Field Listing for Table JOBINVOICESCHEDULE

Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:SEQUENCENO Type: INTEGER
Field:PLANNEDDATE Type: DATE
Field:PLANNEDPERCENTAGE Type: DOUBLE
Field:PLANNEDNETTVALUE Type: DOUBLE
Field:ACTUALDATE Type: DATE
Field:ACTUALPERCENTAGE Type: DOUBLE
Field:ACTUALNETTVALUE Type: DOUBLE
Field:INVOICENUMBER Type: VARCHAR Length: 15
Field:RETENTIONNETTVALUE Type: DOUBLE
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:COSTSTYLE Type: VARCHAR Length: 20
Field:COSTFIXEDVALUE Type: DOUBLE
Field:INVOICECOST Type: DOUBLE
Field:ACCOUNTINGSTYLE Type: VARCHAR Length: 20
Field:LINEINVOICENOTES Type: BLOB
Field:PRINTSTATUS Type: VARCHAR Length: 20
Field:LINEAPPROVED Type: BOOLEAN
Field:LINESTOPRINTONINVOICE Type: VARCHAR Length: 20
Field:PRINTLINESTOTAL Type: DOUBLE
Field:ADDITIONALFIELD_1 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_2 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_3 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_4 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_5 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_6 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_7 Type: VARCHAR Length: 100
Field:ADDITIONALFIELD_8 Type: VARCHAR Length: 100
Field:ADDITIONALDATEFIELD_1 Type: DATE
Field:ADDITIONALDATEFIELD_2 Type: DATE
Field:ADDITIONALDATEFIELD_3 Type: DATE
Field:ADDITIONALDATEFIELD_4 Type: DATE
Field:ADDITIONALDATEFIELD_5 Type: DATE
Field:ADDITIONALDATEFIELD_6 Type: DATE
Field:ADDITIONALDATEFIELD_7 Type: DATE
Field:ADDITIONALDATEFIELD_8 Type: DATE
Field:RETENTIONPERCENT1 Type: DOUBLE
Field:RETENTIONPERCENT2 Type: DOUBLE
Field:RETENTIONPLANNEDDATE1 Type: DATE
Field:RETENTIONPLANNEDDATE2 Type: DATE
Field:REVERSAL Type: BOOLEAN
Field:BILLINGCUSTOMER Type: VARCHAR Length: 50
Field:ORIGINALSCHEDULEID Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:ACTUALJOBVALUE Type: DOUBLE
Field:ACTUALJOBCOST Type: DOUBLE