1. Tables and Views for Financials
  2. JG_FSCL_TAX_LINES_INT

JG_FSCL_TAX_LINES_INT

This table contains tax lines associated with the incoming fiscal document.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

JG_FSCL_TAX_LINES_INT_PK

INTERFACE_TAX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
INTERFACE_TAX_LINE_ID NUMBER 18 Yes Interface line identifier corresponding to the tax line during import of transactions into Receivables. Active
TRX_NUMBER NUMBER Yes Numeric identifier of a transaction. Active
TRX_LINE_NUMBER NUMBER 18 Yes Numeric identifier of a transaction line. Active
APP_SHORT_NAME VARCHAR2 30 Yes Application short name of the transaction. 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_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
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 NUMBER 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 Taxable basis percentage taxpayer operation. Active
TAXABLE_BASIS_PERC_PAYER_OPR NUMBER Percentage by which taxable amount should be reduced for tax calculation. Active
CITY_CODE VARCHAR2 30 Unique code provided by tax authority for a compactly settled area as distinguished from surrounding rural territory. 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 Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 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
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. 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
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
TAX_LINE_NUMBER NUMBER Yes Tax line identifier for the document header which summarizes the tax details applied on the document lines. Active
INTERFACE_ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction line interface table. 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 Y or N indicates if the transaction line amount includes tax amount. Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Certificate number associated with a tax exemption. Active
INTERFACE_HDR_ID NUMBER 18 Yes Interface header identifier of the document. Active
INTERFACE_LINE_ID NUMBER 18 Yes Interface line identifier corresponding to the transaction line during import of transactions. 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.
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.

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_TAX_LINES_INT_N1 Non Unique FUSION_TS_TX_IDX APP_SHORT_NAME, ENTITY_CODE, EVENT_CLASS_CODE, TRX_LEVEL_TYPE Active
JG_FSCL_TAX_LINES_INT_U1 Unique FUSION_TS_TX_IDX INTERFACE_TAX_LINE_ID Active