RPTG_X_GL_TAO(SQL Table) |
Index Back |
---|---|
Rptg Xref-GL, AE Tmp |
# | 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 |