REQ_VAL_ADJ_STG

(SQL Table)
Index Back

PO Price/Amount Adjustments

# 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 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
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_IMPACT_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Impacts
P=Price
S=Schedule Value

Default Value: P

9 ADJ_NBR Number(3,0) SMALLINT NOT NULL Adjustment Sequence
10 ACTUAL_CHRG_FLG Character(1) VARCHAR2(1) NOT NULL Actual Charges Flag
11 ADJ_AMT Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjustment Amount
12 ADJ_AMT_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjustment Amount - Base
13 ADJ_METH Character(1) VARCHAR2(1) NOT NULL Adjustment Method
A=Amount
P=Percentage

Default Value: A

14 ADJ_PCT Signed Number(11,4) DECIMAL(9,4) NOT NULL Adjust Percentage
15 ADJ_PCT_TYPE Character(3) VARCHAR2(3) NOT NULL Price To Base Percentage On
INC=Calculated
SUM=Base

Default Value: SUM

16 ADJ_TBL_SHIPTO_FLG Character(1) VARCHAR2(1) NOT NULL Adjust on Shipto Flag

Y/N Table Edit

Default Value: N

17 ADJ_TBL_UOM_FLG Character(1) VARCHAR2(1) NOT NULL UOM Adjustment
N=No
Y=Yes

Y/N Table Edit

Default Value: N

18 ADJ_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type
BAS=Base
CNT=Contract
FRT=Freight
OTH=Other
TAX=Tax
TBL=Table

Default Value: OTH

19 ADJ_TYPE_OTHER Character(50) VARCHAR2(50) NOT NULL Other Adjustment Type
20 APPLY_ADJ Character(1) VARCHAR2(1) NOT NULL Apply Adjustment
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

21 BASE_PRICE_TYPE Character(1) VARCHAR2(1) NOT NULL Base Price Type
C=Contract
I=Item Std
R=RFQ
U=User
V=Supplier Std
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
24 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
25 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.
26 FLAT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
27 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges
28 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
29 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
30 LC_ACCRUAL_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.
31 LC_COMP_ALLOC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value
QTY=Quantity
VOL=Volume
WT=Weight
32 LC_COMP_CALC Character(3) VARCHAR2(3) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
FL=Flat Amt
FR=Free
FRT=Freight
STX=Sales Tax
UNT=Unit Amt
UTX=Use Tax
VAL=% Value
VAT=VAT
VOL=Volume
WT=Weight
33 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
34 LC_COMP_ON_PO Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Indicates whether this Landed cost component is typically included on the Purchase order to the merchandise supplier
35 LC_RTV_CREDIT Character(1) VARCHAR2(1) NOT NULL Return to Vendor for Credit
36 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
37 MISC_CHARGE_ORIGN Character(1) VARCHAR2(1) NOT NULL Misc Charge Origin
A=Allocated
C=Calculated
M=Entered
38 MISC_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Miscellaneous Charge
39 NOT_APPLY_REASON Character(50) VARCHAR2(50) NOT NULL Why Adjustment Not Applied
40 PCT_VALUE Signed Number(9,2) DECIMAL(7,2) NOT NULL Percentage of Value
41 PRICE_VNDR Number(16,5) DECIMAL(15,5) NOT NULL Vendor Price
42 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
43 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
44 QTY_REQ_LINE Number(16,4) DECIMAL(15,4) NOT NULL Total Line Quantity requested
45 QTY_REQ_SHIP Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested for Shipto
46 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
L=Line Quantity
S=Schedule Quantity
47 RATE_DATE Date(10) DATE Exchange Rate Date
48 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
49 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
50 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.
51 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax
52 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
53 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
54 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: TAX_HEADER_TBL

55 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
56 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
57 UNIT_PRICE_LC Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price -Landed Cost
58 USE_CNTRCT_BASE Character(1) VARCHAR2(1) NOT NULL Use Contract Base Price
N=No
Y=Yes
59 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax
60 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
61 VAT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate VAT
62 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier
63 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID
64 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location