DW_GIC_FUN_TRX_TYPES_D (Preview)
This table requires activation of Global Intercompany functional area. This table contains the intercompany transaction types defined
Details
Module:
Key Columns
TRX_TYPE_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TRX_TYPE_ID | NUMBER | 38 | 0 | True | Transaction type unique identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source record identifier. | ||||
| TRX_TYPE_CODE | VARCHAR2 | 16 | Intercompany transaction type code. | ||||
| ALLOW_INTEREST_ACCRUAL_FLAG | VARCHAR2 | 16 | Allow interest accrual flag for the intercompany transaction type. | ||||
| ALLOW_INVOICING_FLAG | VARCHAR2 | 16 | Allow invoicing flag for the intercompany transaction type. | ||||
| CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| DFF_TRANSFER_FLAG | VARCHAR2 | 16 | Indicates whether descriptive flexfields are to be transferred to Payables and Receivables. | ||||
| ENABLED_FLAG | VARCHAR2 | 16 | Enabled flag for the intercompany transaction type. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| MANUAL_APPROVE_FLAG | VARCHAR2 | 16 | Manual approval flag for the intercompany transaction type. | ||||
| MASTER_INTERCO_TRX_FLAG | VARCHAR2 | 16 | Identifies whether the transaction is a master intercompany transaction. | ||||
| VAT_TAXABLE_FLAG | VARCHAR2 | 16 | VAT taxable flag for the intercompany transaction type. |