AND zldf.event_class_code = ztppo.event_class_code AND zldf.trx_id = ztppo.trx_id AND zldf.event_id = nvl(ztppo.event_id,zldf.event_id) AND ztppo.record_for_partners_flag = 'Y' AND ztppo.record_flag = 'Y' AND ztppo.quote_flag = 'N' AND ztppo.tax_event_type_code =...
EVENT_CLASS_CODEVARCHAR230YesApplication event class of the transaction. TRX_IDNUMBER18YesSystem-generated identification number of a transaction. SUMMARY_TAX_LINE_IDNUMBER18YesSummary tax line identifier for a particular tax line. SUMMARY_TAX_LINE_NUMBERNUMBERYesSummary withholding tax line number. ...
RELATED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Related document event class code Active RELATED_DOC_TRX_ID NUMBER Primary itransaction dentifier for the related document Active REL_DOC_HDR_TRX_USER_KEY1 VARCHAR2 150 First component of the user composite key for uniquely identifying the related document...
, zl.event_class_code evevt_class_code , zl.trx_id trx_id , zl.tax tax ,zl.tax_id tax_id ,zl.tax_regime_code tax_regime_code ,zl.tax_jurisdiction_code tax_jurisdiction_code ,zl.tax_rate_code tax_rate_code ,zl.tax_rate tax_rate ,zl.tax_amt_included_flag tax_amt_included_flag...
EVENT_CLASS_CODEVARCHAR230YesApplication event class of the imported transactionActive TRX_IDNUMBERPrimary transaction identifier for the imported transactionActive HDR_TRX_USER_KEY1VARCHAR2150First component of the user composite key to uniquely identify the imported transactionActive ...
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction Active TRX_ID NUMBER Primary transaction identifier Active 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. Activ...
Indexes IndexUniquenessTablespaceColumns ZX_TAX_LINES_INTERFACE_N1 Non Unique Default BATCH_NAME, TRX_NUMBER, LINE_NUMBER ZX_TAX_LINES_INTERFACE_U1 Unique Default APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, SUMMARY_TAX_LINE_NUMBER, TRX_IDPrevious...
REVERSING_EVNT_CLS_CODE VARCHAR2 30 Yes Reversing document event class code REVERSING_TRX_ID NUMBER Reversing transaction identifier REVERSING_HDR_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the reversing document REVERSING_HDR_USER_KEY2 VARCHA...
REVERSING_EVNT_CLS_CODE VARCHAR2 30 Yes Reversing document event class code REVERSING_TRX_ID NUMBER Reversing transaction identifier REVERSING_HDR_USER_KEY1 VARCHAR2 150 First component of the header level user composite key for uniquely identifying the reversing document REVERSING_HDR_USER_KEY2 VARCHA...