Created by Corina C Larsen, last modified by Cori Schneider on Sep 19, 2019
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| → | RUN_DT - Run Date | Date | Run Date | |
| → | SEQNUM - Sequence number | Num3.0 | SeqNum | |
| → | SF_LINE_NBR - Line Number | Num9.0 | Line | |
| IN_PROCESS_FLG - In Process | Char1 | In Process | ||
| BUSINESS_UNIT_GL - General Ledger Unit | Char5 | GL Unit | ||
| JOURNAL_ID - GL Journal ID | Char10 | Journal | ||
| JOURNAL_DATE - Journal Date | Date | Date | ||
| JOURNAL_LINE - GL Journal Line Number | Num9.0 | Line # | ||
| ACCOUNT - Account | Char10 | Acct | ||
| FUND_CODE - Fund Code | Char5 | Fund | ||
| PROGRAM_CODE - Program Code | Char5 | Program | ||
| DEPTID - Department | Char10 | DeptID | ||
| PROJECT_ID - Project/Grant | Char15 | Proj/Grt | ||
| STATISTICS_CODE - Statistics Code | Char3 | Stat | ||
| MONETARY_AMOUNT - Monetary Amount | SNm15.2 | Amount | ||
| STATISTIC_AMOUNT - Statistic Amount | SNm15.2 | Stat Amt | ||
| JRNL_LN_REF - Journal Line Reference | Char10 | Reference | ||
| OPEN_ITEM_STATUS - Open Item Status | Char1 | N | Status | |
| LINE_DESCR - Journal Line Description | Char30 | Line Descr | ||
| JRNL_LINE_STATUS - Journal Line Status | Char1 | N | Status | |
| JOURNAL_LINE_DATE - Journal Line Date | Date | Line Date | ||
| BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
| APPL_JRNL_ID - Journal Template | Char10 | Template | ||
| ACCOUNTING_DT - Accounting Date | Date | Acctg Date | ||
| GL_DISTRIB_STATUS - Distribution Status | Char1 | N | Status | |
| PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | ||
| CURRENCY_CD - Currency Code | Char3 | Currency | ||
| ACCOUNTING_PERIOD - Accounting Period | Num3.0 | Period | ||
| FISCAL_YEAR - Fiscal Year | Num4.0 | Year | ||
| FOREIGN_AMOUNT - Foreign Amount | SNm15.2 | Amount | ||
| FOREIGN_CURRENCY - Foreign Currency Code | Char3 | Currency | ||
| LEDGER - Ledger | Char10 | Ledger | ||
| LEDGER_GROUP - Ledger Group | Char10 | Ledger Grp | ||
| EXT_GL_CHARTFLD - External GL Chart Field | Char50 | Ext Chart | ||
| EMPLID - Empl ID | Char11 | ID | ||
| SF_EXT_ORG_ID - External Org ID | Char11 | Org ID | ||
| ITEM_NBR - Item Nbr | Char15 | Item Nbr | ||
| BUDGET_PERIOD - Budget Period | Char10 | Bgt Pd. | ||
| CLASS_FLD - Class Field | Char5 | Class | ||
| AFFILIATE - Affiliate | Char5 | Affl | ||
| BUDGET_REF - Budget Reference | Char8 | Budget Ref | ||
| CHARTFIELD1 - Chartfield 1 | Char10 | Chartfield1 | ||
| CHARTFIELD2 - Chartfield 2 | Char10 | Chartfield2 | ||
| CHARTFIELD3 - Chartfield 3 | Char10 | Chartfield3 | ||
| ALTACCT - Alternate Account | Char10 | Alt. Account | ||
| OPERATING_UNIT - Operating Unit | Char8 | Operating Unit | ||
| PRODUCT - Product | Char6 | Prod | ||
| AFFILIATE_INTRA1 - Fund Affiliate | Char10 | Fund Affil | ||
| AFFILIATE_INTRA2 - Operating Unit Affiliate | Char10 | Oper Unit Affil | ||
| SF_DEPOSIT_ID - Deposit ID | Char10 | Deposit | ||
| RT_TYPE - Rate Type | Char5 | Rate Type | ||
| RATE_DIV - Rate Divisor | Num8.8 | Divisor | ||
| RATE_MULT - Rate Multiplier | SNm9.8 | Multiplier | ||
| SF_GL_RUN_INSTANCE - Process Instance | Num10.0 | Instance | ||
| AUDIT_ACTN - Action | Char1 | N | Action | |
| COMMON_ID - ID | Char11 | ID | ||
| SA_ID_TYPE - ID Type | Char1 | N | ID Type | |
| SSF_GL_TRANS_ID - GL Transaction ID | Char12 | GL Transac ID | ||
| SSF_GL_TRANS_SEQNO - GL Transaction Line Seq Num | Num3.0 | GL Trans Ln Seq | ||
| ITEM_TERM - Item Term | Char4 | Item Term | ||
| ITEM_TYPE - Item Type | Char12 | Item Type | ||
| REF1_DESCR - Reference Nbr | Char30 | Ref Nbr | ||
| RECEIPT_NBR - Receipt Number | Num12.0 | Receipt # | ||
| SCC_ROW_ADD_OPRID - Created By | Char30 | Created By | ||
| SCC_ROW_ADD_DTTM - Created | DateTm | Created | ||
| SCC_ROW_UPD_OPRID - Updated By | Char30 | By | ||
| SCC_ROW_UPD_DTTM - Last Update Date/Time | DateTm | Updated |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.