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.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
You could leave a comment if you were logged in.