DARTS : LEDGER - Ledger Data
Created by Corina C Larsen, last modified on Sep 05, 2018
Key | Record.Fieldname | Format | XLAT | Heading Text |
---|
→ | ACCOUNT - Account | Char10 | | Account |
→ | ACCOUNTING_PERIOD - Accounting Period | Num3.0 | | Period |
→ | AFFILIATE - Affiliate | Char5 | | Affiliate |
→ | AFFILIATE_INTRA1 - Fund Affiliate | Char10 | | Fund Affil |
→ | AFFILIATE_INTRA2 - Operating Unit Affiliate | Char10 | | Oper Unit Affil |
→ | ALTACCT - Alternate Account | Char10 | | Alt Acct |
→ | BASE_CURRENCY - Base Currency | Char3 | | Base Curr |
→ | BOOK_CODE - Book Code | Char4 | | Book Code |
→ | BUDGET_REF - Budget Reference | Char8 | | Bud Ref |
→ | BUSINESS_UNIT - Business Unit | Char5 | | Unit |
→ | CHARTFIELD1 - ChartField 1 | Char10 | | ChartField 1 |
→ | CHARTFIELD2 - ChartField 2 | Char10 | | ChartField 2 |
→ | CHARTFIELD3 - ChartField 3 | Char10 | | ChartField 3 |
→ | CLASS_FLD - Class Field | Char5 | | Class |
→ | CURRENCY_CD - Currency Code | Char3 | | Currency |
→ | DATE_CODE - Date Code | Char1 | | Date Code |
→ | DEPTID - Department | Char10 | | Dept |
| DTTM_STAMP_SEC - Last Update DateTime | DateTm | | DateTime |
→ | FISCAL_YEAR - Fiscal Year | Num4.0 | | Year |
→ | FUND_CODE - Fund Code | Char5 | | Fund |
→ | GL_ADJUST_TYPE - Adjustment Type | Char4 | | Adjustment |
→ | LEDGER - Ledger | Char10 | | Ledger |
→ | OPERATING_UNIT - Operating Unit | Char8 | | Oper Unit |
| POSTED_BASE_AMT - Posted Base Currency Amount | SNm25.3 | | Amount |
| POSTED_TOTAL_AMT - Posted Total Amount | SNm25.3 | | Total Amt |
| POSTED_TOTAL_CR - Posted Total Credits | SNm25.3 | | Total Credits |
| POSTED_TOTAL_DR - Posted Total Debits | SNm25.3 | | Total Debits |
| POSTED_TRAN_AMT - Posted Transaction Amount | SNm25.3 | | Transaction Amt |
| POSTED_TRAN_CR - Transaction Credit Amount | SNm25.3 | | Transaction CR |
| POSTED_TRAN_DR - Transaction Debit Amount | SNm25.3 | | Transaction DR |
| PROCESS_INSTANCE - Process Instance | Num10.0 | | Instance |
→ | PRODUCT - Product | Char6 | | Product |
→ | PROGRAM_CODE - Program Code | Char5 | | Program |
→ | PROJECT_ID - Project | Char15 | | Project |
→ | STATISTICS_CODE - Statistics Code | Char3 | | Stat |