ZX_TRANSACTION
This tables stores Transaction info
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_TRANSACTION_PK |
TRX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FIRST_PTY_ORG_ID | NUMBER | Party tax profile identifier for the first party organization of the transaction | |||
| INTERNAL_ORGANIZATION_ID | NUMBER | Yes | Internal organization 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 | 18 | Yes | Primary transaction identifier | |
| TRX_NUMBER | VARCHAR2 | 150 | Yes | Transaction number, typically the number that enables a user to identify a transaction | |
| INTERNAL_ORG_LOCATION_ID | NUMBER | Internal organization location identifier of the transaction | |||
| TAX_EVENT_TYPE_CODE | VARCHAR2 | 30 | Tax event type code of the transaction | ||
| TRX_DATE | DATE | Yes | Transaction date | ||
| DOCUMENT_EVENT_TYPE | VARCHAR2 | 30 | Document event type | ||
| LEDGER_ID | NUMBER | 18 | Ledger defining column | ||
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code | ||
| CURRENCY_CONVERSION_DATE | DATE | Date of the exchange rate | |||
| CURRENCY_CONVERSION_RATE | NUMBER | 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_PTP_ID | NUMBER | 18 | Party tax profile identifier for legal entity of the transaction | ||
| 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 | |||
| BILL_FROM_PARTY_SITE_ID | NUMBER | Bill from party site identifier | |||
| BILL_TO_PARTY_SITE_ID | NUMBER | Bill to party site identifier | |||
| SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship from party site identifier | |||
| SHIP_TO_PARTY_SITE_ID | NUMBER | Ship to party site identifier | |||
| SHIP_TO_PARTY_ID | NUMBER | Ship to party identifier | |||
| SHIP_FROM_PARTY_ID | NUMBER | Ship from party identifier | |||
| BILL_TO_PARTY_ID | NUMBER | Bill to party identifier | |||
| BILL_FROM_PARTY_ID | NUMBER | Bill from party identifier | |||
| SHIP_TO_LOCATION_ID | NUMBER | Ship to location identifier | |||
| SHIP_FROM_LOCATION_ID | NUMBER | Ship from location identifier | |||
| BILL_TO_LOCATION_ID | NUMBER | Bill to location identifier | |||
| BILL_FROM_LOCATION_ID | NUMBER | Bill from location identifier | |||
| POA_LOCATION_ID | NUMBER | Point of acceptance location identifier | |||
| POO_LOCATION_ID | NUMBER | Point of origin location identifier | |||
| PAYING_LOCATION_ID | NUMBER | Not currently used | |||
| OWN_HQ_LOCATION_ID | NUMBER | Not currently used | |||
| TRADING_HQ_LOCATION_ID | NUMBER | Not currently used | |||
| POC_LOCATION_ID | NUMBER | Not currently used | |||
| POI_LOCATION_ID | NUMBER | Not currently used | |||
| POD_LOCATION_ID | NUMBER | Not currently used | |||
| TRX_DESCRIPTION | VARCHAR2 | 240 | Transaction description | ||
| 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 | Number for tax invoice generated by Receivables | |||
| TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Transaction date for tax invoice generated by Receivables | ||
| TITLE_TRANSFER_LOCATION_ID | NUMBER | Not currently used | |||
| TAX_MANUAL_ENTRY_FLAG | VARCHAR2 | 1 | Not currently used | ||
| 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 | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Default taxation country code | ||
| QUOTE_FLAG | VARCHAR2 | 1 | Y or N indicates whether the tax claculation API should be called in quote only mode | ||
| CTRL_TOTAL_HDR_TX_AMT | NUMBER | Control amount at the header level for the total tax amount | |||
| 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 | |||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | 20 | Applied to document transaction number | ||
| 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 | |||
| VALIDATION_CHECK_FLAG | VARCHAR2 | 1 | Not currently used | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LIVE_FOR_SIMULATION_FLAG | VARCHAR2 | 1 | Live For Simulation Flag | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code of the transaction | ||
| SIMULATION_SOURCE_TRX_NUMBER | VARCHAR2 | 150 | Simulation Source Transaction Number | ||
| SIMULATION_SOURCE_TRX_ID | NUMBER | 18 | Simulation Source Transaction 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. | ||
| TRX_SOURCE | VARCHAR2 | 30 | Column to indicate the source of the transaction. | ||
| BATCH_NAME | VARCHAR2 | 80 | To identify the name of the batch containing external taxable transactions. | ||
| TRX_STATUS_FLAG | VARCHAR2 | 1 | Flag to indicate the status of external transaction batch processing. | ||
| HDR_GL_DATE | DATE | Transaction header level accounting date. | |||
| WITHHELD_TAX_AMT | NUMBER | Withheld tax amount for the transaction. | |||
| RECEIPT_SOURCE_CODE | VARCHAR2 | 25 | Source type of a shipment associated with a transaction. | ||
| DROPSHIP_TYPE_ID | NUMBER | 18 | Identifier for a drop ship transaction. | ||
| DOC_SEQ_ID | NUMBER | 18 | Identifies the document sequence for reporting purpose. | ||
| DOC_SEQ_NAME | VARCHAR2 | 150 | Name of the document sequence for reporting purpose | ||
| DOC_SEQ_VALUE | VARCHAR2 | 240 | Value of the document sequence for reporting purpose. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Enterprise Service Scheduler: indicates the request status of the interface load job that created the row. | ||
| PAYMENT_METHOD | VARCHAR2 | 30 | Name of payment method on a transaction. | ||
| FIRST_PTY_REG_NUM | VARCHAR2 | 60 | First party tax registration number of the transaction. | ||
| THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Third party tax registration number of the transaction. | ||
| BU_NAME | VARCHAR2 | 240 | Business unit associated with the transaction. | ||
| TRX_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the transaction. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Ledger name for the self-contained accounting information set for single or multiple legal or management entities. | ||
| LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Legal entity identifier that is either manually set by user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. | ||
| SHIP_TO_PTY_NUMBER | VARCHAR2 | 30 | Party number used for shipping merchandise. | ||
| SHIP_TO_PTY_NAME | VARCHAR2 | 360 | Party name used for shipping merchandise. | ||
| SHIP_FRM_PTY_NUMBER | VARCHAR2 | 30 | Party number from whom goods are shipped. | ||
| SHIP_FRM_PTY_NAME | VARCHAR2 | 360 | Party name from whom goods are shipped. | ||
| BILL_TO_PTY_NUMBER | VARCHAR2 | 30 | Party number that is responsible for receiving and paying the invoice. | ||
| BILL_TO_PTY_NAME | VARCHAR2 | 360 | Party name that is responsible for receiving and paying the invoice. | ||
| BILL_FRM_PTY_NUMBER | VARCHAR2 | 30 | Party number that is responsible for sending the invoice. | ||
| BILL_FRM_PTY_NAME | VARCHAR2 | 360 | Party name that is responsible for sending the invoice. | ||
| SHIP_TO_LOCATION_NAME | VARCHAR2 | 240 | Location for the place where goods are received from a vendor. | ||
| SHIP_FRM_PTY_SITE_CODE | VARCHAR2 | 240 | Code for the party site from where goods are shipped. | ||
| BILL_TO_LOCATION_NAME | VARCHAR2 | 240 | Location for the customer that is responsible for receiving and paying the invoice. | ||
| BILL_FRM_PTY_SITE_CODE | VARCHAR2 | 240 | Code for the party site that is responsible for sending the invoice. | ||
| RECV_TRX_TYPE_CODE | VARCHAR2 | 30 | Receivable transaction type associated with the taxable transaction. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_TRANSACTION | zx_party_tax_profile | FIRST_PTY_ORG_ID |
| zx_transaction_lines | zx_transaction | TRX_ID |
| zx_sim_trx_dists | zx_transaction | TRX_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_TRANSACTION_N1 | Non Unique | Default | APPLICATION_ID |
| ZX_TRANSACTION_N2 | Non Unique | Default | BATCH_NAME, TRX_NUMBER |
| ZX_TRANSACTION_U1 | Unique | Default | TRX_ID |