ZX_TRANSACTION_LINES
This table stores Transaction Lines info
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
ZX_TRANSACTION_LINES_PK |
TRX_LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | Application Identifier of the transaction | Active | ||
ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the application event class for the transaction | Active | |
EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Application event class of the transaction | Active | |
TRX_LINE_ID | NUMBER | 18 | Yes | Transaction line identifier | Active | |
TRX_LINE_NUMBER | NUMBER | Yes | Transaction line number | Active | ||
TRX_ID | NUMBER | 18 | Yes | Primary transaction identifier | Active | |
TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | |
TRX_LINE_TYPE | VARCHAR2 | 30 | Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC. | Active | ||
TRX_LINE_DATE | DATE | Transaction line date | Active | |||
TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code of the transaction line | Active | ||
LINE_INTENDED_USE | VARCHAR2 | 240 | Intended use code of the transaction line. This identifies the purpose for which the product is used. | Active | ||
USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification code of the transaction line | Active | ||
LINE_AMT_INCLUDES_TAX_FLAG | VARCHAR2 | 1 | Yes | Lookup code to indicate whether any tax is included in the transaction line amount and unit price. Possible values are A, N, S and I. | Active | |
LINE_AMT | NUMBER | Transaction line amount | Active | |||
TRX_LINE_QUANTITY | NUMBER | Transaction line quantity | Active | |||
UNIT_PRICE | NUMBER | Unit Price of the transaction line item or product | Active | |||
PRODUCT_ID | NUMBER | Column to store internal identifier of the inventory item or memo line used on this transaction line. | Active | |||
PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Product fiscal classification code of the inventory item | Active | ||
PRODUCT_ORG_ID | NUMBER | Identifier of the organization for the inventory item | Active | |||
UOM_CODE | VARCHAR2 | 30 | Unit of measure code for the inventory item | Active | ||
PRODUCT_TYPE | VARCHAR2 | 240 | Product type code of the inventory item. Possible values are GOODS and SERVICES. | Active | ||
PRODUCT_CODE | VARCHAR2 | 300 | Inventory item code | Active | ||
PRODUCT_CATEGORY | VARCHAR2 | 240 | Product category code of the transaction line | Active | ||
MERCHANT_PARTY_ID | NUMBER | Merchant party identifier recorded for the Payables expense report | Active | |||
ACCOUNT_CCID | NUMBER | Account identifier | Active | |||
ACCOUNT_STRING | VARCHAR2 | 2000 | Column to store concatanated account string value | Active | ||
REF_DOC_LINE_ID | NUMBER | Transaction line identifier for the reference document | Active | |||
REF_DOC_LINE_QUANTITY | NUMBER | Reference document line quantity | Active | |||
REF_DOC_APPLICATION_ID | NUMBER | Reference document application identifier | Active | |||
REF_DOC_ENTITY_CODE | VARCHAR2 | 30 | Reference document entity code | Active | ||
REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Reference document event class code | Active | ||
REF_DOC_TRX_ID | NUMBER | Reference document transaction identifier | Active | |||
APPLIED_FROM_LINE_ID | NUMBER | Transaction line identifier for the applied from document | Active | |||
APPLIED_FROM_APPLICATION_ID | NUMBER | Applied from document application identifier | Active | |||
APPLIED_FROM_ENTITY_CODE | VARCHAR2 | 30 | Applied from document entity code | Active | ||
APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | 30 | Applied from document event class code | Active | ||
APPLIED_FROM_TRX_ID | NUMBER | Applied from document transaction identifier | Active | |||
ADJUSTED_DOC_LINE_ID | NUMBER | Transaction line identifier for the adjusted document | Active | |||
ADJUSTED_DOC_DATE | DATE | Adjusted document date | Active | |||
ADJUSTED_DOC_APPLICATION_ID | NUMBER | Adjusted document application identifier | Active | |||
ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | 30 | Adjusted document entity code | Active | ||
ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Adjusted document event class code | Active | ||
ADJUSTED_DOC_TRX_ID | NUMBER | Adjusted document transaction identifier | Active | |||
TRX_LINE_DESCRIPTION | VARCHAR2 | 240 | Description for the transaction line | Active | ||
PRODUCT_DESCRIPTION | VARCHAR2 | 240 | Description of the inventory item or memo line used on the transaction line | Active | ||
TRX_LINE_GL_DATE | DATE | Accounting date for the transaction line | Active | |||
LINE_LEVEL_ACTION | VARCHAR2 | 30 | Yes | Column to store action at the transaction line level | Active | |
HISTORICAL_FLAG | VARCHAR2 | 1 | Y or N represents whether the document or invoice has been upgraded from a prior release or whether it has been newly created. | Active | ||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill from party site identifier | Active | |||
BILL_TO_PARTY_SITE_ID | NUMBER | Bill to party site identifier | Active | |||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship from party site identifier | Active | |||
SHIP_TO_PARTY_SITE_ID | NUMBER | Ship to party site identifier | Active | |||
SHIP_TO_PARTY_ID | NUMBER | Ship to party identifier | Active | |||
SHIP_FROM_PARTY_ID | NUMBER | Ship from party identifier | Active | |||
BILL_TO_PARTY_ID | NUMBER | Bill to party identifier | Active | |||
BILL_FROM_PARTY_ID | NUMBER | Bill from party identifier | Active | |||
SHIP_TO_LOCATION_ID | NUMBER | Ship to location identifier | Active | |||
SHIP_FROM_LOCATION_ID | NUMBER | Ship from location identifier | Active | |||
BILL_TO_LOCATION_ID | NUMBER | Bill to location identifier | Active | |||
BILL_FROM_LOCATION_ID | NUMBER | Bill from location identifier | Active | |||
POA_LOCATION_ID | NUMBER | Point of acceptance location identifier | Active | |||
POO_LOCATION_ID | NUMBER | Point of origin location identifier | Active | |||
PAYING_LOCATION_ID | NUMBER | Not currently used | Active | |||
OWN_HQ_LOCATION_ID | NUMBER | Not currently used | Active | |||
TRADING_HQ_LOCATION_ID | NUMBER | Not currently used | Active | |||
POC_LOCATION_ID | NUMBER | Not currently used | Active | |||
POI_LOCATION_ID | NUMBER | Not currently used | Active | |||
POD_LOCATION_ID | NUMBER | Not currently used | Active | |||
TAX_REGIME_ID | NUMBER | 18 | Tax regime identifier | Active | ||
TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code | Active | ||
TAX_ID | NUMBER | 18 | Tax identifier | Active | ||
TAX | VARCHAR2 | 30 | Tax | Active | ||
TAX_STATUS_ID | NUMBER | 18 | Tax status identifier | Active | ||
TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code | Active | ||
TAX_RATE_ID | NUMBER | 18 | Tax rate identifier | Active | ||
TAX_RATE_CODE | VARCHAR2 | 50 | Tax rate code | Active | ||
TAX_RATE | NUMBER | Tax rate | Active | |||
TAX_LINE_AMT | NUMBER | Tax line amount | Active | |||
LINE_CLASS | VARCHAR2 | 30 | Column to store event class for the transaction line | Active | ||
TRX_SHIPPING_DATE | DATE | Shipping date of the transaction at header or line level | Active | |||
TRX_RECEIPT_DATE | DATE | Receipt date of the transaction at header or line level | Active | |||
EXEMPT_CERTIFICATE_NUMBER | VARCHAR2 | 80 | Tax exemption certificate number | Active | ||
EXEMPT_REASON | VARCHAR2 | 240 | Tax exemption reason | Active | ||
CASH_DISCOUNT | NUMBER | Cash discount amount | Active | |||
VOLUME_DISCOUNT | NUMBER | Volume discount quantity | Active | |||
TRADING_DISCOUNT | NUMBER | Trading discount amount | Active | |||
TRANSFER_CHARGE | NUMBER | Transfer charge | Active | |||
TRANSPORTATION_CHARGE | NUMBER | Transportation charge | Active | |||
INSURANCE_CHARGE | NUMBER | Insurance charge | Active | |||
OTHER_CHARGE | NUMBER | Other charge | Active | |||
POA_PARTY_ID | NUMBER | Point of acceptance party identifier | Active | |||
POO_PARTY_ID | NUMBER | Point of origin party identifier | Active | |||
POA_PARTY_SITE_ID | NUMBER | Point of acceptance party site identifier | Active | |||
POO_PARTY_SITE_ID | NUMBER | Point of origin party site identifier | Active | |||
MERCHANT_PARTY_COUNTRY | VARCHAR2 | 150 | Merchant party country code | Active | ||
APPLIED_TO_APPLICATION_ID | NUMBER | Applied to document application identifier | Active | |||
APPLIED_TO_ENTITY_CODE | VARCHAR2 | 30 | Applied to document entity code | Active | ||
APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | 30 | Applied to document event class code | Active | ||
APPLIED_TO_TRX_ID | NUMBER | Applied to document transaction identifier | Active | |||
APPLIED_TO_TRX_LINE_ID | NUMBER | Transaction line identifier for the applied to document | Active | |||
CTRL_HDR_TX_APPL_FLAG | VARCHAR2 | 1 | Y or N indicates whether the control amount for the total tax amount is available at the header level | Active | ||
CTRL_TOTAL_LINE_TX_AMT | NUMBER | Control amount for the total tax amount at the line level | Active | |||
INPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Tax classifiation code for Procure To Pay products | Active | ||
OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Tax classifiation code for Order To Cash products | Active | ||
REF_DOC_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | ||
APPLIED_TO_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the applied to document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | ||
APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the applied from document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | ||
ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the adjusted document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | ||
EXEMPTION_CONTROL_FLAG | VARCHAR2 | 1 | Lookup code to control the application of exemptions to the transaction line during tax lines calculation. Possible values are R, S and E. | Active | ||
EXEMPT_REASON_CODE | VARCHAR2 | 30 | Exemption reason code | Active | ||
RECEIVABLES_TRX_TYPE_ID | NUMBER | Transaction type identifier for Receivables transactions | Active | |||
RECEIVABLES_TRX_TYPE_SEQ_ID | NUMBER | Transaction type identifier for Receivables transactions | Active | |||
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. | Active | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
ASSESSABLE_VALUE | NUMBER | Assessable Value | Active | |||
PROD_FC_CATEG_ID | NUMBER | Product fiscal category unique identifier | ||||
INTENDED_USE_CLASSIF_ID | NUMBER | Default intended use code for transactions for a specified country. | ||||
SOURCE_APPLICATION_ID | NUMBER | 18 | Source document application identifier. | |||
SOURCE_TRX_ID | NUMBER | 18 | Source document transaction identifier. | |||
SOURCE_LINE_ID | NUMBER | 18 | Source document transaction line identifier. | |||
SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Source document entity code. | |||
SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Source document event class code. | |||
SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the source document line identifier is stored. | |||
ADJUSTED_DOC_NUMBER | VARCHAR2 | 150 | Adjusted Document Number | |||
APPLIED_FROM_TRX_NUMBER | VARCHAR2 | 150 | Applied from Transaction Number | |||
APPLIED_TO_TRX_NUMBER | VARCHAR2 | 150 | Applied To Transaction Number | |||
BILL_THIRD_PTY_ACCT_ID | NUMBER | 18 | Third Party Billing Account Identifier | |||
BILL_THIRD_PTY_ACCT_SITE_ID | NUMBER | 18 | Third Party Billing Account Site Identifier | |||
BILL_TO_CUST_ACCT_SITE_USE_ID | NUMBER | 18 | Third Party Billing Account Site Usage Identifier | |||
CHAR1 | VARCHAR2 | 150 | Extensibility Character Column 1 | |||
CHAR2 | VARCHAR2 | 150 | Extensibility Character Column 2 | |||
CHAR3 | VARCHAR2 | 150 | Extensibility Character Column 3 | |||
CHAR4 | VARCHAR2 | 150 | Extensibility Character Column 4 | |||
CHAR5 | VARCHAR2 | 150 | Extensibility Character Column 5 | |||
CHAR6 | VARCHAR2 | 150 | Extensibility Character Column 6 | |||
CHAR7 | VARCHAR2 | 150 | Extensibility Character Column 7 | |||
CHAR8 | VARCHAR2 | 150 | Extensibility Character Column 8 | |||
CHAR9 | VARCHAR2 | 150 | Extensibility Character Column 9 | |||
CHAR10 | VARCHAR2 | 150 | Extensibility Character Column 9 | |||
DATE1 | DATE | Extensibility Date Column 1 | ||||
DATE10 | DATE | Extensibility Date Column 10 | ||||
DATE2 | DATE | Extensibility Date Column 2 | ||||
DATE3 | DATE | Extensibility Date Column 3 | ||||
DATE4 | DATE | Extensibility Date Column 4 | ||||
DATE5 | DATE | Extensibility Date Column 5 | ||||
DATE6 | DATE | Extensibility Date Column 6 | ||||
DATE7 | DATE | Extensibility Date Column 7 | ||||
DATE8 | DATE | Extensibility Date Column 8 | ||||
DATE9 | DATE | Extensibility Date Column 9 | ||||
FOB_POINT | VARCHAR2 | 30 | Freight Point | |||
MERCHANT_PTY_DOC_NUMBER | VARCHAR2 | 150 | Merchant Party Document Number | |||
MERCHANT_PTY_NAME | VARCHAR2 | 150 | Merchant Party Name | |||
MERCHANT_PTY_REFERENCE | VARCHAR2 | 250 | Merchant Party Reference | |||
MERCHANT_PTY_TAXPAYER_ID | VARCHAR2 | 150 | Merchant Party Tax Payer ID | |||
MERCHANT_PTY_TAX_PROF_ID | NUMBER | 18 | Merchant Party Tax Profile ID | |||
MERCHANT_PTY_TAX_REG_NUMBER | VARCHAR2 | 150 | Merchant Party Tax Registration Number | |||
NUMERIC1 | NUMBER | Extensibility Numeric Column 1 | ||||
NUMERIC10 | NUMBER | Extensibility Numeric Column 10 | ||||
NUMERIC2 | NUMBER | Extensibility Numeric Column 2 | ||||
NUMERIC3 | NUMBER | Extensibility Numeric Column 3 | ||||
NUMERIC4 | NUMBER | Extensibility Numeric Column 4 | ||||
NUMERIC5 | NUMBER | Extensibility Numeric Column 5 | ||||
NUMERIC6 | NUMBER | Extensibility Numeric Column 6 | ||||
NUMERIC7 | NUMBER | Extensibility Numeric Column 7 | ||||
NUMERIC8 | NUMBER | Extensibility Numeric Column 8 | ||||
NUMERIC9 | NUMBER | Extensibility Numeric Column 9 | ||||
START_EXPENSE_DATE | DATE | Start Expense Date | ||||
SHIP_THIRD_PTY_ACCT_ID | NUMBER | 18 | Third Party Shipping Account Identifier | |||
SHIP_THIRD_PTY_ACCT_SITE_ID | NUMBER | 18 | Third Party Shipping Account Site Identifier | |||
SHIP_TO_CUST_ACCT_SITE_USE_ID | NUMBER | 18 | Third Party Shipping Account Site Use Identifier | |||
TRADING_HQ_PARTY_ID | NUMBER | 18 | Trading HQ Party Idenifier | |||
TRADING_HQ_PARTY_SITE_ID | NUMBER | 18 | Trading HQ Party Site Identifier | |||
TRX_LINE_CURRENCY_CODE | VARCHAR2 | 15 | Transaction Line Currency Code | |||
TRX_LINE_CURRENCY_CONV_DATE | DATE | Transaction Line Currency Conversion date | ||||
TRX_LINE_CURRENCY_CONV_RATE | NUMBER | Transaction Line Currency Conversion rate. | ||||
TRX_LINE_CURRENCY_CONV_TYPE | VARCHAR2 | 30 | Transaction Line Currency Conversion type. | |||
TRX_LINE_MAU | NUMBER | Trasaction Line minimum accountable unit. | ||||
TRX_LINE_PRECISION | NUMBER | Transaction Line Precision. | ||||
TRX_SIC_CODE | VARCHAR2 | 150 | Transaction SIC code | |||
TRX_WAYBILL_NUMBER | VARCHAR2 | 50 | Transaction Way Bill Number | |||
TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Number of the tax invoice used to meet specific tax reporting requirements of different countries. | |||
TAX_INVOICE_DATE | DATE | Date of the tax invoice used to meet specific tax reporting requirements of different countries. | ||||
WHT_GROUP_ID | NUMBER | 18 | Withholding group identifier for the transaction line. | |||
REQUISITION_TYPE | VARCHAR2 | 25 | Requisition type associated a transaction line. | |||
PURCHASING_CATEGORY_ID | NUMBER | 18 | Item category identifier for a transaction line. | |||
DROP_SHIP_FLAG | VARCHAR2 | 1 | Yes or No indicates whether a transaction line is a drop ship transaction. | |||
CONSIGNED_FLAG | VARCHAR2 | 1 | Yes or No indicates whether a transaction line is consigned. | |||
DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Destination type code for a good or service on a transaction line. | |||
CONSIGN_ITM_UPON_RECPT_FLAG | VARCHAR2 | 1 | Yes or No indicates a consigned item upon receipt. | |||
EXPENDITURE_TYPE | VARCHAR2 | 30 | Project expenditure type used to build accounting flexfield for project-related distribution line. | |||
PORT_OF_DISCHARGE | VARCHAR2 | 150 | Location code where a ship voluntarily and without cause of necessity breaks bulk and discharges part or all of its cargo. | |||
PORT_OF_LOADING | VARCHAR2 | 150 | Location code where shipments are loaded and secured aboard a vessel. | |||
DELIVERY_TYPE | VARCHAR2 | 30 | Delivery type for a good or service on a transaction line. | |||
DOCUMENT_TYPE | VARCHAR2 | 30 | Document type for a good or service on a transaction line. | |||
SHIPMENT_TYPE | VARCHAR2 | 25 | Shipment type associated with a transaction line. | |||
FOS_TRANSACTION_ID | NUMBER | 18 | Supply chain financial orchestration agreement identifier. | |||
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Final destination location identifier for the purchases made by the customer. | |||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Code for the country of the manufacture | |||
FINAL_TRANSACTION_NODE_FLAG | VARCHAR2 | 1 | Yes or No indicates whether the internal material transfer is backed by an invoice. | |||
CREDIT_ACCOUNT_CCID | NUMBER | 18 | Credit account identifier for the transaction line. | |||
DEBIT_ACCOUNT_CCID | NUMBER | 18 | Debit account identifier for the transaction line. | |||
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. | |||
LINK_TO_TRX_LINE_ID | NUMBER | 18 | Item line identifier associated with a charge line. | |||
PACKING_CHARGE | NUMBER | Amount of the packing charge on a transaction. | ||||
PURCHASE_BASIS | VARCHAR2 | 30 | Monetary value basis of the line type. | |||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether the underlying procure-to-pay transaction allows accrual on receipt. Valid values: Y and N. | |||
LINE_GROUP_ID | NUMBER | 18 | Identifer to group multiple transaction lines together, such as grouping mutiple shipment lines as one fulfillment line. | |||
TRX_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the transaction. | |||
TRX_NUMBER | VARCHAR2 | 150 | Alphanumeric identifier on a transaction. | |||
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_FROM_PTY_NUMBER | VARCHAR2 | 30 | Party number from whom goods are shipped. | |||
SHIP_FROM_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_FROM_PTY_NUMBER | VARCHAR2 | 30 | Party number that is responsible for sending the invoice. | |||
BILL_FROM_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. | |||
BATCH_NAME | VARCHAR2 | 240 | Batch name to be used in conjunction with transaction number to identify the parent transaction. | |||
DEBIT_ACCT_STRING | VARCHAR2 | 1000 | Concatenated accounting flexfield segments associated with the debit account. | |||
CREDIT_ACCT_STRING | VARCHAR2 | 1000 | Concatenated accounting flexfield segments associated with the credit account. | |||
ADJ_DOC_LINE_NUMBER | NUMBER | Numeric identifier of a line on the adjusted document. | ||||
ADJ_DOC_NUMBER | VARCHAR2 | 150 | Transaction number of the adjusted document. | |||
ADJ_DOC_APP_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the adjusted document. | |||
APP_FRM_LINE_NUMBER | NUMBER | Numeric identifier of a line on the applied from document. | ||||
APP_FRM_DOC_NUMBER | VARCHAR2 | 150 | Transaction number of the applied from document. | |||
APP_FRM_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the applied from document. | |||
REF_DOC_LINE_NUMBER | NUMBER | Numeric identifier of a line on the reference document associated with the transaction. | ||||
REF_DOC_NUMBER | VARCHAR2 | 150 | Transaction number of the reference document associated with the transaction. | |||
REF_DOC_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the reference document associated with the transaction. | |||
FIRST_PTY_REG_NUM | VARCHAR2 | 60 | First party tax registration number of the transaction. | |||
FIRST_PTY_REG_ID | VARCHAR2 | 20 | First party tax registration ID of the transaction. | |||
THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Third party tax registration number of the transaction. | |||
THIRD_PTY_REG_ID | VARCHAR2 | 20 | Third party tax registration ID of the transaction. | |||
MATCH_TYPE | VARCHAR2 | 25 | Indicates the type of match for Payables transaction. Valid va;ues are purchase order, receipt, or consumption. | |||
SOURCE_TRX_NUMBER | VARCHAR2 | 150 | Transacation identifier of the source transaction. | |||
SOURCE_LINE_NUMBER | NUMBER | 18 | Line number of the source transaction. | |||
SOURCE_TRX_DATE | DATE | Transaction date of the source taxable transaction. | ||||
SOURCE_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name associated with the source transaction. | |||
APP_TO_LINE_NUMBER | NUMBER | 18 | Line number of the receipt that is applied to invoice. | |||
APP_TO_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the receipt that is applied to invoice. | |||
EXPENDITURE_TYPE_ID | NUMBER | 18 | Project expenditure type identifier. | |||
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Country for which the transaction is deemed to have taken place for taxation purposes. | |||
DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Classification used by a tax authority to categorize a document associated with a transaction for a tax. | |||
FINAL_DISCHARGE_LOCATION_CODE | VARCHAR2 | 60 | Final destination location code for the purchases made by the customer. | |||
RETAINAGE_AMT | NUMBER | Retainage amount for the item line. | ||||
RETAINAGE_PERCENTAGE | NUMBER | Retainage percentage for the item line. | ||||
TAX_GROSS_NET_FLAG | VARCHAR2 | 1 | Transaction tax calculated on the gross or net amount identifier. | |||
WHT_GROSS_NET_FLAG | VARCHAR2 | 1 | Withholding tax calculated on the gross or net amount identifier. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
ZX_TRANSACTION_LINES | zx_transaction | TRX_ID |
zx_sim_trx_dists | zx_transaction_lines | TRX_LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
ZX_TRANSACTION_LINES_N1 | Non Unique | FUSION_TS_TX_DATA | TRX_ID | Active |
ZX_TRANSACTION_LINES_U1 | Unique | FUSION_TS_TX_IDX | TRX_LINE_ID | Active |