Available in Sage 50 Quantum Accounting.
Quantity Discount Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: QTYDISC.DAT
QTYDISC.DAT is the Quantity Discounts file. The information below is entered or displayed in the Maintain Quantity Discounts window.
- To add Sage 50 Quantity Discount fields to your Crystal reports, select QTYDISC.DAT.
Indexes and Their Uses
The QTYDISC.DAT file has the following indexes:
0 = By GUID. Uses a unique key that will not change for the lifetime of the record.
1 = By ID. Indexed by the unique Record Identifier entered.
2 = By Desc. Indexed by the Quantity Discount Description.
3 = By IDByDesc. Indexed by the ID and the Description.
4 = By InactiveByID. Indexed by the Inactive Indicator and the ID.
5 = By InactiveByDesc. Indexed by the Inactive Indicator and the Description.
Fields
The following table shows the fields available in the QTYDISC.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
Field Name |
Type |
Size |
Comment |
|
QtyDiscGUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the QtyDisc table. |
|
|
ID |
Zstring |
20 |
Quantity Discount ID entered in the Qty Discount ID field on the Maintain Quantity Discounts window. |
|
Description |
Zstring |
30 |
Quantity Discount Description entered in the Description field on the Maintain Quantity Discounts window. |
|
LastUpdateCounter |
Integer |
This increases incrementally when the record is changed. |
|
|
Inactive |
Logical |
The Inactive check box on the Maintain Quantity Discounts window. 0 = the Quantity Discount record is active (unchecked). 1 = the Quantity Discount record is inactive (checked). |
|
|
CalcMethod |
Integer |
Calculation method selected from the Calculation Method drop-down list on the Maintain Quantity Discounts window. 0 = Discount Percentage is chosen. 1 = Discount Amount is chosen. |
|
|
RoundingMethod |
Integer |
Rounding method selected from the Rounding Method drop-down list on the Maintain Quantity Discounts window. 0 = No Rounding is chosen. 1 = Specific Cent is chosen. 2 = Next Dollar is chosen. |
|
|
RoundingCents |
Float |
Specific cent amount entered in the Maintain Quantity Discounts window when the Specific Cent option is chosen as the rounding method. |
|
|
IsQuantitySet1 |
Logical |
Indicates if the quantity has been set for the first discount row |
|
|
MinQuantity1 |
Float |
Quantity entered in the first Minimum Qty for Discount row on the Maintain Quantity Discounts window. |
|
|
Discount1 |
Float |
Discount percent or amount entered in the first Discount Percent/Amount row on the Maintain Quantity Discounts window. |
|
|
IsQuantitySet2 |
Logical |
Indicates if the quantity has been set for the second discount row |
|
|
MinQuantity2 |
Float |
Quantity entered in the second Minimum Qty for Discount row on the Maintain Quantity Discounts window. |
|
|
Discount2 |
Float |
Discount percent or amount entered in the second Discount Percent/Amount row on the Maintain Quantity Discounts window. |
|
|
IsQuantitySet3 |
Logical |
Indicates if the quantity has been set for the third discount row |
|
|
Discount3 |
Float |
Discount percent or amount entered in the third Discount Percent/Amount row on the Maintain Quantity Discounts window. |
|
|
MinQuantity3 |
Float |
Quantity entered in the third Minimum Qty for Discount row on the Maintain Quantity Discounts window. |
|
|
IsQuantitySet4 |
Logical |
Indicates if the quantity has been set for the fourth discount row |
|
|
MinQuantity4 |
Float |
Quantity entered in the fourth Minimum Qty for Discount row on the Maintain Quantity Discounts window. |
|
|
Discount4 |
Float |
Discount percent or amount entered in the fourth Discount Percent/Amount row on the Maintain Quantity Discounts window. |
|
|
IsQuantitySet5 |
Logical |
Indicates if the quantity has been set for the fifth discount row |
|
|
MinQuantity5 |
Float |
Quantity entered in the fifth Minimum Qty for Discount row on the Maintain Quantity Discounts window. |
|
|
Discount5 |
Float |
Discount percent or amount entered in the fifth Discount Percent/Amount row on the Maintain Quantity Discounts window. |
|
|
PriceLevel1Selected |
Integer |
Price Level 1 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 1 is not selected (unchecked). 1 = Price Level 1 is selected (checked). Note: The Price Levels grid on the Maintain Quantity Discounts window lists only the price levels that are enabled in Inventory Item Defaults. (Maintain, Default Information, Inventory Items.) |
|
|
PriceLevel2Selected |
Integer |
Price Level 2 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 2 is not selected (unchecked). 1 = Price Level 2 is selected (checked). |
|
|
PriceLevel3Selected |
Integer |
Price Level 3 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 3 is not selected (unchecked). 1 = Price Level 3 is selected (checked). |
|
|
PriceLevel4Selected |
Integer |
Price Level 4 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 4 is not selected (unchecked). 1 = Price Level 4 is selected (checked). |
|
|
PriceLevel5Selected |
Integer |
Price Level 5 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 5 is not selected (unchecked). 1 = Price Level 5 is selected (checked). |
|
|
PriceLevel6Selected |
Integer |
Price Level 6 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 6 is not selected (unchecked). 1 = Price Level 6 is selected (checked). |
|
|
PriceLevel7Selected |
Integer |
Price Level 7 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 7 is not selected (unchecked). 1 = Price Level 7 is selected (checked). |
|
|
PriceLevel8Selected |
Integer |
Price Level 8 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 8 is not selected (unchecked). 1 = Price Level 8 is selected (checked). |
|
|
PriceLevel9Selected |
Integer |
Price Level 9 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 9 is not selected (unchecked). 1 = Price Level 9 is selected (checked). |
|
|
PriceLevel10Selected |
Integer |
Price Level 10 shown in the Price Levels grid on the Maintain Quantity Discounts window. 0 = Price Level 10 is not selected (unchecked). 1 = Price Level 10 is selected (checked). |