RTBL_XMLP_AET(SQL Table) |
Index Back |
|---|---|
PS/Financials XMLP State Rec |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 3 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 4 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 8 | SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. |
| 9 | FROM_DATE | Date(10) | DATE | From Date |
| 10 | TO_DATE | Date(10) | DATE | To Date |
| 11 | JOURNAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Journal Status
E=Journal Has Errors J=Posted (by journal dates) N=No Status - Needs to be Edited P=Posted (by posting dates) U=Unposted V=Valid Journal - Edits Complete |
| 12 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 13 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 14 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 15 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 16 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 17 | KK_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 18 | BUSINESS_UNIT_IU | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Business Unit for which InterUnit activity is being generated. |
| 19 | 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. |
| 20 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 21 | SEPARATE_DRCR | Character(1) | VARCHAR2(1) NOT NULL | Enable Separate Debit/Credit |
| 22 | SCE_ID | Character(10) | VARCHAR2(10) NOT NULL | ID |
| 23 | RTBL_SCENARIO | Character(18) | VARCHAR2(18) NOT NULL | Scenario Name |