...
Sage Timberline Database Field Name | Sage Timberline Field Label | Create | Update | Framework Database Field Name | Framework Field Label | |||
|---|---|---|---|---|---|---|---|---|
CADD1 |
| Yes | Yes | Special #1: client street number & client street name |
| |||
CAKEY1 |
| Yes | Fixed Value: 1 | |||||
CBADD1 |
| Yes | Yes | Special #1: client street number & client street name |
| |||
CBCIY |
| Yes | Yes | Framework - s_client_suburb | ||||
CBEMAIL | Yes | Yes | Framework - s_client_email |
| ||||
CBSTATE |
| Yes | Yes | Framework - s_client_state | ||||
CBZIP | Yes | Yes | Framework - s_client_postcode |
| ||||
CCITY |
| Yes | Yes | Framework - s_client_suburb |
| |||
CDAYDUE | Yes |
| Fixed Value: 7 |
| ||||
CEMAIL |
| Yes | Yes | Framework - s_client_email | ||||
CESTDT | Yes |
| Framework - d_created |
| ||||
CFAX |
| Yes | Yes | Framework - s_client_fax | ||||
CGLPREF |
| Yes |
| Special #3: depending on the criteria method from the ini file, we get a value from the ini file like this (TLJOBPREFIX(method criteria)). |
| |||
CNAME | Yes | Yes | Special #7: Client Name (job num). |
| ||||
CPHONE | Yes | Yes | Framework - s_client_phone | |||||
CSTATE | Yes | Yes | Framework - s_client_state | |||||
CTRADE |
| Yes |
| Fixed Value: None |
| |||
CTXGR | Yes | Fixed Value: GST |
| |||||
CTXGRPE |
| Yes | Fixed Value: Taxable | |||||
CTXGRPL |
| Yes |
| Fixed Value: Taxable |
| |||
CTXGRPM | Yes | Fixed Value: Taxable |
| |||||
CTXGRPO |
| Yes | Fixed Value: Taxable |
| ||||
CTXGRPS |
| Yes |
| Fixed Value: Taxable |
| |||
CTXGRPT | Yes | Fixed Value: Taxable |
| |||||
CTXGRTB |
| Yes | Fixed Value: Taxable |
| ||||
CTYPEA |
| Yes |
| Fixed Value: Standard |
| |||
CUST | Yes |
| Special #2: Gets the first four or five characters from client ref name (ini file key determines harmony) appends 2 numbers to it, adds leading 0 if needed. | |||||
CZIP | Yes | Yes | Framework - s_client_postcode |
Master_Arm_Record_4
Sage Timberline Database Field Name | Sage Timberline Field Label | Create | Update | Framework Database Field Name | Framework Database Field Label | |
|---|---|---|---|---|---|---|
ATITLE | Yes | Yes | Framework s_client_name |
| ||
CUCUST |
| Yes | Special #2: Gets the first four or five characters from client ref name (ini file key determines harmony) appends 2 numbers to it, adds leading 0 if needed. |
Master_JCM_Record_1_1
Sage Timberline Database Field Name | Sage Timberline Field Label | Create | Update | Framework Database Field Name | Framework Database Field Label | ||
|---|---|---|---|---|---|---|---|
JACTSD |
| Yes | Yes | Framework - d_admin_comp_act |
| ||
JADDR1 |
| Yes | Yes | Special #5: job lot numb, job street num, job street name | |||
JADDR2 | Yes |
| Fixed Value: 1 |
| |||
JARCUST | Yes | Special #2: Gets the first four or five characters from client ref name (ini file key determines harmony) appends 2 numbers to it, adds leading 0 if needed. |
| ||||
JAUTH |
| Yes | Yes | Framework - s_super_nameRef |
| ||
JBCITY | Yes | Yes | Framework - s_client_suburb |
| |||
JBSTATE |
| Yes | Yes | Framework - s_client_state |
| ||
JBZIP | Yes | Yes | Framework - s_client_postcode | ||||
JCITY |
| Yes | Yes | Framework - s_job_suburb |
| ||
JCNAME |
| Yes | Yes | Framework - s_client_name | |||
JDESC |
| Yes | Yes | Special #8: job lot num, job street num, job street name (client name ref) |
| ||
JESTSD |
| Yes | Yes | Framework - d_admin_comp_fMan | |||
JOB |
| Yes | Special #6: Fwork job number formatted to the Timberline format. | ||||
JOESTFN | Yes | Yes | Special #9: if fwork d_site_start_act is entered and the timberline JOESTFN field is 0 we set this to true. | ||||
JORDER1 |
| Yes | Yes | Framework - s_supervisor_name |
| ||
JORDER2 |
| Yes | Yes | Framework - s_hType_notes | |||
JPREFIX | Yes |
| Special #3: depending on the criteri method from the ini file, we get a value from the ini file like this (TLJOBPREFIX(method criteria)). |
| |||
JPRJMGR | Yes | Yes | Framework - s_administrator_name | ||||
JSTATE |
| Yes | Yes | Framework - s_job_state |
| ||
JSTATUS |
| Yes | Yes | Special #4: if not = closed this will be 'in progress' if job status is active/on hold and wfl stage is construction/maintenance else it will be unstarted. | |||
JTITL1 | Yes | Yes | Framework - s_estimator_name |
| |||
JTITL2 |
| Yes | Yes | Framework - s_hFacade_name | |||
JTYPE |
| Yes | Yes | Framework - s_hType_name |
| ||
JZIP |
| Yes | Yes | Framework - s_job_postcode |
| ||
JACTCD | Yes | Yes | Framework - d_settle_act | ||||
JBMETH |
| Yes |
| Fixed Value: Use Quick Bill. This value applies to using Timberline Quickbill for invoicing when not using Contracts. Fixed Value: Use Contracts. This value applies to using Timberline Contracts |
Master_JCM_Record_20
FieSage TimberlineDatabase Field Nameld | Sage Timberline Field Label | Create | Update | Framework Database Field Name | Framework Database Field Label | |||
|---|---|---|---|---|---|---|---|---|
DJOBCRE |
| Yes |
| Framework - d_created |
| |||
JUJOB |
| Yes | Special #6: Fwork job number formatted to the Timberline format. |
| ||||
NFWCVAP | Yes | Yes | Special #17: Sum of doc.c_retail_total whose subtype is building Var or PC Var, status is final and d_signed_act is not null. | |||||
NFWCVPE | Yes | Yes | Special #16: Sum of doc.c_retail_total whose sub type in building Var or Post Contract Variations, status is final or draft and d_signed_act is null. |
...