UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
PO_HDR
This is the main Purchase Order record. It contains information
common to the entire PO, such as the PO status, PO date, vendor, buyer.
Further details are in this record's child: PO_LINE.
|
| BUSINESS_UNIT
| Business Unit
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Legal entity with a tax ID number. Only one exists at UD at this time
(UOD01)
|
| |
|
| .
|
| PO_ID
| Purchase Order
| Example: 0000000015
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies a particular Purchase Order
|
| |
|
| .
|
| ADDRESS_SEQ_NUM
| Address Sequence Number
| Example: 1
|
|
| Type: number
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Represents the sequence in which multiple addresses are recorded.
|
| |
|
| .
|
| BUYER_ID
| Buyer
| Example: mdowney
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | PS userID of Purchasing staff assigned this PO.
|
| |
|
| .
|
| CHANGE_STATUS
| Change Order Status
| Example: U
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Represents whether a change order has been issued for a P.O.
|
| |
|
| .
|
| MATCH_STATUS_PO
| Match Status
| Example: N
|
|
| Type: character
| Format: uppercase
| Length: 1
| Decimals: 0
|
| | Denotes if the PO has been matched to a voucher and possibly a receiver.
|
| |
|
| .
|
| PO_DT
| Purchase Order Date
| Example: 11/26/2002
|
|
| Type: date
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Day the PO became effective.
|
| |
|
| .
|
| PO_STATUS
| PO Status
| Example: A
|
|
| Type: character
| Format: uppercase
| Length: 2
| Decimals: 0
|
| | Status of the PO.
|
| |
|
| .
|
| VENDOR_ID
| Vendor ID
| Example: 0000000001
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifier of the vendor.
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| ACCOUNTING_DT
| Accounting Date
|
| ACCRUE_USE_TAX
| Accrue Use Tax
|
| ACTIVITY_DATE
| Last Activity
|
| APPL_JRNL_ID_ENC
| Encumbrance
|
| APPROVAL_DT
| Date of Approval
|
| BACKORDER_STATUS
| Backorder Status
|
| BILL_LOCATION
| Billing Location
|
| BUDGET_CHECK
| Budget Checked
|
| BUDGET_HDR_STS_NP
| Budget Ch'k Hdr Sts NonProrate
|
| BUSINESS_UNIT_GL
| General Ledger Unit
|
| CHNG_ORD_BATCH
| Change Order Number
|
| CHNG_ORD_SEQ
| Change Order Sequence Number
|
| CNTCT_SEQ_NUM
| Contact Sequence Number
|
| CURRENCY_CD
| Currency Code
|
| CURRENCY_CD_BASE
| Business Unit Base Currency
|
| DISP_ACTION
| Allow Dispatch When Appr
|
| DISP_METHOD
| Dispatch Method
|
| DOC_TOL_HDR_STATUS
| Document Tolerance Status
|
| DST_CNTRL_ID
| Accounting Template
|
| ENTERED_DT
| Entered on
|
| ERS_ACTION
| ERS Action
|
| HOLD_STATUS
| Hold From Further Processing
|
| IN_PROCESS_FLG
| In Process
|
| LC_ID
| Letter of Credit ID
|
| MATCH_ACTION
| Match Action
|
| MATCH_CNTRL_ID
| Match Rule
|
| MATCH_PROCESS_FLG
| Match In Process
|
| MID_ROLL_STATUS
| Mid Roll Status
|
| NEXT_MOD_SEQ_NBR
| Next Modification Number
|
| OPRID_APPROVED_BY
| Approved By
|
| OPRID_ENTERED_BY
| Entered By
|
| ORIGIN
| Origin
|
| PAY_TRM_BSE_DT_OPT
| Payment Terms Basis Date Type
|
| PO_POST_STATUS
| Post Status
|
| PO_REF
| Purchase Order Reference
|
| PO_TYPE
| PO Type
|
| POST_DOC
| Post Document
|
| PREPAID_AMT
| Prepaid Amount
|
| PREPAID_AUTH_STAT
| Prepaid Authorization Status
|
| PREPAID_PO_FLG
| Prepaid PO Flag
|
| PREPAID_STATUS_PO
| Prepaid PO Status
|
| PRICE_LOC
| Price from Location
|
| PRICE_SETID
| Price From Vendor SetID
|
| PRICE_VENDOR
| Price Vendor ID
|
| PROCESS_INSTANCE
| Process Instance
|
| PYMNT_TERMS_CD
| Payment Terms ID
|
| RATE_DATE
| Exchange Rate Date
|
| RATE_DIV
| Rate Divisor
|
| RATE_MULT
| Rate Multiplier
|
| RECV_STATUS
| Receipt Status
|
| RT_TYPE
| Rate Type
|
| SALES_CNTCT_SEQ_N
| Salesperson
|
| TAX_EXEMPT
| Tax Exempt Flag
|
| TAX_EXEMPT_ID
| Tax Exempt ID
|
| TERMS_BASIS_DT
| Payment Terms Basis Date
|
| VAT_ENTITY
| VAT Reporting Entity
|
| VENDOR_SETID
| Vendor Set ID
|
| VNDR_LOC
| Vendor Location