PO_VAL_ADJ_FS

(SQL View)
 Index Back

PO Price/Amount Adjustments


SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , SCHED_NBR , ADJ_IMPACT_TYPE , ADJ_NBR , ADJ_TYPE , BASE_PRICE_TYPE , ADJ_TBL_UOM_FLG , ADJ_TBL_SHIPTO_FLG , QTY_MIN , QTY_PO , TAX_CD , ADJ_TYPE_OTHER , ADJ_METH , CURRENCY_CD , ADJ_AMT , CURRENCY_CD_BASE , ADJ_AMT_BSE , ADJ_PCT , ADJ_PCT_TYPE , APPLY_ADJ , NOT_APPLY_REASON , MISC_CHARGE_CODE , DST_ACCT_TYPE , X_VENDOR_SETID , X_VENDOR_ID , X_VNDR_LOC , LC_COMP_FLAG , LC_ACCRUAL_FLAG , LC_COMP_CALC , LC_COMP_ALLOC , LC_COMP_ON_PO , UNIT_PRICE , FLAT_AMOUNT , PCT_VALUE , UNIT_OF_MEASURE , MISC_CHARGE_ORIGN , UNIT_PRICE_LC , SALETX_PRORATE_FLG , USETAX_PRORATE_FLG , VAT_NRCVR_PRO_FLG , VAT_PRORATE_FLG , FRGHT_PRORATE_FLG , MISC_PRORATE_FLG , ACTUAL_CHRG_FLG , LC_RTV_CREDIT , RATE_DATE , RT_TYPE , RATE_MULT , RATE_DIV FROM PS_PO_VAL_ADJ

  • Parent record: PO_LINE_SHIP_FS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    5 ADJ_IMPACT_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Impacts
    P=Price
    S=Schedule Value

    Default Value: P

    6 ADJ_NBR Number(3,0) SMALLINT NOT NULL Adjustment Sequence
    7 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

    8 BASE_PRICE_TYPE Character(1) VARCHAR2(1) NOT NULL Base Price Type
    C=Contract
    I=Item Std
    R=RFQ
    U=User
    V=Supplier Std
    9 ADJ_TBL_UOM_FLG Character(1) VARCHAR2(1) NOT NULL UOM Adjustment
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    11 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
    12 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    13 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
    14 ADJ_TYPE_OTHER Character(50) VARCHAR2(50) NOT NULL Other Adjustment Type
    15 ADJ_METH Character(1) VARCHAR2(1) NOT NULL Adjustment Method
    A=Amount
    P=Percentage

    Default Value: A

    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 ADJ_AMT Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjustment Amount
    18 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    19 ADJ_AMT_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Adjustment Amount - Base
    20 ADJ_PCT Signed Number(11,4) DECIMAL(9,4) NOT NULL Adjust Percentage
    21 ADJ_PCT_TYPE Character(3) VARCHAR2(3) NOT NULL Price To Base Percentage On
    INC=Calculated
    SUM=Base

    Default Value: SUM

    22 APPLY_ADJ Character(1) VARCHAR2(1) NOT NULL Apply Adjustment
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    23 NOT_APPLY_REASON Character(50) VARCHAR2(50) NOT NULL Why Adjustment Not Applied
    24 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
    25 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
    26 X_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Supplier Set ID

    Prompt Table: SP_SETID_NONVW

    27 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier

    Prompt Table: VNDR_VNDSET_VW

    28 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location

    Prompt Table: VNDR_VNDSET_VW

    29 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
    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_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
    32 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
    33 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
    34 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
    35 FLAT_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    36 PCT_VALUE Signed Number(9,2) DECIMAL(7,2) NOT NULL Percentage of Value
    37 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    38 MISC_CHARGE_ORIGN Character(1) VARCHAR2(1) NOT NULL Misc Charge Origin
    A=Allocated
    C=Calculated
    M=Entered
    39 UNIT_PRICE_LC Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price -Landed Cost
    40 SALETX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Sales Tax
    41 USETAX_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Use Tax
    42 VAT_NRCVR_PRO_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Non-Recoverable VAT
    43 VAT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate VAT
    44 FRGHT_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Freight Charges
    45 MISC_PRORATE_FLG Character(1) VARCHAR2(1) NOT NULL Prorate Miscellaneous Charge
    46 ACTUAL_CHRG_FLG Character(1) VARCHAR2(1) NOT NULL Actual Charges Flag
    47 LC_RTV_CREDIT Character(1) VARCHAR2(1) NOT NULL Return to Vendor for Credit
    48 RATE_DATE Date(10) DATE Exchange Rate Date
    49 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

    50 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

    Default Value: 1

    51 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

    Default Value: 1