DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_TRANSACTION_LINES

Object Details
Object Name: ZX_TRANSACTION_LINES
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_TRANSACTION_LINES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_TRANSACTION_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
ColumnTRX_LINE_ID
Columns
Name Datatype Length Mandatory Comments
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
TRX_LINE_ID NUMBER (15) Yes Transaction line identifier
TRX_LINE_NUMBER NUMBER
Yes Transaction line number
TRX_ID NUMBER (15) Yes Primary transaction identifier
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.
TRX_LINE_TYPE VARCHAR2 (30)
Column to store type of the transaction line. Possible values are ITEM, FREIGHT and MISC.
TRX_LINE_DATE DATE

Transaction line date
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Transaction business category code of the transaction line
LINE_INTENDED_USE VARCHAR2 (240)
Intended use code of the transaction line. This identifies the purpose for which the product is used.
USER_DEFINED_FISC_CLASS VARCHAR2 (30)
User defined fiscal classification code of the transaction line
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.
LINE_AMT NUMBER

Transaction line amount
TRX_LINE_QUANTITY NUMBER

Transaction line quantity
UNIT_PRICE NUMBER

Unit Price of the transaction line item or product
PRODUCT_ID NUMBER

Column to store internal identifier of the inventory item or memo line used on this transaction line.
PRODUCT_FISC_CLASSIFICATION VARCHAR2 (240)
Product fiscal classification code of the inventory item
PRODUCT_ORG_ID NUMBER

Identifier of the organization for the inventory item
UOM_CODE VARCHAR2 (30)
Unit of measure code for the inventory item
PRODUCT_TYPE VARCHAR2 (240)
Product type code of the inventory item. Possible values are GOODS and SERVICES.
PRODUCT_CODE VARCHAR2 (300)
Inventory item code
PRODUCT_CATEGORY VARCHAR2 (240)
Product category code of the transaction line
MERCHANT_PARTY_ID NUMBER

Merchant party identifier recorded for the Payables expense report
ACCOUNT_CCID NUMBER

Account identifier
ACCOUNT_STRING VARCHAR2 (2000)
Column to store concatanated account string value
REF_DOC_LINE_ID NUMBER

Transaction line identifier for the reference document
REF_DOC_LINE_QUANTITY NUMBER

Reference document line quantity
REF_DOC_APPLICATION_ID NUMBER

Reference document application identifier
REF_DOC_ENTITY_CODE VARCHAR2 (30)
Reference document entity code
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Reference document event class code
REF_DOC_TRX_ID NUMBER

Reference document transaction identifier
APPLIED_FROM_LINE_ID NUMBER

Transaction line identifier for the applied from document
APPLIED_FROM_APPLICATION_ID NUMBER

Applied from document application identifier
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
Applied from document entity code
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
Applied from document event class code
APPLIED_FROM_TRX_ID NUMBER

Applied from document transaction identifier
ADJUSTED_DOC_LINE_ID NUMBER

Transaction line identifier for the adjusted document
ADJUSTED_DOC_DATE DATE

Adjusted document date
ADJUSTED_DOC_APPLICATION_ID NUMBER

Adjusted document application identifier
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
Adjusted document entity code
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Adjusted document event class code
ADJUSTED_DOC_TRX_ID NUMBER

Adjusted document transaction identifier
TRX_LINE_DESCRIPTION VARCHAR2 (240)
Description for the transaction line
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description of the inventory item or memo line used on the transaction line
TRX_LINE_GL_DATE DATE

Accounting date for the transaction line
LINE_LEVEL_ACTION VARCHAR2 (30) Yes Column to store action at the transaction line level
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.
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
TAX_REGIME_ID NUMBER (15)
Tax regime identifier
TAX_REGIME_CODE VARCHAR2 (30)
Tax regime code
TAX_ID NUMBER (15)
Tax identifier
TAX VARCHAR2 (30)
Tax
TAX_STATUS_ID NUMBER (15)
Tax status identifier
TAX_STATUS_CODE VARCHAR2 (30)
Tax status code
TAX_RATE_ID NUMBER (15)
Tax rate identifier
TAX_RATE_CODE VARCHAR2 (50)
Tax rate code
TAX_RATE NUMBER

Tax rate
TAX_LINE_AMT NUMBER

Tax line amount
LINE_CLASS VARCHAR2 (30)
Column to store event class for the transaction line
TRX_SHIPPING_DATE DATE

Shipping date of the transaction at header or line level
TRX_RECEIPT_DATE DATE

Receipt date of the transaction at header or line level
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
Tax exemption certificate number
EXEMPT_REASON VARCHAR2 (240)
Tax exemption reason
CASH_DISCOUNT NUMBER

Cash discount amount
VOLUME_DISCOUNT NUMBER

Volume discount quantity
TRADING_DISCOUNT NUMBER

Trading discount amount
TRANSFER_CHARGE NUMBER

Transfer charge
TRANSPORTATION_CHARGE NUMBER

Transportation charge
INSURANCE_CHARGE NUMBER

