VAT_IDEN_GR3_VW

(SQL View)
 Index Back

BI Line Identifier Group View3


SELECT a.setid , 'ITM' , a.INV_ITEM_group , a.descr FROM PS_INV_ITEM_GROUP A WHERE %EffdtCheck(INV_ITEM_GROUP B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: VAT_IDENGR3_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IDEN_GRP_SETID Character(5) VARCHAR2(5) NOT NULL Product Group 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_GROUP Character(15) VARCHAR2(15) NOT NULL Identifier
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description