...
Databuild Database Field Name | Databuild Field Label | Create | Update | Framework Database Field Name | Framework Field Label | |||
|---|---|---|---|---|---|---|---|---|
Address |
| Yes | Yes | Special #1: Street Number and Street Name | ||||
City |
| Yes | Yes | Framework - s_client_suburb |
| |||
Code |
| Yes |
| Special #14: Framework Client Ref Name shortened to 4 Uppercase characters with two numbers added on the end making a unique code. |
| |||
Contact | Yes | Yes | Framework - s_clientCont_name | |||||
Dear |
| Yes | Yes | Framework - s_clientCont_salutation |
| |||
Debtor |
| Yes | Fixed Value: -1 | |||||
| Yes | Yes | Framework - s_client_email | |||||
Fax |
| Yes | Yes | Framework - s_client_fax | ||||
Group_ | Yes | Yes | Special #10: Value from ini file for key dbuild_ContactGroupCode |
| ||||
Mobile | Yes | Yes | Framework - s_client_mobile | |||||
Name | Yes | Yes | Framework - s_client_name |
| ||||
Phone |
| Yes | Yes | Framework - s_client_phone |
| |||
Postcode |
| Yes | Yes | Special #15: Framework - s_client_postcode |
| |||
Sort | Yes | Yes | Special #2: Client reference name shortened to 4 characters |
| ||||
State |
| Yes | Yes | Framework - s_client_state |
|
Dbo.Jobs
Databuild Database Field Name | Databuild Field Label | Create | Update | Framework Database Field Name | Framework Field Label | |||
|---|---|---|---|---|---|---|---|---|
AnyQuantities |
| Yes | Fixed Value: 0 |
| ||||
CCBank | Yes | Yes | Special #11: Value from ini file for key dbuild_CostCentreGroupCode | |||||
ContractGST |
| Yes | Yes | Special #13: GST Rate is retrieved from ini file and the GST amount is calculated based on c_retail_external (total price inc GST) from Framework. | ||||
ContractPrice |
| Yes | Yes | Special #12: GST Rate is retrieved from ini file and the Net amount is c_retail_external minus GST amount calculated above. | ||||
Debtor | Yes | Special #14: Same as above for 14 (code). |
| |||||
DebtorName |
| Yes | Yes | Framework - s_client_name |
| |||
EndDate |
| Yes | Yes | Framework - d_antComp_rev_fman |
| |||
Estimator | Yes | Yes | Framework - s_estimator_name | |||||
Forecast |
| Yes | Yes | Special #12: GST Rate is retrieved from ini file and the Net amount is c_retail_external minus GST amount calculated above. |
| |||
GST |
| Yes | Fixed Value: 0 | |||||
Job_No |
| Yes | Special #6: Framework Job Number shortened to 8 characters. |
| ||||
JobPostCode | Yes | Yes | Special #15: fwork s_job_postcode | |||||
LiveOrders |
| Yes | Fixed Value: 0 | |||||
LockBudgets | Yes |
| Fixed Value: 0 |
| ||||
PreventBill |
| Yes |
| Fixed Value: 0 |
| |||
PreventPosting | Yes |
| Fixed Value: 0 |
| ||||
Salesperson |
| Yes | Yes | Framework - s_salesPerson_name |
| |||
ScheduleProfile | Yes | Yes | Framework - s_hType_name |
| ||||
Site_Address | Yes | Yes | Special #5: lot num, street num, street name suburbName, stateName | |||||
StartDate |
| Yes | Yes | Framework - d_site_start_act | ||||
Supervisor |
| Yes | Yes | Framework - s_supervisor_name |
Database Models
The following database model(s) displays the manner in which data is integrated between the third party application and Framework Integration.
...