BI_SCHEDULE

(SQL Table)
 Index Back

Recurring Bill Schedule

  • Parent record: BI_HDR

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

    Prompt Table: SP_BU_BI_NONVW

    2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

    Prompt Table: BI_HDR

    3 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.

    Default Value: 1

    4 EVENT_DT Date(10) DATE The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
    5 INVOICE_DT Date(10) DATE Invoice Date
    6 BI_HDR_FROM_DT Date(10) DATE Bill Header From Date
    7 BI_HDR_TO_DT Date(10) DATE Bill Header To Date
    8 GENERATED_FLAG Character(1) VARCHAR2(1) NOT NULL Recurring Bill Generated Flag

    Y/N Table Edit

    Default Value: N

    9 GENERATED_INVOICE Character(22) VARCHAR2(22) NOT NULL Generated Invoice

    Default Value: NEXT

    10 GENERATED_DATE Date(10) DATE Generated Date
    11 CPY_STATUS Character(3) VARCHAR2(3) NOT NULL Copy Status
    12 PRIOR_CPY_INVOICE Character(22) VARCHAR2(22) NOT NULL Prior Copy Invoice Id
    13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    14 AUTO_GEN_LN_DT Character(1) VARCHAR2(1) NOT NULL Use Header Dates For Lines

    Y/N Table Edit

    Default Value: N

    15 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    16 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.
    17 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID