PO_POA_HDR_HIST(SQL Table) |
Index Back |
---|---|
POA Header historyCreated 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 |