DARTS : LEDGER_BUDG - Budget 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_PERIOD - Budget Period | Char8 | | Budget Period |
| → | 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 |
| → | SCENARIO - Scenario | Char10 | | Scenario |
| → | STATISTICS_CODE - Statistics Code | Char3 | | Stat |