FUN_TRANSFERS
This is a temporary table that is used by the Intercompany Transfer to General Ledger, Intercompany Transfer to Payables, and Intercompany Transfer to Receivables processes.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FUN_TRANSFERS_PK |
TRX_ID, PARTY_TYPE_FLAG |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| BATCH_ID | NUMBER | 18 | Yes | Unique system generated identifier for the batch. | |
| BATCH_NUMBER | VARCHAR2 | 20 | Number assigned to the intercompany batch. | ||
| TRX_ID | NUMBER | 18 | Yes | Unique system generated identifier for the transaction. | |
| TRX_NUMBER | NUMBER | Number of the transaction in the batch. | |||
| LEDGER_ID | NUMBER | 18 | Unique system generated identifier for the ledger. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Name of the ledger the intercompany batch will be posted to. | ||
| PARTY_TYPE_FLAG | VARCHAR2 | 1 | Yes | Flag indicating the party type of the row when transferring intercompany transactions | |
| TRX_STATUS | VARCHAR2 | 30 | Status of the intercompany transaction. | ||
| PROCESS_MESG | VARCHAR2 | 30 | Status of the intercompany row being processed. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Chart of accounts structure identifier. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Name of the period for the intercompany transfer. | ||
| BU_ID | NUMBER | 18 | Unique system generated identifier for the business unit. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_TRANSFERS_N1 | Non Unique | Default | REQUEST_ID |
| FUN_TRANSFERS_U1 | Unique | Default | TRX_ID, PARTY_TYPE_FLAG |