BI_IVC_NUM_VW

(SQL View)
 Index Back

Billing Invoice Numbering

View of BI_IVC_NUM showing only active records

SELECT IVC_NUM_ID , DESCR FROM PS_BI_IVC_NUM WHERE STATUS = 'A'

  • Related Language Record: BI_IVC_NUM_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IVC_NUM_ID Character(8) VARCHAR2(8) NOT NULL Invoice ID Number
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description