Below is a data dictionary for the Fishbowl AI Insights dataset, which includes the tables, IDs, categories, descriptions, and synonyms used within the product.
| table | id | category | precision | type | unit | description | synonyms |
| receipt_details | datereceived | date | %m-%d-%Y | The date when the goods were received. | date received,receipt details datereceived,Received Date | ||
| part | vendorid | dimensions | id | The unique identifier for the vendor associated with the part. | vendorid,part vendorid,Vendor ID | ||
| receipt_details | vendorid | dimensions | id | Vendor ID,receipt details vendorid,vendor id | |||
| receipt_details | billedtotalcost | metrics | 2 | Currency | $ | The total cost billed for the received items, including taxes, shipping, and other charges. | Billed Total Cost,receipt details billedtotalcost,Billed Amount,billed total cost |
| purchase_order_details | poitem_desc | dimensions | id | poitem desc,poitem desc,PO Item Description,Purchase Order Item Description | |||
| sales_order_details | product_c1 | dimensions | id | Custom field 1 associated with the product in the sales order. | product c1,Product Custom Field 1 | ||
| work_order_details | wo_id | dimensions | id | wo id,wo id,WO ID | |||
| sales_order_details | bill_to_zip | dimensions | id | The postal/ZIP code where the bill for the sales order should be sent. | Billing Zip,bill to zip | ||
| part | not_available_qty | metrics | 2 | Quantity | Not Available Quantity,not available qty,not available qty,Unavailable Quantity | ||
| part | safety_days | metrics | 2 | Quantity | safety days,safety days,Safety Days | ||
| product | accountingid | dimensions | id | accountingid,Accounting ID,product accountingid | |||
| part | moq | metrics | 2 | Quantity | MOQ,part moq,Minimum Order Quantity | ||
| inventory_details | qtyallocatedmo | metrics | 2 | Quantity | Allocated Quantity to MO,Quantity Allocated to MO | ||
| customer_group | customer_name | dimensions | id | The name of the customer associated with the account. | Customer Name,customer name,Customer | ||
| receipt_details | part_description | dimensions | id | part Description,Part Description,part description | |||
| manufacturing_order_details | datecompleted | date | %m-%d-%Y | The date on which the manufacturing order was completed. | Completion Date,Completed Date,manufacturing order details datecompleted | ||
| work_order_details | datecreated | date | %m-%d-%Y | The date on which the work order was created. | date created,Created Date,work order details datecreated | ||
| sales_order_details | fulfilled_margin | metrics | 2 | Quantity | The margin or profit realized upon fulfillment of the sales order. | fulfilled margin,Fulfilled Margin | |
| sales_order_details | qtypicked | metrics | 2 | Quantity | The quantity that has been picked for the sales order. | Picked Quantity,Picked Qty,qtypicked | |
| product_tree | product_number | dimensions | id | The official number assigned to the product. | Product Number,product number | ||
| part | not_available_qty | metrics | 2 | Quantity | The quantity of the part that is not available for use. | Not Available Quantity,not available qty,not available qty,Unavailable Quantity | |
| manufacturing_order_details | moitem_status | dimensions | The current status of the item within the manufacturing order. | moitem status,Manufacturing Order Item Status | |||
| product_tree | uom_name | dimensions | uom name,UOM,Unit of Measure,uom name | ||||
| sales_order_details | qtyfulfilled | metrics | 2 | Quantity | The quantity that has been fulfilled or delivered for the sales order. | qty fulfilled,fulfilled Qty,Fulfilled Quantity | |
| receipt_details | receipt_qty_baseuom | metrics | 2 | Quantity | Quantity is multiplied with unit of measure conversion. | Base UOM Receipt Quantity,Receipt Quantity by Base UOM,receipt qty base uom,receipt qty baseuom,receipt qty baseuom | |
| part | active_flag | flag | Indicates whether the part is active or inactive. | Active Flag,active flag,active flag | |||
| purchase_order_details | shipstate | dimensions | id | The state to which the order is being shipped. | ship state,purchase order details shipstate,Shipping State | ||
| product | product_short_num | dimensions | id | Product Short Number,product short num | |||
| sales_order_details | so_c3 | dimensions | id | Custom field 3 associated with the sales order. | Sales Order Custom Field 3,so c3 | ||
| work_order_details | partid | dimensions | id | The unique identifier for a part used in the work order. | partid,work order details partid,Part ID | ||
| receipt_details | shipstate_name | dimensions | Receipt State,shipstate name,Shipping State,Ship State,shipstate name,ship state name | ||||
| inventory_details | locationgroupid | dimensions | id | Location Group ID,location group id | |||
| work_order_details | wo_num | dimensions | id | WO Number,wo num,wo num | |||
| purchase_order_details | carrier_name | dimensions | id | The name of the carrier responsible for delivering the goods. | carrier name,carrier name,Carrier Name | ||
| sales_order_details | qtytofulfill | metrics | 2 | Quantity | The quantity that remains to be fulfilled or delivered for the sales order. | Quantity to Fulfill,qtytofulfill,qty to fulfill | |
| purchase_order_details | datefirstship | date | %m-%d-%Y | The date when the first shipment was made for the PO. | date first ship,First Ship Date,purchase order details datefirstship | ||
| purchase_order_details | unit_cost | metrics | 4 | Currency | $ | The cost per unit of the item in the purchase order. | Unit Cost,unit cost,unit cost |
| inventory_details | unavailable | metrics | 2 | Quantity | Sum of Quantity from Quantity not Available | unavailable Qty,Unavailable Quantity | |
| work_order_details | datecreated | date | %m-%d-%Y | date created,Created Date,work order details datecreated | |||
| purchase_order_details | remittoname | dimensions | id | The name to which payment should be remitted. | Remittance Name,purchase order details remittoname,remit to name | ||
| work_order_details | wostatus_name | dimensions | The status of the work order, indicating its current stage or condition. | wo status name,wostatus name,WO Status,WO Status Name,wostatus name | |||
| sales_order_details | customer_id | dimensions | id | The unique identifier for the customer associated with the sales order. | customer id,Customer ID | ||
| sales_order_details | bill_to_city | dimensions | id | The city where the bill for the sales order should be sent. | Billing City,bill to city | ||
| sales_order_details | completed_date | date | %m-%d-%Y | The date when the sales order was marked as completed. | completed date,Completed Date | ||
| purchase_order_details | po_item_id | dimensions | id | Purchase Order Item ID,PO Item ID,po item id,po item id | |||
| sales_order_details | vendor_name | dimensions | id | The name of the vendor associated with the sales order. | Vendor,vendor name,Vendor Name | ||
| location_inventory_details | part_description | dimensions | id | Part Description,part description,part Description | |||
| inventory_details | location_group | dimensions | The group or category of locations related to the inventory. | Location Group Name,Location Group | |||
| inventory_details | part | dimensions | The part or item received. | Item,Part | |||
| sales_order_details | soitem_desc | dimensions | id | The description of the item in the sales order. | soitem desc,Sales Order Item Description,SO Item Description | ||
| receipt_details | buyer | dimensions | id | The name or ID of the individual or organization responsible for purchasing the items received. | Buyer,Buyer Name,receipt details buyer | ||
| product_tree | uom_code | dimensions | id | The code representing the unit of measure used for items in the sales order. | UOM Code,Unit of Measure Code,uom code,uom code | ||
| manufacturing_order_details | description | dimensions | id | A brief description of the work order. | description,manufacturing order details description,Manufacturing Order Description,MO Description | ||
| work_order_details | datefinished | date | %m-%d-%Y | date finished,work order details datefinished,Finished Date | |||
| location_inventory_details | part_description | dimensions | id | A description of the part or item in inventory. | Part Description,part description,part Description | ||
| receipt_details | deliverto | dimensions | id | The location or individual to whom the goods are delivered. | deliver to,receipt details deliverto,Deliver to | ||
| product_tree | category_level3 | dimensions | id | The level 3 category under which the product is classified. | category level3,category level3 | ||
| work_order_details | priority_name | dimensions | Priority Name,priority name,priority name | ||||
| purchase_order_details | carrierid | dimensions | id | The unique identifier for the carrier. | Carrier ID,carrier id,purchase order details carrierid | ||
| manufacturing_order_details | moitem_id | dimensions | id | moitem id,moitem id,MO Item ID | |||
| sales_order_details | datefirstship | date | %m-%d-%Y | The date when the first shipment for the sales order is scheduled or has occurred. | First Ship Date,date first ship | ||
| receipt_details | po_status | dimensions | The status of the purchase order (e.g., Open, Closed, Pending). | po status,po status,PO Status | |||
| location_inventory_details | location | dimensions | id | The name of the inventory location. | location inventory details location,location name,Location Name | ||
| receipt_details | locationgroupid | dimensions | id | The ID of the group of locations associated with the receipt. | Location Group ID,receipt details locationgroupid,location group id | ||
| sales_order_details | sellableinotheruoms | flag | Indicates whether the item in the sales order can be sold in other units of measure (UOMs). | Sellable in Other UOM | |||
| receipt_details | shiptoname | dimensions | id | The name of the recipient of the goods. | Receipt by Name,receipt details shiptoname,Shipping Name,ship to name | ||
| sales_order_details | solineitem | metrics | 2 | Quantity | A specific line item in the sales order. | SO Line Item,so line item,Sales Order Line Item | |
| work_order_details | part_num | dimensions | The unique number or code assigned to a part or item used in the work order. | part Number,Raw Material,Item,Part Number,Part,part num | |||
| purchase_order_details | remittoname | dimensions | Remittance Name,purchase order details remittoname,remit to name | ||||
| receipt_details | vendor_name | dimensions | id | The name of the vendor from whom the goods were purchased. | vendor name,vendor name,Vendor | ||
| inventory_details | qty_on_hand | metrics | 2 | Quantity | The quantity of product currently available in stock. | On Hand Quantity,Inventory Quantity,Inventory,Stock,qty on hand | |
| sales_order_details | so_c1 | dimensions | id | Custom field 1 associated with the sales order. | Sales Order Custom Field 1,so c1 | ||
| product_tree | product_id | dimensions | id | product id,Product ID | |||
| receipt_details | remittoname | dimensions | id | The name associated with the remittance. | remit to name,receipt details remittoname,Remittance Name | ||
| manufacturing_order_details | qtyfulfilled | metrics | 2 | Quantity | The quantity that has been fulfilled for the purchase order. | manufacturing order details qtyfulfilled,qty fulfilled,Fulfilled Quantity | |
| sales_order_details | issued_date | date | %m-%d-%Y | The date when the sales order was issued or created in the system. | Issued Date,issued date | ||
| vendor | accountid | dimensions | id | A unique identifier for the account related to the invoice. | Account ID,Accountid,vendor accountid | ||
| purchase_order_details | dateissued | date | %m-%d-%Y | The date when the purchase order was issued. | date issued,Issued Date,purchase order details dateissued | ||
| sales_order_details | ship_to_address | dimensions | id | The address where the sales order items are to be shipped. | ship to address,Shipping Address | ||
| purchase_order_details | partid | dimensions | id | Part ID,partid,purchase order details partid | |||
| work_order_details | type_name | dimensions | The name or type of the work order. | type name,type name,Type Name | |||
| location_inventory_details | inventory_cost | metrics | 2 | Currency | $ | inventory cost,inventory cost,Inventory Cost | |
| purchase_order_details | qtypicked | metrics | 2 | Quantity | The quantity that has been picked for the purchase order. | qtypicked,Picked Quantity,Picked Qty,purchase order details qtypicked | |
| customer_group | account_group | dimensions | The name or identifier for a specific group or category of locations associated with customer accounts. | Location Group Name,account group,Location Group | |||
| receipt_details | shiptozip | dimensions | id | The zip code for the shipping or receipt address. | ship to zip,Shipping Zip,receipt details shiptozip,Receipt Zip | ||
| shipment_details | shipment_number | dimensions | The unique identifier assigned to the shipment. | shipment number,shipment number,Shipment Number | |||
| purchase_order_details | part_description | dimensions | id | part Description,part description,Part Description | |||
| sales_order_details | item_margin | metrics | 2 | Currency | $ | The margin or profit associated with a specific item in the sales order. | Item Margin,item margin |
| inventory_details | qtynotavailabletopick | metrics | 2 | Quantity | Unavailable to Pick Quantity,Quantity Not Available to Pick | ||
| sales_order_details | bill_to_name | dimensions | id | The name associated with the billing information. | bill to name,Billing Name | ||
| purchase_order_details | totalcost | metrics | 2 | Currency | $ | The total cost of the purchase order. | Total Cost,purchase order details totalcost,PO Total Cost |
| sales_order_details | terms_discount_days | metrics | 2 | Quantity | The number of days for which a payment discount is available if payment is made within that timeframe. | terms discount days,Payment Terms Discount Days | |
| product_tree | product_created | date | %m-%d-%Y | product created,Product Created Date | |||
| shipment_details | shipped_user | dimensions | shipped user,shipped user,Shipped User | ||||
| receipt_details | receiptid | dimensions | id | The unique identifier for the receipt. | receipt id,Receipt ID,receipt details receiptid | ||
| purchase_order_details | shiptozip | dimensions | id | The zip code to which the order is being shipped. | ship to zip,Shipping Zip,purchase order details shiptozip | ||
| shipment_details | ship_id | dimensions | id | The unique identifier for the shipment. | ship id,ship id | ||
| inventory_details | orderuptolevel | metrics | 2 | Quantity | orderuptolevel,Max Order Level | ||
| sales_order_details | product | dimensions | id | The product or SKU associated with the sales order. | Product Number,Product,Sku | ||
| sales_order_details | soitem_product_number | dimensions | id | SO Item Product Number | |||
| receipt_details | datereceived | date | %m-%d-%Y | date received,receipt details datereceived,Received Date | |||
| receipt_details | part_description | dimensions | id | Description of the part received. | part Description,Part Description,part description | ||
| manufacturing_order_details | bomitemid | dimensions | id | The unique identifier for the BOM item in the manufacturing order. | manufacturing order details bomitemid,bom item id,bomitemid,BOM Item ID | ||
| part | qtyallocatedtosend | metrics | 2 | Quantity | Allocated Quantity to Send,part qtyallocatedtosend | ||
| work_order_details | location_group | dimensions | location group,location group,Location Group,location group name | ||||
| inventory_details | reorderpoint | metrics | 2 | Quantity | Reorder Point,reorderpoint | ||
| location_inventory_details | part_id | dimensions | id | The unique identifier for the part. | Part Number,Raw Material,part id,Part,Item | ||
| shipment_details | ship_id | dimensions | id | ship id,ship id | |||
| receipt_details | reject_status | dimensions | The status of the rejected items. | Reject Status,reject status,reject status | |||
| sales_order_details | so_id | dimensions | id | The unique identifier for the sales order. | Sales Order ID,SO ID | ||
| receipt_details | shiptoaddress | dimensions | Shipping Address,receipt details shiptoaddress,ship to address,Receipt Address | ||||
| manufacturing_order_details | bomid | dimensions | id | The unique identifier for the Bill of Materials (BOM) in the manufacturing order. | Bill of Materials ID,Bill of Materials Number,bom id,bomid,BOM ID,manufacturing order details bomid | ||
| receipt_details | po_num | dimensions | id | PO Number,purchase order Number,po num | |||
| shipment_details | shipment_contact | dimensions | Shipment Contact,shipment contact,shipment contact | ||||
| purchase_order_details | deliverto | dimensions | deliver to,Deliverto,purchase order details deliverto,Deliver To | ||||
| purchase_order_details | datescheduledfulfillment | date | %m-%d-%Y | The date when the order is scheduled to be fulfilled. | Scheduled Fulfillment Date,scheduled fulfillment Date,purchase order details datescheduledfulfillment | ||
| work_order_details | woitem_id | dimensions | id | The unique identifier for the work order item. | woitem id,woitem id,WO Item ID | ||
| purchase_order_details | polineitem | metrics | 2 | Quantity | Purchase Order Line Item,purchase order details polineitem,po line item | ||
| sales_order_details | qb_class_soitem | dimensions | id | The class or category of the sales order item as defined in the system. | qb class soitem,QB Class SO Item | ||
| location_inventory_details | company | dimensions | id | The company associated with the inventory record. | location inventory details company,company | ||
| sales_order_details | product_c3 | dimensions | id | Custom field 3 associated with the product in the sales order. | product c3,Product Custom Field 3 | ||
| location_inventory_details | expiration_date | date | %m-%d-%Y | The date by which the inventory must be used or sold. | Expiration Date,expiration date | ||
| customer_group | customer_name | dimensions | Customer Name,customer name,Customer | ||||
| purchase_order_details | daterevision | date | %m-%d-%Y | The date when the purchase order was revised. | Revision Date,revision date,purchase order details daterevision | ||
| manufacturing_order_details | partid | dimensions | id | manufacturing order details partid,Part ID | |||
| sales_order_details | accountid | dimensions | id | The unique identifier for the account associated with the sales order. | Asset Account ID,account id,Account ID | ||
| purchase_order_details | remitzip | dimensions | Remittance Zip,purchase order details remitzip,remit zip | ||||
| purchase_order_details | poitem_status | dimensions | The status of the item within the purchase order. | Purchase Order Item Status,poitem status,poitem status | |||
| shipment_details | dateshipped | date | %m-%d-%Y | dateshipped,shipment details dateshipped,shipped date,Shipment Date | |||
| manufacturing_order_details | datescheduled | date | %m-%d-%Y | manufacturing order details datescheduled,Scheduled Date | |||
| purchase_order_details | daterevision | date | %m-%d-%Y | Revision Date,revision date,purchase order details daterevision | |||
| receipt_details | buyer | dimensions | Buyer,Buyer Name,receipt details buyer | ||||
| manufacturing_order_details | locationgroupid | dimensions | id | MO Location Group ID,manufacturing order details locationgroupid,location group id,Production Location Group IDmanufacturing order de | |||
| sales_order_details | datescheduledfulfillment | date | %m-%d-%Y | The scheduled date for fulfilling the sales order. | Scheduled Fulfillment Date | ||
| purchase_order_details | locationgroupid | dimensions | id | The unique identifier for the location group. | location group id,purchase order details locationgroupid | ||
| sales_order_details | terms_net_days | metrics | 2 | Quantity | The number of days within which the full payment is due for the sales order. | terms net days,Payment Terms Net Days | |
| inventory_details | company | dimensions | id | The company associated with the inventory record. | Company | ||
| purchase_order_details | po_id | dimensions | id | The unique identifier for the purchase order. | po id,po id,Purchase Order ID,PO ID | ||
| receipt_details | part | dimensions | Part,receipt details part | ||||
| receipt_details | statusid | dimensions | id | Status ID,receipt details statusid | |||
| receipt_details | shiptoaddress | dimensions | id | The address where the goods are shipped to. | Shipping Address,receipt details shiptoaddress,ship to address,Receipt Address | ||
| shipment_details | shipment_number | dimensions | id | shipment number,shipment number,Shipment Number | |||
| purchase_order_details | customer_so | dimensions | id | The sales order number from the customer associated with the PO. | customer so,customer so,Customer Sales Order | ||
| purchase_order_details | shiptoaddress | dimensions | Shipping Address,purchase order details shiptoaddress,ship to address | ||||
| sales_order_details | salesmaninitials | dimensions | id | The initials of the sales representative associated with the sales order. | sales man initials,Sales Rep Initials | ||
| work_order_details | wo_uom_code | dimensions | wo uom code,wo uom code,UOM,uom code,UOM Code | ||||
| receipt_details | receipt_qty_baseuom | metrics | 2 | Quantity | Base UOM Receipt Quantity,Receipt Quantity by Base UOM,receipt qty base uom,receipt qty baseuom,receipt qty baseuom | ||
| purchase_order_details | dateconfirmed | date | %m-%d-%Y | date confirmed,Confirmed Date,purchase order details dateconfirmed | |||
| part | lastcost | metrics | 2 | Currency | $ | Last Cost,lastcost,part lastcost | |
| purchase_order_details | carrier_name | dimensions | carrier name,carrier name,Carrier Name | ||||
| part | stdcost | metrics | 2 | Currency | $ | stdcost,part stdcost,Standard Cost | |
| manufacturing_order_details | soid | dimensions | id | Sales Order ID,manufacturing order details soid,soid | |||
| sales_order_details | last_unitprice | metrics | 4 | Currency | $ | The last recorded unit price for an item in the sales order. | last unitprice,Last Unit Price |
| work_order_details | qtytarget | metrics | 2 | Quantity | qty target,work order details qtytarget,Target Quantity,Target Qty | ||
| inventory_details | qtyallocatedto | metrics | 2 | Quantity | qtyallocatedto,Quantity Allocated To | ||
| purchase_order_details | polineitem | metrics | 2 | Quantity | The line item within the purchase order. | Purchase Order Line Item,purchase order details polineitem,po line item | |
| purchase_order_details | remitstate_name | dimensions | Remit State,remit state name,Remittance State,remitstate name,remitstate name | ||||
| receipt_details | remitzip | dimensions | remit zip,receipt details remitzip,Remittance Zip | ||||
| purchase_order_details | shiptozip | dimensions | ship to zip,Shipping Zip,purchase order details shiptozip | ||||
| sales_order_details | totalprice | metrics | 2 | Currency | $ | The total price of the sales order, including all items and any applicable discounts or surcharges. | Total Price,total price |
| sales_order_details | product_created | date | %m-%d-%Y | The date when the product associated with the sales order was created. | product created,Product Creation Date,Product Created Date | ||
| location_inventory_details | lg | dimensions | location inventory details lg,Location Group | ||||
| manufacturing_order_details | dateissued | date | %m-%d-%Y | The date on which the manufacturing order was issued. | manufacturing order details dateissued,date issued,Issue Date | ||
| inventory_details | qtycommitted | metrics | 2 | Quantity | The quantity of product that has been committed to an order but not yet shipped. | Committed Quantity | |
| shipment_details | dateshipped | date | %m-%d-%Y | The date when the shipment was sent. | dateshipped,shipment details dateshipped,shipped date,Shipment Date | ||
| sales_order_details | soitem_taxrate | metrics | 2 | Quantity | The tax rate applied to the sales order item. | soitem taxrate,SO Item Tax Rate | |
| manufacturing_order_details | bomitemtype_name | dimensions | The type or category of the BOM item in the manufacturing order. | bom item type name,BOM Item Type,bomitemtype name | |||
| location_inventory_details | part | dimensions | The part or item received. | Item,location inventory details part,Raw Material,Part Number,Part | |||
| work_order_details | qtyused | metrics | 2 | Quantity | Used Quantity,Qty Used,work order details qtyused,Used Qty | ||
| purchase_order_details | purchase_order_number | dimensions | id | purchase order Number,PO Number,purchase order number | |||
| inventory_details | lot_number | dimensions | id | A unique number assigned to a lot or batch of products in inventory. | Lot Number | ||
| purchase_order_details | po_uom_name | dimensions | id | The unit of measure name for the purchase order. | PO UOM Name,po uom name | ||
| work_order_details | uom_name | dimensions | uom name,uom name,UOM Name | ||||
| manufacturing_order_details | qtytofulfill | metrics | 2 | Quantity | manufacturing order details qtytofulfill,Quantity to Fulfill,qtytofulfill | ||
| sales_order_details | shipped_quantity | metrics | 2 | Quantity | The quantity of items that have been shipped for the sales order. | shipped quantity,Shipped Quantity | |
| receipt_details | receipt_carrier_name | dimensions | Carrier Name,Carrier,receipt carrier name,carrier name,receipt carrier name | ||||
| receipt_details | customerid | dimensions | id | The ID or name of the customer receiving the goods. | customer id,receipt details customerid | ||
| receipt_details | datefirstship | date | %m-%d-%Y | date first ship,receipt details datefirstship,First Ship Date,First Shipment Date | |||
| purchase_order_details | po_type | dimensions | The type of purchase order. | po type,po type,PO Type | |||
| shipment_details | shipped_user | dimensions | id | The user responsible for processing the shipment. | shipped user,shipped user,Shipped User | ||
| product_tree | last_unit_price | metrics | 2 | Currency | $ | Last Unit Price,last unit price | |
| location_inventory_details | committed_qty | metrics | 2 | Quantity | Committed Quantity,qty committed,committed qty,Committed Qty | ||
| shipment_details | carton_count | metrics | 2 | Quantity | carton count,carton count,Carton Count | ||
| part | allocated_qty | metrics | 2 | Quantity | The quantity of the part that has been allocated for use. | allocated qty,allocated qty,Allocated Quantity | |
| product | product_num | dimensions | id | Product Number,product num | |||
| purchase_order_details | part_uom_code | dimensions | id | The unit of measure code for the part. | part uom code,part uom code,Part UOM Code | ||
| purchase_order_details | uom_conv_qtytofulfill | metrics | 2 | Quantity | uom conv qtytofulfill,uom conv qtytofulfill,uom conv qty to fulfill,UOM Converted Quantity to Fulfill | ||
| receipt_details | num | dimensions | id | Receipt Details Number,receipt details num | |||
| location_inventory_details | committed_qty | metrics | 2 | Quantity | The quantity of inventory committed but not yet shipped. | Committed Quantity,qty committed,committed qty,Committed Qty | |
| sales_order_details | sales_order_number | dimensions | The unique identifier or number associated with the sales order. | Sales Order,sales order Number,SO Number | |||
| receipt_details | note | dimensions | Receipt Note,receipt details note | ||||
| manufacturing_order_details | parentid | dimensions | id | manufacturing order details parentid,parent id,Parent ID | |||
| location_inventory_details | expiration_date | date | %m-%d-%Y | Expiration Date,expiration date | |||
| part | committed_qty | metrics | 2 | Quantity | The quantity of the part that is committed but not yet used. | Committed Quantity,asset account,committed qty,GL Account | |
| sales_order_details | so_type | dimensions | The type or classification of the sales order. | Sales Order Type,so type,SO Type | |||
| sales_order_details | unitprice | metrics | 2 | Currency | $ | The price per unit of an item in the sales order. | unit price,Unit Price |
| sales_order_details | customercontact | dimensions | id | Contact person or entity for the customer related to the sales order. | Customer Contact,customer contact | ||
| purchase_order_details | shiptoname | dimensions | id | The name of the recipient for the shipment. | ship to name,Shipping Name,purchase order details shiptoname | ||
| receipt_details | datecompleted | date | %m-%d-%Y | date completed,Completed Date,receipt details datecompleted | |||
| purchase_order_details | deliverto | dimensions | id | The location where the order should be delivered. | deliver to,Deliverto,purchase order details deliverto,Deliver To | ||
| shipment_details | so_id | dimensions | id | Sales Order ID,so id,SO ID | |||
| sales_order_details | account_type | dimensions | Type of account associated with the sales order. | Account Type,account type | |||
| product_tree | product_id | dimensions | id | The ID of the product associated with the sales order. | product id,Product ID | ||
| purchase_order_details | po_status | dimensions | The status of the purchase order. | po status,po status,PO Status | |||
| work_order_details | standardcost | metrics | 2 | Currency | $ | The standard cost associated with the work order. | WO Standard Cost,work order details standardcost,standard cost |
| sales_order_details | customer_c4 | dimensions | id | Custom field 4 associated with the customer in the sales order. | customer c4,Customer Custom Field 4 | ||
| purchase_order_details | po_uom_code | dimensions | id | The unit of measure code for the purchase order. | po uom code,po uom code | ||
| vendor | accountinghash | dimensions | accountinghash,vendor accountinghash | ||||
| vendor | id | dimensions | id | Vendorid,vendor id | |||
| purchase_order_details | customer_so | dimensions | customer so,customer so,Customer Sales Order | ||||
| product_tree | active_flag | flag | Indicates whether the part is active or inactive. | active flag,active flag | |||
| receipt_details | remitstate_name | dimensions | remit state name,Remittance State,remitstate name,remitstate name | ||||
| product_tree | sellableinotheruoms | flag | sellable in other uoms,product tree sellableinotheruoms | ||||
| receipt_details | remitzip | dimensions | id | The zip code for the remittance address. | remit zip,receipt details remitzip,Remittance Zip | ||
| receipt_details | reject_responsible | dimensions | reject responsible,reject responsible,Reject Responsible Party | ||||
| location_inventory_details | lot_number | dimensions | id | Lot Number,lot number,lot number | |||
| receipt_details | receipt_reject_reason | dimensions | id | The reason for rejecting the received items, if applicable. | Reject Reason,reject reason,receipt reject reason,receipt reject reason | ||
| sales_order_details | part_description | dimensions | id | The description of the part associated with the sales order. | Part Description,part Description | ||
| sales_order_details | datecreated | date | %m-%d-%Y | The date when the sales order was created. | Created Date,date created | ||
| receipt_details | customerso | dimensions | customer so,Customer SO,Customer Sales Order,receipt details customerso | ||||
| inventory_details | uomcode | dimensions | id | The unit of measure code associated with the product in inventory. | UOM,UOM code | ||
| product_tree | part_id | dimensions | id | part id,Part ID | |||
| receipt_details | datefirstship | date | %m-%d-%Y | The date when the first shipment was made for the associated order. | date first ship,receipt details datefirstship,First Ship Date,First Shipment Date | ||
| part | part_description | dimensions | The description of the part. | Part Description,part description | |||
| product | partid | dimensions | id | Part ID,product partid | |||
| sales_order_details | product_description | dimensions | id | The description of the product associated with the sales order. | product desc,Product Description,product description | ||
| purchase_order_details | remitaddress | dimensions | id | The address to which payment should be remitted. | Remittance Address,purchase order details remitaddress,remit address | ||
| purchase_order_details | po_id | dimensions | id | po id,po id,Purchase Order ID,PO ID | |||
| purchase_order_details | uom_conv_qtyfulfilled | metrics | 2 | Quantity | Quantity fulfilled multiplied by unit of measure conversion | uom conv qty fulfilled,UOM Converted Quantity Fulfilled,uom conv qtyfulfilled,uom conv qtyfulfilled | |
| purchase_order_details | locationgroupid | dimensions | id | location group id,purchase order details locationgroupid | |||
| product_tree | class_name | dimensions | class name,Class Name | ||||
| location_inventory_details | inventory_cost | metrics | 2 | Currency | $ | The value associated with the inventory item. | inventory cost,inventory cost,Inventory Cost |
| part | qtyallocatedtosend | metrics | 2 | Quantity | The quantity of the part allocated to be sent to sales orders. | Allocated Quantity to Send,part qtyallocatedtosend | |
| sales_order_details | so_c6 | dimensions | id | Custom field 6 associated with the sales order. | Sales Order Custom Field 6,so c6 | ||
| manufacturing_order_details | parentid | dimensions | id | The unique identifier for the parent record associated with the manufacturing order. | manufacturing order details parentid,parent id,Parent ID | ||
| receipt_details | dateissued | date | %m-%d-%Y | The date when the receipt was issued. | Issued Date,receipt details dateissued,date issued | ||
| part | part_description | dimensions | id | Part Description,part description | |||
| work_order_details | part_description | dimensions | part Description,part description,Part Description | ||||
| sales_order_details | customer_c2 | dimensions | id | Custom field 2 associated with the customer in the sales order. | Customer Custom Field 2,customer c2 | ||
| product_tree | accountingid | dimensions | id | The unique identifier for the accounting details associated with the product. | product tree accountingid,accountingid | ||
| location_inventory_details | inventory_qty | metrics | 2 | Quantity | inventory qty,inventory qty,Inventory Quantity | ||
| manufacturing_order_details | moitem_status | dimensions | moitem status,Manufacturing Order Item Status | ||||
| receipt_details | reject_status | dimensions | Reject Status,reject status,reject status | ||||
| work_order_details | datescheduled | date | %m-%d-%Y | date scheduled,Scheduled Date,work order details datescheduled | |||
| inventory_details | qtyallocatedpo | metrics | 2 | Quantity | qtyallocatedpo,Allocated Quantity to PO,Quantity Allocated to PO | ||
| receipt_details | remitcity | dimensions | remit city,receipt details remitcity,Remittance City | ||||
| sales_order_details | product_c5 | dimensions | id | Custom field 5 associated with the product in the sales order. | Product Custom Field 5,product c5 | ||
| purchase_order_details | datecompleted | date | %m-%d-%Y | The date when the purchase order was completed. | date completed,purchase order details datecompleted,Completed Date | ||
| purchase_order_details | po_note | dimensions | Note,po note | ||||
| purchase_order_details | qtytofulfill | metrics | 2 | Quantity | The quantity that remains to be fulfilled for the purchase order. | qty to fulfill,purchase order details qtytofulfill,Quantity to Fulfill | |
| purchase_order_details | part_uom_name | dimensions | id | The unit of measure name for the part. | Part UOM Name,part uom name,part uom name | ||
| receipt_details | receipt_qty | metrics | 2 | Quantity | The quantity of items received in the receipt. | Receipt Quantity,receipt qty,receipt qty | |
| sales_order_details | soitem_taxid | dimensions | id | The unique identifier for the tax associated with the sales order item. | SO Tax ID,soitem taxid | ||
| receipt_details | reference_number | dimensions | id | Reference Number,reference Number,reference number | |||
| sales_order_details | uom_code | dimensions | id | The code representing the unit of measure used for items in the sales order. | UOM,UOM Code,uom code | ||
| product_tree | category_level5 | dimensions | id | The level 5 category under which the product is classified. | category level5,category level5 | ||
| receipt_details | remitstate_name | dimensions | id | The state to which remittance should be sent. | remit state name,Remittance State,remitstate name,remitstate name | ||
| receipt_details | shipstate_name | dimensions | id | The state where the goods are shipped to or received from. | Receipt State,shipstate name,Shipping State,Ship State,shipstate name,ship state name | ||
| inventory_details | qtyonorderso | metrics | 2 | Quantity | Quantity On Order to SO,On Order Quantity to SO | ||
| sales_order_details | fulfilled_revenue | metrics | 2 | currency | $ | The revenue realized upon fulfillment of the sales order. | Fulfilled Revenue,fulfilled revenue |
| sales_order_details | parent_customer_name | dimensions | id | The name of the parent customer associated with the sales order. | Parent Customer Name,parent customer name | ||
| work_order_details | moitemid | dimensions | id | mo item id,Manufacturing Order ID,work order details moitemid,MO ID | |||
| manufacturing_order_details | totalcost | metrics | 2 | Currency | $ | The total cost associated with the manufacturing order. | manufacturing order details totalcost,Total Cost |
| shipment_details | carrier_name | dimensions | id | The name of the carrier responsible for delivering the goods. | carrier name,carrier name,Carrier Name | ||
| receipt_details | remitaddress | dimensions | id | The address to which remittance should be sent. | Remittance Address,remit address,receipt details remitaddress | ||
| receipt_details | receiptitem_id | dimensions | id | The unique identifier for the item within the receipt. | Receipt Item ID,receiptitem id,receiptitem id | ||
| purchase_order_details | uom_conv_qtytofulfill | metrics | 2 | Quantity | Quantity to fulfill multiplied by unit of measure conversion | uom conv qtytofulfill,uom conv qtytofulfill,uom conv qty to fulfill,UOM Converted Quantity to Fulfill | |
| receipt_details | reject_responsible | dimensions | id | The party responsible for rejecting the received items. | reject responsible,reject responsible,Reject Responsible Party | ||
| product_tree | sellableinotheruoms | flag | Indicates whether the product can be sold in other units of measure. | sellable in other uoms,product tree sellableinotheruoms | |||
| manufacturing_order_details | uom_name | dimensions | Unit of Measure,UOM,uom name | ||||
| location_inventory_details | company | dimensions | location inventory details company,company | ||||
| receipt_details | shiptocity | dimensions | id | The city where the goods are shipped to. | Shipping City,Receipt City,receipt details shiptocity,ship to city | ||
| shipment_details | so_id | dimensions | id | The unique identifier for the sales order. | Sales Order ID,so id,SO ID | ||
| product_tree | product_created | date | %m-%d-%Y | The date and time when the product was created in the system. | product created,Product Created Date | ||
| inventory_details | qtyonordermo | metrics | 2 | Quantity | On Order Quantity Month,qtyonordermo,Quantity On Order Month | ||
| sales_order_details | datefulfillment | date | %m-%d-%Y | The date when the sales order was fully fulfilled. | date fulfillment,Fulfilment Date | ||
| manufacturing_order_details | datescheduled | date | %m-%d-%Y | The date on which the manufacturing order is scheduled. | manufacturing order details datescheduled,Scheduled Date | ||
| shipment_details | bill_of_lading | dimensions | bill of lading,bill of lading,BOL,Bill of Lading | ||||
| purchase_order_details | vendorid | dimensions | id | Vendor ID,purchase order details vendorid | |||
| inventory_details | allocated | metrics | 2 | Quantity | The quantity of product that has been allocated for specific use or purpose. | Allocated Quantity | |
| receipt_details | num | dimensions | The unique identifier for the receipt document. | Receipt Details Number,receipt details num | |||
| part | part_id | dimensions | id | Part ID,part id | |||
| manufacturing_order_details | datescheduledtostart | date | %m-%d-%Y | manufacturing order details datescheduledtostart,scheduled to start date,Scheduled State Date | |||
| manufacturing_order_details | mo_id | dimensions | id | mo id,Manufacturing Order ID | |||
| purchase_order_details | datefirstship | date | %m-%d-%Y | date first ship,First Ship Date,purchase order details datefirstship | |||
| purchase_order_details | qtyfulfilled | metrics | 2 | Quantity | fulfilled Qty,qty fulfilled,purchase order details qtyfulfilled,Fulfilled Quantity | ||
| sales_order_details | qtyordered | metrics | 2 | Quantity | The quantity that has been ordered in the sales order. | qty ordered,Ordered Quantity,Ordered Qty | |
| receipt_details | po_type | dimensions | po type,po type,PO Type | ||||
| purchase_order_details | shiptocity | dimensions | id | The city to which the order is being shipped. | ship to city,purchase order details shiptocity,Shipping City | ||
| sales_order_details | so_status | dimensions | The current status of the sales order. | Sales Order Status,so status,SO Status | |||
| sales_order_details | location_group_name | dimensions | The name or identifier for the location group associated with the sales order. | Location Group,location group,location group name | |||
| purchase_order_details | datecompleted | date | %m-%d-%Y | date completed,purchase order details datecompleted,Completed Date | |||
| part | vendorid | dimensions | id | vendorid,part vendorid,Vendor ID | |||
| manufacturing_order_details | part_description | dimensions | id | A description of the part or item in inventory. | part description,Part Description | ||
| sales_order_details | so_item_id | dimensions | id | The unique identifier for an item in the sales order. | SO Item ID,so item id | ||
| location_inventory_details | part_id | dimensions | id | Part Number,Raw Material,part id,Part,Item | |||
| sales_order_details | soitem_type | dimensions | The type or classification of the sales order item. | SO Item Type,soitem type | |||
| purchase_order_details | vendorid | dimensions | id | The unique identifier for the vendor. | Vendor ID,purchase order details vendorid | ||
| receipt_details | vendorid | dimensions | id | The unique identifier for the vendor. | Vendor ID,receipt details vendorid,vendor id | ||
| inventory_details | lastdate | date | %m-%d-%Y | Last Date,lastdate | |||
| work_order_details | sortid | dimensions | id | sort id,work order details sortid | |||
| sales_order_details | payment_terms | dimensions | id | The payment terms associated with the sales order. | payment terms,Payment Terms | ||
| shipment_details | carton_count | metrics | 2 | Quantity | The total number of cartons included in the shipment. | carton count,carton count,Carton Count | |
| work_order_details | datescheduledtostart | date | %m-%d-%Y | scheduled to start date,work order details datescheduledtostart,Scheduled to Start Date | |||
| inventory_details | partid | dimensions | id | The unique identifier assigned to a specific part or item. | Part ID | ||
| manufacturing_order_details | revision | metrics | 2 | Quantity | The revision number associated with the manufacturing order. | MO Revision,revision,Manufacturing Order Revision,manufacturing order details revision | |
| purchase_order_details | part_description | dimensions | id | A description of the part or item associated with the PO. | part Description,part description,Part Description | ||
| manufacturing_order_details | bomitemid | dimensions | id | manufacturing order details bomitemid,bom item id,bomitemid,BOM Item ID | |||
| shipment_details | statusid | dimensions | id | Status ID,shipment details statusid | |||
| sales_order_details | customer_c1 | dimensions | id | Custom field 1 associated with the customer in the sales order. | Customer Custom Field 1,customer c1 | ||
| purchase_order_details | po_type | dimensions | po type,po type,PO Type | ||||
| receipt_details | dateconfirmed | date | %m-%d-%Y | The date when the receipt was confirmed. | Confirmed Date,receipt details dateconfirmed | ||
| purchase_order_details | datelastmodified | date | %m-%d-%Y | date last modified,purchase order details datelastmodified,last modified date,Last Modified Date | |||
| work_order_details | location_group | dimensions | The group or category of locations associated with the work order. | location group,location group,Location Group,location group name | |||
| receipt_details | receipt_reject_reason | dimensions | Reject Reason,reject reason,receipt reject reason,receipt reject reason | ||||
| product | product_short_num | dimensions | id | A shorter version of the product number. | Product Short Number,product short num | ||
| sales_order_details | negative_margin_flag | flag | A flag indicating whether the margin on the sales order item is negative. | Negative Margin Flag,negative margin flag | |||
| manufacturing_order_details | datecreated | date | %m-%d-%Y | The date on which the work order was created. | Creation Date,Created Date,manufacturing order details datecreated,date created | ||
| sales_order_details | ship_to_city | dimensions | id | The city where the sales order items are to be shipped. | ship to city,Shipping City | ||
| customer_group | account_group | dimensions | Location Group Name,account group,Location Group | ||||
| vendor | name | dimensions | Vendor Name,vendor name | ||||
| product_tree | product_description | dimensions | id | product description,Part Description | |||
| vendor | name | dimensions | The name of the vendor. | Vendor Name,vendor name | |||
| work_order_details | locationid | dimensions | id | The unique identifier for the location associated with the work order. | location group id,Location ID,work order details locationid | ||
| purchase_order_details | po_note | dimensions | id | Notes associated with the purchase order. | Note,po note | ||
| sales_order_details | customer | dimensions | id | The name of the customer who placed the sales order. | customer,Customer Name,Customer | ||
| product_tree | category_name | dimensions | Category Name,category name | ||||
| shipment_details | carrier_name | dimensions | carrier name,carrier name,Carrier Name | ||||
| manufacturing_order_details | description | dimensions | id | description,manufacturing order details description,Manufacturing Order Description,MO Description | |||
| work_order_details | description | dimensions | id | A brief description of the work order. | Work Order Description,WO description,work order details description | ||
| work_order_details | cost | metrics | 2 | Currency | $ | cost,Work Order Cost,work order details cost,WO Cost | |
| purchase_order_details | remitzip | dimensions | id | The zip code to which payment should be remitted. | Remittance Zip,purchase order details remitzip,remit zip | ||
| part | active_flag | flag | Active Flag,active flag,active flag | ||||
| purchase_order_details | vendor_name | dimensions | Vendor,vendor name,vendor name | ||||
| manufacturing_order_details | part_description | dimensions | part description,Part Description | ||||
| product_tree | accountingid | dimensions | id | product tree accountingid,accountingid | |||
| purchase_order_details | remitstate_name | dimensions | id | The state to which payment should be remitted. | Remit State,remit state name,Remittance State,remitstate name,remitstate name | ||
| shipment_details | bill_of_lading | dimensions | id | The document issued by a carrier to acknowledge receipt of cargo for shipment. | bill of lading,bill of lading,BOL,Bill of Lading | ||
| receipt_details | daterevision | date | %m-%d-%Y | The date when the receipt details were revised. | Revision Date,revision date,receipt details daterevision | ||
| sales_order_details | customer_c5 | dimensions | id | Custom field 5 associated with the customer in the sales order. | customer c5,Customer Custom Field 5 | ||
| location_inventory_details | lot_number | dimensions | The number associated with a specific batch or lot of inventory. | Lot Number,lot number,lot number | |||
| receipt_details | shiptoname | dimensions | Receipt by Name,receipt details shiptoname,Shipping Name,ship to name | ||||
| purchase_order_details | datelastfulfillment | date | %m-%d-%Y | last fulfillment date,purchase order details datelastfulfillment,date last fulfillment,Last Fulfillment Date | |||
| purchase_order_details | po_uom_code | dimensions | po uom code,po uom code | ||||
| product_tree | product_short_number | dimensions | id | Product Short Number,product short number | |||
| work_order_details | datescheduled | date | %m-%d-%Y | The date scheduled for the work order to begin or be completed. | date scheduled,Scheduled Date,work order details datescheduled | ||
| manufacturing_order_details | locationgroupid | dimensions | id | The ID of the group of locations associated with the receipt. | MO Location Group ID,manufacturing order details locationgroupid,location group id,Production Location Group IDmanufacturing order de | ||
| manufacturing_order_details | mo_status | dimensions | The current status of the manufacturing order. | mo status,Manufacturing Order Status | |||
| receipt_details | carrierid | dimensions | id | The ID or name of the carrier responsible for delivering the goods. | Carrier ID,receipt details carrierid | ||
| purchase_order_details | qtyfulfilled | metrics | 2 | Quantity | The quantity that has been fulfilled for the purchase order. | fulfilled Qty,qty fulfilled,purchase order details qtyfulfilled,Fulfilled Quantity | |
| location_inventory_details | uom | dimensions | Unit of Measure,location inventory details uom,UOM | ||||
| manufacturing_order_details | part_num | dimensions | The number associated with the part or raw material in the manufacturing order. | Part Number,part num,part Number,Part,Item,Raw Material | |||
| purchase_order_details | buyer | dimensions | Buyer,Buyer Name,purchase order details buyer | ||||
| purchase_order_details | qtypicked | metrics | 2 | Quantity | qtypicked,Picked Quantity,Picked Qty,purchase order details qtypicked | ||
| receipt_details | remittoname | dimensions | remit to name,receipt details remittoname,Remittance Name | ||||
| work_order_details | priority_name | dimensions | id | The name or label indicating the priority level of the work order. | Priority Name,priority name,priority name | ||
| purchase_order_details | buyer | dimensions | id | The person or entity responsible for making the purchase order. | Buyer,Buyer Name,purchase order details buyer | ||
| receipt_details | carrierid | dimensions | id | Carrier ID,receipt details carrierid | |||
| vendor | accountid | dimensions | id | Account ID,Accountid,vendor accountid | |||
| manufacturing_order_details | location_group | dimensions | location group name,location group,Location Group,location group,production location group | ||||
| manufacturing_order_details | part_num | dimensions | id | Part Number,part num,part Number,Part,Item,Raw Material | |||
| purchase_order_details | location_group_name | dimensions | The name of the location group associated with the PO. | location group,Location Group Name,location group name | |||
| receipt_details | po_id | dimensions | id | PO ID,po id | |||
| inventory_details | reorderpoint | metrics | 2 | Quantity | Reorder Point,reorderpoint | ||
| sales_order_details | product_c2 | dimensions | id | Custom field 2 associated with the product in the sales order. | Product Custom Field 2,product c2 | ||
| receipt_details | datelastmodified | date | %m-%d-%Y | The date when the receipt details were last modified. | date last modified,Last Modified Date,receipt details datelastmodified,last modified date | ||
| product_tree | active_flag | flag | active flag,active flag | ||||
| part | lastcost | metrics | 2 | Currency | $ | The last recorded cost of the part. | Last Cost,lastcost,part lastcost |
| sales_order_details | part | dimensions | The part, raw material, or item associated with the sales order. | Part,Raw Material,Item,Part Number | |||
| purchase_order_details | uom_conv_qtyfulfilled | metrics | 2 | Quantity | uom conv qty fulfilled,UOM Converted Quantity Fulfilled,uom conv qtyfulfilled,uom conv qtyfulfilled | ||
| product_tree | category_level3 | dimensions | category level3,category level3 | ||||
| product | partid | dimensions | id | The unique identifier assigned to a specific part or item. | Part ID,product partid | ||
| receipt_details | receiptid | dimensions | id | receipt id,Receipt ID,receipt details receiptid | |||
| shipment_details | ship_status | dimensions | ship status,ship status,Shipment Status | ||||
| receipt_details | vendor_name | dimensions | vendor name,vendor name,Vendor | ||||
| shipment_details | statusid | dimensions | id | The unique identifier for the current status of the shipment. | Status ID,shipment details statusid | ||
| purchase_order_details | poitem_type | dimensions | The type of item within the purchase order. | Purchase Order Item Type,poitem type,poitem type | |||
| product_tree | category_level4 | dimensions | id | The level 4 category under which the product is classified. | category level4,category level4 | ||
| part | qtyallocatedso | metrics | 2 | Quantity | The quantity of the part allocated to sales orders. | qtyallocatedso,Quanitity Allocated to Sales Order,part qtyallocatedso | |
| work_order_details | standardcost | metrics | 2 | Currency | $ | WO Standard Cost,work order details standardcost,standard cost | |
| purchase_order_details | vendor_part | dimensions | Vendor Part,vendor part | ||||
| product_tree | last_unit_price | metrics | 4 | Currency | $ | The last recorded price per unit for the product. | Last Unit Price,last unit price |
| location_inventory_details | inventory_qty | metrics | 2 | Quantity | The total quantity of inventory available at the location. | inventory qty,inventory qty,Inventory Quantity | |
| location_inventory_details | uom | dimensions | id | The unit of measure used for the inventory items. | Unit of Measure,location inventory details uom,UOM | ||
| receipt_details | customerid | dimensions | id | customer id,receipt details customerid | |||
| manufacturing_order_details | datescheduledtostart | date | %m-%d-%Y | The date on which the manufacturing order is scheduled to start. | manufacturing order details datescheduledtostart,scheduled to start date,Scheduled State Date | ||
| purchase_order_details | dateconfirmed | date | %m-%d-%Y | The date when the purchase order was confirmed. | date confirmed,Confirmed Date,purchase order details dateconfirmed | ||
| purchase_order_details | customerid | dimensions | id | The unique identifier for the customer. | customer id,Customer ID,purchase order details customerid | ||
| purchase_order_details | part | dimensions | Part Number,Part,Item,purchase order details part,Raw Material | ||||
| sales_order_details | soitem_status | dimensions | The current status of the item in the sales order. | Sales Order Item Status,SO Item Status,soitem status | |||
| purchase_order_details | datelastfulfillment | date | %m-%d-%Y | The date when the last fulfillment occurred for the PO. | last fulfillment date,purchase order details datelastfulfillment,date last fulfillment,Last Fulfillment Date | ||
| receipt_details | receiptitem_id | dimensions | id | Receipt Item ID,receiptitem id,receiptitem id | |||
| product_tree | product_number | dimensions | id | Product Number,product number | |||
| inventory_details | expiration_date | dimensions | id | The date by which the inventory must be used or sold. | Expiration Date,expiration date | ||
| work_order_details | type_name | dimensions | type name,type name,Type Name | ||||
| purchase_order_details | vendor_contact | dimensions | id | The contact information for the vendor associated with the purchase order. | vendor contact,vendor contact,Vendor Contact | ||
| shipment_details | sales_order_number | dimensions | The unique identifier for the sales order associated with the shipment. | SO Number,sales order number | |||
| part | qtyonhand | metrics | 2 | Quantity | qtyonhand,part qtyonhand,On Hand Quantity | ||
| shipment_details | ship_status | dimensions | The current status of the shipment. | ship status,ship status,Shipment Status | |||
| location_inventory_details | location | dimensions | location inventory details location,location name,Location Name | ||||
| receipt_details | po_id | dimensions | id | The unique identifier for the purchase order. | PO ID,po id | ||
| purchase_order_details | shiptoname | dimensions | ship to name,Shipping Name,purchase order details shiptoname | ||||
| work_order_details | locationgroupid | dimensions | id | Locaton Group Name,work order details locationgroupid,location group id | |||
| purchase_order_details | remitaddress | dimensions | Remittance Address,purchase order details remitaddress,remit address | ||||
| purchase_order_details | datecreated | date | %m-%d-%Y | date created,Created Date,purchase order details datecreated | |||
| customer_group | account_id | dimensions | id | The unique identifier assigned to a specific customer account. | account id,account id,Account ID | ||
| receipt_details | partid | dimensions | id | Part ID,partid,receipt details partid | |||
| purchase_order_details | customerid | dimensions | id | customer id,Customer ID,purchase order details customerid | |||
| work_order_details | wo_id | dimensions | id | The unique identifier for the work order. | wo id,wo id,WO ID | ||
| purchase_order_details | shiptoaddress | dimensions | id | The address to which the order is being shipped. | Shipping Address,purchase order details shiptoaddress,ship to address | ||
| purchase_order_details | location_group_name | dimensions | location group,Location Group Name,location group name | ||||
| manufacturing_order_details | revision | metrics | 2 | Quantity | MO Revision,revision,Manufacturing Order Revision,manufacturing order details revision | ||
| sales_order_details | product_c4 | dimensions | id | Custom field 4 associated with the product in the sales order. | Product Custom Field 4,product c4 | ||
| receipt_details | dateconfirmed | date | %m-%d-%Y | Confirmed Date,receipt details dateconfirmed | |||
| sales_order_details | ship_to_country | dimensions | id | The country where the sales order items are to be shipped. | ship to country,Shipping Country | ||
| receipt_details | vendorcontact | dimensions | id | The contact details of the vendor. | Vendor Contact,receipt details vendorcontact,vendor contact | ||
| purchase_order_details | remitcity | dimensions | id | The city to which payment should be remitted. | remit city,purchase order details remitcity,Remittance City | ||
| product | accountingid | dimensions | id | The unique identifier for the accounting details associated with the product. | accountingid,Accounting ID,product accountingid | ||
| sales_order_details | customer_c3 | dimensions | id | Custom field 3 associated with the customer in the sales order. | Customer Custom Field 3,customer c3 | ||
| receipt_details | note | dimensions | id | Additional notes or comments related to the receipt. | Receipt Note,receipt details note | ||
| work_order_details | wostatus_name | dimensions | wo status name,wostatus name,WO Status,WO Status Name,wostatus name | ||||
| purchase_order_details | qtytofulfill | metrics | 2 | Quantity | qty to fulfill,purchase order details qtytofulfill,Quantity to Fulfill | ||
| receipt_details | po_type | dimensions | The type of purchase order (e.g., Standard, Blanket, Contract). | po type,po type,PO Type | |||
| sales_order_details | product_short_number | dimensions | The short product number associated with the sales order. | Product Short Number | |||
| work_order_details | part_num | dimensions | id | part Number,Raw Material,Item,Part Number,Part,part num | |||
| part | committed_qty | metrics | 2 | Quantity | Committed Quantity,asset account,committed qty,GL Account | ||
| inventory_details | qtynotavailable | metrics | 2 | Quantity | Unavailable Quantity,Quantity Not Available | ||
| inventory_details | qtyallocatedso | metrics | 2 | Quantity | qtyallocatedso,Allocated Quantity to SO,Quantity Allocated to SO | ||
| receipt_details | remitcity | dimensions | id | The city to which remittance should be sent. | remit city,receipt details remitcity,Remittance City | ||
| purchase_order_details | poitem_type | dimensions | Purchase Order Item Type,poitem type,poitem type | ||||
| receipt_details | billedtotalcost | metrics | 2 | Currency | $ | Billed Total Cost,receipt details billedtotalcost,Billed Amount,billed total cost | |
| part | stdcost | dimensions | 0 | currency | $ | The standard cost associated with the part. | stdcost,part stdcost,Standard Cost |
| receipt_details | remitaddress | dimensions | Remittance Address,remit address,receipt details remitaddress | ||||
| work_order_details | location_name | dimensions | id | The name of the location where the work order is to be executed. | location name,location name,Location | ||
| work_order_details | cost | metrics | 2 | Currency | $ | The total cost associated with the work order, including all related expenses. | cost,Work Order Cost,work order details cost,WO Cost |
| work_order_details | datefinished | date | %m-%d-%Y | The date on which the work order was completed. | date finished,work order details datefinished,Finished Date | ||
| sales_order_details | ship_to_zip | dimensions | id | The zip code where the sales order items are to be shipped. | Shipping Zip,ship to zip | ||
| shipment_details | sales_order_number | dimensions | id | SO Number,sales order number | |||
| manufacturing_order_details | totalcost | metrics | 2 | Currency | $ | manufacturing order details totalcost,Total Cost | |
| inventory_details | part_description | dimensions | id | A description of the part or item in inventory. | Description,Part Description | ||
| receipt_details | customerso | dimensions | id | The sales order number associated with the received goods. | customer so,Customer SO,Customer Sales Order,receipt details customerso | ||
| customer_group | account_type | dimensions | The type or category of the customer account. | Account Type,account type,account type | |||
| inventory_details | qtyonorderto | metrics | 2 | Quantity | qtyonorderto | ||
| purchase_order_details | carrierid | dimensions | id | Carrier ID,carrier id,purchase order details carrierid | |||
| work_order_details | part_description | dimensions | id | A brief description of the part used in the work order. | part Description,part description,Part Description | ||
| receipt_details | datecompleted | date | %m-%d-%Y | The date when the receipt process was completed. | date completed,Completed Date,receipt details datecompleted | ||
| work_order_details | partid | dimensions | id | partid,work order details partid,Part ID | |||
| work_order_details | locationgroupid | dimensions | id | The unique identifier for the location group associated with the work order. | Locaton Group Name,work order details locationgroupid,location group id | ||
| work_order_details | description | dimensions | Work Order Description,WO description,work order details description | ||||
| vendor | accountinghash | dimensions | accountinghash,vendor accountinghash | ||||
| manufacturing_order_details | mo_id | dimensions | id | The unique identifier for the manufacturing order. | mo id,Manufacturing Order ID | ||
| purchase_order_details | shipstate | dimensions | ship state,purchase order details shipstate,Shipping State | ||||
| inventory_details | qtyonorderpo | metrics | 2 | Quantity | Quantity On Order PO,On Order PO Quantity,qtyonorderpo | ||
| shipment_details | shipment_contact | dimensions | id | The contact person or department responsible for the shipment. | Shipment Contact,shipment contact,shipment contact | ||
| part | qtyallocatedso | metrics | 2 | Quantity | qtyallocatedso,Quanitity Allocated to Sales Order,part qtyallocatedso | ||
| purchase_order_details | purchase_order_number | dimensions | The purchase order number. | purchase order Number,PO Number,purchase order number | |||
| receipt_details | dateissued | date | %m-%d-%Y | Issued Date,receipt details dateissued,date issued | |||
| receipt_details | landedtotalcost | metrics | 2 | Currency | $ | Landed Cost,Spend,landed total cost,receipt details landedtotalcost | |
| part | part_num | dimensions | id | Raw Material,part num,Item,Part Number,Part | |||
| sales_order_details | so_taxrateid | dimensions | id | The unique identifier for the tax rate applied to the sales order. | so taxrateid,Tax Rate ID | ||
| sales_order_details | totalcost | metrics | 2 | Currency | $ | The total cost associated with the sales order, including all items, taxes, and other charges. | total cost,Total Cost |
| inventory_details | inventory_cost | metrics | 2 | Currency | $ | The value associated with the inventory item. | Stock Value,stock value |
| product_tree | part_id | dimensions | id | The unique identifier for the part. | part id,Part ID | ||
| sales_order_details | priorityid | dimensions | id | The priority ID assigned to the sales order. | priority id,Priority ID | ||
| work_order_details | datescheduledtostart | date | %m-%d-%Y | The date scheduled for the work order to start. | scheduled to start date,work order details datescheduledtostart,Scheduled to Start Date | ||
| product | product_description | dimensions | id | Product Description,product description | |||
| sales_order_details | so_c5 | dimensions | id | Custom field 5 associated with the sales order. | Sales Order Custom Field 5,so c5 | ||
| purchase_order_details | datelastmodified | date | %m-%d-%Y | The date when the PO was last modified. | date last modified,purchase order details datelastmodified,last modified date,Last Modified Date | ||
| purchase_order_details | poitem_desc | dimensions | id | A description of the item within the purchase order. | poitem desc,poitem desc,PO Item Description,Purchase Order Item Description | ||
| sales_order_details | product_id | dimensions | id | The ID of the product associated with the sales order. | product id,Product ID | ||
| work_order_details | datestarted | date | %m-%d-%Y | The date on which the work order was started. | Started Date,work order details datestarted,started date | ||
| receipt_details | shiptozip | dimensions | ship to zip,Shipping Zip,receipt details shiptozip,Receipt Zip | ||||
| part | moq | metrics | 2 | Quantity | The minimum quantity of the part that must be ordered. | MOQ,part moq,Minimum Order Quantity | |
| purchase_order_details | shiptocity | dimensions | ship to city,purchase order details shiptocity,Shipping City | ||||
| work_order_details | moitemid | dimensions | id | The unique identifier for the manufacturing order item associated with the work order. | mo item id,Manufacturing Order ID,work order details moitemid,MO ID | ||
| receipt_details | reference_number | dimensions | A reference number associated with the receipt or transaction. | Reference Number,reference Number,reference number | |||
| receipt_details | receipt_locationgroup_name | dimensions | The name of the location group associated with the receipt. | location group,Location Group Name,location group name,receipt locationgroup name,receipt locationgroup name | |||
| sales_order_details | parent_customer_id | dimensions | id | The ID of the parent customer associated with the sales order. | Parent Customer ID,Parent Customer,parent customer id | ||
| work_order_details | locationid | dimensions | id | location group id,Location ID,work order details locationid | |||
| purchase_order_details | part_uom_name | dimensions | Part UOM Name,part uom name,part uom name | ||||
| receipt_details | datecreated | date | %m-%d-%Y | date created,Created Date,receipt details datecreated | |||
| receipt_details | locationgroupid | dimensions | id | Location Group ID,receipt details locationgroupid,location group id | |||
| receipt_details | deliverto | dimensions | deliver to,receipt details deliverto,Deliver to | ||||
| sales_order_details | customerpo | dimensions | id | The purchase order number provided by the customer for the sales order. | customer po,Customer PO | ||
| manufacturing_order_details | mo_status | dimensions | mo status,Manufacturing Order Status | ||||
| sales_order_details | qb_class_so | dimensions | id | The class or category of the sales order as defined in the system. | Sales Order QB Class,qb class so | ||
| part | qtyonhand | metrics | 2 | Quantity | The quantity of the part that is currently on hand. | qtyonhand,part qtyonhand,On Hand Quantity | |
| manufacturing_order_details | mo_num | dimensions | id | Manufacturing Order ID,MO ID,mo id,Manufacturing Order Number,mo num | |||
| sales_order_details | default_salesman | dimensions | id | The default salesperson or sales representative assigned to the sales order. | Default Sales Rep,Sales Rep,default salesman | ||
| purchase_order_details | datescheduledfulfillment | date | %m-%d-%Y | Scheduled Fulfillment Date,scheduled fulfillment Date,purchase order details datescheduledfulfillment | |||
| work_order_details | wo_uom_code | dimensions | id | The code representing the unit of measure used in the work order. | wo uom code,wo uom code,UOM,uom code,UOM Code | ||
| work_order_details | customerid | dimensions | id | Customer ID,customer id,work order details customerid | |||
| sales_order_details | so_c4 | dimensions | id | Custom field 4 associated with the sales order. | Sales Order Custom Field 4,so c4 | ||
| shipment_details | datecreated | date | %m-%d-%Y | The date on which the work order was created. | Shipment Created Date,shipment details datecreated,Created Date,date created | ||
| work_order_details | qtyscrapped | metrics | 2 | Quantity | Scrapped Quantity,Scrapped Qty,qty scrapped,work order details qtyscrapped | ||
| work_order_details | wo_num | dimensions | The number or code assigned to the work order. | WO Number,wo num,wo num | |||
| receipt_details | po_num | dimensions | The number assigned to the purchase order. | PO Number,purchase order Number,po num | |||
| purchase_order_details | totalcost | metrics | 2 | Currency | $ | Total Cost,purchase order details totalcost,PO Total Cost | |
| purchase_order_details | remitcity | dimensions | remit city,purchase order details remitcity,Remittance City | ||||
| location_inventory_details | lg | dimensions | id | The group or category associated with the location. | location inventory details lg,Location Group | ||
| product | product_description | dimensions | A detailed description of the product. | Product Description,product description | |||
| product_tree | category_level4 | dimensions | category level4,category level4 | ||||
| sales_order_details | bill_to_address | dimensions | id | The address where the bill for the sales order should be sent. | bill to address,Billing Address | ||
| receipt_details | landedtotalcost | metrics | 2 | Currency | $ | The total cost including shipping, insurance, and other fees associated with getting the goods to the final destination. | Landed Cost,Spend,landed total cost,receipt details landedtotalcost |
| purchase_order_details | po_status | dimensions | po status,po status,PO Status | ||||
| purchase_order_details | po_uom_name | dimensions | PO UOM Name,po uom name | ||||
| receipt_details | trackingnum | dimensions | The number used to track the shipment of goods. | tracking num,Tracking Number,receipt details trackingnum | |||
| part | defaultbomid | dimensions | id | The default Bill of Materials (BOM) ID associated with the part. | defaultbomid,Default Bill of Materials ID,Default BOM ID,part defaultbomid | ||
| sales_order_details | uom_name | dimensions | id | The name of the unit of measure used for items in the sales order. | uom name,UOM Name | ||
| work_order_details | qtytarget | metrics | 2 | Quantity | The target quantity to be achieved in the work order. | qty target,work order details qtytarget,Target Quantity,Target Qty | |
| product_tree | category_level5 | dimensions | category level5,category level5 | ||||
| inventory_details | dropship | metrics | 2 | Quantity | Identifies the inventory item as a drop ship item | Drop Ship,drop ship | |
| receipt_details | poitemid | dimensions | id | The unique identifier for the purchase order item. | po item id,PO Item ID,receipt details poitemid | ||
| purchase_order_details | datecreated | date | %m-%d-%Y | The date when the purchase order was created. | date created,Created Date,purchase order details datecreated | ||
| manufacturing_order_details | moitem_id | dimensions | id | The unique identifier for the item within the manufacturing order. | moitem id,moitem id,MO Item ID | ||
| purchase_order_details | unit_cost | metrics | 2 | Currency | $ | Unit Cost,unit cost,unit cost | |
| manufacturing_order_details | mo_num | dimensions | The number associated with the manufacturing order. | Manufacturing Order ID,MO ID,mo id,Manufacturing Order Number,mo num | |||
| manufacturing_order_details | qtytofulfill | metrics | 2 | Quantity | The quantity that remains to be fulfilled for the purchase order. | manufacturing order details qtytofulfill,Quantity to Fulfill,qtytofulfill | |
| sales_order_details | sales_person | dimensions | id | The name of the sales representative associated with the sales order. | sales person,Sales Rep | ||
| product_tree | class_name | dimensions | id | The name of the product class or category. | class name,Class Name | ||
| manufacturing_order_details | datecreated | date | %m-%d-%Y | Creation Date,Created Date,manufacturing order details datecreated,date created | |||
| sales_order_details | datelastfulfillment | date | %m-%d-%Y | The date of the last fulfillment action for the sales order. | date last fulfillment,last fulfillment date,Last Fulfillment Date | ||
| work_order_details | location_name | dimensions | location name,location name,Location | ||||
| receipt_details | daterevision | date | %m-%d-%Y | Revision Date,revision date,receipt details daterevision | |||
| work_order_details | sortid | dimensions | id | The identifier used to sort or organize work orders. | sort id,work order details sortid | ||
| receipt_details | datecreated | date | %m-%d-%Y | The date when the receipt was created. | date created,Created Date,receipt details datecreated | ||
| sales_order_details | soitem_taxableflag | flag | A flag indicating whether the item in the sales order is taxable. | Taxable Item Flag,soitem taxableflag | |||
| manufacturing_order_details | bomitemtype_name | dimensions | bom item type name,BOM Item Type,bomitemtype name | ||||
| work_order_details | onetimeitem | metrics | 2 | Quantity | one time item,work order details onetimeitem | ||
| product_tree | uom_code | dimensions | UOM Code,Unit of Measure Code,uom code,uom code | ||||
| work_order_details | qtyscrapped | metrics | 2 | Quantity | The quantity of items scrapped during the work order process. | Scrapped Quantity,Scrapped Qty,qty scrapped,work order details qtyscrapped | |
| vendor | id | dimensions | id | The unique identifier for a vendor in the system. | Vendorid,vendor id | ||
| shipment_details | datecreated | date | %m-%d-%Y | Shipment Created Date,shipment details datecreated,Created Date,date created | |||
| part | defaultbomid | dimensions | id | defaultbomid,Default Bill of Materials ID,Default BOM ID,part defaultbomid | |||
| sales_order_details | so_c2 | dimensions | id | Custom field 2 associated with the sales order. | Sales Order Custom Field 2,so c2 | ||
| location_inventory_details | locationid | dimensions | id | The unique identifier for the location associated with the work order. | Location ID,location inventory details locationid,locationid | ||
| purchase_order_details | part_uom_code | dimensions | part uom code,part uom code,Part UOM Code | ||||
| work_order_details | qtyused | metrics | 2 | Quantity | The quantity of items used during the work order process. | Used Quantity,Qty Used,work order details qtyused,Used Qty | |
| receipt_details | poid | dimensions | id | po id,receipt details poid,PO ID | |||
| sales_order_details | active_flag | flag | Indicates whether the sales order is active or not. | active flag | |||
| part | allocated_qty | metrics | 2 | Quantity | allocated qty,allocated qty,Allocated Quantity | ||
| customer_group | account_id | dimensions | id | account id,account id,Account ID | |||
| receipt_details | part | dimensions | The part or item received. | Part,receipt details part | |||
| work_order_details | uom_name | dimensions | id | The name of the unit of measure used in the work order. | uom name,uom name,UOM Name | ||
| receipt_details | datelastmodified | date | %m-%d-%Y | date last modified,Last Modified Date,receipt details datelastmodified,last modified date | |||
| sales_order_details | bill_to_country | dimensions | id | The country where the bill for the sales order should be sent. | Billing Country,bill to country | ||
| receipt_details | poid | dimensions | id | The unique identifier for the purchase order. | po id,receipt details poid,PO ID | ||
| sales_order_details | bill_to_state | dimensions | id | The state where the bill for the sales order should be sent. | bill to state,Billing State | ||
| purchase_order_details | po_item_id | dimensions | id | The unique identifier for the item within the purchase order. | Purchase Order Item ID,PO Item ID,po item id,po item id | ||
| location_inventory_details | locationid | dimensions | id | Location ID,location inventory details locationid,locationid | |||
| receipt_details | partid | dimensions | id | The unique identifier for the part received. | Part ID,partid,receipt details partid | ||
| manufacturing_order_details | partid | dimensions | id | The unique identifier assigned to a specific part or item. | manufacturing order details partid,Part ID | ||
| manufacturing_order_details | bomid | dimensions | id | Bill of Materials ID,Bill of Materials Number,bom id,bomid,BOM ID,manufacturing order details bomid | |||
| receipt_details | poitemid | dimensions | id | po item id,PO Item ID,receipt details poitemid | |||
| product_tree | uom_name | dimensions | id | The name of the unit of measure used for items in the sales order. | uom name,UOM,Unit of Measure,uom name | ||
| sales_order_details | so_taxrate | metrics | 2 | Quantity | The tax rate applied to the sales order. | so taxrate,Sales Order Tax Rate,SO Tax Rate,Tax Rate | |
| sales_order_details | ship_to_state | dimensions | id | The state where the sales order items are to be shipped. | ship to state,Shipping State | ||
| inventory_details | locationgroup_id | dimensions | id | Location Group ID | |||
| receipt_details | receipt_carrier_name | dimensions | id | The name of the carrier responsible for delivering the receipt. | Carrier Name,Carrier,receipt carrier name,carrier name,receipt carrier name | ||
| product_tree | subcategory_name | dimensions | The name of the subcategory under which the product is classified. | subcategory name,Sub-Category,sub category name | |||
| product_tree | subcategory_name | dimensions | subcategory name,Sub-Category,sub category name | ||||
| location_inventory_details | part | dimensions | Item,location inventory details part,Raw Material,Part Number,Part | ||||
| shipment_details | shippedby | metrics | 2 | Quantity | Shipped By,shipment details shippedby | ||
| part | vendorleadtime | metrics | 2 | Quantity | vendorleadtime,part vendorleadtime,Lead Time,Vendor Lead Time | ||
| work_order_details | datestarted | date | %m-%d-%Y | Started Date,work order details datestarted,started date | |||
| receipt_details | receipt_locationgroup_name | dimensions | location group,Location Group Name,location group name,receipt locationgroup name,receipt locationgroup name | ||||
| sales_order_details | soitem_id | dimensions | id | The unique identifier for an item in the sales order. | SO Item ID | ||
| inventory_details | onorder | metrics | 2 | Quantity | The quantity of product currently on order and yet to be received. | On Order Qty,On Order Quantity,onorder,Onorder Qty | |
| part | safety_days | metrics | 2 | Quantity | The number of safety days associated with the part. | safety days,safety days,Safety Days | |
| work_order_details | onetimeitem | metrics | 2 | Quantity | An item that is only used once in the work order. | one time item,work order details onetimeitem | |
| purchase_order_details | partid | dimensions | id | The unique identifier for the part. | Part ID,partid,purchase order details partid | ||
| sales_order_details | part_id | dimensions | id | The ID of the part associated with the sales order. | Part ID,part id | ||
| manufacturing_order_details | qtyfulfilled | metrics | 2 | Quantity | manufacturing order details qtyfulfilled,qty fulfilled,Fulfilled Quantity | ||
| part | part_num | dimensions | id | The number associated with the part. | Raw Material,part num,Item,Part Number,Part | ||
| receipt_details | trackingnum | dimensions | id | tracking num,Tracking Number,receipt details trackingnum | |||
| purchase_order_details | vendor_contact | dimensions | vendor contact,vendor contact,Vendor Contact | ||||
| receipt_details | shiptocity | dimensions | Shipping City,Receipt City,receipt details shiptocity,ship to city | ||||
| manufacturing_order_details | datecompleted | date | %m-%d-%Y | Completion Date,Completed Date,manufacturing order details datecompleted | |||
| purchase_order_details | dateissued | date | %m-%d-%Y | date issued,Issued Date,purchase order details dateissued | |||
| part | part_id | dimensions | id | The unique identifier for the part. | Part ID,part id | ||
| sales_order_details | so_taxratename | dimensions | id | The name of the tax rate applied to the sales order. | SO Tax Rate Name,so taxrate,Tax Rate Name,Sales Order Tax Rate Name | ||
| product_tree | category_name | dimensions | id | The name of the category under which the product is classified. | Category Name,category name | ||
| customer_group | account_type | dimensions | Account Type,account type,account type | ||||
| work_order_details | woitem_id | dimensions | id | woitem id,woitem id,WO Item ID | |||
| manufacturing_order_details | dateissued | date | %m-%d-%Y | manufacturing order details dateissued,date issued,Issue Date | |||
| shipment_details | shippedby | metrics | 2 | Quantity | The person or entity responsible for shipping the items. | Shipped By,shipment details shippedby | |
| purchase_order_details | vendor_name | dimensions | id | The name of the vendor associated with the purchase order. | Vendor,vendor name,vendor name | ||
| inventory_details | orderuptolevel | metrics | 2 | Quantity | orderuptolevel,Max Order Level | ||
| sales_order_details | ship_to_name | dimensions | id | The name of the recipient for the sales order shipment. | Shipping Name,ship to name | ||
| product_tree | product_short_number | dimensions | id | A shortened or abbreviated version of the product number. | Product Short Number,product short number | ||
| purchase_order_details | poitem_status | dimensions | Purchase Order Item Status,poitem status,poitem status | ||||
| manufacturing_order_details | uom_name | dimensions | id | The name of the unit of measure used for items in the sales order. | Unit of Measure,UOM,uom name | ||
| purchase_order_details | part | dimensions | The part or item number associated with the purchase order. | Part Number,Part,Item,purchase order details part,Raw Material | |||
| product | product_id | dimensions | id | The ID of the product associated with the sales order. | product id,Product ID | ||
| manufacturing_order_details | location_group | dimensions | The group or category of locations related to the inventory. | location group name,location group,Location Group,location group,production location group | |||
| sales_order_details | terms_discount_pct | metrics | 2 | Quantity | The percentage discount available if payment is made within the specified discount days. | Payment Terms Discount Percentage,terms discount pct | |
| receipt_details | vendorcontact | dimensions | Vendor Contact,receipt details vendorcontact,vendor contact | ||||
| receipt_details | po_status | dimensions | po status,po status,PO Status | ||||
| product | product_id | dimensions | id | product id,Product ID | |||
| part | vendorleadtime | metrics | 2 | Quantity | The lead time associated with the vendor for the part. | vendorleadtime,part vendorleadtime,Lead Time,Vendor Lead Time | |
| work_order_details | customerid | dimensions | id | The unique identifier for the customer associated with the work order. | Customer ID,customer id,work order details customerid | ||
| manufacturing_order_details | soid | dimensions | id | The unique identifier for the sales order associated with the manufacturing order. | Sales Order ID,manufacturing order details soid,soid | ||
| product | product_num | dimensions | id | The product number used for identification. | Product Number,product num | ||
| purchase_order_details | vendor_part | dimensions | id | The part number or identifier assigned by the vendor. | Vendor Part,vendor part | ||
| receipt_details | receipt_qty | metrics | 2 | Quantity | Receipt Quantity,receipt qty,receipt qty | ||
| product_tree | product_description | dimensions | id | A detailed description of the product. | product description,Part Description | ||
| receipt_details | statusid | dimensions | id | The identifier for the status of the receipt. | Status ID,receipt details statusid |
Comments
0 comments
Please sign in to leave a comment.