PO_HDR_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
5	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
6	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: PYMT_TR_EFF_VW
7	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
8	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL
9	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit
10	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
12	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_TBL
13	PAY_TRM_BSE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date Type A=Acct Date C=Doc Date I=Inv Date R=Recpt Date S=Ship Date U=User Date
14	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
15	DISP_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Dispatch Method EDX=Electronic Document Exchange EML=Email Dispatch FAX=Fax Transmission PHN=Phone Dispatch PRN=Print
16	ACKNOWLEGE_DT	Date(10)	DATE	Acknowledge Date
17	ACK_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Acknowledgement Status AC=Ack - With Detail and Change AD=Ack - With Detail, No Change AE=Ack - Exception Detail Only AH=Acknowledge - Hold Status AK=Ack - No Detail or Change AT=Accepted BP=Accepted - Partial Shipment DR=Accepted - Date Rescheduled IA=Accepted - Price Pending IB=Backordered IC=Accepted - Changes Made ID=Deleted IF=On Hold-Incomplete Description IH=On Hold IP=Accepted - Price Changed IQ=Accepted - Quantity Changed IS=Accepted - Substitution Made IW=On Hold - Waiver Required RD=Rejected With Detail RF=Rej - Exception Detail Only RJ=Rejected - No Detail RO=Rejected With Counter Offer SP=Accpted-Schedule Date Pending ZZ=Mutually Defined Value
18	ACK_RECEIVED_DT	Date(10)	DATE	Date Received Default Value: %date
19	REVIEWED	Character(1)	VARCHAR2(1) NOT NULL	Review Complete N=No Y=Yes Y/N Table Edit Default Value: N
20	REVIEWED_DT	Date(10)	DATE	Reviewed On
21	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
22	PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processing Flag Default Value: N
23	DATETIME_DISP	DateTime(26)	TIMESTAMP	Date and Time Dispatched
24	DATETIME_CREATE	DateTime(26)	TIMESTAMP	02/2001 cel WV-802-1.0.
25	PO_POA_STATUS	Character(3)	VARCHAR2(3) NOT NULL	08/07/01 RML Created for Supplier Portal Acknowledgment BAC=Buyer Accepted CMP=EDX compare needed NEW=New SRP=Supplier Responded SRV=Supplier Review
26	PO_ACK_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC BUY=Online (Buyer) EDI=EDX SUP=Online (Supplier)
27	COMMENTS	Long Character	CLOB	Comment
28	EDX_COMPARE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	EDX Compare Status Default Value: N
29	VNDR_UPN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Vendor Universal Product Number Ready Flag
30	STD_ID_NUM_VNDRGLN	Character(20)	VARCHAR2(20) NOT NULL	Global Location Number
31	STD_ID_NUM_BILLTO	Character(20)	VARCHAR2(20) NOT NULL	Bill To GLN