DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_LINES

Object Details
Object Name: ZX_LINES
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_LINES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnTRX_ID
ColumnTRX_LEVEL_TYPE
ColumnTRX_LINE_ID
ColumnTAX_REGIME_CODE
ColumnTAX
ColumnTAX_APPORTIONMENT_LINE_NUMBER
ZX_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_LINE_ID
ZX_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnADJUSTED_DOC_TAX_LINE_ID
ZX_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUMMARY_TAX_LINE_ID
ZX_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnLEGAL_ENTITY_ID
ColumnLEDGER_ID
ColumnTRX_DATE
ZX_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
ColumnAPPLICATION_ID
ColumnTRX_CURRENCY_CODE
ColumnTRX_LINE_ID
ZX_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_REGIME_CODE
ColumnLEDGER_ID
ColumnAPPLICATION_ID
ZX_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLIED_FROM_APPLICATION_ID
ColumnAPPLIED_FROM_ENTITY_CODE
ColumnAPPLIED_FROM_EVENT_CLASS_CODE
ColumnAPPLIED_FROM_TRX_ID
ColumnAPPLIED_FROM_LINE_ID
ColumnAPPLIED_FROM_TRX_LEVEL_TYPE
Columns
Name Datatype Length Mandatory Comments
TAX_LINE_ID NUMBER (15) Yes Tax line identifier
INTERNAL_ORGANIZATION_ID NUMBER
Yes Internal organization identifier of the transaction
APPLICATION_ID NUMBER
Yes Application identifier of the transaction
ENTITY_CODE VARCHAR2 (30) Yes Entity code of the transaction
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event class code of the transaction
EVENT_TYPE_CODE VARCHAR2 (30)
Application event type code of the transaction
TRX_ID NUMBER
Yes Transaction identifier
TRX_LINE_ID NUMBER
Yes Transaction line identifier
TRX_LEVEL_TYPE VARCHAR2 (30) Yes Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
TRX_LINE_NUMBER NUMBER

Trasnaction line number
DOC_EVENT_STATUS VARCHAR2 (30)
Lookup code that indicates event status of the transaction
TAX_EVENT_CLASS_CODE VARCHAR2 (30)
Tax event class code of the transaction
TAX_EVENT_TYPE_CODE VARCHAR2 (30)
Tax event type code of the transaction
TAX_LINE_NUMBER NUMBER
Yes Line number generated for this tax line
CONTENT_OWNER_ID NUMBER (15)
Party tax profile identifier for the first party organization of the transaction
TAX_REGIME_ID NUMBER (15)
Tax regime identifier
TAX_REGIME_CODE VARCHAR2 (30)
Tax regime code
TAX_ID NUMBER (15)
Tax identifier
TAX VARCHAR2 (30)
Tax
TAX_STATUS_ID NUMBER (15)
Tax status identifier
TAX_STATUS_CODE VARCHAR2 (30)
Tax status code
TAX_RATE_ID NUMBER (15)
Tax rate identifier
TAX_RATE_CODE VARCHAR2 (150)
Tax rate code
TAX_RATE NUMBER

Tax rate
TAX_APPORTIONMENT_LINE_NUMBER NUMBER

Apportionment line number for this tax line when multiple tax lines are created for the same tax during migration from prior releases
TRX_ID_LEVEL2 NUMBER

Transaction identifier at a level between trx_id and trx_line_id
TRX_ID_LEVEL3 NUMBER

Transaction identifier at a level between trx_id_level2 and trx_line_id
TRX_ID_LEVEL4 NUMBER

Transaction identifier at a level between trx_id_level3 and trx_line_id
TRX_ID_LEVEL5 NUMBER

Transaction identifier at a level between trx_id_level4 and trx_line_id
TRX_ID_LEVEL6 NUMBER

Transaction identifier at a level between trx_id_level5 and trx_line_id
TRX_USER_KEY_LEVEL1 VARCHAR2 (150)
First component of the user composite key to uniquely identify the transaction
TRX_USER_KEY_LEVEL2 VARCHAR2 (150)
Second component of the user composite key to uniquely identify the transaction
TRX_USER_KEY_LEVEL3 VARCHAR2 (150)
Third component of the user composite key to uniquely identify the transaction
TRX_USER_KEY_LEVEL4 VARCHAR2 (150)
Fourth component of the user composite key to uniquely identify the transaction
TRX_USER_KEY_LEVEL5 VARCHAR2 (150)
Fifth component of the user composite key to uniquely identify the transaction
TRX_USER_KEY_LEVEL6 VARCHAR2 (150)
Sixth component of the user composite key to uniquely identify the transaction
MRC_TAX_LINE_FLAG VARCHAR2 (1)
Y or N indicates if this tax line is for one of the multiple reporting currencies (MRC)
LEDGER_ID NUMBER (15)
Ledger defining column
ESTABLISHMENT_ID NUMBER

