Field Listing for Table INVENTORYCOUNTS
| Field: | COUNTNO | Type: | INTEGER |
| Field: | COUNTREFERENCE | Type: | VARCHAR Length: 50 |
| Field: | COUNTSTATUS | Type: | VARCHAR Length: 20 |
| Field: | COUNTDATE | Type: | DATE |
| Field: | POSTEDDATE | Type: | DATE |
| Field: | FROMWAREHOUSE | Type: | VARCHAR Length: 20 |
| Field: | TOWAREHOUSE | Type: | VARCHAR Length: 20 |
| Field: | FROMLOCATION | Type: | VARCHAR Length: 20 |
| Field: | TOLOCATION | Type: | VARCHAR Length: 20 |
| Field: | FROMCATEGORY | Type: | VARCHAR Length: 20 |
| Field: | TOCATEGORY | Type: | VARCHAR Length: 20 |
| Field: | FROMSUBCATEGORY | Type: | VARCHAR Length: 20 |
| Field: | TOSUBCATEGORY | Type: | VARCHAR Length: 20 |
| Field: | FROMITEM | Type: | VARCHAR Length: 50 |
| Field: | TOITEM | Type: | VARCHAR Length: 50 |
| Field: | CYCLECODE | Type: | VARCHAR Length: 10 |
| Field: | ABCCLASS | Type: | VARCHAR Length: 1 |
| Field: | INCNOCURRENTTRANS | Type: | BOOLEAN |
| Field: | INVENTORYCOUNTSTYLE | Type: | VARCHAR Length: 100 |
| Field: | COUNTNOTES | Type: | BLOB |
| Field: | SITENAME | Type: | VARCHAR Length: 50 |
| Field: | LOCATIONGROUP | Type: | VARCHAR Length: 20 |
| Field: | FROMLOCATIONSEQUENCE | Type: | INTEGER |
| Field: | TOLOCATIONSEQUENCE | Type: | BOOLEAN |
| Field: | PRIMARYSUPPLIER | Type: | VARCHAR Length: 50 |
| Field: | MOBILITYTEAM | Type: | VARCHAR Length: 20 |
| Field: | RECORDEDNOTES | Type: | BLOB |
| Field: | PREVENTMOBILITYPOSTING | Type: | BOOLEAN |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |