This table keeps track of each snapshot version of a sales order as back orders are filled and snapshots created to reduce stock on back order. Records delivery address and courier details together with total value of the order version and any cash payments received with the order.
Sales Order Main Form Tab and Process Back Orders run.
Name |
Type |
Linked To/Supplied |
InvoiceHistoryID |
Text (20) |
|
InvoiceID |
Text (20) |
SO_Main.InvoiceID |
LastModifiedBy |
Text (20) |
|
RecordDate |
Date/Time |
|
Ref |
Text (50) |
|
HistoryNo |
Number (Integer) |
|
HistoryTotal |
Number (Float) |
|
DocketPrinted |
Yes/No |
0 = No; 1 = Yes |
DelAddress1 |
Text (50) |
|
DelAddress2 |
Text (50) |
|
DelAddress3 |
Text (50) |
|
DelAddress4 |
Text (50) |
|
PostCode |
Text (10) |
|
Notes |
Memo |
|
CourierDetails |
Text (200) |
|
PaymentTypeID |
Text (20) |
SO_PaymentTypes.TypeID |
PaymentRef |
Text (50) |
|
AmountPaid |
Number (Float) |
|
RunNo |
Text (20) |
|
InvoicePrinted |
Yes/No |
0 = No; 1 = Yes |
CartageCharge1 |
Number (Float) |
|
CartageCharge2 |
Number (Float) |
|
CartageCharge3 |
Number (Float) |
|
DelContactName |
Text (50) |
|
Delivered |
Yes/No |
0 = No; 1 = Yes |
Delivered Date |
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) |
|
FreightForwardAddress1 Through to FreightForward Address4 |
Text (250) |
|
FreightForwardNotes |
Memo |
|
DBTransID |
Text (20) |
DB_Trans.DBTransID |
PackslipPrinted |
bit |
|
PIcksheetPrinted |
bit |
|
OtherPrinted |
bit |
|
Status |
tinyint |
|
Invoicemailed |
tinyint |
|
Copyright © 2012 Jiwa Financials. All rights reserved.