Key | Record.Fieldname | Format | XLAT | Heading Text |
---|
| ACCOUNTING_DT - Accounting Date | Date | | Acctg Date |
| ACCRUE_USE_TAX - Accrue Use Tax | Char1 | | Accrue |
| ACTIVITY_DATE - Last Activity | Date | | Last Activ |
| ADDRESS_SEQ_NUM - Address Sequence Number | Num5.0 | | Location |
| APPL_JRNL_ID_ENC - Encumbrance | Char10 | | Enc |
| APPROVAL_DT - Date of Approval | Date | | Date |
| BACKORDER_STATUS - Backorder Status | Char1 | N | BO Stat |
| BILL_LOCATION - Billing Location | Char10 | | Bill Addrs |
| BUDGET_CHECK - Budget Checked | Char1 | | Budget |
| BUDGET_HDR_STATUS - Budget Checking Header Status | Char1 | N | Budget Status |
| BUDGET_HDR_STS_NP - Budget Ch'k Hdr Sts NonProrate | Char1 | | Budget Status |
→ | BUSINESS_UNIT - Business Unit | Char5 | | Unit |
| BUSINESS_UNIT_GL - GL Business Unit | Char5 | | GL Unit |
| BUYER_ID - Buyer | Char30 | | Buyer |
| CC_DISP_OPTION - ProCard Dispatch Option | Char1 | N | Dispatch Option |
| CC_SECURITY_ID - Procurement Card Number | Num10.0 | | Card Number |
| CC_USE_FLAG - Use Procurement Card | Char1 | | Use ProCard |
| CHANGE_STATUS - Change Order Status | Char1 | N | Chng Stat |
| CHNG_ORD_BATCH - Change Order Number | Num3.0 | | Change Order |
| CHNG_ORD_SEQ - Change Order Sequence Number | Num3.0 | | Chng Seq |
| CNTCT_SEQ_NUM - Contact Sequence Number | Num5.0 | | Sequence |
| CONTACT_NAME - Contact Name | Char50 | | Name |
| CONTACT_PHONE - Contact Phone | Char24 | | Phone |
| CURRENCY_CD - Currency Code | Char3 | | Currency |
| CURRENCY_CD_BASE - Business Unit Base Currency | Char3 | | Base Currency |
| CUSTOM_C1_A - Custom Character 2 | Char1 | | UsrChr |
| CUSTOM_C100_A1 - Custom Field 1 | Char100 | | Custm1 |
| CUSTOM_C100_A2 - Custom Field 2 | Char100 | | Custm2 |
| CUSTOM_C100_A3 - Custom Field 3 | Char100 | | Custm3 |
| CUSTOM_C100_A4 - Custom Field 4 | Char100 | | Custm4 |
| CUSTOM_DATE_A - Custom Date | Date | | UserDt |
| DISP_ACTION - Allow Dispatch When Appr | Char1 | | Dispatch |
| DISP_METHOD - Dispatch Method | Char3 | N | Method |
| DOC_TOL_HDR_STATUS - Document Tolerance Status | Char1 | N | Doc Tol Status |
| DST_CNTRL_ID - Accounting Template | Char10 | | Template |
| EE_SEQ_NUM - Entry Event Sequence Number | Num8.0 | | EE Dist Seq Num |
| ENTERED_DT - Entered on | Date | | Entered |
| ERS_ACTION - ERS Action | Char1 | N | ERS Action |
| EXCLUDE_REPORTING - Exclude from DATA Act | Char1 | | Exclude |
| FEDERAL_AWARD_ID - Federal Award IdentificationNo | Char30 | | FAIN |
| HOLD_STATUS - Hold From Further Processing | Char1 | | Hold |
| IN_PROCESS_FLG - In Process | Char1 | | In Process |
| KK_AMOUNT_TYPE - Commitment Control Amount Type | Char1 | N | Amount Type |
| KK_TRAN_OVER_DTTM - Override Date | DateTm | | DateTime |
| KK_TRAN_OVER_FLAG - Override Transaction | Char1 | | Override |
| KK_TRAN_OVER_OPRID - Override User ID | Char30 | | User |
| LAST_DTTM_UPDATE - Last Change Date | DateTm | | Last Dttm |
| LC_ID - Letter of Credit ID | Char12 | | L/C ID |
| MATCH_ACTION - Match Action | Char1 | N | Action |
| MATCH_CNTRL_ID - Match Rule | Char10 | | Rule |
| MATCH_PROCESS_FLG - Match In Process | Char1 | N | Match Flg |
| MATCH_STATUS_PO - Match Status | Char1 | N | Status |
| MID_ROLL_STATUS - Mid Roll Status | Char1 | | Mid Roll Status |
| NEXT_MOD_SEQ_NBR - Next Modification Number | Num3.0 | | Next Mod |
| OPRID_APPROVED_BY - Approved By | Char30 | | By |
| OPRID_ENTERED_BY - Entered By | Char30 | | Entered By |
| OPRID_MODIFIED_BY - Last User to Modify | Char30 | | User Modify |
| ORIGIN - Origin | Char3 | | Origin |
| PAY_TRM_BSE_DT_OPT - Payment Terms Basis Date Type | Char1 | N | Basis Date Type |
| PI_ID_PARENT - Parent PIID | Char50 | | Parent PIID |
| PO_DT - Purchase Order Date | Date | | PO Date |
→ | PO_ID - PO Number | Char10 | | PO No. |
| PO_POST_STATUS - Post Status | Char1 | N | Post Statu |
| PO_REF - Purchase Order Reference | Char30 | | PO Ref |
| PO_STATUS - PO Status | Char2 | N | Status |
| PO_TYPE - PO Type | Char4 | | Type |
| POA_REQS - Acknowledgements required for | Char1 | N | POA required |
| POA_STATUS - POA Status | Char2 | N | POA Status |
| POST_DOC - Post Document | Char1 | | Post Doc |
| PREPAID_AMT - Prepaid Amount | SNm25.3 | | Prepaid Amt |
| PREPAID_AUTH_STAT - Prepaid Authorization Status | Char1 | N | Prepaid Auth |
| PREPAID_PO_FLG - Prepaid PO Flag | Char1 | | Prepaid PO Flag |
| PREPAID_STATUS_PO - Prepaid PO Status | Char1 | N | Prepaid PO Stat |
| PRICE_LOC - Price from Location | Char10 | | Pricing |
| PRICE_SETID - Price From Supplier SetID | Char5 | | Price SetID |
| PRICE_VENDOR - Price Supplier ID | Char10 | | Price Supp |
| PROCESS_INSTANCE - Process Instance | Num10.0 | | Instance |
| PROCURE_INSTRUM_ID - Procurement Instrument ID | Char50 | | PIID |
| PYMNT_TERMS_CD - Payment Terms ID | Char5 | | Terms |
| RATE_DATE - Exchange Rate Date | Date | | Rate Date |
| RATE_DIV - Rate Divisor | Num8.8 | | Divisor |
| RATE_MULT - Rate Multiplier | SNm9.8 | | Multiplier |
| RECV_STATUS - Receipt Status | Char1 | N | Receipt |
| RT_TYPE - Rate Type | Char5 | | Rate Type |
| SALES_CNTCT_SEQ_N - Salesperson | Num3.0 | | Salespersn |
| SPLIT_PO_BY_SHIPTO - Split PO by Ship To | Char1 | | Split |
| TAX_EXEMPT - Tax Exempt Flag | Char1 | | Tax Exempt |
| TAX_EXEMPT_ID - Tax Exempt ID | Char30 | | Exempt ID |
| TERMS_BASIS_DT - Payment Terms Basis Date | Date | | Basis Date |
| TEXT254_CC2 - Payment Instructions | Char254 | | Instructions |
| TMPLDEFN_ID - Template ID | Char30 | | Template ID |
| UNIVERSAL_REC_ID - Universal Record Identifier | Char70 | | URI |
| USER_HDR_CHAR1 - Custom Character 1 | Char1 | | Char 1 |
| VAT_ENTITY - VAT Reporting Entity | Char20 | | VAT Entity |
| VENDOR_ID - Supplier ID | Char10 | | Supplier |
| VENDOR_SETID - Supplier SetID | Char5 | | Supp SetID |
| VNDR_LOC - Supplier Location | Char10 | | Location |