UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
PO_LINE
Contains the long description (254 maximum characters) of the goods/services in a PO.
This record is a child of PO_HDR.
Further details are in this record's child: PO_LINE_DISTRIB.
|
| 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)
|
| |
|
| .
|
| LINE_NBR
| Line Number
| Example: 1
|
| KEY
| Type: number
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The number of the line on the PO.
|
| |
|
| .
|
| PO_ID
| Purchase Order
| Example: 0000000015
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Identifies a particular Purchase Order
|
| |
|
| .
|
| CATEGORY_ID
| Category ID
| Example: 00014
|
|
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Identifier of a particular comodity or service in A/P or Procurement.
|
| |
|
| .
|
| 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.
|
| |
|
| .
|
| CNTRCT_ID
| Buying Agreement ID
| Example:
|
|
| Type: character
| Format: uppercase
| Length: 25
| Decimals: 0
|
| | Identifier of an individual contract.
|
| |
|
| .
|
| CNTRCT_LINE_NBR
| Buying Agreement Line Nbr
| Example: 1
|
|
numb | number Type: number
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | A line number of a contract.
|
| |
|
| .
|
| DESCR254_MIXED
| (No Description)
| Example: Widget Covers with matching logos and perforated
|
|
| Type: character
| Format: lowercase
| Length: 254
| Decimals: 0
|
| | Description
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| AMT_ONLY_FLG
| Amount Only
|
| CANCEL_STATUS
| Cancel Status
|
| CHNG_ORD_SEQ
| Change Order Sequence Number
|
| CNTRCT_RATE_DIV
| Contract Rate Divider
|
| CNTRCT_RATE_MULT
| Contract Rate Multiplier
|
| CNTRCT_SETID
| SetID
|
| CONFIG_CODE
| Configuration Code
|
| CP_TEMPLATE_ID
| Template
|
| GPO_CNTRCT_NBR
| GPO Contract Number
|
| GPO_ID
| GPO ID
|
| INSPECT_CD
| Inspection Required
|
| INV_ITEM_ID
| Item ID
|
| ITM_ID_VNDR
| Vendor Item ID
|
| ITM_SETID
| Item SetID
|
| MFG_ID
| Manufacturer ID
|
| MFG_ITM_ID
| Manufacturer's Item ID
|
| MILESTONE_NBR
| Milestone Line Number
|
| PACKING_VOLUME
| Packing Volume
|
| PACKING_WEIGHT
| Packing Weight
|
| PRICE_CAN_CHANGE
| Price Can Be Changed on Order
|
| PRICE_DT_TYPE
| Date to Use for Prices
|
| QTY_TYPE
| Quantity to Use for Prices
|
| RECV_REQ
| Receiving Required
|
| RELEASE_NBR
| Release Number
|
| REPLEN_OPT
| Replenish Code
|
| RFQ_ID
| RFQ ID
|
| RFQ_LINE_NBR
| RFQ Line
|
| ROUTING_ID
| Inspection Routing ID
|
| UNIT_MEASURE_VOL
| Volume UOM
|
| UNIT_MEASURE_WT
| Weight UOM
|
| UNIT_OF_MEASURE
| Unit of Measure
|
| VNDR_CATALOG_ID
| Vendor's Catalog Number
|
| WTHD_CD
| Withholding Code
|
| WTHD_SW
| Withholding Applicable