IM_Warehouse – combined.
| • | WarehouseCode – convert warehouse |
IM_AliasItem – combined.
| • | ARDivisionNo – convert A/R division |
| • | APDivisionNo – convert A/P division |
IM_ItemCost – combined.
| • | WarehouseCode – convert warehouse |
| • | QuantityCommitted – summed |
| • | ExtendedCost – calculated |
IM_ItemWarehouse – combined.
| • | WarehouseCode – convert warehouse |
| • | QuantityOnPurchaseOrder - summed |
| • | QuantityOnSalesOrder - summed |
| • | .QuantityOnBackOrder - summed |
| • | QuantityOnWorkOrder - summed |
| • | QuantityRequiredForWO - summed |
| • | AverageCost – recalculated |
| • | QuantityInShipping - summed |
| • | TotalWarehouseValue - summed |
IM_ProductLine – combined.
| • | InventoryAcctKey - G/L account conversion |
| • | CostOfGoodsSoldAcctKey - G/L account conversion |
| • | SalesIncomeAcctKey - G/L account conversion |
| • | ReturnsAcctKey - G/L account conversion |
| • | AdjustmentAcctKey - G/L account conversion |
| • | PurchaseAcctKey - G/L account conversion |
| • | PurchaseOrderVarianceAcctKey - G/L account conversion |
| • | ManufacturingVarianceAcctKey - G/L account conversion |
| • | ScrapAcctKey - G/L account conversion |
| • | RepairsInProcessAcctKey - G/L account conversion |
| • | RepairsClearingAcctKey - G/L account conversion |
IM_AlternateItem – combined.
IM_BuyerPlannerCode – combined.
IM_ItemCustomerHistoryByPeriod – combined.
| • | ARDivisionNo – convert A/R division |
| • | CostOfGoodsSold - summed |
| • | QuantityReturned – summed |
IM_ItemMemo - increment sequence.
IM_ItemMemoSettings - increment sequence.
IM_ItemTransactionHistory - increment sequence.
| • | WarehouseCode – convert warehouse |
| • | APDivisionNo – convert A/P division |
| • | ARDivisionNo – convert A/R division |
| • | EntryNo - changed to match invoice number in AR_ OpenInvoice if Transaction Code is “SO” SequenceNo – incremented |
| • | InvoiceHistoryHeaderSeqNo- changed to match sequence number in AP_InvoiceHistoryHeader |
| • | ReceiptHistoryHeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
| • | ReceiptHistoryPurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
IM_ItemVendor – combined.
| • | APDivisionNo – convert A/P division |
| • | LastReturnPurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | LastReceiptPurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | LastReceiptHeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
IM_ItemVendorHistoryByPeriod – combined.
| • | APDivisionNo – convert A/P division |
| • | QuantityReceived - summed |
| • | CostOfGoodsReceived - summed |
| • | QuantityReturned – summed |
IM_ItemWhseHistoryByPeriod – combined.
| • | WarehouseCode – convert warehouse |
| • | CostOfGoodsSold – summed |
| • | QuantityReturnedCustomer – summed |
| • | QuantityReceived – summed |
| • | CostOfGoodsReceived – summed |
| • | QuantityProduced – summed |
| • | QuantityReturnedVendor – summed |
| • | QuantityTransferred – summed |
| • | QuantityTransferredOut – summed |
| • | QuantityAdjusted – summed |
| • | AdjustmentsCost – summed |
| • | QuantitySoldAsKits – summed |
IM_LotSerialTransactionHistory - increment sequence.
| • | WarehouseCode – convert warehouse |
| • | APDivisionNo – convert A/P division |
| • | ARDivisionNo – convert A/R division |
| • | EntryNo - changed to match invoice number in AR_OpenInvoice if Transaction Code is “SO” |
| • | SequenceNo – incremented |
| • | InvoiceHistoryHeaderSeqNo- changed to match sequence number in AP_InvoiceHistoryHeader |
| • | ReceiptHistoryHeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
| • | ReceiptHistoryPurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
IM_PeriodPostingHistory – combined.
| • | WarehouseCode – convert warehouse |
| • | BeginningBalQty – summed |
| • | BeginningBalDollarAmt – summed |
| • | BeginningBalExtendedStdCost – summed |
| • | PeriodChangeQty – summed |
| • | PeriodChangeDollarAmt – summed |
| • | PeriodChangeExtendedStdCost – summed |
IM_PriceCode – combined.
| • | ARDivisionNo – convert A/R division |
IM_SalesPromotion – combined.
IM_WarrantyCode – combined.
IM_Audit - increment sequence.
| • | SequenceNo – incremented |
