RPTG_X_ARMI_TAO

(SQL Table)
Index Back

Reporting Xref to AR

  • Parent record: RPTG_DETAIL_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 RPTG_APPL_ID Character(3) VARCHAR2(3) NOT NULL Reporting Application
    AP=Accounts Payable
    AR=Accounts Receivable
    BI=Billing
    EX=Expenses

    Default Value: AR

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    5 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.
    6 RPTG_DETAIL_SEQ Number(6,0) INTEGER NOT NULL Reporting Detail Line
    7 BUSINESS_UNIT_TXN Character(5) VARCHAR2(5) NOT NULL Transaction Business Unit
    8 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    9 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
    10 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
    11 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence