PO_CHNG_H_WRK

(SQL Table)
Index Back

PO Change Header Work

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
5 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
6 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
7 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
8 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 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.
11 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
12 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
13 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.
14 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

15 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID