DD Table Name | DD Column Name | Data Type | Constraint | Definition |
|---|
AnticipatedWorkorder | TrackingNumber | int | null | |
AnticipatedWorkorder | SuscriberId | int | not null | |
AnticipatedWorkorder | ScheduleId | int | not null | |
AnticipatedWorkorder | GroupId | int | not null | |
AnticipatedWorkorder | LocationId | int | not null | |
AnticipatedWorkorder | AssignedLocationId | int | not null | |
AnticipatedWorkorder | ContractId | int | null | |
AnticipatedWorkorder | Trade | nvarchar(255) | null | |
AnticipatedWorkorder | Category | nvarchar(255) | null | |
AnticipatedWorkorder | Priority | nvarchar(255) | null | |
AnticipatedWorkorder | NTE | money | null | |
AnticipatedWorkorder | ProviderId | int | null | |
AnticipatedWorkorder | Description | nvarchar(max) | null | |
AnticipatedWorkorder | CreatedDate | datetime | not null | |
AnticipatedWorkorder | ScheduledDate | datetime | not null | |
AnticipatedWorkorder | ExpirationDate | datetime | null | |
AnticipatedWorkorder | ServiceNumber | int | not null | |
AnticipatedWorkorder | WoLength | int | null | |
AnticipatedWorkorder | ID | int | PK, not null | |
AnticipatedWorkorder_Frequency | SubscriberId | int | null | |
AnticipatedWorkorder_Frequency | GroupId | int | not null | |
AnticipatedWorkorder_Frequency | ServiceId | int | not null | |
AnticipatedWorkorder_Frequency | FrequencyType | varchar(50) | null | |
AnticipatedWorkorder_Frequency | NumberOfDaysPerWeek | int | null | |
AnticipatedWorkorder_Frequency | WeekInterval | int | null | |
AnticipatedWorkorder_Frequency | NumberOfMonthsPerYear | int | null | |
AnticipatedWorkorder_Frequency | StartOn | datetime | null | |
AnticipatedWorkorder_Frequency | StopOn | datetime | null | |
AnticipatedWorkorder_Frequency | ID | int | PK, not null | |
AnticipatedWorkorder_Frequency | CreatedDateInDataDirect | datetime | null | |
AnticipatedWorkorder_Frequency | UpdatedDateInDataDirect | datetime | null | |
Asset | Id | int | PK, not null | System Generated Sequence Number. |
Asset | AssetId | int | not null | system generated unique identifier for the Asset. |
Asset | EffectiveStartDate | datetime | not null | Slowly changing dimension table for Asset - Effective Start date of the record for an AssetID |
Asset | EffectiveEndDate | datetime | null | Slowly changing dimension table for Asset - Effective End Date of the record for an AssetID |
Asset | LocationId | int | not null | Service Channel Unique Identifier for the Location of the facility where the Asset is Installed. |
Asset | StoreId | varchar(50) | null | Store Number of the location as entered by the Client in ServiceChannel |
Asset | IsAssetActive | bit | null | By default '1' and means that this asset is active in the application and can be assigned a work order. |
Asset | TagId | nvarchar(100) | null | Random unique identifier within a location entered by the client. It can be auto generated by the application if the customer selects "auto generate tag id" setting in AssetType. |
Asset | AssetType | nvarchar(200) | null | Name of the Asset Type entered by the client in Asset Module |
Asset | Brand | nvarchar(300) | null | Manufacturer Brand Name of the asset as selected from the drop down or as uploaded by the client in Asset Module. |
Asset | ModelNo | nvarchar(300) | null | Model number of the Asset as entered or uploaded by the client in Asset Module. |
Asset | SerialNo | nvarchar(300) | null | Serial Number (Manufacturer's unique identifier) as entered or uploaded by the client in Asset Module. |
Asset | InstallDate | datetime | null | Date when the asset was installed at its corresponding location, as entered or uploaded by the client in Asset Module. Captured in EST timezone. |
Asset | PurchaseDate | datetime | null | Original purchase date of the asset as entered or uploaded by the client in Asset Module. |
Asset | Condition | int | null | 0 = 'Broken', 25 = 'poor', 50 = 'Average', 75- = Good', 100 = 'Excellent', as selected by the client from the drop down menu |
Asset | WarrantyPeriod | int | null | Manufacturer warranty period in months as entered/uploaded by the client in Asset |
Asset | WarrantyStartsFromInstallDate | bit | null | 1 means 'warranty starts from Install date' and 0 means 'Warranty starts from purchase date' |
Asset | WarrantyExpirationDate | datetime | null | Date Calculated by adding the warranty period ( in months) from Install date or purchase date |
Asset | WarrantyCategory | nvarchar(50) | null | A work order category as defined by the admin categories configuration. |
Asset | DeactivatedDate | datetime | null | If Asset is no longer active, this date is populated with the date when Asset is Retired or Last modified. |
Asset | LifeExpectancy | int | null | Asset life expectancy (can be represented in months or years as defined by the client). This value is also entered or uploaded by the client in Asset Module |
Asset | OriginalValue | money | null | Used to determine the original cost of the Asset ,as entered or uploaded by the client. Can be used to calculate the value of the asset based on its life expectancy. |
Asset | EnergyEfficiency | nvarchar(300) | null | User defined value to measure the energy consumption of the asset. Value Entered or uploaded by the client in Asset Module. |
Asset | Capacity | nvarchar(300) | null | User defined value that allows the client to indicate the capacity of the asset. |
Asset | Note | nvarchar(2000) | null | Decommissioned Field. Not used by the application. |
Asset | AssetAdditionalTrade | nvarchar(100) | null | Decommissioned field , Client no longer can add trades at the asset level. Clients can enter/ modify the trades or choose from a list of drop down values at the Asset Type level. |
Asset | QRCode | nvarchar(300) | null | QR Code or Bar Code that is scanned from the Asset. Entered/uploaded by the client. |
Asset | AssetTypeId | int | null | System Generated unique identifier for the Asset Type in the application. |
Asset | AssetParentId | int | null | ID of Parent Asset(Circuit and component relations). If Asset is created as a component or circuit then it will have Parent Asset. |
Asset | UsesRefrigerant | int | null | Means that asset uses refrigerant. The Value is entered/uploaded at the time of asset creation and cannot be changed .1-Rack, 2- Connected to the rack, 3-self contained, 4- other |
Asset | RefrigerantPurpose | nvarchar(50) | null | Selected from a drop down at the Asset Type. List of values 'Circuit,Comfort Cooling (AC),Commercial Refrigeration,Industrial Refrigeration,Leak Detector,Other types of Refrigerated Asset' |
Asset | HasCircuits | bit | null | If an Asset has child assets then hasCircuits = 1 |
Asset | IsCircuit | bit | null | This is an asset type property to create a circuit asset type. By default it is '0' |
Asset | RefrigerantLastChargeId | int | null | System generated unique identifier that relates to last charge transaction of the Asset. Applicable only for Assets that use refrigerant. |
Asset | Description | nvarchar(50) | null | short asset description. This value can only be entered in the asset detail. |
Asset | TradeId | int | null | Decommissioned at the Asset Level. Must use Trade ID linked with the Asset Type. Trade ID is system generated unique identifier for the Trade i.e selected from the drop down. |
Asset | ScPrimaryTrade | nvarchar(50) | null | Unique name for the subscriber trade in servicechannel |
Asset | AssetCreatedBy | int | null | Unique identifier in ServiceChannel for the login( username) of the user who uploaded the assets. |
Asset | AssetCreatedDate | datetime | null | Date when the assets were entered or uploaded in Asset Module. Captured in EST timezone. |
Asset | AssetModifiedBy | int | null | Unique identifier in ServiceChannel for the login( username) of the user who modified the assets. |
Asset | AssetModifiedDate | datetime | null | Date when the asset was modified , captured in EST time zone. |
Asset | CreatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the user creating this record. |
Asset | CreatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was inserted in this table. Captured in EST timezone. |
Asset | UpdatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the the user updating the record. |
Asset | UpdatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was updated in this table. Captured in EST timezone. |
Asset | CreatedDateInDataDirect | datetime | null | |
Asset | UpdatedDateInDataDirect | datetime | null | |
AssetCustomAttributes | EquipmentAttributeID | int | not null | Unique identifier for the custom attribute of the equipment |
AssetCustomAttributes | EquipmentID | int | null | The identifier of the equipment |
AssetCustomAttributes | EquipmentTypeCustomAttributeID | int | null | Custom attribute identifier for the equipment type |
AssetCustomAttributes | AttributeName | nvarchar(50) | null | Name of the custom attribute |
AssetCustomAttributes | AttributeTypeID | int | null | Identifier for the type of the custom attribute |
AssetCustomAttributes | AttributeType | nvarchar(50) | null | Type name of the custom attribute (e.g. Number, Text, Single Choice List) |
AssetCustomAttributes | Value | nvarchar(2000) | null | Value of the custom attribute |
AssetCustomAttributes | CreatedDateInDataDirect | datetime | null | |
AssetCustomAttributes | UpdatedDateInDataDirect | datetime | null | |
AssetInfo | Id | int | PK, not null | System Generated Sequence Number. |
AssetInfo | AssetId | int | not null | System generated unique identifier for the Asset. |
AssetInfo | EffectiveStartDate | datetime | not null | Slowly changing dimension table for Asset - Effective Start date of the record for an AssetID |
AssetInfo | EffectiveEndDate | datetime | null | Slowly changing dimension table for Asset - Effective End Date of the record for an AssetID |
AssetInfo | AssetTypeId | int | null | System generated unique identifier for the AssetType. |
AssetInfo | AssetTypeParentId | int | null | Unique Identifier of Parent asset type the current asset type was inherited from. Child Asset type will inherit some attributes of the parent asset type.This inheritance will work only during Asset Type Creation. If attributes are updated at the parent asset type at a later time, changes will not propagate to the inherited child asset type. |
AssetInfo | isAssetTypeActive | bit | null | Flag used to determine if Asset type is active or not, Used only for asset UI , Application checks this flag during asset creation process, an inactive asset type cannot be selected to create an asset. |
AssetInfo | AssetTypeAddedAt | datetime | null | Date when asset type was created. Captured in EST timezone. |
AssetInfo | AssetTypeTradeId | int | null | Trade ID ( servicechannel unique identifier for the subscriber trades) linked with the Asset Type. Trade ID is auto populated when a trade is selected from a drop down list of subscriber trades. |
AssetInfo | AssetPrimaryTrade | nvarchar(150) | null | it is the subscriber trade name from the admin module.This field is no longer used in Asset Manager application. |
AssetInfo | EnableAlerts | bit | null | Decommissioned Field. Not used by the application. |
AssetInfo | AssetTypeUserId | int | null | Unique identifier in ServiceChannel for the login( username) of the user who modified the assets. |
AssetInfo | AssetTypeGroupId | int | null | System Generated Unique identifier for Asset Type Groups. Asset Type groups are created by client in the Asset Module UI. |
AssetInfo | AssetTypeLastModifiedDate | datetime | null | Date when the Asset Type was last modified, captured in EST timezone. |
AssetInfo | WarrantyPrimaryRank | int | null | if 1 - warranty provider is defined as a provider with highest rank for asset type trade and location |
AssetInfo | WarrantyFixedRank | int | null | if Fixed rank is not null, provider is selected based on the Fixed Rank. Provider assignment is available in the admin module. |
AssetInfo | WarrantyFixedProvider | int | null | If Populated, this asset has a fixed provider to fix the issues. |
AssetInfo | WarrantyNTE | money | null | Not to exceed amount. Information Only - Not applied during the wo creation. |
AssetInfo | WarrantyPriority | nvarchar(50) | null | Selected from subscriber priorities (related to work order priorities). Information only- not applied during work order creation. |
AssetInfo | RetiredDate | datetime | null | Date when asset was deactivated in the asset module or asset web api or asset template. |
AssetInfo | ImportedFrom | int | null | Internal system table element.if an asset was created/updated in template, unique identifier for internal table that maintains template entries. Not used by analytics. |
AssetInfo | ManufacturedDate | datetime | null | Manufactured Date of the Asset and entered by the client. Captured in EST timezone. |
AssetInfo | isLeased | bit | null | 1, If the Asset is a leased asset |
AssetInfo | LeaseDate | datetime | null | Entered by the client, lease date of the asset. captured in EST timezone. |
AssetInfo | LeasePeriod | int | null | Lease Period in Months as entered by the client. |
AssetInfo | PhysicalArea | nvarchar(150) | null | Plain text as entered by the client. To be used to mention the area where the asset is installed at a location. |
AssetInfo | WorkOrderArea | nvarchar(100) | null | User defined pick list found in dashboard settings that allowed to be selected on asset details. This helps to group assets in the certain area of the location. |
AssetInfo | HasComponents | bit | null | 1, means Asset can have sub components |
AssetInfo | HasLeakDetector | bit | null | For Refrigerant tracking assets only , it is a flag which means asset has a sensor that can detect leaks and used to generate PM services/frequencies to ensure asset gets inspected on an annual basis. |
AssetInfo | IsCarbReporting | bit | null | For Refrigerant tracking assets only, this flags tells this asset needs to report to California air resource board on it carbon emmissions. |
AssetInfo | AssetStatus | tinyint | null | asset repair status. InUse = 0, OutForRepair = 1, ReplacementRecommended = 2, Repaired = 3 |
AssetInfo | AttributesAvailableForProvider | int | null | Decommissioned Field. Not to be used for analytics. |
AssetInfo | CreatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the user creating this record. |
AssetInfo | CreatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was inserted in this table. Captured in EST timezone. |
AssetInfo | UpdatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the the user updating the record. |
AssetInfo | UpdatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was updated in this table. Captured in EST timezone. |
AssetInfo | CreatedDateInDataDirect | datetime | null | |
AssetInfo | UpdatedDateInDataDirect | datetime | null | |
AssetLeakInspections | AssetLeakInspectionId | int | PK, not null | System generated unique id of the on the leak inspection verification record |
AssetLeakInspections | AssetId | int | not null | System generated unique id of the asset that is associated with the leak inspection verification record |
AssetLeakInspections | TrackingNumber | int | not null | Work order Tracking Number |
AssetLeakInspections | LeakVerificationMethod | varchar(50) | null | Method of leak verification |
AssetLeakInspections | CreatedByUserId | int | not null | |
AssetLeakInspections | CreatedDate | datetimeoffset(7) | not null | Datetime when the record was created |
AssetLeakInspections | UpdatedByUserId | int | null | |
AssetLeakInspections | UpdatedDate | datetimeoffset(7) | null | |
AssetLeakInspections | Actor | nvarchar(50) | null | |
AssetLeakInspections | ActiveFlag | bit | not null | Active Flag |
AssetLeakInspections | CreatedDateInDataDirect | datetime | null | |
AssetLeakInspections | UpdatedDateInDataDirect | datetime | null | |
AssetMeterReadings | AssetMeterReadingId | int | not null | System generated unique id of the record |
AssetMeterReadings | AssetId | int | not null | Identifier of the asset that is associate with the record |
AssetMeterReadings | TagId | nvarchar(100) | null | Tag Id for the Asset |
AssetMeterReadings | AssetMeterId | int | not null | Identifier for the Asset Meter |
AssetMeterReadings | AssetTypeMeter | nvarchar(50) | null | Asset Meter Type |
AssetMeterReadings | UnitOfMeasureName | nvarchar(50) | null | Unit of Measure |
AssetMeterReadings | UnitOfMeasureTypeName | nvarchar(50) | null | Measure Type |
AssetMeterReadings | Value | decimal(11,2) | not null | Meter Reading Value |
AssetMeterReadings | Notes | nvarchar(4000) | null | Notes if any |
AssetMeterReadings | TrackingNumber | int | null | Work Order Tracking Number |
AssetMeterReadings | MeasureDate | datetimeoffset(7) | null | Timestamp when reading was taken |
AssetMeterReadings | UpdatedByUserId | int | null | Identifier for the User who updated the record |
AssetMeterReadings | UpdatedByUserName | nvarchar(100) | null | Name of the User who updated the record |
AssetMeterReadings | CreatedDateInDataDirect | datetime | null | Timestamp when record was created in Data Direct |
AssetMeterReadings | UpdatedDateInDataDirect | datetime | null | Timestamp when record was updated in Data Direct |
AssetRefrigerantCharge | Id | int | PK, not null | System Generated Sequence Number. |
AssetRefrigerantCharge | AssetChargeHistoryId | int | not null | System generated unique id of a backend table that holds refrigeration charge history |
AssetRefrigerantCharge | AssetId | int | not null | System generated unique id of the asset that is associate with the refrigeration charge. |
AssetRefrigerantCharge | LocationId | int | null | System generated unique id of the location of asset where the charge occurred |
AssetRefrigerantCharge | InitialCharge | bit | null | Refrigeration Charge when the asset first received it. |
AssetRefrigerantCharge | ChargeEffectiveDate | datetime | null | Date when charge went into affect for that asset. Captured in EST timezone. |
AssetRefrigerantCharge | TotalCharge | decimal(9,4) | null | Amount of refrigerant in the asset at any given time. Measured in Lbs |
AssetRefrigerantCharge | TotalChargeMetrics | decimal(9,3) | null | Amount of refrigerant in the asset at any given time measured in kg |
AssetRefrigerantCharge | ProviderName | nvarchar(500) | null | Name of the provider, that determined the charge of the asset |
AssetRefrigerantCharge | RackId | nvarchar(50) | null | System generated unique id of a backend table that maintains refrigeration racks( as entered by the client) |
AssetRefrigerantCharge | RackType | tinyint | null | Refrigerant assets with rack (0 = high, 1 = low, 2= medium , 3= dual temp) , null = non rack refrigerant asset |
AssetRefrigerantCharge | RackTypeName | nvarchar(50) | null | Dual Temp,High,Low,Medium |
AssetRefrigerantCharge | RefrigerantPartNumber | nvarchar(50) | null | Refrigerant part category related to the inventory module. Only populated when refrigerant is taken out of the Inventory. |
AssetRefrigerantCharge | isODS | bit | null | Flag used to determine if the refrigerant has Ozone depleting substance. Used for Carb reporting. |
AssetRefrigerantCharge | PartNumberId | int | null | system generated ID of the part category from Inventory module, Only populated when refrigerant is taken out of the Inventory. |
AssetRefrigerantCharge | CarbId | nvarchar(50) | null | Decommissioned field. |
AssetRefrigerantCharge | SystemLocation | tinyint | null | Used for Carb reporting purposes,
Indoors = 1,
Outdoors = 2,
PartiallyIndoorsAndOutdoors = 3 |
AssetRefrigerantCharge | OperationalStatus | tinyint | null | 0 = Mothballed,
1 = SeasonalOperation,
2 = NormalOperation,
3 = SeasonalNonOperation,
4 =Remove,
5 =ProvisionalOperation,
6 =Shutdown,
7 = UnderRepair,
8 = RetrofitInProgress,
9 =Inactive |
AssetRefrigerantCharge | ChargeModifiedDate | datetimeoffset(7) | null | Refrigeration charge updated date |
AssetRefrigerantCharge | RefrigerantChargeOptionsId | int | null | System generated unique id of the databasetable that maintain refrigeration charge options. Fixed settings in the system, can only be selected from the drop down. |
AssetRefrigerantCharge | RefrigerantChargeOptionsOrder | int | null | Decommissioned Field, Not to be used for analytics |
AssetRefrigerantCharge | RefrigerantChargeOptionDesc | varchar(255) | null | Decommissioned Field, Not to be used for analytics |
AssetRefrigerantCharge | RefrigerantChargeOptionName | varchar(100) | null | Calculation
Established
Manufacturer Tag
Measurement
MFG Info (Established Range)
Onsite Documentation
Approximate |
AssetRefrigerantCharge | CreatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the user creating this record. |
AssetRefrigerantCharge | CreatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was inserted in this table. Captured in EST timezone. |
AssetRefrigerantCharge | UpdatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the the user updating the record. |
AssetRefrigerantCharge | UpdatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was updated in this table. Captured in EST timezone. |
AssetRefrigerantCharge | CreatedDateInDataDirect | datetime | null | |
AssetRefrigerantCharge | UpdatedDateInDataDirect | datetime | null | |
AssetRefrigerantCharge | IsCurrentRecord | bit | null | Indicates if this is the current record (since this table stores history of changes) |
AssetRefrigerantLeak | Id | int | Primary Key | System Generated Sequence Number. |
AssetRefrigerantLeak | AssetLeakRecordId | int | not null | System generate unique id for the leak record. |
AssetRefrigerantLeak | AssetId | int | not null | System generated unique id of the asset that is associate with the leak. |
AssetRefrigerantLeak | LocationId | int | null | Service Channel Unique Identifier for the Location of the facility where the Asset is Installed. |
AssetRefrigerantLeak | LeakRate | decimal(10,2) | null | Leak rate usually means entered refrigerant with refrigerant usage reason "Leak" divided by asset charge at the moment of refrigerant usage date |
AssetRefrigerantLeak | TriggerDate | datetime | null | Date the leak event met or exceed the leak rate threshold as set in the refrigeration rules. |
AssetRefrigerantLeak | RepairDate | datetime | null | Date the leak event was repaired. Captured in EST |
AssetRefrigerantLeak | InitialVerificationDate | datetime | null | Date the user provider verified the first time that that the leak event was repaired. Captured in EST |
AssetRefrigerantLeak | FollowupDate | datetime | null | The date the provider validated that the leak event was repaired the second time. Captured in EST |
AssetRefrigerantLeak | InitialVerificationMethod | tinyint | null | The standard method used to determine the leak was repaired the first time. See LeakVerificationMethods table |
AssetRefrigerantLeak | FollowupMethod | tinyint | null | The standard method used to determine the leak was repaired a second time. See LeakVerificationMethods table |
AssetRefrigerantLeak | LeakStatus | tinyint | null | Status of the leak event only two options open or closed. 0-open, 1- closed. 2-invalidated(leak rate becomes less than threshold after refrigerant usage correction) |
AssetRefrigerantLeak | Charge | decimal(16,2) | null | Total system charge of the asset where the leak event occurred. |
AssetRefrigerantLeak | ChargeMetrics | decimal(13,2) | null | Unit of measure of the charge, pounds and ounces, pounds and decimal of pounds, kilograms and grams |
AssetRefrigerantLeak | TriggerQty | decimal(16,2) | null | Amount of refrigerant that was added to the system that caused the leak rate to meet or exceed the leak rate threshold set in the refrigerant tracking rules. |
AssetRefrigerantLeak | TriggerQtyMetrics | decimal(13,2) | null | Unit of measure of the trigger quantity, pounds and ounces, pounds and decimal of pounds, kilograms and grams |
AssetRefrigerantLeak | CalculationMethod | tinyint | null | Method used to calculated the leak rate as defined in the refrigerant tracking rules. options Annualized or average rolling |
AssetRefrigerantLeak | GeneratedDate | datetime | null | Date When Leak record was generated by the system. Captured in EST |
AssetRefrigerantLeak | BulkImportTrackingNumber | int | null | Obsolete, Decommissioned field. |
AssetRefrigerantLeak | TrackingNumber | int | null | Tracking number of the work order where the refrigerant was added that caused the leak rate to meet or exceed the leak threshold. |
AssetRefrigerantLeak | ProvideId | int | null | servicechannel unique id of the provider that captured the leak record. |
AssetRefrigerantLeak | ContractorId | int | null | servicechannel unique id of the contractor |
AssetRefrigerantLeak | LeakRecordModifiedDate | datetime | null | Date Leak Record was modified. Captured in EST |
AssetRefrigerantLeak | RefrigerantTypeId | int | null | System generated value that represents the refrigerant type. |
AssetRefrigerantLeak | RefrigerantTypeName | varchar(50) | null | The name of the type of refrigerant. |
AssetRefrigerantLeak | isODS | bit | null | Indicator that tells the user if the refrigerant type is classified as a high global warming potential (GWP) refrigerant or not. |
AssetRefrigerantLeak | LeakLocationId | int | null | Location of the leak within the system. System defined pick list. |
AssetRefrigerantLeak | LeakLocationName | nvarchar(100) | null | Location of the leak within the system. System defined pick list. |
AssetRefrigerantLeak | LeakAreaName | nvarchar(100) | null | Area of the system where the leak occurred, this value is a subsystem to the leak area. System defined pick list. |
AssetRefrigerantLeak | FaultCodeName | nvarchar(50) | null | System defined list of possible causes of the leak. |
AssetRefrigerantLeak | ActionTaken | nvarchar(50) | null | System defined list of resolution to the leak. |
AssetRefrigerantLeak | CreatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the user creating this record. |
AssetRefrigerantLeak | CreatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was inserted in this table. Captured in EST timezone. |
AssetRefrigerantLeak | UpdatedBy | varchar(20) | null | Audit field used by etl pipeline in internal warehouse. Denotes the the user updating the record. |
AssetRefrigerantLeak | UpdatedDate | datetimeoffset(7) | null | Audit field used by etl pipeline in internal warehouse. Date when the record was updated in this table. Captured in EST timezone. |
AssetRefrigerantLeak | CreatedDateInDataDirect | datetime | null | |
AssetRefrigerantLeak | UpdatedDateInDataDirect | datetime | null | |
AssetRefrigerantLeakNotes | Id | int | PK, not null | System generated unique identifier for the record. |
AssetRefrigerantLeakNotes | AssetLeakRecordId | int | not null | Identifier for the asset Leak Record. |
AssetRefrigerantLeakNotes | LeakRecordNote | nvarchar(4000) | null | Note associated with the Leak Record. |
AssetRefrigerantLeakNotes | CreatedDate | datetimeoffset(7) | null | Timestamp when record was created. |
AssetRefrigerantLeakNotes | CreatedUserId | int | null | Id of the User who created the record. |
AssetRefrigerantLeakNotes | IsAutoGeneratedNoteFlag | bit | not null | Flag indicating if the note was auto generated or not. |
AssetRefrigerantLeakNotes | CreatedDateInDataDirect | datetime | null | Timestamp when record was created in Data Direct. |
AssetRefrigerantLeakNotes | UpdatedDateInDataDirect | datetime | null | Timestamp when record was last updated in Data Direct. |
AssetRefrigerantLeakWOs | Id | int | Primary Key | System generated unique identifier for the record |
AssetRefrigerantLeakWOs | AssetLeakRecordId | int | not null | Identifier for the asset Leak Record |
AssetRefrigerantLeakWOs | TrackingNumber | int | not null | WO Tracking Number associated with the Leak Record |
AssetRefrigerantLeakWOs | ScMaterialId | int | null | Identifier for the Material Record (Refrigerant) |
AssetRefrigerantLeakWOs | IsFollowUp | bit | not null | Follow up flag |
AssetRefrigerantLeakWOs | OriginalTrackingNumber | int | null | Tracking Number of the parent workorder associated with the Asset Refrigerant Leak |
AssetRefrigerantLeakWOs | CreatedDateInDataDirect | datetime | null | Timestamp when record was created in Data Direct |
AssetRefrigerantLeakWOs | UpdatedDateInDataDirect | datetime | null | Timestamp when record was updated in Data Direct |
AssetRefrigerantLeakImmeasurable | Id | int | PK, not null | System Generated Unique Identifier for the record |
AssetRefrigerantLeakImmeasurable | AssetId | int | not null | Identifier of the asset that is associate with the leak. |
AssetRefrigerantLeakImmeasurable | LocationId | int | null | Identifier for the Location of the facility where the Asset is Installed. |
AssetRefrigerantLeakImmeasurable | SubscriberId | int | null | Identifier for the Subscriber |
AssetRefrigerantLeakImmeasurable | RepairDate | datetime | null | Date the leak was repaired. |
AssetRefrigerantLeakImmeasurable | InitialVerificationDate | datetime | null | Date the provider verified the first time that that the leak was repaired. |
AssetRefrigerantLeakImmeasurable | InitialVerificationMethod | tinyint | null | The standard method used to determine the leak was repaired the first time. |
AssetRefrigerantLeakImmeasurable | FollowupVerificationDate | datetime | null | The date the provider validated that the leak event was repaired the second time. |
AssetRefrigerantLeakImmeasurable | FollowupVerificationMethod | tinyint | null | The standard method used to determine the leak was repaired a second time. |
AssetRefrigerantLeakImmeasurable | LeakLocationId | int | null | Identifier for the Location of the leak within the system. |
AssetRefrigerantLeakImmeasurable | LeakLocationName | nvarchar(100) | null | Location of the leak within the system. |
AssetRefrigerantLeakImmeasurable | LeakAreaName | nvarchar(100) | null | Area of the system where the leak occurred. |
AssetRefrigerantLeakImmeasurable | FaultCodeName | nvarchar(50) | null | Possible cause of the leak. |
AssetRefrigerantLeakImmeasurable | ActionTaken | nvarchar(50) | null | Action Taken to address the issue |
AssetRefrigerantLeakImmeasurable | Actor | nvarchar(50) | null | Indicates who took the action |
AssetRefrigerantLeakImmeasurable | AssetLeakRecordId | int | null | Reference to the Asset Refrigerant Leak Record |
AssetRefrigerantLeakImmeasurable | CreatedDate | datetimeoffset(7) | not null | Timestamp when record was created |
AssetRefrigerantLeakImmeasurable | CreatedByUserId | int | null | User who created the record |
AssetRefrigerantLeakImmeasurable | UpdatedDate | datetimeoffset(7) | null | Timestamp when record was updated |
AssetRefrigerantLeakImmeasurable | UpdatedByUserId | int | null | User who updated the record |
AssetRefrigerantLeakImmeasurable | CreatedDateInDataDirect | datetime | null | Timestamp when record was created in Data Direct |
AssetRefrigerantLeakImmeasurable | UpdatedDateInDataDirect | datetime | null | Timestamp when record was updated in Data Direct |
AssetRefrigerantLeakImmeasurableNotes | Id | int | PK, not null | System generated unique identifier for the record. |
AssetRefrigerantLeakImmeasurableNotes | LeakImmeasurableId | int | not null | Identifier for the Asset Leak Immeasurable Record. |
AssetRefrigerantLeakImmeasurableNotes | LeakImmeasurableNote | nvarchar(4000) | null | Note associated with the Asset Leak Immeasurable Record. |
AssetRefrigerantLeakImmeasurableNotes | CreatedDate | datetimeoffset(7) | null | Timestamp when record was created. |
AssetRefrigerantLeakImmeasurableNotes | CreatedUserId | int | null | Id of the User who created the record. |
AssetRefrigerantLeakImmeasurableNotes | IsAutoGeneratedNoteFlag | bit | not null | Flag indicating if the note was auto generated or not. |
AssetRefrigerantLeakImmeasurableNotes | CreatedDateInDataDirect | datetime | null | Timestamp when record was created in Data Direct. |
AssetRefrigerantLeakImmeasurableNotes | UpdatedDateInDataDirect | datetime | null | Timestamp when record was last updated in Data Direct. |
AssetRefrigerantLeakImmeasurableWOs | Id | int | PK, not null | System generated unique identifier for the record |
AssetRefrigerantLeakImmeasurableWOs | AssetRefrigerantLeakImmeasurableId | int | not null | Identifier for the asset Leak Immeasurable Record |
AssetRefrigerantLeakImmeasurableWOs | TrackingNumber | int | not null | WO Tracking Number associated with the Leak Record |
AssetRefrigerantLeakImmeasurableWOs | OriginalTrackingNumber | int | null | Tracking Number of the parent workorder associated with the Asset Refrigerant Leak |
AssetRefrigerantLeakImmeasurableWOs | ScMaterialId | int | null | Identifier for the Material Record (Refrigerant) |
AssetRefrigerantLeakImmeasurableWOs | GeneratedDate | datetimeoffset(7) | null | Date when record was generated |
AssetRefrigerantLeakImmeasurableWOs | SourceRecordId | int | not null | Reference to the record on the source table |
AssetRefrigerantLeakImmeasurableWOs | CreatedDateInDataDirect | datetime | null | Timestamp when record was created in Data Direct |
AssetRefrigerantLeakImmeasurableWOs | UpdatedDateInDataDirect | datetime | null | Timestamp when record was updated in Data Direct |
assets | Brand | nvarchar(300) | null | Manufacturer Brand Name of the asset as selected from the drop down or as uploaded by the client in Asset Module. |
assets | EquipmentID | int | PK, not null | ServiceChannel unique identifier for the Asset. |
assets | LocationID | int | not null | Service Channel Unique Identifier for the Location of the facility where the Asset is Installed. |
assets | Active | bit | not null | By default '1' and means that this asset is active in the application and can be assigned a work order. |
assets | TagID | nvarchar(100) | not null | Random unique identifier within a location entered by the client. It can be auto generated by the application if the customer selects "auto generate tag id" setting in AssetType. |
assets | ModelNo | nvarchar(300) | null | Model number of the Asset as entered or uploaded by the client in Asset Module. |
assets | SerialNo | nvarchar(300) | null | Serial Number (Manufacturer's unique identifier) as entered or uploaded by the client in Asset Module. |
assets | Condition | int | null | 0 = 'Broken', 25 = 'poor', 50 = 'Average', 75- = Good', 100 = 'Excellent', as selected by the client from the drop down menu |
assets | DeactivatedDate | datetime | null | If Asset is no longer active, this date is populated with the date when Asset is Retired or Last modified. |
assets | LifeExpectancy | int | null | Asset life expectancy (can be represented in months or years as defined by the client). This value is also entered or uploaded by the client in Asset Module |
assets | OriginalValue | money | null | Used to determine the original cost of the Asset ,as entered or uploaded by the client. Can be used to calculate the value of the asset based on its life expectancy. |
assets | EnergyEfficiency | nvarchar(300) | null | User defined value to measure the energy consumption of the asset. Value Entered or uploaded by the client in Asset Module. |
assets | Capacity | nvarchar(300) | null | User defined value that allows the client to indicate the capacity of the asset. |
assets | InstallDate | datetime | null | Date when the asset was installed at its corresponding location, as entered or uploaded by the client in Asset Module. Captured in EST timezone. |
assets | PurchaseDate | datetime | null | Original purchase date of the asset as entered or uploaded by the client in Asset Module. |
assets | WarrantyPeriod | int | null | Manufacturer warranty period in months as entered/uploaded by the client in Asset |
assets | WarrantyStartsFromInstallDate | bit | null | 1 means 'warranty starts from Install date' and 0 means 'Warranty starts from purchase date' |
assets | WarrantyExpirationDate | datetime | null | Date Calculated by adding the warranty period ( in months) from Install date or purchase date |
assets | Note | nvarchar(300) | null | Decommissioned field. |
assets | QRcode | nvarchar(300) | null | QR Code or Bar Code that is scanned from the Asset. Entered/uploaded by the client. |
assets | AssetType | nvarchar(200) | null | Name of the Asset Type entered by the client in Asset Module |
assets | Trade | nvarchar(100) | not null | |
assets | UpdatedDateInDataDirect | datetime | null | |
assets | CreatedDateInDataDirect | datetime | null | Date when the record is inserted into this table in Data Direct. Captured in EST timezone. |
AssetsInWorkorders | AssetsInWorkordersId | int | PK, not null | Primary key for the table |
AssetsInWorkorders | AssetId | int | not null | Asset Identifier |
AssetsInWorkorders | TrackingNumber | int | not null | Workorder Tracking Number (Identifier for the Workorder Record) |
AssetsInWorkorders | DateAdded | datetimeoffset(7) | null | Date when Asset WO relationship was added |
AssetsInWorkorders | AddedByUserId | int | null | User Identifier who added the Asset WO relationship |
AssetsInWorkorders | ReplaceAsset | int | not null | Replace Asset Flag indicator |
AssetsInWorkorders | CreatedDateInDataDirect | datetimeoffset(7) | null | Timestamp when record was created in Data Direct |
AssetsInWorkorders | UpdatedDateInDataDirect | datetimeoffset(7) | null | Timestamp when record was updated in Data Direct |
AssetTypeCustomAttributes | EquipmentTypeID | int | null | Equipment type Id |
AssetTypeCustomAttributes | EquipmentTypeCustomAttributeID | int | null | Identifier for equipment type custom attribute |
AssetTypeCustomAttributes | AttributeName | nvarchar(50) | null | Name of the attribute |
AssetTypeCustomAttributes | AttributeTypeID | int | null | Type identifier of the attribute |
AssetTypeCustomAttributes | AttributeType | nvarchar(50) | null | Type of the attribute(e.g. Text, Date etc) |
AssetTypeCustomAttributes | Value | nvarchar(150) | null | Default value of the attribute |
AssetTypeCustomAttributes | CreatedDateInDataDirect | datetime | null | |
AssetTypeCustomAttributes | UpdatedDateInDataDirect | datetime | null | |
AssetValidationInfo | AssetValidationInfoId | int | PK, not null | Primary key for the table |
AssetValidationInfo | AssetId | int | not null | Asset Identifier |
AssetValidationInfo | TrackingNumber | int | not null | Workorder Tracking Number (Identifier for the Workorder Record) |
AssetValidationInfo | ValidationStatus | nvarchar(50) | null | Asset Validation Status |
AssetValidationInfo | UnableToVaildateReason | nvarchar(256) | null | Reason for not being able to perform the asset validation |
AssetValidationInfo | OtherReason | nvarchar(256) | null | Other Reasons |
AssetValidationInfo | AssetTagNotScannedReason | nvarchar(256) | null | Reason for not being able to scan the asset |
AssetValidationInfo | ValidatedDate | datetimeoffset(7) | null | Date when validation was performed |
AssetValidationInfo | ValidatedByUserId | int | null | User Identifier who performed the asset validation |
AssetValidationInfo | CreatedDateInDataDirect | datetimeoffset(7) | null | Timestamp when record was created in Data Direct |
AssetValidationInfo | UpdatedDateInDataDirect | datetimeoffset(7) | null | Timestamp when record was updated in Data Direct |
audit | AuditID | int | PK, not null | Id that uniquely identifies Audit record |
audit | Date | date | not null | Date when audit is started |
audit | Time | time(7) | not null | Time when audit is started |
audit | AuditType | nvarchar(500) | not null | The name of the template under which the audit is created |
audit | LocationID | varchar(50) | not null | links to the location of the audit |
audit | LocationName | nvarchar(100) | null | name of the location of the audit |
audit | Region | nvarchar(50) | null | region of the audit location |
audit | District | nvarchar(50) | null | district of the audit location |
audit | InspectorName | nvarchar(50) | not null | User id or the user name of the inspector |
audit | CreatedDateInDataDirect | datetime | null | |
audit | UpdatedDateInDataDirect | datetime | null | |
audit | StartDate_DTO | datetimeoffset | null | Date when audit is started |
audit | FinishDate_DTO | datetimeoffset | null | Date when audit is ended |
audit_check_list_item | CommentQuantity | int | not null | The number of issues |
audit_check_list_item | AuditID | int | not null | Reference to the corrsponding Audit |
audit_check_list_item | AuditCheckListItemStatus | int | not null | The status of the audit checklist item (AuditPass=1, AuditFail=2, AuditNA=3 or 0) |
audit_check_list_item | AuditCheckListItemID | int | not null | Id that uniquely identifies the audit checklist item |
audit_check_list_item | Area | nvarchar(500) | not null | Name of audit Area |
audit_check_list_item | AuditCheckListItemName | nvarchar(500) | not null | Name of Check List Item |
audit_check_list_item | AuditCheckListItemDescription | nvarchar(max) | not null | Description of the checklist in question form |
audit_check_list_item | TrackingNumber | int | null | link to the corresponding work order (if any) |
audit_check_list_item | CreatedDateInDataDirect | datetime | null | |
audit_check_list_item | UpdatedDateInDataDirect | datetime | null | |
audit_check_list_item | Score | int | null | Score of the Audit CheckListItem |
audit_check_list_item | PassThreshold | int | null | Threshold to determine if an audit passed or failed |
audit_check_list_item | RatingSystemName | nvarchar(50) | null | Audit Rating System (PF/Numeric/Weighted/Percentage) |
audit_check_list_item | Quantity | int | null | Quantity of the checklist item |
audit_check_list_item | Units | nvarchar(64) | null | Units of the quantity |
audit_issue_attachment | AuditCheckListItemID | int | not null | Link to the corresponding audit checklist item |
audit_issue_attachment | AuditIssueAttachmentId | int | not null | Unique ID of the attachment |
audit_issue_attachment | AuditID | int | null | Link to the corresponding Audit record |
audit_issue_attachment | FileName | nvarchar(255) | not null | Name of the file attachment |
audit_issue_attachment | CreatedDateInDataDirect | datetime | null | |
audit_issue_attachment | UpdatedDateInDataDirect | datetime | null | |
budget | BudgetId | bigint | PK, not null | |
budget | SuscriberId | int | not null | |
budget | FiscalYear | nvarchar(10) | not null | |
budget | FiscalPeriod | nvarchar(10) | not null | |
budget | FiscalWeek | nvarchar(10) | null | |
budget | FiscalQuarter | nvarchar(10) | null | |
budget | LocationId | int | null | |
budget | LocationName | nvarchar(100) | null | |
budget | StoreId | varchar(50) | null | |
budget | District | nvarchar(50) | null | |
budget | Region | nvarchar(50) | null | |
budget | Country | nvarchar(50) | null | |
budget | RoutineNonRoutine | nvarchar(15) | null | |
budget | ServiceType | nvarchar(100) | null | |
budget | Trade | nvarchar(100) | null | |
budget | Category | varchar(50) | null | |
budget | GLCode | nvarchar(50) | null | |
budget | GLCodeName | nvarchar(50) | null | |
budget | BudgetAmount | decimal(30,17) | null | |
budget | ForecastAmount | decimal(30,17) | null | |
budget | AccruedAmount | decimal(30,17) | null | |
budget | LocationNoteHeader1 | varchar(255) | null | |
budget | LocationNoteHeader1value | varchar(255) | null | |
budget | LocationNoteHeader2 | varchar(255) | null | |
budget | LocationNoteHeader2value | varchar(255) | null | |
budget | LocationNoteHeader3 | varchar(255) | null | |
budget | LocationNoteHeader3value | varchar(255) | null | |
budget | LocationNoteHeader4 | varchar(255) | null | |
budget | LocationNoteHeader4value | varchar(255) | null | |
budget | LocationNoteHeader5 | varchar(255) | null | |
budget | LocationNoteHeader5value | varchar(255) | null | |
budget | UpdatedDate | datetime | null | |
budget | SourceName | varchar(100) | not null | |
budget | SourceRecordId | int | not null | |
budget | CreatedDateInDataDirect | datetime | null | |
budget | UpdatedDateInDataDirect | datetime | null | |
Categories | Category | varchar(200) | not null | Work order's category. Displayed both on the work order details and the work order list screens. |
categories | id | int | not null | Unique Id of the category |
categories | CreatedDateInDataDirect | datetime | null | The date and time that this record was insert in Data Direct Table. |
categories | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
CheckListAssetTaskResponses | id | int | not null | |
CheckListAssetTaskResponses | AssetTaskId | int | not null | |
CheckListAssetTaskResponses | AssetId | int | not null | |
CheckListAssetTaskResponses | TrackingNumber | int | not null | |
CheckListAssetTaskResponses | Attempt | int | not null | |
CheckListAssetTaskResponses | StartTime | datetimeoffset | not null | |
CheckListAssetTaskResponses | EndTime | datetimeoffset | null | |
CheckListAssetTaskResponses | UserId | int | not null | |
CheckListAssetTaskResponses | CreatedDateInDataDirect | datetime | null | |
CheckListAssetTaskResponses | UpdatedDateInDataDirect | datetime | null | |
checklists | Question | nvarchar(500) | not null | |
checklists | id | int | not null | |
checklists | Answer | nvarchar(500) | not null | |
checklists | Attempt | tinyint | not null | |
checklists | TechnicianId | int | null | |
checklists | TrackingNumber | int | not null | |
checklists | CreatedByUserID | int | not null | |
checklists | ProviderID | int | not null | |
checklists | CreatedDate | datetime | not null | |
checklists | FreeTextAnswer | nvarchar(200) | null | |
checklists | SurveyName | nvarchar(100) | not null | |
checklists | isActive | int | not null | |
checklists | UpdatedDate | datetime | not null | |
checklists | ChecklistResponseUpdatedDate | datetime | null | |
checklists | ChecklistUpdatedDate | datetime | null | |
checklists | CreatedDateInDataDirect | datetime | null | |
checklists | UpdatedDateInDataDirect | datetime | null | |
CheckListTasks | id | int | not null | |
CheckListTasks | CheckListId | int | not null | |
CheckListTasks | TypeId | int | not null | |
CheckListTasks | Name | nvarchar(50) | not null | |
CheckListTasks | Description | nvarchar(4000) | not null | |
CheckListTasks | IsActive | bit | not null | |
CheckListTasks | CreatedDate | datetimeoffset | not null | |
CheckListTasks | CreatedBy | int | not null | |
CheckListTasks | UpdatedDate | datetimeoffset | not null | |
CheckListTasks | UpdatedBy | int | null | |
CheckListTasks | TaskTypeName | nvarchar(100) | not null | |
CheckListTasks | CreatedDateInDataDirect | datetime | null | |
CheckListTasks | UpdatedDateInDataDirect | datetime | null | |
custom_asset_attributes | equipmentID | int | not null | ServiceChannel unique identifier for the Asset. |
custom_asset_attributes | UpdatedDate | datetime | null | Date when a custom attribute was modified by the client. |
custom_asset_attributes | equipmentAttributeID | int | not null | Unique Identifier for the custom attribute. |
custom_asset_attributes | valueText | nvarchar(2000) | null | Value for the Custom attribute as entered by the client. |
custom_asset_attributes | valueNumber | int | null | Value for the Custom attribute as entered by the client. |
custom_asset_attributes | valueBool | bit | null | Value for the Custom attribute as entered by the client. |
custom_asset_attributes | ValueMoney | money | null | Value for the Custom attribute as entered by the client. |
custom_asset_attributes | valueDate | datetime | null | Value for the Custom attribute as entered by the client. |
custom_asset_attributes | valueChoice | int | null | Value for the Custom attribute as entered by the client. |
custom_asset_attributes | equipmentType | nvarchar(200) | null | Name of the Asset Type entered by the client in Asset Module |
custom_asset_attributes | equipmentTypeCustomAttributeName | nvarchar(50) | null | Plain text as entered by the client for custom attribute name |
custom_asset_attributes | defaultValue | nvarchar(150) | null | Default value of the custom attribute. |
custom_asset_attributes | required | bit | null | Flag that is used to determine if the custom attribute is required or not |
custom_asset_attributes | position | int | null | position in add/edit form for custom attributes upload. |
custom_asset_attributes | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
custom_asset_attributes | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
ftm | InternalDepartment | bit | null | |
ftm | trackingNumber | int | not null | |
ftm | ProviderID | int | null | |
ftm | SubscriberId | int | null | |
ftm | id | int | PK, not null | |
ftm | checkInDateTime | datetime | null | |
ftm | checkOutDateTime | datetime | null | |
ftm | checkinTime_dto | datetimeoffset(7) | null | |
ftm | checkOutTime_dto | datetimeoffset(7) | null | |
ftm | userid | int | null | |
ftm | email | nvarchar(128) | null | |
ftm | technicianFirstName | nvarchar(128) | null | |
ftm | technicianLastName | nvarchar(128) | null | |
ftm | employeeId | nvarchar(100) | null | |
ftm | workType | varchar(100) | null | |
ftm | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
ftm | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_catalog | InventoryCatalogId | int | not null | System generated unique identifier for the record |
inventory_catalog | SubId | int | not null | Subscriber Identifier |
inventory_catalog | CatalogSupplierName | nvarchar(50) | null | Catalog Supplier Name |
inventory_catalog | BrandName | nvarchar(100) | null | Brand Name |
inventory_catalog | SupplierPartNumber | nvarchar(100) | null | Part Number from Supplier |
inventory_catalog | ScProviderId | int | not null | Provider Identifier value from ServiceChannel |
inventory_catalog | ManufacturerPartNumber | nvarchar(100) | null | Part Number from Manufacturer |
inventory_catalog | CatalogName | nvarchar(100) | null | Name of the catalog |
inventory_catalog | CatalogDescription | nvarchar(2000) | null | Description of the catalog |
inventory_catalog | Price | decimal | not null | Price of the item |
inventory_catalog | Multiplier | decimal | null | Multiplier (if any) |
inventory_catalog | UnitOfMeasure | nvarchar(100) | null | Unit of measure |
inventory_catalog | CurrencyCode | varchar(3) | null | Currency for the price |
inventory_catalog | ValidDate | datetimeoffset | not null | Valid date |
inventory_catalog | ExpireDate | datetimeoffset | not null | Expiration date |
inventory_catalog | MinOrderQty | decimal | not null | Minimum quantity that is required for order |
inventory_catalog | Deleted | bit | not null | Indicates if the record is deleted |
inventory_catalog | CreatedDate | datetimeoffset | not null | Date and time when the record was created |
inventory_catalog | UpdatedDate | datetimeoffset | not null | Date and time when the record was updated |
inventory_catalog | InventoryPartId | int | null | Part identifier |
inventory_catalog | Trade | nvarchar(50) | null | Associated Trade |
inventory_catalog | Category | nvarchar(50) | null | Assocaited Category |
inventory_catalog | GLCode | nvarchar(128) | null | General Ledger Code |
inventory_catalog | UPCCode | nvarchar(128) | null | UPC Code value |
inventory_catalog | Priority | nvarchar(50) | null | Priority |
inventory_catalog | IsActive | bit | not null | Indicates if the record is active |
inventory_catalog | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_catalog | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_cyclecount_location_records | CycleCountLocationRecordId | int | not null | System generated unique identifier for the record |
inventory_cyclecount_location_records | InventoryLocationId | int | not null | Inventroy Location Identifier |
inventory_cyclecount_location_records | CycleCountScheduleId | int | not null | Cycle count Schedule identifier |
inventory_cyclecount_location_records | Accepted | bit | null | Indicates if the schedule is accepted |
inventory_cyclecount_location_records | CycleCountLocationRecordStatus | nvarchar(50) | null | Status of the schedule at the location |
inventory_cyclecount_location_records | CreatedByUserId | int | null | Identifier of the user who created the record |
inventory_cyclecount_location_records | CreatedByUsername | nvarchar(100) | null | Name of the user who created the record |
inventory_cyclecount_location_records | CreatedDate | datetimeoffset | not null | Date and time when the record was created |
inventory_cyclecount_location_records | UpdatedByUserId | int | null | Identifier of the user who updated the record |
inventory_cyclecount_location_records | UpdatedByUsername | nvarchar(100) | null | Name of the user who updated the record |
inventory_cyclecount_location_records | UpdatedDate | datetimeoffset | not null | Date and time when the record was updated |
inventory_cyclecount_location_records | CycleCountLocationRecordNote | nvarchar(2000) | null | Any note associated with the Location cycle count schedule |
inventory_cyclecount_location_records | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_cyclecount_location_records | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_cyclecount_schedule_parts | CycleCountSchedulePartId | int | not null | System generated unique identifier for the record |
inventory_cyclecount_schedule_parts | CycleCountScheduleId | int | not null | Identifier of the Cycle count schedule record |
inventory_cyclecount_schedule_parts | InventoryPartId | int | not null | Identifier of the Inventory part record |
inventory_cyclecount_schedule_parts | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_cyclecount_schedule_parts | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_cyclecount_schedule_parttypes | CycleCountSchedulePartTypeId | int | not null | System generated unique identifier for the record |
inventory_cyclecount_schedule_parttypes | CycleCountScheduleId | int | not null | Identifier of the Cycle count schedule record |
inventory_cyclecount_schedule_parttypes | PartTypeName | nvarchar(100) | null | Name of the part type |
inventory_cyclecount_schedule_parttypes | PartTypeDescription | nvarchar(2000) | null | Description of the part type |
inventory_cyclecount_schedule_parttypes | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_cyclecount_schedule_parttypes | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_cyclecount_schedules | CycleCountScheduleId | int | not null | System generated unique identifier for the record |
inventory_cyclecount_schedules | SubId | int | not null | Subscriber Identifier |
inventory_cyclecount_schedules | DueDate | datetimeoffset | not null | Date when the schedule is due. |
inventory_cyclecount_schedules | CompletionDate | datetimeoffset | null | Completion Date |
inventory_cyclecount_schedules | CycleCountType | nvarchar(50) | null | Cycle count type |
inventory_cyclecount_schedules | CycleCountLocationsType | nvarchar(50) | null | Type of location |
inventory_cyclecount_schedules | CycleCountStatus | nvarchar(50) | null | Status |
inventory_cyclecount_schedules | CreatedByUserId | int | null | Identifier of the user who created the cycle count schedule. |
inventory_cyclecount_schedules | CreatedByUsername | nvarchar(100) | null | Name of the user who created the cycle count schedule. |
inventory_cyclecount_schedules | CreatedDate | datetimeoffset | not null | Date when the schedule was created |
inventory_cyclecount_schedules | UpdatedByUserId | int | null | Identifier of the user who updated the cycle count schedule. |
inventory_cyclecount_schedules | UpdatedByUsername | nvarchar(100) | null | Name of the user who updated the cycle count schedule. |
inventory_cyclecount_schedules | UpdatedDate | datetimeoffset | not null | Date when the schedule was updated |
inventory_cyclecount_schedules | CycleCountScheduleNote | nvarchar(2000) | null | Any note associated with the schedule |
inventory_cyclecount_schedules | CycleCountName | nvarchar(100) | null | Name |
inventory_cyclecount_schedules | CycleCountDescription | nvarchar(2000) | null | Description |
inventory_cyclecount_schedules | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_cyclecount_schedules | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_cyclecounts | CycleCountId | int | not null | System generated unique identifier for the record |
inventory_cyclecounts | CycleCountLocationRecordId | int | not null | Identifier of the cycle count location schedule |
inventory_cyclecounts | InventoryPartId | int | not null | Inventory part identifier |
inventory_cyclecounts | InventoryStockId | int | not null | Inventory stock identifier |
inventory_cyclecounts | CountDate | datetimeoffset | null | Date when the count was performed |
inventory_cyclecounts | QuantitySystem | decimal | null | Quantity in the system |
inventory_cyclecounts | QuantityCounted | decimal | null | Counted Quantity |
inventory_cyclecounts | CountedByUserId | int | null | Identifier of the user who performed the counts |
inventory_cyclecounts | CountedByUsername | nvarchar(100) | null | Name of the user who performed the counts |
inventory_cyclecounts | CreatedByUserId | int | null | Identifier of the user who created the cycle count record. |
inventory_cyclecounts | CreatedByUsername | nvarchar(100) | null | Name of the user who created the cycle count record. |
inventory_cyclecounts | CreatedDate | datetimeoffset | not null | Date when the cycle count record was created |
inventory_cyclecounts | UpdatedByUserId | int | null | Identifier of the user who updated the cycle count record. |
inventory_cyclecounts | UpdatedByUsername | nvarchar(100) | null | Name of the user who updated the cycle count record. |
inventory_cyclecounts | UpdatedDate | datetimeoffset | not null | Date when the cycle count record was updated |
inventory_cyclecounts | CycleCountNote | nvarchar(2000) | null | Any note associated with the cycle count |
inventory_cyclecounts | Repaired | decimal | null | Quantity Repaired |
inventory_cyclecounts | Damaged | decimal | null | Quantity Damaged |
inventory_cyclecounts | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_cyclecounts | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_locations | InventoryLocationId | int | not null | System generated unique identifier for the record |
inventory_locations | ScLocationId | int | null | Identifier of the Location record in Service Channel for store locations. For Trucks the value will be null |
inventory_locations | SubId | int | not null | Subscriber Identifier |
inventory_locations | CompanyName | nvarchar(100) | null | Company Name |
inventory_locations | LocationName | nvarchar(100) | null | Location Name |
inventory_locations | StoreId | varchar(100) | null | Store Number |
inventory_locations | address1 | nvarchar(500) | null | Address of the location |
inventory_locations | address2 | nvarchar(500) | null | Address of the location |
inventory_locations | city | varchar(50) | null | City of the location |
inventory_locations | state | nvarchar(50) | null | State of the location |
inventory_locations | zip | nvarchar(12) | null | Zipcode of the location |
inventory_locations | Region | nvarchar(50) | null | Region of the location |
inventory_locations | District | nvarchar(50) | null | District of the location |
inventory_locations | country | varchar(20) | null | Country of the location |
inventory_locations | IsActive | bit | not null | Indicates if the location is active |
inventory_locations | CreatedDate | datetimeoffset | null | Date when the location record was created |
inventory_locations | type_label | nvarchar(50) | null | Location Type Label |
inventory_locations | supplier | nvarchar(100) | null | Supplier |
inventory_locations | TruckId | int | null | Identifier for truck |
inventory_locations | TruckMake | nvarchar(100) | null | Make of the Truck |
inventory_locations | TruckModel | nvarchar(100) | null | Model of the Truck |
inventory_locations | TruckYear | nvarchar(100) | null | Manufactured Year of the Truck |
inventory_locations | TruckLicense | nvarchar(100) | null | License plate number of the Truck |
inventory_locations | TruckVin | nvarchar(100) | null | Vehicle Identification Number of the Truck |
inventory_locations | TruckHomestoreLocationId | int | null | Location Identifier of the Home Store location of the Truck |
inventory_locations | UpdatedDate | datetimeoffset | not null | Date when the location record was updated |
inventory_locations | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_locations | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_locations | IsDeleted | bit | null | Indicates if the location is deleted |
inventory_part_purchase | InventoryPartPurchaseId | int | not null | System generated unique identifier for the part purchase record |
inventory_part_purchase | CatalogSupplierName | nvarchar(50) | null | Name of the supplier |
inventory_part_purchase | ToInventoryLocationId | int | not null | Identifier of the inventory location for which purchase was made. |
inventory_part_purchase | PartPurchaseState | nvarchar(50) | null | Part Purchase State (e.g: Open, Approved, Issued, Partially Received, Received, Canceled) |
inventory_part_purchase | PartPurchaseType | nvarchar(50) | null | Part Purchase Type (e.g: Standard, Restocking, PMCycleCount) |
inventory_part_purchase | WoNumber | nvarchar(20) | null | WO Tracking Number (if any) |
inventory_part_purchase | CreatedByUserId | int | null | Identifier of the user who created the part purchase record. |
inventory_part_purchase | CreatedByUsername | nvarchar(100) | null | Name of the user who created the part purchase record. |
inventory_part_purchase | CreatedDate | datetimeoffset | not null | Date when the part purchase record was created |
inventory_part_purchase | UpdatedByUserId | int | null | Identifier of the user who updated the part purchase record. |
inventory_part_purchase | UpdatedByUsername | nvarchar(100) | null | Name of the user who updated the part purchase record. |
inventory_part_purchase | UpdatedDate | datetimeoffset | not null | Date when the part purchase record was updated |
inventory_part_purchase | IssuedByUserId | int | null | Identifier of the user who issued the part purchase record. |
inventory_part_purchase | IssuedByUsername | nvarchar(100) | null | Name of the user who issued the part purchase record. |
inventory_part_purchase | IssuedDate | datetimeoffset | null | Date when the part purchase record was issued |
inventory_part_purchase | ReceivedByUserId | int | null | Identifier of the user who received the part purchase record. |
inventory_part_purchase | ReceivedByUsername | nvarchar(100) | null | Name of the user who received the part purchase record. |
inventory_part_purchase | ReceivedDate | datetimeoffset | null | Date when the part purchase record was updated |
inventory_part_purchase | PartsOnOrderWorkorderId | int | null | WO Tracking Number if parts on order |
inventory_part_purchase | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_part_purchase | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_part_purchase_items | InventoryPartPurchaseItemId | int | not null | System generated unique identifier for the part purchase Item |
inventory_part_purchase_items | InventoryPartPurchaseId | int | not null | Identifier of the Part Purchase record |
inventory_part_purchase_items | ToInventoryStockId | int | null | Inventory Stock Identifier |
inventory_part_purchase_items | InventoryCatalogId | int | null | Inventory Catalog Identifier |
inventory_part_purchase_items | InventoryPartId | int | null | Inventory Part Identifier |
inventory_part_purchase_items | UnitPrice | decimal | null | Price per unit |
inventory_part_purchase_items | QuantityRequested | decimal | not null | Requested Quantity |
inventory_part_purchase_items | QuantityIssued | decimal | null | Issued Quantity |
inventory_part_purchase_items | QuantityLost | decimal | null | Lost Quantity |
inventory_part_purchase_items | QuantityReceived | decimal | null | Received Quantity |
inventory_part_purchase_items | CreatedByUserId | int | null | Identifier of the user who created the part purchase item. |
inventory_part_purchase_items | CreatedByUsername | nvarchar(100) | null | Name of the user who created the part purchase item. |
inventory_part_purchase_items | CreatedDate | datetimeoffset | not null | Date when the part purchase item record was created |
inventory_part_purchase_items | UpdatedByUserId | int | null | Identifier of the user who updated the part purchase item. |
inventory_part_purchase_items | UpdatedByUsername | nvarchar(100) | null | Name of the user who updated the part purchase item. |
inventory_part_purchase_items | UpdatedDate | datetimeoffset | not null | Date when the part purchase item record was updated |
inventory_part_purchase_items | ReceivedDate | datetimeoffset | null | Date when the part purchase item was received |
inventory_part_purchase_items | WoNumber | nvarchar(20) | null | WO Tracking Number |
inventory_part_purchase_items | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_part_purchase_items | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_part_transit | InventoryPartTransitId | int | not null | System generated unique identifier for the part transit record |
inventory_part_transit | FromInventoryLocationId | int | null | Identifier of the inventory location from which transit is made. |
inventory_part_transit | ToInventoryLocationId | int | null | Identifier of the inventory location to which transit is made. |
inventory_part_transit | SentByUserId | int | null | Identifier of the user who initiated the part transit. |
inventory_part_transit | SentByUsername | nvarchar(100) | null | Name of the user who initiated the part transit. |
inventory_part_transit | ReceivedByUserId | int | null | Identifier of the user who received the part transit. |
inventory_part_transit | ReceivedByUsername | nvarchar(100) | null | Name of the user who received the part transit. |
inventory_part_transit | TransitState | nvarchar(50) | null | Part Transit State (e.g: Received, Open, Picking, Shipped, Partially Received, Canceled) |
inventory_part_transit | Immediate | bit | not null | Flag that indicates if the transit is immediate |
inventory_part_transit | TransitType | nvarchar(50) | null | Part Transit Type (e.g: Standard, Store, Restocking, Purchasing, WorkOrderTransfer) |
inventory_part_transit | TransferDate | datetimeoffset | null | Date of transfer |
inventory_part_transit | Description | nvarchar(150) | null | Description |
inventory_part_transit | ShipDate | datetimeoffset | null | Date shipped |
inventory_part_transit | ModifiedByUserId | int | null | Identifier of the user who modified the part transit record. |
inventory_part_transit | ModifiedByUsername | nvarchar(100) | null | Name of the user who modified the part transit record. |
inventory_part_transit | DateModified | datetimeoffset | null | Date when the part transit record was modified |
inventory_part_transit | PartsOnOrderWorkorderId | int | null | |
inventory_part_transit | CreatedDateInDataDirect | datetime | null | |
inventory_part_transit | UpdatedDateInDataDirect | datetime | null | |
inventory_part_transit_items | InventoryPartTransitItemId | int | not null | |
inventory_part_transit_items | InventoryPartTransitId | int | not null | |
inventory_part_transit_items | InventoryPartId | int | not null | |
inventory_part_transit_items | FromInventoryStockId | int | null | |
inventory_part_transit_items | ToInventoryStockId | int | null | |
inventory_part_transit_items | Qty | int | null | |
inventory_part_transit_items | UnitPrice | int | null | |
inventory_part_transit_items | QuantityRequested | decimal | null | |
inventory_part_transit_items | QuantityTransferred | decimal | null | |
inventory_part_transit_items | QuantityReceived | decimal | null | |
inventory_part_transit_items | QuantityLost | decimal | null | |
inventory_part_transit_items | DateReceived | datetimeoffset | null | |
inventory_part_transit_items | PartUnitPrice | decimal | not null | |
inventory_part_transit_items | WoNumber | nvarchar(20) | null | |
inventory_part_transit_items | ToInventoryLocationId | int | null | |
inventory_part_transit_items | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_part_transit_items | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_part_usage | InventoryPartUsageId | int | not null | |
inventory_part_usage | SubId | int | not null | |
inventory_part_usage | UsageToken | nvarchar(100) | not null | |
inventory_part_usage | CreatedDate | datetimeoffset | not null | |
inventory_part_usage | ModifiedDate | datetimeoffset | not null | |
inventory_part_usage | WoNumber | nvarchar(20) | null | |
inventory_part_usage | WoLocationId | int | null | |
inventory_part_usage | WoStoreId | nvarchar(50) | null | |
inventory_part_usage | WoLocationName | nvarchar(100) | null | |
inventory_part_usage | PoNumber | nvarchar(50) | null | |
inventory_part_usage | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_part_usage | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_part_usage_items | InventoryPartUsageItemId | int | not null | |
inventory_part_usage_items | InventoryPartUsageId | int | not null | |
inventory_part_usage_items | InventoryPartId | int | not null | |
inventory_part_usage_items | InventoryStockId | int | not null | |
inventory_part_usage_items | UserId | int | null | |
inventory_part_usage_items | Username | nvarchar(100) | null | |
inventory_part_usage_items | Qty | decimal | not null | |
inventory_part_usage_items | CreatedDate | datetimeoffset | not null | |
inventory_part_usage_items | ModifiedDate | datetimeoffset | not null | |
inventory_part_usage_items | Deleted | bit | not null | |
inventory_part_usage_items | Recovered | bit | not null | |
inventory_part_usage_items | UnitPrice | decimal | not null | |
inventory_part_usage_items | UseDate | datetimeoffset | null | |
inventory_part_usage_items | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_part_usage_items | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_parts | InventoryPartId | int | not null | |
inventory_parts | PartTypeName | nvarchar(100) | null | |
inventory_parts | PartTypeDescription | nvarchar(2000) | null | |
inventory_parts | SubId | int | not null | |
inventory_parts | PartNumber | nvarchar(100) | null | |
inventory_parts | PartName | nvarchar(100) | null | |
inventory_parts | UnitOfMeasure | nvarchar(100) | null | |
inventory_parts | UpcCode | nvarchar(20) | null | |
inventory_parts | PartDescription | nvarchar(2000) | null | |
inventory_parts | PartCategory | nvarchar(100) | null | |
inventory_parts | Price | decimal | not null | |
inventory_parts | CurrencyCode | varchar(3) | null | |
inventory_parts | IsActive | bit | not null | |
inventory_parts | IsStandard | bit | not null | |
inventory_parts | IsRegulated | bit | not null | |
inventory_parts | PriceValuation | int | not null | |
inventory_parts | Supplier | nvarchar(100) | null | |
inventory_parts | AveragePrice | decimal | null | |
inventory_parts | ReplacementPrice | decimal | null | |
inventory_parts | EquipmentType | nvarchar(100) | null | |
inventory_parts | NonCatalog | bit | null | |
inventory_parts | CreatedByUserId | int | null | |
inventory_parts | CreatedByUsername | nvarchar(100) | null | |
inventory_parts | CreatedDate | datetimeoffset | not null | |
inventory_parts | UpdatedByUserId | int | null | |
inventory_parts | UpdatedByUsername | nvarchar(100) | null | |
inventory_parts | UpdatedDate | datetimeoffset | not null | |
inventory_parts | AutoRestock | bit | not null | |
inventory_parts | ManufacturerNumber | nvarchar(100) | null | |
inventory_parts | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_parts | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_stock | InventoryStockId | int | not null | |
inventory_stock | InventoryLocationId | int | not null | |
inventory_stock | InventoryPartId | int | not null | |
inventory_stock | Qty | decimal | not null | |
inventory_stock | UnitPrice | decimal | not null | |
inventory_stock | CreatedByUserId | int | null | |
inventory_stock | CreatedByUsername | nvarchar(100) | null | |
inventory_stock | CreatedDate | datetimeoffset | not null | |
inventory_stock | UpdatedByUserId | int | null | |
inventory_stock | UpdatedByUsername | nvarchar(100) | null | |
inventory_stock | UpdatedDate | datetimeoffset | not null | |
inventory_stock | Area | nvarchar(20) | null | |
inventory_stock | Aisle | nvarchar(20) | null | |
inventory_stock | Shelf | nvarchar(20) | null | |
inventory_stock | Bin | nvarchar(20) | null | |
inventory_stock | MinQty | int | null | |
inventory_stock | MaxQty | int | null | |
inventory_stock | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_stock | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
inventory_stock_manual_change | InventoryStockManualChangeId | int | not null | |
inventory_stock_manual_change | InventoryStockId | int | not null | |
inventory_stock_manual_change | InventoryPartId | int | not null | |
inventory_stock_manual_change | ChangedByUserId | int | null | |
inventory_stock_manual_change | ChangedByUsername | nvarchar(100) | null | |
inventory_stock_manual_change | ChangedDate | datetimeoffset | null | |
inventory_stock_manual_change | Qty | decimal | not null | |
inventory_stock_manual_change | Comment | nvarchar(255) | null | |
inventory_stock_manual_change | Price | decimal | not null | |
inventory_stock_manual_change | ReasonId | int | null | |
inventory_stock_manual_change | Reason | nvarchar(100) | null | |
inventory_stock_manual_change | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
inventory_stock_manual_change | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
invoice_labor | ID | int | PK, not null | Unique identifier for Invoice labor record |
invoice_labor | InvoiceID | int | not null | Unique identifier for the Invoice record. |
invoice_labor | SkillLevel | varchar(10) | null | Skill level of the labor(Supervisor, Technician, Helper). |
invoice_labor | Type | varchar(10) | null | Labor type (Regular, Overtime, DoubleTime). |
invoice_labor | NumberOfTechs | tinyint | not null | Number of technicians |
invoice_labor | HourlyRate | money | not null | Line item Hourly rate |
invoice_labor | Hours | decimal(9,2) | null | Line item Hours |
invoice_labor | Amount | money | not null | Line item amount |
invoice_labor | LineNumber | smallint | null | Line Item number |
invoice_labor | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
invoice_labor | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
invoice_materials | ID | int | PK, not null | Unique identifier for Invoice materials record. |
invoice_materials | InvoiceID | int | not null | Unique identifier for the Invoice record. |
invoice_materials | Description | varchar(100) | null | Invoice materials description |
invoice_materials | PartNumber | varchar(100) | null | Invoice materials part number |
invoice_materials | Unit | varchar(5) | null | Invoice materials unit type (Each, Box, Feet, Sq ft, Lbs,Gal, Oz) |
invoice_materials | UnitPrice | money | not null | Line item Unit price |
invoice_materials | Quantity | decimal(9,2) | null | Line item Quantity |
invoice_materials | Amount | money | not null | Line item Amount |
invoice_materials | LineNumber | smallint | null | Line Item number |
invoice_materials | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
invoice_materials | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
invoice_statuses | status | varchar(50) | null | OPEN,APPROVED,REVIEWED,ON HOLD,PAID,VOID,DISPUTED,REJECTED |
invoice_statuses | id | int | not null | Unique ID of invoice status |
invoice_statuses | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
invoice_statuses | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
invoices | InvoiceID | int | not null | System generated unique identifier for the invoice record. |
invoices | invoiceNumber | varchar(50) | not null | Invoice number |
invoices | invoiceDate | datetime | not null | Datetime of invoice |
invoices | laborAmount | money | null | Labor charge amount |
invoices | materialAmount | money | null | material charge amount |
invoices | travelAmount | money | null | Travel charge amount |
invoices | freightAmount | money | null | Freight charge amount |
invoices | taxAmount | money | null | Invocie Tax |
invoices | otheramount | money | null | Other charge amount |
invoices | otherdescription | varchar(255) | null | Other charge description |
invoices | total | money | null | Invoice total amount |
invoices | subtotal | money | null | Invoice amount without tax |
invoices | postedDate | datetime | null | Datetime when invoice was posted |
invoices | lastModifiedDate | datetime | null | Datetime when invoice was updated |
invoices | glCode | varchar(40) | null | Invoice Approval code |
invoices | createdDate | datetime | null | Datetime when invoice was created |
invoices | approvedDate | datetime | null | Datetime when invoice was approved |
invoices | approvedDateDto | datetimeoffset | null | Datetime when invoice was approved |
invoices | approvedBy | nvarchar(50) | null | Approved by user |
invoices | lastPaymentDate | datetime | null | Last payment date time |
invoices | LastPaymentDateDto | datetimeoffset | null | Last payment date time |
invoices | postedDateDto | datetimeoffset | null | Datetime when invoice was posted |
invoices | createddateDto | datetimeoffset | null | Datetime when invoice was updated |
invoices | Comments | varchar(2000) | null | Invoice comment |
invoices | postedBy | varchar(50) | null | Posted by user |
invoices | isMarkedForAudit | bit | null | Is there an invoice audit record for this invoice? (Yes=1, No=0) |
invoices | invoiceStatusID | int | not null | ID of the invoice status (invoice_statuses) |
invoices | trackingNumber | int | not null | WO tracking number |
invoices | lastPaymentNumber | varchar(100) | null | Payment Number |
invoices | paymentAmount | money | null | Payment amount |
invoices | paymentDate | smalldatetime | null | Payment date |
invoices | paymentBy | varchar(50) | null | Paid by user |
invoices | vendorPayeeID | int | null | ID of Vendor Payee |
invoices | currency | varchar(50) | null | currency of the associated work order |
invoices | TransferDate | datetime | null | When invoice was posted to subscriber by EDI |
invoices | transferredDateDto | datetime | null | When invoice was posted to subscriber by EDI |
invoices | CreatedDateInDataDirect | datetime | null | The date and time that this record was inserted in Data Direct Table. |
invoices | UpdatedDateInDataDirect | datetime | null | The date and time that this record was last updated in Data Direct Table. |
invoices | InvoiceText | nvarchar(4000) | null | Additional text for the invoice |
invoices | Tax1 | money | null | Tax1 Amount (for invoices having multiple tax rates) |
invoices | Tax2 | money | null | Tax2 Amount (for invoices having multiple tax rates) |
invoices | Tax2Name | varchar(10) | null | Tax2 Name |