Insurance charge
OTHER_CHARGE NUMBER

Other charge
POA_PARTY_ID NUMBER

Point of acceptance party identifier
POO_PARTY_ID NUMBER

Point of origin party identifier
POA_PARTY_SITE_ID NUMBER

Point of acceptance party site identifier
POO_PARTY_SITE_ID NUMBER

Point of origin party site identifier
MERCHANT_PARTY_COUNTRY VARCHAR2 (150)
Merchant party country code
APPLIED_TO_APPLICATION_ID NUMBER

Applied to document application identifier
APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
Applied to document entity code
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
Applied to document event class code
APPLIED_TO_TRX_ID NUMBER

Applied to document transaction identifier
APPLIED_TO_TRX_LINE_ID NUMBER

Transaction line identifier for the applied to document
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
CTRL_TOTAL_LINE_TX_AMT NUMBER

Control amount for the total tax amount at the line level
INPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax classifiation code for Procure To Pay products
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (50)
Tax classifiation code for Order To Cash products
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.
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.
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.
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.
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.
EXEMPT_REASON_CODE VARCHAR2 (30)
Exemption reason code
RECEIVABLES_TRX_TYPE_ID NUMBER

Transaction type identifier for Receivables transactions
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_LINE_ID
,      TRX_LINE_NUMBER
,      TRX_ID
,      TRX_LEVEL_TYPE
,      TRX_LINE_TYPE
,      TRX_LINE_DATE
,      TRX_BUSINESS_CATEGORY
,      LINE_INTENDED_USE
,      USER_DEFINED_FISC_CLASS
,      LINE_AMT_INCLUDES_TAX_FLAG
,      LINE_AMT
,      TRX_LINE_QUANTITY
,      UNIT_PRICE
,      PRODUCT_ID
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_ORG_ID
,      UOM_CODE
,      PRODUCT_TYPE
,      PRODUCT_CODE
,      PRODUCT_CATEGORY
,      MERCHANT_PARTY_ID
,      ACCOUNT_CCID
,      ACCOUNT_STRING
,      REF_DOC_LINE_ID
,      REF_DOC_LINE_QUANTITY
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_TRX_ID
,      ADJUSTED_DOC_LINE_ID
,      ADJUSTED_DOC_DATE
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      TRX_LINE_DESCRIPTION
,      PRODUCT_DESCRIPTION
,      TRX_LINE_GL_DATE
,      LINE_LEVEL_ACTION
,      HISTORICAL_FLAG
,      BILL_FROM_PARTY_SITE_ID
,      BILL_TO_PARTY_SITE_ID
,      SHIP_FROM_PARTY_SITE_ID
,      SHIP_TO_PARTY_SITE_ID
,      SHIP_TO_PARTY_ID
,      SHIP_FROM_PARTY_ID
,      BILL_TO_PARTY_ID
,      BILL_FROM_PARTY_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_FROM_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      BILL_FROM_LOCATION_ID
,      POA_LOCATION_ID
,      POO_LOCATION_ID
,      PAYING_LOCATION_ID
,      OWN_HQ_LOCATION_ID
,      TRADING_HQ_LOCATION_ID
,      POC_LOCATION_ID
,      POI_LOCATION_ID
,      POD_LOCATION_ID
,      TAX_REGIME_ID
,      TAX_REGIME_CODE
,      TAX_ID
,      TAX
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_LINE_AMT
,      LINE_CLASS
,      TRX_SHIPPING_DATE
,      TRX_RECEIPT_DATE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON
,      CASH_DISCOUNT
,      VOLUME_DISCOUNT
,      TRADING_DISCOUNT
,      TRANSFER_CHARGE
,      TRANSPORTATION_CHARGE
,      INSURANCE_CHARGE
,      OTHER_CHARGE
,      POA_PARTY_ID
,      POO_PARTY_ID
,      POA_PARTY_SITE_ID
,      POO_PARTY_SITE_ID
,      MERCHANT_PARTY_COUNTRY
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_TRX_ID
,      APPLIED_TO_TRX_LINE_ID
,      CTRL_HDR_TX_APPL_FLAG
,      CTRL_TOTAL_LINE_TX_AMT
,      INPUT_TAX_CLASSIFICATION_CODE
,      OUTPUT_TAX_CLASSIFICATION_CODE
,      REF_DOC_TRX_LEVEL_TYPE
,      APPLIED_TO_TRX_LEVEL_TYPE
,      APPLIED_FROM_TRX_LEVEL_TYPE
,      ADJUSTED_DOC_TRX_LEVEL_TYPE
,      EXEMPTION_CONTROL_FLAG
,      EXEMPT_REASON_CODE
,      RECEIVABLES_TRX_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZX.ZX_TRANSACTION_LINES;

Dependencies

[top of page]

ZX.ZX_TRANSACTION_LINES does not reference any database object

ZX.ZX_TRANSACTION_LINES is referenced by following:

SchemaZX
ViewZX_TRANSACTION_LINES#