1. Tables and Views for Financials
  2. JG_FSCL_TAX_LINES_ALL

JG_FSCL_TAX_LINES_ALL

This table stores tax lines of the inbound fiscal document after validation.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_TAX_LINES_PK

TAX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TAX_LINE_ID NUMBER 18 Yes Identifier for a particular tax line in a table. Active
APPLICATION_ID NUMBER 18 Yes Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction, which indicates the type of transaction being created. Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction, such as requisition, purchase order and agreement, and release. Active
TRX_ID NUMBER 18 Yes System-generated identification number of a transaction. Active
TRX_LINE_ID NUMBER 18 Yes Transaction line identifier of the transaction. Active
TRX_LEVEL_TYPE VARCHAR2 30 Yes Level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
TAX VARCHAR2 30 Yes Tax code for the classification of a charge imposed by a government through a fiscal or tax authority. Active
TAX_ID NUMBER 18 Yes Tax identifier for the classification of a charge imposed by a government through a fiscal or tax authority. Active
TAXABLE_AMT NUMBER Yes Amount in entered currency on which the tax rate is applied to calculate the tax amount. Active
TAX_RATE_CODE VARCHAR2 30 Yes Tax rate code specified for a tax status for an effective time period, expressed as a percentage or a value per unit quantity. Active
TAX_RATE_ID NUMBER 18 Yes Identifier for the rate specified for a tax status for an effective time period. Active
TAX_RATE NUMBER Yes Rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity. Active
QUANTITY NUMBER Exact or specified amount or measure. Active
UOM_CODE VARCHAR2 30 Unit of measure code for quantity based rates. Active
TAX_AMT NUMBER Yes Tax amount associated with the tax distribution. Active
EXEMPT_REASON_CODE VARCHAR2 30 Reason code for a tax exemption. Active
VALUE_ADDED_MARGIN_PERC NUMBER Value added margin percentage for the tax. Active
TAXABLE_BASIS_REDUCTION_PERC NUMBER Percentage by which taxable amount should be reduced for tax calculation. Active
TAXABLE_BASIS_PERC_PAYER_OPR NUMBER Taxable basis percentage taxpayer operation. Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code for a geographic area where a tax is levied by a specific tax authority. Active
SERVICE_ITEM_CODE VARCHAR2 30 Item bought or sold in the associated transaction, which may be a tangible item or an intangible item such as a service. Active
REPORTING_TYPE_CODE VARCHAR2 30 Code for a tax reporting type that identifies specific units of information, such as dates or text comments, to associate with specific tax usage. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
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. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
TAX_LINE_NUMBER NUMBER Yes Line number to uniquely identify this imported tax line. Active
INTERFACE_ENTITY_CODE VARCHAR2 30 Oracle internal use only. Active
INTERFACE_TAX_LINE_ID NUMBER 18 Interface line identifier corresponding to the tax line during import of transactions into Receivables. Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code for the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. Active
TAX_STATUS_CODE VARCHAR2 30 Tax status code for the taxable nature of a product in the context of a transaction for a tax. Active
TAX_AMT_INCLUDED_FLAG VARCHAR2 1 Oracle internal use only. Active
TAX_EXCEPTION_ID NUMBER 18 Identifier of the tax exception used in determination of the effective tax rate. Active
TAX_EXEMPTION_ID NUMBER 18 Identifier of the tax exemption used in determination of the effective tax rate. Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Certificate number associated with a tax exemption. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
CITY_CODE VARCHAR2 30 Unique code provided by the tax authority for a compactly settled area as distinguished from the surrounding rural territory.
TAXABLE_AMT_DETERM_CODE VARCHAR2 30 Code used for tax reporting purposes that represents the type of taxable basis amount determination.
TAX_SITUATION_CODE VARCHAR2 30 Code used for tax reporting purposes that represents the tax situation.
MAIN_TRX_LINE_ID NUMBER 18 Transaction line identifier of the transaction that was divided into multiple lines.
TAX_CREDIT_AMOUNT NUMBER Tax credit amount informed by city tax authority. In some cases, this tax credit amount can be deducted by tax payer from other city taxes.
CAL_TAX_AMT NUMBER System calculated tax amount in transaction currency.
USER_ENTERED_TAX_AMT NUMBER User entered tax amount in transaction currency if tax calculation is not correct.
TAX_LINE_SOURCE_CODE VARCHAR2 30 Identifies the source of tax line. Valid values are Manually Created, Imported or System Generated.
TAX_HOLD_CODE NUMBER Indicates reason for hold on the tax line. Possible values are 1 for tax variance hold, 2 for tax amount range hold and 3 for both.
CONTENT_OWNER_ID NUMBER 18 Party tax profile identifier for the first party organization of the transaction.
TAX_REGIME_ID NUMBER 18 Identifier of tax regime associated with the tax line.
TAX_STATUS_ID NUMBER 18 Identifier of tax status associated with the tax line.
TAX_JURISDICTION_ID NUMBER 18 Identifier of tax jurisdiction associated with the tax line.
TAX_ONLY_LINE_FLAG VARCHAR2 1 Indicates if the transaction is only for tax. Select Y if the line is only for tax and is not related to other item lines of the transaction.
ADJUSTED_TAX_LINE_ID NUMBER 18 Tax line identifier from adjusted document.
CAL_TAX_AMT_TAX_CURR NUMBER System calculated tax amount in tax currency. This is same as the tax amount in tax currency if there is no user override.
TAX_AMT_TAX_CURR NUMBER Amount associated with tax line in tax currency.
USER_ENTERED_TAX_AMT_TAX_CURR NUMBER User entered tax amount in tax currency if tax calculation is not correct.
ORIG_TAX_STATUS_ID NUMBER 18 Value of tax status identifier present prior to user override.
ORIG_TAX_STATUS_CODE VARCHAR2 30 Value of tax status code present prior to user override.
ORIG_TAX_RATE_ID NUMBER 18 Value of tax rate identifier present prior to user override.
ORIG_TAX_RATE_CODE VARCHAR2 150 Value of tax rate code present prior to user override.
ORIG_TAX_RATE NUMBER Value of tax rate present prior to user override.
ORIG_TAX_JURISDICTION_ID NUMBER 18 Value of tax jurisdiction identifier present prior to user override.
ORIG_TAX_JURISDICTION_CODE VARCHAR2 30 Value of tax jurisdiction code present prior to user override.
ORIG_TAX_AMT_INCLUDED_FLAG VARCHAR2 1 Inclusive tax amount calculated by the application, prior to user updates.
ORIG_SELF_ASSESSED_FLAG VARCHAR2 1 Self-assessed tax amount calculated by the application, prior to user updates.
REFERENCE_DOC_UNIT_PRICE NUMBER Identifies the reference document unit price.
REFERENCE_DOC_LINE_AMT NUMBER Identifies the reference document line amount.
SELF_ASSESSED_FLAG VARCHAR2 1 Indicates if the tax line is self-assessed. Select Y if the tax line is self-assessed by the first party organization.
REPORTING_ONLY_FLAG VARCHAR2 1 Indicates whether this tax line is created for reporting only. Valid vaules: Y and N.

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_TAX_LINES_N1 Non Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE Active
JG_FSCL_TAX_LINES_U1 Unique FUSION_TS_TX_IDX TAX_LINE_ID Active