{$page} 



Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 11100 - PO Detail
  * DetailType:
    * 0 - None
    * 1 - New Part
    * 2 - Catalog Item
    * 3 - Part
    * 4 - Expense
    * 5 - Notes
    * 6 - Other Material
    * 7 - Other Labor
    * 8 - Other Equipment
    * 9 - Other Outsource
    * 10 - Other Freight
    * 11 - Other Item



  



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| VendorTransDetail.AttachedOrderClassTypeID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderIDOV || bit ||   ||   ||
|| VendorTransDetail.AttachedOrderInvClassTypeID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderInvID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderItemClassTypeID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderItemID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderItemIDOV || bit ||   ||   ||
|| VendorTransDetail.AttachedOrderPartClassTypeID || int ||   ||   ||
|| VendorTransDetail.AttachedOrderPartID || int ||   ||   ||
|| VendorTransDetail.BillCostType || int ||   ||   ||
|| VendorTransDetail.BillID || int ||   ||   ||
|| VendorTransDetail.BillInventoryType || int ||   ||   ||
|| VendorTransDetail.BillItemID || int ||   ||   ||
|| VendorTransDetail.BillQuantity || float ||   ||   ||
|| VendorTransDetail.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| VendorTransDetail.Description || text ||   ||   ||
|| VendorTransDetail.DetailType || int ||   ||   ||
|| VendorTransDetail.ExpenseClassTypeID || int ||   ||   ||
|| VendorTransDetail.ExpenseID || int ||   ||   ||
|| VendorTransDetail.GLDepartmentID || int ||   ||   ||
|| VendorTransDetail.GLDepartmentIDOV || bit ||   ||   ||
|| VendorTransDetail.ID || int || Primary Key for the Table ||   ||
|| VendorTransDetail.IsActive || bit || Not Used for This Table ||   ||
|| VendorTransDetail.IsSystem || bit || Used to Mark Required Records ||   ||
|| VendorTransDetail.ItemClassTypeID || int || 12076 - CatalogItem \\ 12014 - Part ||   ||
|| VendorTransDetail.ItemID || int || ID from the Catalog Items table ||   ||
|| VendorTransDetail.ItemName || varchar(50) ||   ||   ||
|| VendorTransDetail.LineItemIndex || int ||   ||   ||
|| VendorTransDetail.LineItemNumber || varchar(50) ||   ||   ||
|| VendorTransDetail.ModifiedByComputer || varchar(25) || HostName of computer that last modified this record ||   ||
|| VendorTransDetail.ModifiedByUser || varchar(25) || Windows User who last modified this record ||   ||
|| VendorTransDetail.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| VendorTransDetail.PackingSize || float ||   ||   ||
|| VendorTransDetail.POID || int ||   ||   ||
|| VendorTransDetail.POItemID || int ||   ||   ||
|| VendorTransDetail.POQuantity || float ||   ||   ||
|| VendorTransDetail.Quantity || float ||   ||   ||
|| VendorTransDetail.RDID || int ||   ||   ||
|| VendorTransDetail.RDInventoryType || int ||   ||   ||
|| VendorTransDetail.RDItemID || int ||   ||   ||
|| VendorTransDetail.RDQuantity || float ||   ||   ||
|| VendorTransDetail.SeqID || int ||   ||   ||
|| VendorTransDetail.SKU || text ||   ||   ||
|| VendorTransDetail.StageClassTypeID || int ||   ||   ||
|| VendorTransDetail.StageID || int ||   ||   ||
|| VendorTransDetail.StationClassTypeID || int ||   ||   ||
|| VendorTransDetail.StationID || int || The current status of the line item. || [[sql_structure_-_station_table|Station]].ID ||
|| VendorTransDetail.StoreID || int || Not Used. ||   ||
|| VendorTransDetail.TotalPrice || float ||   ||   ||
|| VendorTransDetail.TransHeaderClassTypeID || int ||   ||   ||
|| VendorTransDetail.TransHeaderID || int ||   ||   ||
|| VendorTransDetail.TransHeaderNumber || int ||   ||   ||
|| VendorTransDetail.TransPartClassTypeID || int ||   ||   ||
|| VendorTransDetail.TransPartID || int ||   ||   ||
|| VendorTransDetail.UnitID || int ||   ||   ||
|| VendorTransDetail.UnitPrice || float ||   ||   ||
|| VendorTransDetail.UnitText || varchar(50) ||   ||   ||
|| VendorTransDetail.VariationID || int ||   ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]