[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_REP_TRX_DETAIL_T# |
|---|---|
| Object Type: | VIEW |
| Owner: | ZX |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DETAIL_TAX_LINE_ID | NUMBER | (15) | Yes | |
| REP_CONTEXT_ID | NUMBER | (15) | ||
| EXTRACT_LINE_ID | NUMBER | (15) | ||
| EXTRACT_REPORT_LINE_NUMBER | NUMBER | |||
| LEDGER_ID | NUMBER | (15) | ||
| LEDGER_NAME | VARCHAR2 | (30) | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | ||
| EXTRACT_SOURCE_LEDGER | VARCHAR2 | (30) | ||
| EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| EVENT_CLASS_MAPPING_ID | NUMBER | |||
| DOC_EVENT_STATUS | VARCHAR2 | (30) | ||
| APPLICATION_DOC_STATUS | VARCHAR2 | (30) | ||
| ESTABLISHMENT_ID | NUMBER | |||
| APPLICATION_ID | NUMBER | |||
| INTERNAL_ORGANIZATION_ID | NUMBER | |||
| TRX_ID | NUMBER | |||
| TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| TRX_LINE_ID | NUMBER | |||
| TRX_LINE_NUMBER | NUMBER | |||
| TRX_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_LINE_TYPE | VARCHAR2 | (30) | ||
| TRX_DATE | DATE | |||
| DEPOSIT_DATE | DATE | |||
| TRX_DUE_DATE | DATE | |||
| TRX_SHIPPING_DATE | DATE | |||
| TRX_COMMUNICATED_DATE | DATE | |||
| TRX_TYPE_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_TYPE_ID | NUMBER | (15) | ||
| TRX_LEVEL_TYPE | VARCHAR2 | (30) | ||
| TRX_BATCH_SOURCE_NAME | VARCHAR2 | (150) | ||
| TRX_SIC_CODE | VARCHAR2 | (150) | ||
| FOB_POINT | VARCHAR2 | (30) | ||
| TRX_WAYBILL_NUMBER | VARCHAR2 | (50) | ||
| TRX_LINE_CLASS | VARCHAR2 | (30) | ||
| PRODUCT_ID | NUMBER | |||
| PRODUCT_DESCRIPTION | VARCHAR2 | (240) | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| PRECISION | NUMBER | |||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | |||
| GDF_FND_CURRENCIES_ATT1 | VARCHAR2 | (150) | ||
| CURRENCY_CODE_DESC | VARCHAR2 | (240) | ||
| TERRITORY_SHORT_NAME | VARCHAR2 | (80) | ||
| DOC_SEQ_ID | NUMBER | |||
| DOC_SEQ_NAME | VARCHAR2 | (150) | ||
| DOC_SEQ_VALUE | VARCHAR2 | (240) | ||
| TRX_LINE_QUANTITY | NUMBER | |||
| TRX_LINE_AMT | NUMBER | |||
| UOM_CODE | VARCHAR2 | (30) | ||
| RECEIPT_CLASS_ID | NUMBER | (15) | ||
| TRX_BATCH_SOURCE_ID | NUMBER | (15) | ||
| TRX_BATCH_SOURCE_DATE | DATE | |||
| 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_NUMBER | VARCHAR2 | (150) | ||
| RELATED_DOC_DATE | DATE | |||
| APPLIED_FROM_APPLICATION_ID | NUMBER | |||
| APPLIED_FROM_LINE_ID | NUMBER | |||
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_TRX_ID | NUMBER | |||
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_APPLIED_FROM_CLASS_MNG | VARCHAR2 | (80) | ||
| 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_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_DATE | DATE | |||
| APPLIED_TO_APPLICATION_ID | NUMBER | |||
| APPLIED_TO_TRX_ID | NUMBER | |||
| APPLIED_TO_TRX_LINE_ID | NUMBER | |||
| APPLIED_TO_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_APPLIED_TO_CLASS_MNG | VARCHAR2 | (80) | ||
| 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_LINE_ID | NUMBER | |||
| REF_DOC_LINE_QUANTITY | NUMBER | |||
| MERCHANT_PARTY_DOCUMENT_NUMBER | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_NAME | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_REFERENCE | VARCHAR2 | (250) | ||
| MERCHANT_PARTY_TAX_REG_NUMBER | VARCHAR2 | (150) | ||
| MERCHANT_PARTY_TAXPAYER_ID | VARCHAR2 | (150) | ||
| COUNTRY_OF_SUPPLY | VARCHAR2 | (150) | ||
| START_EXPENSE_DATE | DATE | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | (2) | ||
| TRX_CLASS_MNG | VARCHAR2 | (80) | ||
| TRX_TYPE_MNG | VARCHAR2 | (80) | ||
| TAX_RATE_CODE_REG_TYPE_MNG | VARCHAR2 | (80) | ||
| TAX_EXEMPT_REASON_MNG | VARCHAR2 | (80) | ||
| TAX_EXCEPTION_REASON_MNG | VARCHAR2 | (80) | ||
| TRX_QUANTITY_UOM_MNG | VARCHAR2 | (80) | ||
| TAX_RATE_CODE_VAT_TRX_TYPE_MNG | 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) | ||
| LINE_INTENDED_USE | VARCHAR2 | (240) | ||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | (240) | ||
| PRODUCT_CATEGORY | VARCHAR2 | (240) | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | (30) | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | (240) | ||
| ASSESSABLE_VALUE | NUMBER | |||
| PORT_OF_ENTRY_CODE | VARCHAR2 | (30) | ||
| TAXABLE_LINE_ITEM_FLEXFIELD | VARCHAR2 | (2000) | ||
| TAXABLE_LINE_SOURCE_TABLE | VARCHAR2 | (30) | ||
| TAXABLE_LINE_TOTAL_AMOUNT | NUMBER | |||
| TAX_LINE_ID | NUMBER | (15) | ||
| TAX_LINE_NUMBER | NUMBER | |||
| TAX_AMT | NUMBER | |||
| TAX_AMT_FUNCL_CURR | NUMBER | |||
| TAXABLE_AMT | NUMBER | |||
| TAXABLE_AMT_FUNCL_CURR | NUMBER | |||
| TAXABLE_DISC_AMT | NUMBER | |||
| TAXABLE_DISC_AMT_FUNCL_CURR | NUMBER | |||
| TAX_DISC_AMT | NUMBER | |||
| TAX_DISC_AMT_FUNCL_CURR | NUMBER | |||
| TAX_RATE_CODE | VARCHAR2 | (50) | ||
| TAX_RATE | NUMBER | |||
| TAX_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | ||
| TAX_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_TYPE_MNG | VARCHAR2 | (80) | ||
| TAX_STATUS_ID | NUMBER | (15) | ||
| TAX_RATE_CODE_NAME | VARCHAR2 | (240) | ||
| TAX_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | ||
| TAX_RATE_ID | NUMBER | (15) | ||
| TAX_RATE_REGISTER_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_APPLIED | NUMBER | |||
| TAX_PROVIDER_ID | NUMBER | |||
| DEF_REC_SETTLEMENT_OPTION_CODE | VARCHAR2 | (30) | ||
| OFFSET_TAX_RATE_CODE | VARCHAR2 | (50) | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
| EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| TAX_EXCEPTION_REASON_CODE | VARCHAR2 | (30) | ||
| TAX_EXEMPTION_ID | NUMBER | (15) | ||
| TAX_EXCEPTION_ID | NUMBER | (15) | ||
| TAX_RECOVERY_RATE | NUMBER | |||
| TAX_REGIME_CODE | VARCHAR2 | (30) | ||
| TAX | VARCHAR2 | (30) | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | (30) | ||
| TAX_STATUS_CODE | VARCHAR2 | (30) | ||
| TAX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| EXCEPTION_RATE | NUMBER | |||
| EXEMPT_RATE_MODIFIER | NUMBER | |||
| TAX_DATE | DATE | |||
| TAX_DETERMINE_DATE | DATE | |||
| TAX_APPORTIONMENT_LINE_NUMBER | NUMBER | |||
| TAX_AMT_TAX_CURR | NUMBER | |||
| TAXABLE_AMT_TAX_CURR | NUMBER | |||
| ORIG_TAXABLE_AMT | NUMBER | |||
| ORIG_TAXABLE_AMT_TAX_CURR | NUMBER | |||
| ORIG_TAX_AMT | NUMBER | |||
| ORIG_TAX_AMT_TAX_CURR | NUMBER | |||
| ORIG_REC_NREC_TAX_AMT | NUMBER | |||
| REC_TAX_AMT_TAX_CURR | NUMBER | |||
| NREC_TAX_AMT_TAX_CURR | NUMBER | |||
| TAX_LINE_USER_CATEGORY | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| TAX_LINE_USER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| RECOVERY_TYPE_CODE | VARCHAR2 | (30) | ||
| RECOVERY_RATE_CODE | VARCHAR2 | (150) | ||
| BILLING_TP_NAME | VARCHAR2 | (360) | ||
| BILLING_TP_NUMBER | VARCHAR2 | (240) | ||
| BILLING_TP_TAX_REG_NUM | VARCHAR2 | (50) | ||
| BILLING_TP_TAXPAYER_ID | VARCHAR2 | (50) | ||
| BILLING_TP_SITE_NAME_ALT | VARCHAR2 | (320) | ||
| BILLING_TP_NAME_ALT | VARCHAR2 | (320) | ||
| BILLING_TP_SIC_CODE | VARCHAR2 | (30) | ||
| BILLING_TP_CITY | VARCHAR2 | (60) | ||
| BILLING_TP_COUNTY | VARCHAR2 | (60) | ||
| BILLING_TP_STATE | VARCHAR2 | (150) | ||
| BILLING_TP_PROVINCE | VARCHAR2 | (60) | ||
| BILLING_TP_ADDRESS1 | VARCHAR2 | (240) | ||
| BILLING_TP_ADDRESS2 | VARCHAR2 | (240) | ||
| BILLING_TP_ADDRESS3 | VARCHAR2 | (240) | ||
| BILLING_TP_ADDRESS_LINES_ALT | VARCHAR2 | (560) | ||
| BILLING_TP_COUNTRY | VARCHAR2 | (60) | ||
| BILLING_TP_POSTAL_CODE | VARCHAR2 | (60) | ||
| SHIPPING_TP_NUMBER | VARCHAR2 | (60) | ||
| SHIPPING_TP_TAX_REG_NUM | VARCHAR2 | (50) | ||
| SHIPPING_TP_TAXPAYER_ID | VARCHAR2 | (50) | ||
| SHIPPING_TP_NAME | VARCHAR2 | (360) | ||
| SHIPPING_TP_NAME_ALT | VARCHAR2 | (320) | ||
| SHIPPING_TP_SIC_CODE | VARCHAR2 | (30) | ||
| SHIPPING_TP_CITY | VARCHAR2 | (60) | ||
| SHIPPING_TP_COUNTY | VARCHAR2 | (60) | ||
| SHIPPING_TP_STATE | VARCHAR2 | (60) | ||
| SHIPPING_TP_PROVINCE | VARCHAR2 | (60) | ||
| SHIPPING_TP_ADDRESS1 | VARCHAR2 | (240) | ||
| SHIPPING_TP_ADDRESS2 | VARCHAR2 | (240) | ||
| SHIPPING_TP_ADDRESS3 | VARCHAR2 | (240) | ||
| SHIPPING_TP_ADDRESS_LINES_ALT | VARCHAR2 | (560) | ||
| SHIPPING_TP_COUNTRY | VARCHAR2 | (60) | ||
| SHIPPING_TP_POSTAL_CODE | VARCHAR2 | (60) | ||
| BILLING_TP_PARTY_NUMBER | VARCHAR2 | (30) | ||
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | ||
| BILLING_TRADING_PARTNER_ID | NUMBER | (15) | ||
| BILLING_TP_SITE_ID | NUMBER | (15) | ||
| BILLING_TP_ADDRESS_ID | NUMBER | (15) | ||
| BILLING_TP_TAX_REPORTING_FLAG | VARCHAR2 | (1) | ||
| SHIPPING_TRADING_PARTNER_ID | NUMBER | (15) | ||
| SHIPPING_TP_SITE_ID | NUMBER | (15) | ||
| SHIPPING_TP_ADDRESS_ID | NUMBER | (15) | ||
| BANKING_TP_NAME | VARCHAR2 | (360) | ||
| BANKING_TP_TAXPAYER_ID | VARCHAR2 | (50) | ||
| BANK_ACCOUNT_ID | NUMBER | (15) | ||
| BANK_BRANCH_ID | NUMBER | (15) | ||
| BILLING_TP_SITE_NAME | VARCHAR2 | (40) | ||
| BILLING_TP_SITE_TAX_REG_NUM | VARCHAR2 | (50) | ||
| SHIPPING_TP_SITE_NAME | VARCHAR2 | (40) | ||
| SHIPPING_TP_SITE_TAX_REG_NUM | VARCHAR2 | (50) | ||
| OFFICE_SITE_FLAG | VARCHAR2 | (1) | ||
| SHIP_TO_LOCATION_ID | NUMBER | |||
| SHIP_FROM_LOCATION_ID | NUMBER | |||
| BILL_TO_LOCATION_ID | NUMBER | |||
| BILL_FROM_LOCATION_ID | NUMBER | |||
| SHIP_TO_PARTY_TAX_PROF_ID | NUMBER | |||
| SHIP_FROM_PARTY_TAX_PROF_ID | NUMBER | |||
| BILL_TO_PARTY_TAX_PROF_ID | NUMBER | |||
| BILL_FROM_PARTY_TAX_PROF_ID | NUMBER | |||
| OWN_HQ_PARTY_TAX_PROF_ID | NUMBER | |||
| SHIP_TO_SITE_TAX_PROF_ID | NUMBER | |||
| BILL_TO_SITE_TAX_PROF_ID | NUMBER | |||
| SHIP_FROM_SITE_TAX_PROF_ID | NUMBER | |||
| BILL_FROM_SITE_TAX_PROF_ID | NUMBER | |||
| OWN_HQ_PARTY_SITE_PROF_ID | NUMBER | |||
| SHIP_TO_PARTY_ID | NUMBER | (15) | ||
| SHIP_FROM_PARTY_ID | NUMBER | (15) | ||
| BILL_TO_PARTY_ID | NUMBER | (15) | ||
| BILL_FROM_PARTY_ID | NUMBER | (15) | ||
| OWN_HQ_PARTY_ID | NUMBER | (15) | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | (15) | ||
| SHIP_FROM_PARTY_SITE_ID | NUMBER | (15) | ||
| BILL_TO_PARTY_SITE_ID | NUMBER | (15) | ||
| BILL_FROM_PARTY_SITE_ID | NUMBER | (15) | ||
| REGISTRATION_STATUS_CODE | VARCHAR2 | (30) | ||
| REG_PARTY_TAX_PROF_ID | NUMBER | (15) | ||
| REG_PARTY_TAX_SITE_PROF_ID | NUMBER | (15) | ||
| POS_TAX_PARTY_PROF_ID | NUMBER | (15) | ||
| POS_TAX_PARTY_SITE_PROF_ID | NUMBER | (15) | ||
| POA_LOCATION_ID | NUMBER | |||
| PLACE_OF_SUPPLY_TYPE_CODE | VARCHAR2 | (30) | ||
| DEF_PLACE_OF_SUPPLY_TYPE_CODE | VARCHAR2 | (30) | ||
| POO_LOCATION_ID | NUMBER | |||
| LEGAL_ENTITY_TAX_REG_NUMBER | NUMBER | |||
| HQ_ESTB_REG_NUMBER | VARCHAR2 | (30) | ||
| TAX_LINE_REGISTRATION_NUMBER | VARCHAR2 | (50) | ||
| REGISTRATION_PARTY_TYPE | VARCHAR2 | (30) | ||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | ||
| BALANCING_SEGMENT_DESC | VARCHAR2 | (240) | ||
| CANCELLED_DATE | DATE | |||
| HISTORICAL_FLAG | VARCHAR2 | (1) | ||
| CANCEL_FLAG | VARCHAR2 | (1) | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | (1) | ||
| REPORTING_ONLY_FLAG | VARCHAR2 | (1) | ||
| TAX_ONLY_FLAG | VARCHAR2 | (1) | ||
| OFFSET_FLAG | VARCHAR2 | (1) | ||
| POSTED_FLAG | VARCHAR2 | (1) | ||
| MRC_TAX_LINE_FLAG | VARCHAR2 | (1) | ||
| SMALL_BUSINESS_FLAG | VARCHAR2 | (1) | ||
| RECONCILIATION_FLAG | VARCHAR2 | (1) | ||
| TAX_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
| REVERSE_FLAG | VARCHAR2 | (1) | ||
| AR_CASH_RECEIPT_REVERSE_STATUS | VARCHAR2 | (30) | ||
| AR_CASH_RECEIPT_REVERSE_DATE | DATE | |||
| TAXABLE_ITEM_SOURCE_ID | NUMBER | |||
| AMOUNT_APPLIED | NUMBER | |||
| BR_REF_CUSTOMER_TRX_ID | NUMBER | |||
| TAX_AMT_INCLUDED_FLAG | VARCHAR2 | (1) | ||
| 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) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_LOGIN_ID | NUMBER | |||
| GDF_PARTY_SITES_BILL_ATT8 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_BILL_ATT10 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_BILL_ATT12 | VARCHAR2 | (150) | ||
| GDF_RA_ADDRESSES_BILL_ATT8 | VARCHAR2 | (150) | ||
| GDF_RA_ADDRESSES_BILL_ATT9 | VARCHAR2 | (150) | ||
| GDF_PARTY_SITES_SHIP_ATT8 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_SHIP_ATT10 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_SHIP_ATT12 | VARCHAR2 | (150) | ||
| GDF_RA_ADDRESSES_SHIP_ATT8 | VARCHAR2 | (150) | ||
| GDF_RA_ADDRESSES_SHIP_ATT9 | VARCHAR2 | (150) | ||
| GDF_PO_VENDOR_SITE_ATT17 | VARCHAR2 | (150) | ||
| ACCTD_AMOUNT_CR | NUMBER | |||
| ACCTD_AMOUNT_DR | NUMBER | |||
| REC_APPLICATION_STATUS | VARCHAR2 | (30) | ||
| SUB_LEDGER_INVOICE_IDENTIFIER | VARCHAR2 | (20) | ||
| ACCOUNT_CLASS | VARCHAR2 | (20) | ||
| LATEST_REC_FLAG | VARCHAR2 | (1) | ||
| ENTITY_CODE | VARCHAR2 | (30) | ||
| POSTED_DATE | DATE | |||
| ACTG_SOURCE_ID | NUMBER | |||
| UNIT_PRICE | NUMBER | |||
| GL_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DETAIL_TAX_LINE_ID
, REP_CONTEXT_ID
, EXTRACT_LINE_ID
, EXTRACT_REPORT_LINE_NUMBER
, LEDGER_ID
, LEDGER_NAME
, CHART_OF_ACCOUNTS_ID
, EXTRACT_SOURCE_LEDGER
, EVENT_CLASS_CODE
, EVENT_CLASS_MAPPING_ID
, DOC_EVENT_STATUS
, APPLICATION_DOC_STATUS
, ESTABLISHMENT_ID
, APPLICATION_ID
, INTERNAL_ORGANIZATION_ID
, TRX_ID
, TRX_NUMBER
, TRX_DESCRIPTION
, TRX_CURRENCY_CODE
, TRX_LINE_ID
, TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION
, TRX_LINE_TYPE
, TRX_DATE
, DEPOSIT_DATE
, TRX_DUE_DATE
, TRX_SHIPPING_DATE
, TRX_COMMUNICATED_DATE
, TRX_TYPE_DESCRIPTION
, TRX_TYPE_ID
, TRX_LEVEL_TYPE
, TRX_BATCH_SOURCE_NAME
, TRX_SIC_CODE
, FOB_POINT
, TRX_WAYBILL_NUMBER
, TRX_LINE_CLASS
, PRODUCT_ID
, PRODUCT_DESCRIPTION
, FUNCTIONAL_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, PRECISION
, MINIMUM_ACCOUNTABLE_UNIT
, GDF_FND_CURRENCIES_ATT1
, CURRENCY_CODE_DESC
, TERRITORY_SHORT_NAME
, DOC_SEQ_ID
, DOC_SEQ_NAME
, DOC_SEQ_VALUE
, TRX_LINE_QUANTITY
, TRX_LINE_AMT
, UOM_CODE
, RECEIPT_CLASS_ID
, TRX_BATCH_SOURCE_ID
, TRX_BATCH_SOURCE_DATE
, 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_LINE_ID
, APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_TRX_ID
, APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_TRX_NUMBER
, TRX_APPLIED_FROM_CLASS_MNG
, ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_TRX_ID
, ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE
, APPLIED_TO_APPLICATION_ID
, APPLIED_TO_TRX_ID
, APPLIED_TO_TRX_LINE_ID
, APPLIED_TO_ENTITY_CODE
, APPLIED_TO_EVENT_CLASS_CODE
, APPLIED_TO_TRX_NUMBER
, TRX_APPLIED_TO_CLASS_MNG
, 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
, MERCHANT_PARTY_DOCUMENT_NUMBER
, MERCHANT_PARTY_NAME
, MERCHANT_PARTY_REFERENCE
, MERCHANT_PARTY_TAX_REG_NUMBER
, MERCHANT_PARTY_TAXPAYER_ID
, COUNTRY_OF_SUPPLY
, START_EXPENSE_DATE
, DEFAULT_TAXATION_COUNTRY
, TRX_CLASS_MNG
, TRX_TYPE_MNG
, TAX_RATE_CODE_REG_TYPE_MNG
, TAX_EXEMPT_REASON_MNG
, TAX_EXCEPTION_REASON_MNG
, TRX_QUANTITY_UOM_MNG
, TAX_RATE_CODE_VAT_TRX_TYPE_MNG
, DOCUMENT_SUB_TYPE
, SUPPLIER_TAX_INVOICE_NUMBER
, SUPPLIER_TAX_INVOICE_DATE
, SUPPLIER_EXCHANGE_RATE
, TAX_INVOICE_DATE
, TAX_INVOICE_NUMBER
, LINE_INTENDED_USE
, PRODUCT_FISC_CLASSIFICATION
, PRODUCT_CATEGORY
, USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY
, ASSESSABLE_VALUE
, PORT_OF_ENTRY_CODE
, TAXABLE_LINE_ITEM_FLEXFIELD
, TAXABLE_LINE_SOURCE_TABLE
, TAXABLE_LINE_TOTAL_AMOUNT
, TAX_LINE_ID
, TAX_LINE_NUMBER
, TAX_AMT
, TAX_AMT_FUNCL_CURR
, TAXABLE_AMT
, TAXABLE_AMT_FUNCL_CURR
, TAXABLE_DISC_AMT
, TAXABLE_DISC_AMT_FUNCL_CURR
, TAX_DISC_AMT
, TAX_DISC_AMT_FUNCL_CURR
, TAX_RATE_CODE
, TAX_RATE
, TAX_RATE_VAT_TRX_TYPE_CODE
, TAX_RATE_VAT_TRX_TYPE_DESC
, TAX_TYPE_CODE
, TAX_TYPE_MNG
, TAX_STATUS_ID
, TAX_RATE_CODE_NAME
, TAX_RATE_CODE_DESCRIPTION
, TAX_RATE_ID
, TAX_RATE_REGISTER_TYPE_CODE
, TAX_APPLIED
, TAX_PROVIDER_ID
, DEF_REC_SETTLEMENT_OPTION_CODE
, OFFSET_TAX_RATE_CODE
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE
, TAX_EXCEPTION_REASON_CODE
, TAX_EXEMPTION_ID
, TAX_EXCEPTION_ID
, TAX_RECOVERY_RATE
, TAX_REGIME_CODE
, TAX
, TAX_JURISDICTION_CODE
, TAX_STATUS_CODE
, TAX_CURRENCY_CODE
, EXCEPTION_RATE
, EXEMPT_RATE_MODIFIER
, TAX_DATE
, TAX_DETERMINE_DATE
, TAX_APPORTIONMENT_LINE_NUMBER
, TAX_AMT_TAX_CURR
, TAXABLE_AMT_TAX_CURR
, ORIG_TAXABLE_AMT
, ORIG_TAXABLE_AMT_TAX_CURR
, ORIG_TAX_AMT
, ORIG_TAX_AMT_TAX_CURR
, ORIG_REC_NREC_TAX_AMT
, REC_TAX_AMT_TAX_CURR
, NREC_TAX_AMT_TAX_CURR
, TAX_LINE_USER_CATEGORY
, TAX_LINE_USER_ATTRIBUTE1
, TAX_LINE_USER_ATTRIBUTE2
, TAX_LINE_USER_ATTRIBUTE3
, TAX_LINE_USER_ATTRIBUTE4
, TAX_LINE_USER_ATTRIBUTE5
, TAX_LINE_USER_ATTRIBUTE6
, TAX_LINE_USER_ATTRIBUTE7
, TAX_LINE_USER_ATTRIBUTE8
, TAX_LINE_USER_ATTRIBUTE9
, TAX_LINE_USER_ATTRIBUTE10
, TAX_LINE_USER_ATTRIBUTE11
, TAX_LINE_USER_ATTRIBUTE12
, TAX_LINE_USER_ATTRIBUTE13
, TAX_LINE_USER_ATTRIBUTE14
, TAX_LINE_USER_ATTRIBUTE15
, RECOVERY_TYPE_CODE
, RECOVERY_RATE_CODE
, BILLING_TP_NAME
, BILLING_TP_NUMBER
, BILLING_TP_TAX_REG_NUM
, BILLING_TP_TAXPAYER_ID
, BILLING_TP_SITE_NAME_ALT
, BILLING_TP_NAME_ALT
, BILLING_TP_SIC_CODE
, BILLING_TP_CITY
, BILLING_TP_COUNTY
, BILLING_TP_STATE
, BILLING_TP_PROVINCE
, BILLING_TP_ADDRESS1
, BILLING_TP_ADDRESS2
, BILLING_TP_ADDRESS3
, BILLING_TP_ADDRESS_LINES_ALT
, BILLING_TP_COUNTRY
, BILLING_TP_POSTAL_CODE
, SHIPPING_TP_NUMBER
, SHIPPING_TP_TAX_REG_NUM
, SHIPPING_TP_TAXPAYER_ID
, SHIPPING_TP_NAME
, SHIPPING_TP_NAME_ALT
, SHIPPING_TP_SIC_CODE
, SHIPPING_TP_CITY
, SHIPPING_TP_COUNTY
, SHIPPING_TP_STATE
, SHIPPING_TP_PROVINCE
, SHIPPING_TP_ADDRESS1
, SHIPPING_TP_ADDRESS2
, SHIPPING_TP_ADDRESS3
, SHIPPING_TP_ADDRESS_LINES_ALT
, SHIPPING_TP_COUNTRY
, SHIPPING_TP_POSTAL_CODE
, BILLING_TP_PARTY_NUMBER
, BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUM
, BILLING_TRADING_PARTNER_ID
, BILLING_TP_SITE_ID
, BILLING_TP_ADDRESS_ID
, BILLING_TP_TAX_REPORTING_FLAG
, SHIPPING_TRADING_PARTNER_ID
, SHIPPING_TP_SITE_ID
, SHIPPING_TP_ADDRESS_ID
, BANKING_TP_NAME
, BANKING_TP_TAXPAYER_ID
, BANK_ACCOUNT_ID
, BANK_BRANCH_ID
, BILLING_TP_SITE_NAME
, BILLING_TP_SITE_TAX_REG_NUM
, SHIPPING_TP_SITE_NAME
, SHIPPING_TP_SITE_TAX_REG_NUM
, OFFICE_SITE_FLAG
, SHIP_TO_LOCATION_ID
, SHIP_FROM_LOCATION_ID
, BILL_TO_LOCATION_ID
, BILL_FROM_LOCATION_ID
, SHIP_TO_PARTY_TAX_PROF_ID
, SHIP_FROM_PARTY_TAX_PROF_ID
, BILL_TO_PARTY_TAX_PROF_ID
, BILL_FROM_PARTY_TAX_PROF_ID
, OWN_HQ_PARTY_TAX_PROF_ID
, SHIP_TO_SITE_TAX_PROF_ID
, BILL_TO_SITE_TAX_PROF_ID
, SHIP_FROM_SITE_TAX_PROF_ID
, BILL_FROM_SITE_TAX_PROF_ID
, OWN_HQ_PARTY_SITE_PROF_ID
, SHIP_TO_PARTY_ID
, SHIP_FROM_PARTY_ID
, BILL_TO_PARTY_ID
, BILL_FROM_PARTY_ID
, OWN_HQ_PARTY_ID
, SHIP_TO_PARTY_SITE_ID
, SHIP_FROM_PARTY_SITE_ID
, BILL_TO_PARTY_SITE_ID
, BILL_FROM_PARTY_SITE_ID
, REGISTRATION_STATUS_CODE
, REG_PARTY_TAX_PROF_ID
, REG_PARTY_TAX_SITE_PROF_ID
, POS_TAX_PARTY_PROF_ID
, POS_TAX_PARTY_SITE_PROF_ID
, POA_LOCATION_ID
, PLACE_OF_SUPPLY_TYPE_CODE
, DEF_PLACE_OF_SUPPLY_TYPE_CODE
, POO_LOCATION_ID
, LEGAL_ENTITY_TAX_REG_NUMBER
, HQ_ESTB_REG_NUMBER
, TAX_LINE_REGISTRATION_NUMBER
, REGISTRATION_PARTY_TYPE
, BALANCING_SEGMENT_VALUE
, BALANCING_SEGMENT_DESC
, CANCELLED_DATE
, HISTORICAL_FLAG
, CANCEL_FLAG
, SELF_ASSESSED_FLAG
, REPORTING_ONLY_FLAG
, TAX_ONLY_FLAG
, OFFSET_FLAG
, POSTED_FLAG
, MRC_TAX_LINE_FLAG
, SMALL_BUSINESS_FLAG
, RECONCILIATION_FLAG
, TAX_RECOVERABLE_FLAG
, REVERSE_FLAG
, AR_CASH_RECEIPT_REVERSE_STATUS
, AR_CASH_RECEIPT_REVERSE_DATE
, TAXABLE_ITEM_SOURCE_ID
, AMOUNT_APPLIED
, BR_REF_CUSTOMER_TRX_ID
, TAX_AMT_INCLUDED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, GDF_PARTY_SITES_BILL_ATT8
, GDF_RA_CUST_BILL_ATT10
, GDF_RA_CUST_BILL_ATT12
, GDF_RA_ADDRESSES_BILL_ATT8
, GDF_RA_ADDRESSES_BILL_ATT9
, GDF_PARTY_SITES_SHIP_ATT8
, GDF_RA_CUST_SHIP_ATT10
, GDF_RA_CUST_SHIP_ATT12
, GDF_RA_ADDRESSES_SHIP_ATT8
, GDF_RA_ADDRESSES_SHIP_ATT9
, GDF_PO_VENDOR_SITE_ATT17
, ACCTD_AMOUNT_CR
, ACCTD_AMOUNT_DR
, REC_APPLICATION_STATUS
, SUB_LEDGER_INVOICE_IDENTIFIER
, ACCOUNT_CLASS
, LATEST_REC_FLAG
, ENTITY_CODE
, POSTED_DATE
, ACTG_SOURCE_ID
, UNIT_PRICE
, GL_DATE
FROM ZX.ZX_REP_TRX_DETAIL_T#;
ZX
ZX_REP_TRX_DETAIL_T
APPS
ZX_REP_TRX_DETAIL_T
|
|
|
|