Table

Required Field(s)

Expected Value for UID

Addresses

Addresses.nFacilityUID

Facilities.cFacilityName

Addresses.cType

Addresses.cAddress1

Addresses.cCity

Addresses.cCountry

Note: The four required fields comprise the unique key per address.

Assets

Assets.cBarcode

Note: auto-generated if not specified

AssetEx

N/A

AssetLog

AssetLog.cBarcode

AssetServices

AssetServices.nServiceTypeUID

AssetServices.tMaintDate

Note: An Asset Scheduled Service is unique by nServiceTypeUID for each asset. The Maintenance date is required, but not part of the unique key.

CallSheets

CallSheets.tMaintDate

CallSheetEx

N/A

CallSheetPartsLink

N/A

CallSheetResults

CallSheetResults.cDescription

CallSheetStandardLink

CallSheetStandardLink.nAssetUID

Assets.cBarcode

Contacts

Contacts.cEmail2

Facilities

Facilities.cFacilityName

FacilityContactLink

Automatic, if both the facility and contact are specified in the record

FacilityEx

N/A

FacilityUserLink

N/A

Files

Files.cFileName

Files.cFileType

JobNumbers

JobNumbers.cJobOrderNumber

Labor

Labor.cLaborAccount

Parts

Parts.cPartNumber

Points

Points.cPointDescription

PointAmbients

N/A

PointExLogicals

N/A

PointExNumerics

N/A

PointExStrings

N/A

PointReadings

PointReadings.nReadingOrdinal

PointStatistics

N/A

PointTolerances

N/A

PointUncertainties

N/A

Procedures

Procedures.cProcedureName

Service Types

ServiceTypes.cServiceName (Service Type)

ServiceTypes.cServiceType (Service Mode)

ToolAssignments

ToolAssignments.tLoanDate

ToolAssignmentEx

N/A

Types

Types.cDescription

Types.cModelNumber

Types.nManufacturerUID

Facilities.cFacilityName

TypeProcedureDefaults

N/A

Units

Units.cBaseUnit

Users

Users.cUserName