Establishment identifier
LEGAL_ENTITY_ID NUMBER

Legal entity identifier
LEGAL_ENTITY_TAX_REG_NUMBER NUMBER

Legal entity tax registration number
HQ_ESTB_REG_NUMBER VARCHAR2 (30)
First party HQ establishment tax registration number
HQ_ESTB_PARTY_TAX_PROF_ID NUMBER

Party tax profile identifier for the first party HQ establishment
CURRENCY_CONVERSION_DATE DATE

Date of the exchange rate for transaction currency to functional currency conversion
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type for transaction currency to functional currency conversion
CURRENCY_CONVERSION_RATE NUMBER

Exchange rate for transaction currency to functional currency conversion
TAX_CURRENCY_CONVERSION_DATE DATE

Date of the exchange rate for transaction currency to tax currency conversion
TAX_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type for transaction currency to tax currency conversion
TAX_CURRENCY_CONVERSION_RATE NUMBER

Exchange rate for transaction currency to tax currency conversion
TRX_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
MINIMUM_ACCOUNTABLE_UNIT NUMBER

Minimum accountable unit of the transaction currency
PRECISION NUMBER

Precision of the transaction currency
TRX_NUMBER VARCHAR2 (150)
Transaction number
TRX_DATE DATE

Transaction date
UNIT_PRICE NUMBER

Unit Price of the transaction line item or product
LINE_AMT NUMBER

Transaction line amount
TRX_LINE_QUANTITY NUMBER

Transaction line quantity
TAX_BASE_MODIFIER_RATE NUMBER

Modifier rate used for taxable basis determination
REF_DOC_APPLICATION_ID NUMBER

Reference document application identifier
REF_DOC_ENTITY_CODE VARCHAR2 (30)
Reference document entity code
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Reference document event class code
REF_DOC_TRX_ID NUMBER

Reference document transaction identifier
REF_DOC_LINE_ID NUMBER

Transaction line identifier for the reference document
REF_DOC_LINE_QUANTITY NUMBER

Reference document line quantity
OTHER_DOC_LINE_AMT NUMBER

Line amount on the other document
OTHER_DOC_LINE_TAX_AMT NUMBER

Line tax amount on the other document
OTHER_DOC_LINE_TAXABLE_AMT NUMBER

Taxable amount on the other document
UNROUNDED_TAXABLE_AMT NUMBER

Unrounded taxable amount for this tax line
UNROUNDED_TAX_AMT NUMBER

Unrounded tax amount for this tax line
RELATED_DOC_APPLICATION_ID NUMBER

Related document application identifier
RELATED_DOC_ENTITY_CODE VARCHAR2 (30)
Related document entity code
RELATED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Related document event class code
RELATED_DOC_TRX_ID NUMBER

Primary itransaction dentifier for the related document
RELATED_DOC_NUMBER VARCHAR2 (150)
Transaction number for related document
RELATED_DOC_DATE DATE

Related document date
APPLIED_FROM_APPLICATION_ID NUMBER

Applied from document application identifier
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
Applied from document event class code
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
Applied from document entity code
APPLIED_FROM_TRX_ID NUMBER

Applied from document transaction identifier
APPLIED_FROM_LINE_ID NUMBER

Transaction line identifier for the applied from document
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
Transaction number of the applied from document
ADJUSTED_DOC_APPLICATION_ID NUMBER

Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event class code
ADJUSTED_DOC_TRX_ID NUMBER

Adjusted document transaction identifier
ADJUSTED_DOC_LINE_ID NUMBER

Transaction line identifier for the adjusted document
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
Transaction number of the adjusted document
ADJUSTED_DOC_DATE DATE

Adjusted document date
APPLIED_TO_APPLICATION_ID NUMBER

