Records sales information that is used in the Inventory Sales Details, Inventory Figures Form Tab and for reporting purposes.
Process Sales Orders run
Name |
Type |
Linked To/Supplied |
SalesID |
char (20) |
|
DateRun |
datetime |
|
InvoiceDate |
datetime |
|
DebtorID |
char (20) |
|
InvoiceNo |
varchar (20) |
|
PartNo |
varchar (50) |
|
Description |
varchar (200) |
|
ClassDescription |
varchar (50) |
|
Cat1Description |
varchar(255) |
|
Cat2Description |
varchar(255) |
|
Cat3Description |
varchar(255) |
|
Quantity |
float |
|
UnitCost |
float |
|
UnitSellPrice |
float |
|
LineTax |
float |
|
LineTotal |
float |
|
RunNo |
char (20) |
|
HistoryNo |
smallint |
|
InvoiceID |
char (20) |
|
InventoryID |
char (20) |
|
YearNo |
smallint |
|
MonthNo |
smallint |
|
IN_LogicalID |
char (20) |
|
Cat4Description |
varchar (255) |
|
Cat5Description |
varchar (255) |
|
KitStyle |
smallint |
0 = Normal;1 = Assembled;2 = Template ;3 = Kit;4 = Kit (Tax Over-ride) |
KitStatus |
smallint |
0 = Normal;1 = Kit Header;2 = Kit Component |
SO_LinesID |
char (20) |
|
LineCost |
float |
|
Copyright © 2012 Jiwa Financials. All rights reserved.