|
  
|
||
|
|
||
The Quantity Discounts table contains details of the discounts defined for the Stock as well as the Account Quantity Break discounts within Exchequer.
Relational Links
The discounts can be relationally linked to the Customers or Suppliers using the idxAcCode field, and to the Stock table using the idxStockFolio field.
Field Name |
Description |
Type |
Length |
qdRecType |
D |
String |
1 |
qdIdxRecSub |
|
String |
2 |
qdSubType |
|
String |
1 |
qdIdxDiscQty |
|
String |
26 |
qdIdxSpare |
Future Use |
String |
20 |
qdIdxBatchNo |
|
String |
10 |
qdQtyFrom |
From Quantity |
Float |
8 |
qdQtyTo |
To Quantity |
Float |
8 |
qdType
C = Cust Q = Stock S = Supplier |
Quantity Discount Type |
String |
1 |
qdCurrency |
Currency |
Integer |
1 |
qdSalesPrice |
Sales Price |
Float |
8 |
qdUsePriceBand |
Use Price Band |
String |
1 |
qdDiscPerc |
Discount Percentage |
Float |
8 |
qdDiscAmt |
Discoutn Amount |
Float |
8 |
qdMarkupMargin |
Markup/Margin |
Float |
8 |
IdxStockFolio |
Stock Folio No |
Integer |
4 |
IdxAcCode |
Account Code |
String |
6 |
qdUseEffectiveDates |
Use Effective Dates |
Logical |
1 |
qdDateEffectiveFrom |
Date Effective From |
Date |
8 |
qdDateEffectiveTo |
Date Effective To |
Date |
8 |