Applied to document application identifier
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
Applied to document event class code
APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
Applied to document entity code
APPLIED_TO_TRX_ID NUMBER

Applied to document transaction identifier
APPLIED_TO_LINE_ID NUMBER

Transaction line identifier for the applied to document
SUMMARY_TAX_LINE_ID NUMBER (15)
Summary tax line identifier for this tax line
OFFSET_LINK_TO_TAX_LINE_ID NUMBER (15)
Identifier of the source tax line to which this tax line is associated if this tax line is created for an offset tax
OFFSET_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is created for an offset tax
PROCESS_FOR_RECOVERY_FLAG VARCHAR2 (1)
Y or N indciates whether recoverable tax amount needs to be determined for this tax line
TAX_JURISDICTION_ID NUMBER (15)
Tax jurisdiction identifier
TAX_JURISDICTION_CODE VARCHAR2 (30)
Tax jurisdiction code
PLACE_OF_SUPPLY NUMBER

Lookup code for place of supply of this tax line
PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 (30)
Lookup code for place of supply type
PLACE_OF_SUPPLY_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from place of supply determination process for this tax line
TAX_DATE_RULE_ID NUMBER (15)
Column to record identifier of tax rule used to determine tax date
TAX_DATE DATE

One of the dates on the current transaction based on which applicable tax rates and rules are determined
TAX_DETERMINE_DATE DATE

Actual date used for determining applicable tax rates and rules. If adjusted document is persent, this is the tax date of the adjusted document; else it is same as the tax date of this tax line.
TAX_POINT_DATE DATE

Date on which the taxpayer becomes liable for paying the tax to the tax authority. It can be the delivery date, the invoice date or the pickup date
TRX_LINE_DATE DATE

Transaction line date
TAX_TYPE_CODE VARCHAR2 (30)
Lookup code for tax type
TAX_CODE VARCHAR2 (30)
Tax classification code
TAX_REGISTRATION_ID NUMBER (15)
Tax registration identifier
TAX_REGISTRATION_NUMBER VARCHAR2 (50)
Tax registration number
REGISTRATION_PARTY_TYPE VARCHAR2 (30)
Lookup code for party type that is used to determine the tax registration number
ROUNDING_LEVEL_CODE VARCHAR2 (30)
Rounding level code
ROUNDING_RULE_CODE VARCHAR2 (30)
Rounding rule code for the tax
ROUNDING_LVL_PARTY_TAX_PROF_ID NUMBER (15)
Party tax profile identifier of the party used for determining rounding level code
ROUNDING_LVL_PARTY_TYPE VARCHAR2 (30)
Lookup code for type of the party used for determining rounding level code
COMPOUNDING_TAX_FLAG VARCHAR2 (1)
Y or N indicates whether there exists any other tax line that is compunded on top of this tax line
ORIG_TAX_STATUS_ID NUMBER (15)
Column to store value of tax status identifier present prior to user override
ORIG_TAX_STATUS_CODE VARCHAR2 (30)
Column to store value of tax status code present prior to user override
ORIG_TAX_RATE_ID NUMBER (15)
Column to store value of tax rate identifier present prior to user override
ORIG_TAX_RATE_CODE VARCHAR2 (150)
Column to store value of tax rate code present prior to user override
ORIG_TAX_RATE NUMBER

Column to store value of tax rate present prior to user override
ORIG_TAX_JURISDICTION_ID NUMBER (15)
Column to store value of tax jurisdiction identifier present prior to user override
ORIG_TAX_JURISDICTION_CODE VARCHAR2 (30)
Column to store value of tax jurisdiction code present prior to user override
ORIG_TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
Tax amount inlcuded flag before override
ORIG_SELF_ASSESSED_FLAG VARCHAR2 (1)
Column to store value of self-assessed flag prior to user override
TAX_CURRENCY_CODE VARCHAR2 (15)
Tax currency code
TAX_AMT NUMBER

Tax amount in transaction currency
TAX_AMT_TAX_CURR NUMBER

Tax amount in tax currency
TAX_AMT_FUNCL_CURR NUMBER

Tax amount in functional currency
TAXABLE_AMT NUMBER

Taxable amount in transaction currency
TAXABLE_AMT_TAX_CURR NUMBER

Taxable amount in tax currency
TAXABLE_AMT_FUNCL_CURR NUMBER

Taxable amount in functional currency
ORIG_TAXABLE_AMT NUMBER

