idempiere11.adempiere contains 545 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
c_bpartner	ad_client_id	numeric	10				Tenant for this installation.
c_invoiceline	ad_client_id	numeric	10				Tenant for this installation.
c_nonbusinessday	ad_client_id	numeric	10				Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Tenant for this installation.
c_servicelevel	ad_client_id	numeric	10				Tenant for this installation.
c_servicelevelline	ad_client_id	numeric	10				Tenant for this installation.
c_taxcategory	ad_client_id	numeric	10				Tenant for this installation.
c_uom	ad_client_id	numeric	10				Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Tenant for this installation.
m_product	ad_client_id	numeric	10				Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Tenant for this installation.
s_expensetype	ad_client_id	numeric	10				Tenant for this installation.
s_resource	ad_client_id	numeric	10				Tenant for this installation.
s_resourceassignment	ad_client_id	numeric	10				Tenant for this installation.
s_resourcetype	ad_client_id	numeric	10				Tenant for this installation.
s_resourceunavailable	ad_client_id	numeric	10				Tenant for this installation.
s_timeexpense	ad_client_id	numeric	10				Tenant for this installation.
s_timeexpenseline	ad_client_id	numeric	10				Tenant for this installation.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	ad_org_id	numeric	10				Organizational entity within tenant
c_invoiceline	ad_org_id	numeric	10				Organizational entity within tenant
c_nonbusinessday	ad_org_id	numeric	10				Organizational entity within tenant
c_orderline	ad_org_id	numeric	10				Organizational entity within tenant
c_servicelevel	ad_org_id	numeric	10				Organizational entity within tenant
c_servicelevelline	ad_org_id	numeric	10				Organizational entity within tenant
c_taxcategory	ad_org_id	numeric	10				Organizational entity within tenant
c_uom	ad_org_id	numeric	10				Organizational entity within tenant
m_pricelist	ad_org_id	numeric	10				Organizational entity within tenant
m_product	ad_org_id	numeric	10				Organizational entity within tenant
m_product_category	ad_org_id	numeric	10				Organizational entity within tenant
m_warehouse	ad_org_id	numeric	10				Organizational entity within tenant
s_expensetype	ad_org_id	numeric	10				Organizational entity within tenant
s_resource	ad_org_id	numeric	10				Organizational entity within tenant
s_resourceassignment	ad_org_id	numeric	10				Organizational entity within tenant
s_resourcetype	ad_org_id	numeric	10				Organizational entity within tenant
s_resourceunavailable	ad_org_id	numeric	10				Organizational entity within tenant
s_timeexpense	ad_org_id	numeric	10				Organizational entity within tenant
s_timeexpenseline	ad_org_id	numeric	10				Organizational entity within tenant
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_invoiceline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_orderline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
s_resource	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
s_resourcetype	allowuomfractions	bpchar	1			'N'::bpchar	Allow Unit of Measure Fractions
s_timeexpense	approvalamt	numeric	0	√		null	Document Approval Amount
s_resourceassignment	assigndatefrom	timestamp	29,6				Assign resource from
s_resourceassignment	assigndateto	timestamp	29,6	√		null	Assign resource until
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_activity_id	numeric	10	√		null	Business Activity
s_timeexpenseline	c_activity_id	numeric	10	√		null	Business Activity
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
s_timeexpense	c_bpartner_id	numeric	10				Identifies a Business Partner
s_timeexpenseline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_orderline	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_nonbusinessday	c_calendar_id	numeric	10				Accounting Calendar Name
c_invoiceline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_orderline	c_campaign_id	numeric	10	√		null	Marketing Campaign
s_timeexpenseline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	Additional document charges
c_nonbusinessday	c_country_id	numeric	10	√		NULL::numeric	Country
c_orderline	c_currency_id	numeric	10				The Currency for this record
m_pricelist	c_currency_id	numeric	10				The Currency for this record
s_timeexpenseline	c_currency_id	numeric	10	√		null	The Currency for this record
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
s_timeexpenseline	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
m_warehouse	c_location_id	numeric	10				Location or Address
c_nonbusinessday	c_nonbusinessday_id	numeric	10				Day on which business is not transacted
c_nonbusinessday	c_nonbusinessday_uu	varchar	36	√		NULL::character varying	C_NonBusinessDay_UU
c_orderline	c_order_id	numeric	10				Order
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_id	numeric	10				Sales Order Line
s_timeexpenseline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_project_id	numeric	10	√		null	Financial Project
s_timeexpenseline	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
s_timeexpenseline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
s_timeexpenseline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
c_servicelevel	c_revenuerecognition_plan_id	numeric	10				Plan for recognizing or recording revenue
c_servicelevel	c_servicelevel_id	numeric	10				Product Revenue Recognition Service Level
c_servicelevelline	c_servicelevel_id	numeric	10				Product Revenue Recognition Service Level
c_servicelevel	c_servicelevel_uu	varchar	36	√		NULL::character varying	C_ServiceLevel_UU
c_servicelevelline	c_servicelevelline_id	numeric	10				Product Revenue Recognition Service Level Line
c_servicelevelline	c_servicelevelline_uu	varchar	36	√		NULL::character varying	C_ServiceLevelLine_UU
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_orderline	c_tax_id	numeric	10				Tax identifier
c_taxcategory	c_taxcategory_id	numeric	10				Tax Category
m_product	c_taxcategory_id	numeric	10				Tax Category
s_expensetype	c_taxcategory_id	numeric	10				Tax Category
s_resourcetype	c_taxcategory_id	numeric	10				Tax Category
c_taxcategory	c_taxcategory_uu	varchar	36	√		NULL::character varying	C_TaxCategory_UU
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
c_orderline	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
s_expensetype	c_uom_id	numeric	10				Unit of Measure
s_resourcetype	c_uom_id	numeric	10				Unit of Measure
s_timeexpenseline	c_uom_id	numeric	10	√		null	Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
s_resource	chargeableqty	numeric	0	√		0	Chargeable Quantity
s_resourcetype	chargeableqty	numeric	0	√		0	Chargeable Quantity
m_product	classification	varchar	12	√		null	Classification for grouping
c_taxcategory	commoditycode	varchar	20	√		null	Commodity code used for tax calculation
s_timeexpenseline	convertedamt	numeric	0	√		0	Converted Amount
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_uom	costingprecision	numeric	10				Rounding used costing calculations
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	created	timestamp	29,6			now()	Date this record was created
c_nonbusinessday	created	timestamp	29,6			now()	Date this record was created
c_orderline	created	timestamp	29,6			now()	Date this record was created
c_servicelevel	created	timestamp	29,6			now()	Date this record was created
c_servicelevelline	created	timestamp	29,6			now()	Date this record was created
c_taxcategory	created	timestamp	29,6			now()	Date this record was created
c_uom	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
s_expensetype	created	timestamp	29,6			now()	Date this record was created
s_resource	created	timestamp	29,6			now()	Date this record was created
s_resourceassignment	created	timestamp	29,6			now()	Date this record was created
s_resourcetype	created	timestamp	29,6			now()	Date this record was created
s_resourceunavailable	created	timestamp	29,6			now()	Date this record was created
s_timeexpense	created	timestamp	29,6			now()	Date this record was created
s_timeexpenseline	created	timestamp	29,6			now()	Date this record was created
c_bpartner	createdby	numeric	10				User who created this records
c_invoiceline	createdby	numeric	10				User who created this records
c_nonbusinessday	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_servicelevel	createdby	numeric	10				User who created this records
c_servicelevelline	createdby	numeric	10				User who created this records
c_taxcategory	createdby	numeric	10				User who created this records
c_uom	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
s_expensetype	createdby	numeric	10				User who created this records
s_resource	createdby	numeric	10				User who created this records
s_resourceassignment	createdby	numeric	10				User who created this records
s_resourcetype	createdby	numeric	10				User who created this records
s_resourceunavailable	createdby	numeric	10				User who created this records
s_timeexpense	createdby	numeric	10				User who created this records
s_timeexpenseline	createdby	numeric	10				User who created this records
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
s_resource	dailycapacity	numeric	0	√		null	Daily Capacity
c_nonbusinessday	date1	timestamp	29,6				Date when business is not conducted
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
s_timeexpenseline	dateexpense	timestamp	29,6	√		null	Date of expense
s_resourceunavailable	datefrom	timestamp	29,6				Starting date for a range
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
c_orderline	dateordered	timestamp	29,6				Date of Order
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
s_timeexpense	datereport	timestamp	29,6				Expense/Time Report Date
s_resourceunavailable	dateto	timestamp	29,6	√		null	End date of a date range
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_invoiceline	description	varchar	255	√		null	Optional short description of the record
c_orderline	description	varchar	255	√		null	Optional short description of the record
c_servicelevel	description	varchar	255	√		null	Optional short description of the record
c_servicelevelline	description	varchar	255	√		null	Optional short description of the record
c_taxcategory	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_warehouse	description	varchar	255	√		null	Optional short description of the record
s_expensetype	description	varchar	255	√		null	Optional short description of the record
s_resource	description	varchar	255	√		null	Optional short description of the record
s_resourceassignment	description	varchar	255	√		null	Optional short description of the record
s_resourcetype	description	varchar	255	√		null	Optional short description of the record
s_resourceunavailable	description	varchar	255	√		null	Optional short description of the record
s_timeexpense	description	varchar	255	√		null	Optional short description of the record
s_timeexpenseline	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
c_orderline	discount	numeric	0	√		null	Discount in percent
s_timeexpense	docaction	bpchar	2				The targeted status of the document
s_timeexpense	docstatus	bpchar	2				The current status of the document
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
s_timeexpense	documentno	varchar	30				Document sequence number of the document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
s_timeexpenseline	expenseamt	numeric	0	√		0	Amount for this expense
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_orderline	freightamt	numeric	0			0	Freight Amount
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
m_product	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
s_timeexpenseline	invoiceprice	numeric	0	√		0	Unit price to be invoiced or 0 for default price
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoiceline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_nonbusinessday	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orderline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_servicelevel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_servicelevelline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_taxcategory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_warehouse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_expensetype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_resource	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_resourceassignment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_resourcetype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_resourceunavailable	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_timeexpense	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_timeexpenseline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_timeexpense	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
s_resource	isavailable	bpchar	1			'Y'::bpchar	Resource is available
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
s_resourceassignment	isconfirmed	bpchar	1			'N'::bpchar	Assignment is confirmed
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
s_resourcetype	isdateslot	bpchar	1			'N'::bpchar	Resource has day slot availability
c_taxcategory	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_orderline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	Is Fixed Asset Invoice
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
s_expensetype	isinvoiced	bpchar	1			'Y'::bpchar	Is this invoiced?
s_timeexpenseline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
s_resource	ismanufacturingresource	bpchar	1	√		'N'::bpchar	Manufacturing Resource
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	Is Present For Product
c_invoiceline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
s_resourcetype	issingleassignment	bpchar	1			'N'::bpchar	Only one assignment at a time (no double-booking or overlapping)
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
s_timeexpenseline	istimereport	bpchar	1			'N'::bpchar	Line is a time report only (no expense)
s_resourcetype	istimeslot	bpchar	1			'N'::bpchar	Resource has time slot availability
m_product	istoformule	bpchar	1	√		null
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
s_timeexpenseline	line	numeric	10				Unique line for this document
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
c_orderline	link_orderline_id	numeric	10	√		null	This field links a sales order line to the purchase order line that is generated from it.
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
s_timeexpense	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
s_expensetype	m_product_category_id	numeric	10				Category of a Product
s_resourcetype	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_servicelevel	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
s_timeexpenseline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
c_invoiceline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
c_orderline	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
s_resource	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
s_timeexpense	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
s_resource	manufacturingresourcetype	bpchar	2	√		null	Manufacturing Resource Type
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_nonbusinessday	name	varchar	60	√		null	Alphanumeric identifier of the entity
c_taxcategory	name	varchar	60				Alphanumeric identifier of the entity
c_uom	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
s_expensetype	name	varchar	60				Alphanumeric identifier of the entity
s_resource	name	varchar	60				Alphanumeric identifier of the entity
s_resourceassignment	name	varchar	60				Alphanumeric identifier of the entity
s_resourcetype	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
s_timeexpenseline	note	varchar	255	√		null	Optional additional user defined information
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
s_resourcetype	onfriday	bpchar	1			'Y'::bpchar	Available on Fridays
s_resourcetype	onmonday	bpchar	1			'Y'::bpchar	Available on Mondays
s_resourcetype	onsaturday	bpchar	1			'N'::bpchar	Available on Saturday
s_resourcetype	onsunday	bpchar	1			'N'::bpchar	Available on Sundays
s_resourcetype	onthursday	bpchar	1			'Y'::bpchar	Available on Thursdays
s_resourcetype	ontuesday	bpchar	1			'Y'::bpchar	Available on Tuesdays
s_resourcetype	onwednesday	bpchar	1			'Y'::bpchar	Available on Wednesdays
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
s_resource	percentutilization	numeric	0			(100)::numeric	% Utilization
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
s_resource	planninghorizon	numeric	10	√		(0)::numeric	The planning horizon is the amount of time (Days) an organisation will look into the future when preparing a strategic plan.
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
s_timeexpenseline	priceentered	numeric	0	√		'0'::numeric	Price Entered - the price based on the selected/base UoM
s_timeexpenseline	priceinvoiced	numeric	0	√		null	The priced invoiced to the customer (in the currency of the customer's AR price list) - 0 for default price
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
c_orderline	pricelist	numeric	0			0	List Price
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
s_timeexpenseline	pricereimbursed	numeric	0	√		null	The reimbursed price (in currency of the employee's AP price list)
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_servicelevel	processed	bpchar	1	√		'N'::bpchar	The document has been processed
c_servicelevelline	processed	bpchar	1	√		'N'::bpchar	The document has been processed
s_timeexpense	processed	bpchar	1			'N'::bpchar	The document has been processed
s_timeexpenseline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_servicelevel	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
s_timeexpense	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
s_resourceassignment	qty	numeric	0	√		0	Quantity
s_timeexpenseline	qty	numeric	0	√		0	Quantity
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_invoiceline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtyinvoiced	numeric	0			0	Invoiced Quantity
s_timeexpenseline	qtyinvoiced	numeric	0	√		null	Invoiced Quantity
c_orderline	qtylostsales	numeric	0			0	Quantity of potential sales
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
s_timeexpenseline	qtyreimbursed	numeric	0	√		null	The reimbursed quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
s_resource	queuingtime	numeric	0	√		null	Queue time is the time a job waits at a work center before begin handled.
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
c_orderline	ref_orderline_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
s_expensetype	s_expensetype_id	numeric	10				Expense report type
s_expensetype	s_expensetype_uu	varchar	36	√		NULL::character varying	S_ExpenseType_UU
m_product	s_resource_id	numeric	10	√		null	Resource
s_resource	s_resource_id	numeric	10				Resource
s_resourceassignment	s_resource_id	numeric	10				Resource
s_resourceunavailable	s_resource_id	numeric	10				Resource
s_resource	s_resource_uu	varchar	36	√		NULL::character varying	S_Resource_UU
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
s_resourceassignment	s_resourceassignment_id	numeric	10				Resource Assignment
s_timeexpenseline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
s_resourceassignment	s_resourceassignment_uu	varchar	36	√		NULL::character varying	S_ResourceAssignment_UU
s_resource	s_resourcetype_id	numeric	10				Resource Type
s_resourcetype	s_resourcetype_id	numeric	10				Resource Type
s_resourcetype	s_resourcetype_uu	varchar	36	√		NULL::character varying	S_ResourceType_UU
s_resourceunavailable	s_resourceunavailable_id	numeric	10				Resource Unavailability
s_resourceunavailable	s_resourceunavailable_uu	varchar	36	√		NULL::character varying	S_ResourceUnAvailable_UU
s_timeexpense	s_timeexpense_id	numeric	10				Time and Expense Report
s_timeexpenseline	s_timeexpense_id	numeric	10				Time and Expense Report
s_timeexpense	s_timeexpense_uu	varchar	36	√		NULL::character varying	S_TimeExpense_UU
s_timeexpenseline	s_timeexpenseline_id	numeric	10				Time and Expense Report Line
s_timeexpenseline	s_timeexpenseline_uu	varchar	36	√		NULL::character varying	S_TimeExpenseLine_UU
s_timeexpenseline	s_timetype_id	numeric	10	√		null	Type of time recorded
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_warehouse	separator	bpchar	1				Element Separator
c_servicelevelline	servicedate	timestamp	29,6				Date service was provided
c_servicelevel	servicelevelinvoiced	numeric	0				Quantity of product or service invoiced
c_servicelevel	servicelevelprovided	numeric	0				Quantity of service or product provided
c_servicelevelline	servicelevelprovided	numeric	0				Quantity of service or product provided
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_bpartner	taxid	varchar	20	√		null	Tax Identification
s_resourcetype	timeslotend	timestamp	29,6	√		null	Time when timeslot ends
s_resourcetype	timeslotstart	timestamp	29,6	√		null	Time when timeslot starts
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	updated	timestamp	29,6			now()	Date this record was updated
c_nonbusinessday	updated	timestamp	29,6			now()	Date this record was updated
c_orderline	updated	timestamp	29,6			now()	Date this record was updated
c_servicelevel	updated	timestamp	29,6			now()	Date this record was updated
c_servicelevelline	updated	timestamp	29,6			now()	Date this record was updated
c_taxcategory	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
s_expensetype	updated	timestamp	29,6			now()	Date this record was updated
s_resource	updated	timestamp	29,6			now()	Date this record was updated
s_resourceassignment	updated	timestamp	29,6			now()	Date this record was updated
s_resourcetype	updated	timestamp	29,6			now()	Date this record was updated
s_resourceunavailable	updated	timestamp	29,6			now()	Date this record was updated
s_timeexpense	updated	timestamp	29,6			now()	Date this record was updated
s_timeexpenseline	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updatedby	numeric	10				User who updated this records
c_invoiceline	updatedby	numeric	10				User who updated this records
c_nonbusinessday	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_servicelevel	updatedby	numeric	10				User who updated this records
c_servicelevelline	updatedby	numeric	10				User who updated this records
c_taxcategory	updatedby	numeric	10				User who updated this records
c_uom	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
s_expensetype	updatedby	numeric	10				User who updated this records
s_resource	updatedby	numeric	10				User who updated this records
s_resourceassignment	updatedby	numeric	10				User who updated this records
s_resourcetype	updatedby	numeric	10				User who updated this records
s_resourceunavailable	updatedby	numeric	10				User who updated this records
s_timeexpense	updatedby	numeric	10				User who updated this records
s_timeexpenseline	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_invoiceline	user1_id	numeric	10	√		null	User defined list element #1
c_orderline	user1_id	numeric	10	√		null	User defined list element #1
c_invoiceline	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	510				Search key for the record in the format required - must be unique
m_product_category	value	varchar	40				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
s_expensetype	value	varchar	40				Search key for the record in the format required - must be unique
s_resource	value	varchar	40				Search key for the record in the format required - must be unique
s_resourcetype	value	varchar	40				Search key for the record in the format required - must be unique
m_product	versionno	varchar	20	√		null	Version Number
m_product	volume	numeric	0	√		0	Volume of a product
s_resource	waitingtime	numeric	0	√		null	Workflow Simulation Waiting time
m_product	weight	numeric	0	√		0	Weight of a product
c_uom	x12de355	varchar	4				UOM EDI X12 Code