Unbook Bookings File

Parent Previous Next



Main Booking (Orders) file called unbook.dbf (same as history file structure unbooh.dbf)


***** Table setup for UNBOOK *****



                    BM1                C(3)                Site Type

                    BM2                C(4)                Site Number

                    FR_TIME                C(8)                From Time (24 hr format eg. 10:00:00)

                    BM3                D                Arrival (From Date)

                    BM4                D                Departure (To Date)

                    TO_TIME                C(8)                To Time (24 hr format eg. 10:00:00)

                    BM5                N(3, 0)                Number of Adults

                    BM6                N(3, 0)                Number of Children

                    BM8                C(50)                Surname of Booking

                    BM9                C(50)                First Names of Booking

                    BM10                C(50)                Address Line 1

                    BM11                C(50)                Address Line 2

                    BM12                C(50)

                    BM69                C(4)

                    BM13                C(30)

                    BM20                C(30)

                    BM24                D

                    BM25                C(254)

                    BM26                N(2, 0)

                    BM28                L

                    BM29                D

                    BM32                C(15)

                    BM33                N(8, 0)

                    BM34                D

                    BM35                N(8, 2)

                    BM36                N(8, 2)

                    BM37                N(8, 2)

                    BM61                N(8, 2)

                    BM62                N(8, 2)

                    BM64                D

                    BM65                C(23)

                    BM66                N(2, 0)

                    BM67                D

                    BM68                N(2, 0)

                    BM70                C(30)

                    SIGNATURE        N(8, 0)

                    BM72                L

                    BM73                D

                    BM74                C(8)

                    BM75                L

                    BM76                D

                    BM77                C(8)

                    BM78                N(8, 0)

                    BM57                N(6, 2)

                    BOOMKEYS        C(20)

                    GENFLAG        L

                    CONCESSION        L

                    NOCONCESS        L

                    CATEGORY        N(3, 0)

                    LASTMETER        N(8, 0)

                    LPDATE                D

                    PENSIONER        C(15)

                    DISCPERCT        N(6, 2)

                    COUNTRY        C(20)

                    ALTTYPE        C(3)

                    DISCGIVEN        N(10, 2)

                    SCR1                N(12, 2)

                    SCR2                N(12, 2)

                    GPOPCODE        C(10)

                    GPDEF                C(50)

                    GPSWEEK        N(10, 2)

                    GPSDAY                N(10, 2)

                    GPSADULT        N(10, 2)

                    GPSCHLD        N(10, 2)

                    GPSCADULT        N(10, 2)

                    GPSCCHLD        N(10, 2)

                    GPLINK                N(8, 0)

                    GPMETHOD        N(1, 0)

                    GPFIXED                N(10, 2)

                    GPSITES        N(8, 0)

                    EMAIL                C(254)

                    LPDATE2        D

                    LASTMETER2        N(8, 0)

                    PWRPERIOD        N(1, 0)

                    PWRON                L NOT

                    PWRLASTVAL        N(10, 2)

                    PWRPCTVAR        N(7, 2)

                    TARIFF                C(10)

                    LASTTARIFF        C(10)

                    NEXTPREAD        D NOT

                    MMEXCLUDE        L NOT

                    BOOKING_NO        N(8, 0)

                    BOOKEVENT        C(20)

                    MOBILE                C(20)

                    VEHICOUNT        N(8, 0)

                    SCHARGETO        D

                    BKCANC                L

                    BKCANCDATE        D

                    BKCANCTIME        C(8)

                    BADDEBT        L

                    BADDEBTAC        C(10)

                    BKPROV                L

                    BKHOLD                T

                    BKUSER                C(30)

                    WLASTMETER        N(8, 0)

                    LWDATE                D

                    GLASTMETER        N(8, 0)

                    LGDATE                D

                    PHLASTM        N(8, 0)

                    PHLASTD        D

                    LINNENREQD        L

                    INFANTS                N(8, 0)

                    PETS                N(8, 0)

                    USAGE                N(1, 0)

                    BOOMSINGLE        L

                    CCARD                C(19)

                    CVALID                C(5)

                    CTYPE                C(10)

                    CHBANK                C(25)

                    CHBSB                C(7)

                    CHACCOUNT        C(12)

                    POWERED        L

                    SITESIZE        I

                    PERMANENT        L

                    BOOKREC        N(10, 0)

                    COMPNO        N(8, 0)

                    CUSTNO                N(10, 0)

                    PSTATEMENT        L

                    STATTYPE        I

                    CCVV                C(4)

                    MEMBER_NO        C(20)

                    GENDER                I

                    ACCESSED        T

                    USERNAME        C(10)

                    TRANDATE        T

                    WINDOWUSER        C(20)

                    MACHINE        C(50)

                    RECEIPTFORM        C(30)

                    EAORTOTAL        N(8, 2)