Column to store value of taxable amount prior to user override
ORIG_TAXABLE_AMT_TAX_CURR NUMBER

Column to store value of taxable amount in tax currency prior to user override
CAL_TAX_AMT NUMBER

System calculated tax amount in transaction currency. This is same as the tax amount in transaction currency if there is no user override.
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.
CAL_TAX_AMT_FUNCL_CURR NUMBER

System calculated tax amount in functional currency. This is same as the tax amount in functional currency if there is no user override.
ORIG_TAX_AMT NUMBER

Column to store value of tax amount in transaction currency prior to user override
ORIG_TAX_AMT_TAX_CURR NUMBER

Column to store value of tax amount in tax currency prior to user override
REC_TAX_AMT NUMBER

Total recoverable tax amount in transaction currency
REC_TAX_AMT_TAX_CURR NUMBER

Total recoverable tax amount in tax currency
REC_TAX_AMT_FUNCL_CURR NUMBER

Total recoverable tax amount in functional currency
NREC_TAX_AMT NUMBER

Total non-recoverable tax amount in transaction currency
NREC_TAX_AMT_TAX_CURR NUMBER

Total non-recoverable tax amount in tax currency
NREC_TAX_AMT_FUNCL_CURR NUMBER

Total non-recoverable tax amount in functional currency
TAX_EXEMPTION_ID NUMBER (15)
Identifier of the tax exemption used in determination of the effective tax rate
TAX_RATE_BEFORE_EXEMPTION NUMBER

Tax rate that is determined before applying the tax exemption
TAX_RATE_NAME_BEFORE_EXEMPTION VARCHAR2 (150)
Tax rate name that is determined before applying the tax exemption
EXEMPT_RATE_MODIFIER NUMBER

Percentage of the original tax rate that is exempt
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
Tax exemption certificate number
EXEMPT_REASON VARCHAR2 (240)
Tax exemption reason
EXEMPT_REASON_CODE VARCHAR2 (30)
Exempt reason code
TAX_EXCEPTION_ID NUMBER (15)
Identifier of the tax exception used in determination of the effective tax rate
TAX_RATE_BEFORE_EXCEPTION NUMBER

Tax rate that is determined before applying the tax exception
TAX_RATE_NAME_BEFORE_EXCEPTION VARCHAR2 (150)
Tax rate name that is determined before applying the tax exception
EXCEPTION_RATE NUMBER

Percentage of the original tax rate that is treated as an exception
TAX_APPORTIONMENT_FLAG VARCHAR2 (1)
Y or N indicates whether there are multiple tax lines created for the tax of this line during migration from prior releases
HISTORICAL_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is created during migration from prior releases
TAXABLE_BASIS_FORMULA VARCHAR2 (30)
Formula code used for determining taxable basis amount
TAX_CALCULATION_FORMULA VARCHAR2 (30)
Formula code used for determining tax amount
CANCEL_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is cancelled by the user
PURGE_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is marked for purge
DELETE_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is marked for delete by the user
TAX_AMT_INCLUDED_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is inclusive
SELF_ASSESSED_FLAG VARCHAR2 (1)
Y or N indicates whether this is a self-assessed tax line
OVERRIDDEN_FLAG VARCHAR2 (1)
Y or N indicates whether user has overridden this tax line
MANUALLY_ENTERED_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is manually entered by the user
REPORTING_ONLY_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is created for reporting only
FREEZE_UNTIL_OVERRIDDEN_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is enforced from the reference document eventhough it is not found applicable for the current document
COPIED_FROM_OTHER_DOC_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is copied from another document like a reference document
RECALC_REQUIRED_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line needs to be recalculated when user overrides an inclusive tax line or a tax line on top of which this tax line is compounded
SETTLEMENT_FLAG VARCHAR2 (1)
Not currently used
ITEM_DIST_CHANGED_FLAG VARCHAR2 (1)
Y or N indicates whether item distributions corresponding to the transaction line of this tax line are changed
ASSOCIATED_CHILD_FROZEN_FLAG VARCHAR2 (1)
Y or N indicates whether tax distributions associated with this tax line are frozen
TAX_ONLY_LINE_FLAG VARCHAR2 (1)
Y or N indicates whether this is a tax only line
COMPOUNDING_DEP_TAX_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is compunded on top of another tax line
LAST_MANUAL_ENTRY VARCHAR2 (30)
Column to indicate which column is last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE and TAX_AMOUNT.
TAX_PROVIDER_ID NUMBER

