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 |