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 |