Party tax profile identifier of the third party service provider that has determined the tax on this line.
RECORD_TYPE_CODE VARCHAR2 (30)
Lookup code to indicate whether the record is migrated, seeded or defined by the user
REPORTING_PERIOD_ID NUMBER

Identifier of the period when this tax line is reported
LEGAL_MESSAGE_APPL_2 NUMBER

Legal message for tax applicability
LEGAL_MESSAGE_STATUS NUMBER

Legal message for status determination
LEGAL_MESSAGE_RATE NUMBER

Legal message for rate determination
LEGAL_MESSAGE_BASIS NUMBER

Legal message for taxable basis
LEGAL_MESSAGE_CALC NUMBER

Legal message for tax calculation
LEGAL_MESSAGE_THRESHOLD NUMBER

Legal message for thresholds
LEGAL_MESSAGE_POS NUMBER

Legal message for place of supply
LEGAL_MESSAGE_TRN NUMBER

Legal message for tax registration number
LEGAL_MESSAGE_EXMPT NUMBER

Legal message for exemptions
LEGAL_MESSAGE_EXCPT NUMBER

Legal message for exceptions
TAX_REGIME_TEMPLATE_ID NUMBER (15)
Identifier of determining factor template used for regime determination
TAX_APPLICABILITY_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from tax applicability process for this tax line
DIRECT_RATE_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from line determination process for this tax line
STATUS_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from status determination process for this tax line
RATE_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from rate determination process for this tax line
BASIS_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from taxable basis determination process for this tax line
THRESH_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from threshold evaluation process for this tax line
CALC_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from tax calculation process for this tax line
TAX_REG_NUM_DET_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from tax registration number determination process for this tax line
EVAL_EXMPT_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from exemption evaluation process for this tax line
EVAL_EXCPT_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from exception evaluation process for this tax line
ENFORCE_FROM_NATURAL_ACCT_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line is enforced from natural account
TAX_HOLD_CODE NUMBER

Name of tax hold code for Payables. Possible values are TAX VARIANCE, TAX AMOUNT RANGE and TAX VARIANCE+TAX AMOUNT RANGE.
TAX_HOLD_RELEASED_CODE NUMBER

Name of tax hold release code for Payables. Possible values are TAX VARIANCE CORRECTED, TAX AMOUNT RANGE CORRECTED and TAX VARIANCE+TAX AMOUNT RANGE CORRECTED.
PRD_TOTAL_TAX_AMT NUMBER

Prorated total tax amount
PRD_TOTAL_TAX_AMT_TAX_CURR NUMBER

Prorated total tax amount in tax currency
PRD_TOTAL_TAX_AMT_FUNCL_CURR NUMBER

Prorated total tax amount in functional currency
INTERNAL_ORG_LOCATION_ID NUMBER

Internal organization location identifier of the transaction
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country specific localizations
NUMERIC1 NUMBER

Not currently used
NUMERIC2 NUMBER

Not currently used
NUMERIC3 NUMBER

Not currently used
NUMERIC4 NUMBER

Not currently used
NUMERIC5 NUMBER

Not currently used
NUMERIC6 NUMBER

Not currently used
NUMERIC7 NUMBER

Not currently used
NUMERIC8 NUMBER

Not currently used
NUMERIC9 NUMBER

Not currently used
NUMERIC10 NUMBER

Not currently used
CHAR1 VARCHAR2 (150)
Not currently used
CHAR2 VARCHAR2 (150)
Not currently used
CHAR3 VARCHAR2 (150)
Not currently used
CHAR4 VARCHAR2 (150)
Not currently used
CHAR5 VARCHAR2 (150)
Not currently used
CHAR6 VARCHAR2 (150)
Not currently used
CHAR7 VARCHAR2 (150)
Not currently used
CHAR8 VARCHAR2 (150)
Not currently used
CHAR9 VARCHAR2 (150)
Not currently used
CHAR10 VARCHAR2 (150)
Not currently used
DATE1 DATE

Not currently used
DATE2 DATE

Not currently used
DATE3 DATE

Not currently used
DATE4 DATE

Not currently used
DATE5 DATE

Not currently used
DATE6 DATE

Not currently used
DATE7 DATE

