| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
|
|
|
|
|
| STATUSID |
integer |
10 |
|
|
|
|
|
| ORDERTYPEID |
integer |
10 |
|
|
|
|
|
| ORDERID |
integer |
10 |
√ |
|
0 |
|
|
| TYPEID |
integer |
10 |
|
|
|
|
|
| REFID |
integer |
10 |
√ |
|
0 |
|
|
| REFITEMID |
integer |
10 |
√ |
|
0 |
|
|
| DATECREATED |
timestamp |
19 |
√ |
|
'NOW' |
|
|
| DATEPOSTED |
timestamp |
19 |
√ |
|
null |
|
|
| SERIALNUM |
varchar |
30 |
√ |
|
null |
|
|
| TXNID |
varchar |
36 |
√ |
|
null |
|
|
| EDITSEQUENCE |
varchar |
16 |
√ |
|
null |
|
|
| REFNUMBER |
varchar |
20 |
√ |
|
null |
|
|
| TXNLINEID |
varchar |
36 |
√ |
|
null |
|
|
| QUANTITY |
double precision |
15 |
√ |
|
0 |
|
|
| AMOUNT |
double precision |
15 |
√ |
|
0 |
|
|
| CUSTOMERID |
integer |
10 |
√ |
|
null |
|
|
Analyzed at Mon Jul 01 09:44 PDT 2013
|
