Inventory on hand described
When importing subledger transactions from a CSV or Excel file you must assign fields in the file to Caseware fields in the subledger dataset type you select on import, so that the transaction data displays correctly in the engagement. This topic details the fields in the Inventory on hand subledger.
For more information on the subledger dataset descriptions, see Understand subledger data.
For more information on importing transaction data from CSV files, see Import the client’s transactions from a CSV.
| Field | Usage |
|---|---|
| Transaction ID ( inventory_on_hand_transaction_id) | The transaction identifier associated with either the Procure to Pay or Order to Cash Subledger Audit Data Standards (ADS). Data type: Text Required: No Primary key: The value of this field is used to form the unique identifier of this entry. |
| Inventory Product ID ( inventory_on_hand_inventory_product_id) | The product identifier is a code that uniquely identifies an item that you carry in inventory. Data type: Text Required: Yes Primary key: First alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
| Serial Number ( inventory_on_hand_serial_number) | The number associated with an individual product item that is used for tracking and managing. For example, a company purchases 10 computers, with each computer assigned an individual serial number. Data type: Text Required: No Primary key: Sixth alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
| Lot Number ( inventory_on_hand_lot_number) | The number associated with a product that is used for tracking and managing the lot. Data type: Text Required: No Primary key: Fifth alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
| Location ID ( inventory_on_hand_location_id) | The unique identifier of a specific location within a division or site where inventory is received, held, and issued from. Data type: Text Required: No |
| Inventory Held For Vendors ( inventory_on_hand_inventory_held_for_vendors) | True, if the inventory is physically present and is being held for vendors; false, otherwise. Data type: Enum Required: No Possible values: true or false. |
| Inventory Held For Customers ( inventory_on_hand_inventory_held_for_customers) | True, if the inventory is physically present and is being held for customers; false, otherwise. Data type: Enum Required: No Possible values: true or false. |
| Inventory Held For Others ( inventory_on_hand_inventory_held_for_others) | True, if the inventory is physically present and is being held for others aside from customers or vendors; false, otherwise. Data type: Enum Required: No Possible values: true or false. |
| Obsolete or Damaged Inventory ( inventory_on_hand_obsolete_or_damaged_inventory) | This inventory status identifies inventory quantities that are slow moving, damaged or obsolete. Data type: Text Required: No Example values: slow moving, damaged, or obsolete |
| Bin ID ( inventory_on_hand_bin_id) | The optional identifier of an inventory sublocation. A code used in an inventory management system. Data type: Text Required: No Primary key: Fourth alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
| Bin Location ( inventory_on_hand_bin_location) | The description of the inventory sublocation identified in Bin ID. Data type: Text Required: No |
| Inventory Quantity ( inventory_on_hand_quantity) | The inventory count whose unit of measure is specified in Inventory Stocking UOM. Data type: Decimal Required: No |
| Inventory Cost Method ( inventory_on_hand_inventory_cost_method) | The description of costing practice, such as LIFO, FIFO, Average, Standard, and specific identification. Data type: Text Required: No |
| Inventory Cost ( inventory_on_hand_inventory_cost) | The cost per unit using the method found in Inventory Cost Method. Data type: Money Required: No |
| Quantity On Hand System ( inventory_on_hand_quantity_on_hand_system) | Either the quantity on hand at the last physical count according to the source system, or the calculated quantity on hand. Data type: Decimal Required: No |
| Inventory As Of Date ( inventory_on_hand_inventory_as_of_date) | The date you start tracking the quantity on hand of an inventory item. Data type: Date Required: No |
| Inventory Costing UOM Code ( inventory_on_hand_inventory_costing_uom_code) | The code of the measurement unit for the inventory's cost. Data type: Text Required: No |
| Business Unit Code ( inventory_on_hand_business_unit_code) | Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited. Data type: Text Required: No Primary key: Second alternate. If Transaction ID is not present in the data, the value of this field is concatenated with the values of the other alternate fields to form the unique identifier of the entry, for example |
| Inventory Purchasing UOM ( inventory_on_hand_inventory_purchasing_uom) | The primary unit of measure used to express quantities of goods purchased by the organization. Data type: Text Required: No |
| Inventory Stocking UOM ( inventory_on_hand_inventory_stocking_uom) | The unit of measure that is used to count quantities of items held in inventory. Data type: Text Required: No |
| Inventory Selling UOM ( inventory_on_hand_inventory_selling_uom) | The primary unit of measure in which inventory sales quantities are expressed. Data type: Text Required: No |
| Standard Cost ( inventory_on_hand_standard_cost) | If maintained, the standard cost per unit. Data type: Money Required: No |
| Average Cost ( inventory_on_hand_average_cost) | If maintained, the average cost per unit. Data type: Money Required: No |
| Specific Cost ( inventory_on_hand_specific_cost) | If maintained, the specific cost per unit. Data type: Money Required: No |
| Quantity On Hand Physical Count ( inventory_on_hand_quantity_on_hand_physical_count) | The quantity on hand at last physical count per physical count. Data type: Decimal Required: No |
| Last Count Date ( inventory_on_hand_last_count_date) | The date of last physical count. Data type: Date Required: No |
| Inventory List Price ( inventory_on_hand_inventory_list_price) | The list or suggested retail price. Data type: Money Required: No |
| Inventory Purchase Year To Date ( inventory_on_hand_inventory_purchase_year_to_date) | The quantity purchased at this location year to date. Data type: Decimal Required: No |
| Inventory Sold Year To Date ( inventory_on_hand_inventory_sold_year_to_date) | The quantity sold from this location year to date. Data type: Decimal Required: No |
| Location Currency ( inventory_on_hand_location_currency) | The local currency. Data type: Text Required: No |
