|
  
|
||
|
|
||
The Account Discounts Table contains details of the discounts defined for the Customers and Suppliers 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 idxStockCode field.
Key Field: adIdxAcStock
Field Name |
Description |
Type |
Length |
adIdxRecSub |
|
String |
2 |
adRecType |
C |
String |
1 |
adIdxStock |
Stock Code |
String |
20 |
adIdxAcStock |
IdxAcCode+IdxStockcode. |
String |
26 |
adSubType |
|
String |
1 |
IdxStockCode |
Stock Code (Idx) |
String |
20 |
IdxAcCode |
Account Code (Idx) |
String |
6 |
adType |
Discount Type |
String |
1 |
adCurrency |
Discount Currency |
Integer |
1 |
adPrice |
Special Price |
Float |
8 |
adBand |
Price Band |
String |
1 |
adDiscPerc |
Discount % |
Float |
8 |
adDiscAmt |
Net Discount Amount |
Float |
8 |
adMarkupMargin |
% Markup or Margin |
Float |
8 |
adUseEffectiveDates |
Use Effective Dates |
Logical |
1 |
adDateEffectiveFrom |
Effective Start Date |
Date |
8 |
adDateEffectiveTo |
Effective End Date |
Date |
8 |
