BI_BILL_BY

(SQL Table)
Index Back

Billing Bill By Identifier

  • Related Language Record: BI_BILL_BY_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL Bill By Identifier

    Prompt Table: BI_BILL_BY

    2 STATUS_BI Character(1) VARCHAR2(1) NOT NULL Status
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
    CAN=Canceled
    FNL=Finalized Bill
    HLD=Hold Bill
    INV=Invoiced Bill
    NEW=New Bill
    PND=Pending Approval
    RDY=Ready to Invoice
    TMP=Temporary Bill
    TMR=Temporary Ready Bill

    Default Value: NEW

    6 NEW_ALLOWED Character(1) VARCHAR2(1) NOT NULL New Allowed

    Y/N Table Edit

    Default Value: Y

    7 HOLD_ALLOWED Character(1) VARCHAR2(1) NOT NULL Hold Allowed

    Y/N Table Edit

    Default Value: N

    8 PENDING_ALLOWED Character(1) VARCHAR2(1) NOT NULL Pending Allowed

    Y/N Table Edit

    Default Value: N

    9 READY_ALLOWED Character(1) VARCHAR2(1) NOT NULL Ready Allowed

    Y/N Table Edit

    Default Value: N

    10 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    11 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID