PurchaseOrderDetailsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PurchaseOrderDetailsHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
PurchaseOrderDetailsSeq int 4 √ null
OrderNumber int 4 √ null
OrderLine int 4 √ null
Description varchar 255 √ null
ItemCode varchar 15 √ null
SupplierItemCode varchar 50 √ null
GLCode varchar 15 √ null
GLSubAllocationCode varchar 15 √ null
OrderOrigin char 1 √ null
Status char 1 √ null
UnitCostOrdered decimal 14,4 √ null
ExtendedCostOrdered money 21,4 √ null
UnitCostSupplied decimal 14,4 √ null
ExtendedCostSupplied money 21,4 √ null
CreditorID int 4 √ null
InvoiceNumber varchar 20 √ null
InvoiceDate datetime 16,3 √ null
DeliveryDocketNumber varchar 20 √ null
DeliveryDate datetime 16,3 √ null
BackorderedAmount money 21,4 √ null
ReturnType char 1 √ null
OriginatingLine int 4 √ null
CreditorTransactionSeq int 4 √ null
PostingNumber int 4 √ null
PostingSource varchar 10 √ null
TaxCode varchar 5 √ null
TaxAmountOrdered money 21,4 √ null
TaxAmountSupplied money 21,4 √ null
RootOriginatingLine int 4 √ null
QuantityOrdered decimal 16,4 √ null
QuantitySupplied decimal 16,4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PurchaseOrderDetailsHistory Primary key Asc PurchaseOrderDetailsHistorySeq
AK_PurchaseOrderDetailsHistory_OrderNumber Performance Asc OrderNumber
AK_PurchaseOrderDetailsHistory_PurchaseOrderDetailsSeq Performance Asc PurchaseOrderDetailsSeq