ZX_TRX_HEADERS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERNAL_ORGANIZATION_ID | NUMBER | Yes | Internal organization identifier of the transaction | ||
| INTERNAL_ORG_LOCATION_ID | NUMBER | Internal organization location identifier of the transaction | |||
| APPLICATION_ID | NUMBER | Yes | Application Identifier of the transaction | ||
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the application event class for the transaction | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Application event class of the transaction | |
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Application event type for the transaction | |
| TRX_ID | NUMBER | Yes | Primary transaction identifier | ||
| HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the user composite key to uniquely identify the transaction | ||
| HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the user composite key to uniquely identify the transaction | ||
| HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the user composite key to uniquely identify the transaction | ||
| HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the user composite key to uniquely identify the transaction | ||
| HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the user composite key to uniquely identify the transaction | ||
| HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the user composite key to uniquely identify the transaction | ||
| TRX_DATE | DATE | Yes | Transaction date | ||
| TRX_DOC_REVISION | VARCHAR2 | 150 | Revision number for the transaction. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifying column | ||
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code | ||
| CURRENCY_CONVERSION_DATE | DATE | Date of the exchange rate | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Date of the exchange rate | |||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Exchange rate type | ||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Minimum accountable unit of the transaction currency | |||
| PRECISION | NUMBER | Precision of the transaction currency | |||
| LEGAL_ENTITY_ID | NUMBER | Yes | Legal entity identifier for the transaction | ||
| ROUNDING_SHIP_TO_PARTY_ID | NUMBER | Party identifier for the ship to party of the transaction used for rounding of tax amounts | |||
| ROUNDING_SHIP_FROM_PARTY_ID | NUMBER | Party identifier for the ship from party of the transaction used for rounding of tax amounts | |||
| ROUNDING_BILL_TO_PARTY_ID | NUMBER | Party identifier for the bill to party of the transaction used for rounding of tax amounts | |||
| ROUNDING_BILL_FROM_PARTY_ID | NUMBER | Party identifier for the bill from party of the transaction used for rounding of tax amounts | |||
| RNDG_SHIP_TO_PARTY_SITE_ID | NUMBER | Party site identifier for the ship to party site of the transaction used for rounding of tax amounts | |||
| RNDG_SHIP_FROM_PARTY_SITE_ID | NUMBER | Party site identifier for the ship from party site of the transaction used for rounding of tax amounts | |||
| RNDG_BILL_TO_PARTY_SITE_ID | NUMBER | Party site identifier for the bill to party site of the transaction used for rounding of tax amounts | |||
| RNDG_BILL_FROM_PARTY_SITE_ID | NUMBER | Party site identifier for the bill from party site of the transaction used for rounding of tax amounts | |||
| ESTABLISHMENT_ID | NUMBER | Establishment identifier of the first party | |||
| RECEIVABLES_TRX_TYPE_ID | NUMBER | Transaction type identifier for Receivables transactions | |||
| RECEIVABLES_TRX_TYPE_SEQ_ID | NUMBER | Transaction type identifier for Receivables transactions | |||
| RELATED_DOC_APPLICATION_ID | NUMBER | Related document application identifier | |||
| RELATED_DOC_ENTITY_CODE | VARCHAR2 | 30 | Related document entity code | ||
| RELATED_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Related document event class code | ||
| RELATED_DOC_TRX_ID | NUMBER | Primary itransaction dentifier for the related document | |||
| REL_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the user composite key for uniquely identifying the related document | ||
| REL_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the user composite key for uniquely identifying the related document | ||
| REL_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the user composite key for uniquely identifying the related document | ||
| REL_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the user composite key for uniquely identifying the related document | ||
| REL_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the user composite key for the uniquely identifying related document | ||
| REL_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the user composite key for the uniquely identifying related document | ||
| RELATED_DOC_NUMBER | VARCHAR2 | 150 | Transaction number for related document | ||
| RELATED_DOC_DATE | DATE | Related document date | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Default taxation country code | ||
| QUOTE_FLAG | VARCHAR2 | 1 | Y or N indicates whether the tax calculation call is for estimate purpose only | ||
| CTRL_TOTAL_HDR_TX_AMT | NUMBER | Control amount at the header level for the total tax amount | |||
| TRX_NUMBER | VARCHAR2 | 150 | Transaction number, typically the number that enables a user to identify a transaction | ||
| TRX_DESCRIPTION | VARCHAR2 | 240 | Description for the transaction | ||
| TRX_COMMUNICATED_DATE | DATE | Printed or Received date of the transaction | |||
| BATCH_SOURCE_ID | NUMBER | Batch source identifier for Receivables transactions | |||
| BATCH_SOURCE_SEQ_ID | NUMBER | Batch source identifier for Receivables transactions | |||
| BATCH_SOURCE_NAME | VARCHAR2 | 150 | Batch source name for Receivables transactions | ||
| DOC_SEQ_ID | NUMBER | Identifies the document sequence | |||
| DOC_SEQ_NAME | VARCHAR2 | 150 | Name of the document sequence | ||
| DOC_SEQ_VALUE | VARCHAR2 | 240 | Value of the document sequence | ||
| TRX_DUE_DATE | DATE | Payment due date of the transaction | |||
| TRX_TYPE_DESCRIPTION | VARCHAR2 | 240 | Transaction type description for Receivables transactions | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document sub type code | ||
| SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Transaction number on the supplier tax invoice | ||
| SUPPLIER_TAX_INVOICE_DATE | DATE | Transaction date on the supplier tax invoice | |||
| SUPPLIER_EXCHANGE_RATE | NUMBER | Exchange rate on the supplier tax invoice | |||
| TAX_INVOICE_DATE | DATE | Transaction date for tax invoice generated by Receivables | |||
| TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Number for tax invoice generated by Receivables | ||
| FIRST_PTY_ORG_ID | NUMBER | Party tax profile identifier for the first party organization of the transaction | |||
| TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Tax event class code of the transaction | ||
| TAX_EVENT_TYPE_CODE | VARCHAR2 | 30 | Tax event type code of the transaction | ||
| DOC_EVENT_STATUS | VARCHAR2 | 30 | Lookup code that indicates event status of the transaction | ||
| RDNG_SHIP_TO_PTY_TX_PROF_ID | NUMBER | Party tax profile identifier for the ship to party of the transaction used for rounding of tax amounts | |||
| RDNG_SHIP_FROM_PTY_TX_PROF_ID | NUMBER | Party tax profile identifier for the ship from party of the transaction used for rounding of tax amounts | |||
| RDNG_BILL_TO_PTY_TX_PROF_ID | NUMBER | Party tax profile identifier for the bill to party of the transaction used for rounding of tax amounts | |||
| RDNG_BILL_FROM_PTY_TX_PROF_ID | NUMBER | Party tax profile identifier for the bill from party of the transaction used for rounding of tax amounts | |||
| RDNG_SHIP_TO_PTY_TX_P_ST_ID | NUMBER | Party tax profile identifier for the ship to party site of the transaction used for rounding of tax amounts | |||
| RDNG_SHIP_FROM_PTY_TX_P_ST_ID | NUMBER | Party tax profile identifier for the ship from party of the transaction used for rounding of tax amounts | |||
| RDNG_BILL_TO_PTY_TX_P_ST_ID | NUMBER | Party tax profile identifier for the bill to party site of the transaction used for rounding of tax amounts | |||
| RDNG_BILL_FROM_PTY_TX_P_ST_ID | NUMBER | Party tax profile identifier for the bill from party of the transaction used for rounding of tax amounts | |||
| VALIDATION_CHECK_FLAG | VARCHAR2 | 1 | Y or N indicates whether this transaction is valid from tax perspective if it is imported | ||
| PORT_OF_ENTRY_CODE | VARCHAR2 | 30 | Port of entry code | ||
| TAX_REPORTING_FLAG | VARCHAR2 | 1 | Tax reporting flag for lease management | ||
| SHIP_TO_CUST_ACCT_SITE_USE_ID | NUMBER | Column to record ship to customer account site use identifier for Receivables. | |||
| BILL_TO_CUST_ACCT_SITE_USE_ID | NUMBER | Column to record bill to customer account site use identifier for Receivables | |||
| PROVNL_TAX_DETERMINATION_DATE | DATE | Transaction date of the original transaction in case of lease management when a lease contract is revised | |||
| DOC_LEVEL_RECALC_FLAG | VARCHAR2 | 1 | Y or N indicates whether tax lines of all transaction lines are modified due to recalculation | ||
| TRX_BATCH_ID | NUMBER | 18 | Transaction batch identifier | ||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | 20 | Applied to document transaction number | ||
| APPLICATION_DOC_STATUS | VARCHAR2 | 30 | Transaction status as stored by the application | ||
| SHIP_THIRD_PTY_ACCT_ID | NUMBER | Column to record ship to customer account identifier for Receivables or ship from supplier identifier for Payables | |||
| BILL_THIRD_PTY_ACCT_ID | NUMBER | Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables | |||
| SHIP_THIRD_PTY_ACCT_SITE_ID | NUMBER | Column to record ship to customer account site identifier for Receivables or ship from supplier site identifier for Payables | |||
| BILL_THIRD_PTY_ACCT_SITE_ID | NUMBER | Column to record bill to customer account site identifier for Receivables or bill from supplier site identifier for Payables | |||
| ICX_SESSION_ID | NUMBER | 18 | ICX user session identifier | ||
| FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration ID for the transaction. | ||
| THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration ID for the transaction | ||
| RECEIPT_SOURCE_CODE | VARCHAR2 | 25 | Oracle internal use only. | ||
| DROPSHIP_TYPE_ID | NUMBER | 18 | Oracle internal use only. | ||
| HDR_GL_DATE | DATE | Oracle internal use only. | |||
| WITHHELD_TAX_AMT | NUMBER | Oracle internal use only. | |||
| PROCESS_TAX_DISTS_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| DEFAULT_ADDNL_ATTRIBS_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| TRX_SOURCE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_CALC_MODE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| BATCH_NAME | VARCHAR2 | 80 | To indicate name of the batch for importing external transactions. | ||
| PAYMENT_METHOD | VARCHAR2 | 30 | Oracle internal use only. | ||
| FIRST_PTY_REG_NUM | VARCHAR2 | 60 | Oracle internal use only. | ||
| THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Oracle internal use only. | ||
| ADD_TAX_TO_INV_AMT_FLAG | VARCHAR2 | 1 | Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y and N. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_TRX_HEADERS_GT_U1 | Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID |