Databuild Accounts Receivable Integration - Profile Configuration
Return to Databuild Accounts Receivable Integration
Article Index
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) |