Navigation:  Product Use > How Tables are Consolidated >

Sales Order Module

 Previous pageReturn to chapter overviewNext page

 

SO_Options – use Consolidated Company SO_Options table.

•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

 

SO_SalesOrderHeader - change to create unique key.

•SalesOrderNo - changed to create unique key
•MasterRepeatingOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader
•ARDivisionNo – 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
•BillToDivisionNo - convert A/R division
•D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader
•D531HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader

 

SO_SalesOrderMemo - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_SalesOrderTaxDetail - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_SalesOrderTaxSummary - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_SalesOrderDetail - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader
•ExtendedDescriptionKey - convert extended description key
•WarehouseCode – convert warehouse
•CostOfGoodsSoldAcctKey - G/L account conversion
•SalesAcctKey - G/L account conversion
•APDivisionNo – convert A/P division
•PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader
•D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader
•D531HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader

 

SO_SalesOrderHistoryHeader - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or to create unique key
•MasterRepeatingOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader
•ARDivisionNo – convert A/R division
•BillToDivisionNo – convert A/R division
•WarehouseCode – convert warehouse
•LastInvoiceNo – changed to match invoice number in AR_OpenInvoice
•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
•D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader
•D531HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader

 

SO_SalesOrderHistoryDetail - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader
•ExtendedDescriptionKey - convert extended description key
•WarehouseCode – convert warehouse
•CostOfGoodsSoldAcctKey - G/L account conversion
•SalesAcctKey - G/L account conversion
•APDivisionNo – convert A/P division
•PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader
•D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader
•D531HeaderSeqNo – changed to match Header Sequence number in SM_531ServiceOrderHistHeader

 

SO_SalesOrderHistoryMemo - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader

 

SO_SalesOrderHistoryTaxDetail - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader

 

SO_SalesOrderHistoryTaxSummary - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader

 

SO_RecapByProductLineWhse – combined.

•WarehouseCode – convert warehouse
•QuantityShipped - summed
•QuantityReturned - summed
•DollarsSold - summed
•CostOfGoodsSold – summed

 

SO_RecapByDivision – combined.

•ARDivisionNo – convert A/R division
•QuantityShipped - summed
•QuantityReturned - summed
•DollarsSold - summed
•CostOfGoodsSold – summed

 

SO_RecapByWarehouse– combined.

•WarehouseCode – convert warehouse
•QuantityShipped - summed
•QuantityReturned - summed
•DollarsSold - summed
•CostOfGoodsSold – summed

 

SO_ShipToAddress – combined.

•ARDivisionNo – convert A/R division
•SalespersonDivisionNo - convert A/R division
•SalespersonNo – convert salesperson
•WarehouseCode – convert warehouse

 

SO_ARInvoiceHistoryLink – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader
•InvoiceNo - changed to match invoice number in AR_OpenInvoice
•InvoiceHistoryHeaderSeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader

 

SO_CancelReasonCode – combined.

 

SO_InvoiceDefaults – combined.

•WarehouseCode – convert warehouse

 

SO_InvoiceHistoryLink – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader
•InvoiceNo - changed to match invoice number in AR_OpenInvoice
•InvoiceHistoryHeaderSeqNo - changed to match invoice sequence number in AR_InvoiceHistoryHeader

 

SO_LastPurchaseHistory – combined.

•ARDivisionNo – convert A/R division

 

SO_LotSerialHistory – combined.

•ARDivisionNo – convert A/R division
•InvoiceNo - changed to match invoice number in AR_OpenInvoice
•BillToDivisionNo - convert A/R division
•QuantityShipped - summed

 

SO_OpenOrderDetailByItem – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_PurchaseCtrlByCustByItem – combined.

•ARDivisionNo – convert A/R division

 

SO_PurchaseCtrlByCustByProdLn– combined.

•ARDivisionNo – convert A/R division

 

SO_PurchaseCtrlByStateByItem – combined.

 

SO_PurchaseCtrlByStateByProdLn – combined.

 

SO_SalesHistory – combined.

•ARDivisionNo – convert A/R division
•WarehouseCode – convert warehouse
•DollarsSold - summed
•CostOfGoodsSold - summed
•QuantityShipped - summed
•QuantityReturned – summed

 

SO_SalesOrderDefaults – combined.

•WarehouseCode – convert warehouse

 

SO_SalesOrderDropShip– change to create unique key.

•APDivisionNo – convert A/P division
•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_SalesOrderHistMemoSettings – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_SalesOrderMemoSettings – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader

 

SO_SalesOrderPrint – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader
•WarehouseCode – convert warehouse
•InvoiceNo – not changed

 

SO_SalesOrderRecap – change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader
•ARDivisionNo – convert A/R division
•BillToDivisionNo – convert A/R division

 

SO_ShipperID – combined.

 

SO_ShippingRateDetail – combined.

 

SO_ShippingRateHeader – combined.

 

SO_SalesOrderTierDistribution - change to create unique key.

•SalesOrderNo - changed to match SO number in SO_SalesOrderHeader
•WarehouseCode – convert warehouse