FUS_GL_XFR_INTF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYSTEM_ID | Number(18,0) | DECIMAL(18) NOT NULL | Peoplesoft System ID |
| 2 | TRANSFER_ID | Number(18,0) | DECIMAL(18) NOT NULL | Transfer ID |
| 3 | INTERFACE_ROW_NUM | Number(18,0) | DECIMAL(18) NOT NULL | Interface Journal Line No |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 6 | FUS_LEDGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Fusion Ledger Name |
| 7 | COA_MAPPING_NAME | Character(33) | VARCHAR2(33) NOT NULL | Fusion COA Mapping Name |
| 8 | 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. |
| 9 | FUS_STATUS_CODE | Character(30) | VARCHAR2(30) NOT NULL | Status Code |
| 10 | ACCOUNTING_DATE | Date(10) | DATE | ACCOUNTING_DATE |
| 11 | FUS_ACCTG_PERIOD | Character(15) | VARCHAR2(15) NOT NULL | Fusion Acct Period |
| 12 | FUS_PERIOD_NAME | Character(15) | VARCHAR2(15) NOT NULL | Fusion Period Name |
| 13 | CURRENCY_CODE | Character(10) | VARCHAR2(10) NOT NULL | CURRENCY_CODE |
| 14 | CURRENCY_CONV_DATE | Date(10) | DATE | Currency Conversion Date |
| 15 | USER_CUR_CONV_TYPE | Character(30) | VARCHAR2(30) NOT NULL | User Currency Conversion Type |
| 16 | CURRENCY_CONV_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | Currency Conversion rate |
| 17 | SEGMENT1 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT1 |
| 18 | SEGMENT2 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT2 |
| 19 | SEGMENT3 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT3 |
| 20 | SEGMENT4 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT4 |
| 21 | SEGMENT5 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT5 |
| 22 | SEGMENT6 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT6 |
| 23 | SEGMENT7 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT7 |
| 24 | SEGMENT8 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT8 |
| 25 | SEGMENT9 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT9 |
| 26 | SEGMENT10 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT10 |
| 27 | SEGMENT11 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT11 |
| 28 | SEGMENT12 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT12 |
| 29 | SEGMENT13 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT13 |
| 30 | SEGMENT14 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT14 |
| 31 | SEGMENT15 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT15 |
| 32 | SEGMENT16 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT16 |
| 33 | SEGMENT17 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT17 |
| 34 | SEGMENT18 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT18 |
| 35 | SEGMENT19 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT19 |
| 36 | SEGMENT20 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT20 |
| 37 | SEGMENT21 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT21 |
| 38 | SEGMENT22 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT22 |
| 39 | SEGMENT23 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT23 |
| 40 | SEGMENT24 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT24 |
| 41 | SEGMENT25 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT25 |
| 42 | SEGMENT26 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT26 |
| 43 | SEGMENT27 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT27 |
| 44 | SEGMENT28 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT28 |
| 45 | SEGMENT29 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT29 |
| 46 | SEGMENT30 | Character(25) | VARCHAR2(25) NOT NULL | SEGMENT30 |
| 47 | FUS_PSFT_CCID | Number(18,0) | DECIMAL(18) NOT NULL | Fusion PSFT CCID |
| 48 | FUS_PSFT_COMBO | Long Character(750) | VARCHAR2(750) | Fusion PSFT Combo |
| 49 | ENTERED_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | ENTERED_DR |
| 50 | ENTERED_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | ENTERED_CR |
| 51 | ACCOUNTED_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | ACCOUNTED_DR |
| 52 | ACCOUNTED_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | ACCOUNTED_CR |
| 53 | REFERENCE1 | Character(100) | VARCHAR2(100) NOT NULL | REFERENCE1 |
| 54 | REFERENCE2 | Character(240) | VARCHAR2(240) NOT NULL | Reference2 |
| 55 | REFERENCE3 | Character(100) | VARCHAR2(100) NOT NULL | Reference3 |
| 56 | REFERENCE4 | Character(100) | VARCHAR2(100) NOT NULL | REFERENCE4 |
| 57 | REFERENCE5 | Character(240) | VARCHAR2(240) NOT NULL | Reference5 |
| 58 | REFERENCE6 | Character(100) | VARCHAR2(100) NOT NULL | Reference6 |
| 59 | REFERENCE7 | Character(100) | VARCHAR2(100) NOT NULL | Reference7 |
| 60 | REFERENCE8 | Character(100) | VARCHAR2(100) NOT NULL | Reference8 |
| 61 | REFERENCE9 | Character(100) | VARCHAR2(100) NOT NULL | Reference9 |
| 62 | REFERENCE10 | Character(240) | VARCHAR2(240) NOT NULL | Reference10 |
| 63 | REFERENCE11 | Character(240) | VARCHAR2(240) NOT NULL | Reference11 |
| 64 | REFERENCE12 | Character(100) | VARCHAR2(100) NOT NULL | Reference12 |
| 65 | REFERENCE13 | Character(100) | VARCHAR2(100) NOT NULL | Referecne13 |
| 66 | REFERENCE14 | Character(100) | VARCHAR2(100) NOT NULL | Reference14 |
| 67 | REFERENCE15 | Character(100) | VARCHAR2(100) NOT NULL | Reference15 |
| 68 | REFERENCE16 | Character(100) | VARCHAR2(100) NOT NULL | Reference16 |
| 69 | REFERENCE17 | Character(100) | VARCHAR2(100) NOT NULL | Reference17 |
| 70 | REFERENCE18 | Character(100) | VARCHAR2(100) NOT NULL | Reference18 |
| 71 | REFERENCE19 | Character(100) | VARCHAR2(100) NOT NULL | Reference19 |
| 72 | REFERENCE20 | Character(100) | VARCHAR2(100) NOT NULL | Reference20 |
| 73 | REFERENCE21 | Character(240) | VARCHAR2(240) NOT NULL | Reference21 |
| 74 | REFERENCE22 | Character(240) | VARCHAR2(240) NOT NULL | Reference22 |
| 75 | REFERENCE23 | Character(240) | VARCHAR2(240) NOT NULL | Reference23 |
| 76 | REFERENCE24 | Character(240) | VARCHAR2(240) NOT NULL | Reference24 |
| 77 | REFERENCE25 | Character(240) | VARCHAR2(240) NOT NULL | Reference25 |
| 78 | REFERENCE26 | Character(240) | VARCHAR2(240) NOT NULL | Reference26 |
| 79 | REFERENCE27 | Character(240) | VARCHAR2(240) NOT NULL | Reference27 |
| 80 | REFERENCE28 | Character(240) | VARCHAR2(240) NOT NULL | Reference28 |
| 81 | REFERENCE29 | Character(240) | VARCHAR2(240) NOT NULL | Reference29 |
| 82 | REFERENCE30 | Character(240) | VARCHAR2(240) NOT NULL | Reference30 |