[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_LINES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.ZX_LINES_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| TAX_LINE_ID | NUMBER | (15) | Yes | |
| INTERNAL_ORGANIZATION_ID | NUMBER | Yes | ||
| APPLICATION_ID | NUMBER | Yes | ||
| ENTITY_CODE | VARCHAR2 | (30) | Yes | |
| EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | |
| EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
| TRX_ID | NUMBER | Yes | ||
| TRX_LINE_ID | NUMBER | Yes | ||
| TRX_LEVEL_TYPE | VARCHAR2 | (30) | Yes | |
| TRX_LINE_NUMBER | NUMBER | |||
| DOC_EVENT_STATUS | VARCHAR2 | (30) | ||
| TAX_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| TAX_EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_LINE_NUMBER | NUMBER | Yes | ||
| CONTENT_OWNER_ID | NUMBER | (15) | ||
| TAX_REGIME_ID | NUMBER | (15) | ||
| TAX_REGIME_CODE | VARCHAR2 | (30) | ||
| TAX_REGIME_NAME | VARCHAR2 | (80) | ||
| TAX_ID | NUMBER | (15) | ||
| TAX | VARCHAR2 | (30) | ||
| TAX_FULL_NAME | VARCHAR2 | (80) | ||
| TAX_STATUS_ID | NUMBER | (15) | ||
| TAX_STATUS_CODE | VARCHAR2 | (30) | ||
| TAX_STATUS_NAME | VARCHAR2 | (80) | ||
| TAX_RATE_ID | NUMBER | (15) | ||
| TAX_RATE_CODE | VARCHAR2 | (150) | ||
| TAX_RATE_NAME | VARCHAR2 | (240) | ||
| TAX_RATE | NUMBER | |||
| TAX_RATE_TYPE | VARCHAR2 | (30) | ||
| TAX_APPORTIONMENT_LINE_NUMBER | NUMBER | |||
| TRX_ID_LEVEL2 | NUMBER | |||
| TRX_ID_LEVEL3 | NUMBER | |||
| TRX_ID_LEVEL4 | NUMBER | |||
| TRX_ID_LEVEL5 | NUMBER | |||
| TRX_ID_LEVEL6 | NUMBER | |||
| TRX_USER_KEY_LEVEL1 | VARCHAR2 | (150) | ||
| TRX_USER_KEY_LEVEL2 | VARCHAR2 | (150) | ||
| TRX_USER_KEY_LEVEL3 | VARCHAR2 | (150) | ||
| TRX_USER_KEY_LEVEL4 | VARCHAR2 | (150) | ||
| TRX_USER_KEY_LEVEL5 | VARCHAR2 | (150) | ||
| TRX_USER_KEY_LEVEL6 | VARCHAR2 | (150) | ||
| MRC_TAX_LINE_FLAG | VARCHAR2 | (1) | ||
| MRC_LINK_TO_TAX_LINE_ID | NUMBER | |||
| LEDGER_ID | NUMBER | (15) | ||
| ESTABLISHMENT_ID | NUMBER | |||
| LEGAL_ENTITY_ID | NUMBER | |||
| LEGAL_ENTITY_TAX_REG_NUMBER | NUMBER | |||
| HQ_ESTB_REG_NUMBER | VARCHAR2 | (30) | ||
| HQ_ESTB_PARTY_TAX_PROF_ID | NUMBER | |||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| TAX_CURRENCY_CONVERSION_DATE | DATE | |||
| TAX_CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| TAX_CURRENCY_CONVERSION_RATE | NUMBER | |||
| TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| REPORTING_CURRENCY_CODE | VARCHAR2 | (30) | ||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | |||
| PRECISION | NUMBER | |||
| TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_DATE | DATE | |||
| UNIT_PRICE | NUMBER | |||
| LINE_AMT | NUMBER | |||
| TRX_LINE_QUANTITY | NUMBER | |||
| TAX_BASE_MODIFIER_RATE | NUMBER | |||
| REF_DOC_APPLICATION_ID | NUMBER | |||
| REF_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
| REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| REF_DOC_TRX_ID | NUMBER | |||
| REF_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| REF_DOC_LINE_ID | NUMBER | |||
| REF_DOC_LINE_QUANTITY | NUMBER | |||
| OTHER_DOC_LINE_AMT | NUMBER | |||
| OTHER_DOC_LINE_TAX_AMT | NUMBER | |||
| OTHER_DOC_LINE_TAXABLE_AMT | NUMBER | |||
| UNROUNDED_TAXABLE_AMT | NUMBER | |||
| UNROUNDED_TAX_AMT | NUMBER | |||
| RELATED_DOC_APPLICATION_ID | NUMBER | |||
| RELATED_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
| RELATED_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| RELATED_DOC_TRX_ID | NUMBER | |||
| RELATED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| RELATED_DOC_NUMBER | VARCHAR2 | (150) | ||
| RELATED_DOC_DATE | DATE | |||
| APPLIED_FROM_APPLICATION_ID | NUMBER | |||
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_TRX_ID | NUMBER | |||
| APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| APPLIED_FROM_LINE_ID | NUMBER | |||
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_APPLICATION_ID | NUMBER | |||
| ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_TRX_ID | NUMBER | |||
| ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_LINE_ID | NUMBER | |||
| ADJUSTED_DOC_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_DATE | DATE | |||
| APPLIED_TO_APPLICATION_ID | NUMBER | |||
| APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| APPLIED_TO_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_TO_TRX_ID | NUMBER | |||
| APPLIED_TO_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| APPLIED_TO_LINE_ID | NUMBER | |||
| SUMMARY_TAX_LINE_ID | NUMBER | (15) | ||
| OFFSET_LINK_TO_TAX_LINE_ID | NUMBER | (15) | ||
| OFFSET_FLAG | VARCHAR2 | (1) | ||
| PROCESS_FOR_RECOVERY_FLAG | VARCHAR2 | (1) | ||
| TAX_JURISDICTION_ID | NUMBER | (15) | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | (30) | ||
| TAX_JURISDICTION_NAME | VARCHAR2 | (240) | ||
| PLACE_OF_SUPPLY | NUMBER | |||
| PLACE_OF_SUPPLY_TYPE_CODE | VARCHAR2 | (30) | ||
| PLACE_OF_SUPPLY_RESULT_ID | NUMBER | (15) | ||
| TAX_DATE_RULE_ID | NUMBER | (15) | ||
| TAX_DATE | DATE | |||
| TAX_DETERMINE_DATE | DATE | |||
| TAX_POINT_DATE | DATE | |||
| TRX_LINE_DATE | DATE | |||
| TAX_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_CODE | VARCHAR2 | (30) | ||
| TAX_REGISTRATION_ID | NUMBER | (15) | ||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | (50) | ||
| REGISTRATION_PARTY_TYPE | VARCHAR2 | (30) | ||
| ROUNDING_LEVEL_CODE | VARCHAR2 | (30) | ||
| ROUNDING_RULE_CODE | VARCHAR2 | (30) | ||
| ROUNDING_LVL_PARTY_TAX_PROF_ID | NUMBER | (15) | ||
| ROUNDING_LVL_PARTY_TYPE | VARCHAR2 | (30) | ||
| COMPOUNDING_TAX_FLAG | VARCHAR2 | (1) | ||
| ORIG_TAX_STATUS_ID | NUMBER | (15) | ||
| ORIG_TAX_STATUS_CODE | VARCHAR2 | (30) | ||
| ORIG_TAX_RATE_ID | NUMBER | (15) | ||
| ORIG_TAX_RATE_CODE | VARCHAR2 | (150) | ||
| ORIG_TAX_RATE | NUMBER | |||
| ORIG_TAX_JURISDICTION_ID | NUMBER | (15) | ||
| ORIG_TAX_JURISDICTION_CODE | VARCHAR2 | (30) | ||
| ORIG_TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | ||
| ORIG_SELF_ASSESSED_FLAG | VARCHAR2 | (1) | ||
| TAX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| TAX_AMT | NUMBER | |||
| TAX_AMT_TAX_CURR | NUMBER | |||
| TAX_AMT_FUNCL_CURR | NUMBER | |||
| TAXABLE_AMT | NUMBER | |||
| TAXABLE_AMT_TAX_CURR | NUMBER | |||
| TAXABLE_AMT_FUNCL_CURR | NUMBER | |||
| ORIG_TAXABLE_AMT | NUMBER | |||
| ORIG_TAXABLE_AMT_TAX_CURR | NUMBER | |||
| CAL_TAX_AMT | NUMBER | |||
| CAL_TAX_AMT_TAX_CURR | NUMBER | |||
| CAL_TAX_AMT_FUNCL_CURR | NUMBER | |||
| ORIG_TAX_AMT | NUMBER | |||
| ORIG_TAX_AMT_TAX_CURR | NUMBER | |||
| REC_TAX_AMT | NUMBER | |||
| REC_TAX_AMT_TAX_CURR | NUMBER | |||
| REC_TAX_AMT_FUNCL_CURR | NUMBER | |||
| NREC_TAX_AMT | NUMBER | |||
| NREC_TAX_AMT_TAX_CURR | NUMBER | |||
| NREC_TAX_AMT_FUNCL_CURR | NUMBER | |||
| TAX_EXEMPTION_ID | NUMBER | (15) | ||
| TAX_RATE_BEFORE_EXEMPTION | NUMBER | |||
| TAX_RATE_NAME_BEFORE_EXEMPTION | VARCHAR2 | (150) | ||
| EXEMPT_RATE_MODIFIER | NUMBER | |||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
| EXEMPT_REASON | VARCHAR2 | (240) | ||
| EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| TAX_EXCEPTION_ID | NUMBER | (15) | ||
| TAX_RATE_BEFORE_EXCEPTION | NUMBER | |||
| TAX_RATE_NAME_BEFORE_EXCEPTION | VARCHAR2 | (150) | ||
| EXCEPTION_RATE | NUMBER | |||
| TAX_APPORTIONMENT_FLAG | VARCHAR2 | (1) | ||
| HISTORICAL_FLAG | VARCHAR2 | (1) | ||
| TAXABLE_BASIS_FORMULA | VARCHAR2 | (30) | ||
| TAX_CALCULATION_FORMULA | VARCHAR2 | (30) | ||
| CANCEL_FLAG | VARCHAR2 | (1) | ||
| PURGE_FLAG | VARCHAR2 | (1) | ||
| DELETE_FLAG | VARCHAR2 | (1) | ||
| TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | (1) | ||
| OVERRIDDEN_FLAG | VARCHAR2 | (1) | ||
| MANUALLY_ENTERED_FLAG | VARCHAR2 | (1) | ||
| REPORTING_ONLY_FLAG | VARCHAR2 | (1) | ||
| FREEZE_UNTIL_OVERRIDDEN_FLAG | VARCHAR2 | (1) | ||
| COPIED_FROM_OTHER_DOC_FLAG | VARCHAR2 | (1) | ||
| RECALC_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| SETTLEMENT_FLAG | VARCHAR2 | (1) | ||
| ITEM_DIST_CHANGED_FLAG | VARCHAR2 | (1) | ||
| ASSOCIATED_CHILD_FROZEN_FLAG | VARCHAR2 | (1) | ||
| TAX_ONLY_LINE_FLAG | VARCHAR2 | (1) | ||
| COMPOUNDING_DEP_TAX_FLAG | VARCHAR2 | (1) | ||
| COMPOUNDING_TAX_MISS_FLAG | VARCHAR2 | (1) | ||
| SYNC_WITH_PRVDR_FLAG | VARCHAR2 | (1) | ||
| LAST_MANUAL_ENTRY | VARCHAR2 | (30) | ||
| TAX_PROVIDER_ID | NUMBER | |||
| RECORD_TYPE_CODE | VARCHAR2 | (30) | ||
| REPORTING_PERIOD_ID | NUMBER | |||
| LEGAL_JUSTIFICATION_TEXT1 | VARCHAR2 | (2000) | ||
| LEGAL_JUSTIFICATION_TEXT2 | VARCHAR2 | (2000) | ||
| LEGAL_JUSTIFICATION_TEXT3 | VARCHAR2 | (2000) | ||
| LEGAL_MESSAGE_APPL_2 | NUMBER | |||
| LEGAL_MESSAGE_STATUS | NUMBER | |||
| LEGAL_MESSAGE_RATE | NUMBER | |||
| LEGAL_MESSAGE_BASIS | NUMBER | |||
| LEGAL_MESSAGE_CALC | NUMBER | |||
| LEGAL_MESSAGE_THRESHOLD | NUMBER | |||
| LEGAL_MESSAGE_POS | NUMBER | |||
| LEGAL_MESSAGE_TRN | NUMBER | |||
| LEGAL_MESSAGE_EXMPT | NUMBER | |||
| LEGAL_MESSAGE_EXCPT | NUMBER | |||
| TAX_REGIME_TEMPLATE_ID | NUMBER | (15) | ||
| TAX_APPLICABILITY_RESULT_ID | NUMBER | (15) | ||
| DIRECT_RATE_RESULT_ID | NUMBER | (15) | ||
| STATUS_RESULT_ID | NUMBER | (15) | ||
| RATE_RESULT_ID | NUMBER | (15) | ||
| BASIS_RESULT_ID | NUMBER | (15) | ||
| THRESH_RESULT_ID | NUMBER | (15) | ||
| CALC_RESULT_ID | NUMBER | (15) | ||
| TAX_REG_NUM_DET_RESULT_ID | NUMBER | (15) | ||
| EVAL_EXMPT_RESULT_ID | NUMBER | (15) | ||
| EVAL_EXCPT_RESULT_ID | NUMBER | (15) | ||
| ENFORCE_FROM_NATURAL_ACCT_FLAG | VARCHAR2 | (1) | ||
| TAX_HOLD_CODE | NUMBER | |||
| TAX_HOLD_RELEASED_CODE | NUMBER | |||
| PRD_TOTAL_TAX_AMT | NUMBER | |||
| PRD_TOTAL_TAX_AMT_TAX_CURR | NUMBER | |||
| PRD_TOTAL_TAX_AMT_FUNCL_CURR | NUMBER | |||
| TRX_LINE_INDEX | VARCHAR2 | (30) | ||
| OFFSET_TAX_RATE_CODE | VARCHAR2 | (150) | ||
| PRORATION_CODE | VARCHAR2 | (30) | ||
| OTHER_DOC_SOURCE | VARCHAR2 | (30) | ||
| INTERNAL_ORG_LOCATION_ID | NUMBER | |||
| LINE_ASSESSABLE_VALUE | NUMBER | |||
| CTRL_TOTAL_LINE_TX_AMT | NUMBER | |||
| MULTIPLE_JURISDICTIONS_FLAG | VARCHAR2 | (1) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| NUMERIC1 | NUMBER | |||
| NUMERIC2 | NUMBER | |||
| NUMERIC3 | NUMBER | |||
| NUMERIC4 | NUMBER | |||
| NUMERIC5 | NUMBER | |||
| NUMERIC6 | NUMBER | |||
| NUMERIC7 | NUMBER | |||
| NUMERIC8 | NUMBER | |||
| NUMERIC9 | NUMBER | |||
| NUMERIC10 | NUMBER | |||
| CHAR1 | VARCHAR2 | (150) | ||
| CHAR2 | VARCHAR2 | (150) | ||
| CHAR3 | VARCHAR2 | (150) | ||
| CHAR4 | VARCHAR2 | (150) | ||
| CHAR5 | VARCHAR2 | (150) | ||
| CHAR6 | VARCHAR2 | (150) | ||
| CHAR7 | VARCHAR2 | (150) | ||
| CHAR8 | VARCHAR2 | (150) | ||
| CHAR9 | VARCHAR2 | (150) | ||
| CHAR10 | VARCHAR2 | (150) | ||
| DATE1 | DATE | |||
| DATE2 | DATE | |||
| DATE3 | DATE | |||
| DATE4 | DATE | |||
| DATE5 | DATE | |||
| DATE6 | DATE | |||
| DATE7 | DATE | |||
| DATE8 | DATE | |||
| DATE9 | DATE | |||
| DATE10 | DATE | |||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | (150) | ||
| INTERFACE_ENTITY_CODE | VARCHAR2 | (30) | ||
| INTERFACE_TAX_LINE_ID | NUMBER | |||
| TAXING_JURIS_GEOGRAPHY_ID | NUMBER | |||
| ADJUSTED_DOC_TAX_LINE_ID | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| REVERSED_TAX_LINE_ID | NUMBER | |||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| LEGAL_REPORTING_STATUS | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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_REGIME_NAME
, TAX_ID
, TAX
, TAX_FULL_NAME
, TAX_STATUS_ID
, TAX_STATUS_CODE
, TAX_STATUS_NAME
, TAX_RATE_ID
, TAX_RATE_CODE
, TAX_RATE_NAME
, TAX_RATE
, TAX_RATE_TYPE
, 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
, MRC_LINK_TO_TAX_LINE_ID
, 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
, REPORTING_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_TRX_LEVEL_TYPE
, 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_TRX_LEVEL_TYPE
, 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_TRX_LEVEL_TYPE
, 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_TRX_LEVEL_TYPE
, 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_TRX_LEVEL_TYPE
, 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
, TAX_JURISDICTION_NAME
, 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
, COMPOUNDING_TAX_MISS_FLAG
, SYNC_WITH_PRVDR_FLAG
, LAST_MANUAL_ENTRY
, TAX_PROVIDER_ID
, RECORD_TYPE_CODE
, REPORTING_PERIOD_ID
, LEGAL_JUSTIFICATION_TEXT1
, LEGAL_JUSTIFICATION_TEXT2
, LEGAL_JUSTIFICATION_TEXT3
, 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
, TRX_LINE_INDEX
, OFFSET_TAX_RATE_CODE
, PRORATION_CODE
, OTHER_DOC_SOURCE
, INTERNAL_ORG_LOCATION_ID
, LINE_ASSESSABLE_VALUE
, CTRL_TOTAL_LINE_TX_AMT
, MULTIPLE_JURISDICTIONS_FLAG
, 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
, APPLIED_TO_TRX_NUMBER
, INTERFACE_ENTITY_CODE
, INTERFACE_TAX_LINE_ID
, TAXING_JURIS_GEOGRAPHY_ID
, ADJUSTED_DOC_TAX_LINE_ID
, OBJECT_VERSION_NUMBER
, REVERSED_TAX_LINE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LEGAL_REPORTING_STATUS
FROM APPS.ZX_LINES_V;
APPS
ZX_JURISDICTIONS_TL
ZX_LINES
ZX_RATES_TL
ZX_REGIMES_TL
ZX_STATUS_TL
ZX_TAXES_TL
APPS
AR_XML_INVOICE_TAX_V
JE_IT_INVOICES_ABOVE_THRESHOLD
- show dependent code
|
|
|
|