Listed in the table below are the database changes made at this version MoversSuite.
|
Table |
Field |
Description |
|
AdvancePostingInformation |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
BillingMinorDist |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
BillingMinorItem |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimHandlingExpense |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimHandlingExpensePayment |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimHandlingRevenue |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimHandlingRevenuePayment |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimItemDueFrom |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimItemDueFromPayment |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimLiabilityItem |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimLiabilityItemPayment |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
ClaimSettlement |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
CommissionedDetail |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
CustomerStatementDetail |
DocumentNumber |
Modified this field by increasing its size to 23 characters from 21. This field is a varchar (23). (6541) |
|
ErrorCode |
Description |
Increased field size to 256 characters from 128. The Description field to accommodate larger error messages. This field is a varchar (256). (6634) |
|
InvoiceSequence |
|
Table removed. It has been replaced by new fields added to SysFile. (6541) |
|
Orders |
Archived |
New field storing an indicator that this record is archived (set) or not (not set). (6541) |
|
ArchivedOn |
New field storing the date and time the record was archived. (6541) | |
|
ArchivedOrderNo |
New field storing the original Order Number of this record prior to it being archived. This field is a varchar (23). (6541) | |
|
ArchiveEstimateNo |
New field storing the original Estimate Number of this record prior to it being archived. This field is a varchar (32). (6541) | |
|
OrderDocSequence |
|
Table removed. It has been replaced by new fields added to SysFile. (6541) |
|
PMImportDetailDist |
InvoiceNumber |
Increased the size of this field to 30 characters from 25 to better match what comes from Dynamics GP. This field is a varchar (30). (6541) |
|
SplitCommissions |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
StatementDetailDistInvoice |
InvoiceNumber |
Increased the size of this field to 30 characters from 25 to better match what comes from Dynamics GP. This field is a varchar (30). (6541) |
|
StatementDocument |
InvoiceNumber |
Increased the size of this field to 30 characters from 25 to better match what comes from Dynamics GP. This field is a varchar (30). (6541) |
|
SysFile |
AcctDocSequenceYear |
New field to store the year that new sequence numbers are based on when created. This field affects what is set for the InvoiceSequence and WorkTicketSequence fields. (6541) |
|
InvoiceSequence |
New field storing the next sequential number to be assigned to new invoices created within MoversSuite. (6541) | |
|
WorkTicketSequence |
New field storing the next sequential number to be assigned to new work ticket numbers created within MoversSuite. (6541) | |
|
ThirdParty |
DocumentNumber |
New field to store the posted document number for the transaction. This field is a varchar (21). (6541) |
|
PostingDoc |
Field removed (7202) | |
|
WorkTickets |
Sequence |
Field replaced by WorkTickets.WorkTicketNumber. (6541) |
|
WorkTicketNumber |
New field to store the work ticket number generated through MoversSuite. This field generates based on values assigned through SysFile.WorkTicketSequence. This field is a varchar (32).(6541) |
Click here for a graphical interpretation of the MoversSuite database schema (5.15).
Listed in the table below are the Microsoft Dynamics GP database changes made at this version MoversSuite.
|
Table |
Field |
Description |
|
MSS00200 |
|
New table storing the primary table key to identify archived orders (7213) |