This table keeps track of each snapshot version of a quote, including delivery address details and history number.
Sales Order Entry Quoting New Snapshot
Name |
Type |
Linked To/Supplied |
InvoiceHistoryID |
Text (20) |
|
InvoiceID |
Text (20) |
QO_Main.InvoiceID |
LastModifiedBy |
Text (20) |
|
RecordDate |
Date/Time |
|
Ref |
Text (255) |
|
HistoryNo |
Number (Integer) |
|
HistoryTotal |
Number (Float) |
|
DocketPrinted |
Yes/No |
|
DelAddress1 |
Text (50) |
|
DelAddress2 |
Text (50) |
|
DelAddress3 |
Text (50) |
|
DelAddress4 |
Text (50) |
|
PostCode |
Text (10) |
|
Notes |
Memo |
|
CourierDetails |
Text (200) |
|
PaymentTypeID |
Text (20) |
|
PaymentRef |
Text (50) |
|
AmountPaid |
Number (Float) |
|
RunNo |
Text (20) |
|
InvoicePrinted |
Yes/No |
|
CartageCharge1 |
Number (Float) |
|
CartageCharge2 |
Number (Float) |
|
CartageCharge3 |
Number (Float) |
|
ExpiryDate |
Date/Time |
|
Cartage1TaxRateID |
Text (20) |
|
Cartage1TaxRate |
Number (Float) |
|
Cartage1TaxAmount |
Number (Float) |
|
Cartage2TaxRateID |
Text (20) |
|
Cartage2TaxRate |
Number (Float) |
|
Cartage2TaxAmount |
Number (Float) |
|
Cartage3TaxRateID |
Text (20) |
|
Cartage3TaxRate |
Number (Float) |
|
Cartage3TaxAmount |
Number (Float) |
|
DelContactName |
Text (50) |
|
FreightForwardAddress1 |
Text (250) |
|
FreightForwardAddress2 |
Text (250) |
|
FreightForwardAddress3 |
Text (250) |
|
FreightForwardAddress4 |
Text (250) |
|
FreightForwardNotes |
Memo |
|
Recid |
Char36 |
|
LastsavedDateTime |
DateTime |
|
DisplayOrder |
int |
|
Description |
Varchar255 |
|
PercentComplete |
int |
|
DefaultSalesStage |
bit |
|
Copyright © 2012 Jiwa Financials. All rights reserved.