Multi-Buy Discounts |
  
|
Multi-Buy Discounts |
|
The Multi-Buy Discounts table contains details of the Multi-Buy Discounts defined for the Customers, Suppliers and Stock Records.
Relational Links
The Multi-Buy Discounts can be relationally linked to the Customers or Suppliers using the mbdAcCode field, and to the Stock database using the mbdStockCode field.
Field Name |
Description |
Type |
Length |
mbdOwnerType
C = Customer S = Supplier T = Stock
|
Owner Type |
String |
1 |
mbdAcCode |
Customer/Supplier Account Code |
String |
6 |
mbdStockCode |
Stock Code |
String |
16 |
mbdBuyQtyString |
Buy Quantity |
String |
20 |
mbdCurrency |
Currency |
Integer |
1 |
mbdDiscountType
0 = Buy X Get Y Free 1 = Buy X For Specified Price 2 = Buy X Get Y% Off |
Discount Type |
String |
1 |
mbdStartDate |
Effective Start Date |
String |
8 |
mbdEndDate |
Effective End Date |
String |
8 |
mbdUseDates |
Use Effective Dates |
Bit |
|
mbdBuyQty |
Buy Quantity |
Double |
8 |
mbdRewardValue |
Reward Value |
Double |
8 |
mbdSpare1a |
Future Use |
String |
255 |
mbdSpare1b |
Future Use |
String |
1 |