Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| OrderNumber | int | 4 | ((0)) |
|
|
|||||
| OrderLine | int | 4 | ((0)) |
|
|
|||||
| Description | varchar | 255 | ('') |
|
|
|||||
| ItemCode | varchar | 15 | ('') |
|
|
|||||
| SupplierItemCode | varchar | 50 | ('') |
|
|
|||||
| GLCode | varchar | 15 | ('') |
|
|
|||||
| GLSubAllocationCode | varchar | 15 | ('') |
|
|
|||||
| OrderOrigin | char | 1 | ('') |
|
|
|||||
| Status | char | 1 | ('') |
|
|
|||||
| UnitCostOrdered | decimal | 14,4 | ((0)) |
|
|
|||||
| ExtendedCostOrdered | money | 21,4 | ((0)) |
|
|
|||||
| UnitCostSupplied | decimal | 14,4 | ((0)) |
|
|
|||||
| ExtendedCostSupplied | money | 21,4 | ((0)) |
|
|
|||||
| CreditorID | int | 4 | ((0)) |
|
|
|||||
| InvoiceNumber | varchar | 20 | ('') |
|
|
|||||
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
||||
| DeliveryDocketNumber | varchar | 20 | ('') |
|
|
|||||
| DeliveryDate | datetime | 16,3 | √ | null |
|
|
||||
| BackorderedAmount | money | 21,4 | ((0)) |
|
|
|||||
| ReturnType | char | 1 | ('') |
|
|
|||||
| OriginatingLine | int | 4 | ((0)) |
|
|
|||||
| CreditorTransactionSeq | int | 4 | ((0)) |
|
|
|||||
| PostingNumber | int | 4 | ((0)) |
|
|
|||||
| PostingSource | varchar | 10 | ('') |
|
|
|||||
| TaxCode | varchar | 5 | ('') |
|
|
|||||
| TaxAmountOrdered | money | 21,4 | ((0)) |
|
|
|||||
| TaxAmountSupplied | money | 21,4 | ((0)) |
|
|
|||||
| RootOriginatingLine | int | 4 | ((0)) |
|
|
|||||
| QuantityOrdered | decimal | 16,4 | ((0)) |
|
|
|||||
| QuantitySupplied | decimal | 16,4 | ((0)) |
|
|
|||||
| PurchaseOrderDetailsSeq | int identity | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PurchaseOrderDetails | Primary key | Asc/Asc | OrderNumber + OrderLine |
| AK_PurchaseOrderDetails_CreditorTransactionSeq | Performance | Asc | CreditorTransactionSeq |
| AK_PurchaseOrderDetails_GLCode | Performance | Asc | GLCode |
| AK_PurchaseOrderDetails_ItemCode | Performance | Asc | ItemCode |
| AK_PurchaseOrderDetails_PostingNumber | Performance | Asc | PostingNumber |
| AK_PurchaseOrderDetails_PurchaseOrderDetailsSeq | Must be unique | Asc | PurchaseOrderDetailsSeq |
Relationships
Close relationships within degrees of separation
