SM_Options – use Consolidated Company SM_Options table.
| • | AutoTransferRefurbishedItems – set to “N” in the Consolidated Company if it is “N” in any Source Company |
| • | EnableLotSerialDist – set to “Y” in the Consolidated Company if it is “Y” in any Source Company |
| • | RequireFullyDistributedLines – set to “N” in the Consolidated Company if EnableLotSerialDist is set to “Y” in the Consolidated Company and RequireFullyDistributedLines is “N” in any Source Company |
SM_531ServiceOrderHeader – change to create unique key.
| • | ServiceOrderNo – changed to create unique key |
| • | OutsideDivisionNo – convert A/P division |
| • | ARDivisionNo – convert A/R division |
| • | BillToDivisionNo – convert A/R division |
| • | WarehouseCode – convert warehouse |
| • | SalespersonDivisionNo - convert A/R division |
| • | SalespersonNo – convert salesperson |
| • | SalespersonNo2 - convert salesperson |
| • | SalespersonDivisionNo3 - convert A/R division |
| • | SalespersonNo3 - convert salesperson |
| • | SalespersonDivisionNo4 - convert A/R division |
| • | SalespersonNo4 - convert salesperson |
| • | SalespersonDivisionNo5 - convert A/R division |
| • | SalespersonNo5 - convert salesperson |
| • | LoanerSalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | HistorySeqNo – changed to match sequence number in SM_531ServiceOrderHistHeader |
SM_531ServiceOrderMemo – change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
SM_531ServiceOrderMemoSettings – change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
SM_531ServiceOrderTaxDetail – change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
SM_531ServiceOrderTaxSummary – change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
SM_531ServiceItemEntry – change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | EndUserCurrentDivisionNo - convert A/R division |
| • | OutsideServiceDivisionNo – convert A/P division |
| • | OriginalInvoice - changed to match invoice number in AR_OpenInvoice |
| • | OriginalInvoiceHistSeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | SalesOrderNoForLoaner - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | ReturnWarehouseCode - convert warehouse |
| • | ApplyToInvoice - changed to match invoice number in AR_OpenInvoice |
| • | RefurbishSourceWarehouseCode - convert warehouse |
| • | RefurbishTargetWarehouseCode - convert warehouse |
SM_531ServiceOrderDetail – change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | ExtendedDescriptionKey - convert extended description key |
| • | WarehouseCode – convert warehouse |
| • | CostOfGoodsSoldAcctKey - G/L account conversion |
| • | SalesAcctKey - G/L account conversion |
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | APDivisionNo – convert A/P division |
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
SM_531ServiceOrderHistHeader - change to create unique key and increment sequence.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | HeaderSeqNo – incremented |
| • | OutsideDivisionNo – convert A/P division |
| • | ARDivisionNo – convert A/R division |
| • | BillToDivisionNo – convert A/R division |
| • | WarehouseCode – convert warehouse |
| • | SalespersonDivisionNo - convert A/R division |
| • | SalespersonNo – convert salesperson |
| • | SalespersonNo2 - convert salesperson |
| • | SalespersonDivisionNo3 - convert A/R division |
| • | SalespersonNo3 - convert salesperson |
| • | SalespersonDivisionNo4 - convert A/R division |
| • | SalespersonNo4 - convert salesperson |
| • | SalespersonDivisionNo5 - convert A/R division |
| • | SalespersonNo5 - convert salesperson |
| • | LoanerSalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | HistorySeqNo – changed to match HeaderSeqNo |
SM_531ServiceOrderHistMemo - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
SM_531SvcOrderHistMemoSettings - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
SM_531SvcOrderHistTaxDetail - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | ServiceOrderSeqNo - changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
SM_531SvcOrderHistTaxSummary - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | ServiceOrderSeqNo changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
SM_531ServiceItemEntryHistory - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
| • | EndUserCurrentDivisionNo - convert A/R division |
| • | OutsideServiceDivisionNo – convert A/P division |
| • | OriginalInvoice - changed to match invoice number in AR_OpenInvoice |
| • | OriginalInvoiceHistSeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | SalesOrderNoForLoaner - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | ReturnWarehouseCode - convert warehouse |
| • | ApplyToInvoice - changed to match invoice number in AR_OpenInvoice |
| • | RefurbishSourceWarehouseCode - convert warehouse |
| • | RefurbishTargetWarehouseCode - convert warehouse |
SM_531ServiceOrderHistDetail - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
| • | ExtendedDescriptionKey - convert extended description key |
| • | WarehouseCode – convert warehouse |
| • | CostOfGoodsSoldAcctKey - G/L account conversion |
| • | SalesAcctKey - G/L account conversion |
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | APDivisionNo – convert A/P division |
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
SM_531AutoGeneratePODefaults – combined.
SM_531ComplaintCode – combined.
SM_531DemoLoaner – - change to create unique key and combine.
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo – changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | WarehouseCode – convert warehouse |
| • | ARDivisionNo – convert A/R division |
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | SvcOrderHistHeaderSeqNo - changed to match header history number in SM_531ServiceOrderHeader |
| • | SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | QuantityShipped - summed |
| • | QuantityReturned – summed |
SM_531DemoLoanerHistory – - change to create unique key and combine.
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo – changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | WarehouseCode – convert warehouse |
| • | ARDivisionNo – convert A/R division |
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | SvcOrderHistHeaderSeqNo - changed to match header history number in SM_531ServiceOrderHeader |
| • | SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | QuantityShipped - summed |
| • | QuantityReturned – summed |
SM_531FailureReason – combined.
SM_531GroupCode – combined.
SM_531GroupCodeCustomer – combined.
| • | ARDivisionNo – convert A/R division |
SM_531GroupCodeParts – combined.
SM_531OwnerHistory – combined.
| • | OldDivisionNo – convert A/R division |
| • | OldCurrentDivisionNo – convert A/R division |
SM_531QuickPrintDefaults – combined.
SM_531ServiceItem – combined.
| • | WarehouseCode – convert warehouse |
| • | SoldToDivisionNo - convert A/R division |
| • | EndUserDivisionNo - convert A/R division |
| • | OriginalInvoice - changed to match invoice number in AR_OpenInvoice |
| • | OriginalInvoiceHistSeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader |
| • | SalespersonDivisionNo - convert A/R division |
| • | SalespersonNo – convert salesperson |
| • | APDivisionNo – convert A/P division |
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | NumberOfTimesServiced - summed |
| • | TotalWarrantyHours - summed |
| • | TotalWarrantyLaborCost - summed |
| • | TotalBillableHours - summed |
| • | TotalServiceLaborCost - summed |
| • | TotalServiceLaborSales – summed |
SM_531ServiceItemMemo - increment sequence.
SM_531ServiceItemMemoSettings - increment sequence.
SM_531ServiceItemSerialHistory - increment sequence.
SM_531ServiceItemStatusLog - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | OutsideServiceDivisionNo – convert A/P division |
SM_531ServiceItemStatusLog - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | ServiceOrderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
| • | OutsideServiceDivisionNo – convert A/P division |
SM_531ServiceOrderDefaults – combined.
| • | WarehouseCode – convert warehouse |
SM_531ServiceOrderPrint - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | WarehouseCode – convert warehouse |
| • | InvoiceNo – will not be changed |
SM_531ServiceOrderUserLog - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
SM_531ServiceOrderUserLogHist - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | ServiceOrderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
SM_531ServiceTechnician– combined.
| • | LaborSalesAcctKey - G/L account conversion |
| • | WarrantyLaborAcctKey - G/L account conversion |
| • | ServiceLaborAcctKey - G/L account conversion |
| • | PayrollLaborOffsetAcctKey - G/L account conversion |
| • | SalespersonDivisionNo - convert A/R division |
| • | SalespersonNo – convert salesperson |
| • | WarehouseCode – convert warehouse |
SM_531ServiceTechHistory – combined.
| • | NonWarrantyHours - summed |
| • | WarrantyLaborCost - summed |
| • | NonWarrantyLaborCost - summed |
SM_531StatusCode – combined.
| • | NextInvoiceNo – will not be changed |
SM_531SvcTierDistribution - change to create unique key.
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | WarehouseCode – convert warehouse |
SM_531TimeTransactions - change to create unique key.
| • | TransactionId – changed to create unique key |
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
SM_531TimeTransHistory - change to create unique key.
| • | TransactionId – change to match Transaction ID in SM_531TimeTransactions or create unique key |
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | ServiceOrderHistorySeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
SM_531WarrantyCode – combined.
SM_531WarrantyPricing – combined.
SM_531WarrantyReplacement - change to create unique key or increment sequence.
| • | SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
| • | HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
| • | InvoiceNo - changed to match invoice number in AR_OpenInvoice |
| • | InvoiceHistorySeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader |
| • | SalesOrderLineKey – incremented if SalesOrderNo is |
