Column/parameter names dictionary

CollapseAll image

Collapse image Column/parameter names


Name  Total 
2002 1
2003 1
2004 1
AccountNumber 8
ACTION 2
ACTION_NAME 1
ActiveFlag 1
ActualCost 3
ActualEndDate 1
ActualResourceHrs 1
ActualStartDate 1
AdditionalContactInfo 3
Addr.Loc.City 1
Addr.Loc.CountryRegion 1
Addr.Loc.State 1
Addr.PostalCode 1
Addr.Type 1
AddressID 2
AddressLine1 6
AddressLine2 6
AddressType 3
AddressTypeID 2
AFFECTED_ROWS 2
aggregate 1
Analyze 1
AnnualRevenue 1
AnnualSales 1
APP_NAME 3
APPLICATION 1
asOf 1
AUDIT_ACTION_ID 1
AUDIT_LOG_DATA_ID 2
AUDIT_LOG_TRANSACTION_ID 3
Availability 1
AverageLeadTime 1
AverageRate 1
BankName 1
BikeFrame 1
BillOfMaterialsID 1
BillToAddressID 7
Bin 1
BirthDate 5
BOMLevel 1
Bonus 1
Brands 1
BusinessEntityID 44
BusinessType 1
CardNumber 1
CardType 1
CarrierTrackingNumber 8
CatalogDescription 1
Category 3
ChangeNumber 1
CheckDate 2
City 7
Class 3
COL_NAME 2
Color 4
Comment 9
Comments 1
CommissionPct 1
ComponentID 1
COMPUTER 1
ContactType 2
ContactTypeID 2
Copyright 1
CostLastYear 1
CostRate 1
CostYTD 1
CountryRegion 1
CountryRegionCode 5
CountryRegionName 6
Crankset 1
CreditCardApprovalCode 6
CreditCardID 8
CreditCardNumber 1
CreditRating 1
CultureID 3
CurrencyCode 2
CurrencyRateDate 1
CurrencyRateID 7
CurrentFlag 3
CustomerID 9
DATA_TYPE 2
DATABASE 2
Database Version 1
DatabaseLogID 1
DatabaseUser 1
DATE_FROM 3
DATE_TO 3
DateCreated 1
DateFirstPurchase 1
DaysToManufacture 3
DDL 1
ddl_report 1
Delete 1
DELETE_ALL 1
Demographics 4
Department 2
DepartmentID 2
Description 5
DESCRIPTION 1
Diagram 1
DiscontinuedDate 3
DiscountPct 3
Document 1
DocumentLevel 1
DocumentNode 2
DocumentSummary 1
DueDate 9
Edu.Degree 1
Edu.EndDate 1
Edu.GPA 1
Edu.GPAScale 1
Edu.Level 1
Edu.Loc.City 1
Edu.Loc.CountryRegion 1
Edu.Loc.State 1
Edu.Major 1
Edu.Minor 1
Edu.School 1
Edu.StartDate 1
Education 1
EMail 1
EmailAddress 8
EMailAddress 1
EmailAddressID 1
EmailPromotion 10
EMailSpecialInstructions 1
EMailTelephoneNumber 1
Emp.EndDate 1
Emp.FunctionCategory 1
Emp.IndustryCategory 1
Emp.JobTitle 1
Emp.Loc.City 1
Emp.Loc.CountryRegion 1
Emp.Loc.State 1
Emp.OrgName 1
Emp.Responsibility 1
Emp.StartDate 1
EmployeeID 1
EndDate 10
EndOfDayRate 1
EndTime 1
ErrorLine 1
ErrorLogID 2
ErrorMessage 1
ErrorNumber 1
ErrorProcedure 1
ErrorSeverity 1
ErrorState 1
ErrorTime 1
Event 1
EventDateTime 1
EventDetails 2
EventName 1
ExpMonth 1
ExpYear 1
FileExtension 1
FileName 1
FinishedGoodsFlag 3
FirstName 15
FolderFlag 1
Freight 8
FromCurrencyCode 1
FullName 1
Gender 7
Group 1
GroupByACTION 1
GroupByAPPLICATION 1
GroupByCOMPUTER 1
GroupByDate 1
GroupByMODIFIED_BY 1
GroupByTableName 1
GroupName 3
hex 1
HireDate 5
HomeAddressSpecialInstructions 1
HomeOwnerFlag 1
HOST_NAME 3
Identity 1
IllustrationID 2
index 1
Instructions 2
Internet 1
IsOnlyStateProvinceFlag 2
items_per_order 1
JobCandidateID 4
JobTitle 11
KEY1 1
KEY2 1
KEY3 1
KEY4 1
LaborHours 1
language 1
LargePhoto 1
LargePhotoFileName 1
LastName 15
LastReceiptCost 1
LastReceiptDate 1
LineTotal 2
ListPrice 4
LocalID 2
LocationID 4
LogId 1
LoginID 5
LotSize 1
MachineHours 1
MaintenanceDescription 1
MakeFlag 3
Manufacturer 1
MaritalStatus 7
Material 1
MAX_ROWS 1
MaxOrderQty 1
MaxQty 3
MiddleName 14
MinOrderQty 1
MinQty 3
MODIFIED_BY 4
MODIFIED_DATE 4
ModifiedDate 85
Name 32
Name.First 1
Name.Last 1
Name.Middle 1
Name.Prefix 1
Name.Suffix 1
NameStyle 4
NationalIDNumber 4
NEW_VALUE 5
NEW_VALUE_BLOB 1
NEW_VALUE_LONG 1
NoOfYears 1
NumberCarsOwned 1
NumberChildrenAtHome 1
NumberEmployees 1
Object 1
OBJECT_NAME 1
OBJECT_TYPE 1
Occupation 1
OLD_VALUE 5
OLD_VALUE_LONG 1
OLDER_THAN 1
OLDER_THAN_TYPE 1
OnlineOrderFlag 6
OnOrderQty 1
OperationSequence 1
OrderDate 8
OrderID 1
OrderQty 6
OrderTrackingID 1
OrganizationLevel 3
OrganizationNode 4
Owner 1
PasswordHash 1
PasswordSalt 1
PayFrequency 2
Pedal 1
PerAssemblyQty 1
PersonID 4
PersonType 5
PhoneNumber 7
PhoneNumberType 5
PhoneNumberTypeID 2
PictureAngle 1
PictureSize 1
PlannedCost 1
PostalCode 7
PostTime 1
PreferredVendorStatus 1
Primary 1
PRIMARY_KEY 3
PRIMARY_KEY_DATA 1
ProductAssemblyID 1
ProductCategoryID 2
ProductDescriptionID 2
ProductID 28
ProductLine 4
ProductModel 1
ProductModelID 8
ProductNumber 3
ProductPhotoID 3
ProductReviewID 1
ProductSubcategoryID 4
ProductURL 1
PurchaseOrderDetailID 1
PurchaseOrderID 2
PurchaseOrderNumber 6
PurchasingWebServiceURL 1
purge 1
Quantity 4
QuotaDate 1
Rate 2
RateChangeDate 2
Rating 1
ReasonType 1
REC_COUNT 1
ReceivedQty 1
ReferenceOrderID 2
ReferenceOrderLineID 2
RejectedQty 1
RemoveServer 1
ReorderPoint 3
Resume 1
ReviewDate 1
ReviewerName 1
Revision 1
RevisionNumber 5
RiderExperience 1
ROW_COUNT 3
rowguid 34
Saddle 1
SafetyStockLevel 3
SalariedFlag 1
SalesLastYear 3
SalesOrderDetailID 3
SalesOrderDetails 2
SalesOrderID 16
SalesOrderNumber 2
SalesPersonID 9
SalesQuota 3
SalesReasonID 2
SalesTaxRateID 1
SalesTerritory 1
SalesYTD 3
ScheduledEndDate 1
ScheduledStartDate 1
Schema 1
SCHEMA 1
ScrappedQty 1
ScrapReasonID 2
searchString 1
SellEndDate 3
SellStartDate 3
SetupHours 1
Shelf 1
Shift 1
ShiftID 2
ShipBase 1
ShipDate 8
ShipMethodID 9
ShipRate 1
ShipToAddressID 7
ShoppingCartID 1
ShoppingCartItemID 1
SickLeaveHours 5
Size 3
SizeUnitMeasureCode 3
Skills 1
SpatialLocation 1
SpecialOfferID 10
Specialty 1
SquareFeet 1
SSN 1
standard 1
StandardCost 4
StandardPrice 1
StartDate 11
StartProductID 2
StartTime 1
StateProvince 1
StateProvinceCode 2
StateProvinceID 4
StateProvinceName 6
Status 17
Step 1
StockedQty 2
StoreID 1
Street 1
string 1
Style 4
SubTotal 5
Suffix 12
Summary 1
SYSOBJ_ID 1
SystemInformationID 1
TABLE_NAME 3
TABLE_SCHEMA 2
TaxAmt 5
TaxRate 4
TaxType 1
TelephoneNumber 1
TelephoneSpecialInstructions 1
TerritoryGroup 1
TerritoryID 14
TerritoryName 1
Test column 2
Test column 3 1
Test column2 1
ThumbNailPhoto 1
ThumbnailPhotoFileName 1
Title 14
ToCurrencyCode 1
TotalChildren 1
TotalDue 3
TotalPurchaseYTD 1
TrackingEventID 3
TransactionDate 2
TransactionID 2
TransactionType 2
TSQL 1
Type 3
undo 1
UnitMeasureCode 3
UnitPrice 4
UnitPriceDiscount 3
useInflectional 1
UserName 1
useThesaurus 1
VacationHours 5
ValidFrom 4
ValidTo 4
value 1
Value 2
var 1
VendorID 1
VersionDate 1
View 1
WarrantyDescription 1
WarrantyPeriod 1
WebSite 1
Weight 3
WeightUnitMeasureCode 3
Wheel 1
WHERE 3
WorkOrderID 2
XmlEvent 1
YearlyIncome 1
YearOpened 1
Total: 430 column/parameter names

Collapse image See also


Server index