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 |