Field Listing for Table JOBHEADERCLOSE
Field: | JOBSELECTED | Type: | BOOLEAN |
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
Field: | ORDERDATE | Type: | DATE |
Field: | JOBCLOSEDATE | Type: | DATE |
Field: | ORDERDESCRIPTION | Type: | VARCHAR Length: 100 |
Field: | JOBTYPE | Type: | VARCHAR Length: 20 |
Field: | JOBSTYLE | Type: | VARCHAR Length: 20 |
Field: | INVOICESTYLE | Type: | VARCHAR Length: 20 |
Field: | REQUIREDDATE | Type: | DATE |
Field: | ORDERSTARTDATE | Type: | DATE |
Field: | ORDERFINISHDATE | Type: | DATE |
Field: | CUSTOMER | Type: | VARCHAR Length: 50 |
Field: | JOBCATEGORY | Type: | VARCHAR Length: 20 |
Field: | ORIGINALORDERCOST | Type: | DOUBLE |
Field: | ACTUALORDERCOST | Type: | DOUBLE |
Field: | ORIGINALORDERAMOUNT | Type: | DOUBLE |
Field: | TOBEINVOICEDNETTAMOUNT | Type: | DOUBLE |
Field: | INVOICEDNETTAMOUNT | Type: | DOUBLE |
Field: | CURRENTWIPVALUE | Type: | DOUBLE |
Field: | COSTCENTRECODE | Type: | VARCHAR Length: 50 |
Field: | OUTSTANDINGPORECEIPTS | Type: | INTEGER |
Field: | ALLOWEDTOCLOSE | Type: | BOOLEAN |
Field: | SITENAME | Type: | VARCHAR Length: 50 |
Field: | LASTINVOICEDATE | Type: | DATE |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |