Detail Record Layout for GLDL
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 |
The GLASSIGN process updates an FT's GL details with the appropriate GL account number.