Created by Miki Yanagi on Oct 13, 2020
This table contains Pro Card purchase information.
| Key | Record.Fieldname | Format | XLAT | Heading Text |
|---|---|---|---|---|
| ACCOUNT - Account | Char10 | Account | ||
| ACCOUNT_NUM - Account Number | Char35 | Account# | ||
| ACCOUNTING_DT - Accounting Date | Date | Acctg Date | ||
| ACCOUNTING_PERIOD - Accounting Period | Num3.0 | Period | ||
| ACTIVITY_ID - Activity | Char15 | Activity | ||
| 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 | ||
| ANALYSIS_TYPE - Analysis Type | Char3 | An Type | ||
| APPL_JRNL_ID - Journal Template | Char10 | Template | ||
| BUDGET_DT - Budget Date | Date | Budg Dt | ||
| BUDGET_LINE_STATUS - Budget Checking Line Status | Char1 | N | Budget Status | |
| BUDGET_REF - Budget Reference | Char8 | Bud Ref | ||
| BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
| BUSINESS_UNIT_GL - GL Business Unit | Char5 | GL Unit | ||
| BUSINESS_UNIT_PC - PC Business Unit | Char5 | PC Bus Unit | ||
| CF_BAL_LINE_NUM - Chart Field Balancing Line Num | Num10.0 | CF Bal Num | ||
| CHARTFIELD1 - ChartField 1 | Char10 | ChartField 1 | ||
| CHARTFIELD2 - ChartField 2 | Char10 | ChartField 2 | ||
| CHARTFIELD3 - ChartField 3 | Char10 | ChartField 3 | ||
| CLASS_FLD - Class Field | Char5 | Class | ||
| CRDMEM_ACCT_NBR - Cardmember Number | Char44 | Account | ||
| CURRENCY_CD - Currency Code | Char3 | Currency | ||
| DEBIT_CREDIT - Debit / Credit Indicator | Char2 | N | DR/CR | |
| DEPTID - Department | Char10 | Dept | ||
| DESCR - Description | Char30 | Descr | ||
| DESCR1 - Descr | Char30 | Description | ||
| DESCR254_MIXED - More Information | Char254 | More Info | ||
| DISTRIB_LINE_NUM - Distribution Line | Num5.0 | Distribution Li | ||
| DST_ACCT_TYPE - Accounting Entry Type | Char4 | N | Type | |
| DTTM_STAMP - Date/Time Stamp | DateTm | Date/Time | ||
| ENTRY_EVENT - Entry Event | Char10 | Event | ||
| ERROR_FLAG - Error Flag | Char1 | N | Err Flag | |
| ERROR_MESSAGE - Error Message | Char254 | Error Msg | ||
| EVENT_LINE - Entry Event Line Number | Num5.0 | Line | ||
| FILE_CREATE_DT - File Creation Date | Date | File Date | ||
| FISCAL_YEAR - Fiscal Year | Num4.0 | Year | ||
| FOREIGN_AMOUNT - Foreign Amount | SNm25.3 | Amount | ||
| FOREIGN_AMOUNT2 - Foreign Amount 2 | SNm25.3 | Frgn Amt 2 | ||
| FOREIGN_CURRENCY - Foreign Currency Code | Char3 | Currency | ||
| FUND_CODE - Fund Code | Char5 | Fund | ||
| GL_DISTRIB_STATUS - Distribution Status | Char1 | N | Status | |
| 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_DESCR - Journal Description | Char30 | Descr | ||
| JRNL_LINE_STATUS - Journal Line Status | Char1 | N | Status | |
| JRNL_LN_REF - Journal Line Reference | Char10 | Ref | ||
| LEDGER - Ledger | Char10 | Ledger | ||
| LEDGER_CATEGORY - Ledger Category | Char3 | Led Catg | ||
| LEDGER_GROUP - Ledger Group | Char10 | Ledger Grp | ||
| → | LINE_NBR - Line Number | Num5.0 | Line | |
| MERCHANT_CAT_CODE - Merchant Category Code | Char10 | MCC | ||
| MONETARY_AMOUNT - Monetary Amount | SNm25.3 | Amount | ||
| NAME1 - Name 1 | Char40 | Name | ||
| NAME1_VNDR - Supplier Name | Char40 | Supp nm | ||
| NAME2 - Name 2 | Char40 | Name 2 | ||
| OPERATING_UNIT - Operating Unit | Char8 | Oper Unit | ||
| PC_DISTRIB_STATUS - PC Distribution Status | Char1 | N | PC Status | |
| POST_DT - Posted Date | Date | Posted | ||
| PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | ||
| PROCESS_STATUS - Process Status | Char1 | N | Status | |
| PROCESSED_DATE - Processed Date | Date | Date | ||
| PROCESSED_FLG - Plan Processed Flag | Char1 | N | Processed | |
| 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 | ||
| REFERENCE - Reference Code | Char30 | Reference | ||
| RESOURCE_CATEGORY - Category | Char5 | Category | ||
| RESOURCE_SUB_CAT - Subcategory | Char5 | Subcategory | ||
| RESOURCE_TYPE - Source Type | Char5 | Source Type | ||
| RT_TYPE - Rate Type | Char5 | Rate Type | ||
| → | RUN_DT - Run Date | Date | Run Date | |
| → | SEQ_NUM - Sequence | Num3.0 | Seq Nbr | |
| SEQUENCENO - Sequence Number | Num10.0 | Sequence | ||
| STATEMENT_DT - Statement Date | Date | Date | ||
| TAXPAYER_ID_NO - Taxpayer ID Number | Char9 | TIN | ||
| TAXPAYER_ID_TYPE - TIN Type | Char3 | N | TIN_TYPE | |
| TRANS_NBR - Transaction Number | Char24 | Tran Nbr | ||
| TRANSACTION_DT - Transaction Date | Date | Trans Date | ||
| UM_PHASE - Phase | Char20 | Phase | ||
| UM_WORK_ORDER - Work Order Number | Char15 | Work Order | ||
| VENDOR_NAME1 - Supplier Name 1 | Char40 | Supp Name1 |
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.
