1. Tables and Views for Financials
  2. JG_FSCL_DOC_LINES_ALL

JG_FSCL_DOC_LINES_ALL

This table contains transaction line level attributes required for generating fiscal document. Product teams would populate this table with their transaction lines attributes prior to calling the fiscal document generation process.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_DOC_LINES_PK

DOC_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
DOC_LINE_ID NUMBER 18 Yes Document line identifier of the transaction. Active
DOC_HDR_ID NUMBER 18 Yes Document header identifier of the transaction. Active
APPLICATION_ID NUMBER 18 Yes Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction, which indicates the type of transaction being created. Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction, such as requisition, purchase order and agreement, and release. Active
TRX_ID NUMBER 18 Yes System-generated identification number of a transaction. Active
TRX_LINE_ID NUMBER 18 Yes Transaction line identifier of the transaction. Active
TRX_LEVEL_TYPE VARCHAR2 30 Yes Level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
TRX_LINE_TYPE VARCHAR2 30 Transaction line type that indicates transaction nature such as freight, insurance, discount, other accessory expenses. Active
LINK_TO_TRX_LINE_ID NUMBER 18 Link to original fiscal document line for insurance or freight line types. Active
BILLABLE_FLAG VARCHAR2 1 Flag to represent if line is included in invoice to customer. Active
LINE_LEVEL_ACTION VARCHAR2 30 Action at the transaction line level. 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 18 Numeric identifier of a transaction line. Active
TRX_LINE_DESCRIPTION VARCHAR2 1000 Shows the description of the transaction line. Active
LINE_INTENDED_USE VARCHAR2 240 Intended use code of the transaction line that identifies the purpose for which the product is used. 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_SIC_CODE VARCHAR2 150 Standard industry classification code of the transaction. Active
FOB_POINT VARCHAR2 30 Point at which the ownership of the goods in transit changes. Active
TRX_WAYBILL_NUMBER VARCHAR2 50 Waybill number of the transaction. Active
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product fiscal classification code of 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 for anything you buy, sell, or handle in your business. An item may be a tangible item in your warehouse, such as a wrench or tractor, or an intangible item, such as a service. Active
PROD_FC_CATEG_ID NUMBER 18 Product fiscal classification category identifier of the transaction line. Active
PRODUCT_CATEGORY VARCHAR2 240 Product category code of the transaction line. Active
PRODUCT_DESCRIPTION VARCHAR2 240 Description of the inventory item or memo line used on the transaction line. Active
USER_DEFINED_FISC_CLASS VARCHAR2 30 User-defined fiscal classification code of the transaction line. Active
INTENDED_USE_CLASSIF_ID NUMBER 18 Default intended use code for transactions for a specified country. Active
LINE_AMT NUMBER Monetary amount associated with the transaction line. Active
TRX_LINE_QUANTITY NUMBER Quantity of the associated transaction line. Active
UNIT_PRICE NUMBER Unit price of the transaction line item or product. Active
CASH_DISCOUNT NUMBER Cash discount associated with a transaction to calculate the taxable basis. Active
VOLUME_DISCOUNT NUMBER Volume discount quantity associated with the transaction line. Active
TRADING_DISCOUNT NUMBER Trading discount amount associated with the transaction line. Active
TRANSFER_CHARGE NUMBER Transfer charge associated with the transaction line. Active
TRANSPORTATION_CHARGE NUMBER Transportation charge associated with the transaction line. Active
INSURANCE_CHARGE NUMBER Insurance charge associated with the transaction. Active
OTHER_CHARGE NUMBER Other charge associated with the transaction. Active
ASSESSABLE_VALUE NUMBER 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 Oracle internal use only. Active
ASSET_NUMBER VARCHAR2 150 Oracle internal use only. Active
ASSET_ACCUM_DEPRECIATION NUMBER Oracle internal use only. Active
ASSET_TYPE VARCHAR2 150 Oracle internal use only. Active
ASSET_COST NUMBER Oracle internal use only. Active
ADJUSTED_DOC_APPLICATION_ID NUMBER 18 Oracle internal use only. Active
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 30 Oracle internal use only. Active
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 30 Oracle internal use only. Active
ADJUSTED_DOC_TRX_ID NUMBER 18 Oracle internal use only. Active
ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2 30 Oracle internal use only. 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 18 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 Oracle internal use only. Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction business category code of the transaction line. Active
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 80 Certificate number associated with a tax exemption. Active
EXEMPT_REASON VARCHAR2 240 Reason a tax exemption was granted and taken. 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 for Oracle internal use only. Active
TRX_LINE_GL_DATE DATE Accounting date for the transaction line. Active
LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2 1 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
ACCOUNT_CCID NUMBER 18 Unique combination of segment values that records accounting transactions. Active
ACCOUNT_STRING VARCHAR2 1000 Concatenated account code combination string value. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
NUMERIC1 NUMBER Numeric attribute for extensibility. Active
NUMERIC2 NUMBER Numeric attribute for extensibility. Active
NUMERIC3 NUMBER Numeric attribute for extensibility. Active
NUMERIC4 NUMBER Numeric attribute for extensibility. Active
NUMERIC5 NUMBER Numeric attribute for extensibility. Active
NUMERIC6 NUMBER Numeric attribute for extensibility. Active
NUMERIC7 NUMBER Numeric attribute for extensibility. Active
NUMERIC8 NUMBER Numeric attribute for extensibility. Active
NUMERIC9 NUMBER Numeric attribute for extensibility. Active
NUMERIC10 NUMBER Numeric attribute for extensibility. Active
CHAR1 VARCHAR2 150 Character attribute for extensibility. Active
CHAR2 VARCHAR2 150 Character attribute for extensibility. Active
CHAR3 VARCHAR2 150 Character attribute for extensibility. Active
CHAR4 VARCHAR2 150 Character attribute for extensibility. Active
CHAR5 VARCHAR2 150 Character attribute for extensibility. Active
CHAR6 VARCHAR2 150 Character attribute for extensibility. Active
CHAR7 VARCHAR2 150 Character attribute for extensibility. Active
CHAR8 VARCHAR2 150 Character attribute for extensibility. Active
CHAR9 VARCHAR2 150 Character attribute for extensibility. Active
CHAR10 VARCHAR2 150 Character attribute for extensibility. Active
DATE1 DATE Date attribute for extensibility. Active
DATE2 DATE Date attribute for extensibility. Active
DATE3 DATE Date attribute for extensibility. Active
DATE4 DATE Date attribute for extensibility. Active
DATE5 DATE Date attribute for extensibility. Active
DATE6 DATE Date attribute for extensibility. Active
DATE7 DATE Date attribute for extensibility. Active
DATE8 DATE Date attribute for extensibility. Active
DATE9 DATE Date attribute for extensibility. Active
DATE10 DATE Date attribute for extensibility. Active
SHIP_TO_LOCATION_ID NUMBER 18 Ship-to location identifier for the place where goods are received from a vendor. Active
SHIP_FROM_LOCATION_ID NUMBER 18 Ship-from location identifier for the place from which goods are to be shipped. Active
POA_LOCATION_ID NUMBER 18 Location identifier for where the purchase order is deemed to have been accepted by the supplier. Active
POO_LOCATION_ID NUMBER 18 Location identifier for where the purchase order is deemed to have been originated. Active
BILL_TO_LOCATION_ID NUMBER 18 Bill-to location identifier for the customer that is responsible for receiving and paying the invoice. Active
BILL_FROM_LOCATION_ID NUMBER 18 Bill-from location identifier of the party that sent the bill. Active
PAYING_LOCATION_ID NUMBER 18 Oracle internal use only. Active
OWN_HQ_LOCATION_ID NUMBER 18 Oracle internal use only. Active
TRADING_HQ_LOCATION_ID NUMBER 18 Oracle internal use only. Active
POC_LOCATION_ID NUMBER 18 Oracle internal use only. Active
POI_LOCATION_ID NUMBER 18 Oracle internal use only. Active
POD_LOCATION_ID NUMBER 18 Oracle internal use only. Active
TITLE_TRANSFER_LOCATION_ID NUMBER 18 Oracle internal use only. Active
LINE_CLASS VARCHAR2 30 Event class of the transaction line. Active
TRX_LINE_DATE DATE Date of the associated adjusted transaction line. Active
INPUT_TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax classification code for procure to pay products. Active
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax classification code for order to cash products. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
TRX_ID_LEVEL2 NUMBER Oracle internal use only. Active
TRX_ID_LEVEL3 NUMBER Oracle internal use only. Active
TRX_ID_LEVEL6 NUMBER Oracle internal use only. Active
TRX_ID_LEVEL5 NUMBER Oracle internal use only. Active
TRX_ID_LEVEL4 NUMBER Oracle internal use only. Active
THRESHOLD_INDICATOR_FLAG VARCHAR2 1 Y or N indicates whether thresholds are applied at the document level. Active
SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER 18 Ship-to customer account site use identifier for Receivables. Active
BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER 18 Bill-to customer account site use identifier for Receivables. Active
REVERSED_APPLN_ID NUMBER 18 Reversed transaction application Identifier. Active
REVERSED_ENTITY_CODE VARCHAR2 30 Reversed transaction entity code. Active
REVERSED_EVNT_CLS_CODE VARCHAR2 30 Reversed transaction event class code. Active
REVERSED_TRX_ID NUMBER 18 Reversed transaction identifier. Active
REVERSED_TRX_LEVEL_TYPE VARCHAR2 30 Level at which the reversed transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
REVERSED_TRX_LINE_ID NUMBER 18 Reversed transaction line identifier. Active
SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER 18 Ship-to customer account site identifier for Receivables or ship-from supplier site identifier for Payables. Active
BILL_THIRD_PTY_ACCT_SITE_ID NUMBER 18 Bill-to customer account site identifier for Receivables or bill-from supplier site identifier for Payables. Active
SHIP_THIRD_PTY_ACCT_ID NUMBER 18 Ship-to customer account identifier for Receivables or ship-from supplier identifier for Payables. Active
BILL_THIRD_PTY_ACCT_ID NUMBER 18 Bill-to customer account identifier for Receivables or bill-from supplier identifier for Payables. Active
INTERFACE_ENTITY_CODE VARCHAR2 30 Entity code of the transaction line interface table. 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
TRX_LINE_CURRENCY_CODE VARCHAR2 15 The three-letter ISO (International Organization for Standardization) code associated with a currency of the transaction line. Active
TRX_LINE_CURRENCY_CONV_RATE NUMBER Ratio at which the principal unit of one currency can be converted into another currency. Active
TRX_LINE_CURRENCY_CONV_DATE DATE Transaction line date of the exchange rate. Active
TRX_LINE_PRECISION NUMBER Precision of the transaction line in the entered currency. Active
TRX_LINE_MAU NUMBER Minimum accountable unit of the transaction line in the entered currency. Active
TRX_LINE_CURRENCY_CONV_TYPE VARCHAR2 30 Transaction line exchange rate type. Active
FIRST_PTY_REG_ID NUMBER 18 First party tax registration identifier for the transaction. Active
THIRD_PTY_REG_ID NUMBER 18 Third party tax registration identifier for the transaction. Active
FOS_TRANSACTION_ID NUMBER 18 Supply chain financial orchestration (SFO) agreement identifier. Active
DROP_SHIP_FLAG VARCHAR2 1 Attribute that indicates whether a transaction line is a drop ship transaction. Possible values are Y or N. Active
CONSIGNED_FLAG VARCHAR2 1 Y or N indicates whether a transaction line is consigned. Active
CONSIGN_ITM_UPON_RECPT_FLAG VARCHAR2 1 Y or N indicates a consigned item upon receipt. Active
PORT_OF_DISCHARGE VARCHAR2 150 Location code where a ship discharges part or all of its cargo. Active
PORT_OF_LOADING VARCHAR2 150 Location code where shipments are loaded and secured aboard a vessel. Active
DELIVERY_TYPE VARCHAR2 30 Delivery type for a good or service on a transaction line. Active
DOCUMENT_TYPE VARCHAR2 30 Document type for a good or service on a transaction line. Active
SHIPMENT_TYPE VARCHAR2 25 Shipment type associated with a transaction line. Active
WHT_GROUP_ID NUMBER 18 Withholding group identifier of the transaction line. Active
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 Final destination location identifier for the purchases made by the customer. Active
FINAL_TRANSACTION_NODE_FLAG VARCHAR2 1 Y or N indicates whether the internal material transfer is backed by an invoice. Active
BILL_FROM_PARTY_ID NUMBER 18 Bill-from party identifier of the party that sent the bill. Active
BILL_FROM_PARTY_SITE_ID NUMBER 18 Bill-from party site identifier of the party that sent the bill. Active
BILL_TO_PARTY_ID NUMBER 18 Bill-to party identifier for the customer that is responsible for receiving and paying the invoice. Active
BILL_TO_PARTY_SITE_ID NUMBER 18 Bill-to party site identifier for the customer that is responsible for receiving and paying the invoice. Active
OWN_HQ_PARTY_ID NUMBER 18 Oracle internal use only. Active
OWN_HQ_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
PAYING_PARTY_ID NUMBER 18 Oracle internal use only. Active
PAYING_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
POA_PARTY_ID NUMBER 18 Oracle internal use only. Active
POA_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
POD_PARTY_ID NUMBER 18 Oracle internal use only. Active
POD_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
POI_PARTY_ID NUMBER 18 Oracle internal use only. Active
POI_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
POO_PARTY_ID NUMBER 18 Oracle internal use only. Active
POO_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
SHIP_FROM_PARTY_ID NUMBER 18 Oracle internal use only. Active
SHIP_FROM_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
SHIP_TO_PARTY_ID NUMBER 18 Ship-to party identifier for the party receiving goods from a vendor. Active
SHIP_TO_PARTY_SITE_ID NUMBER 18 Ship-to party site identifier for the party receiving goods from a vendor. Active
TITLE_TRANSFER_PARTY_ID NUMBER 18 Oracle internal use only. Active
TITLE_TRANSFER_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
TRADING_HQ_PARTY_ID NUMBER 18 Oracle internal use only. Active
TRADING_HQ_PARTY_SITE_ID NUMBER 18 Oracle internal use only. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
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_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition 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.
UOM_CODE VARCHAR2 30 Unit of measure code for quantity based rates.
INVENTORY_ORG_ID NUMBER 18 Identifies the inventory organization of the item for which the cost is being published.
ROOT_PARENT_LINE_ID NUMBER 18 Invoice line identifier associated to the parent configured item in a configured item hierarchy.
SOURCE_DOCUMENT_NUMBER VARCHAR2 150 The identifier for a shipment transaction used to identify the transaction number associated to a shipment line.

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_DOC_LINES_U1 Unique FUSION_TS_TX_IDX DOC_LINE_ID Active
JG_FSCL_DOC_LINES_U2 Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE Active