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 |