Not currently used
DATE8 DATE

Not currently used
DATE9 DATE

Not currently used
DATE10 DATE

Not currently used
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LEGAL_JUSTIFICATION_TEXT1 VARCHAR2 (2000)
Legal justification text 1 - for migration only
LEGAL_JUSTIFICATION_TEXT2 VARCHAR2 (2000)
Legal justification text 2 - for migration only
LEGAL_JUSTIFICATION_TEXT3 VARCHAR2 (2000)
Legal justification text 3 - for migration only
REPORTING_CURRENCY_CODE VARCHAR2 (30)
Reporting currency code
LINE_ASSESSABLE_VALUE NUMBER

Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes
TRX_LINE_INDEX VARCHAR2 (30)
Not currently used
OFFSET_TAX_RATE_CODE VARCHAR2 (150)
Offset tax rate code
PRORATION_CODE VARCHAR2 (30)
Not currently used
OTHER_DOC_SOURCE VARCHAR2 (30)
Source of other document
CTRL_TOTAL_LINE_TX_AMT NUMBER

Control amount for the total tax amount at the transaction line level
TAX_RATE_TYPE VARCHAR2 (30)
Lookup code that indicates type of the tax rate. Possible values include PERCENTAGE, QUANTITY and RECOVERY.
COMPOUNDING_TAX_MISS_FLAG VARCHAR2 (1)
Y or N indicates whether the tax line on top of which this tax line is compounded is missing
MRC_LINK_TO_TAX_LINE_ID NUMBER

Identifier of the source tax line in transaction currency corresponding to which this tax line is created if this tax line is in one of the multiple reporting currencies
REF_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
RELATED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Not currently used
APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
APPLIED_TO_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the applied to document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
SYNC_WITH_PRVDR_FLAG VARCHAR2 (1)
Y or N indicates whether this tax line needs to be synchronized with the third party service provider
APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
Applied to document transaction number
INTERFACE_ENTITY_CODE VARCHAR2 (30)
Column to temporarily store entity code of the tax line interface table
INTERFACE_TAX_LINE_ID NUMBER

Column to temporarily store identifier of the interface line corresponding to this tax line during import of transactions into Receivables
TAXING_JURIS_GEOGRAPHY_ID NUMBER

Geography Id for the tax jurisdiction of this tax line
ADJUSTED_DOC_TAX_LINE_ID NUMBER

Adjusted document tax line identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country specific localizations
REVERSED_TAX_LINE_ID NUMBER

