SchemaSpy Analysis of idempiere9.adempiere - ColumnsGeneral Ledger Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:48 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 445 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
gl_distribution seqno numeric 10 '0'::numeric Method of ordering records; lowest number comes first
gl_journalgenerator postingtype bpchar 1  √  'A'::bpchar The type of posted amount for the transaction
c_acctschema costinglevel bpchar 1 'C'::bpchar The lowest level to accumulate Costing Information
gl_journalline a_createasset bpchar 1  √  'N'::bpchar Create Asset
gl_journalline a_processed bpchar 1  √  'N'::bpchar Processed
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
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
gl_journal processed bpchar 1  √  'N'::bpchar The document has been processed
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
gl_journal isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
gl_budgetcontrol isbeforeapproval bpchar 1 'N'::bpchar The Check is before the (manual) approval
gl_journalgeneratorline iscopyalldimensions bpchar 1 'N'::bpchar Copy All Dimensions
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
gl_journalline isgenerated bpchar 1 'N'::bpchar This Line is generated
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_acctschema ispostservices bpchar 1 'N'::bpchar Differentiate between Services and Product Receivable/Payables
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 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
gl_journal posted bpchar 1 'N'::bpchar Posting status
gl_journalbatch processed bpchar 1 'N'::bpchar The document has been processed
gl_journalline processed bpchar 1 'N'::bpchar The document has been processed
gl_journalbatch processing bpchar 1 'N'::bpchar Process Now
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
c_acctschema ispostifclearingequal bpchar 1  √  'Y'::bpchar This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
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 hasalias bpchar 1 'Y'::bpchar Ability to select (partial) account combinations by an Alias
c_acctschema hascombination bpchar 1 'Y'::bpchar Combination of account elements are checked
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_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_validcombination isfullyqualified bpchar 1 'Y'::bpchar This account is fully qualified
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
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
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
gl_journalgeneratorline roundfactor numeric 10  √  (0)::numeric Round Factor
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_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_journalline qty numeric 0  √  0 Quantity
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_journalline amtsourcecr numeric 0 0 Source Credit Amount
gl_journalline amtsourcedr numeric 0 0 Source Debit Amount
gl_journal currencyrate numeric 0 0 Currency Conversion Rate
gl_journalline currencyrate numeric 0 0 Currency Conversion Rate
gl_distributionline line numeric 10 0 Unique line for this document
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
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_journalline created timestamp 29,6 now() Date this record was created
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_journalline updated timestamp 29,6 now() Date this record was updated
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
gl_distribution account_id numeric 10  √  null Account used
gl_distributionline account_id numeric 10  √  null Account used
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
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
c_validcombination alias varchar 40  √  null Defines an alternate method of indicating an account combination.
gl_budget budgetstatus bpchar 1  √  null Indicates the current status of this budget
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
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
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_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_distribution c_doctype_id numeric 10  √  null 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
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
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
c_acctschema c_period_id numeric 10  √  null 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
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
c_validcombination c_subacct_id numeric 10  √  null Sub account for Element Value
gl_journalline c_uom_id numeric 10  √  null Unit of Measure
gl_journalline c_validcombination_id numeric 10  √  null Valid Account Combination
c_validcombination combination varchar 60  √  null Unique combination of account elements
gl_journalbatch copyfrom bpchar 1  √  null Copy From Record
gl_journalbatch dateacct timestamp 29,6  √  null Accounting Date
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_doctype definitesequence_id numeric 10  √  null Definite Sequence
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_journalline description varchar 255  √  null Optional short description of the record
gl_category docbasetype bpchar 3  √  null Logical type of document
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
c_doctype documentnote varchar 2000  √  null Additional information for a Document
c_period enddate timestamp 29,6  √  null Last effective date (inclusive)
gl_journalgenerator generategljournal bpchar 1  √  null Generate GL Journal
gl_journal gl_budget_id numeric 10  √  null General Ledger Budget
gl_journalbatch gl_category_id numeric 10  √  null General Ledger Category
gl_journal gl_journalbatch_id numeric 10  √  null General Ledger Journal Batch
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_journalbatch isapproved bpchar 1  √  null Indicates if this document requires approval
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_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)
gl_distribution postingtype bpchar 1  √  null The type of posted amount for the transaction
gl_journal processedon numeric 0  √  null The date+time (expressed in decimal format) when 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_journal reversal_id numeric 10  √  null ID of document reversal
gl_journalbatch reversal_id numeric 10  √  null ID of document reversal
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
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
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
c_validcombination userelement1_id numeric 10  √  null User defined accounting Element
c_validcombination userelement2_id numeric 10  √  null User defined accounting Element
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_validcombination account_id numeric 10 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
gl_budgetcontrol budgetcontrolscope bpchar 1 Scope of the Budget Control
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_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_journalline c_currency_id numeric 10 The Currency for this record
c_doctype c_doctype_id numeric 10 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_fundrestriction c_elementvalue_id numeric 10 Account Element
gl_journalgeneratorsource c_elementvalue_id numeric 10 Account Element
c_period c_period_id numeric 10 Period of the Calendar
gl_journal c_period_id numeric 10 Period of the Calendar
c_validcombination c_validcombination_id numeric 10 Valid Account Combination
c_period c_year_id numeric 10 Calendar Year
gl_category categorytype bpchar 1 Source of the Journal with this category
gl_budgetcontrol commitmenttype bpchar 1 Create Commitment and/or Reservations for Budget Control
c_acctschema costingmethod bpchar 1 Indicates how Costs will be calculated
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
gl_journal dateacct timestamp 29,6 Accounting Date
gl_journalline dateacct timestamp 29,6 Accounting Date
gl_journal datedoc timestamp 29,6 Date of the Document
gl_journal description varchar 255 Optional short description of the record
gl_journalbatch description varchar 255 Optional short description of the record
gl_journal docaction bpchar 2 The targeted status of the document
gl_journalbatch docaction bpchar 2 The targeted status of the document
c_doctype docbasetype bpchar 3 Logical type of 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 documentcopies numeric 10 Number of copies to be printed
gl_journal documentno varchar 30 Document sequence number of the document
gl_journalbatch documentno varchar 30 Document sequence number of the document
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
gl_budget gl_budget_id numeric 10 General Ledger Budget
gl_budgetcontrol gl_budget_id numeric 10 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_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_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_journalline line numeric 10 Unique line for this document
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
gl_distributionline percent numeric 0 Percentage
gl_distribution percenttotal numeric 0 Sum of the Percent details
c_period periodno numeric 10 Unique Period Number
c_period periodtype bpchar 1 Period Type
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
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
c_acctschema separator bpchar 1 Element Separator
gl_journalgeneratorline seqno numeric 10 Method of ordering records; lowest number comes first
c_period startdate timestamp 29,6 First effective day (inclusive)
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
gl_journalgeneratorline bpdimensiontype bpchar 1  √  NULL::bpchar Type of BP Dimension
gl_journal copyfrom bpchar 1  √  NULL::bpchar Copy From Record
gl_journalgeneratorline bpcolumn varchar 100  √  NULL::character varying BP Column
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_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
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
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
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
gl_journalline account_id numeric 10  √  NULL::numeric Account used
gl_journalline ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
gl_journalline alias_validcombination_id numeric 10  √  NULL::numeric Valid Account Alias List
gl_journalgenerator c_acctschema_id numeric 10  √  NULL::numeric Rules for accounting
gl_journalline c_activity_id numeric 10  √  NULL::numeric Business Activity
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
gl_journalline c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
gl_journalgenerator c_doctype_id numeric 10  √  NULL::numeric Document type or rules
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
gl_journalline c_locfrom_id numeric 10  √  NULL::numeric Location that inventory was moved from
gl_journalline c_locto_id numeric 10  √  NULL::numeric Location that inventory was moved to
gl_journalline c_project_id numeric 10  √  NULL::numeric Financial Project
gl_journalline c_salesregion_id numeric 10  √  NULL::numeric Sales coverage region
gl_journalline c_subacct_id numeric 10  √  NULL::numeric Sub account for Element Value
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_journalline m_product_id numeric 10  √  NULL::numeric Product, Service, Item
gl_journalgeneratorsource roundfactor numeric 10  √  NULL::numeric Round Factor
gl_journalline user1_id numeric 10  √  NULL::numeric User defined list element #1
gl_journalline user2_id numeric 10  √  NULL::numeric User defined list element #2
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_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