idempiere9.adempiere contains 445 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
gl_journalline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
gl_journalline	a_processed	bpchar	1	√		'N'::bpchar	Processed
gl_distribution	anyacct	bpchar	1			'Y'::bpchar	Match any value of the Account segment
gl_distribution	anyactivity	bpchar	1			'Y'::bpchar	Match any value of the Activity segment
gl_distribution	anybpartner	bpchar	1			'Y'::bpchar	Match any value of the Business Partner segment
gl_distribution	anycampaign	bpchar	1			'Y'::bpchar	Match any value of the Campaign segment
gl_distribution	anylocfrom	bpchar	1			'Y'::bpchar	Match any value of the Location From segment
gl_distribution	anylocto	bpchar	1			'Y'::bpchar	Match any value of the Location To segment
gl_distribution	anyorg	bpchar	1			'Y'::bpchar	Match any value of the Organization segment
gl_distribution	anyorgtrx	bpchar	1			'Y'::bpchar	Match any value of the Transaction Organization segment
gl_distribution	anyproduct	bpchar	1			'Y'::bpchar	Match any value of the Product segment
gl_distribution	anyproject	bpchar	1			'Y'::bpchar	Match any value of the Project segment
gl_distribution	anysalesregion	bpchar	1			'Y'::bpchar	Match any value of the Sales Region segment
gl_distribution	anyuser1	bpchar	1			'Y'::bpchar	Match any value of the User 1 segment
gl_distribution	anyuser2	bpchar	1			'Y'::bpchar	Match any value of the User 2 segment
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
gl_journalgeneratorline	bpdimensiontype	bpchar	1	√		NULL::bpchar	Type of BP Dimension
gl_budgetcontrol	budgetcontrolscope	bpchar	1				Scope of the Budget Control
gl_budget	budgetstatus	bpchar	1	√		null	Indicates the current status of this budget
gl_category	categorytype	bpchar	1				Source of the Journal with this category
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
gl_budgetcontrol	commitmenttype	bpchar	1				Create Commitment and/or Reservations for Budget Control
gl_journal	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
gl_journalbatch	copyfrom	bpchar	1	√		null	Copy From Record
c_acctschema	costinglevel	bpchar	1			'C'::bpchar	The lowest level to accumulate Costing Information
c_acctschema	costingmethod	bpchar	1				Indicates how Costs will be calculated
gl_journalgenerator	generategljournal	bpchar	1	√		null	Generate GL Journal
c_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_period	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_validcombination	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_budget	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_budgetcontrol	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_distribution	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_distributionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_fund	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_fundrestriction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journal	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalbatch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalgenerator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalgeneratorline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalgeneratorsource	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
gl_journalline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
gl_journal	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
gl_journalbatch	isapproved	bpchar	1	√		null	Indicates if this document requires approval
gl_budgetcontrol	isbeforeapproval	bpchar	1			'N'::bpchar	The Check is before the (manual) approval
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
gl_journalgeneratorline	iscopyalldimensions	bpchar	1			'N'::bpchar	Copy All Dimensions
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
gl_distribution	iscreatereversal	bpchar	1			'Y'::bpchar	Indicates that reversal movement will be created, if disabled the original movement will be deleted.
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
gl_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
c_validcombination	isfullyqualified	bpchar	1			'Y'::bpchar	This account is fully qualified
gl_journalline	isgenerated	bpchar	1			'N'::bpchar	This Line is generated
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
c_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Pricelist
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
c_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
gl_budget	isprimary	bpchar	1			'Y'::bpchar	Indicates if this is the primary budget
gl_journal	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
gl_journalgeneratorline	issameproduct	bpchar	1			'N'::bpchar	Same Product
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
gl_distribution	isvalid	bpchar	1			'N'::bpchar	Element is valid
gl_distributionline	overwriteacct	bpchar	1			'N'::bpchar	Overwrite the account segment Account with the value specified
gl_distributionline	overwriteactivity	bpchar	1			'N'::bpchar	Overwrite the account segment Activity with the value specified
gl_distributionline	overwritebpartner	bpchar	1			'N'::bpchar	Overwrite the account segment Business Partner with the value specified
gl_distributionline	overwritecampaign	bpchar	1			'N'::bpchar	Overwrite the account segment Campaign with the value specified
gl_distributionline	overwritelocfrom	bpchar	1			'N'::bpchar	Overwrite the account segment Location From with the value specified
gl_distributionline	overwritelocto	bpchar	1			'N'::bpchar	Overwrite the account segment Location From with the value specified
gl_distributionline	overwriteorg	bpchar	1			'N'::bpchar	Overwrite the account segment Organization with the value specified
gl_distributionline	overwriteorgtrx	bpchar	1			'N'::bpchar	Overwrite the account segment Transaction Organization with the value specified
gl_distributionline	overwriteproduct	bpchar	1			'N'::bpchar	Overwrite the account segment Product with the value specified
gl_distributionline	overwriteproject	bpchar	1			'N'::bpchar	Overwrite the account segment Project with the value specified
gl_distributionline	overwritesalesregion	bpchar	1			'N'::bpchar	Overwrite the account segment Sales Region with the value specified
gl_distributionline	overwriteuser1	bpchar	1			'N'::bpchar	Overwrite the account segment User 1 with the value specified
gl_distributionline	overwriteuser2	bpchar	1			'N'::bpchar	Overwrite the account segment User 2 with the value specified
c_period	periodtype	bpchar	1				Period Type
gl_journal	posted	bpchar	1			'N'::bpchar	Posting status
gl_distribution	postingtype	bpchar	1	√		null	The type of posted amount for the transaction
gl_journal	postingtype	bpchar	1				The type of posted amount for the transaction
gl_journalbatch	postingtype	bpchar	1				The type of posted amount for the transaction
gl_journalgenerator	postingtype	bpchar	1	√		'A'::bpchar	The type of posted amount for the transaction
gl_journal	processed	bpchar	1	√		'N'::bpchar	The document has been processed
gl_journalbatch	processed	bpchar	1			'N'::bpchar	The document has been processed
gl_journalline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_acctschema	processing	bpchar	1	√		null	Process Now
c_period	processing	bpchar	1	√		null	Process Now
gl_distribution	processing	bpchar	1	√		null	Process Now
gl_journal	processing	bpchar	1	√		null	Process Now
gl_journalbatch	processing	bpchar	1			'N'::bpchar	Process Now
c_acctschema	separator	bpchar	1				Element Separator
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
gl_journal	docaction	bpchar	2				The targeted status of the document
gl_journalbatch	docaction	bpchar	2				The targeted status of the document
gl_journal	docstatus	bpchar	2				The current status of the document
gl_journalbatch	docstatus	bpchar	2				The current status of the document
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
c_doctype	docbasetype	bpchar	3				Logical type of document
gl_category	docbasetype	bpchar	3	√		null	Logical type of document
gl_fund	amt	numeric	0			0	Amount
gl_journalline	amtacctcr	numeric	0			0	Accounted Credit Amount
gl_journalline	amtacctdr	numeric	0			0	Accounted Debit Amount
gl_journalgeneratorline	amtmultiplier	numeric	0	√		(1)::numeric	Multiplier Amount for generating commissions
gl_journalgeneratorsource	amtmultiplier	numeric	0			(1)::numeric	Multiplier Amount for generating commissions
gl_journalline	amtsourcecr	numeric	0			0	Source Credit Amount
gl_journalline	amtsourcedr	numeric	0			0	Source Debit Amount
gl_journal	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
gl_journalbatch	controlamt	numeric	0	√		0	If not zero, the Debit amount of the document must be equal this amount
gl_journal	currencyrate	numeric	0			0	Currency Conversion Rate
gl_journalline	currencyrate	numeric	0			0	Currency Conversion Rate
gl_distributionline	percent	numeric	0				Percentage
gl_distribution	percenttotal	numeric	0				Sum of the Percent details
gl_journal	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
gl_journalline	qty	numeric	0	√		0	Quantity
gl_journal	totalcr	numeric	0			0	Total Credit in document currency
gl_journalbatch	totalcr	numeric	0			0	Total Credit in document currency
gl_journal	totaldr	numeric	0			0	Total debit in document currency
gl_journalbatch	totaldr	numeric	0			0	Total debit in document currency
gl_journalline	a_asset_group_id	numeric	10	√		null	Group of Assets
gl_journalline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_validcombination	account_id	numeric	10				Account used
gl_distribution	account_id	numeric	10	√		null	Account used
gl_distributionline	account_id	numeric	10	√		null	Account used
gl_journalline	account_id	numeric	10	√		NULL::numeric	Account used
c_acctschema	ad_client_id	numeric	10				Client/Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_period	ad_client_id	numeric	10				Client/Tenant for this installation.
c_validcombination	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_budget	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_budgetcontrol	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_category	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_distribution	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_distributionline	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_fund	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_fundrestriction	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journal	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalbatch	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalgenerator	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalgeneratorline	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalgeneratorsource	ad_client_id	numeric	10				Client/Tenant for this installation.
gl_journalline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_acctschema	ad_org_id	numeric	10				Organizational entity within client
c_doctype	ad_org_id	numeric	10				Organizational entity within client
c_period	ad_org_id	numeric	10				Organizational entity within client
c_validcombination	ad_org_id	numeric	10				Organizational entity within client
gl_budget	ad_org_id	numeric	10				Organizational entity within client
gl_budgetcontrol	ad_org_id	numeric	10				Organizational entity within client
gl_category	ad_org_id	numeric	10				Organizational entity within client
gl_distribution	ad_org_id	numeric	10				Organizational entity within client
gl_distributionline	ad_org_id	numeric	10				Organizational entity within client
gl_fund	ad_org_id	numeric	10				Organizational entity within client
gl_fundrestriction	ad_org_id	numeric	10				Organizational entity within client
gl_journal	ad_org_id	numeric	10				Organizational entity within client
gl_journalbatch	ad_org_id	numeric	10				Organizational entity within client
gl_journalgenerator	ad_org_id	numeric	10				Organizational entity within client
gl_journalgeneratorline	ad_org_id	numeric	10				Organizational entity within client
gl_journalgeneratorsource	ad_org_id	numeric	10				Organizational entity within client
gl_journalline	ad_org_id	numeric	10				Organizational entity within client
c_acctschema	ad_orgonly_id	numeric	10	√		null	Create posting entries only for this organization
c_validcombination	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
gl_distribution	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
gl_distributionline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
gl_journalline	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
gl_journalline	alias_validcombination_id	numeric	10	√		NULL::numeric	Valid Account Alias List
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
c_validcombination	c_acctschema_id	numeric	10				Rules for accounting
gl_budgetcontrol	c_acctschema_id	numeric	10				Rules for accounting
gl_distribution	c_acctschema_id	numeric	10				Rules for accounting
gl_fund	c_acctschema_id	numeric	10				Rules for accounting
gl_journal	c_acctschema_id	numeric	10				Rules for accounting
gl_journalgenerator	c_acctschema_id	numeric	10	√		NULL::numeric	Rules for accounting
c_validcombination	c_activity_id	numeric	10	√		null	Business Activity
gl_distribution	c_activity_id	numeric	10	√		null	Business Activity
gl_distributionline	c_activity_id	numeric	10	√		null	Business Activity
gl_journalline	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_validcombination	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
gl_distribution	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
gl_distributionline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
gl_journalgeneratorline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
gl_journalline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
c_validcombination	c_campaign_id	numeric	10	√		null	Marketing Campaign
gl_distribution	c_campaign_id	numeric	10	√		null	Marketing Campaign
gl_distributionline	c_campaign_id	numeric	10	√		null	Marketing Campaign
gl_journalline	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
gl_journal	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
gl_journalline	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
c_acctschema	c_currency_id	numeric	10				The Currency for this record
gl_journal	c_currency_id	numeric	10	√		null	The Currency for this record
gl_journalbatch	c_currency_id	numeric	10	√		null	The Currency for this record
gl_journalline	c_currency_id	numeric	10				The Currency for this record
c_doctype	c_doctype_id	numeric	10				Document type or rules
gl_distribution	c_doctype_id	numeric	10	√		null	Document type or rules
gl_journal	c_doctype_id	numeric	10				Document type or rules
gl_journalbatch	c_doctype_id	numeric	10				Document type or rules
gl_journalgenerator	c_doctype_id	numeric	10	√		NULL::numeric	Document type or rules
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
gl_fundrestriction	c_elementvalue_id	numeric	10				Account Element
gl_journalgeneratorsource	c_elementvalue_id	numeric	10				Account Element
gl_journalgenerator	c_elementvalueadjustcr_id	numeric	10	√		NULL::numeric	Account Adjust CR
gl_journalgenerator	c_elementvalueadjustdr_id	numeric	10	√		NULL::numeric	Account Adjust DR
gl_journalgeneratorline	c_elementvaluecr_id	numeric	10	√		NULL::numeric	Account CR
gl_journalgeneratorline	c_elementvaluedr_id	numeric	10	√		NULL::numeric	Account DR
c_validcombination	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
gl_distribution	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
gl_distributionline	c_locfrom_id	numeric	10	√		null	Location that inventory was moved from
gl_journalline	c_locfrom_id	numeric	10	√		NULL::numeric	Location that inventory was moved from
c_validcombination	c_locto_id	numeric	10	√		null	Location that inventory was moved to
gl_distribution	c_locto_id	numeric	10	√		null	Location that inventory was moved to
gl_distributionline	c_locto_id	numeric	10	√		null	Location that inventory was moved to
gl_journalline	c_locto_id	numeric	10	√		NULL::numeric	Location that inventory was moved to
c_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
c_period	c_period_id	numeric	10				Period of the Calendar
gl_journal	c_period_id	numeric	10				Period of the Calendar
gl_journalbatch	c_period_id	numeric	10	√		null	Period of the Calendar
c_validcombination	c_project_id	numeric	10	√		null	Financial Project
gl_distribution	c_project_id	numeric	10	√		null	Financial Project
gl_distributionline	c_project_id	numeric	10	√		null	Financial Project
gl_journalline	c_project_id	numeric	10	√		NULL::numeric	Financial Project
c_validcombination	c_salesregion_id	numeric	10	√		null	Sales coverage region
gl_distribution	c_salesregion_id	numeric	10	√		null	Sales coverage region
gl_distributionline	c_salesregion_id	numeric	10	√		null	Sales coverage region
gl_journalline	c_salesregion_id	numeric	10	√		NULL::numeric	Sales coverage region
c_validcombination	c_subacct_id	numeric	10	√		null	Sub account for Element Value
gl_journalline	c_subacct_id	numeric	10	√		NULL::numeric	Sub account for Element Value
gl_journalline	c_uom_id	numeric	10	√		null	Unit of Measure
c_validcombination	c_validcombination_id	numeric	10				Valid Account Combination
gl_journalline	c_validcombination_id	numeric	10	√		null	Valid Account Combination
c_period	c_year_id	numeric	10				Calendar Year
c_acctschema	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_period	createdby	numeric	10				User who created this records
c_validcombination	createdby	numeric	10				User who created this records
gl_budget	createdby	numeric	10				User who created this records
gl_budgetcontrol	createdby	numeric	10				User who created this records
gl_category	createdby	numeric	10				User who created this records
gl_distribution	createdby	numeric	10				User who created this records
gl_distributionline	createdby	numeric	10				User who created this records
gl_fund	createdby	numeric	10				User who created this records
gl_fundrestriction	createdby	numeric	10				User who created this records
gl_journal	createdby	numeric	10				User who created this records
gl_journalbatch	createdby	numeric	10				User who created this records
gl_journalgenerator	createdby	numeric	10				User who created this records
gl_journalgeneratorline	createdby	numeric	10				User who created this records
gl_journalgeneratorsource	createdby	numeric	10				User who created this records
gl_journalline	createdby	numeric	10				User who created this records
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
c_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	documentcopies	numeric	10				Number of copies to be printed
gl_budget	gl_budget_id	numeric	10				General Ledger Budget
gl_budgetcontrol	gl_budget_id	numeric	10				General Ledger Budget
gl_journal	gl_budget_id	numeric	10	√		null	General Ledger Budget
gl_budgetcontrol	gl_budgetcontrol_id	numeric	10				Budget Control
c_doctype	gl_category_id	numeric	10				General Ledger Category
gl_category	gl_category_id	numeric	10				General Ledger Category
gl_journal	gl_category_id	numeric	10				General Ledger Category
gl_journalbatch	gl_category_id	numeric	10	√		null	General Ledger Category
gl_journalgenerator	gl_category_id	numeric	10	√		NULL::numeric	General Ledger Category
gl_journalgeneratorsource	gl_category_id	numeric	10	√		NULL::numeric	General Ledger Category
gl_distribution	gl_distribution_id	numeric	10				General Ledger Distribution
gl_distributionline	gl_distribution_id	numeric	10				General Ledger Distribution
gl_distributionline	gl_distributionline_id	numeric	10				General Ledger Distribution Line
gl_fund	gl_fund_id	numeric	10				General Ledger Funds Control
gl_fundrestriction	gl_fund_id	numeric	10				General Ledger Funds Control
gl_fundrestriction	gl_fundrestriction_id	numeric	10				Restriction of Funds
gl_journal	gl_journal_id	numeric	10				General Ledger Journal
gl_journalline	gl_journal_id	numeric	10				General Ledger Journal
gl_journal	gl_journalbatch_id	numeric	10	√		null	General Ledger Journal Batch
gl_journalbatch	gl_journalbatch_id	numeric	10				General Ledger Journal Batch
gl_journalgenerator	gl_journalgenerator_id	numeric	10				GL Journal Generator
gl_journalgeneratorline	gl_journalgenerator_id	numeric	10				GL Journal Generator
gl_journalgeneratorline	gl_journalgeneratorline_id	numeric	10				Generator Line
gl_journalgeneratorsource	gl_journalgeneratorline_id	numeric	10				Generator Line
gl_journalgeneratorsource	gl_journalgeneratorsource_id	numeric	10				Generator Source
gl_journalline	gl_journalline_id	numeric	10				General Ledger Journal Line
gl_distributionline	line	numeric	10			0	Unique line for this document
gl_journalline	line	numeric	10				Unique line for this document
c_acctschema	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
c_validcombination	m_product_id	numeric	10	√		null	Product, Service, Item
gl_distribution	m_product_id	numeric	10	√		null	Product, Service, Item
gl_distributionline	m_product_id	numeric	10	√		null	Product, Service, Item
gl_journalline	m_product_id	numeric	10	√		NULL::numeric	Product, Service, Item
gl_distribution	org_id	numeric	10	√		null	Organizational entity within client
gl_distributionline	org_id	numeric	10	√		null	Organizational entity within client
c_acctschema	period_openfuture	numeric	10	√		null	Number of days to be able to post to a future date (based on system date)
c_acctschema	period_openhistory	numeric	10	√		null	Number of days to be able to post in the past (based on system date)
c_period	periodno	numeric	10				Unique Period Number
gl_journal	reversal_id	numeric	10	√		null	ID of document reversal
gl_journalbatch	reversal_id	numeric	10	√		null	ID of document reversal
gl_journalgeneratorline	roundfactor	numeric	10	√		(0)::numeric	Round Factor
gl_journalgeneratorsource	roundfactor	numeric	10	√		NULL::numeric	Round Factor
gl_distribution	seqno	numeric	10			'0'::numeric	Method of ordering records; lowest number comes first
gl_journalgeneratorline	seqno	numeric	10				Method of ordering records; lowest number comes first
c_acctschema	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_period	updatedby	numeric	10				User who updated this records
c_validcombination	updatedby	numeric	10				User who updated this records
gl_budget	updatedby	numeric	10				User who updated this records
gl_budgetcontrol	updatedby	numeric	10				User who updated this records
gl_category	updatedby	numeric	10				User who updated this records
gl_distribution	updatedby	numeric	10				User who updated this records
gl_distributionline	updatedby	numeric	10				User who updated this records
gl_fund	updatedby	numeric	10				User who updated this records
gl_fundrestriction	updatedby	numeric	10				User who updated this records
gl_journal	updatedby	numeric	10				User who updated this records
gl_journalbatch	updatedby	numeric	10				User who updated this records
gl_journalgenerator	updatedby	numeric	10				User who updated this records
gl_journalgeneratorline	updatedby	numeric	10				User who updated this records
gl_journalgeneratorsource	updatedby	numeric	10				User who updated this records
gl_journalline	updatedby	numeric	10				User who updated this records
c_validcombination	user1_id	numeric	10	√		null	User defined list element #1
gl_distribution	user1_id	numeric	10	√		null	User defined list element #1
gl_distributionline	user1_id	numeric	10	√		null	User defined list element #1
gl_journalline	user1_id	numeric	10	√		NULL::numeric	User defined list element #1
c_validcombination	user2_id	numeric	10	√		null	User defined list element #2
gl_distribution	user2_id	numeric	10	√		null	User defined list element #2
gl_distributionline	user2_id	numeric	10	√		null	User defined list element #2
gl_journalline	user2_id	numeric	10	√		NULL::numeric	User defined list element #2
c_validcombination	userelement1_id	numeric	10	√		null	User defined accounting Element
c_validcombination	userelement2_id	numeric	10	√		null	User defined accounting Element
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_period	created	timestamp	29,6			now()	Date this record was created
c_validcombination	created	timestamp	29,6			now()	Date this record was created
gl_budget	created	timestamp	29,6			now()	Date this record was created
gl_budgetcontrol	created	timestamp	29,6			now()	Date this record was created
gl_category	created	timestamp	29,6			now()	Date this record was created
gl_distribution	created	timestamp	29,6			now()	Date this record was created
gl_distributionline	created	timestamp	29,6			now()	Date this record was created
gl_fund	created	timestamp	29,6			now()	Date this record was created
gl_fundrestriction	created	timestamp	29,6			now()	Date this record was created
gl_journal	created	timestamp	29,6			now()	Date this record was created
gl_journalbatch	created	timestamp	29,6			now()	Date this record was created
gl_journalgenerator	created	timestamp	29,6			statement_timestamp()	Date this record was created
gl_journalgeneratorline	created	timestamp	29,6			statement_timestamp()	Date this record was created
gl_journalgeneratorsource	created	timestamp	29,6			statement_timestamp()	Date this record was created
gl_journalline	created	timestamp	29,6			now()	Date this record was created
gl_journal	dateacct	timestamp	29,6				Accounting Date
gl_journalbatch	dateacct	timestamp	29,6	√		null	Accounting Date
gl_journalline	dateacct	timestamp	29,6				Accounting Date
gl_journal	datedoc	timestamp	29,6				Date of the Document
gl_journalbatch	datedoc	timestamp	29,6	√		null	Date of the Document
gl_fund	datefrom	timestamp	29,6	√		null	Starting date for a range
gl_fund	dateto	timestamp	29,6	√		null	End date of a date range
c_period	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_period	startdate	timestamp	29,6				First effective day (inclusive)
c_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_period	updated	timestamp	29,6			now()	Date this record was updated
c_validcombination	updated	timestamp	29,6			now()	Date this record was updated
gl_budget	updated	timestamp	29,6			now()	Date this record was updated
gl_budgetcontrol	updated	timestamp	29,6			now()	Date this record was updated
gl_category	updated	timestamp	29,6			now()	Date this record was updated
gl_distribution	updated	timestamp	29,6			now()	Date this record was updated
gl_distributionline	updated	timestamp	29,6			now()	Date this record was updated
gl_fund	updated	timestamp	29,6			now()	Date this record was updated
gl_fundrestriction	updated	timestamp	29,6			now()	Date this record was updated
gl_journal	updated	timestamp	29,6			now()	Date this record was updated
gl_journalbatch	updated	timestamp	29,6			now()	Date this record was updated
gl_journalgenerator	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
gl_journalgeneratorline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
gl_journalgeneratorsource	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
gl_journalline	updated	timestamp	29,6			now()	Date this record was updated
gl_distribution	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
gl_distribution	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
gl_journal	documentno	varchar	30				Document sequence number of the document
gl_journalbatch	documentno	varchar	30				Document sequence number of the document
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_period	c_period_uu	varchar	36	√		NULL::character varying	C_Period_UU
c_validcombination	c_validcombination_uu	varchar	36	√		NULL::character varying	C_ValidCombination_UU
gl_budget	gl_budget_uu	varchar	36	√		NULL::character varying	GL_Budget_UU
gl_budgetcontrol	gl_budgetcontrol_uu	varchar	36	√		NULL::character varying	GL_BudgetControl_UU
gl_category	gl_category_uu	varchar	36	√		NULL::character varying	GL_Category_UU
gl_distribution	gl_distribution_uu	varchar	36	√		NULL::character varying	GL_Distribution_UU
gl_distributionline	gl_distributionline_uu	varchar	36	√		NULL::character varying	GL_DistributionLine_UU
gl_fund	gl_fund_uu	varchar	36	√		NULL::character varying	GL_Fund_UU
gl_fundrestriction	gl_fundrestriction_uu	varchar	36	√		NULL::character varying	GL_FundRestriction_UU
gl_journal	gl_journal_uu	varchar	36	√		NULL::character varying	GL_Journal_UU
gl_journalbatch	gl_journalbatch_uu	varchar	36	√		NULL::character varying	GL_JournalBatch_UU
gl_journalgenerator	gl_journalgenerator_uu	varchar	36	√		NULL::character varying	GL_JournalGenerator_UU
gl_journalgeneratorline	gl_journalgeneratorline_uu	varchar	36	√		NULL::character varying	GL_JournalGeneratorLine_UU
gl_journalgeneratorsource	gl_journalgeneratorsource_uu	varchar	36	√		NULL::character varying	GL_JournalGeneratorSource_UU
gl_journalline	gl_journalline_uu	varchar	36	√		NULL::character varying	GL_JournalLine_UU
c_validcombination	alias	varchar	40	√		null	Defines an alternate method of indicating an account combination.
c_validcombination	combination	varchar	60	√		null	Unique combination of account elements
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_period	name	varchar	60				Alphanumeric identifier of the entity
gl_budget	name	varchar	60				Alphanumeric identifier of the entity
gl_budgetcontrol	name	varchar	60				Alphanumeric identifier of the entity
gl_category	name	varchar	60				Alphanumeric identifier of the entity
gl_distribution	name	varchar	60				Alphanumeric identifier of the entity
gl_fund	name	varchar	60				Alphanumeric identifier of the entity
gl_fundrestriction	name	varchar	60				Alphanumeric identifier of the entity
gl_journalgenerator	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
gl_journalgeneratorline	bpcolumn	varchar	100	√		NULL::character varying	BP Column
c_acctschema	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_validcombination	description	varchar	255	√		null	Optional short description of the record
gl_budget	description	varchar	255	√		null	Optional short description of the record
gl_budgetcontrol	description	varchar	255	√		null	Optional short description of the record
gl_category	description	varchar	255	√		null	Optional short description of the record
gl_distribution	description	varchar	255	√		null	Optional short description of the record
gl_distributionline	description	varchar	255	√		null	Optional short description of the record
gl_fund	description	varchar	255	√		null	Optional short description of the record
gl_fundrestriction	description	varchar	255	√		null	Optional short description of the record
gl_journal	description	varchar	255				Optional short description of the record
gl_journalbatch	description	varchar	255				Optional short description of the record
gl_journalgenerator	description	varchar	255	√		NULL::character varying	Optional short description of the record
gl_journalgeneratorline	description	varchar	255	√		NULL::character varying	Optional short description of the record
gl_journalline	description	varchar	255	√		null	Optional short description of the record
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
gl_budgetcontrol	help	varchar	2000	√		null	Comment or Hint
gl_distribution	help	varchar	2000	√		null	Comment or Hint
gl_fund	help	varchar	2000	√		null	Comment or Hint
gl_journalgenerator	help	varchar	2000	√		NULL::character varying	Comment or Hint
gl_journalgeneratorline	help	varchar	2000	√		NULL::character varying	Comment or Hint
gl_journalgeneratorsource	help	varchar	2000	√		NULL::character varying	Comment or Hint