ZX_TRANSACTION_LINES_GT
This table stores Transaction Lines information
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
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_ID | NUMBER | 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_ID | NUMBER | Yes | Transaction line identifier | Active | ||
LINE_LEVEL_ACTION | VARCHAR2 | 30 | Yes | Column to store action at the transaction line level | 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 | |||
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 | NUMBER | Yes | Transaction line amount | Active | ||
TRX_LINE_QUANTITY | NUMBER | Transaction line quantity | 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 | |||
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 | ||
TRX_SIC_CODE | VARCHAR2 | 150 | Standard industry classification code of the transaction | Active | ||
FOB_POINT | VARCHAR2 | 30 | Free on Board point | Active | ||
SHIP_TO_PARTY_ID | NUMBER | Ship to party identifier | Active | |||
SHIP_FROM_PARTY_ID | NUMBER | Ship from party identifier | Active | |||
POA_PARTY_ID | NUMBER | Point of acceptance party identifier | Active | |||
POO_PARTY_ID | NUMBER | Point of origin party identifier | Active | |||
BILL_TO_PARTY_ID | NUMBER | Bill to party identifier | Active | |||
BILL_FROM_PARTY_ID | NUMBER | Bill from party identifier | Active | |||
MERCHANT_PARTY_ID | NUMBER | Merchant party identifier recorded for the Payables expense report | Active | |||
SHIP_TO_PARTY_SITE_ID | NUMBER | Ship to party site identifier | Active | |||
SHIP_FROM_PARTY_SITE_ID | NUMBER | Ship from party site 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 | |||
BILL_TO_PARTY_SITE_ID | NUMBER | Bill to party site identifier | Active | |||
BILL_FROM_PARTY_SITE_ID | NUMBER | Bill from party site identifier | Active | |||
SHIP_TO_LOCATION_ID | NUMBER | Ship to location identifier | Active | |||
SHIP_FROM_LOCATION_ID | NUMBER | Ship from location identifier | Active | |||
POA_LOCATION_ID | NUMBER | Point of Acceptance location identifier | Active | |||
POO_LOCATION_ID | NUMBER | Point of Origin location identifier | Active | |||
BILL_TO_LOCATION_ID | NUMBER | Bill to location identifier | Active | |||
BILL_FROM_LOCATION_ID | NUMBER | Bill from location identifier | Active | |||
ACCOUNT_CCID | NUMBER | Account identifier | Active | |||
ACCOUNT_STRING | VARCHAR2 | 2000 | Column to store concatanated account string value | Active | ||
MERCHANT_PARTY_COUNTRY | VARCHAR2 | 150 | Merchant party country code | 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 | |||
REF_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the header level user composite key for uniquely identifying the reference document | Active | ||
REF_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the header level user composite key for uniquely identifying the reference document | Active | ||
REF_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the header level user composite key for uniquely identifying the reference document | Active | ||
REF_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the header level user composite key for uniquely identifying the reference document | Active | ||
REF_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the header level user composite key for uniquely identifying the reference document | Active | ||
REF_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the header level user composite key for uniquely identifying the reference document | Active | ||
REF_DOC_LINE_ID | NUMBER | Transaction line identifier for the reference document | Active | |||
REF_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line level user composite key for uniquely identifying the reference document line | Active | ||
REF_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line level user composite key for uniquely identifying the reference document line | Active | ||
REF_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line level user composite key for uniquely identifying the reference document line | Active | ||
REF_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line level user composite key for uniquely identifying the reference document line | Active | ||
REF_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line level user composite key for uniquely identifying the reference document line | Active | ||
REF_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line level user composite key for uniquely identifying the reference document line | Active | ||
REF_DOC_LINE_QUANTITY | NUMBER | Reference document line quantity | 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 | |||
APP_FROM_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the header level user composite key for uniquely identifying the applied from document | Active | ||
APP_FROM_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the header level user composite key for uniquely identifying the applied from document | Active | ||
APP_FROM_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the header level user composite key for uniquely identifying the applied from document | Active | ||
APP_FROM_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the header level user composite key for uniquely identifying the applied from document | Active | ||
APP_FROM_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the header level user composite key for uniquely identifying the applied from document | Active | ||
APP_FROM_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the header level user composite key for uniquely identifying the applied from document | Active | ||
APPLIED_FROM_LINE_ID | NUMBER | Transaction line identifier for the applied from document | Active | |||
APP_FROM_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line level user composite key for uniquely identifying the applied from document line | Active | ||
APP_FROM_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line level user composite key for uniquely identifying the applied from document line | Active | ||
APP_FROM_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line level user composite key for uniquely identifying the applied from document line | Active | ||
APP_FROM_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line level user composite key for uniquely identifying the applied from document line | Active | ||
APP_FROM_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line level user composite key for uniquely identifying the applied from document line | Active | ||
APP_FROM_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line level user composite key for uniquely identifying the applied from document line | 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 | |||
ADJ_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the header level user composite key for uniquely identifying the adjusted document | Active | ||
ADJ_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the header level user composite key for uniquely identifying the adjusted document | Active | ||
ADJ_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the header level user composite key for uniquely identifying the adjusted document | Active | ||
ADJ_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the header level user composite key for uniquely identifying the adjusted document | Active | ||
ADJ_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the header level user composite key for uniquely identifying the adjusted document | Active | ||
ADJ_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the header level user composite key for uniquely identifying the adjusted document | Active | ||
ADJUSTED_DOC_LINE_ID | NUMBER | Transaction line identifier for the adjusted document | Active | |||
ADJ_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line level user composite key for uniquely identifying the adjusted document line | Active | ||
ADJ_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line level user composite key for uniquely identifying the adjusted document line | Active | ||
ADJ_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line level user composite key for uniquely identifying the adjusted document line | Active | ||
ADJ_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line level user composite key for uniquely identifying the adjusted document line | Active | ||
ADJ_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line level user composite key for uniquely identifying the adjusted document line | Active | ||
ADJ_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line level user composite key for uniquely identifying the adjusted document line | Active | ||
ADJUSTED_DOC_NUMBER | VARCHAR2 | 150 | Transaction number of the adjusted document | Active | ||
ADJUSTED_DOC_DATE | DATE | Adjusted document date | 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 | |||
APP_TO_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the header level user composite key for uniquely identifying the applied to document | Active | ||
APP_TO_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the header level user composite keyfor uniquely identifying the applied to document | Active | ||
APP_TO_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the header level user composite key for uniquely identifying the applied to document | Active | ||
APP_TO_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the header level user composite key for uniquely identifying the applied to document | Active | ||
APP_TO_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the header level user composite key for uniquely identifying the applied to document | Active | ||
APP_TO_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the header level user composite key for uniquely identifying the applied to document | Active | ||
APPLIED_TO_TRX_LINE_ID | NUMBER | Transaction line identifier for the applied to document | Active | |||
APP_TO_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line level user composite key for uniquely identifying the applied to document line | Active | ||
APP_TO_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line level user composite key for uniquely identifying the applied to document line | Active | ||
APP_TO_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line level user composite key for uniquely identifying the applied to document line | Active | ||
APP_TO_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line level user composite key for uniquely identifying the applied to document line | Active | ||
APP_TO_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line level user composite key for uniquely identifying the applied to document line | Active | ||
APP_TO_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line level user composite key for uniquely identifying the applied to document line | Active | ||
TRX_ID_LEVEL2 | NUMBER | Transaction identifier at a level between trx_id and trx_line_id | Active | |||
TRX_ID_LEVEL3 | NUMBER | Transaction identifier at a level between trx_id_level2 and trx_line_id | Active | |||
TRX_ID_LEVEL4 | NUMBER | Transaction identifier at a level between trx_id_level3 and trx_line_id | Active | |||
TRX_ID_LEVEL5 | NUMBER | Transaction identifier at a level between trx_id_level4 and trx_line_id | Active | |||
TRX_ID_LEVEL6 | NUMBER | Transaction identifier at a level between trx_id_level5 and trx_line_id | Active | |||
HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the user composite key to uniquely identify the transaction | Active | ||
HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the user composite key to uniquely identify the transaction | Active | ||
HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the user composite key to uniquely identify the transaction | Active | ||
HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the user composite key to uniquely identify the transaction | Active | ||
HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the user composite key to uniquely identify the transaction | Active | ||
HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the user composite key to uniquely identify the transaction | Active | ||
LINE_TRX_USER_KEY1 | VARCHAR2 | 150 | First component of the line user composite key for uniquely identifying the transaction line | Active | ||
LINE_TRX_USER_KEY2 | VARCHAR2 | 150 | Second component of the line user composite key for uniquely identifying the transaction line | Active | ||
LINE_TRX_USER_KEY3 | VARCHAR2 | 150 | Third component of the line user composite key for uniquely identifying the transaction line | Active | ||
LINE_TRX_USER_KEY4 | VARCHAR2 | 150 | Fourth component of the line user composite key for uniquely identifying the transaction line | Active | ||
LINE_TRX_USER_KEY5 | VARCHAR2 | 150 | Fifth component of the line user composite key for uniquely identifying the transaction line | Active | ||
LINE_TRX_USER_KEY6 | VARCHAR2 | 150 | Sixth component of the line user composite key for uniquely identifying the transaction line | Active | ||
TRX_LINE_NUMBER | NUMBER | Transaction line number | 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_WAYBILL_NUMBER | VARCHAR2 | 50 | Waybill number of the transaction | Active | ||
TRX_LINE_GL_DATE | DATE | Accounting date for the transaction line | Active | |||
MERCHANT_PARTY_NAME | VARCHAR2 | 150 | Merchant party name recorded for the Payables expense report | Active | ||
MERCHANT_PARTY_DOCUMENT_NUMBER | VARCHAR2 | 150 | Merchant party document number recorded for the Payables expense report | Active | ||
MERCHANT_PARTY_REFERENCE | VARCHAR2 | 250 | Merchant party reference recorded for the Payables expense report | Active | ||
MERCHANT_PARTY_TAXPAYER_ID | VARCHAR2 | 150 | Merchant party taxpayer ID recorded for the Payables expense report | Active | ||
MERCHANT_PARTY_TAX_REG_NUMBER | VARCHAR2 | 150 | Merchant party tax registration number recorded for the Payables expense report | Active | ||
PAYING_PARTY_ID | NUMBER | Not currently used | Active | |||
OWN_HQ_PARTY_ID | NUMBER | Not currently used | Active | |||
TRADING_HQ_PARTY_ID | NUMBER | Not currently used | Active | |||
POI_PARTY_ID | NUMBER | Not currently used | Active | |||
POD_PARTY_ID | NUMBER | Not currently used | Active | |||
TITLE_TRANSFER_PARTY_ID | NUMBER | Not currently used | Active | |||
PAYING_PARTY_SITE_ID | NUMBER | Not currently used | Active | |||
OWN_HQ_PARTY_SITE_ID | NUMBER | Not currently used | Active | |||
TRADING_HQ_PARTY_SITE_ID | NUMBER | Not currently used | Active | |||
POI_PARTY_SITE_ID | NUMBER | Not currently used | Active | |||
POD_PARTY_SITE_ID | NUMBER | Not currently used | Active | |||
TITLE_TRANSFER_PARTY_SITE_ID | NUMBER | Not currently used | 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 | |||
TITLE_TRANSFER_LOCATION_ID | NUMBER | Not currently used | Active | |||
ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | Active | |||
ASSET_FLAG | VARCHAR2 | 1 | Not currently used | Active | ||
ASSET_NUMBER | VARCHAR2 | 150 | Not currently used | Active | ||
ASSET_ACCUM_DEPRECIATION | NUMBER | Not currently used | Active | |||
ASSET_TYPE | VARCHAR2 | 150 | Not currently used | Active | ||
ASSET_COST | NUMBER | Not currently used | Active | |||
NUMERIC1 | NUMBER | Not currently used | Active | |||
NUMERIC2 | NUMBER | Not currently used | Active | |||
NUMERIC3 | NUMBER | Not currently used | Active | |||
NUMERIC4 | NUMBER | Not currently used | Active | |||
NUMERIC5 | NUMBER | Not currently used | Active | |||
NUMERIC6 | NUMBER | Not currently used | Active | |||
NUMERIC7 | NUMBER | Not currently used | Active | |||
NUMERIC8 | NUMBER | Not currently used | Active | |||
NUMERIC9 | NUMBER | Not currently used | Active | |||
NUMERIC10 | NUMBER | Not currently used | Active | |||
CHAR1 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR2 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR3 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR4 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR5 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR6 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR7 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR8 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR9 | VARCHAR2 | 150 | Not currently used | Active | ||
CHAR10 | VARCHAR2 | 150 | Not currently used | Active | ||
DATE1 | DATE | Not currently used | Active | |||
DATE2 | DATE | Not currently used | Active | |||
DATE3 | DATE | Not currently used | Active | |||
DATE4 | DATE | Not currently used | Active | |||
DATE5 | DATE | Not currently used | Active | |||
DATE6 | DATE | Not currently used | Active | |||
DATE7 | DATE | Not currently used | Active | |||
DATE8 | DATE | Not currently used | Active | |||
DATE9 | DATE | Not currently used | Active | |||
DATE10 | DATE | Not currently used | Active | |||
SHIP_TO_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for ship to party of the transaction line | Active | |||
SHIP_FROM_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for ship from party of the transaction line | Active | |||
POA_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for point of acceptance party of the transaction line | Active | |||
POO_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for point of origin party of the transaction line | Active | |||
PAYING_PARTY_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
OWN_HQ_PARTY_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
TRADING_HQ_PARTY_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
POI_PARTY_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
POD_PARTY_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
BILL_TO_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for bill to party of the transaction line | Active | |||
BILL_FROM_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for bill from party of the transaction line | Active | |||
TITLE_TRANS_PARTY_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
SHIP_TO_SITE_TAX_PROF_ID | NUMBER | Party tax profile identifier for ship to party site of the transaction line | Active | |||
SHIP_FROM_SITE_TAX_PROF_ID | NUMBER | Party tax profile identifier for ship from party site of the transaction line | Active | |||
POA_SITE_TAX_PROF_ID | NUMBER | Party tax profile identifier for point of acceptance party site of the transaction line | Active | |||
POO_SITE_TAX_PROF_ID | NUMBER | Party tax profile identifier for point of origin party site of the transaction line | Active | |||
PAYING_SITE_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
OWN_HQ_SITE_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
TRADING_HQ_SITE_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
POI_SITE_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
POD_SITE_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
BILL_TO_SITE_TAX_PROF_ID | NUMBER | Party tax profile identifier for bill to party site of the transaction line | Active | |||
BILL_FROM_SITE_TAX_PROF_ID | NUMBER | Party tax profile identifier for bill from party site of the transaction line | Active | |||
TITLE_TRANS_SITE_TAX_PROF_ID | NUMBER | Not currently used | Active | |||
MERCHANT_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for merchant party of the transaction line | Active | |||
HQ_ESTB_PARTY_TAX_PROF_ID | NUMBER | Party tax profile identifier for HQ establishment 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 | |
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 | ||
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 | ||
SOURCE_APPLICATION_ID | NUMBER | Source document application identifier | Active | |||
SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Source document entity code | Active | ||
SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Source document event class code | Active | ||
SOURCE_TRX_ID | NUMBER | Source document transaction identifier | Active | |||
SOURCE_LINE_ID | NUMBER | Source document transaction line identifier | Active | |||
SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Column to record the level at which the source document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | ||
UNIT_PRICE | NUMBER | Unit Price of the transaction line item or product | Active | |||
START_EXPENSE_DATE | DATE | Start expense date of a Payables Invoice distribution | 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 | ||
DEFAULTING_ATTRIBUTE1 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE2 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE3 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE4 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE5 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE6 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE7 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE8 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE9 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
DEFAULTING_ATTRIBUTE10 | VARCHAR2 | 150 | Attribute used in rules for defaulting one of the tax determining factors | Active | ||
SOURCE_TAX_LINE_ID | NUMBER | Column to record source document tax line identifier that is represented by the current transaction line for billing purposes | Active | |||
APPLIED_FROM_TRX_NUMBER | VARCHAR2 | 150 | Transaction number of the applied from document | 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 | ||
APPLIED_TO_TRX_NUMBER | VARCHAR2 | 150 | Applied to document transaction number | Active | ||
EXEMPT_REASON_CODE | VARCHAR2 | 30 | Exemption reason code | Active | ||
INTERFACE_ENTITY_CODE | VARCHAR2 | 30 | Column to temporarily store entity code of the transaction line interface table | Active | ||
INTERFACE_LINE_ID | NUMBER | Column to temporarily store identifier of the interface line corresponding to the transaction line during import of transactions into Receivables | Active | |||
HISTORICAL_TAX_CODE_ID | NUMBER | 18 | Tax classification code identifier stored on the historical transactions | Active | ||
TRX_LINE_CURRENCY_CODE | VARCHAR2 | 15 | Transaction line currency code | Active | ||
TRX_LINE_CURRENCY_CONV_RATE | NUMBER | Transaction line exchange rate | Active | |||
TRX_LINE_CURRENCY_CONV_DATE | DATE | Transaction line date of the exchange rate | Active | |||
TRX_LINE_CURRENCY_CONV_TYPE | VARCHAR2 | 30 | Transaction line exchange rate type | Active | ||
TRX_LINE_MAU | NUMBER | Minimum accountable unit of the transaction line currency | Active | |||
TRX_LINE_PRECISION | NUMBER | Precision of the transaction line currency | Active | |||
BILL_TO_CUST_ACCT_SITE_USE_ID | NUMBER | Column to record bill to customer account site use identifier for Receivables | Active | |||
SHIP_TO_CUST_ACCT_SITE_USE_ID | NUMBER | Column to record ship to customer account site use identifier for Receivables. | Active | |||
SHIP_THIRD_PTY_ACCT_ID | NUMBER | Column to record ship to customer account identifier for Receivables or ship from supplier identifier for Payables | Active | |||
BILL_THIRD_PTY_ACCT_ID | NUMBER | Column to record bill to customer account identifier for Receivables or bill from supplier identifier for Payables | Active | |||
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 | Active | |||
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 | 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 | |||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | Active | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | Active | ||
USER_UPD_DET_FACTORS_FLAG | VARCHAR2 | 1 | Y or N indicates whether the user has updated additional tax determining factors like transaction business category, assessable value | Active | ||
TAX_DATE | DATE | For internal use only | Active | |||
TAX_DETERMINE_DATE | DATE | For internal use only | Active | |||
TAX_POINT_DATE | DATE | For internal use only | Active | |||
SUBSCRIPTION_DATE | DATE | For internal use only | Active | |||
PROD_FC_CATEG_ID | NUMBER | Oracle internal use only | ||||
INTENDED_USE_CLASSIF_ID | NUMBER | Oracle internal use only | ||||
MATCH_TYPE | VARCHAR2 | 25 | Indicates the type of match for Payables transaction. | |||
TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | |||
TAX_INVOICE_DATE | DATE | Oracle internal use only. | ||||
REQUISITION_TYPE | VARCHAR2 | 25 | Oracle internal use only. | |||
PURCHASING_CATEGORY_ID | NUMBER | 18 | Oracle internal use only. | |||
DROP_SHIP_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
CONSIGNED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Oracle internal use only. | |||
CONSIGN_ITM_UPON_RECPT_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
EXPENDITURE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |||
PORT_OF_DISCHARGE | VARCHAR2 | 150 | Oracle internal use only. | |||
PORT_OF_LOADING | VARCHAR2 | 150 | Oracle internal use only. | |||
DELIVERY_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |||
DOCUMENT_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |||
SHIPMENT_TYPE | VARCHAR2 | 25 | Oracle internal use only. | |||
WHT_GROUP_ID | NUMBER | 18 | Oracle internal use only. | |||
FOS_TRANSACTION_ID | NUMBER | 18 | Oracle internal use only. | |||
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | |||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | 2 | Oracle internal use only. | |||
FINAL_TRANSACTION_NODE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
FIRST_PTY_REG_ID | NUMBER | 18 | Oracle internal use only. | |||
THIRD_PTY_REG_ID | NUMBER | 18 | Oracle internal use only. | |||
DEBIT_ACCOUNT_CCID | NUMBER | 18 | Debit account identifier for the transaction line. | |||
CREDIT_ACCOUNT_CCID | NUMBER | 18 | Credit account identifier for the transaction line. | |||
INDIRECT_TAX_LINE_ID | NUMBER | 18 | Oracle internal use only. | |||
TAX_REGIME_CODE | VARCHAR2 | 30 | Oracle internal use only. | |||
TAX_REGIME_ID | NUMBER | 18 | Oracle internal use only. | |||
TAX | VARCHAR2 | 30 | Oracle internal use only. | |||
TAX_ID | NUMBER | 18 | Oracle internal use only. | |||
TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | |||
TAX_JURISDICTION_ID | NUMBER | 18 | Oracle internal use only. | |||
PAYMENT_DATE | DATE | Oracle internal use only. | ||||
PAYMENT_ID | NUMBER | 18 | Oracle internal use only. | |||
CHECKRUN_ID | NUMBER | 18 | Oracle internal use only. | |||
PAYMENT_AMT | NUMBER | Oracle internal use only. | ||||
DISCOUNT_AMT | NUMBER | Oracle internal use only. | ||||
LINK_TO_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only. | |||
PACKING_CHARGE | NUMBER | Oracle internal use only. | ||||
PURCHASE_BASIS | VARCHAR2 | 30 | Oracle internal use only. | |||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
LINE_GROUP_ID | NUMBER | 18 | Oracle internal use only. | |||
PAYMENT_NUMBER | NUMBER | 18 | Oracle internal use only. | |||
WHT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Oracle internal use only. | |||
EXPENDITURE_TYPE_ID | NUMBER | 18 | Oracle internal use only. | |||
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Oracle internal use only. | |||
DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Oracle internal use only. | |||
FIRST_PTY_REG_NUM | VARCHAR2 | 60 | Oracle internal use only. | |||
THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Oracle internal use only. | |||
FINAL_DISCHARGE_LOCATION_CODE | VARCHAR2 | 60 | Oracle internal use only. | |||
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. | ||||
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. | |||
TRANSACTION_LINE_GEOGRAPHY_ID | NUMBER | 18 | Column to store the geography ID of the place where the transaction took place. For example, the geography ID of the city where an employee incurred a meal. |
Indexes
Index | Uniqueness | Columns | Status |
---|---|---|---|
ZX_TRANSACTION_LINES_GT_U1 | Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, INDIRECT_TAX_LINE_ID, TRX_LEVEL_TYPE, PAYMENT_ID, CHECKRUN_ID, PAYMENT_NUMBER | Active |