INL Tables (32)

INL - Oracle Landed Cost Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
INL_ALLOCATIONS 17 This table stores all amounts of a Shipment, prorated into its Shipment Lines.
INL_ALWD_LINE_TYPES 10 This table stores Shipment Line Types for Shipment Types.
INL_ALWD_PARTY_TYPES 9 This table stores Party Types that are allowed for a Shipment Type.
INL_ALWD_PARTY_USAGES 9 This table stores Party Usages that are allowed for a Shipment Type.
INL_ALWD_SOURCE_TYPES 9 This table stores Source Types that are allowed for a Shipment Type.
INL_ASSOCIATIONS 14 This table stores associations between landed cost components of the same or different Shipments.
INL_ATTRIBUTES_B 9 This table stores common characteristics of Attributes.
INL_ATTRIBUTES_TL 12 This table stores translatable data for Attributes.
INL_CHARGE_LINES 48 This table stores information on charges associated to Shipment components.
INL_CONDITIONS 20 This table stores common characteristics of COnditions.
INL_ENTITIES_B 8 This table stores common characteristics of Entities.
INL_ENTITIES_TL 11 This table stores translatable data for Entities.
INL_INTERFACE_ERRORS 29 This table stores information on errors occurred during LCM Open Interface Processor.
INL_MATCHES 37 This table stores actual amounts and the shipment components they refer to, to be used in actual landed cost calculation.
INL_MATCHES_INT 37 This table stores Open Interface data for Matches.
INL_MATCH_AMOUNTS 21 This table stores actual charge amounts, grouped by cost factor, and the shipment components they refer to, to be used as actual charges, in
INL_MATCH_AMOUNTS_INT 18 This table stores Open Interface data for matches between actual and estimated charge amounts of a Landed Cost Shipment, grouped by Charge L
INL_PARAMETERS 27 This table stores the general LCM setup options by Inventory Organization.
INL_RULES_B 9 This table stores common characteristics of Rules.
INL_RULES_TL 9 This table stores translatable data for Rules.
INL_SHIP_HEADERS_ALL 45 This table stores header information on Shipments.
INL_SHIP_HEADERS_INT 49 This table stores Open Interface data for Shipment Headers.
INL_SHIP_HOLDS 31 This table stores information on holds occurred during LCM Shipment validation process.
INL_SHIP_LINES_ALL 81 This table stores information on Shipment Lines.
INL_SHIP_LINES_INT 114 This table stores Open Interface data for Shipment Lines
INL_SHIP_LINE_GROUPS 36 This table stores attributes common to all Shipment Lines below it
INL_SHIP_LINE_TYPES_B 27 This table stores common characteristics of Shipment Lines.
INL_SHIP_LINE_TYPES_TL 9 This table stores translatable data for Shipment Line Types.
INL_SHIP_TYPES_B 26 This table stores common characteristics of Shipments.
INL_SHIP_TYPES_TL 9 This table stores translatable data for Shipment Types.
INL_SIMULATIONS 35 This table is for to grouping the several simulated shipments that may be generated for a given source document and revision
INL_TAX_LINES 22 This table stores information on taxes associated to Shipment components.