Available in Sage 50 Quantum Accounting.

Quantity Discount Fields

See a list of Crystal Reports data (.DAT) files

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).