PO_POA_HDR_HIST

(SQL Table)
Index Back

POA Header history

Created on 08/09/01 - CN#WV840-4.0 Purchase order acknowledgment history - header record

# 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 RESPONDED_DTTM DateTime(26) TIMESTAMP Represents the date and time a designated operator reviewed and acknowledged an exposure limit vi
5 POA_HIST_TYPE Character(1) VARCHAR2(1) NOT NULL Submitted by
B=Buyer
S=Supplier

Default Value: S

6 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
7 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
8 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

9 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: VENDOR_CNTCT_VW

10 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Prompt Table: LOCATION_TBL

11 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

12 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

14 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

15 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
16 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
17 ACK_RECEIVED_DT Date(10) DATE Date Received
18 REVIEWED Character(1) VARCHAR2(1) NOT NULL Review Complete
N=No
Y=Yes

Y/N Table Edit

19 REVIEWED_DT Date(10) DATE Reviewed On
20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
21 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
22 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
23 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
24 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)

Default Value: SUP

25 COMMENTS Long Character CLOB Comment
26 VNDR_UPN_FLG Character(1) VARCHAR2(1) NOT NULL Vendor Universal Product Number Ready Flag
27 STD_ID_NUM_VNDRGLN Character(20) VARCHAR2(20) NOT NULL Global Location Number
28 STD_ID_NUM_BILLTO Character(20) VARCHAR2(20) NOT NULL Bill To GLN