PO_LC_CALC_VWLN

(SQL View)
 Index Back

Value Adjust Prompt View


SELECT %Substring(fieldvalue, 1, 3) , language_cd , xlatlongname FROM PSXLATITEMLANG WHERE FIELDNAME = 'LC_COMP_CALC' AND FIELDVALUE NOT IN ('STX','UTX','TBL','FRT','VAT')

  • Related Language Record for PO_LC_CALC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name