***** Index file definitions for UNBOOK *****

INDEX ON BM1+BM2+STR(999999-VAL(SYS(11,BM3)),7,0) TAG BOK1 COLLATE 'MACHINE'

INDEX ON SYS(11,BM3) TAG BM3 COLLATE 'MACHINE'

INDEX ON BM69 TAG POSTCODE COLLATE 'MACHINE'

INDEX ON VAL(SYS(11,BM3)) TAG FROMDATE COLLATE 'MACHINE'

INDEX ON VAL(SYS(11,BM4)) TAG TODATE COLLATE 'MACHINE'

INDEX ON VAL(SYS(11,BM29)) TAG PAIDTO COLLATE 'MACHINE'

INDEX ON BOOKREC TAG BOOKREC COLLATE 'MACHINE'

INDEX ON UPPER(BM8+BM9)+STR(99999999-BM78,8,0) TAG BOK2 COLLATE 'MACHINE'

INDEX ON STR(BM78,8,0) TAG BM78 COLLATE 'MACHINE'

INDEX ON UPPER(BM8) TAG BM8 COLLATE 'MACHINE'

INDEX ON BM2+BM1+SYS(11,BM3)+FR_TIME TAG NUMORDER COLLATE 'MACHINE'

INDEX ON BOOKEVENT+BM1+BM2 TAG BOOKEVENT COLLATE 'MACHINE'

INDEX ON BM1+BM2+SYS(11,BM3)+FR_TIME TAG SITEDTME COLLATE 'MACHINE'

INDEX ON SYS(11,BM3)+FR_TIME TAG FROMDTME COLLATE 'MACHINE'

INDEX ON CATEGORY TAG CATEGORY COLLATE 'MACHINE'

INDEX ON GPOPCODE TAG GPOPCODE COLLATE 'MACHINE'

INDEX ON BM1+BM2 TAG SITE COLLATE 'MACHINE'

INDEX ON CUSTNO TAG CUSTNO COLLATE 'MACHINE'


***** properties for UNBOOK fields *****

DBSETPROP('UNBOOK.BM1', 'Field', 'Caption', "Site")

DBSETPROP('UNBOOK.BM1', 'Field', 'Comment', "Site Type")

DBSETPROP('UNBOOK.BM1', 'Field', 'InputMask', "XXX")

DBSETPROP('UNBOOK.BM1', 'Field', 'Format', "XXX")


DBSETPROP('UNBOOK.BM2', 'Field', 'Caption', "Number")

DBSETPROP('UNBOOK.BM2', 'Field', 'Comment', "Site Number" + CHR(13) + "")

DBSETPROP('UNBOOK.BM2', 'Field', 'InputMask', "XXXX")

DBSETPROP('UNBOOK.BM2', 'Field', 'Format', "XXXX")

DBSETPROP('UNBOOK.BM2', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM2', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.FR_TIME', 'Field', 'Caption', "From Time")

DBSETPROP('UNBOOK.FR_TIME', 'Field', 'Comment', "From Time")

DBSETPROP('UNBOOK.FR_TIME', 'Field', 'InputMask', "99:99")

DBSETPROP('UNBOOK.FR_TIME', 'Field', 'Format', "99:99")

