CE_CP_SYS_TRX_INT
This interface table contains the system transaction.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CE_CP_SYS_TRX_INTERFACE_PK |
CP_SYS_TRX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CP_SYS_TRX_ID | NUMBER | 18 | Yes | Sequentially generated surrogate key for the system transaction interface table. | |
| SOURCE_SYSTEM | VARCHAR2 | 50 | Instance of the source. Valid values are FUSION, EBS or OTHER. | ||
| SOURCE | VARCHAR2 | 30 | Source of transaction. For example, accounts receivable receipts, accounts payable payments, payrolls, external cash transactions and bank statements. | ||
| FLOW_INDICATOR | VARCHAR2 | 15 | Flow indicator of the transaction. Valid values are Inflow or Outflow. | ||
| RECON_STATUS | VARCHAR2 | 30 | Reconciliation Status of the transaction. Valid values are Reconciled, Unreconciled or Not Applicable. | ||
| SOURCE_TRANSACTION_ID | NUMBER | 18 | Foreign key to the system transaction. | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | 360 | Name assigned to a bank account for identification purposes. | ||
| BANK_ACCOUNT_NUMBER | VARCHAR2 | 80 | Number of the bank account used by the deploying company. | ||
| BANK_NAME | VARCHAR2 | 360 | Name of the bank of the system transaction. | ||
| TRANSACTION_DATE | DATE | Transaction date of the system transaction. | |||
| VALUE_DATE | DATE | Value date of the system transaction. | |||
| TRANSACTION_NUMBER | VARCHAR2 | 256 | Transaction number of the system transaction. | ||
| TRANSACTION_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the system transaction. | ||
| TRANSACTION_AMOUNT | NUMBER | Transaction amount of the system transaction. | |||
| REPORTING_AMOUNT | NUMBER | Transaction amount in reporting currency. | |||
| TRANSACTION_TYPE | VARCHAR2 | 80 | Transaction type of the system transaction. | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 15 | Ledger currency code of the system transaction. | ||
| FUNCTIONAL_AMOUNT | NUMBER | Ledger currency code of the system transaction. | |||
| BANK_ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the bank account. | ||
| BANK_ACCT_AMOUNT | NUMBER | Amount in bank account currency. | |||
| LEGAL_ENTITY_REGION | VARCHAR2 | 360 | Name of the legal entity region for the transaction. | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | 240 | Name of the legal entity of the system transaction. | ||
| CASH_POOL_NAME | VARCHAR2 | 80 | Name of the cash pool dimension member | ||
| PARENT_CASH_POOL_NAME | VARCHAR2 | 250 | Fully qualified dimension member name of the parent cash pool | ||
| EXT_DIM_ATTRIBUTE1 | VARCHAR2 | 80 | Extensible Dimension Attribute 1 | ||
| EXT_DIM_ATTRIBUTE2 | VARCHAR2 | 80 | Extensible Dimension Attribute 2 | ||
| EXT_DIM_ATTRIBUTE3 | VARCHAR2 | 80 | Extensible Dimension Attribute 3 | ||
| EXT_DIM_ATTRIBUTE4 | VARCHAR2 | 80 | Extensible Dimension Attribute 4 | ||
| EXT_DIM_ATTRIBUTE5 | VARCHAR2 | 80 | Extensible Dimension Attribute 5 | ||
| EXT_DIM_ATTRIBUTE6 | VARCHAR2 | 80 | Extensible Dimension Attribute 6 | ||
| EXT_DIM_ATTRIBUTE7 | VARCHAR2 | 80 | Extensible Dimension Attribute 7 | ||
| EXT_DIM_ATTRIBUTE8 | VARCHAR2 | 80 | Extensible Dimension Attribute 8 | ||
| EXT_DIM_ATTRIBUTE9 | VARCHAR2 | 80 | Extensible Dimension Attribute 9 | ||
| EXT_DIM_ATTRIBUTE10 | VARCHAR2 | 80 | Extensible Dimension Attribute 10 | ||
| EXT_DIM_ATTRIBUTE11 | VARCHAR2 | 80 | Extensible Dimension Attribute 11 | ||
| EXT_DIM_ATTRIBUTE12 | VARCHAR2 | 80 | Extensible Dimension Attribute 12 | ||
| EXT_DIM_ATTRIBUTE13 | VARCHAR2 | 80 | Extensible Dimension Attribute 13 | ||
| EXT_DIM_ATTRIBUTE14 | VARCHAR2 | 80 | Extensible Dimension Attribute 14. | ||
| EXT_DIM_ATTRIBUTE15 | VARCHAR2 | 80 | Extensible Dimension Attribute 15 | ||
| DELETE_FLAG | VARCHAR2 | 1 | Represents a deleted transaction from the source. Valid values are Yes or No. | ||
| ERROR_FLAG | VARCHAR2 | 1 | Indicates if there is a validation error for this record. | ||
| ERROR_CODE | VARCHAR2 | 30 | Error code of the validation error. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Request ID of the interface load job that created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_CP_SYS_TRX_INT_N1 | Non Unique | FUSION_TS_INTERFACE | SOURCE_TRANSACTION_ID, SOURCE, SOURCE_SYSTEM |
| CE_CP_SYS_TRX_INT_U1 | Unique | FUSION_TS_TX_DATA | CP_SYS_TRX_ID |