1. Tables and Views for Financials
  2. FLA_TAX_TRANSACTIONS

FLA_TAX_TRANSACTIONS

FLA_TAX_TRANSACTIONS contains the tax transaction details for the payment.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FLA_TAX_TRANSACTIONS_PK

TAX_TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
TAX_TRANSACTION_ID NUMBER 18 Yes Payment tax transaction identifier. This is primary key for the table.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LEASE_ID NUMBER 18 Yes Lease identifier from FLA_LEASES_ALL table.
LEASE_DETAIL_ID NUMBER 18 Yes Lease details identifier which is referenced.
PAYMENT_NUMBER VARCHAR2 30 Yes Payment number. Tax transactions are created for this Payment.
REGIME_CODE VARCHAR2 30 Yes Regime code. This drives the accounting model and reporting for the lease.
TAX_REGIME_CODE VARCHAR2 30 Yes Tax regime code for the tax rate.
TAX VARCHAR2 30 Yes Tax for which the rate is defined.
VERSION_NUM NUMBER 9 Yes Version number of the lease as captured in FLA_LEASE_DETAILS.
TRANSACTION_TYPE_CODE VARCHAR2 30 Yes Transaction type. Possible values are RECOVERABLE and NONRECOVERABLE.
TRANSACTION_DATE DATE Yes Indicates the Transaction date.
COMMENCEMENT_DATE DATE Indicates the commencement date.
PRIOR_TAX_AMOUNT NUMBER Indicates the prior tax amount.
FORECASTED_TAX_AMOUNT NUMBER Indicates the forecasted tax amount.
ADJUSTED_TAX_AMOUNT NUMBER Indicates the adjusted tax amount.
ACCOUNTED_FLAG VARCHAR2 1 Flag to indicate that the accounting is processed.
REVERSAL_FLAG VARCHAR2 1 Indicates if the transaction is reversed or pending for reversal.
ACTIVE_FLAG VARCHAR2 1 Indicates if the tax transaction is active or not.
REGENERATE_SCHEDULES_FLAG VARCHAR2 1 Indicates if the schedules need to be regenerated.
PARENT_RECORD_ID NUMBER 18 Contains parent tax transaction identifier.
INCLUDE_IN_ROU_FLAG VARCHAR2 1 Indicates if the amount is included in Right of Use or not.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CURRENCY_CODE VARCHAR2 15 Attribute indicating tax payment currency code.
EFFECTIVE_TAX_RATE NUMBER Effective Tax rate which is calculated.
PAYMENT_TAX_LINE_NUMBER VARCHAR2 30 Yes Payment tax line number. This is generated by system using a document sequence.
TAX_RATE_ID NUMBER 18 Tax rate identifier of the selected tax rate code.
RECOVERY_TAX_RATE_ID NUMBER 18 Recovery tax rate identifier of the selected recovery tax rate code.
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code for which this rate is defined.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
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_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
FLA_TAX_TRANSACTIONS_N1 Non Unique FUSION_TS_TX_IDX PAYMENT_TAX_LINE_NUMBER, LEASE_ID
FLA_TAX_TRANSACTIONS_U1 Unique FUSION_TS_TX_IDX TAX_TRANSACTION_ID
FLA_TAX_TRANSACTIONS_U2 Unique FUSION_TS_TX_IDX LEASE_ID, VERSION_NUM, PAYMENT_NUMBER, REGIME_CODE, TRANSACTION_TYPE_CODE, TAX_REGIME_CODE, TAX