Created by Miki Yanagi, last modified on Aug 24, 2023
| Key | Record.Fieldname | Format | XLAT | Heading Text | Note |
|---|---|---|---|---|---|
| ACCOUNT - Account | Char10 | Account | |||
| ACCOUNTING_DT - Accounting Date | Date | Acctg Date | |||
| 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 | |||
| APPL_JRNL_ID - Journal Template | Char10 | Template | |||
| BILLING_DATE - Billing Date | Date | Bill Dt | |||
| BUDGET_PERIOD - Budget Period | Char8 | Budget Period | |||
| BUDGET_REF - Budget Reference | Char8 | Bud Ref | |||
| BUSINESS_UNIT - Business Unit | Char5 | Unit | Use BUSINESS_UNIT_GL field for join tables | ||
| BUSINESS_UNIT_GL - GL Business Unit | Char5 | GL Unit | Use this field when you join other table for business 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 | |||
| DEPTID - Department | Char10 | Dept | |||
| DESCR50_MIXED - Description | Char50 | Description | |||
| DTTM_STAMP - Date/Time Stamp | DateTm | Date/Time | |||
| END_DT - End Date | Date | End Date | |||
| EXT_GL_CHARTFLD - External GL Chart Field | Char50 | Ext Chart | |||
| FISCAL_YEAR - Fiscal Year | Num4.0 | Year | |||
| FOREIGN_AMOUNT - Foreign Amount | SNm25.3 | Amount | |||
| FOREIGN_CURRENCY - Foreign Currency Code | Char3 | Currency | |||
| FUND_CODE - Fund Code | Char5 | Fund | |||
| GL_DISTRIB_STATUS - Distribution Status | Char1 | N | Status | ||
| IN_PROCESS_FLG - In Process | Char1 | In Process | |||
| ITEM_NBR - Item Nbr | Char15 | Item Nbr | |||
| JOURNAL_DATE - Journal Date | Date | Date | |||
| JOURNAL_ID - Journal ID | Char10 | Journal ID | |||
| JOURNAL_LINE - GL Journal Line Number | Num9.0 | Line # | |||
| JOURNAL_LINE_DATE - Journal Line Date | Date | Line Date | |||
| JRNL_LINE_STATUS - Journal Line Status | Char1 | N | Status | ||
| JRNL_LN_REF - Journal Line Reference | Char10 | Ref | |||
| LEDGER - Ledger | Char10 | Ledger | |||
| LEDGER_GROUP - Ledger Group | Char10 | Ledger Grp | |||
| LINE_DESCR - Journal Line Description | Char30 | Line Descr | |||
| → | LINE_NBR - Line Number | Num5.0 | Line | ||
| MONETARY_AMOUNT - Monetary Amount | SNm25.3 | Amount | |||
| OPEN_ITEM_STATUS - Open Item Status | Char1 | N | Status | ||
| OPERATING_UNIT - Operating Unit | Char8 | Oper Unit | |||
| PRIOR_READING - Prior Reading | SNm9.6 | Reading | |||
| PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | |||
| PRODUCT - Product | Char6 | Product | |||
| PROGRAM_CODE - Program Code | Char5 | Program | |||
| PROJECT_ID - Project | Char15 | Project | |||
| RATE_DIV - Rate Divisor | Num8.8 | Divisor | |||
| RATE_MULT - Rate Multiplier | SNm9.8 | Multiplier | |||
| READING - Reading | SNm9.6 | Reading | |||
| RT_TYPE - Rate Type | Char5 | Rate Type | |||
| → | RUN_DT - Run Date | Date | Run Date | ||
| → | SEQNUM - Sequence number | Num3.0 | SeqNum | ||
| START_DT - Start Date | Date | Start Date | |||
| STATISTIC_AMOUNT - Statistic Amount | SNm15.2 | Stat Amt | |||
| STATISTICS_CODE - Statistics Code | Char3 | Stat | |||
| UM_AIM_CUSTOM - Utility Contract ID | Char50 | Contract ID | |||
| UM_AIM_SHOP - AiM Shop | Char25 | Shop | |||
| UM_AIM_SUBLEDG - AiM Subledger | Char25 | AiM Subledger | |||
| UM_AIM_TRANS_TYPE - Transaction Type | Char50 | Trans Type | |||
| UM_AIM_UTIL_TYPE - Utility Type | Char15 | Type | |||
| UM_DOC_ID - Document ID | Char15 | Doc | |||
| UM_PHASE - Phase | Char20 | Phase | |||
| UM_PHS_DESCR - Phase Description | Char254 | Phase Descr | |||
| UM_WO_DESCR - Work Order Description | Char254 | WO Descr | |||
| USAGE_QTY - Current Period Usage | SNm13.4 | Current |
Source on JRNL_HEADER:
- 1WO
- 2WO
- 3WO
- 4WO
- 5WO
- 6WO
- 8WO
The view used this table: UM_AIM_LN_VW
SQL for PS_UM_AIM_LN_VW Expand source
SELECT A.FISCAL_YEAR,
A.ACCOUNTING_PERIOD,
A.JOURNAL_LINE,
A.DEPTID,
A.FUND_CODE,
A.PROGRAM_CODE,
A.PROJECT_ID,
A.OPERATING_UNIT,
A.ACCOUNT,
A.CLASS_FLD,
A.JOURNAL_ID,
A.JOURNAL_DATE,
A.LINE_DESCR,
SUBSTR(A.UM_WO_DESCR, 1, 50),
A.ACCOUNTING_DT,
A.MONETARY_AMOUNT,
A.BUSINESS_UNIT,
A.APPL_JRNL_ID
FROM PS_UM_AIM_ACCTG_LN A
ORDER BY A.JOURNAL_DATE, A.LINE_DESCR;