PL_PO_HDR_C

(SQL Table)
Index Back

PL_PO_HDR_C

PL_PO_HDR_C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

Prompt Table: SP_PRBINS_NONVW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: PL_POBU_VW

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: PL_POID_VW

4 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
5 ORIG_STATUS Character(2) VARCHAR2(2) NOT NULL Original PO Status
6 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
7 PO_DT Date(10) DATE Date
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference