Schema Change for Version 3.11
As compared to Version 3.10 of MoversSuite
Table Field
AcctTransactions VendorName
ARCTriggeredAlert BranchFID
BATProcess VendorName
GPWarehouse PONumber
GPWarehouse GBLNumber
XmlDocumentTypeVanlineMap
ARCTriggeredAlertOrderMap New table
ARCTriggeredAlertOrderMap ARCAlertDescription
ARCTriggeredAlertOrderMap CustomerNumber
ARCTriggeredAlertOrderMap BranchFID
ARCTriggeredAlertOrderMap OrderFID
ARCTriggeredAlertOrderMap InvoiceHeaderFID
StorageProcessBillingHeader New table
StorageProcessBillingHeader StorageProcessBillingHeaderID
StorageProcessBillingHeader SessionID
StorageProcessBillingHeader BranchFID
StorageProcessBillingHeader StorageTypeFID
StorageProcessBillingHeader ReportFID
StorageProcessBillingHeader BillFromDate
StorageProcessBillingHeader BillToDate
StorageProcessBillingHeader DocumentDate
StorageProcessBillingHeader JournalDate
Description
Increased field size from varchar(50) to varchar(65)
Deleted field
Increased field size from varchar(50) to varchar(65)
New field of varchar(30) used to store the purchase order number retrieved from GP for the order/invoice
New field of varchar(16) used to store the GBL number retrieved from GP for the order/invoice
Deleted table
Stores data on alerts set for each customer
Text of the alert
ID of the customer linked to the alert
ID of the branch associated to the alert
ID of the order number associated to the alert
ID of the invoice document associated to the alert
Stores data from a billing run
Primary key of the table
Session ID that uniquely identifies a storage run
ID of the branch chosen for the storage run identified by SessionID, or 0 if the storage run is for all branches
ID of the billing type chosen for the storage run identified by SessionID, or 0 if the storage run is for all billing types
ID of the invoice report to be used when generating invoices for the storage run identified by SessionID
The starting date for the storage run identified by SessionID
The ending date for the storage run identified by SessionID
DThe Document Date for transactions generated by the storage run identified by SessionID
The Document Date for transactions generated by the storage run identified by SessionID
SQL Compare between: