Field Listing for Table RECURRINGINVOICES

Field:CONTRACTNO Type: INTEGER
Field:CONTRACTSTATUS Type: VARCHAR Length: 20
Field:CONTRACTCREATIONDATE Type: DATE
Field:CONTRACTDESCRIPTION Type: VARCHAR Length: 50
Field:CONTRACTTYPE Type: VARCHAR Length: 10
Field:CONTRACTSTYLE Type: VARCHAR Length: 30
Field:CONTRACTCATEGORY Type: VARCHAR Length: 20
Field:INVOICEFREQUENCY Type: INTEGER
Field:FREQUENCYTERM Type: VARCHAR Length: 10
Field:NUMBEROFFIXEDINVOICES Type: INTEGER
Field:PERINVOICEVALUE Type: DOUBLE
Field:CONTRACTSTARTDATE Type: DATE
Field:CONTRACTFINISHDATE Type: DATE
Field:CUSTOMER Type: VARCHAR Length: 50
Field:ASSETNAME Type: VARCHAR Length: 90
Field:ASSETCURRENTLOCATION Type: VARCHAR Length: 20
Field:CONTRACTNETTAMOUNT Type: DOUBLE
Field:CONTRACTTAXAMOUNT Type: DOUBLE
Field:CONTRACTTOTALAMOUNT Type: DOUBLE
Field:CONTRACTINVOICEDAMOUNT Type: DOUBLE
Field:CONTRACTREMAININGGAMOUNT Type: DOUBLE
Field:CONTRACTCOMMENTS Type: BLOB
Field:INVOICEREFERENCE Type: VARCHAR Length: 50
Field:INVOICEHEADERNOTES Type: BLOB
Field:LINENUMBER Type: INTEGER
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:LINEDESCRIPTION Type: VARCHAR Length: 255
Field:LINEUNIT Type: VARCHAR Length: 15
Field:INVOICEQTY Type: DOUBLE
Field:TAXCODE Type: VARCHAR Length: 10
Field:ANALYSISCODE Type: VARCHAR Length: 20
Field:LINEINVOICENOTES Type: BLOB
Field:RECURRINGCUSTOMER Type: VARCHAR Length: 50
Field:SITENAME Type: VARCHAR Length: 50
Field:CURRENCYCODE Type: VARCHAR Length: 3
Field:EXCHANGERATE Type: DOUBLE
Field:READINGNAME Type: VARCHAR Length: 50
Field:MAXSCHEDULEVALUE Type: DOUBLE
Field:FINANCIALCATEGORY Type: VARCHAR Length: 200
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30