[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_REP_EXTRACT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.ZX_REP_EXTRACT_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | |||
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LEDGER_ID | NUMBER | (15) | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | ||
| DETAIL_TAX_LINE_ID | NUMBER | (15) | Yes | |
| EXTRACT_SOURCE_LEDGER | VARCHAR2 | (30) | ||
| EXTRACT_REPORT_LINE_NUMBER | NUMBER | |||
| REP_ENTITY_ID | NUMBER | (15) | ||
| LEGAL_ENTITY_TAX_REG_NUMBER | NUMBER | |||
| ORG_INFORMATION2 | VARCHAR2 | (150) | ||
| REP_CONTEXT_LVL_CODE | VARCHAR2 | (30) | ||
| REP_CONTEXT_LVL_MNG | VARCHAR2 | (80) | ||
| TAXPAYER_ID | VARCHAR2 | (30) | ||
| REP_CONTEXT_ENTITY_NAME | VARCHAR2 | (240) | ||
| REP_CONTEXT_ENTITY_LOCATION_ID | NUMBER | (15) | ||
| REP_CONTEXT_ENTITY_CITY | VARCHAR2 | (120) | ||
| REP_CONTEXT_ENTITY_COUNTY | VARCHAR2 | (120) | ||
| REP_CONTEXT_ENTITY_STATE | VARCHAR2 | (120) | ||
| REP_CONTEXT_ENTITY_PROVINCE | VARCHAR2 | (120) | ||
| REP_CONTEXT_ENTITY_ADDRESS1 | VARCHAR2 | (240) | ||
| REP_CONTEXT_ENTITY_ADDRESS2 | VARCHAR2 | (240) | ||
| REP_CONTEXT_ENTITY_ADDRESS3 | VARCHAR2 | (240) | ||
| REP_CONTEXT_ENTITY_COUNTRY | VARCHAR2 | (60) | ||
| REP_CONTEXT_ENTITY_POSTAL_CODE | VARCHAR2 | (30) | ||
| REP_CONTEXT_ENTITY_TEL_NUMBER | VARCHAR2 | (60) | ||
| LEDGER_NAME | VARCHAR2 | (30) | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (30) | ||
| TRX_ID | NUMBER | |||
| TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_DESCRIPTION | VARCHAR2 | (240) | ||
| DOC_SEQ_ID | NUMBER | |||
| DOC_SEQ_NAME | VARCHAR2 | (150) | ||
| DOC_SEQ_VALUE | VARCHAR2 | (240) | ||
| TRX_DATE | DATE | |||
| TRX_LINE_CLASS | VARCHAR2 | (30) | ||
| TRX_CLASS_MNG | VARCHAR2 | (80) | ||
| TRX_TYPE_ID | NUMBER | (15) | ||
| TRX_TYPE_MNG | VARCHAR2 | (80) | ||
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | ||
| APPLIED_FROM_TRX_ID | NUMBER | |||
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| TRX_APPLIED_FROM_CLASS_MNG | VARCHAR2 | (80) | ||
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_TRX_ID | NUMBER | |||
| ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| ADJUSTED_DOC_NUMBER | VARCHAR2 | (150) | ||
| ADJUSTED_DOC_DATE | DATE | |||
| TRX_APPLIED_TO_CLASS_MNG | VARCHAR2 | (80) | ||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | (150) | ||
| TRX_TYPE_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_DUE_DATE | DATE | |||
| TRX_SHIPPING_DATE | DATE | |||
| TRX_COMMUNICATED_DATE | DATE | |||
| TRX_CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| RECONCILIATION_FLAG | VARCHAR2 | (1) | ||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | ||
| TRX_CONTROL_ACCOUNT_FLEXFIELD | VARCHAR2 | (2000) | ||
| BILLING_TRADING_PARTNER_ID | NUMBER | (15) | ||
| BILLING_TP_SITE_ID | NUMBER | (15) | ||
| BILLING_TP_NUMBER | VARCHAR2 | (240) | ||
| BILLING_TP_TAX_REG_NUM | VARCHAR2 | (50) | ||
| BILLING_TP_TAXPAYER_ID | VARCHAR2 | (50) | ||
| BILLING_TP_SITE_NAME | VARCHAR2 | (40) | ||
| BILLING_TP_SITE_NAME_ALT | VARCHAR2 | (320) | ||
| BILLING_TP_SITE_TAX_REG_NUM | VARCHAR2 | (50) | ||
| BILLING_TP_TAX_REPORTING_FLAG | VARCHAR2 | (1) | ||
| BILLING_TP_NAME | VARCHAR2 | (360) | ||
| BILLING_TP_NAME_ALT | VARCHAR2 | (320) | ||
| BILLING_TP_SIC_CODE | VARCHAR2 | (30) | ||
| BILLING_TP_ADDRESS_ID | NUMBER | (15) | ||
| 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_TRADING_PARTNER_ID | NUMBER | (15) | ||
| SHIPPING_TP_SITE_ID | NUMBER | (15) | ||
| SHIPPING_TP_NUMBER | VARCHAR2 | (60) | ||
| SHIPPING_TP_TAX_REG_NUM | VARCHAR2 | (50) | ||
| SHIPPING_TP_TAXPAYER_ID | VARCHAR2 | (50) | ||
| SHIPPING_TP_SITE_NAME | VARCHAR2 | (40) | ||
| SHIPPING_TP_SITE_TAX_REG_NUM | VARCHAR2 | (50) | ||
| SHIPPING_TP_NAME | VARCHAR2 | (360) | ||
| SHIPPING_TP_NAME_ALT | VARCHAR2 | (320) | ||
| SHIPPING_TP_SIC_CODE | VARCHAR2 | (30) | ||
| SHIPPING_TP_ADDRESS_ID | NUMBER | (15) | ||
| 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) | ||
| BANKING_TP_NAME | VARCHAR2 | (360) | ||
| BANKING_TP_TAXPAYER_ID | VARCHAR2 | (50) | ||
| TRX_BATCH_SOURCE_NAME | VARCHAR2 | (150) | ||
| TRX_SIC_CODE | VARCHAR2 | (150) | ||
| FOB_POINT | VARCHAR2 | (30) | ||
| TRX_WAYBILL_NUMBER | VARCHAR2 | (50) | ||
| POSTED_FLAG | VARCHAR2 | (1) | ||
| TAX_RATE_ID | NUMBER | (15) | ||
| TAX_RATE_CODE | VARCHAR2 | (50) | ||
| TAX_RATE | NUMBER | |||
| TAX | VARCHAR2 | (30) | ||
| TAX_STATUS_CODE | VARCHAR2 | (30) | ||
| TAX_REGIME_CODE | VARCHAR2 | (30) | ||
| TAX_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_RATE_CODE_VAT_TRX_TYPE_MNG | VARCHAR2 | (240) | ||
| TAX_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | ||
| TAX_RATE_REGISTER_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_RATE_CODE_REG_TYPE_MEANING | VARCHAR2 | (80) | ||
| TAX_TYPE_CODE | VARCHAR2 | (30) | ||
| TAX_TYPE_MNG | VARCHAR2 | (80) | ||
| TAX_RATE_CODE_NAME | VARCHAR2 | (240) | ||
| TAX_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | ||
| TAX_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
| TAX_RECOVERY_RATE | 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 | |||
| TAX_EXEMPTION_ID | NUMBER | (15) | ||
| TAX_EXCEPTION_ID | NUMBER | (15) | ||
| EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | (80) | ||
| EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| TAX_EXEMPT_REASON_MNG | VARCHAR2 | (80) | ||
| TAX_EXCEPTION_REASON_CODE | VARCHAR2 | (30) | ||
| TAX_EXCEPTION_REASON_MNG | VARCHAR2 | (80) | ||
| 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) | ||
| GL_DATE | DATE | |||
| TAX_AMT | NUMBER | |||
| TAX_AMT_FUNCL_CURR | NUMBER | |||
| TAX_LINE_NUMBER | NUMBER | |||
| TAXABLE_AMT | NUMBER | |||
| TAXABLE_AMT_FUNCL_CURR | NUMBER | |||
| TOTAL_ENTERED_AMOUNT | NUMBER | |||
| TOTAL_ACCOUNTED_AMOUNT | NUMBER | |||
| TAXABLE_DISC_AMT | NUMBER | |||
| TAXABLE_DISC_AMT_FUNCL_CURR | NUMBER | |||
| TAX_DISC_AMT | NUMBER | |||
| TAX_DISC_AMT_FUNCL_CURR | NUMBER | |||
| TRX_LINE_NUMBER | NUMBER | |||
| TAXABLE_LINE_SOURCE_TABLE | VARCHAR2 | (30) | ||
| TRX_LINE_DESCRIPTION | VARCHAR2 | (240) | ||
| PRODUCT_ID | NUMBER | |||
| TAXABLE_LINE_ITEM_FLEXFIELD | VARCHAR2 | (2000) | ||
| PRODUCT_DESCRIPTION | VARCHAR2 | (240) | ||
| TRX_LINE_QUANTITY | NUMBER | |||
| UOM_CODE | VARCHAR2 | (30) | ||
| TRX_QUANTITY_UOM_MNG | VARCHAR2 | (80) | ||
| TRX_LINE_TYPE | VARCHAR2 | (30) | ||
| ACTG_EVENT_ID | NUMBER | (15) | ||
| ACTG_EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
| ACTG_EVENT_TYPE_MNG | VARCHAR2 | (240) | ||
| ACTG_EVENT_NUMBER | NUMBER | |||
| ACTG_EVENT_STATUS_FLAG | VARCHAR2 | (1) | ||
| ACTG_EVENT_STATUS_MNG | VARCHAR2 | (240) | ||
| ACTG_SOURCE_TABLE | VARCHAR2 | (30) | ||
| ACTG_SOURCE_ID | NUMBER | (15) | ||
| ACTG_HEADER_ID | NUMBER | (15) | ||
| ACTG_CATEGORY_CODE | VARCHAR2 | (30) | ||
| ACTG_CATEGORY_MNG | VARCHAR2 | (240) | ||
| PERIOD_NAME | VARCHAR2 | (30) | ||
| GL_TRANSFER_FLAG | VARCHAR2 | (1) | ||
| GL_TRANSFER_RUN_ID | NUMBER | (15) | ||
| ACTG_HEADER_DESCRIPTION | VARCHAR2 | (1996) | ||
| ACTG_LINE_NUM | NUMBER | (15) | ||
| ACTG_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
| ACTG_LINE_TYPE_MNG | VARCHAR2 | (240) | ||
| ACTG_LINE_CCID | NUMBER | (15) | ||
| ACCOUNT_FLEXFIELD | VARCHAR2 | (2000) | ||
| ACCOUNT_DESCRIPTION | VARCHAR2 | (1996) | ||
| ACTG_LINE_DESCRIPTION | VARCHAR2 | (1996) | ||
| ACTG_STAT_AMT | NUMBER | |||
| ACTG_ERROR_CODE | VARCHAR2 | (30) | ||
| GL_TRANSFER_CODE | VARCHAR2 | (30) | ||
| ACTG_DOC_SEQUENCE_ID | NUMBER | (15) | ||
| ACTG_DOC_SEQUENCE_NAME | VARCHAR2 | (150) | ||
| ACTG_DOC_SEQUENCE_VALUE | VARCHAR2 | (240) | ||
| ACTG_PARTY_ID | NUMBER | (15) | ||
| ACTG_PARTY_SITE_ID | NUMBER | (15) | ||
| TRX_ARAP_BALANCING_SEGMENT | VARCHAR2 | (240) | ||
| TRX_ARAP_NATURAL_ACCOUNT | VARCHAR2 | (240) | ||
| TRX_TAXABLE_BALANCING_SEGMENT | VARCHAR2 | (240) | ||
| TRX_TAXABLE_NATURAL_ACCOUNT | VARCHAR2 | (240) | ||
| TRX_TAX_BALANCING_SEGMENT | VARCHAR2 | (240) | ||
| TRX_TAX_NATURAL_ACCOUNT | VARCHAR2 | (240) | ||
| TRX_TAXABLE_ACCOUNT | VARCHAR2 | (240) | ||
| TRX_TAXABLE_ACCOUNT_DESC | VARCHAR2 | (1996) | ||
| TRX_TAXABLE_BALSEG_DESC | VARCHAR2 | (240) | ||
| TRX_TAXABLE_NATACCT_SEG_DESC | VARCHAR2 | (240) | ||
| NUMERIC1 | NUMBER | |||
| NUMERIC2 | NUMBER | |||
| NUMERIC3 | NUMBER | |||
| NUMERIC4 | NUMBER | |||
| NUMERIC5 | NUMBER | |||
| NUMERIC6 | NUMBER | |||
| NUMERIC7 | NUMBER | |||
| NUMERIC8 | NUMBER | |||
| NUMERIC9 | NUMBER | |||
| NUMERIC10 | NUMBER | |||
| NUMERIC11 | NUMBER | |||
| NUMERIC12 | NUMBER | |||
| NUMERIC13 | NUMBER | |||
| NUMERIC14 | NUMBER | |||
| NUMERIC15 | NUMBER | |||
| NUMERIC16 | NUMBER | |||
| 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) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| BUSINESS_LOC_ADDRESS | VARCHAR2 | (754) | ||
| DOCUMENT_SUB_TYPE_MNG | VARCHAR2 | (80) | ||
| TAX_STATUS_MNG | VARCHAR2 | (80) | ||
| TRX_BUSINESS_CATEGORY_MNG | VARCHAR2 | (80) | ||
| GDF_AP_INVOICES_ATT2 | VARCHAR2 | (150) | ||
| GDF_AP_INVOICES_ATT3 | VARCHAR2 | (150) | ||
| GDF_AP_INVOICES_ATT4 | VARCHAR2 | (150) | ||
| GDF_AP_INVOICES_ATT11 | VARCHAR2 | (150) | ||
| GDF_AP_INVOICES_ATT12 | VARCHAR2 | (150) | ||
| GDF_AP_INVOICES_ATT13 | VARCHAR2 | (150) | ||
| GDF_AP_INVOICE_DIST_ATT1 | VARCHAR2 | (150) | ||
| GDF_PO_VENDOR_SITES_ATT17 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_BILL_ATT10 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_BILL_ATT12 | VARCHAR2 | (150) | ||
| GDF_PARTY_SITES_BILL_ATT8 | VARCHAR2 | (150) | ||
| GDF_PARTY_SITES_BILL_ATT9 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT3 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT4 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT5 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT6 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT7 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT8 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT9 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_ATT19 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_LINES_ATT1 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_LINES_ATT2 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_TYPES_ATT5 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_TYPES_ATT6 | VARCHAR2 | (150) | ||
| GDF_RA_CUST_TRX_TYPES_ATT7 | VARCHAR2 | (150) | ||
| GDF_RA_BATCH_SOURCES_ATT1 | VARCHAR2 | (150) | ||
| GDF_RA_BATCH_SOURCES_ATT2 | VARCHAR2 | (150) | ||
| GDF_RA_BATCH_SOURCES_ATT3 | VARCHAR2 | (150) | ||
| GDF_RA_BATCH_SOURCES_ATT4 | VARCHAR2 | (150) | ||
| GDF_RA_BATCH_SOURCES_ATT7 | VARCHAR2 | (150) | ||
| GDF_RA_ADDRESSES_BILL_ATT9 | VARCHAR2 | (150) | ||
| GDF_RA_ADDRESSES_SHIP_ATT9 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LEDGER_ID
, CHART_OF_ACCOUNTS_ID
, DETAIL_TAX_LINE_ID
, EXTRACT_SOURCE_LEDGER
, EXTRACT_REPORT_LINE_NUMBER
, REP_ENTITY_ID
, LEGAL_ENTITY_TAX_REG_NUMBER
, ORG_INFORMATION2
, REP_CONTEXT_LVL_CODE
, REP_CONTEXT_LVL_MNG
, TAXPAYER_ID
, REP_CONTEXT_ENTITY_NAME
, REP_CONTEXT_ENTITY_LOCATION_ID
, REP_CONTEXT_ENTITY_CITY
, REP_CONTEXT_ENTITY_COUNTY
, REP_CONTEXT_ENTITY_STATE
, REP_CONTEXT_ENTITY_PROVINCE
, REP_CONTEXT_ENTITY_ADDRESS1
, REP_CONTEXT_ENTITY_ADDRESS2
, REP_CONTEXT_ENTITY_ADDRESS3
, REP_CONTEXT_ENTITY_COUNTRY
, REP_CONTEXT_ENTITY_POSTAL_CODE
, REP_CONTEXT_ENTITY_TEL_NUMBER
, LEDGER_NAME
, FUNCTIONAL_CURRENCY_CODE
, TRX_ID
, TRX_NUMBER
, TRX_DESCRIPTION
, DOC_SEQ_ID
, DOC_SEQ_NAME
, DOC_SEQ_VALUE
, TRX_DATE
, TRX_LINE_CLASS
, TRX_CLASS_MNG
, TRX_TYPE_ID
, TRX_TYPE_MNG
, APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_TRX_ID
, APPLIED_FROM_EVENT_CLASS_CODE
, TRX_APPLIED_FROM_CLASS_MNG
, APPLIED_FROM_TRX_NUMBER
, ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_TRX_ID
, ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE
, TRX_APPLIED_TO_CLASS_MNG
, APPLIED_TO_TRX_NUMBER
, TRX_TYPE_DESCRIPTION
, TRX_DUE_DATE
, TRX_SHIPPING_DATE
, TRX_COMMUNICATED_DATE
, TRX_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, RECONCILIATION_FLAG
, BALANCING_SEGMENT_VALUE
, TRX_CONTROL_ACCOUNT_FLEXFIELD
, BILLING_TRADING_PARTNER_ID
, BILLING_TP_SITE_ID
, BILLING_TP_NUMBER
, BILLING_TP_TAX_REG_NUM
, BILLING_TP_TAXPAYER_ID
, BILLING_TP_SITE_NAME
, BILLING_TP_SITE_NAME_ALT
, BILLING_TP_SITE_TAX_REG_NUM
, BILLING_TP_TAX_REPORTING_FLAG
, BILLING_TP_NAME
, BILLING_TP_NAME_ALT
, BILLING_TP_SIC_CODE
, BILLING_TP_ADDRESS_ID
, 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_TRADING_PARTNER_ID
, SHIPPING_TP_SITE_ID
, SHIPPING_TP_NUMBER
, SHIPPING_TP_TAX_REG_NUM
, SHIPPING_TP_TAXPAYER_ID
, SHIPPING_TP_SITE_NAME
, SHIPPING_TP_SITE_TAX_REG_NUM
, SHIPPING_TP_NAME
, SHIPPING_TP_NAME_ALT
, SHIPPING_TP_SIC_CODE
, SHIPPING_TP_ADDRESS_ID
, 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
, BANKING_TP_NAME
, BANKING_TP_TAXPAYER_ID
, TRX_BATCH_SOURCE_NAME
, TRX_SIC_CODE
, FOB_POINT
, TRX_WAYBILL_NUMBER
, POSTED_FLAG
, TAX_RATE_ID
, TAX_RATE_CODE
, TAX_RATE
, TAX
, TAX_STATUS_CODE
, TAX_REGIME_CODE
, TAX_RATE_VAT_TRX_TYPE_CODE
, TAX_RATE_CODE_VAT_TRX_TYPE_MNG
, TAX_RATE_VAT_TRX_TYPE_DESC
, TAX_RATE_REGISTER_TYPE_CODE
, TAX_RATE_CODE_REG_TYPE_MEANING
, TAX_TYPE_CODE
, TAX_TYPE_MNG
, TAX_RATE_CODE_NAME
, TAX_RATE_CODE_DESCRIPTION
, TAX_RECOVERABLE_FLAG
, TAX_RECOVERY_RATE
, 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
, TAX_EXEMPTION_ID
, TAX_EXCEPTION_ID
, EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON_MNG
, TAX_EXCEPTION_REASON_CODE
, TAX_EXCEPTION_REASON_MNG
, 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
, GL_DATE
, TAX_AMT
, TAX_AMT_FUNCL_CURR
, TAX_LINE_NUMBER
, TAXABLE_AMT
, TAXABLE_AMT_FUNCL_CURR
, TOTAL_ENTERED_AMOUNT
, TOTAL_ACCOUNTED_AMOUNT
, TAXABLE_DISC_AMT
, TAXABLE_DISC_AMT_FUNCL_CURR
, TAX_DISC_AMT
, TAX_DISC_AMT_FUNCL_CURR
, TRX_LINE_NUMBER
, TAXABLE_LINE_SOURCE_TABLE
, TRX_LINE_DESCRIPTION
, PRODUCT_ID
, TAXABLE_LINE_ITEM_FLEXFIELD
, PRODUCT_DESCRIPTION
, TRX_LINE_QUANTITY
, UOM_CODE
, TRX_QUANTITY_UOM_MNG
, TRX_LINE_TYPE
, ACTG_EVENT_ID
, ACTG_EVENT_TYPE_CODE
, ACTG_EVENT_TYPE_MNG
, ACTG_EVENT_NUMBER
, ACTG_EVENT_STATUS_FLAG
, ACTG_EVENT_STATUS_MNG
, ACTG_SOURCE_TABLE
, ACTG_SOURCE_ID
, ACTG_HEADER_ID
, ACTG_CATEGORY_CODE
, ACTG_CATEGORY_MNG
, PERIOD_NAME
, GL_TRANSFER_FLAG
, GL_TRANSFER_RUN_ID
, ACTG_HEADER_DESCRIPTION
, ACTG_LINE_NUM
, ACTG_LINE_TYPE_CODE
, ACTG_LINE_TYPE_MNG
, ACTG_LINE_CCID
, ACCOUNT_FLEXFIELD
, ACCOUNT_DESCRIPTION
, ACTG_LINE_DESCRIPTION
, ACTG_STAT_AMT
, ACTG_ERROR_CODE
, GL_TRANSFER_CODE
, ACTG_DOC_SEQUENCE_ID
, ACTG_DOC_SEQUENCE_NAME
, ACTG_DOC_SEQUENCE_VALUE
, ACTG_PARTY_ID
, ACTG_PARTY_SITE_ID
, TRX_ARAP_BALANCING_SEGMENT
, TRX_ARAP_NATURAL_ACCOUNT
, TRX_TAXABLE_BALANCING_SEGMENT
, TRX_TAXABLE_NATURAL_ACCOUNT
, TRX_TAX_BALANCING_SEGMENT
, TRX_TAX_NATURAL_ACCOUNT
, TRX_TAXABLE_ACCOUNT
, TRX_TAXABLE_ACCOUNT_DESC
, TRX_TAXABLE_BALSEG_DESC
, TRX_TAXABLE_NATACCT_SEG_DESC
, NUMERIC1
, NUMERIC2
, NUMERIC3
, NUMERIC4
, NUMERIC5
, NUMERIC6
, NUMERIC7
, NUMERIC8
, NUMERIC9
, NUMERIC10
, NUMERIC11
, NUMERIC12
, NUMERIC13
, NUMERIC14
, NUMERIC15
, NUMERIC16
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, BUSINESS_LOC_ADDRESS
, DOCUMENT_SUB_TYPE_MNG
, TAX_STATUS_MNG
, TRX_BUSINESS_CATEGORY_MNG
, GDF_AP_INVOICES_ATT2
, GDF_AP_INVOICES_ATT3
, GDF_AP_INVOICES_ATT4
, GDF_AP_INVOICES_ATT11
, GDF_AP_INVOICES_ATT12
, GDF_AP_INVOICES_ATT13
, GDF_AP_INVOICE_DIST_ATT1
, GDF_PO_VENDOR_SITES_ATT17
, GDF_RA_CUST_BILL_ATT10
, GDF_RA_CUST_BILL_ATT12
, GDF_PARTY_SITES_BILL_ATT8
, GDF_PARTY_SITES_BILL_ATT9
, GDF_RA_CUST_TRX_ATT3
, GDF_RA_CUST_TRX_ATT4
, GDF_RA_CUST_TRX_ATT5
, GDF_RA_CUST_TRX_ATT6
, GDF_RA_CUST_TRX_ATT7
, GDF_RA_CUST_TRX_ATT8
, GDF_RA_CUST_TRX_ATT9
, GDF_RA_CUST_TRX_ATT19
, GDF_RA_CUST_TRX_LINES_ATT1
, GDF_RA_CUST_TRX_LINES_ATT2
, GDF_RA_CUST_TRX_TYPES_ATT5
, GDF_RA_CUST_TRX_TYPES_ATT6
, GDF_RA_CUST_TRX_TYPES_ATT7
, GDF_RA_BATCH_SOURCES_ATT1
, GDF_RA_BATCH_SOURCES_ATT2
, GDF_RA_BATCH_SOURCES_ATT3
, GDF_RA_BATCH_SOURCES_ATT4
, GDF_RA_BATCH_SOURCES_ATT7
, GDF_RA_ADDRESSES_BILL_ATT9
, GDF_RA_ADDRESSES_SHIP_ATT9
FROM APPS.ZX_REP_EXTRACT_V;
APPS
ZX_REP_ACTG_EXT_T
ZX_REP_CONTEXT_T
ZX_REP_TRX_DETAIL_T
ZX_REP_TRX_JX_EXT_T
APPS.ZX_REP_EXTRACT_V is not referenced by any database object
|
|
|
|