PO_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Default Value: NEXT
3	CHNG_ORD_BATCH	Number(3,0)	SMALLINT NOT NULL	Change Order Number
4	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban Default Value: GEN Prompt Table: %EDITTABLE30
5	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
6	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit Default Value: N
7	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
8	DISP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Allow Dispatch When Appr Y/N Table Edit Default Value: Y
9	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
10	CHANGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Order Status C=Changed U=Unchanged Default Value: U
11	PO_DT	Date(10)	DATE NOT NULL	Date Default Value: %date
12	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
13	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PO_VW
15	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
16	PRICE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Price From Vendor SetID
17	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
18	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
19	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
20	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
21	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PO
22	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
23	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.ADDR_SEQ_NUM_ORDR Prompt Table: VENDOR_ADDR1_VW
24	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: VENDOR_CNTCT_VW
25	SALES_CNTCT_SEQ_N	Number(3,0)	SMALLINT NOT NULL	Salesperson Prompt Table: VENDOR_CNTCT_VW
26	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL
27	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT
28	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
29	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
30	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. Default Value: BUS_UNIT_TBL_PM.RT_TYPE Prompt Table: RT_TYPE_TBL
31	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard Default Value: N
32	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: %EDITTABLE2
33	MATCH_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Match Status M=Matched N=Not Required P=Partially Matched T=To Match Default Value: N
34	MATCH_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Match In Process I=In Process N=No Default Value: N
35	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
36	APPL_JRNL_ID_ENC	Character(10)	VARCHAR2(10) NOT NULL	Encumbrance
37	POST_DOC	Character(1)	VARCHAR2(1) NOT NULL	Post Document Y/N Table Edit Default Value: Y
38	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID Prompt Table: DST_CNTRL_DVW
39	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
40	ENTERED_DT	Date(10)	DATE	Entered on
41	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
42	APPROVAL_DT	Date(10)	DATE	Date of Approval
43	OPRID_MODIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
44	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
45	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
46	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
47	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
48	ACTIVITY_DATE	Date(10)	DATE	Last Activity
49	PO_POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Post Status D=Distributed N=None Default Value: N
50	NEXT_MOD_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Next Modification Number
51	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=No Y=Yes Default Value: N
52	ACCRUE_USE_TAX	Character(1)	VARCHAR2(1) NOT NULL	Accrue Use Tax Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX
53	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency Prompt Table: CURRENCY_CD_TBL
54	RATE_DATE	Date(10)	DATE	Exchange Rate Date
55	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: 1
56	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
57	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. Prompt Table: VAT_ENTITY
58	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Default Value: V
59	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
60	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
61	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
62	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
63	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System Prompt Table: LC_HDR_PO_VW Set Control Field: BUSINESS_UNIT_GL
64	BUDGET_HDR_STS_NP	Character(1)	VARCHAR2(1) NOT NULL	Budget Ch'k Hdr Sts NonProrate E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check Default Value: V
65	PREPAID_PO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Flag Y/N Table Edit Default Value: N
66	PREPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Prepaid Amount
67	PREPAID_AUTH_STAT	Character(1)	VARCHAR2(1) NOT NULL	Prepaid Authorization Status A=Authorized N=Not Approved P=Pending Authorization Default Value: N
68	PREPAID_STATUS_PO	Character(1)	VARCHAR2(1) NOT NULL	Prepaid PO Status N=Not Processed P=Processing V=Vouchered Default Value: N
69	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
70	TERMS_BASIS_DT	Date(10)	DATE	Payment Terms Basis Date
71	BACKORDER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Back Order Status 1=Not Backordered 2=Backordered 3=Backordered Received Default Value: 1
72	DOC_TOL_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Document Heade Document Tolerance Status E=Error N=Not Checked R=Reset V=Valid Default Value: V
73	MID_ROLL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Mid Roll Status Default Value: N
74	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
75	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
76	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
77	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
78	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
79	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
80	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
81	BUDGET_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Budget Checked N=No Y=Yes Y/N Table Edit Default Value: N
82	POA_STATUS	Character(2)	VARCHAR2(2) NOT NULL	po ack status field that will be on po_hdr. AC=Acknowledged with changes AK=Acknowledged BA=Approved, Changes Pending IN=Initial Dispatch Acknowledged NR=Not Required SR=Responded, Awaits Review WD=Awaiting PO Dispatch WR=Awaiting Acknowledgement Default Value: NR
83	POA_REQS	Character(1)	VARCHAR2(1) NOT NULL	CEL. New field to store POA requirements on the PO Hdr A=All dispatches I=Initial dispatch only N=Not required Default Value: N
84	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
85	CC_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Procurement Card Y/N Table Edit Default Value: N
86	CC_DISP_OPTION	Character(1)	VARCHAR2(1) NOT NULL	ProCard Dispatch Option A=Default B=Include Masked Card Info C=Contact Buyer D=Contact Cardholder E=Charge to Card on File F=No Reference
87	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
88	CONTACT_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Recepient Phone
89	TEXT254_CC2	Character(254)	VARCHAR2(254) NOT NULL	Payment Instructions
90	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN). Prompt Table: %EDITTABLE
91	SPLIT_PO_BY_SHIPTO	Character(1)	VARCHAR2(1) NOT NULL	Split PO by Ship To B=Default from Higher Level N=Do Not Split PO by Ship To Y=Split PO by Ship To Y/N Table Edit Default Value: N
92	EE_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Entry Event Sequence Number
93	PROCURE_INSTRUM_ID	Character(50)	VARCHAR2(50) NOT NULL	Procurement Instrument ID
94	PI_ID_PARENT	Character(50)	VARCHAR2(50) NOT NULL	Parent PIID
95	UNIVERSAL_REC_ID	Character(70)	VARCHAR2(70) NOT NULL	Universal Record Identifier
96	FEDERAL_AWARD_ID	Character(30)	VARCHAR2(30) NOT NULL	Federal Award IdentificationNo
97	EXCLUDE_REPORTING	Character(1)	VARCHAR2(1) NOT NULL	Exclude from DATA Act Y/N Table Edit Default Value: N
98	PRIORITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Priority Flag 1=High 2=Medium 3=Low Default Value: 2