Back

General Ledger (GL) - GLACCODT

Name Type Length Decimal Relation Description
ACCTNUM String 12 GL DETAIL ACCTNUM - General Ledger Account Number
PERIOD String 2 GL DETAIL PERIOD - The accounting period (ie 01,02,etc)
DATE DateTime 8 GL DETAIL DATE - The general ledger posting date
REFERENCE String 10 GL REFERENCE
COMMENT String 4 GL DETAIL COMMENT - Description of transaction. Also contains specific information about transaction such as invoice number. Specific information is parsed and used for drill downs.
AMOUNT Decimal 14 2 GL DETAIL AMOUNT - The amount of the posting. (debits are positive, credits are negative).
DOCUMENT String 15 GL DETAIL DOCUMENT - The source document that created the entry.
CLEARED Boolean 1 GL CLEARED
KEYID String 12 GL KEYID
CLEARDATE DateTime 8 GL CLEARDATE