Field Listing for Table PURCHASETYPES
| Field: | ORDERTYPE | Type: | VARCHAR Length: 20 |
| Field: | TYPEDESCRIPTION | Type: | VARCHAR Length: 50 |
| Field: | ORDERSTATUS | Type: | VARCHAR Length: 20 |
| Field: | ORDERNUMBERING | Type: | VARCHAR Length: 10 |
| Field: | ORDERPREFIX | Type: | VARCHAR Length: 5 |
| Field: | RESTRICTTOSITENAME | Type: | VARCHAR Length: 50 |
| Field: | DEFAULTFORSITE | 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 |