Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
|||||
| dateCreated | DATETIME | 26 | null |
|
|
||||||
| dateLastModified | DATETIME | 26 | √ | null |
|
|
|||||
| extRefNumber | VARCHAR | 21 | √ | null |
|
|
|||||
| extTxnHash | VARCHAR | 16 | √ | null |
|
|
|||||
| extTxnId | VARCHAR | 36 | √ | null |
|
|
|||||
| extTxnLineId | VARCHAR | 36 | √ | null |
|
|
|||||
| poItemId | INT | 10 | √ | null |
|
|
|||||
| postPoId | INT | 10 | null |
|
|
||||||
| postedTotalCost | DECIMAL | 28,9 | √ | null |
|
|
|||||
| mcPostedTotalCost | DECIMAL | 28,9 | √ | null |
|
|
|||||
| qty | DECIMAL | 28,9 | null |
|
|
||||||
| receiptItemId | INT | 10 | √ | null |
|
|
|||||
| shipItemId | INT | 10 | √ | null |
|
|
|||||
| stdCost | DECIMAL | 28,9 | √ | null |
|
|
|||||
| receivedTotalCost | DECIMAL | 28,9 | 0.000000000 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK4g1wam0l8pq6u28vqoxevnhaa | Performance | Asc | shipItemId |
| FKgdrk308otm2h5j29bgiq3r1ln | Performance | Asc | postPoId |
| FKij8ivfkbmalljkkdfahj3yu8t | Performance | Asc | poItemId |
| FKp03lkg4xf890l9el812jkcvrx | Performance | Asc | receiptItemId |