Octal8 BizPrac Database Field Name	Octal8 BizPrac Field Label	Create	Update	Framework Database Field Name
C_code	Unique Client Code	Yes	No	Special # 14: Gets next unique number from file903.tps
Job_no	Job Number	Yes	No	Framework – s_job_num
Address1	Job Address	Yes	Yes	Special # 5: Job lot number, job street number, job street name
Suburb	Fkid number to the correct suburb in file35	Yes	Yes	Special #41: Searches for the matching suburb and returns the linkCode, otherwise creates the suburb in the table if it does not exist and returns the new linkCode
Books	BookSet	Yes	No	Fixed Value 1
Contact	Primary Contact Name	Yes	Yes	Framework - s_clientCont_name
Contract	Contract inc GST	Yes	Yes	Framework - c_retail_external
Phone	Primary Contact Business Hours Phone	Yes	Yes	Framework – s_client_phone
Fax	Primary Contact Fax	Yes	Yes	Framework - s_client_fax
Mobile	Primary Contact Mobile	Yes	Yes	Framework - s_client_mobile
Job_name	Client Reference Name	Yes	Yes	Framework - s_client_nameRef
jobType	New Home	Yes	No	Fixed Value ‘New Home’

Octal8 BizPrac Database Field Name	Octal8 BizPrac Field Label	Create	Update	Framework Database Field Name
C_code	Unique Client Code	Yes	No	Special # 14: Gets next unique number from file903.tps
Client_name	Client Reference Name	Yes	Yes	Framework - s_client_nameRef
Contactname	Client Salutation	Yes	Yes	Framework - s_client_salutation
Books	BookSet	Yes	No	Fixed Value 1
cliAddress1	Client Address	Yes	Yes	Special #1: Client street number and client street name
cliSuburb	Fkid number to the correct suburb in file35	Yes	Yes	Special # 41: Searches for the matching suburb and returns the linkCode, otherwise creates the suburb in the table if it does not exist and returns the new linkCode
Country	Country	Yes	Yes	Framework – s_client_country
cliPhone	Primary Contact Business Hours Phone	Yes	Yes	Framework – s_client_phone
cliFax	Primary Contact Fax	Yes	Yes	Framework - s_client_fax
Mobile	Primary Contact Mobile	Yes	Yes	Framework - s_client_mobile
Alt_name	Client Name	Yes	Yes	Framework - s_client_name
Alt_contactName	Client Salutation	Yes	Yes	Framework - s_client_salutation
Alt_address1	Client Address	Yes	Yes	Special # 1: Client street number and client street name
Alt_suburb	Fkid number to the correct suburb in file35	Yes	Yes	Special # 41: Searches for the matching suburb and returns thel inkCode, otherwise creates the suburb in the table if it does not exist and returns the new linkCode.
Alt_country	Country	Yes	Yes	Framework- s_client_country

Octal8 BizPrac Database Field Name	Octal8 BizPrac Field Label	Create	Update	Framework Database Field Name
Linkcode	Unique Suburb Code	Yes	No	Gets next unique number from file903.tps
City_name	Suburb Name	Yes	No	Framework – s_client_suburb or s_job_suburb
State	Suburb State (short version)	Yes	No	Framework – s_client_state or s_job_state
postcode	Postcode	Yes	No	Framework – s_client_postcode or s_job_postcode

Database Models

The following database model(s) displays the manner in which data is integrated between the third party application and Framework Integration.

...

Versions Compared