| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
|
|
|
|
|
| TYPEID |
integer |
10 |
|
|
10 |
|
|
| STATUSID |
integer |
10 |
|
|
10 |
|
|
| NUM |
varchar |
25 |
|
|
|
|
|
| FROMLGID |
integer |
10 |
|
|
|
|
|
| FROMATTN |
varchar |
30 |
√ |
|
null |
|
|
| FROMNAME |
varchar |
41 |
√ |
|
null |
|
|
| FROMADDRESS |
varchar |
90 |
√ |
|
null |
|
|
| FROMCITY |
varchar |
30 |
√ |
|
null |
|
|
| FROMZIP |
varchar |
10 |
√ |
|
null |
|
|
| FROMSTATEID |
integer |
10 |
√ |
|
null |
|
|
| FROMCOUNTRYID |
integer |
10 |
√ |
|
null |
|
|
| SHIPTOLGID |
integer |
10 |
|
|
|
|
|
| SHIPTOATTN |
varchar |
30 |
√ |
|
null |
|
|
| SHIPTONAME |
varchar |
41 |
√ |
|
null |
|
|
| SHIPTOADDRESS |
varchar |
90 |
√ |
|
null |
|
|
| SHIPTOCITY |
varchar |
30 |
√ |
|
null |
|
|
| SHIPTOZIP |
varchar |
10 |
√ |
|
null |
|
|
| SHIPTOCOUNTRYID |
integer |
10 |
√ |
|
null |
|
|
| SHIPTOSTATEID |
integer |
10 |
√ |
|
null |
|
|
| MAINLOCATIONTAGID |
integer |
10 |
√ |
|
null |
|
|
| OWNERISFROM |
smallint |
5 |
√ |
|
1 |
|
|
| USERID |
integer |
10 |
|
|
1 |
|
|
| REVISIONNUM |
integer |
10 |
√ |
|
0 |
|
|
| DATELASTMODIFIED |
timestamp |
19 |
√ |
|
null |
|
|
| DATECREATED |
timestamp |
19 |
√ |
|
null |
|
|
| DATEISSUED |
timestamp |
19 |
√ |
|
null |
|
|
| DATECONFIRMED |
timestamp |
19 |
√ |
|
null |
|
|
| DATEFIRSTSHIP |
timestamp |
19 |
√ |
|
null |
|
|
| DATECOMPLETED |
timestamp |
19 |
√ |
|
null |
|
|
| DATESCHEDULED |
timestamp |
19 |
√ |
|
null |
|
|
| CARRIERID |
integer |
10 |
|
|
|
|
|
| NOTE |
blob sub_type 1 |
0 |
√ |
|
null |
|
|
Analyzed at Mon Jul 01 09:44 PDT 2013
|
