eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: ZX_LINES

Product:	ZX - E-Business Tax
Description:	This table stores detail tax lines for transactions of multiple event classes.
Implementation/DBA Data:	ZX.ZX_LINES

Primary Key: ZX_LINES_PK

TAX_LINE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZX_LINES	ZX_EXCEPTIONS	ZX_LINES.TAX_EXCEPTION_ID
ZX_LINES	ZX_PARTY_TAX_PROFILE	ZX_LINES.CONTENT_OWNER_ID
ZX_LINES	ZX_REGIMES_B	ZX_LINES.TAX_REGIME_CODE
ZX_LINES	ZX_TAXES_B	ZX_LINES.TAX_ID
ZX_LINES	ZX_STATUS_B	ZX_LINES.TAX_STATUS_ID
ZX_LINES	ZX_RATES_B	ZX_LINES.TAX_RATE_ID
ZX_LINES	%	ZX_LINES.LEDGER_ID
ZX_LINES	ZX_PARTY_TAX_PROFILE	ZX_LINES.HQ_ESTB_PARTY_TAX_PROF_ID
ZX_LINES	FND_CURRENCIES	ZX_LINES.TRX_CURRENCY_CODE
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.CALC_RESULT_ID
ZX_LINES	%	ZX_LINES.REF_DOC_APPLICATION_ID ZX_LINES.REF_DOC_ENTITY_CODE
ZX_LINES	%	ZX_LINES.RELATED_DOC_APPLICATION_ID ZX_LINES.RELATED_DOC_ENTITY_CODE
ZX_LINES	%	ZX_LINES.APPLIED_FROM_APPLICATION_ID ZX_LINES.APPLIED_FROM_ENTITY_CODE
ZX_LINES	%	ZX_LINES.ADJUSTED_DOC_APPLICATION_ID ZX_LINES.ADJUSTED_DOC_ENTITY_CODE
ZX_LINES	%	ZX_LINES.APPLIED_TO_APPLICATION_ID ZX_LINES.APPLIED_TO_ENTITY_CODE
ZX_LINES	ZX_LINES_SUMMARY	ZX_LINES.SUMMARY_TAX_LINE_ID
ZX_LINES	ZX_LINES	ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.PLACE_OF_SUPPLY_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.TAX_DATE_RULE_ID
ZX_LINES	ZX_REGISTRATIONS	ZX_LINES.TAX_REGISTRATION_ID
ZX_LINES	FND_CURRENCIES	ZX_LINES.REPORTING_CURRENCY_CODE
ZX_LINES	ZX_PARTY_TAX_PROFILE	ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID
ZX_LINES	ZX_STATUS_B	ZX_LINES.ORIG_TAX_STATUS_ID
ZX_LINES	ZX_LINES	ZX_LINES.ADJUSTED_DOC_TAX_LINE_ID
ZX_LINES	ZX_LINES	ZX_LINES.REVERSED_TAX_LINE_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.TAX_REG_NUM_DET_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.EVAL_EXMPT_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.EVAL_EXCPT_RESULT_ID
ZX_LINES	HR_LOCATIONS_ALL	ZX_LINES.INTERNAL_ORG_LOCATION_ID
ZX_LINES	ZX_PARTY_TAX_PROFILE	ZX_LINES.TAX_PROVIDER_ID
ZX_LINES	ZX_RATES_B	ZX_LINES.ORIG_TAX_RATE_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.TAX_APPLICABILITY_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.DIRECT_RATE_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.STATUS_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.RATE_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.BASIS_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.THRESH_RESULT_ID
ZX_LINES	ZX_PROCESS_RESULTS	ZX_LINES.TAX_LINE_ID
ZX_LINES	HR_ALL_ORGANIZATION_UNITS	ZX_LINES.INTERNAL_ORGANIZATION_ID
ZX_LINES	%	ZX_LINES.APPLICATION_ID ZX_LINES.ENTITY_CODE
ZX_LINES	ZX_EVNT_TYP_MAPPINGS	ZX_LINES.APPLICATION_ID ZX_LINES.ENTITY_CODE ZX_LINES.EVENT_CLASS_CODE ZX_LINES.EVENT_TYPE_CODE
ZX_LINES	%	ZX_LINES.TAX_REGIME_CODE ZX_LINES.TAX ZX_LINES.ORIG_TAX_JURISDICTION_CODE
ZX_LINES	RA_INTERFACE_LINES_ALL	ZX_LINES.INTERFACE_TAX_LINE_ID
ZX_LINES	%	ZX_LINES.TAX_REGIME_CODE ZX_LINES.TAX ZX_LINES.TAX_JURISDICTION_CODE
ZX_LINES	FND_CURRENCIES	ZX_LINES.TAX_CURRENCY_CODE
ZX_LINES	ZX_EXEMPTIONS	ZX_LINES.TAX_EXEMPTION_ID
ZX_LINES	ZX_EVENT_CLASSES_B	ZX_LINES.TAX_EVENT_CLASS_CODE
ZX_LINES	ZX_EVNT_CLS_TYPS	ZX_LINES.TAX_EVENT_CLASS_CODE ZX_LINES.TAX_EVENT_TYPE_CODE
ZX_LINES_DET_FACTORS	ZX_LINES	ZX_LINES_DET_FACTORS.SOURCE_TAX_LINE_ID
ZX_LINES	ZX_LINES	ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID
ZX_LINES	ZX_LINES	ZX_LINES.ADJUSTED_DOC_TAX_LINE_ID
ZX_LINES	ZX_LINES	ZX_LINES.REVERSED_TAX_LINE_ID