Column/parameter names dictionary
Collapse all
Expand all
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
See also
Server index