PO_PRC_ADJ_WRK

(SQL Table)
 Index Back

Autosource Pricing Work Table

# 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 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
5 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 ADJ_WRK_SEQ Number(3,0) SMALLINT NOT NULL Adjustment Work table sequence
9 ADJ_AMT Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjustment Amount
10 ADJ_METH Character(1) VARCHAR2(1) NOT NULL Adjustment Method
A=Amount
P=Percentage
11 ADJ_PCT Signed Number(11,4) DECIMAL(9,4) NOT NULL Adjust Percentage
12 ADJ_SET_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Set Type
INC=Increment Adjustments
SUM=Sum All Adjustments
13 ADJ_WRK_TYPE Character(4) VARCHAR2(4) NOT NULL Type of Adjustment
14 ADJUST_ON_GENERAL Character(1) VARCHAR2(1) NOT NULL General Adjustment
N=No
Y=Yes
15 ADJUST_ON_SHIPTO Character(1) VARCHAR2(1) NOT NULL Adjust on Shipto
N=No
Y=Yes
16 ADJUST_ON_UOM Character(1) VARCHAR2(1) NOT NULL Adjust When UOM Matches
N=No
Y=Yes
17 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
18 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
19 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
21 DFLT_UOM_ADJUST Character(1) VARCHAR2(1) NOT NULL Default UOM Adjustment
22 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
23 FINAL_PRICE Character(1) VARCHAR2(1) NOT NULL Stop Price Calculation Here
N=No
Y=Yes
24 HARD_PRICE Character(1) VARCHAR2(1) NOT NULL Hard Price
N=No
Y=Yes
25 IGNORE_IF_OTHER Character(1) VARCHAR2(1) NOT NULL Ignore If Other Adjustments
N=No
Y=Yes
26 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
27 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
28 PRICE_ADJUST_SEQ Number(3,0) SMALLINT NOT NULL Price Adjustment Sequence
29 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
30 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
31 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
32 QTY_MAX Number(16,4) DECIMAL(15,4) NOT NULL Maximum Quantity
33 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
34 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
35 SHIPTO_ID_PRC Character(10) VARCHAR2(10) NOT NULL Price Shipto ID
36 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
37 SHIPTO_SETID_PRC Character(5) VARCHAR2(5) NOT NULL Shipto Setid for Pricing
38 UNIT_OF_MSRE_PRC Character(3) VARCHAR2(3) NOT NULL Price Unit of Measure
39 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
40 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
41 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location