PurchaseOrdersHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PurchaseOrdersHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
PurchaseOrdersSeq int 4 √ null
OrderNumber int 4 √ null
BusinessUnitCode varchar 15 √ null
CreditorID int 4 √ null
OrderType char 1 √ null
OrderDate datetime 16,3 √ null
RequisitionNumber int 4 √ null
DeliveryPoint varchar 15 √ null
RequiredDate datetime 16,3 √ null
LastLine int 4 √ null
PrintPricesFlag bit 1 √ null
Status char 1 √ null
GLSubAllocationCode varchar 15 √ null
Urgency char 1 √ null
Amendment char 1 √ null
OrderHeader varchar 255 √ null
OrderTrailer varchar 255 √ null
OrderedBy varchar 80 √ null
OrderPrintedFlag bit 1 √ null
AuthoriserID int 4 √ null
AuthorisationStatus varchar 5 √ null
OrderedByComment varchar 2147483647 √ null
AuthoriserComment varchar 2147483647 √ null
OrderedByID int 4 √ null
OrderPricesIncludeTaxFlag bit 1 √ null
DepartmentAuthoriserID int 4 √ null
PurchaseOrderNotifyMethod varchar 9 √ null
ForeignCurrencyCode varchar 15 √ null
EmailOverride varchar 100 √ null
GLCode varchar 15 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PurchaseOrdersHistory Primary key Asc PurchaseOrdersHistorySeq
AK_PurchaseOrdersHistory_OrderNumber Performance Asc OrderNumber
AK_PurchaseOrdersHistory_PurchaseOrdersSeq Performance Asc PurchaseOrdersSeq