DBSETPROP('UNBOOK.FR_TIME', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.FR_TIME', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM3', 'Field', 'Caption', "From Date")

DBSETPROP('UNBOOK.BM3', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM3', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")

DBSETPROP('UNBOOK.BM4', 'Field', 'Caption', "To Date")

DBSETPROP('UNBOOK.BM4', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM4', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.TO_TIME', 'Field', 'Caption', "To Time")

DBSETPROP('UNBOOK.TO_TIME', 'Field', 'InputMask', "99:99")

DBSETPROP('UNBOOK.TO_TIME', 'Field', 'Format', "99:99")

DBSETPROP('UNBOOK.TO_TIME', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.TO_TIME', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM5', 'Field', 'Caption', "Adults")

DBSETPROP('UNBOOK.BM5', 'Field', 'Comment', "Number of Adults")

DBSETPROP('UNBOOK.BM5', 'Field', 'InputMask', "999")

DBSETPROP('UNBOOK.BM5', 'Field', 'Format', "999")

DBSETPROP('UNBOOK.BM5', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM5', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM6', 'Field', 'Caption', "Children")

DBSETPROP('UNBOOK.BM6', 'Field', 'Comment', "Number of Children")

DBSETPROP('UNBOOK.BM6', 'Field', 'InputMask', "999")

DBSETPROP('UNBOOK.BM6', 'Field', 'Format', "999")

DBSETPROP('UNBOOK.BM6', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM6', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM8', 'Field', 'Caption', "Surname")

DBSETPROP('UNBOOK.BM8', 'Field', 'Comment', "Surname account in name of...")

DBSETPROP('UNBOOK.BM8', 'Field', 'InputMask', "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX")

DBSETPROP('UNBOOK.BM8', 'Field', 'Format', "!T")

DBSETPROP('UNBOOK.BM8', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM8', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM9', 'Field', 'Caption', "First Names")

DBSETPROP('UNBOOK.BM9', 'Field', 'InputMask', "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX")

DBSETPROP('UNBOOK.BM9', 'Field', 'Format', "!T")

DBSETPROP('UNBOOK.BM9', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM9', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM10', 'Field', 'Caption', "Address")

DBSETPROP('UNBOOK.BM10', 'Field', 'Comment', "address line 1")

DBSETPROP('UNBOOK.BM10', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM10', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM11', 'Field', 'Comment', "Address line 2")

DBSETPROP('UNBOOK.BM11', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM11', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM12', 'Field', 'Comment', "address line 3  pc = bm69")

DBSETPROP('UNBOOK.BM12', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM12', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM69', 'Field', 'Caption', "Post Code")

DBSETPROP('UNBOOK.BM69', 'Field', 'InputMask', "9999")

DBSETPROP('UNBOOK.BM69', 'Field', 'Format', "9999")

DBSETPROP('UNBOOK.BM69', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM69', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM13', 'Field', 'Caption', "Phone Number")

DBSETPROP('UNBOOK.BM13', 'Field', 'Comment', "Phone number")

DBSETPROP('UNBOOK.BM13', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM13', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM20', 'Field', 'Caption', "Vehicle Registration Number")

DBSETPROP('UNBOOK.BM20', 'Field', 'Comment', "First vehicle details")

DBSETPROP('UNBOOK.BM20', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM20', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM24', 'Field', 'Caption', "Last LP Gas Charge Date")

DBSETPROP('UNBOOK.BM24', 'Field', 'Comment', "The date the last time LP GAS was charged for.")

DBSETPROP('UNBOOK.BM24', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM24', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM25', 'Field', 'Caption', "Comments")

DBSETPROP('UNBOOK.BM25', 'Field', 'Comment', "not on booking screen")

DBSETPROP('UNBOOK.BM25', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM25', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM26', 'Field', 'Caption', "Hold for days")

DBSETPROP('UNBOOK.BM26', 'Field', 'Comment', "not on booking screen")

DBSETPROP('UNBOOK.BM26', 'Field', 'InputMask', "99")

DBSETPROP('UNBOOK.BM26', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM26', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM28', 'Field', 'Caption', "Optomise Flag")

DBSETPROP('UNBOOK.BM28', 'Field', 'Comment', "Not used")

DBSETPROP('UNBOOK.BM28', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM28', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM29', 'Field', 'Caption', "Paid To")

DBSETPROP('UNBOOK.BM29', 'Field', 'Comment', "Paid to date")

DBSETPROP('UNBOOK.BM29', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM29', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM32', 'Field', 'Caption', "Pension Number")

DBSETPROP('UNBOOK.BM32', 'Field', 'Comment', "Used in power charging?")

DBSETPROP('UNBOOK.BM32', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM32', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM33', 'Field', 'Caption', "Last Receipt Number")

DBSETPROP('UNBOOK.BM33', 'Field', 'InputMask', "99999999")

DBSETPROP('UNBOOK.BM33', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM33', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM34', 'Field', 'Caption', "Last Power Charged Date")

DBSETPROP('UNBOOK.BM34', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM34', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM35', 'Field', 'Caption', "Sc:")

DBSETPROP('UNBOOK.BM35', 'Field', 'Comment', "Security Deposit Held")

DBSETPROP('UNBOOK.BM35', 'Field', 'InputMask', "99999.99")

DBSETPROP('UNBOOK.BM35', 'Field', 'Format', "99999.99")

DBSETPROP('UNBOOK.BM35', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM35', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM36', 'Field', 'Caption', "Bk:")

DBSETPROP('UNBOOK.BM36', 'Field', 'Comment', "Booking Deposit Held")

DBSETPROP('UNBOOK.BM36', 'Field', 'InputMask', "99999.99")

DBSETPROP('UNBOOK.BM36', 'Field', 'Format', "99999.99")

DBSETPROP('UNBOOK.BM36', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM36', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM37', 'Field', 'Caption', "Ky:")

DBSETPROP('UNBOOK.BM37', 'Field', 'Comment', "Key deposit held" + CHR(13) + "")

DBSETPROP('UNBOOK.BM37', 'Field', 'InputMask', "99999.99")

DBSETPROP('UNBOOK.BM37', 'Field', 'Format', "99999.99")

DBSETPROP('UNBOOK.BM37', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM37', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM61', 'Field', 'Caption', "Balance B/F")

DBSETPROP('UNBOOK.BM61', 'Field', 'Comment', "Outstanding Balance")

DBSETPROP('UNBOOK.BM61', 'Field', 'InputMask', "99999.99")

DBSETPROP('UNBOOK.BM61', 'Field', 'Format', "99999.99")

DBSETPROP('UNBOOK.BM61', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM61', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM62', 'Field', 'Caption', "Last Receipt Amount")

DBSETPROP('UNBOOK.BM62', 'Field', 'Comment', "Last Receipt Amount")

DBSETPROP('UNBOOK.BM62', 'Field', 'InputMask', "99999.99")

DBSETPROP('UNBOOK.BM62', 'Field', 'Format', "99999.99")

DBSETPROP('UNBOOK.BM62', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM62', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM63', 'Field', 'Caption', "Date of Last Receipt")

DBSETPROP('UNBOOK.BM63', 'Field', 'Comment', "Date of Last receipt")

DBSETPROP('UNBOOK.BM63', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM63', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM64', 'Field', 'Caption', "Date Booking Made")

DBSETPROP('UNBOOK.BM64', 'Field', 'Comment', "Date booking made")

DBSETPROP('UNBOOK.BM64', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM64', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM65', 'Field', 'Caption', "Extras")

DBSETPROP('UNBOOK.BM65', 'Field', 'Comment', "Extras String")

DBSETPROP('UNBOOK.BM65', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM65', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")

DBSETPROP('UNBOOK.BM66', 'Field', 'Caption', "No. of Gas Bottles")


DBSETPROP('UNBOOK.BM66', 'Field', 'Comment', "No. of Gas Bottles")

DBSETPROP('UNBOOK.BM66', 'Field', 'Format', "99")

DBSETPROP('UNBOOK.BM66', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM66', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM67', 'Field', 'Caption', "Due Date for Gas Bottle Return")

DBSETPROP('UNBOOK.BM67', 'Field', 'Comment', "Due Date for Gas Bottle Return" + CHR(13) + "")

DBSETPROP('UNBOOK.BM67', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM67', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM68', 'Field', 'Caption', "Period Number")

DBSETPROP('UNBOOK.BM68', 'Field', 'Comment', "Period Number of Booking n/a")

DBSETPROP('UNBOOK.BM68', 'Field', 'InputMask', "99")

DBSETPROP('UNBOOK.BM68', 'Field', 'Format', "99")

DBSETPROP('UNBOOK.BM68', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM68', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM70', 'Field', 'Caption', "Key Numbers")

DBSETPROP('UNBOOK.BM70', 'Field', 'Comment', "Key numbers in sequence string")

DBSETPROP('UNBOOK.BM70', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM70', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


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

DBSETPROP('UNBOOK.SIGNATURE', 'Field', 'Comment', "signature n/a")

DBSETPROP('UNBOOK.SIGNATURE', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.SIGNATURE', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM72', 'Field', 'Caption', "Checked In")

DBSETPROP('UNBOOK.BM72', 'Field', 'Comment', "Checked in flag")

DBSETPROP('UNBOOK.BM72', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM72', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM73', 'Field', 'Caption', "Checked In Date")

DBSETPROP('UNBOOK.BM73', 'Field', 'Comment', "Checked in date")

DBSETPROP('UNBOOK.BM73', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM73', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM74', 'Field', 'Caption', "Checked In Time")

DBSETPROP('UNBOOK.BM74', 'Field', 'Comment', "Checked in time")

DBSETPROP('UNBOOK.BM74', 'Field', 'InputMask', "99:99")

DBSETPROP('UNBOOK.BM74', 'Field', 'Format', "99:99")

DBSETPROP('UNBOOK.BM74', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM74', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM75', 'Field', 'Caption', "Checked Out ")

DBSETPROP('UNBOOK.BM75', 'Field', 'Comment', "Checked out flag")

DBSETPROP('UNBOOK.BM75', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM75', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM76', 'Field', 'Caption', "Checked Out Date")

DBSETPROP('UNBOOK.BM76', 'Field', 'Comment', "Checked out date")

DBSETPROP('UNBOOK.BM76', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM76', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM77', 'Field', 'Caption', "Checked Out Time")

DBSETPROP('UNBOOK.BM77', 'Field', 'Comment', "Checked out time")

DBSETPROP('UNBOOK.BM77', 'Field', 'InputMask', "99:99")

DBSETPROP('UNBOOK.BM77', 'Field', 'Format', "99:99")

DBSETPROP('UNBOOK.BM77', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM77', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM78', 'Field', 'Caption', "Booking Audit Number")

DBSETPROP('UNBOOK.BM78', 'Field', 'Comment', "Booking Audit Number")

DBSETPROP('UNBOOK.BM78', 'Field', 'InputMask', "99999999")

DBSETPROP('UNBOOK.BM78', 'Field', 'Format', "99999999")

DBSETPROP('UNBOOK.BM78', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM78', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")


DBSETPROP('UNBOOK.BM57', 'Field', 'Caption', "Market Code")

DBSETPROP('UNBOOK.BM57', 'Field', 'Comment', "Market Code  (was Total discounts given todate)")

DBSETPROP('UNBOOK.BM57', 'Field', 'InputMask', "99")

DBSETPROP('UNBOOK.BM57', 'Field', 'Format', "99")

DBSETPROP('UNBOOK.BM57', 'Field', 'DisplayClass', "booktxtbox")

DBSETPROP('UNBOOK.BM57', 'Field', 'DisplayClassLibrary', "c:\caravan2\libs\bookings.vcx")




Created with the Personal Edition of HelpNDoc: Easy to use tool to create HTML Help files and Help web sites