POVALADJ_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for PO_VAL_ADJ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | 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 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 6 | ADJ_IMPACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Impacts
P=Price S=Schedule Value Default Value: P |
| 7 | ADJ_NBR | Number(3,0) | SMALLINT NOT NULL | Adjustment Sequence |
| 8 | 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 Prompt Table: PO_ADJ_TYPE_VW |
| 9 | BASE_PRICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Base Price Type
C=Contract I=Item Std R=RFQ U=User V=Supplier Std |
| 10 | ADJ_TBL_UOM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
UOM Adjustment
N=No Y=Yes Y/N Table Edit Default Value: N |
| 11 | ADJ_TBL_SHIPTO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Adjust on Shipto Flag
Y/N Table Edit Default Value: N |
| 12 | QTY_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 13 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 14 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: TAX_SU_HDR_VW |
| 15 | ADJ_TYPE_OTHER | Character(50) | VARCHAR2(50) NOT NULL | Other Adjustment Type |
| 16 | ADJ_METH | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Method
A=Amount P=Percentage Default Value: A |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 18 | ADJ_AMT | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Adjustment Amount |
| 19 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 20 | ADJ_AMT_BSE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Adjustment Amount - Base |
| 21 | ADJ_PCT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Adjust Percentage |
| 22 | ADJ_PCT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Price To Base Percentage On
INC=Calculated SUM=Base Default Value: SUM |
| 23 | APPLY_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Apply Adjustment
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 24 | NOT_APPLY_REASON | Character(50) | VARCHAR2(50) NOT NULL | Why Adjustment Not Applied |
| 25 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table: CM_LC_COMPONENT |
| 26 | 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 |
| 27 | X_VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Supplier Set ID
Prompt Table: SP_SETID_NONVW |
| 28 | X_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Third Party Supplier
Prompt Table: VNDR_VNDSET_VW |
| 29 | X_VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Third Party Supplier Location
Prompt Table: VNDR_VNDSET_VW |
| 30 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Y/N Table Edit Default Value: N |
| 31 | 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. |
| 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_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 |
| 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
Default Value: N |
| 35 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 36 | FLAT_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 37 | PCT_VALUE | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Percentage of Value |
| 38 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 39 | MISC_CHARGE_ORIGN | Character(1) | VARCHAR2(1) NOT NULL |
Misc Charge Origin
A=Allocated C=Calculated M=Entered |
| 40 | UNIT_PRICE_LC | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price -Landed Cost |
| 41 | SALETX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate Sales Tax
Default Value: Y |
| 42 | USETAX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate Use Tax
Default Value: Y |
| 43 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Default Value: Y |
| 44 | VAT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate VAT
Default Value: Y |
| 45 | FRGHT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate Freight Charges
Default Value: Y |
| 46 | MISC_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate Miscellaneous Charge
Default Value: Y |
| 47 | ACTUAL_CHRG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Actual Charges Flag
Y/N Table Edit Default Value: N |
| 48 | LC_RTV_CREDIT | Character(1) | VARCHAR2(1) NOT NULL |
Return to Vendor for Credit
Y/N Table Edit Default Value: N |
| 49 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 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.
Prompt Table: RT_TYPE_TBL |
| 51 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1 |
| 52 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 53 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |