To record specific sales order line details, including part number and details, quantity ordered, delivered, previously delivered and still on back order, and the line total.
Sales Order, Main Form Tab and Process Back Orders run
Name |
Type |
Linked To/Supplied |
InvoiceLineID |
Text (20) |
|
InvoiceHistoryID |
Text (20) |
SO_History.InvoiceHistoryID |
GroupNo |
Number (Integer) |
|
LineNum |
Number (Integer) |
|
CommentLine |
Yes/No |
0 = No; 1 = Yes |
PartNo |
Text (50) |
|
Description |
Text (200) |
|
PhysicalItem |
Number (Integer) |
|
ItemWeight |
Number (Float) |
|
ItemCubic |
Number (Float) |
|
TaxID |
Text (20) |
TX_Tax.TaxID |
ClassDescription |
Text (50) |
|
Cat1Description |
Text (50) |
|
Cat2Description |
Text (50) |
|
Cat3Description |
Text (50) |
|
Units |
Text (50) |
|
CostIn |
Number (Float) |
In_Main.LCost |
DefaultPrice |
Number (Float) |
|
ItemPrice |
Number (Float) |
|
Discount |
Number (Float) |
|
InvoicePrice |
Number (Float) |
|
RRPPrice |
Number (Float) |
|
TaxToCharge |
Number (Float) |
|
TaxToPay |
Number (Float) |
|
CurrentLineTotal |
Number (Float) |
|
QuantityOrdered |
Number (Float) |
|
QuantityPrevDel |
Number (Float) |
|
QuantityThisDel |
Number (Float) |
|
QuantityBackOrd |
Number (Float) |
|
HistoryText_Comment |
Text (200) |
|
Discountable |
Yes/No |
0 = No; 1 = Yes |
TaxInc |
Yes/No |
0 = No; 1 = Yes |
DirectTax |
Number (Float) |
|
DecimalPlaces |
Number (Integer) |
|
MinimumGP |
Number (Float) |
|
DebitLedger |
Text (50) |
|
CreditLedger |
Text (50) |
|
NonStock |
Yes/No |
0 = No; 1 = Yes |
InventoryID |
Text (20) |
IN_Main.InventoryID |
UseSerialNo |
Yes/No |
0 = No; 1 = Yes |
Backorderable |
Yes/No |
0 = No; 1 = Yes |
Picked |
Yes/No |
0 = No; 1 = Yes |
TaxPaid |
Number (Float) |
|
TaxRate |
Number (Float) |
|
UsingSpecialPrice |
Yes/No |
0 = No; 1 = Yes |
EstBOValue |
Number (Float) |
|
ItemTaxToCharge |
Number (Float) |
|
ItemTaxToPay |
Number (Float) |
|
LineLinkID |
Text (20) |
HR_Staff.StaffID;CN_Main.ProspectID;User defined |
KittingStatus |
Number (Integer) |
|
KittingUnits |
Number (Float) |
|
JobConnectorID |
Text (20) |
|
KitStyle |
Number (Integer) |
0 = Normal;1 = Assembled;2 = Template;3 = Kit;4 = Kit (Tax Over-ride) |
DiscountPercentage |
Number (Float) |
|
SalesmanCost |
Number (Float) |
|
LineCost |
Number (Float) |
Sum of all costs multiplied by the quantity in SO_LineDetails |
OrigInvoiceNo |
Text (20) |
|
ItemPriceIncGST |
Number (Float) |
|
ItemPriceUnDiscounted |
Number (Float) |
|
DemandQuantity |
Number (Float) |
|
NonStockLedgerSalesAccID |
Text (20) |
GL_Ledger.GLLedgerID |
KitLineID |
Text (20) |
|
JobCostNo |
Text (62) |
|
SellPriceIncTax |
Yes/No |
0 = No; 1 = Yes |
JobInvoiceItem |
Number (Integer) |
|
QuantityPrevDemand |
Number (Float) |
|
JobID |
Text (20) |
JB_Main.JobID |
CostCentreID |
Text (20) |
JB_CostCentre.CostCentreID |
StageID |
Text (20) |
|
UserDefinedFloat1 |
Number (Float) |
|
UserDefinedFloat2 |
Number (Float) |
|
UserDefinedFloat3 |
Number (Float) |
|
ForwardOrderDate |
DateTime |
|
ScheduleDate |
DateTime |
|
DeliverStock |
Bit |
|
FixSellPrice |
Bit |
|
TypeKitRounding |
Bit |
|
Copyright © 2012 Jiwa Financials. All rights reserved.