...
MYOB Database Field Name | Create | Update | Framework Database Field Name | |||
|---|---|---|---|---|---|---|
JobNumber | Yes |
| Framework: s_job_num | |||
JobName | Yes | Yes | Special #55: s_job_address or “New Job” | |||
SubjobOf |
|
| ||||
Header | Yes | Yes | Fixed Value: “D” for Detail | |||
Description | Yes | Yes | Framework: s_description | |||
Contact | Yes | Yes | Framework: s_clientCont_name | |||
StartDate | Yes | Yes | Framework: d_site_start_act | |||
PercentComplete |
|
|
| |||
FinishDate | Yes | Yes | Framework: d_cst_comp_act | |||
Manager | Yes | Yes | Framework: s_supervisor_name | |||
LinkedCustomer | Yes | Yes | Framework: s_client_nameRef | |||
InactiveJob | Yes | Yes | Framework: s_inactive_job | |||
TrackReimburseables |
|
|
Dbo.Import_Customer_Cards
MYOB Database Field Name | Create | Update | Framework Database Field Name | |||
|---|---|---|---|---|---|---|
CoLastName | Yes | Yes | Framework: s_client_nameRef | |||
FirstName |
|
|
| |||
CardID | Yes |
| Special #56 - Framework: s_client_boq or s_client_num | |||
CardStatus | Yes | Yes | Framework: s_inactive_client | |||
CurrencyCode |
|
|
| |||
Address1AddressLine1 | Yes | Yes | Special #54 - Framework: s_client_stNum + s_client_stName or s_client_address | |||
Address1AddressLine2 |
|
|
| |||
Address1AddressLine3 |
|
|
| |||
Address1AddressLine4 |
|
| ||||
Address1City | Yes | Yes | Framework: s_client_suburb | |||
Address1State | Yes | Yes | Framework: s_client_state | |||
Address1PostCode | Yes | Yes | Framework: s_client_state | |||
Address1Country | Yes | Yes | Framework: s_client_country | |||
Address1Phone1 | Yes | Yes | Framework: s_client_bhPhone | |||
Address1Phone2 | Yes | Yes | Framework: s_client_ahPhone | |||
Address1Phone3 | Yes | Yes | Framework: s_client_mobile | |||
Address1Fax | Yes | Yes | Framework: s_client_fax | |||
Address1Email | Yes | Yes | Framework: s_client_email | |||
Address1Website | Yes | Yes | Framework: s_client_website | |||
Address1ContactName | Yes | Yes | Framework: s_clientCont_name | |||
Address1Salutation | Yes | Yes | Framework: s_clientCont_salutation | |||
< Address2/5 sets of fields > |
|
|
| |||
Notes | Yes | Yes | Framework:s_client_notes | |||
PaymentIsDue | Yes | Yes | Special #52: Value from ini file for key MYOB_PaymentDueCode | |||
DiscountDays |
|
| ||||
BalanceDueDays | Yes | Yes | Special #53: Value from ini file for key MYOB_BalanceDueDays | |||
PercentDiscount |
|
|
| |||
PercentMonthlyCharge |
|
|
| |||
TaxCode | Yes | Yes | Special #51: Value from ini file for key MYOB_TaxCode | |||
CreditLimit |
|
|
| |||
TaxIDNumber |
|
|
| |||
VolumeDiscount |
|
|
| |||
SaleLayout | Yes | Yes | Fixed Value: “S” for Service | |||
ItemPriceLayout | Yes | Yes |
| |||
PaymentMethod | Yes | Yes | Fixed Value: 0 | |||
AccountNumber |
|
|
| |||
AccountName |
|
| ||||
ABN |
|
|
| |||
ABNBranch |
|
|
| |||
IncomeAccount |
|
|
| |||
Salesperson | Yes |
| Framework: s_salesPerson_name | |||
SalespersonCardID | Yes | Yes | Fixed Value: 0 | |||
SaleComment |
|
|
| |||
ShippingMethod |
|
| ||||
PrintedForm |
|
|
| |||
FreightTaxCode |
|
| ||||
UseCustomersTaxCode |
|
|
| |||
ReceiptMemo |
|
|
| |||
InvoiceDelivery |
|
|
| |||
RecordID |
|
|
|
Database Models
The following database model(s) displays the manner in which data is integrated between the third party application and Framework Integration.
...