BI_MSG_AGE_TBL

(SQL Table)
Index Back

Billing MSG Item Table

  • Parent Record Of BI_BILL_MSG_AGE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 AGING_SET Character(5) VARCHAR2(5) NOT NULL Aging Set

    Prompt Table: AGING_TBL

    3 AGE_CATEGORY Character(2) VARCHAR2(2) NOT NULL Aging Category

    Prompt Table: AGING_CAT_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A