https://help.odatalink.com/index.php?action=history&feed=atom&title=MYOB_Endpoint%3A_SuppliersTableMYOB Endpoint: SuppliersTable - Revision history2026-10-26T14:30:23ZRevision history for this page on the wikiMediaWiki 1.43.11https://help.odatalink.com/index.php?title=MYOB_Endpoint:_SuppliersTable&diff=4341&oldid=prevNic: Created page with "== Overview == The MYOB '''SuppliersTable''' endpoint allows you to access the list of supplier cards. Note, these cards are also available via the MYOB..."2025-04-03T05:14:23Z<p>Created page with "== Overview == The MYOB '''SuppliersTable''' <a href="/index.php?title=MYOB_Endpoints" title="MYOB Endpoints">endpoint</a> allows you to access the list of supplier cards. Note, these cards are also available via the MYOB..."</p>
<p><b>New page</b></p><div>== Overview ==<br />
<br />
The MYOB '''SuppliersTable''' [[MYOB Endpoints|endpoint]] allows you to access the list of supplier cards. Note, these cards are also available via the [[MYOB Endpoint: Cards|Cards]] endpoint.<br />
<br />
Note this endpoint is an alternate format of the [[MYOB Endpoint: Suppliers|Suppliers]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.<br />
<br />
<br />
== Fields ==<br />
<br />
The following fields are available for the SuppliersTable endpoint.<br />
<br />
;DataFileID<br />
:A [[Field Type: GUID|guid field]] that provides the id of the data file as setup in OdataLink.<br />
<br />
;DataFileName<br />
:A [[Field Type: Text|text field]] that provides the name of the data file as setup in OdataLink.<br />
<br />
;DataFileCode<br />
:A [[Field Type: Text|text field]] that provides the code of the data file as setup in OdataLink.<br />
<br />
;UID<br />
:A [[Field Type: GUID|GUID field]] representing the internal id of a card. This field can be used to link to other endpoints.<br />
:Note that the UID will be the same as that on the [[MYOB Endpoint: Cards|Cards]] endpoint.<br />
<br />
;CompanyName<br />
:A [[Field Type: Text|text field]] used as the company name of the card.<br />
:Note this only applies to cards set as companies and not individuals.<br />
<br />
;LastName<br />
:A [[Field Type: Text|text field]] used as the last name of the card.<br />
:Note this only applies to cards set as individuals and not companies.<br />
<br />
;FirstName<br />
:A [[Field Type: Text|text field]] used as the first name of the card.<br />
:Note this only applies to cards set as individuals and not companies.<br />
<br />
;IsIndividual<br />
:A [[Field Type: Boolean|true/false value]] that indicates if the card is an individual or a company.<br />
<br />
;DisplayID<br />
:A [[Field Type: Text|text field]] used as the Card ID.<br />
<br />
;IsActive<br />
:A [[Field Type: Boolean|true/false value]] that indicates if the card is active and can be used on new transactions.<br />
<br />
;Address1Street<br />
:A [[Field Type: Text|text field]] stores the street address.<br />
<br />
;Address1City<br />
:A [[Field Type: Text|text field]] stores the city.<br />
<br />
;Address1State<br />
:A [[Field Type: Text|text field]] stores the state or province.<br />
<br />
;Address1PostCode<br />
:A [[Field Type: Text|text field]] stores the post code or zip code.<br />
<br />
;Address1Country<br />
:A [[Field Type: Text|text field]] stores the country.<br />
<br />
;Address1Phone1<br />
:A [[Field Type: Text|text field]] stores the first phone number.<br />
<br />
;Address1Phone2<br />
:A [[Field Type: Text|text field]] stores the second phone number.<br />
<br />
;Address1Phone3<br />
:A [[Field Type: Text|text field]] stores the third phone number.<br />
<br />
;Address1Fax<br />
:A [[Field Type: Text|text field]] stores the fax number.<br />
<br />
;Address1Email<br />
:A [[Field Type: Text|text field]] stores the email.<br />
<br />
;Address1Website<br />
:A [[Field Type: Text|text field]] stores the website.<br />
<br />
;Address1ContactName<br />
:A [[Field Type: Text|text field]] stores the contact name.<br />
<br />
;Address1Saluation<br />
:A [[Field Type: Text|text field]] stores the saluation (e.g. Mr, Mrs, etc.)<br />
<br />
;Address2Street<br />
:A [[Field Type: Text|text field]] stores the street address.<br />
<br />
;Address2City<br />
:A [[Field Type: Text|text field]] stores the city.<br />
<br />
;Address2State<br />
:A [[Field Type: Text|text field]] stores the state or province.<br />
<br />
;Address2PostCode<br />
:A [[Field Type: Text|text field]] stores the post code or zip code.<br />
<br />
;Address2Country<br />
:A [[Field Type: Text|text field]] stores the country.<br />
<br />
;Address2Phone1<br />
:A [[Field Type: Text|text field]] stores the first phone number.<br />
<br />
;Address2Phone2<br />
:A [[Field Type: Text|text field]] stores the second phone number.<br />
<br />
;Address2Phone3<br />
:A [[Field Type: Text|text field]] stores the third phone number.<br />
<br />
;Address2Fax<br />
:A [[Field Type: Text|text field]] stores the fax number.<br />
<br />
;Address2Email<br />
:A [[Field Type: Text|text field]] stores the email.<br />
<br />
;Address2Website<br />
:A [[Field Type: Text|text field]] stores the website.<br />
<br />
;Address2ContactName<br />
:A [[Field Type: Text|text field]] stores the contact name.<br />
<br />
;Address2Saluation<br />
:A [[Field Type: Text|text field]] stores the saluation (e.g. Mr, Mrs, etc.)<br />
<br />
;Address3Street<br />
:A [[Field Type: Text|text field]] stores the street address.<br />
<br />
;Address3City<br />
:A [[Field Type: Text|text field]] stores the city.<br />
<br />
;Address3State<br />
:A [[Field Type: Text|text field]] stores the state or province.<br />
<br />
;Address3PostCode<br />
:A [[Field Type: Text|text field]] stores the post code or zip code.<br />
<br />
;Address3Country<br />
:A [[Field Type: Text|text field]] stores the country.<br />
<br />
;Address3Phone1<br />
:A [[Field Type: Text|text field]] stores the first phone number.<br />
<br />
;Address3Phone2<br />
:A [[Field Type: Text|text field]] stores the second phone number.<br />
<br />
;Address3Phone3<br />
:A [[Field Type: Text|text field]] stores the third phone number.<br />
<br />
;Address3Fax<br />
:A [[Field Type: Text|text field]] stores the fax number.<br />
<br />
;Address3Email<br />
:A [[Field Type: Text|text field]] stores the email.<br />
<br />
;Address3Website<br />
:A [[Field Type: Text|text field]] stores the website.<br />
<br />
;Address3ContactName<br />
:A [[Field Type: Text|text field]] stores the contact name.<br />
<br />
;Address3Saluation<br />
:A [[Field Type: Text|text field]] stores the saluation (e.g. Mr, Mrs, etc.)<br />
<br />
;Address4Street<br />
:A [[Field Type: Text|text field]] stores the street address.<br />
<br />
;Address4City<br />
:A [[Field Type: Text|text field]] stores the city.<br />
<br />
;Address4State<br />
:A [[Field Type: Text|text field]] stores the state or province.<br />
<br />
;Address4PostCode<br />
:A [[Field Type: Text|text field]] stores the post code or zip code.<br />
<br />
;Address4Country<br />
:A [[Field Type: Text|text field]] stores the country.<br />
<br />
;Address4Phone1<br />
:A [[Field Type: Text|text field]] stores the first phone number.<br />
<br />
;Address4Phone2<br />
:A [[Field Type: Text|text field]] stores the second phone number.<br />
<br />
;Address4Phone3<br />
:A [[Field Type: Text|text field]] stores the third phone number.<br />
<br />
;Address4Fax<br />
:A [[Field Type: Text|text field]] stores the fax number.<br />
<br />
;Address4Email<br />
:A [[Field Type: Text|text field]] stores the email.<br />
<br />
;Address4Website<br />
:A [[Field Type: Text|text field]] stores the website.<br />
<br />
;Address4ContactName<br />
:A [[Field Type: Text|text field]] stores the contact name.<br />
<br />
;Address4Saluation<br />
:A [[Field Type: Text|text field]] stores the saluation (e.g. Mr, Mrs, etc.)<br />
<br />
;Address5Street<br />
:A [[Field Type: Text|text field]] stores the street address.<br />
<br />
;Address5City<br />
:A [[Field Type: Text|text field]] stores the city.<br />
<br />
;Address5State<br />
:A [[Field Type: Text|text field]] stores the state or province.<br />
<br />
;Address5PostCode<br />
:A [[Field Type: Text|text field]] stores the post code or zip code.<br />
<br />
;Address5Country<br />
:A [[Field Type: Text|text field]] stores the country.<br />
<br />
;Address5Phone1<br />
:A [[Field Type: Text|text field]] stores the first phone number.<br />
<br />
;Address5Phone2<br />
:A [[Field Type: Text|text field]] stores the second phone number.<br />
<br />
;Address5Phone3<br />
:A [[Field Type: Text|text field]] stores the third phone number.<br />
<br />
;Address5Fax<br />
:A [[Field Type: Text|text field]] stores the fax number.<br />
<br />
;Address5Email<br />
:A [[Field Type: Text|text field]] stores the email.<br />
<br />
;Address5Website<br />
:A [[Field Type: Text|text field]] stores the website.<br />
<br />
;Address5ContactName<br />
:A [[Field Type: Text|text field]] stores the contact name.<br />
<br />
;Address5Saluation<br />
:A [[Field Type: Text|text field]] stores the saluation (e.g. Mr, Mrs, etc.)<br />
<br />
;Notes<br />
:A [[Field Type: Text|text field]] that stores notes for the card.<br />
<br />
;CustomList1<br />
:A [[Field Type: Text|text field]] that stores the first [[MYOB Field: CustomList|custom list value]] selected for this card.<br />
<br />
;CustomList2<br />
:A [[Field Type: Text|text field]] that stores the second [[MYOB Field: CustomList|custom list value]] selected for this card.<br />
<br />
;CustomList3<br />
:A [[Field Type: Text|text field]] that stores the third [[MYOB Field: CustomList|custom list value]] selected for this card.<br />
<br />
;CustomField1<br />
:A [[Field Type: Text|text field]] that stores the first [[MYOB Field: CustomField|custom field value]] entered for this card.<br />
<br />
;CustomField2<br />
:A [[Field Type: Text|text field]] that stores the second [[MYOB Field: CustomField|custom field value]] entered for this card.<br />
<br />
;CustomField3<br />
:A [[Field Type: Text|text field]] that stores the third [[MYOB Field: CustomField|custom field value]] entered for this card.<br />
<br />
;CurrentBalance<br />
:A [[Field Type: Decimal|decimal field]] that gives access to the current outstanding balance of this card (amount owing or owed).<br />
<br />
;PurchaseLayout<br />
:A [[Field Type: Text|text field]] stores the default layout (Item, Service, Miscellaneous or Professional) used when recording purchases.<br />
<br />
;PrintedForm<br />
:A [[Field Type: Text|text field]] stores the default templated used when printing the purchase.<br />
<br />
;PuchaseOrderDelivery<br />
:A [[Field Type: Text|text field]] stores the default purchase order delivery status.<br />
<br />
;ExpenseAccountUID<br />
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Accounts|account]] used for recording expenses.. This field can be used to link to other endpoints.<br />
<br />
;ExpenseAccountNumber<br />
:A [[Field Type: Text|text field]] that provides the account number used for recording expenses.<br />
<br />
;ExpenseAccountName<br />
:A [[Field Type: Text|text field]] that provides the account name used for recording expenses.<br />
<br />
;PaymentMemo<br />
:A [[Field Type: Text|text field]] stores the default memo used for payments.<br />
<br />
;PurchaseComment<br />
:A [[Field Type: Text|text field]] stores the default comment used for purchases.<br />
<br />
;SupplierBillingRate<br />
:A [[Field Type: Decimal|decimal field]] that gives access to the tax exclusive billing rate of the supplier.<br />
<br />
;ShippingMethod<br />
:A [[Field Type: Text|text field]] stores the default shipping method used for purchases.<br />
<br />
;IsReportable<br />
:A [[Field Type: Boolean|true/false field]] that indicates if the supplier is setup for reportable taxable payments.<br />
:Only applicable to '''Australia'''.<br />
<br />
;CostPerHour<br />
:A [[Field Type: Decimal|decimal field]] that gives access to the cost per hour of the supplier.<br />
<br />
;CreditLimit<br />
:A [[Field Type: Decimal|decimal field]] that gives access to the credit limit given by the supplier.<br />
<br />
;CreditAvailable<br />
:A [[Field Type: Decimal|decimal field]] that gives access to the credit amount available for this supplier.<br />
<br />
;CreditPastDue<br />
:A [[Field Type: Decimal|decimal field]] that gives access to overdue credit amount for this supplier.<br />
<br />
;ABN<br />
:A [[Field Type: Text|text field]] stores the ABN of the supplier.<br />
:Only applicable to '''Australia'''.<br />
<br />
;ABN<br />
:A [[Field Type: Text|text field]] stores the ABN branch number of the supplier.<br />
:Only applicable to '''Australia'''.<br />
<br />
;TaxIdNumber<br />
:A [[Field Type: Text|text field]] stores the tax id number of the supplier.<br />
<br />
;TaxCodeUID<br />
:A [[Field Type: GUID|guid field]] that provides the id of the [[MYOB Endpoint: TaxCodes|tax code]] for recording expenses.<br />
<br />
;TaxCode<br />
:A [[Field Type: Text|text field]] that provides the [[MYOB Endpoint: TaxCodes|tax code]] for recording expenses (e.g. GST or FRE).<br />
<br />
;FreightTaxCodeUID<br />
:A [[Field Type: GUID|guid field]] that provides the id of the [[MYOB Endpoint: TaxCodes|tax code]] for recording freight.<br />
<br />
;FreightTaxCode<br />
:A [[Field Type: Text|text field]] that provides the [[MYOB Endpoint: TaxCodes|tax code]] for recording freight(e.g. GST or FRE).<br />
<br />
;UseSupplierTaxCode<br />
:A [[Field Type: Boolean|true/false field]] that indicates if the supplier is tax code is used.<br />
<br />
;TermsPaymentIsDue<br />
:A [[Field Type: Text|text field]] that represents the due date.<br />
:Possible values are:<br />
:* CashOnDelivery<br />
:* PrePaid<br />
:* InAGivenNumberOfDays<br />
:* OnADayOfTheMonth<br />
:* NumberOfDaysAfterEOM<br />
:* DayOfMonthAfterEOM<br />
<br />
;TermsDiscountDate<br />
:A [[Field Type: Integer|integer field]] used to represent either a specific day or a specific number of days in order to receive a discount.<br />
<br />
;TermsBalanceDueDate<br />
:A [[Field Type: Integer|integer field]] used to represent either a specific day or a specific number of days in order to pay on time.<br />
<br />
;TermsDiscountForEarlyPayment<br />
:A [[Field Type: Decimal|decimal field]] used to represent the percentage discount for early payment.<br />
<br />
;TermsVolumeDiscount<br />
:A [[Field Type: Decimal|decimal field]] used to represent the percentage discount for large purchases.<br />
<br />
;PaymentDetailsBSBNumber<br />
:A [[Field Type: Text|text field]] used to store the BSB number.<br />
<br />
;PaymentDetailsBankAccountNumber<br />
:A [[Field Type: Text|text field]] used to store the bank account number.<br />
<br />
;PaymentDetailsBankAccountName<br />
:A [[Field Type: Text|text field]] used to store the bank account name.<br />
<br />
;PaymentDetailsStatementText<br />
:A [[Field Type: Text|text field]] used to store the statement text included on direct credit ABA files.<br />
<br />
;PaymentDetailsStatementCode<br />
:A [[Field Type: Text|text field]] used to store the statement code included on direct credit ABA files.<br />
<br />
;PaymentDetailsStatementReference<br />
:A [[Field Type: Text|text field]] used to store the statement reference included on direct credit ABA files.<br />
<br />
;RefundDetailsPaymentMethod<br />
:A [[Field Type: Text|text field]] used to store the payment method type when recording refunds.<br />
<br />
;RefundDetailsCardNumber<br />
:A [[Field Type: Text|text field]] used to store the credit card number.<br />
:Note only the last 4 digits can be retrieved.<br />
<br />
;RefundDetailsNameOnCard<br />
:A [[Field Type: Text|text field]] used to store the name on the credit card.<br />
<br />
;RefundDetailsNotes<br />
:A [[Field Type: Text|text field]] used to store the notes for the payment method.<br />
<br />
;ForeignCurrencyUID<br />
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Currencies|currency]] linked to this transaction. This field can be used to link to other endpoints.<br />
<br />
;ForeignCurrencyCode<br />
:A [[Field Type: Text|text field]] that provides the currency ISO code.<br />
<br />
;ForeignCurrencyName<br />
:A [[Field Type: Text|text field]] that provides the currency name.<br />
<br />
;LastModified<br />
:A [[Field Type: DateTimeOffset|date time field]] that stores the last date and time this card was modified.<br />
<br />
;PhotoURI<br />
:A [[Field Type: Text|text field]] that stores a URL that can be used to access the photo associated with this card.<br />
<br />
;RowVersion<br />
:A [[Field Type: Row Version|row version field]].<br />
<br />
<br />
== MYOB API ==<br />
<br />
For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/contact/supplier/ MYOB API].<br />
<br />
<br />
== Related Endpoints==<br />
<br />
:[[MYOB Endpoint: Cards|Cards]]<br />
:[[MYOB Endpoint: Suppliers|Suppliers]]<br />
<br />
<br />
== Related Topics ==<br />
<br />
:[[MYOB Models]]<br />
:[[MYOB Endpoints]]</div>Nic