RPTG_X_GL_TAO

(SQL Table)
Index Back

Rptg Xref-GL, AE Tmp

  • 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: GL

    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 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
    8 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
    9 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
    10 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
    11 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger