RTBL_CLSN_TR_B(SQL Table) |
Index Back |
|---|---|
RTBL Closing Trial BalanceRTBL Closing Trial Balance |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | SCE_ID | Character(10) | VARCHAR2(10) NOT NULL | ID |
| 5 | RTBL_SCENARIO | Character(18) | VARCHAR2(18) NOT NULL | Scenario Name |
| 6 | ACCOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue. |
| 7 | ACCOUNT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Account Description |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 10 | YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Year
1=NONE |
| 11 | DATE_CHAR | Character(26) | VARCHAR2(26) NOT NULL | Generic space field |
| 12 | TIMESTAMPFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Row Level TimeStamp Field Name |
| 13 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 14 | POSTED_TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination. |
| 15 | POSTED_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the total monetary amount of all pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total. |
| 16 | POSTED_TOTAL_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Total Credits |
| 17 | POSTED_TOTAL_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Total Debits |
| 18 | POSTED_TOTAL_EBAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted total ending balance. |
| 19 | DATA_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Data Source
820=820 ANSI-X12 APP=Accounts Payable Payment BST=Bank Statement CDR=Cash Drawer Receipts CRX=EDIFACT CREEXT LBX=Lockbox ONL=Online XEL=Excel Upload |