Quoting
Records the specific line details including part number, quantities and pricing for each quote and each quote snapshot.
Sales Order Entry
Quoting
|
Name |
Type |
Linked To/Supplied |
|
InvoiceLineID |
Text (20) |
|
|
InvoiceHistoryID |
Text (20) |
QO_History.InvoiceHistoryID |
|
GroupNo |
Number (Integer) |
|
|
LineNum |
Number (Integer) |
|
|
CommentLine |
Yes/No |
0 = No; 1 = Yes |
|
PartNo |
Text (50) |
|
|
Description |
Text (200) |
|
|
PhysicalItem |
Number (Integer) |
0 = No; 1 = Yes |
|
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) |
|
|
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 |
|
|
TaxInc |
Yes/No |
|
|
DirectTax |
Number (Float) |
|
|
DecimalPlaces |
Number (Integer) |
|
|
MinimumGP |
Number (Float) |
|
|
DebitLedger |
Text (50) |
|
|
CreditLedger |
Text (50) |
|
|
NonStock |
Yes/No |
|
|
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;
|
|
KittingStatus |
Number (Integer) |
*** |
|
KittingUnits |
Number (Float) |
|
|
JobConnectorID |
Text (20) |
|
|
KitStyle |
Number (Integer) |
0 = Normal;1 = Assembled;2 = Template; |
|
DiscountPercentage |
Number (Float) |
|
|
SalesmanCost |
Number (Float) |
|
|
ItemPriceIncGST |
Number (Float) |
|
|
ItemPriceUnDiscounted |
Number (Float) |
|
|
NonStockLedgerSales |
Text (20) |
GL_Ledger.GLLedgerID |
|
KitLineID |
Text (20) |
|
|
SellPriceIncTax |
Yes/No |
|
|
UserDefinedFloat1 |
Number (Float) |
|
|
UserDefinedFloat2 |
Number (Float) |
|
|
UserDefinedFloat3 |
Number (Float) |
|
|
FixSellPrice |
Bit |
|
|
TypeKitRounding |
Bit |
|
Copyright © 2012 Jiwa Financials. All rights reserved.