PO_PurchaseOrderHeader - change to create unique key.
| • | PurchaseOrderNo - changed to create unique key |
| • | MasterRepeatingOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | APDivisionNo – convert A/P division |
| • | WarehouseCode – convert warehouse |
| • | ARDivisionNo – convert A/R division |
| • | SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | LastInvoiceNo – changed to match invoice number in AP_OpenInvoice |
| • | LastPurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
PO_PurchaseOrderMemo- change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
PO_PurchaseOrderTaxDetail - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
PO_PurchaseOrderTaxSummary - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
PO_PurchaseOrderDetail - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
| • | ExtendedDescriptionKey - convert extended description key |
| • | PurchasesAcctKey - G/L account conversion |
| • | WarehouseCode – convert warehouse |
| • | SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
PO_ReceiptHistoryHeader – change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or change to create unique key |
| • | APDivisionNo – convert A/P division |
| • | WarehouseCode – convert warehouse |
| • | ARDivisionNo – convert A/R division |
| • | InvoiceNo – changed to match invoice number in AP_OpenInvoice |
| • | HeaderSeqNo – incremented if PurchaseOrderNo is blank |
PO_ReceiptHistoryMemo - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | HeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
PO_ReceiptHistoryTaxSummary - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | HeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
PO_ReceiptHistoryDetail - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | HeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
| • | ExtendedDescriptionKey - convert extended description key |
| • | WarehouseCode – convert warehouse |
| • | OrderWarehouseCode – convert warehouse |
| • | ExpenseAcctKey - G/L account conversion |
| • | SalesOrderNo - changed to match SO number in SO_SalesOrderHeader or SO_SalesOrderHistoryHeader |
| • | D531ServiceOrderNo – changed to match Service Order number in SM_531ServiceOrderHeader |
PO_LandedCostHistory – change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
PO_LandedCostType – combined.
| • | CostExpenseAcctKey - G/L account conversion |
PO_OpenOrderDetailByItem – change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
PO_PurchaseOrderDefaults – combined.
| • | WarehouseCode – convert warehouse |
PO_PurchaseOrderMemoSettings– change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
PO_PurchaseOrderPrint– change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
PO_PurchaseOrderRecap – change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader |
| • | APDivisionNo – convert A/P division |
| • | LastInvoiceNo - changed to match invoice number in AP_OpenInvoice |
| • | LastPurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
PO_PurchasesHistory – combined.
| • | APDivisionNo – convert A/P division |
| • | WarehouseCode – convert warehouse |
| • | QuantityPurchased - summed |
| • | DollarsPurchased – summed |
PO_ReceiptDefaults – combined.
| • | WarehouseCode – convert warehouse |
PO_ReceiptHistoryMemoSettings - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | HeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
PO_ReceiptHistoryLotSerial - change to create unique key.
| • | PurchaseOrderNo - changed to match PO number in PO_PurchaseOrderHeader or PO_ReceiptHistoryHeader |
| • | HeaderSeqNo - changed to match Header Sequence number in PO_ReceiptHistoryHeader |
PO_ShipToAddress – combined.
PO_VendorPriceLevel – combined.
| • | APDivisionNo – convert A/P division |
PO_VendorPurchaseAddress– combined.
| • | APDivisionNo – convert A/P division |
