Detail Record Layout for GLDL

Note:

A record is created for each unique occurrence of REC_TYPE, GL_DIVISION, CURRENCY_CD, GL_ACCOUNT and ACCT_PERIOD. If a given GL account has debit and credit FINANCIAL_AMOUNTs, two records will be created - one shows the debit amount, the other shows the credit amount.


Field Name	Format	Source/Value/Description
REC_TYPE	A1	2 ( 2 is used for detail records )
GL_DIVISION	A5	This is the GL Division from the CI_FT record. It determines a) which Accounting Calendar will be used to calculate the Accounting Period (below) and b) the default currency (i.e., if currency code is not sourced directly from the FT).
CURRENCY_CD	A3	The currency in which the Amount is denominated. Note: The Use FT's Currency Code (Y/N) batch parameter controls whether the Currency Code is retrieved directly from the FT or from the GL Division (default).
GL_ACCOUNT	A254	Contains the GL account number as supplied by the distribution code's GL account algorithm.
ACCT_PERIOD	A6	An accounting period in the format YYYYPP where YYYY is the fiscal year and PP is the accounting period. This is derived from the GL detail's FT's accounting date and GL division.
FINANCIAL_AMOUNT	N13.2	This is the debit or credit amount. Debits are represented by positive numbers; credits are represented by negative numbers. If a given GL account has debit and credit entries, two records will be created - one shows the debit amount, the other shows the credit amount.
STAT_CODE	A8	This is the GL distribution code's statistic code (if any)
STAT_AMOUNT	N13.6	This is the statistical amount from the GL detail lines

Note:

The GLASSIGN process updates an FT's GL details with the appropriate GL account number.