DW_GIC_FUN_TRX_TYPES_D

This table contains the intercompany transaction types defined

Details

Module:

Key Columns

TRX_TYPE_ID

Columns

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.    

Copyright © 2019, 2026, Oracle and/or its affiliates.