SRM_PO_WC_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
6	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
7	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	APPROVAL_DT	Date(10)	DATE	Date of Approval
10	CHNG_DTTM	DateTime(26)	TIMESTAMP	Change Request Date/Time Default Value: %Date
11	CNTRCT_EXPIRE_DT	Date(10)	DATE	Expire Date
12	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
14	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
15	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
16	PO_DT	Date(10)	DATE	Date Default Value: %date
17	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
18	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 Default Value: I
19	PO_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PO Total
20	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled Default Value: N
21	REQ_DT	Date(10)	DATE	Requisition Date
22	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
23	STAGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Stage Status B=Ready to Create C=Completed D=Inv Demand Build in Process E=Error I=In Process N=Needs Approval P=PO Create in Process R=Error Recycle S=Staged V=POCALC in Process W=Warning Issued X=Reset Req and Purge
24	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
25	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
26	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
27	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
28	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
29	APPROVE_PB	Character(1)	VARCHAR2(1) NOT NULL	Approve