Identifier of the tax line that is reversed by this tax line
MULTIPLE_JURISDICTIONS_FLAG VARCHAR2 (1)
Y or N indicates whether the tax of this tax line has multiple jurisdictions
LEGAL_REPORTING_STATUS VARCHAR2 (15)
Status for legal reporting
ACCOUNT_SOURCE_TAX_RATE_ID NUMBER (15)
Tax Rate from which the GL account should be derived. If the tax derives its GL account from another tax, this column store the tax rate id of that tax, i.e., the source tax for accounts
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TAX_LINE_ID
,      INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_NUMBER
,      DOC_EVENT_STATUS
,      TAX_EVENT_CLASS_CODE
,      TAX_EVENT_TYPE_CODE
,      TAX_LINE_NUMBER
,      CONTENT_OWNER_ID
,      TAX_REGIME_ID
,      TAX_REGIME_CODE
,      TAX_ID
,      TAX
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_APPORTIONMENT_LINE_NUMBER
,      TRX_ID_LEVEL2
,      TRX_ID_LEVEL3
,      TRX_ID_LEVEL4
,      TRX_ID_LEVEL5
,      TRX_ID_LEVEL6
,      TRX_USER_KEY_LEVEL1
,      TRX_USER_KEY_LEVEL2
,      TRX_USER_KEY_LEVEL3
,      TRX_USER_KEY_LEVEL4
,      TRX_USER_KEY_LEVEL5
,      TRX_USER_KEY_LEVEL6
,      MRC_TAX_LINE_FLAG
,      LEDGER_ID
,      ESTABLISHMENT_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_TAX_REG_NUMBER
,      HQ_ESTB_REG_NUMBER
,      HQ_ESTB_PARTY_TAX_PROF_ID
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      TAX_CURRENCY_CONVERSION_DATE
,      TAX_CURRENCY_CONVERSION_TYPE
,      TAX_CURRENCY_CONVERSION_RATE
,      TRX_CURRENCY_CODE
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      TRX_NUMBER
,      TRX_DATE
,      UNIT_PRICE
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      TAX_BASE_MODIFIER_RATE
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      REF_DOC_LINE_ID
,      REF_DOC_LINE_QUANTITY
,      OTHER_DOC_LINE_AMT
,      OTHER_DOC_LINE_TAX_AMT
,      OTHER_DOC_LINE_TAXABLE_AMT
,      UNROUNDED_TAXABLE_AMT
,      UNROUNDED_TAX_AMT
,      RELATED_DOC_APPLICATION_ID
,      RELATED_DOC_ENTITY_CODE
,      RELATED_DOC_EVENT_CLASS_CODE
,      RELATED_DOC_TRX_ID
,      RELATED_DOC_NUMBER
,      RELATED_DOC_DATE
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_TRX_ID
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_TRX_NUMBER
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      ADJUSTED_DOC_LINE_ID
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_TRX_ID
,      APPLIED_TO_LINE_ID
,      SUMMARY_TAX_LINE_ID
,      OFFSET_LINK_TO_TAX_LINE_ID
,      OFFSET_FLAG
,      PROCESS_FOR_RECOVERY_FLAG
,      TAX_JURISDICTION_ID
,      TAX_JURISDICTION_CODE
,      PLACE_OF_SUPPLY
,      PLACE_OF_SUPPLY_TYPE_CODE
,      PLACE_OF_SUPPLY_RESULT_ID
,      TAX_DATE_RULE_ID
,      TAX_DATE
,      TAX_DETERMINE_DATE
,      TAX_POINT_DATE
,      TRX_LINE_DATE
,      TAX_TYPE_CODE
,      TAX_CODE
,      TAX_REGISTRATION_ID
,      TAX_REGISTRATION_NUMBER
,      REGISTRATION_PARTY_TYPE
,      ROUNDING_LEVEL_CODE
,      ROUNDING_RULE_CODE
,      ROUNDING_LVL_PARTY_TAX_PROF_ID
,      ROUNDING_LVL_PARTY_TYPE
,      COMPOUNDING_TAX_FLAG
,      ORIG_TAX_STATUS_ID
,      ORIG_TAX_STATUS_CODE
,      ORIG_TAX_RATE_ID
,      ORIG_TAX_RATE_CODE
,      ORIG_TAX_RATE
,      ORIG_TAX_JURISDICTION_ID
,      ORIG_TAX_JURISDICTION_CODE
,      ORIG_TAX_AMT_INCLUDED_FLAG
,      ORIG_SELF_ASSESSED_FLAG
,      TAX_CURRENCY_CODE
,      TAX_AMT
,      TAX_AMT_TAX_CURR
,      TAX_AMT_FUNCL_CURR
,      TAXABLE_AMT
,      TAXABLE_AMT_TAX_CURR
,      TAXABLE_AMT_FUNCL_CURR
,      ORIG_TAXABLE_AMT
,      ORIG_TAXABLE_AMT_TAX_CURR
,      CAL_TAX_AMT
,      CAL_TAX_AMT_TAX_CURR
,      CAL_TAX_AMT_FUNCL_CURR
,      ORIG_TAX_AMT
,      ORIG_TAX_AMT_TAX_CURR
,      REC_TAX_AMT
,      REC_TAX_AMT_TAX_CURR
,      REC_TAX_AMT_FUNCL_CURR
,      NREC_TAX_AMT
,      NREC_TAX_AMT_TAX_CURR
,      NREC_TAX_AMT_FUNCL_CURR
,      TAX_EXEMPTION_ID
,      TAX_RATE_BEFORE_EXEMPTION
,      TAX_RATE_NAME_BEFORE_EXEMPTION
,      EXEMPT_RATE_MODIFIER
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      EXEMPT_REASON_CODE
,      TAX_EXCEPTION_ID
,      TAX_RATE_BEFORE_EXCEPTION
,      TAX_RATE_NAME_BEFORE_EXCEPTION
,      EXCEPTION_RATE
,      TAX_APPORTIONMENT_FLAG
,      HISTORICAL_FLAG
,      TAXABLE_BASIS_FORMULA
,      TAX_CALCULATION_FORMULA
,      CANCEL_FLAG
,      PURGE_FLAG
,      DELETE_FLAG
,      TAX_AMT_INCLUDED_FLAG
,      SELF_ASSESSED_FLAG
,      OVERRIDDEN_FLAG
,      MANUALLY_ENTERED_FLAG
,      REPORTING_ONLY_FLAG
,      FREEZE_UNTIL_OVERRIDDEN_FLAG
,      COPIED_FROM_OTHER_DOC_FLAG
,      RECALC_REQUIRED_FLAG
,      SETTLEMENT_FLAG
,      ITEM_DIST_CHANGED_FLAG
,      ASSOCIATED_CHILD_FROZEN_FLAG
,      TAX_ONLY_LINE_FLAG
,      COMPOUNDING_DEP_TAX_FLAG
,      LAST_MANUAL_ENTRY
,      TAX_PROVIDER_ID
,      RECORD_TYPE_CODE
,      REPORTING_PERIOD_ID
,      LEGAL_MESSAGE_APPL_2
,      LEGAL_MESSAGE_STATUS
,      LEGAL_MESSAGE_RATE
,      LEGAL_MESSAGE_BASIS
,      LEGAL_MESSAGE_CALC
,      LEGAL_MESSAGE_THRESHOLD
,      LEGAL_MESSAGE_POS
,      LEGAL_MESSAGE_TRN
,      LEGAL_MESSAGE_EXMPT
,      LEGAL_MESSAGE_EXCPT
,      TAX_REGIME_TEMPLATE_ID
,      TAX_APPLICABILITY_RESULT_ID
,      DIRECT_RATE_RESULT_ID
,      STATUS_RESULT_ID
,      RATE_RESULT_ID
,      BASIS_RESULT_ID
,      THRESH_RESULT_ID
,      CALC_RESULT_ID
,      TAX_REG_NUM_DET_RESULT_ID
,      EVAL_EXMPT_RESULT_ID
,      EVAL_EXCPT_RESULT_ID
,      ENFORCE_FROM_NATURAL_ACCT_FLAG
,      TAX_HOLD_CODE
,      TAX_HOLD_RELEASED_CODE
,      PRD_TOTAL_TAX_AMT
,      PRD_TOTAL_TAX_AMT_TAX_CURR
,      PRD_TOTAL_TAX_AMT_FUNCL_CURR
,      INTERNAL_ORG_LOCATION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      NUMERIC1
,      NUMERIC2
,      NUMERIC3
,      NUMERIC4
,      NUMERIC5
,      NUMERIC6
,      NUMERIC7
,      NUMERIC8
,      NUMERIC9
,      NUMERIC10
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      CHAR10
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      DATE9
,      DATE10
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEGAL_JUSTIFICATION_TEXT1
,      LEGAL_JUSTIFICATION_TEXT2
,      LEGAL_JUSTIFICATION_TEXT3
,      REPORTING_CURRENCY_CODE
,      LINE_ASSESSABLE_VALUE
,      TRX_LINE_INDEX
,      OFFSET_TAX_RATE_CODE
,      PRORATION_CODE
,      OTHER_DOC_SOURCE
,      CTRL_TOTAL_LINE_TX_AMT
,      TAX_RATE_TYPE
,      COMPOUNDING_TAX_MISS_FLAG
,      MRC_LINK_TO_TAX_LINE_ID
,      REF_DOC_TRX_LEVEL_TYPE
,      RELATED_DOC_TRX_LEVEL_TYPE
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      APPLIED_TO_TRX_LEVEL_TYPE
,      SYNC_WITH_PRVDR_FLAG
,      APPLIED_TO_TRX_NUMBER
,      INTERFACE_ENTITY_CODE
,      INTERFACE_TAX_LINE_ID
,      TAXING_JURIS_GEOGRAPHY_ID
,      ADJUSTED_DOC_TAX_LINE_ID
,      OBJECT_VERSION_NUMBER
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      REVERSED_TAX_LINE_ID
,      MULTIPLE_JURISDICTIONS_FLAG
,      LEGAL_REPORTING_STATUS
,      ACCOUNT_SOURCE_TAX_RATE_ID
FROM ZX.ZX_LINES;

Dependencies

[top of page]

ZX.ZX_LINES does not reference any database object

ZX.ZX_LINES is referenced by following:

SchemaZX
ViewZX_LINES#