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 currency of the FT. |
| CURRENCY_CD | A3 | The currency in which the Amount is denominated. |
| 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.2 | 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.