RPTG_XREF_BI

(SQL Table)
Index Back

Reporting Xref to Billing

  • Parent record: RPTG_DETAIL_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RPTG_APPL_ID Character(3) VARCHAR2(3) NOT NULL Reporting Application
    AP=Accounts Payable
    AR=Accounts Receivable
    BI=Billing
    EX=Expenses

    Default Value: BI

    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    5 RPTG_DETAIL_SEQ Number(6,0) INTEGER NOT NULL Reporting Detail Line
    6 BUSINESS_UNIT_TXN Character(5) VARCHAR2(5) NOT NULL Transaction Business Unit
    7 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    8 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
    9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    10 ACCT_ENTRY_TYPE Character(3) VARCHAR2(3) NOT NULL Account Entry Type
    11 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
    12 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
    13 LINE_DST_SEQ_NUM Number(3,0) SMALLINT NOT NULL Revenue Sequence Number
    14 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
    15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance