VAT_BI_IDEN2LVW

(SQL View)
 Index Back

Bill Line Identifier Prompt


SELECT DISTINCT A.SETID , B.DISC_SUR_INDICATOR , A.DISC_SUR_ID , A.LANGUAGE_CD , A.DESCR FROM PS_BI_DISC_SUR_LNG A ,PS_BI_DISC_SUR B WHERE A.SETID = B.SETID AND A.BI_CURRENCY_CD = B.BI_CURRENCY_CD AND A.DISC_SUR_ID = B.DISC_SUR_ID AND A.EFFDT = B.EFFDT AND B.DISC_SUR_INDICATOR = 'D'

  • Related Language Record for VAT_BI_IDEN2_VW VAT_BI_IDEN4_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 IDENTIFIER_TBL Character(3) VARCHAR2(3) NOT NULL Table Identifier
    A=Asset ID
    CON=Contracts
    D=Discount Table
    G=Generic Identifier
    ID=PS/Billing Charge Id
    ITM=PS/Inventory Item ID
    LAB=Labor type
    PDA=Product Alias
    PRD=PS/Product Id
    PRM=PS/Promotion Code
    S=Surcharge Table
    SVC=Service
    UPC=UPC
    UPN=Universal Item ID
    3 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description