Field Listing for Table JOBHEADERRETENTIONS
Field: | ORDERNUMBER | Type: | VARCHAR Length: 15 |
Field: | ORIGINATINGINVOICE | Type: | VARCHAR Length: 15 |
Field: | RETENTIONPERCENT | Type: | DOUBLE |
Field: | RETENTIONPLANDATE | Type: | DATE |
Field: | RETENTIONACTUALDATE | Type: | DATE |
Field: | RETENTIONPLANVALUE | Type: | DOUBLE |
Field: | RETENTIONPLANTAX | Type: | DOUBLE |
Field: | RETENTIONACTUALPERCENT | Type: | DOUBLE |
Field: | RETENTIONACTUALVALUE | Type: | DOUBLE |
Field: | RETENTIONACTUALTAX | Type: | DOUBLE |
Field: | RETENTIONINVOICENO | Type: | VARCHAR Length: 15 |
Field: | INVOICEPRINTSTATUS | Type: | VARCHAR Length: 20 |
Field: | RETENTIONSTATUS | Type: | VARCHAR Length: 20 |
Field: | RETENTIONLINENUMBER | Type: | INTEGER |
Field: | RETENTIONLINECODE | Type: | VARCHAR Length: 50 |
Field: | RETENTIONLINEUNIT | Type: | VARCHAR Length: 15 |
Field: | RETENTIONDESCRIPTION | Type: | VARCHAR Length: 255 |
Field: | RETENTIONTAXCODE | Type: | VARCHAR Length: 10 |
Field: | RETENTIONANALYSISGROUP | Type: | VARCHAR Length: 20 |
Field: | RETENTIONNOTES | Type: | BLOB |
Field: | RETENTIONMULTIPLE | Type: | INTEGER |
Field: | JOBINVOICESCHEDULEID | 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 |