Integration Profile Configuration
The following outlines the settings for Databuild Accounts Receivable integration .ini file profiles.
Default initialisation filename:
- Int_DatabuildClaims_Default.ini
Settings
...
Key
...
Description/Setting
...
IntegrationType
...
Description:
Specifies the type of integration to be performed. This is a fixed value that should not be changed.
Setting:
Databuild Claims
...
ODBCConnectionType
...
Description:
Indicates if the Databuild database is SQL Server or Microsoft Access.
Setting:
1: SQL Server
2: Microsoft Access
Databases
...
Key
...
Description/Setting
...
ODBCDSN_Framework
...
Description:
ODBC DSN name for the Framework database.
Setting:
FworkSQLEcm
...
ODBCConnect_Framework
...
Description:
ODBC DSN connection string for the Framework database.
Setting:
None
...
ODBCDSN_FrameworkLicense
...
Description:
ODBC DSN name for the Framework Licence database.
Setting:
FworkSQLLic
...
MultipleForeignDatabase
...
Description:
Allow multiple Databuild databases.
Setting:
0 (default): No
1: Yes
...
ODBCDSN_DataBuildJob
...
Description:
ODBC DSN name of the Databuild Job database.
Setting:
FworkDBuildJob
...
DatabaseName_DataBuildJob
...
Description:
Databuild Job database name.
Setting:
DataBuildJob
...
ODBCConnect_DataBuildJob
...
Description:
ODBC DSN connection string for the Databuild Job database.
Setting:
"uid=enterUserName;pwd=enterPassword"
Mail Configuration
...
Key
...
Description/Setting
...
Mail_System
...
Description:
Email delivery method.
Setting:
0: no email will be sent.
1: email will be sent using MAPI.
2 (default): email will be sent using SMTP.
...
Mapi_Profile
...
Description:
Microsoft Outlook user profile name.
Setting:
(default): Outlook
...
Mail_From
...
Description:
The name or email address of who/where the email is being sent from.
Setting:
FrameworkIntegration
...
Mail_Recipient
...
Description:
These are the mail recipients of integration logs. Multiple addresses can be added if separated with a semi-colon (;). Spaces are not necessary before or after the semi-colon.
Setting:
enterRecipientEmail@yourDomain.com.au;integrationsupport@insulagroup.com.au
...
Mail_Subject
...
Description:
Email subject heading.
Setting:
"Framework Integration : Databuild Claims"
...
SMTP_Server
...
Description:
If using Mail_System 2 (SMTP), add the SMTP Server name.
Setting:
enterSMTPServerName (replace this text with your SMTP Server name)
...
SMTP_UseSecurity
...
Description:
Is security used for the STMP server?
Setting:
0 (default): A username or password is not required.
1: A username and password is required. If this setting is used, the SMTP_UserName and SMTP_Pwd fields must have a valid username and password.
...
SMTP_UserName
...
Description:
A valid username for the SMTP server.
Setting:
enterUserName (replace this text with a valid SMTP Server User Name)
...
SMTP_PWD
...
Description:
A valid password for the SMTP username.
Setting:
enterPassword (replace this text with a valid SMTP Server Password)
Criteria
...
Key
...
Description/Setting
...
CriteriaMethod
...
Description:
Job selection criteria for retrieving records from Framework to process.
Setting:
1: Single region/division.
2: Single job.
3: Single team.
4 (default): All jobs.
5: Accounts entity.
...
CriteriaData
...
Description:
Input criteria data for the criteria method.
Setting:
0
...
DepositRunStartDate
...
Description:
Date used to select receipts that were entered into Databuild after or on this date.
Setting:
01/01/2006
...
DepositRunEndDate
...
Description:
Date used to select receipts that were entered into Databuild before or on this date.
Setting:
01/01/2006
...
ConsistencyCheckout
...
Determines whether the consistency check process. Calculates the totals for each claim or all claims for the job.
1 (Default): Claim
2: Job
Consistency
...
Key
...
Description/Setting
...
PreAdmin
...
Description:
n/a
Setting:
False
...
Admin
...
Description:
n/a
Setting:
True
...
Construction
...
Description:
n/a
Setting:
True
...
Maintenance
...
Description:
n/a
Setting:
False
Actions
...
Key
...
Description/Setting
...
ActionCreateInvoices
...
Description:
Creates a file of Framework Claims Invoices in a format that can be inserted into Databuild.
Setting:
0: Framework Integration will not create invoices.
1 (default): Framework Integration will create invoices.
...
ActionProcessReceipts
...
Description:
Retrieves Databuild Receipts and inserts them into Framework, updating invoices in the process.
Setting:
0 (default): Framework Integration will not process receipts.
1: Framework Integration will process receipts.
...
ActionCheckingConsistency
...
Description:
Checks that Framework and Databuild have matching invoices and receipts.
Setting:
0 (default): Framework Integration will not check consistency.
1: Framework Integration will check consistency.
Databuild Settings
...
Key
...
Description/Setting
...
GLac
...
Description:
Databuild General Ledger Account code.
Setting:
0
...
CCBank
...
Description:
Cost Centre Bank value.
Setting:
1 (default)
Integrated Fields
The integration of Databuild Accounts Receivable to Framework is fixed in the content that is exchanged between the systems. There are no user-configurable integrated fields available to this type of integration.
...