[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_LINES_DET_FACTORS# |
|---|---|
| Object Type: | VIEW |
| Owner: | ZX |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERNAL_ORGANIZATION_ID | NUMBER | Yes | ||
| APPLICATION_ID | NUMBER | Yes | ||
| ENTITY_CODE | VARCHAR2 | (30) | Yes | |
| EVENT_CLASS_CODE | VARCHAR2 | (30) | Yes | |
| EVENT_CLASS_MAPPING_ID | NUMBER | |||
| EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| DOC_EVENT_STATUS | VARCHAR2 | (30) | ||
| LINE_LEVEL_ACTION | VARCHAR2 | (30) | Yes | |
| TRX_ID | NUMBER | Yes | ||
| TRX_LINE_ID | NUMBER | |||
| TRX_LEVEL_TYPE | VARCHAR2 | (30) | Yes | |
| HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| LINE_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| LINE_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| LINE_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| LINE_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| LINE_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| LINE_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| TRX_DATE | DATE | Yes | ||
| TRX_DOC_REVISION | VARCHAR2 | (150) | ||
| LEDGER_ID | NUMBER | (15) | ||
| TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | |||
| PRECISION | NUMBER | |||
| LEGAL_ENTITY_ID | NUMBER | Yes | ||
| ESTABLISHMENT_ID | NUMBER | |||
| RECEIVABLES_TRX_TYPE_ID | NUMBER | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | (2) | ||
| TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_LINE_NUMBER | NUMBER | |||
| TRX_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_COMMUNICATED_DATE | DATE | |||
| BATCH_SOURCE_ID | NUMBER | |||
| BATCH_SOURCE_NAME | VARCHAR2 | (150) | ||
| DOC_SEQ_ID | NUMBER | |||
| DOC_SEQ_NAME | VARCHAR2 | (150) | ||
| DOC_SEQ_VALUE | VARCHAR2 | (240) | ||
| TRX_DUE_DATE | DATE | |||
| TRX_TYPE_DESCRIPTION | VARCHAR2 | (240) | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | (240) | ||
| SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | (150) | ||
| SUPPLIER_TAX_INVOICE_DATE | DATE | |||
| SUPPLIER_EXCHANGE_RATE | NUMBER | |||
| TAX_INVOICE_DATE | DATE | |||
| TAX_INVOICE_NUMBER | VARCHAR2 | (150) | ||
| FIRST_PTY_ORG_ID | NUMBER | |||
| TAX_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| TAX_EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
| RDNG_SHIP_TO_PTY_TX_PROF_ID | NUMBER | |||
| RDNG_SHIP_FROM_PTY_TX_PROF_ID | NUMBER | |||
| RDNG_BILL_TO_PTY_TX_PROF_ID | NUMBER | |||
| RDNG_BILL_FROM_PTY_TX_PROF_ID | NUMBER | |||
| RDNG_SHIP_TO_PTY_TX_P_ST_ID | NUMBER | |||
| RDNG_SHIP_FROM_PTY_TX_P_ST_ID | NUMBER | |||
| RDNG_BILL_TO_PTY_TX_P_ST_ID | NUMBER | |||
| RDNG_BILL_FROM_PTY_TX_P_ST_ID | NUMBER | |||
| LINE_INTENDED_USE | VARCHAR2 | (240) | ||
| TRX_LINE_TYPE | VARCHAR2 | (30) | ||
| TRX_SHIPPING_DATE | DATE | |||
| TRX_RECEIPT_DATE | DATE | |||
| TRX_SIC_CODE | VARCHAR2 | (150) | ||
| FOB_POINT | VARCHAR2 | (30) | ||
| TRX_WAYBILL_NUMBER | VARCHAR2 | (50) | ||
| PRODUCT_ID | NUMBER | |||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | ||
| PRODUCT_ORG_ID | NUMBER | |||
| UOM_CODE | VARCHAR2 | (30) | ||
| PRODUCT_TYPE | VARCHAR2 | (240) | ||
| PRODUCT_CODE | VARCHAR2 | (300) | ||
| PRODUCT_CATEGORY | VARCHAR2 | (240) | ||
| PRODUCT_DESCRIPTION | VARCHAR2 | (240) | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (30) | ||
| LINE_AMT | NUMBER | Yes | ||
| TRX_LINE_QUANTITY | NUMBER | |||
| CASH_DISCOUNT | NUMBER | |||
| VOLUME_DISCOUNT | NUMBER | |||
| TRADING_DISCOUNT | NUMBER | |||
| TRANSFER_CHARGE | NUMBER | |||
| TRANSPORTATION_CHARGE | NUMBER | |||
| INSURANCE_CHARGE | NUMBER | |||
| OTHER_CHARGE | NUMBER | |||
| ASSESSABLE_VALUE | NUMBER | |||
| ASSET_FLAG | VARCHAR2 | (1) | ||
| ASSET_NUMBER | VARCHAR2 | (150) | ||
| ASSET_ACCUM_DEPRECIATION | NUMBER | |||
| ASSET_TYPE | VARCHAR2 | (150) | ||
| ASSET_COST | NUMBER | |||
| RELATED_DOC_APPLICATION_ID | NUMBER | |||
| RELATED_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
| RELATED_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| RELATED_DOC_TRX_ID | NUMBER | |||
| REL_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| REL_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| REL_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| REL_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| REL_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| REL_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| RELATED_DOC_NUMBER | VARCHAR2 | (150) | ||
| RELATED_DOC_DATE | DATE | |||
| APPLIED_FROM_APPLICATION_ID | NUMBER | |||
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_TRX_ID | NUMBER | |||
| APP_FROM_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| APP_FROM_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| APP_FROM_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| APP_FROM_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| APP_FROM_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| APP_FROM_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| APPLIED_FROM_LINE_ID | NUMBER | |||
| APP_FROM_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| APP_FROM_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| APP_FROM_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| APP_FROM_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| APP_FROM_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| APP_FROM_LIN_TRX_USER_KEY6 | 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 | |||
| ADJ_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| ADJ_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| ADJ_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| ADJ_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| ADJ_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| ADJ_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_LINE_ID | NUMBER | |||
| ADJ_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| ADJ_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| ADJ_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| ADJ_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| ADJ_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| ADJ_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_DATE | DATE | |||
| APPLIED_TO_APPLICATION_ID | NUMBER | |||
| APPLIED_TO_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| APPLIED_TO_TRX_ID | NUMBER | |||
| APP_TO_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| APP_TO_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| APP_TO_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| APP_TO_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| APP_TO_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| APP_TO_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| APPLIED_TO_TRX_LINE_ID | NUMBER | |||
| APP_TO_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| APP_TO_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| APP_TO_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| APP_TO_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| APP_TO_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| APP_TO_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
| EXEMPT_REASON | VARCHAR2 | (240) | ||
| HISTORICAL_FLAG | VARCHAR2 | (1) | ||
| TRX_LINE_GL_DATE | DATE | |||
| LINE_AMT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Yes | |
| ACCOUNT_CCID | NUMBER | |||
| ACCOUNT_STRING | VARCHAR2 | (2000) | ||
| MERCHANT_PARTY_TAX_PROF_ID | NUMBER | |||
| HQ_ESTB_PARTY_TAX_PROF_ID | NUMBER | |||
| 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 | |||
| MERCHANT_PARTY_NAME | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_DOCUMENT_NUMBER | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_REFERENCE | VARCHAR2 | (250) | ||
| MERCHANT_PARTY_TAXPAYER_ID | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_TAX_REG_NUMBER | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_ID | NUMBER | |||
| MERCHANT_PARTY_COUNTRY | VARCHAR2 | (150) | ||
| SHIP_TO_LOCATION_ID | NUMBER | |||
| SHIP_FROM_LOCATION_ID | NUMBER | |||
| POA_LOCATION_ID | NUMBER | |||
| POO_LOCATION_ID | NUMBER | |||
| BILL_TO_LOCATION_ID | NUMBER | |||
| BILL_FROM_LOCATION_ID | NUMBER | |||
| PAYING_LOCATION_ID | NUMBER | |||
| OWN_HQ_LOCATION_ID | NUMBER | |||
| TRADING_HQ_LOCATION_ID | NUMBER | |||
| POC_LOCATION_ID | NUMBER | |||
| POI_LOCATION_ID | NUMBER | |||
| POD_LOCATION_ID | NUMBER | |||
| TITLE_TRANSFER_LOCATION_ID | NUMBER | |||
| SHIP_TO_PARTY_TAX_PROF_ID | NUMBER | |||
| SHIP_FROM_PARTY_TAX_PROF_ID | NUMBER | |||
| POA_PARTY_TAX_PROF_ID | NUMBER | |||
| POO_PARTY_TAX_PROF_ID | NUMBER | |||
| PAYING_PARTY_TAX_PROF_ID | NUMBER | |||
| OWN_HQ_PARTY_TAX_PROF_ID | NUMBER | |||
| TRADING_HQ_PARTY_TAX_PROF_ID | NUMBER | |||
| POI_PARTY_TAX_PROF_ID | NUMBER | |||
| POD_PARTY_TAX_PROF_ID | NUMBER | |||
| BILL_TO_PARTY_TAX_PROF_ID | NUMBER | |||
| BILL_FROM_PARTY_TAX_PROF_ID | NUMBER | |||
| TITLE_TRANS_PARTY_TAX_PROF_ID | NUMBER | |||
| SHIP_TO_SITE_TAX_PROF_ID | NUMBER | |||
| SHIP_FROM_SITE_TAX_PROF_ID | NUMBER | |||
| POA_SITE_TAX_PROF_ID | NUMBER | |||
| POO_SITE_TAX_PROF_ID | NUMBER | |||
| PAYING_SITE_TAX_PROF_ID | NUMBER | |||
| OWN_HQ_SITE_TAX_PROF_ID | NUMBER | |||
| TRADING_HQ_SITE_TAX_PROF_ID | NUMBER | |||
| POI_SITE_TAX_PROF_ID | NUMBER | |||
| POD_SITE_TAX_PROF_ID | NUMBER | |||
| BILL_TO_SITE_TAX_PROF_ID | NUMBER | |||
| BILL_FROM_SITE_TAX_PROF_ID | NUMBER | |||
| TITLE_TRANS_SITE_TAX_PROF_ID | NUMBER | |||
| CTRL_HDR_TX_APPL_FLAG | VARCHAR2 | (1) | ||
| CTRL_TOTAL_LINE_TX_AMT | NUMBER | |||
| CTRL_TOTAL_HDR_TX_AMT | 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_HDR_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| REF_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| REF_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| REF_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| REF_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| REF_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| REF_DOC_LINE_ID | NUMBER | |||
| REF_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | (150) | ||
| REF_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | (150) | ||
| REF_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | (150) | ||
| REF_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | (150) | ||
| REF_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | (150) | ||
| REF_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | (150) | ||
| REF_DOC_LINE_QUANTITY | NUMBER | |||
| LINE_CLASS | VARCHAR2 | (30) | ||
| TRX_LINE_DATE | DATE | |||
| INPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | ||
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | ||
| INTERNAL_ORG_LOCATION_ID | NUMBER | |||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| PORT_OF_ENTRY_CODE | VARCHAR2 | (30) | ||
| TAX_REPORTING_FLAG | VARCHAR2 | (1) | ||
| TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | ||
| COMPOUNDING_TAX_FLAG | VARCHAR2 | (1) | ||
| TRX_ID_LEVEL5 | NUMBER | |||
| TRX_ID_LEVEL2 | NUMBER | |||
| TRX_ID_LEVEL3 | NUMBER | |||
| TRX_ID_LEVEL4 | NUMBER | |||
| EVENT_ID | NUMBER | (15) | ||
| THRESHOLD_INDICATOR_FLAG | VARCHAR2 | (1) | ||
| PROVNL_TAX_DETERMINATION_DATE | DATE | |||
| UNIT_PRICE | NUMBER | |||
| SHIP_TO_CUST_ACCT_SITE_USE_ID | NUMBER | |||
| BILL_TO_CUST_ACCT_SITE_USE_ID | NUMBER | |||
| TRX_BATCH_ID | NUMBER | (15) | ||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | (150) | ||
| START_EXPENSE_DATE | DATE | |||
| SOURCE_APPLICATION_ID | NUMBER | |||
| SOURCE_ENTITY_CODE | VARCHAR2 | (30) | ||
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| SOURCE_TRX_ID | NUMBER | |||
| SOURCE_LINE_ID | NUMBER | |||
| SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| RECORD_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| REF_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| APPLIED_TO_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| INCLUSIVE_TAX_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
| TAX_PROCESSING_COMPLETED_FLAG | VARCHAR2 | (1) | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| APPLICATION_DOC_STATUS | VARCHAR2 | (30) | ||
| USER_UPD_DET_FACTORS_FLAG | VARCHAR2 | (1) | ||
| SOURCE_TAX_LINE_ID | NUMBER | |||
| REVERSED_APPLN_ID | NUMBER | |||
| REVERSED_ENTITY_CODE | VARCHAR2 | (30) | ||
| REVERSED_EVNT_CLS_CODE | VARCHAR2 | (30) | ||
| REVERSED_TRX_ID | NUMBER | |||
| REVERSED_TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| REVERSED_TRX_LINE_ID | NUMBER | |||
| TAX_CALCULATION_DONE_FLAG | VARCHAR2 | (1) | ||
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | (150) | ||
| PARTNER_MIGRATED_FLAG | VARCHAR2 | (1) | ||
| SHIP_THIRD_PTY_ACCT_SITE_ID | NUMBER | |||
| BILL_THIRD_PTY_ACCT_SITE_ID | NUMBER | |||
| SHIP_THIRD_PTY_ACCT_ID | NUMBER | |||
| BILL_THIRD_PTY_ACCT_ID | NUMBER | |||
| EXEMPTION_CONTROL_FLAG | VARCHAR2 | (1) | ||
| EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| INTERFACE_ENTITY_CODE | VARCHAR2 | (30) | ||
| INTERFACE_LINE_ID | NUMBER | |||
| DEFAULTING_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| DEFAULTING_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| TRX_ID_LEVEL6 | NUMBER | |||
| HISTORICAL_TAX_CODE_ID | NUMBER | (15) | ||
| ICX_SESSION_ID | NUMBER | (15) | ||
| TRX_LINE_CURRENCY_CODE | VARCHAR2 | (15) | ||
| TRX_LINE_CURRENCY_CONV_RATE | NUMBER | |||
| TRX_LINE_CURRENCY_CONV_DATE | DATE | |||
| TRX_LINE_PRECISION | NUMBER | |||
| TRX_LINE_MAU | NUMBER | |||
| TRX_LINE_CURRENCY_CONV_TYPE | VARCHAR2 | (30) | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| TOTAL_INC_TAX_AMT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INTERNAL_ORGANIZATION_ID
, APPLICATION_ID
, ENTITY_CODE
, EVENT_CLASS_CODE
, EVENT_CLASS_MAPPING_ID
, EVENT_TYPE_CODE
, DOC_EVENT_STATUS
, LINE_LEVEL_ACTION
, TRX_ID
, TRX_LINE_ID
, TRX_LEVEL_TYPE
, HDR_TRX_USER_KEY1
, HDR_TRX_USER_KEY2
, HDR_TRX_USER_KEY3
, HDR_TRX_USER_KEY4
, HDR_TRX_USER_KEY5
, HDR_TRX_USER_KEY6
, LINE_TRX_USER_KEY1
, LINE_TRX_USER_KEY2
, LINE_TRX_USER_KEY3
, LINE_TRX_USER_KEY4
, LINE_TRX_USER_KEY5
, LINE_TRX_USER_KEY6
, TRX_DATE
, TRX_DOC_REVISION
, LEDGER_ID
, TRX_CURRENCY_CODE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, MINIMUM_ACCOUNTABLE_UNIT
, PRECISION
, LEGAL_ENTITY_ID
, ESTABLISHMENT_ID
, RECEIVABLES_TRX_TYPE_ID
, DEFAULT_TAXATION_COUNTRY
, TRX_NUMBER
, TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION
, TRX_DESCRIPTION
, TRX_COMMUNICATED_DATE
, BATCH_SOURCE_ID
, BATCH_SOURCE_NAME
, DOC_SEQ_ID
, DOC_SEQ_NAME
, DOC_SEQ_VALUE
, TRX_DUE_DATE
, TRX_TYPE_DESCRIPTION
, DOCUMENT_SUB_TYPE
, SUPPLIER_TAX_INVOICE_NUMBER
, SUPPLIER_TAX_INVOICE_DATE
, SUPPLIER_EXCHANGE_RATE
, TAX_INVOICE_DATE
, TAX_INVOICE_NUMBER
, FIRST_PTY_ORG_ID
, TAX_EVENT_CLASS_CODE
, TAX_EVENT_TYPE_CODE
, RDNG_SHIP_TO_PTY_TX_PROF_ID
, RDNG_SHIP_FROM_PTY_TX_PROF_ID
, RDNG_BILL_TO_PTY_TX_PROF_ID
, RDNG_BILL_FROM_PTY_TX_PROF_ID
, RDNG_SHIP_TO_PTY_TX_P_ST_ID
, RDNG_SHIP_FROM_PTY_TX_P_ST_ID
, RDNG_BILL_TO_PTY_TX_P_ST_ID
, RDNG_BILL_FROM_PTY_TX_P_ST_ID
, LINE_INTENDED_USE
, TRX_LINE_TYPE
, TRX_SHIPPING_DATE
, TRX_RECEIPT_DATE
, TRX_SIC_CODE
, FOB_POINT
, TRX_WAYBILL_NUMBER
, PRODUCT_ID
, PRODUCT_FISC_CLASSIFICATION
, PRODUCT_ORG_ID
, UOM_CODE
, PRODUCT_TYPE
, PRODUCT_CODE
, PRODUCT_CATEGORY
, PRODUCT_DESCRIPTION
, USER_DEFINED_FISC_CLASS
, LINE_AMT
, TRX_LINE_QUANTITY
, CASH_DISCOUNT
, VOLUME_DISCOUNT
, TRADING_DISCOUNT
, TRANSFER_CHARGE
, TRANSPORTATION_CHARGE
, INSURANCE_CHARGE
, OTHER_CHARGE
, ASSESSABLE_VALUE
, ASSET_FLAG
, ASSET_NUMBER
, ASSET_ACCUM_DEPRECIATION
, ASSET_TYPE
, ASSET_COST
, RELATED_DOC_APPLICATION_ID
, RELATED_DOC_ENTITY_CODE
, RELATED_DOC_EVENT_CLASS_CODE
, RELATED_DOC_TRX_ID
, REL_DOC_HDR_TRX_USER_KEY1
, REL_DOC_HDR_TRX_USER_KEY2
, REL_DOC_HDR_TRX_USER_KEY3
, REL_DOC_HDR_TRX_USER_KEY4
, REL_DOC_HDR_TRX_USER_KEY5
, REL_DOC_HDR_TRX_USER_KEY6
, RELATED_DOC_NUMBER
, RELATED_DOC_DATE
, APPLIED_FROM_APPLICATION_ID
, APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_TRX_ID
, APP_FROM_HDR_TRX_USER_KEY1
, APP_FROM_HDR_TRX_USER_KEY2
, APP_FROM_HDR_TRX_USER_KEY3
, APP_FROM_HDR_TRX_USER_KEY4
, APP_FROM_HDR_TRX_USER_KEY5
, APP_FROM_HDR_TRX_USER_KEY6
, APPLIED_FROM_LINE_ID
, APP_FROM_LIN_TRX_USER_KEY1
, APP_FROM_LIN_TRX_USER_KEY2
, APP_FROM_LIN_TRX_USER_KEY3
, APP_FROM_LIN_TRX_USER_KEY4
, APP_FROM_LIN_TRX_USER_KEY5
, APP_FROM_LIN_TRX_USER_KEY6
, ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_TRX_ID
, ADJ_DOC_HDR_TRX_USER_KEY1
, ADJ_DOC_HDR_TRX_USER_KEY2
, ADJ_DOC_HDR_TRX_USER_KEY3
, ADJ_DOC_HDR_TRX_USER_KEY4
, ADJ_DOC_HDR_TRX_USER_KEY5
, ADJ_DOC_HDR_TRX_USER_KEY6
, ADJUSTED_DOC_LINE_ID
, ADJ_DOC_LIN_TRX_USER_KEY1
, ADJ_DOC_LIN_TRX_USER_KEY2
, ADJ_DOC_LIN_TRX_USER_KEY3
, ADJ_DOC_LIN_TRX_USER_KEY4
, ADJ_DOC_LIN_TRX_USER_KEY5
, ADJ_DOC_LIN_TRX_USER_KEY6
, ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE
, APPLIED_TO_APPLICATION_ID
, APPLIED_TO_ENTITY_CODE
, APPLIED_TO_EVENT_CLASS_CODE
, APPLIED_TO_TRX_ID
, APP_TO_HDR_TRX_USER_KEY1
, APP_TO_HDR_TRX_USER_KEY2
, APP_TO_HDR_TRX_USER_KEY3
, APP_TO_HDR_TRX_USER_KEY4
, APP_TO_HDR_TRX_USER_KEY5
, APP_TO_HDR_TRX_USER_KEY6
, APPLIED_TO_TRX_LINE_ID
, APP_TO_LIN_TRX_USER_KEY1
, APP_TO_LIN_TRX_USER_KEY2
, APP_TO_LIN_TRX_USER_KEY3
, APP_TO_LIN_TRX_USER_KEY4
, APP_TO_LIN_TRX_USER_KEY5
, APP_TO_LIN_TRX_USER_KEY6
, TRX_BUSINESS_CATEGORY
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON
, HISTORICAL_FLAG
, TRX_LINE_GL_DATE
, LINE_AMT_INCLUDES_TAX_FLAG
, ACCOUNT_CCID
, ACCOUNT_STRING
, MERCHANT_PARTY_TAX_PROF_ID
, HQ_ESTB_PARTY_TAX_PROF_ID
, 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
, MERCHANT_PARTY_NAME
, MERCHANT_PARTY_DOCUMENT_NUMBER
, MERCHANT_PARTY_REFERENCE
, MERCHANT_PARTY_TAXPAYER_ID
, MERCHANT_PARTY_TAX_REG_NUMBER
, MERCHANT_PARTY_ID
, MERCHANT_PARTY_COUNTRY
, SHIP_TO_LOCATION_ID
, SHIP_FROM_LOCATION_ID
, POA_LOCATION_ID
, POO_LOCATION_ID
, BILL_TO_LOCATION_ID
, BILL_FROM_LOCATION_ID
, PAYING_LOCATION_ID
, OWN_HQ_LOCATION_ID
, TRADING_HQ_LOCATION_ID
, POC_LOCATION_ID
, POI_LOCATION_ID
, POD_LOCATION_ID
, TITLE_TRANSFER_LOCATION_ID
, SHIP_TO_PARTY_TAX_PROF_ID
, SHIP_FROM_PARTY_TAX_PROF_ID
, POA_PARTY_TAX_PROF_ID
, POO_PARTY_TAX_PROF_ID
, PAYING_PARTY_TAX_PROF_ID
, OWN_HQ_PARTY_TAX_PROF_ID
, TRADING_HQ_PARTY_TAX_PROF_ID
, POI_PARTY_TAX_PROF_ID
, POD_PARTY_TAX_PROF_ID
, BILL_TO_PARTY_TAX_PROF_ID
, BILL_FROM_PARTY_TAX_PROF_ID
, TITLE_TRANS_PARTY_TAX_PROF_ID
, SHIP_TO_SITE_TAX_PROF_ID
, SHIP_FROM_SITE_TAX_PROF_ID
, POA_SITE_TAX_PROF_ID
, POO_SITE_TAX_PROF_ID
, PAYING_SITE_TAX_PROF_ID
, OWN_HQ_SITE_TAX_PROF_ID
, TRADING_HQ_SITE_TAX_PROF_ID
, POI_SITE_TAX_PROF_ID
, POD_SITE_TAX_PROF_ID
, BILL_TO_SITE_TAX_PROF_ID
, BILL_FROM_SITE_TAX_PROF_ID
, TITLE_TRANS_SITE_TAX_PROF_ID
, CTRL_HDR_TX_APPL_FLAG
, CTRL_TOTAL_LINE_TX_AMT
, CTRL_TOTAL_HDR_TX_AMT
, REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID
, REF_DOC_HDR_TRX_USER_KEY1
, REF_DOC_HDR_TRX_USER_KEY2
, REF_DOC_HDR_TRX_USER_KEY3
, REF_DOC_HDR_TRX_USER_KEY4
, REF_DOC_HDR_TRX_USER_KEY5
, REF_DOC_HDR_TRX_USER_KEY6
, REF_DOC_LINE_ID
, REF_DOC_LIN_TRX_USER_KEY1
, REF_DOC_LIN_TRX_USER_KEY2
, REF_DOC_LIN_TRX_USER_KEY3
, REF_DOC_LIN_TRX_USER_KEY4
, REF_DOC_LIN_TRX_USER_KEY5
, REF_DOC_LIN_TRX_USER_KEY6
, REF_DOC_LINE_QUANTITY
, LINE_CLASS
, TRX_LINE_DATE
, INPUT_TAX_CLASSIFICATION_CODE
, OUTPUT_TAX_CLASSIFICATION_CODE
, INTERNAL_ORG_LOCATION_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PORT_OF_ENTRY_CODE
, TAX_REPORTING_FLAG
, TAX_AMT_INCLUDED_FLAG
, COMPOUNDING_TAX_FLAG
, TRX_ID_LEVEL5
, TRX_ID_LEVEL2
, TRX_ID_LEVEL3
, TRX_ID_LEVEL4
, EVENT_ID
, THRESHOLD_INDICATOR_FLAG
, PROVNL_TAX_DETERMINATION_DATE
, UNIT_PRICE
, SHIP_TO_CUST_ACCT_SITE_USE_ID
, BILL_TO_CUST_ACCT_SITE_USE_ID
, TRX_BATCH_ID
, APPLIED_TO_TRX_NUMBER
, START_EXPENSE_DATE
, SOURCE_APPLICATION_ID
, SOURCE_ENTITY_CODE
, SOURCE_EVENT_CLASS_CODE
, SOURCE_TRX_ID
, SOURCE_LINE_ID
, SOURCE_TRX_LEVEL_TYPE
, RECORD_TYPE_CODE
, REF_DOC_TRX_LEVEL_TYPE
, APPLIED_TO_TRX_LEVEL_TYPE
, APPLIED_FROM_TRX_LEVEL_TYPE
, ADJUSTED_DOC_TRX_LEVEL_TYPE
, INCLUSIVE_TAX_OVERRIDE_FLAG
, TAX_PROCESSING_COMPLETED_FLAG
, OBJECT_VERSION_NUMBER
, APPLICATION_DOC_STATUS
, USER_UPD_DET_FACTORS_FLAG
, SOURCE_TAX_LINE_ID
, REVERSED_APPLN_ID
, REVERSED_ENTITY_CODE
, REVERSED_EVNT_CLS_CODE
, REVERSED_TRX_ID
, REVERSED_TRX_LEVEL_TYPE
, REVERSED_TRX_LINE_ID
, TAX_CALCULATION_DONE_FLAG
, APPLIED_FROM_TRX_NUMBER
, PARTNER_MIGRATED_FLAG
, SHIP_THIRD_PTY_ACCT_SITE_ID
, BILL_THIRD_PTY_ACCT_SITE_ID
, SHIP_THIRD_PTY_ACCT_ID
, BILL_THIRD_PTY_ACCT_ID
, EXEMPTION_CONTROL_FLAG
, EXEMPT_REASON_CODE
, INTERFACE_ENTITY_CODE
, INTERFACE_LINE_ID
, DEFAULTING_ATTRIBUTE1
, DEFAULTING_ATTRIBUTE2
, DEFAULTING_ATTRIBUTE3
, DEFAULTING_ATTRIBUTE4
, DEFAULTING_ATTRIBUTE5
, DEFAULTING_ATTRIBUTE6
, DEFAULTING_ATTRIBUTE7
, DEFAULTING_ATTRIBUTE8
, DEFAULTING_ATTRIBUTE9
, DEFAULTING_ATTRIBUTE10
, TRX_ID_LEVEL6
, HISTORICAL_TAX_CODE_ID
, ICX_SESSION_ID
, TRX_LINE_CURRENCY_CODE
, TRX_LINE_CURRENCY_CONV_RATE
, TRX_LINE_CURRENCY_CONV_DATE
, TRX_LINE_PRECISION
, TRX_LINE_MAU
, TRX_LINE_CURRENCY_CONV_TYPE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE_CATEGORY
, TOTAL_INC_TAX_AMT
FROM ZX.ZX_LINES_DET_FACTORS#;
ZX
ZX_LINES_DET_FACTORS
APPS
ZX_LINES_DET_FACTORS
ZX_LINES_DET_FACTORS_TMP
|
|
|
|