Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PurchaseOrdersRequisitionHoldSeq | int identity | 4 | √ | null |
|
|
||
| OrderNumber | int | 4 | √ | ((0)) |
|
|
||
| OrderCreatedDate | datetime | 16,3 | √ | (getdate()) |
|
|
||
| OrderCreatedBy | varchar | 50 | √ | null |
|
|
||
| OrderModifiedDate | datetime | 16,3 | √ | (getdate()) |
|
|
||
| OrderModifiedBy | varchar | 50 | √ | ('') |
|
|
||
| BusinessUnitCode | varchar | 15 | √ | ('') |
|
|
||
| CreditorID | int | 4 | √ | ((0)) |
|
|
||
| OrderType | char | 1 | √ | ('') |
|
|
||
| OrderDate | datetime | 16,3 | √ | null |
|
|
||
| RequisitionNumber | int | 4 | √ | ((0)) |
|
|
||
| DeliveryPoint | varchar | 15 | √ | ('') |
|
|
||
| RequiredDate | datetime | 16,3 | √ | null |
|
|
||
| LastLine | int | 4 | √ | ((0)) |
|
|
||
| PrintPricesFlag | bit | 1 | √ | ((1)) |
|
|
||
| Status | char | 1 | √ | ('') |
|
|
||
| GLCode | varchar | 15 | √ | ('') |
|
|
||
| GLSubAllocationCode | varchar | 15 | √ | ('') |
|
|
||
| Urgency | char | 1 | √ | ('') |
|
|
||
| Amendment | char | 1 | √ | ('') |
|
|
||
| OrderHeader | varchar | 255 | √ | ('') |
|
|
||
| OrderTrailer | varchar | 255 | √ | ('') |
|
|
||
| OrderedBy | varchar | 80 | √ | ('') |
|
|
||
| OrderPrintedFlag | bit | 1 | √ | ((0)) |
|
|
||
| AuthoriserID | int | 4 | √ | ((0)) |
|
|
||
| AuthorisationStatus | varchar | 5 | √ | ('') |
|
|
||
| OrderedByComment | varchar | 2147483647 | √ | null |
|
|
||
| AuthoriserComment | varchar | 2147483647 | √ | null |
|
|
||
| OrderedByID | int | 4 | √ | ((0)) |
|
|
||
| OrderPricesIncludeTaxFlag | bit | 1 | √ | ((1)) |
|
|
||
| DepartmentAuthoriserID | int | 4 | √ | null |
|
|
||
| PurchaseOrderNotifyMethod | varchar | 9 | √ | ('') |
|
|
||
| ForeignCurrencyCode | varchar | 15 | √ | ('') |
|
|
||
| EmailOverride | varchar | 100 | √ | ('') |
|
|
||
| LineItemsXML | varchar | 2147483647 | √ | ('') |
|
|
||
| PurchaseOrdersRequisitionHoldDate | datetime | 16,3 | √ | (getdate()) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PurchaseOrdersRequisitionHold | Primary key | Asc | PurchaseOrdersRequisitionHoldSeq |
| AK_PurchaseOrdersRequisitionHold_OrderedByID | Performance | Asc/Asc | OrderedByID + PurchaseOrdersRequisitionHoldSeq |