PO_HDR_DIAG_VW

#	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	CHANGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Order Status C=Changed U=Unchanged Default Value: U
10	PO_DT	Date(10)	DATE NOT NULL	Date Default Value: %date
11	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PO_VW
13	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
14	PRICE_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Price Vendor ID
15	PRICE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Price from Location
16	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
17	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: %EDIT_BUYER
18	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PO
19	CHNG_ORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Change Order Sequence Number
20	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Default Value: VENDOR.ADDR_SEQ_NUM_ORDR Prompt Table: VENDOR_ADDR_VW
21	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION Prompt Table: LOCATION_TBL
22	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT
23	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
25	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
26	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard Default Value: N
27	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: %EDITTABLE2
28	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
29	MATCH_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Match In Process I=In Process N=No Default Value: N
30	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
31	ENTERED_DT	Date(10)	DATE	Entered on
32	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
33	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL
34	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
35	ERS_ACTION	Character(1)	VARCHAR2(1) NOT NULL	ERS Action N=No Y=Yes Default Value: N
36	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
37	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency Prompt Table: CURRENCY_CD_TBL
38	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: 1
39	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
40	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