UNRATE

***** Table setup for UNRATE *****

TABLE 'UNRATE.DBF' NAME 'UNRATE'

                    RT1 C(3)

                    RT2 D

                    RT3 D

                    RT4 N(14, 10)

                    RT5 C(1)

                    RT6 N(3, 0)

                    RT7 N(2, 0)

                    RT8 N(6, 2)

                    RT9 N(6, 2)

                    RT10 N(1, 0)

                    RT11 N(3, 0)

                    RT12 C(60)

                    RT13 N(3, 0)

                    RT14 N(14, 10)

                    SIGNATURE N(2, 0)

                    WKDAYRATE N(14, 10)

                    NDAYCODE C(3)

                    NDAYTYPE C(1)

                    NDAYTAX N(14, 10)

                    NDAYINC N(14, 10)

                    DDAYTAX N(14, 10)

                    DDAYINC N(14, 10)

                    SDAYTAX N(14, 10)

                    SDAYINC N(14, 10)

                    WDAYTAX N(14, 10)

                    WDAYINC N(14, 10)

                    GLLINK1 C(9)

                    GLLINK2 C(9)

                    GLLINK3 C(9)

                    DFORECOLOR N(9, 0)

                    DBACKCOLOR N(9, 0)

                    BOOKREC N(10, 0)

***** each index for UNRATE *****

INDEX ON RT1+SYS(11,RT2) TAG RATELIST COLLATE 'MACHINE'

INDEX ON RT1+DTOC(RT2,1) TAG RATE COLLATE 'MACHINE'

***** Change properties for UNRATE *****

DBSETPROP('UNRATE.RT1', 'Field', 'Caption', "Type")

DBSETPROP('UNRATE.RT1', 'Field', 'Comment', "Site Type and Start Date are used to identify the rate. A Blank Rate is the default rate." + CHR(13) + "")

DBSETPROP('UNRATE.RT1', 'Field', 'InputMask', "XXX")

DBSETPROP('UNRATE.RT1', 'Field', 'Format', "!T")

DBSETPROP('UNRATE.RT2', 'Field', 'Caption', "Start Date")

DBSETPROP('UNRATE.RT2', 'Field', 'Comment', "Blank if Base rate")

DBSETPROP('UNRATE.RT3', 'Field', 'Caption', "End Date")

DBSETPROP('UNRATE.RT3', 'Field', 'Comment', "Blank if Base rate" + CHR(13) + "")

DBSETPROP('UNRATE.RT4', 'Field', 'Caption', "Daily Rate")

DBSETPROP('UNRATE.RT5', 'Field', 'Caption', "n/a")

DBSETPROP('UNRATE.RT6', 'Field', 'Caption', "Persons")

DBSETPROP('UNRATE.RT6', 'Field', 'Comment', "Persons at this rate")

DBSETPROP('UNRATE.RT6', 'Field', 'InputMask', "999")

DBSETPROP('UNRATE.RT7', 'Field', 'Caption', "n/a")

DBSETPROP('UNRATE.RT7', 'Field', 'InputMask', "99")

DBSETPROP('UNRATE.RT8', 'Field', 'Caption', "Daily Extra Adults Rate")

DBSETPROP('UNRATE.RT8', 'Field', 'InputMask', "999.99")

DBSETPROP('UNRATE.RT9', 'Field', 'Caption', "Daily Extra Child Rate")

DBSETPROP('UNRATE.RT9', 'Field', 'InputMask', "999.99")

DBSETPROP('UNRATE.RT10', 'Field', 'Caption', "Extras Free Days Per Week")

DBSETPROP('UNRATE.RT10', 'Field', 'Comment', "Free Days per 7 days for extra persons")

DBSETPROP('UNRATE.RT10', 'Field', 'InputMask', "9")

DBSETPROP('UNRATE.RT11', 'Field', 'Caption', "Minimum Booking Days")

DBSETPROP('UNRATE.RT11', 'Field', 'Comment', "Not Used")

DBSETPROP('UNRATE.RT11', 'Field', 'InputMask', "999")

DBSETPROP('UNRATE.RT12', 'Field', 'Caption', "Comment")

DBSETPROP('UNRATE.RT12', 'Field', 'Comment', "Comment description of rate")

DBSETPROP('UNRATE.RT13', 'Field', 'Caption', "Days")

DBSETPROP('UNRATE.RT13', 'Field', 'Comment', "End date - start date (used?)")

DBSETPROP('UNRATE.RT13', 'Field', 'InputMask', "999")

DBSETPROP('UNRATE.RT14', 'Field', 'Caption', "Weekly Charge")

DBSETPROP('UNRATE.RT14', 'Field', 'Comment', "Weekly Rate")

DBSETPROP('UNRATE.RT14', 'Field', 'InputMask', "999.9999999999")

DBSETPROP('UNRATE.SIGNATURE', 'Field', 'Caption', "n/a")

DBSETPROP('UNRATE.SIGNATURE', 'Field', 'Comment', "Not Used")

Created with the Personal Edition of HelpNDoc: Easily create Qt Help files