Mar 29, 2010

Data Structure of Oracle Inventory

Data Structure of  Oracle Inventory


: Setup > Organizations > Parameters
This view contains basic information on all inventory organisations.
Some columns of interest includes :
·         Organization_code
·         Organization_name
·         Set_of_books_id (when you have more than one set of book, you’ll also need to link to gl_sets_of_books)
·         Inventory_enabled_flag

: Setup > Organizations > Subinventories
This table stores all subinventory information for an inventory organisation.
Some columns of interest includes :
·         Secondary_inventory_name
·         Description

: Transactions > Material Transactions (Inquiry)
This table stores all inventory transactions including cost updates.
Some columns of interest includes :
·         Transaction_quantity
·         Transaction_type_id
·         Transaction_source_type_id
·         Transaction_source_name

: Transactions > Material Distributions (Inquiry)
This table stores the inventory accounting information.  There are two rows in this table for each transaction in mtl_material_transactions.
Some columns of interest includes :
·         Transaction_date
·         Gl_batch_id
·         Accounting_line_type
·         Base_transaction_value

: Items > Master Items or Items > Organization Items
This table stores the item definition. An item must exist in an inventory organisation.
Your item number is stored in the columns segment1 to segment20 depending on your application configuration.  If you have configured your items to have to segments then you may be using segment1 and segment2
Some columns of interest includes :
·         Segment1 to segment20
·         Description
·         Invetory_item_flag
·         Purchasing_item_flag
·         Inventory_asset_flag
·         Stock_enabled_flag
·         Invoiceable_item_flag
·         Shippable_item_flag
·         So_transaction_flag
·         Mtl_transactions_enabled_flag
·         Primary_unit_of_measure

: On-hand, Availability > On-hand Quantities
This table stores quantity on hand in a location for each item.
Some columns of interest includes :
·         Date_received
·         Transaction_quantity
·         Subinventory_code

: Costs > Item Costs
This table stores the item cost information.  Note that there can be multiple costs per item and the actual cost is where the cost type is Frozen.
Some columns of interest includes :
·         Cost_type_id (link to cst_cost_types)
·         Item_cost

No comments:

OraApps Search

Custom Search

Search This Blog