Overview
Configuration is provided for establishing connections with the Fiix CMMS service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this guide, we will show you step-by-step how to create a connection to Fiix CMMS REST API using COZYROC's REST Connection Manager.
Step 1: Run Visual Studio under Administrator account. Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2: From the drop-down menu Configuration select Fiix CMMS.
Step 3: Set [your-instance] to the desired instance in the Server host parameter. Then provide values for parameters appkey, accessKey and secretKey in the grid below.
Step 4: Click Test Connection to test your connection.
Congratulations! You have now established a connection to your Fiix CMMS instance.
This guide demonstrates how to read data from the Fiix CMMS service resource using the COZYROC REST Source component.
Step 1: Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open SSIS Toolbox and drag and drop COZYROC REST Source component.
Step 3: Double click on the REST Source component and select Fiix CMMS connection from the combo. Then, select the desired Fiix CMMS resource from the second dropdown.
Optionally, you can add extra parameters in the grid below if needed.
Step 4: Click on the Columns tab and select Fiix CMMS resource columns you want to read.
Step 5: Click Preview to verify that all necessary resource columns are included.
Congratulations! You've successfully learned how to read data from the Fiix CMMS service.
This guide explains how to write data to the Fiix CMMS service resource using the COZYROC REST Destination component.
Step 1: Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2: Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3: Double click on the REST Destination component and select Fiix CMMS connection from the combo. Also, select resource action and Fiix CMMS resource you want to work on.
Step 4: Click on the "Mapping" tab and map the input columns for the process you are configuring.
If you want to provide input for other resource composite objects, change the input above and map the columns.
Done. You have now learned how to write data into the Fiix CMMS resource.
Configuration
Base URL address: https://[your-instance].macmms.com.
- Basic
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- appKey: Required. Specify the app key.
- accessKey: Required. Specify the access key.
- secretKey: Required. Specify the secret.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
{{=sha256.makeAuthorization(request, connection)}} -
appKey:
{{=connection.user.appKey}} -
accessKey:
{{=connection.user.accessKey}} -
signatureMethod:
HmacSHA256 -
signatureVersion:
1
Documentation: https://fiixlabs.github.io/api-documentation/index.html#/ApiDoc#Authentication.
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strCode
Template: ShortText.
- strDescription
Template: LongText.
- strUuid
Template: Guid. A read-only field.
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAccountID
Data type: DT_I4
- intChargeDepartmentID
Data type: DT_I4
- intSuperCategorySysCode
Data type: DT_I4
- bolIsRegion
Data type: DT_BOOL A read-only field.
- bolIsShippingOrReceivingFacility
Data type: DT_BOOL
- bolIsSite
Data type: DT_BOOL A read-only field.
- dblWeightedPrice
Data type: DT_R8
- dtmCreated
Data type: DT_R8 A read-only field.
- created
Template: UnixTime. A read-only field.
- intAssetParentID
Data type: DT_I4
- intCategoryID
Data type: DT_I4
- intKind
Data type: DT_I4 A read-only field.
- intSiteID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- qtyStockCount
Data type: DT_I4
- strShippingTerms
Template: ShortText.
- strCode
Template: ShortText.
- strCustomerIds
Template: ShortText. A read-only field.
- strStockLocation
Template: ShortText. A read-only field.
- strRFQTriggerSiteLevelSetting
Template: ShortText.
- strCriticality
Template: ShortText. A read-only field.
- strVendorIds
Template: ShortText. A read-only field.
- strCity
Template: ShortText.
- strBarcode
Template: ShortText.
- strPostalCode
Template: ShortText.
- strSerialNumber
Template: ShortText.
- strAddress
Template: ShortText.
- strNotes
Template: ShortText.
- strProvince
Template: ShortText.
- strName
Template: ShortText.
- strMake
Template: ShortText.
- strModel
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- strAddressParsed
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- intCountryID
Data type: DT_I4
- strInventoryCode
Template: ShortText.
- strRow
Template: ShortText.
- strMASourceProduct
Template: LongText. A composite field.
- strAisle
Template: ShortText.
- strBinNumber
Template: ShortText.
- dblLatitude
Data type: DT_R8
- dblLongitude
Data type: DT_R8
- dblLastPrice
Data type: DT_R8
- strUnspcCode
Template: ShortText.
- intAssetLocationID
Data type: DT_I4
- bolIsBillToFacility
Data type: DT_BOOL
- bolIsOnline
Data type: DT_BOOL
- strQuotingTerms
Template: ShortText.
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAccountID, dv_intCategoryID, dv_intSiteID, dv_intCountryID, dv_intAssetLocationID, dv_intChargeDepartmentID, dv_intAssetParentID, cf_intDefaultImageFileThumbnailID, cf_intDefaultImageFileID, cf_intAddressAssetID, cf_assetAddressString.
-
Uses template:
- [External]
-
The external fields URL address:
/api/. The external fields list is extracted from:{{=Fiix.getCustomFields(response)}}.
Based on resource template Base.
- id
Data type: DT_I4
- intBusinessID
Data type: DT_I4
- intBusinessRoleTypeID
Data type: DT_I4
- intAssetID
Data type: DT_I4
- bolSendRFQs
Data type: DT_BOOL
- bolPreferredVendor
Data type: DT_BOOL
- qtyEconomicBatchQuantity
Data type: DT_I4
- strBusinessAssetNumber
Template: ShortText.
- intBusinessGroupID
Data type: DT_I4
- strUuid
Template: Guid. A read-only field.
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intBusinessID, dv_intBusinessRoleTypeID, dv_intBusinessGroupID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- intParentID
Data type: DT_I4
- intSysCode
Data type: DT_I4
- bolOverrideRules
Data type: DT_BOOL
- strUuid
Template: Guid. A read-only field.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intParentID, cf_strBarcodeFormatType.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intSiteID
Data type: DT_I4
- qtyAnnualUsage
Data type: DT_I4
- intClassificationID
Data type: DT_I4
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intSiteID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intSiteID
Data type: DT_I4
- dtmDateApplied
Data type: DT_R8 A read-only field.
- dateApplied
Template: UnixTime. A read-only field.
- intClassificationID
Data type: DT_I4
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intSiteID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intConsumesAssetID
Data type: DT_I4
- intBOMControlID
Data type: DT_I4
- intBOMPartControlID
Data type: DT_I4
- qtyMaxConsumption
Data type: DT_I4
- strUuid
Template: Guid. A read-only field.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- className
Template: ShortText.
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intConsumesAssetID, dv_intBOMPartControlID, dv_intBOMControlID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intAssetEventTypeID
Data type: DT_I4
- intSubmittedByUserID
Data type: DT_I4
- dtmDateSubmitted
Data type: DT_R8 A read-only field.
- dateSubmitted
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- className
Template: ShortText.
- strAdditionalDescription
Template: LongText.
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetEventTypeID, dv_intAssetID, dv_intSubmittedByUserID, dv_intWorkOrderID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- strEventCode
Template: ShortText.
- strEventDescription
Template: LongText.
- strEventName
Template: ShortText.
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- className
Template: ShortText.
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmOffLineTo
Data type: DT_R8
- offLineTo
Template: UnixTime.
- dtmOfflineFrom
Data type: DT_R8
- offlineFrom
Template: UnixTime.
- intAssetID
Data type: DT_I4
- intReasonOfflineID
Data type: DT_I4
- intReasonOnlineID
Data type: DT_I4
- intSetOfflineByUserID
Data type: DT_I4
- intSetOnlineByUserID
Data type: DT_I4
- intWorkOrderID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strOfflineAdditionalInfo
Template: ShortText.
- strOnlineAdditionalInfo
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- updateLocation
Data type: DT_BOOL
- generateEvent
Data type: DT_BOOL
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intWorkOrderID, dv_intSetOfflineByUserID, dv_intSetOnlineByUserID, dv_intReasonOfflineID, dv_intReasonOnlineID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmDateAdded
Data type: DT_R8
- dateAdded
Template: UnixTime.
- intAssetID
Data type: DT_I4
- intAssetUserTypeID
Data type: DT_I4
- intUserID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intUserID, dv_intAssetID, dv_intAssetUserTypeID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmLastUpdated
Data type: DT_R8
- lastUpdated
Template: UnixTime.
- intCreatedByUserID
Data type: DT_I4
- intLastUpdatedByUserID
Data type: DT_I4
- strName
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intCreatedByUserID, dv_intLastUpdatedByUserID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetID
Data type: DT_I4
- intBOMGroupID
Data type: DT_I4
- qtyMaxConsumption
Data type: DT_I4
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intBOMGroupID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intPrimaryCurrencyID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strCode
Template: ShortText.
- strProvince
Template: ShortText.
- strPostalCode
Template: ShortText.
- strTimezone
Template: ShortText.
- strPrimaryEmail
Template: ShortText.
- strName
Template: ShortText.
- strPhone
Template: ShortText.
- strFax
Template: ShortText.
- intCountryID
Data type: DT_I4
- strAddress
Template: ShortText.
- strPrimaryContact
Template: ShortText.
- strNotes
Template: ShortText.
- strPhone2
Template: ShortText.
- strCity
Template: ShortText.
- strSecondaryEmail
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- timeZone
Template: ShortText.
- strAddressParsed
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intCountryID, dv_intPrimaryCurrencyID, cf_intDefaultImageFileID, cf_intDefaultImageFileThumbnailID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolIsDefaultSupplier
Data type: DT_BOOL
- intRelationshipType
Data type: DT_I4
- strName
Template: ShortText.
- strUuid
Template: ShortText. A read-only field.
- vendor
Data type: DT_BOOL
- customer
Data type: DT_BOOL
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intBusinessGroupID
Data type: DT_I4
- intBusinessID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intBusinessGroupID, dv_intBusinessID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmDate
Data type: DT_R8
- date
Template: UnixTime.
- intScheduleTriggerID
Data type: DT_I4
- intScheduledMaintenanceID
Data type: DT_I4
- hasIssues
Data type: DT_BOOL
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intScheduleTriggerID, dv_intScheduledMaintenanceID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intFacilityID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strCode
Template: ShortText.
- strDescription
Template: LongText.
- strUuid
Template: Guid. A read-only field.
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intFacilityID, cf_intSiteID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strISOCode
Template: ShortText.
- strName
Template: ShortText.
- strDescription
Template: ShortText.
- strSymbol
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolComplete
Data type: DT_BOOL
- bolIncludeClassA
Data type: DT_BOOL
- bolIncludeClassB
Data type: DT_BOOL
- bolIncludeClassC
Data type: DT_BOOL
- bolIncludeNotClassified
Data type: DT_BOOL
- dblGrossVariance
Data type: DT_R8 A read-only field.
- dblNetVariance
Data type: DT_R8 A read-only field.
- dblTotalValueCounted
Data type: DT_R8 A read-only field.
- dblTotalValueExpected
Data type: DT_R8 A read-only field.
- dtmCreated
Data type: DT_R8
- created
Template: UnixTime.
- dtmCompleted
Data type: DT_R8
- completed
Template: UnixTime.
- intCreatedBy
Data type: DT_I4
- intCompletedBy
Data type: DT_I4
- intSiteID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strUuid
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intCompletedBy, dv_intCreatedBy, dv_intSiteID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblCostPerUnit
Data type: DT_R8
- dblTotalCost
Data type: DT_R8
- dtmDate
Template: ShortText.
- intInventoryChargeID
Data type: DT_I4
- intInventoryChargedForID
Data type: DT_I4
- intInventoryChargedFromID
Data type: DT_I4
- intStockTxTypeID
Data type: DT_I4
- qtyTxQuantity
Data type: DT_R8
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSysCode
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strColor
Template: ShortText.
- strName
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblMeterReading
Data type: DT_R8
- dtmDateSubmitted
Data type: DT_R8
- dateSubmitted
Template: UnixTime.
- intAssetID
Data type: DT_I4
- intMeterReadingUnitsID
Data type: DT_I4
- intSubmittedByUserID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strUuid
Template: Guid. A read-only field.
- justInsertedFromGui
Data type: DT_BOOL
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- intWorkOrderID
Data type: DT_I4
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intWorkOrderID, dv_intMeterReadingUnitsID, dv_intAssetID, dv_intSubmittedByUserID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intPrecision
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- strSymbol
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strUuid
Template: Guid. A read-only field.
- strDescription
Template: ShortText.
- qtyQuantity
Data type: DT_I4
- qtyEstQuantity
Data type: DT_I4
- intWorkOrderID
Data type: DT_I4
- intMiscCostTypeID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- dblEstimatedUnitCost
Data type: DT_R8
- dblEstimatedTotalCost
Data type: DT_R8
- dblActualUnitCost
Data type: DT_R8
- dblActualTotalCost
Data type: DT_R8
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intMiscCostTypeID, dv_intWorkOrderID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strUuid
Template: Guid. A read-only field.
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strUuid
Template: Guid. A read-only field.
- intSysCode
Data type: DT_I4
- intOrder
Data type: DT_I4
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSiteID
Data type: DT_I4
- dtmActualEndDate
Data type: DT_R8
- actualEndDate
Template: UnixTime.
- strUuid
Template: Guid. A read-only field.
- strName
Template: ShortText.
- strDescription
Template: LongText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- dtmActualStartDate
Data type: DT_R8
- actualStartDate
Template: UnixTime.
- dtmProjectedEndDate
Data type: DT_R8
- projectedEndDate
Template: UnixTime.
- dtmProjectedStartDate
Data type: DT_R8
- projectedStartDate
Template: UnixTime.
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intSiteID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblSubtotal
Data type: DT_R8 A read-only field.
- dblTotal
Data type: DT_R8 A read-only field.
- dtmDateCreated
Data type: DT_R8 A read-only field.
- dateCreated
Template: UnixTime. A read-only field.
- dtmDateExpectedDelivery
Data type: DT_R8
- dateExpectedDelivery
Template: UnixTime.
- dtmDateSubmitted
Data type: DT_R8
- dateSubmitted
Template: UnixTime.
- intBillingTermID
Data type: DT_I4
- intChargeDepartmentID
Data type: DT_I4
- intCode
Data type: DT_I4
- intCreatedByUserID
Data type: DT_I4 A read-only field.
- intPurchaseOrderStatusID
Data type: DT_I4
- intSendToSupplierMethod
Data type: DT_I4
- intSiteID
Data type: DT_I4
- intSupplierID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dtmDateLastUpdated
Data type: DT_R8 A read-only field.
- dateLastUpdated
Template: UnixTime. A read-only field.
- dtmDateReceived
Data type: DT_R8
- dateReceived
Template: UnixTime.
- dtmDateRequiredBy
Data type: DT_R8
- dateRequiredBy
Template: UnixTime.
- intAccountID
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intBillToCountryID
Data type: DT_I4
- intBillToID
Data type: DT_I4
- intLastUpdatedUserID
Data type: DT_I4 A read-only field.
- intPurchaseCurrencyID
Data type: DT_I4
- intShipToCountryID
Data type: DT_I4
- intShipToID
Data type: DT_I4
- intSupplierCountryID
Data type: DT_I4
- intWorkOrderID
Data type: DT_I4
- strBillToAddress
Template: ShortText.
- strBillToCity
Template: ShortText.
- strBillToPostalCode
Template: ShortText.
- strBillToProvince
Template: ShortText.
- strPurchaseOrderReference
Template: ShortText.
- strShipToAddress
Template: ShortText.
- strShipToCity
Template: ShortText.
- strShipToPostalCode
Template: ShortText.
- strShipToProvince
Template: ShortText.
- strSupplierAddress
Template: ShortText.
- strSupplierCity
Template: ShortText.
- strSupplierPostalCode
Template: ShortText.
- strSupplierProvince
Template: ShortText.
- strTransactionID
Template: ShortText.
- intLocationID
Data type: DT_I4 A read-only field.
- dblFreight
Data type: DT_R8 A read-only field.
- dblTax1
Data type: DT_R8 A read-only field.
- dblTax2
Data type: DT_R8 A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intBillingTermID, dv_intChargeDepartmentID, dv_intCreatedByUserID, dv_intPurchaseOrderStatusID, dv_intSiteID, dv_intSupplierID, dv_intAccountID, dv_intAssetID, dv_intBillToCountryID, dv_intBillToID, dv_intLastUpdatedUserID, dv_intPurchaseCurrencyID, dv_intShipToCountryID, dv_intShipToID, dv_intSupplierCountryID, dv_intWorkOrderID, dv_intLocationID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblTaxRate
Data type: DT_R8
- dblPrice
Data type: DT_R8
- intBusinessID
Data type: DT_I4
- intShippingTypeID
Data type: DT_I4
- intPurchaseOrderAdditionalCostTypeID
Data type: DT_I4
- strDescription
Template: LongText.
- dirty
Data type: DT_BOOL
- bolOverridePoLineItemTax
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intBusinessID, dv_intPurchaseOrderAdditionalCostTypeID, dv_intPurchaseOrderID, dv_intShippingTypeID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSysCode
Data type: DT_I4
- bolAlwaysShowOnNewPo
Data type: DT_BOOL
- intControlID
Data type: DT_I4
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolAddedDirectlyToPurchaseOrder
Data type: DT_BOOL
- bolProductionEquipmentDownWhileOnOrder
Data type: DT_BOOL
- dblRemoteOrgUnitPrice
Data type: DT_R8
- dblTaxRate
Data type: DT_R8
- dblUnitPrice
Data type: DT_R8
- dtmDateCreated
Data type: DT_R8 A read-only field.
- dateCreated
Template: UnixTime. A read-only field.
- intAssetID
Data type: DT_I4
- intAccountID
Data type: DT_I4
- dtmRequiredByDate
Data type: DT_R8 A read-only field.
- requiredByDate
Template: UnixTime. A read-only field.
- intChargeDepartmentID
Data type: DT_I4
- intPurchaseOrderID
Data type: DT_I4
- intRequestedByUserID
Data type: DT_I4
- intSiteID
Data type: DT_I4 A read-only field.
- intSourceAssetID
Data type: DT_I4
- intSourceWorkOrderID
Data type: DT_I4
- intStockHistoryID
Data type: DT_I4
- intStockID
Data type: DT_I4
- intSupplierID
Data type: DT_I4
- qtyOnOrder
Data type: DT_I4
- qtyRecieved
Data type: DT_I4
- strDescription
Template: LongText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAccountID, dv_intAssetID, dv_intChargeDepartmentID, dv_intPurchaseOrderID, dv_intRequestedByUserID, dv_intShipToLocationID, dv_intSiteID, dv_intSourceAssetID, dv_intSourceWorkOrderID, dv_intStockHistoryID, dv_intStockID, dv_intSupplierID, dv_intParentPurchaseOrderLineItemID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmDateLogged
Data type: DT_R8 A read-only field.
- dateLogged
Template: UnixTime. A read-only field.
- intPurchaseOrderID
Data type: DT_I4
- intFromStatusId
Data type: DT_I4
- intToStatusId
Data type: DT_I4
- intUserID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSysCode
Data type: DT_I4
- intControlID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- strDefaultLabel
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strCode
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strDescription
Template: ShortText.
- dirty
Data type: DT_BOOL
- bolActive
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strCode
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strDescription
Template: ShortText.
- dirty
Data type: DT_BOOL
- bolActive
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetCategoryID
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intRCAProblemID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intRCAGroupingID
Data type: DT_I4
- intRCAActionID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intRCACauseID
Data type: DT_I4
- intRCAGroupingID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strCode
Template: ShortText.
- strDescription
Template: ShortText.
- bolActive
Data type: DT_BOOL
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSiteID
Data type: DT_I4
- intCode
Data type: DT_I4
- intRFQStatusID
Data type: DT_I4
- intCreatedByUserID
Data type: DT_I4
- dtmDateRequiredResponse
Data type: DT_R8
- dateRequiredResponse
Template: UnixTime.
- dtmDateExpectedDelivery
Data type: DT_R8
- dateExpectedDelivery
Template: UnixTime.
- dtmDateSent
Data type: DT_R8 A read-only field.
- dateSent
Template: UnixTime. A read-only field.
- intBusinessID
Data type: DT_I4
- strMessageContent
Template: LongText.
- strMessageSubject
Template: LongText.
- intSupplierID
Data type: DT_I4
- strSupplierAddress
Template: ShortText.
- strSupplierCity
Template: ShortText.
- strSupplierPostalCode
Template: ShortText.
- strSupplierProvince
Template: ShortText.
- intSupplierCountryID
Data type: DT_I4
- intBillToID
Data type: DT_I4
- strBillToAddress
Template: ShortText.
- strBillToCity
Template: ShortText.
- strBillToPostalCode
Template: ShortText.
- strBillToProvince
Template: ShortText.
- intBillToCountryID
Data type: DT_I4
- intShipToID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- strShipToAddress
Template: ShortText.
- strShipToCity
Template: ShortText.
- strShipToPostalCode
Template: ShortText.
- strShipToProvince
Template: ShortText.
- intShipToCountryID
Data type: DT_I4
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intBillToCountryID, dv_intBillToID, dv_intBusinessID, dv_intCreatedByUserID, dv_intRFQStatusID, dv_intShipToCountryID, dv_intShipToID, dv_intSiteID, dv_intSupplierCountryID, dv_intSupplierID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intRFQID
Data type: DT_I4
- intParentRFQLineItemID
Data type: DT_I4
- intPurchaseOrderLineItemID
Data type: DT_I4
- strDescription
Template: ShortText.
- intAssetID
Data type: DT_I4
- strBusinessAssetNumber
Template: ShortText.
- qtyRequested
Data type: DT_I4
- qtyQuoted
Data type: DT_I4
- dblQuotedPricePerUnit
Data type: DT_R8
- dblQuotedPriceTotal
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intParentRFQLineItemID, dv_intPurchaseOrderLineItemID, dv_intRFQID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strName
Template: ShortText.
- strDefaultLabel
Template: ShortText.
- intSysCode
Data type: DT_I4
- intControlID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- statusControl
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name, defaultLabel, actionName, actionDefaultLabel, color.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strName
Template: ShortText.
- strUuid
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strName
Template: ShortText.
- strUuid
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSiteID
Data type: DT_I4
- dtmDateReceived
Data type: DT_R8
- dateReceived
Template: UnixTime.
- dtmDateOrdered
Data type: DT_R8
- dateOrdered
Template: UnixTime.
- intReceiptStatusID
Data type: DT_I4
- intPurchaseCurrencyID
Data type: DT_I4
- intPurchaseOrderID
Data type: DT_I4
- intCode
Data type: DT_I4
- intSupplierID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strPackingSlip
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intPurchaseCurrencyID, dv_intSiteID, dv_intSupplierID, dv_intReceiptStatusID, dv_intPurchaseOrderID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intStockID
Data type: DT_I4
- dtmDateExpiryOfInventoryItems
Data type: DT_R8
- dateExpiryOfInventoryItems
Template: UnixTime.
- qtyQuantityReceived
Data type: DT_I4
- qtyQuantityOrdered
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intReceiptID
Data type: DT_I4
- strDescription
Template: LongText.
- intParentReceiptLineItemID
Data type: DT_I4
- intPurchaseOrderLineItemID
Data type: DT_I4
- intReceiveToStockID
Data type: DT_I4
- dblPurchasePricePerUnit
Data type: DT_R8
- intReceiveToFacilityID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
A read-only field. Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intReceiptID, dv_intAssetID, dv_intPurchaseOrderLineItemID, dv_intReceiveToStockID, dv_intReceiveToFacilityID, dv_intStockID, dv_intParentReceiptLineItemID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intControlID
Data type: DT_I4
- strName
Template: ShortText.
- intSysCode
Data type: DT_I4
- strDefaultLabel
Template: ShortText.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- statusControl
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name, defaultLabel, actionName, actionDefaultLabel, color.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intRegionID
Data type: DT_I4
- intUserID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intRegionID, dv_intUserID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intGroupID
Data type: DT_I4
- intRegionUserID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intGroupID, dv_intRegionUserID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- intChildID
Data type: DT_I4
- intParentID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intChildID, dv_intParentID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolCreateWorkOrderOnStartDate
Data type: DT_BOOL
- bolMrByWOClosed
Data type: DT_BOOL
- bolTSWFriday
Data type: DT_BOOL
- bolTSWMonday
Data type: DT_BOOL
- bolTSWSaturday
Data type: DT_BOOL
- bolTSWSunday
Data type: DT_BOOL
- bolTSWThursday
Data type: DT_BOOL
- bolTSWTuesday
Data type: DT_BOOL
- bolTSWWednesday
Data type: DT_BOOL
- datTRStart
Data type: DT_R8
- dblRMeterReading
Data type: DT_R8
- dblROMeterReading
Data type: DT_R8
- dblRREndBy
Data type: DT_R8
- dblRRStart
Data type: DT_R8
- dblLastMeterReading
Data type: DT_R8
- dtmLastTriggered
Data type: DT_R8
- lastTriggered
Template: UnixTime.
- intAssetID
Data type: DT_I4
- intRMeterReadingUnitID
Data type: DT_I4
- intROMeterReadingUnitID
Data type: DT_I4
- intRREndAfter
Data type: DT_I4
- intScheduledMaintenanceID
Data type: DT_I4
- intTREndAfter
Data type: DT_I4
- intTRTriggerTime
Data type: DT_I4
- intTSDEveryDays
Data type: DT_I4
- intTSHEveryHours
Data type: DT_I4
- intTSMDayOfMonth
Data type: DT_I4
- intTSMEveryMonths
Data type: DT_I4
- intTSWEveryWeeks
Data type: DT_I4
- intTSYDayOfMonth
Data type: DT_I4
- intTSYEveryYears
Data type: DT_I4
- intTSYMonthOfYear
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strDatLogicDaily
Template: ShortText.
- strDatLogicHourly
Template: ShortText.
- strDatLogicMonthly
Template: ShortText.
- strDatLogicYearly
Template: ShortText.
- strMrLogic
Template: ShortText.
- strROType
Template: ShortText.
- strRRType
Template: ShortText.
- strRType
Template: ShortText.
- strScheduleDescription
Template: ShortText.
- strTRType
Template: ShortText.
- strTSType
Template: ShortText.
- strType
Template: ShortText.
- description
Template: LongText.
- triggerTimeDisplayValue
Template: ShortText.
- nonHourlyTimeTrigger
Data type: DT_BOOL
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- datTREndBy
Template: ShortText. A read-only field.
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetEventTypeID, dv_intAssetID, dv_intRMeterReadingUnitID, dv_intROMeterReadingUnitID, dv_intScheduledMaintenanceID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intPriorityID
Data type: DT_I4
- intSiteID
Data type: DT_I4
- intStartAsWorkOrderStatusID
Data type: DT_I4
- intScheduledMaintenanceStatusID
Data type: DT_I4
- intSuggestedCompletion
Data type: DT_I4
- dtmUpdatedDate
Data type: DT_R8
- updatedDate
Template: UnixTime.
- strCode
Template: ShortText.
- strCompletionNotes
Template: ShortText.
- intProjectID
Data type: DT_I4
- dtmCreateDate
Data type: DT_R8
- createDate
Template: UnixTime.
- intMaintenanceTypeID
Data type: DT_I4
- intRequestorUserID
Data type: DT_I4
- strDescription
Template: LongText.
- bolCanFireSMWithOpenWO
Data type: DT_BOOL
- bolWORequiresSignature
Data type: DT_BOOL
- strUuid
Template: Guid. A read-only field.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intChargeDepartmentID
Data type: DT_I4
- intAccountID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intPriorityID, dv_intAccountID, dv_intSiteID, dv_intProjectID, dv_intRequestorUserID, dv_intMaintenanceTypeID, dv_intStartAsWorkOrderStatusID, cf_dvSMAsset, dv_intChargeDepartmentID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetID
Data type: DT_I4
- intScheduledMaintenanceID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intWoOrSmID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strDescription
Template: LongText.
- intCurrentIterationCycle
Data type: DT_I4
- intParentId
Data type: DT_I4
- intMultiplier
Data type: DT_I4
- intNameIdentifier
Data type: DT_I4
- intScheduledMaintenanceID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intParentId, dv_intScheduledMaintenanceID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetID
Data type: DT_I4
- intPartID
Data type: DT_I4
- intScheduledMaintenanceID
Data type: DT_I4
- intStockID
Data type: DT_I4
- qtySuggestedQuantity
Data type: DT_R8
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intPartID, dv_intStockID, dv_intScheduledMaintenanceID, cf_part, cf_partLocation.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolNotifyOnAssignment
Data type: DT_BOOL
- bolNotifyOnCompletion
Data type: DT_BOOL
- bolNotifyOnOnlineOffline
Data type: DT_BOOL
- bolNotifyOnStatusChange
Data type: DT_BOOL
- bolNotifyOnTaskCompleted
Data type: DT_BOOL
- intScheduledMaintenanceID
Data type: DT_I4
- intUserID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intUserID, dv_intScheduledMaintenanceID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblTimeEstimatedHours
Data type: DT_R8
- intAssignedToUserID
Data type: DT_I4
- intOrder
Data type: DT_I4
- intAssetID
Data type: DT_I4
- intMeterReadingUnitID
Data type: DT_I4
- intParentScheduledTaskID
Data type: DT_I4 A read-only field.
- intScheduledMaintenanceID
Data type: DT_I4
- intScheduledMaintenanceNestingID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strDescription
Template: LongText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intSiteID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intUserID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intGroupID
Data type: DT_I4
- intSiteUserID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intSiteUserID, dv_intGroupID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolDeactivated
Data type: DT_BOOL
- intAssetID
Data type: DT_I4
- intFacilityID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- qtyOnHand
Data type: DT_R8
- qtyMinQty
Data type: DT_R8
- qtyMaxQty
Data type: DT_R8
- strBin
Template: ShortText.
- strAisle
Template: ShortText.
- strRow
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intFacilityID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblPrice
Data type: DT_R8 A read-only field.
- intCycleCountID
Data type: DT_I4 A read-only field.
- intStockID
Data type: DT_I4 A read-only field.
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- qtyExpected
Data type: DT_R8 A read-only field.
- qtyStockCount
Data type: DT_R8
- dtmDateCounted
Data type: DT_R8
- dateCounted
Template: UnixTime.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intCountedBy, dv_intCycleCountID, dv_intStockID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblLastPrice
Data type: DT_R8
- dtmDate
Data type: DT_R8
- date
Template: UnixTime.
- intInventoryMethodType
Data type: DT_I4
- intStockID
Data type: DT_I4
- intStockTxID
Data type: DT_I4
- intStockTxTypeID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intUserID
Data type: DT_I4
- qtyAfter
Data type: DT_R8
- qtyBefore
Data type: DT_R8
- qtyMethodQty
Data type: DT_R8
- qtyQuantity
Data type: DT_R8
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- strDescription
Template: ShortText.
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intStockID, dv_intStockTxTypeID, dv_intUserID.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmLastUpdated
Data type: DT_R8 A read-only field.
- lastUpdated
Template: UnixTime. A read-only field.
- intCreatedByUserID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intCreatedByUserID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolApiApplicationUser
Data type: DT_BOOL
- bolApiManaged
Data type: DT_BOOL
- bolGroup
Data type: DT_BOOL
- bolPushNotificationMessages
Data type: DT_BOOL
- intLocalizationID
Data type: DT_I4
- intUpdated
Template: ShortText.
- intUserStatusID
Data type: DT_I4
- strDefaultLoginLocation
Template: ShortText.
- strTelephone2
Template: ShortText.
- strUserTitle
Template: ShortText.
- strPersonnelCode
Template: ShortText.
- strTelephone
Template: ShortText.
- strNotes
Template: LongText.
- strRequestNotes
Template: LongText.
- intCountryID
Data type: DT_I4
- strAddress1
Template: ShortText.
- strAddress2
Template: ShortText.
- strCity
Template: ShortText.
- strPostalCode
Template: ShortText.
- strState
Template: ShortText.
- strEmailAddress
Template: ShortText.
- strFullName
Template: ShortText.
- strPreferences
Template: LongText.
- strUserName
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intLocalizationID, cf_intSiteIDs, cf_intDefaultImageFileID, cf_intDefaultImageFileThumbnailID, dv_intCountryID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intCertificationID
Data type: DT_I4
- intFileContentsID
Data type: DT_I4
- intUserID
Data type: DT_I4
- strDescription
Template: LongText.
- dtmExpiryNotificationSent
Data type: DT_R8 A read-only field.
- expiryNotificationSent
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intCertificationID, dv_intFileContentsID, dv_intUserID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmDateAdded
Data type: DT_R8 A read-only field.
- dateAdded
Template: UnixTime. A read-only field.
- dtmExpiryDate
Data type: DT_R8
- expiryDate
Template: UnixTime.
- intAssetID
Data type: DT_I4
- intMeterReadingUnitsID
Data type: DT_I4
- intProvider
Data type: DT_I4
- intWarrantyTypeID
Data type: DT_I4
- intWarrantyUsageTermTypeID
Data type: DT_I4
- strCertificateNumber
Template: ShortText.
- strDescription
Template: LongText.
- strMeterReadingValueLimit
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intMeterReadingUnitsID, dv_intProvider, dv_intWarrantyTypeID, dv_intWarrantyUsageTermTypeID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolLocked
Data type: DT_BOOL
- dtmDateCompleted
Data type: DT_R8
- dateCompleted
Template: UnixTime.
- dtmDateCreated
Data type: DT_R8
- dateCreated
Template: UnixTime.
- dtmDateLastModified
Data type: DT_R8
- dateLastModified
Template: UnixTime.
- dtmSuggestedStartDate
Data type: DT_R8
- suggestedStartDate
Template: UnixTime.
- intCompletedByUserID
Data type: DT_I4
- intLastModifiedByUserID
Data type: DT_I4 A read-only field.
- intMaintenanceTypeID
Data type: DT_I4
- intPriorityID
Data type: DT_I4
- intScheduledMaintenanceID
Data type: DT_I4 A read-only field.
- intSiteID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intWorkOrderStatusID
Data type: DT_I4
- strAssetIds
Template: ShortText. A read-only field.
- strAssets
Template: ShortText. A read-only field.
- strCode
Template: ShortText.
- strCompletedByUserIds
Template: ShortText. A read-only field.
- strCompletedByUsers
Template: ShortText. A read-only field.
- strUuid
Template: Guid. A read-only field.
- statusId
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- strAssignedUserIds
Template: ShortText. A read-only field.
- strAssignedUsers
Template: ShortText. A read-only field.
- intRequestedByUserID
Data type: DT_I4
- strEmailUserGuest
Template: ShortText.
- strDescription
Template: ShortText.
- strNameUserGuest
Template: ShortText.
- dtmSuggestedCompletionDate
Data type: DT_R8
- suggestedCompletionDate
Template: UnixTime.
- strPhoneUserGuest
Template: ShortText.
- strCompletionNotes
Template: ShortText.
- bolRequiresSignature
Data type: DT_BOOL A read-only field.
- dtmDateSigned
Data type: DT_R8 A read-only field.
- dateSigned
Template: UnixTime. A read-only field.
- intSignedByUserID
Template: ShortText. A read-only field.
- intWorkOrderStatusGroup
Data type: DT_I4 A read-only field.
- strAdminNotes
Template: ShortText.
- intRCAActionID
Data type: DT_I4
- intRCACauseID
Data type: DT_I4
- intRCAProblemID
Data type: DT_I4
- strCustomerIds
Template: ShortText. A read-only field.
- strVendorIds
Template: ShortText. A read-only field.
- intAccountID
Data type: DT_I4
- intChargeDepartmentID
Data type: DT_I4
- intProjectID
Template: ShortText.
- intOriginWorkOrderTaskID
Data type: DT_I4
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intPriorityID, dv_intRequestedByUserID, dv_intSiteID, dv_intCompletedByUserID, dv_intWorkOrderStatusID, dv_intMaintenanceTypeID, dv_intRCAActionID, dv_intRCACauseID, dv_intRCAProblemID, dv_intScheduledMaintenanceID, dv_intSignedByUserID, dv_intAccountID, dv_intChargeDepartmentID, dv_intProjectID, dv_intOriginWorkOrderTaskID, dv_intLastModifiedByUserID.
-
Uses template:
- [External]
-
The external fields URL address:
/api/. The external fields list is extracted from:{{=Fiix.getCustomFields(response)}}.
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intWorkOrderID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intWorkOrderID
Data type: DT_I4
- intBusinessGroupID
Data type: DT_I4
- intBusinessID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intAssetID, dv_intBusinessGroupID, dv_intBusinessID, dv_intWorkOrderID, cf_intRelationshipType.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intAssetID
Data type: DT_I4
- intPartID
Data type: DT_I4
- intStockID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intWorkOrderID
Data type: DT_I4
- qtyActualQuantityUsed
Data type: DT_I4
- qtySuggestedQuantity
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intWorkOrderID, dv_intPartID, dv_intAssetID, dv_intStockID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- intControlID
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- intStatusControlID
Data type: DT_I4
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- intSysCode
Data type: DT_I4
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- dtmDate
Data type: DT_R8
- date
Template: UnixTime.
- intToWorkOrderStatusID
Data type: DT_I4
- intFromWorkOrderStatusID
Data type: DT_I4
- intUserID
Data type: DT_I4
- intWorkOrderID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- dblTimeEstimatedHours
Data type: DT_R8
- dblTimeSpentHours
Data type: DT_R8
- dtmDateCompleted
Data type: DT_R8
- dateCompleted
Template: UnixTime.
- intAssetID
Data type: DT_I4
- intCompletedByUserID
Data type: DT_I4
- intOrder
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- intWorkOrderID
Data type: DT_I4
- strDescription
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- intTaskType
Template: ShortText.
- strResult
Template: ShortText.
- dtmStartDate
Data type: DT_R8
- startDate
Template: UnixTime.
- intAssignedToUserID
Data type: DT_I4
- intMeterReadingUnitID
Data type: DT_I4
- strTaskNotesCompletion
Template: ShortText.
- intTaskGroupControlID
Data type: DT_I4
- intParentWorkOrderTaskID
Data type: DT_I4
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intWorkOrderID, dv_intMeterReadingUnitID, dv_intAssetID, dv_intParentWorkOrderTaskID, dv_intTaskGroupControlID, dv_intTaskResultValueID, cf_bolIsCompleteable.
-
Uses template:
Based on resource template ReadOnly.
- id
Data type: DT_I4
- className
Template: ShortText.
- intFileID
Data type: DT_I4
- intWorkOrderTaskID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intFileID, dv_intWorkOrderTaskID.
-
Uses template:
Based on resource template Base.
- id
Data type: DT_I4
- className
Template: ShortText.
- bolNotifyOnAssignment
Data type: DT_BOOL
- bolNotifyOnCompletion
Data type: DT_BOOL
- bolNotifyOnOnlineOffline
Data type: DT_BOOL
- bolNotifyOnStatusChange
Data type: DT_BOOL
- bolNotifyOnTaskCompleted
Data type: DT_BOOL
- intUserID
Data type: DT_I4
- intWorkOrderID
Data type: DT_I4
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intWorkOrderID, dv_intUserID.
-
Uses template:
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/api/upload.The following request parameters will be automatically processed:
-
application/json:
{{=undefined}} -
file:
{{=item.content}} -
descriptions:
{{=[{ sourceInfo: item.sourceInfo, sourceIdString: item.sourceIdString, fieldName: 'file' }]}} -
action:
uploadFile
-
application/json:
- id
Data type: DT_I4
- className
Template: ShortText.
- intWorkOrderID
Data type: DT_I4
- intFileContentsID
Data type: DT_I4
- intFileTypeID
Data type: DT_I4
- intSize
Data type: DT_I4
- intUpdated
Data type: DT_R8 A read-only field.
- updated
Template: UnixTime. A read-only field.
- strName
Template: ShortText.
- strUuid
Template: Guid. A read-only field.
- strNotes
Template: LongText.
- size
Template: ShortText.
- strUniqueKey
Template: ShortText.
- dirty
Data type: DT_BOOL
- new
Data type: DT_BOOL
- uideleted
Data type: DT_BOOL
- intAssetID
Data type: DT_I4
- intPurchaseOrderID
Data type: DT_I4
- strLink
Template: ShortText.
- intScheduledMaintenanceID
Data type: DT_I4
- extraFields
Field components:
-
Uses template:
ShortText. - Contains the following components: dv_intWorkOrderID, dv_intAssetID, dv_intPurchaseOrderID, dv_intScheduledMaintenanceID.
-
Uses template:
- sourceInfo
Template: ShortText.
- sourceIdString
Template: ShortText.
- fileName
Template: ShortText.
- content
Data type: DT_IMAGE The gathered value is processed with
{{=Fiix.downloadFile(item)}}expression.
- [Read] action
-
Endpoint URL address:
/api/.
The result is extracted from:{{=response.objects}}.
The action uses POST method.
The result is paginated.The action has the following user-defined parameters:
- filter: Optional in JSON format (e.g) [{ "ql": "id = ?", "parameters": [1] }].
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
action:
FindResponse -
application/json:
{{=Fiix.prepareRequestBody(resource, { _maCn: 'FindRequest', fields: Fiix.getSelectFields(parameters).join(), maxObjects: parameters.batchSize, startIndex: parameters.iterator, filters: parameters.get('filter') && JSON.parse(Fiix.specialParam(parameters.filter)) })}}
- [Read Single] action
-
Endpoint URL address:
/api/.
The result is extracted from:{{=[response.object]}}.
The action uses POST method.
The result is paginated.The action has the following user-defined parameters:
- id: Required. Specify the record identifier.
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
action:
FindResponse -
application/json:
{{=Fiix.prepareRequestBody(resource, { _maCn: 'FindByIdRequest', fields: Fiix.getSelectFields(parameters).join(), id: parameters.id })}}
Based on resource template ReadOnly.
- [Create] action
-
Endpoint URL address:
/api/.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
action:
FindResponse -
application/json:
{{=Fiix.prepareRequestBody(resource, { _maCn: 'AddRequest', object: _.extend(item, { className: Fiix.getClassName(resource) }) })}}
Documentation: https://fiixlabs.github.io/api-documentation/index.html#/ApiDoc#MethodAdd.
-
_includeUserParameters:
- [Update] action
-
Endpoint URL address:
/api/.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
action:
FindResponse -
application/json:
{{=Fiix.prepareRequestBody(resource, { _maCn: 'ChangeRequest', changeFields: _.keys(item).join(','), object: _.extend(item, { className: Fiix.getClassName(resource) }) })}}
Documentation: https://fiixlabs.github.io/api-documentation/index.html#/ApiDoc#MethodChangeRequest.
-
_includeUserParameters:
- [Delete] action
-
Endpoint URL address:
/api/.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
action:
FindResponse -
application/json:
{{=Fiix.prepareRequestBody(resource, { _maCn: 'RemoveRequest', id: item.id })}}
Documentation: https://fiixlabs.github.io/api-documentation/index.html#/ApiDoc#MethodRemove.
-
_includeUserParameters:
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Guid
Data type: DT_GUID
- UnixTime
Data type: DT_DBTIMESTAMP The gathered value is processed with
{{=Fiix.formatUnixToISO8601(field, valueParent)}}expression.- Date
Data type: DT_DBDATE
- Number
Data type: DT_R8
- Boolean
Data type: DT_BOOL
- Integer
Data type: DT_I4
- BigInt
Data type: DT_UI8
Knowledge Base
What's New
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.