...
- Int_ArrowClaims_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: Arrow Claims |
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 |
ODBCDSN_Destination | Description: ODBC DSN name for the Arrow Claims database. Setting: FworkArrowAccts |
ODBCConnect_Destination | Description: ODBC DSN connection string for the Arrow Claims 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 : Arrow 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 Arrow after or on this date. Setting: 01/01/2006 |
DepositRunEndDate | Description: Date used to select receipts that were entered into Arrow before or on this date. Setting: 01/01/2006 |
Actions
Key | Description/Setting |
|---|---|
ActionCreateInvoices | Description: Creates a file of Framework Claims Invoices in a format that can be inserted into Arrow. Setting: 0: Framework Integration will not create invoices. 1 (default): Framework Integration will create invoices. |
ActionProcessReceipts | Description: Retrieves Arrow 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 Arrow have matching invoices and receipts. Setting: 0 (default): Framework Integration will not check consistency. 1: Framework Integration will check consistency. |
Arrow Settings
Key | Description/Setting |
|---|---|
InitialDeposit | Description: Arrow Cost Code for the Initial Deposit. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
BalanceDeposit | Description: Arrow Cost Code for the Balance Deposit. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
BaseClaim | Description: Arrow Cost Code for the Base Claim. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
FrameClaim | Description: Arrow Cost Code for the Frame Claim. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
LockUpClaim | Description: Arrow Cost Code for the Lock Up Claim. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
FixOutClaim | Description: Arrow Cost Code for the Fix Out Claim. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
FinalClaim | Description: Arrow Cost Code for the Final Claim. Setting: 0 These need to have values that are from Arrow and indicate the Cost Code for each stage. |
File/Path Location
Key | Description/Setting |
|---|---|
OutputPath | Description: Path where invoice file will be created. Setting: c:\Temp |
OutputFilename | Description: Invoice file name that is created storing invoices in a format that can be imported into Arrow Claims. Setting: ARInvImport.txt |
Integrated Fields
The integration of Arrow Accounts Receivable to Framework ECM is fixed in the content that is exchanged between the systems. There are no user-configurable integrated fields available for this type of integration.
Database Model
The following database model(s) displays the manner in which data is integrated between the third party application and Framework Integration.
Integration Process
The following information is a low level account of the integration process including criteria, decisions, and outcomes. This information is technical in nature and is provided "as-is" for a detailed analysis of the integration process for system administrators.
...