MYOB Endpoint: Suppliers: Difference between revisions
No edit summary |
No edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Overview == | == Overview == | ||
The MYOB '''Suppliers''' [[Endpoints|endpoint]] allows you to access the list of | The MYOB '''Suppliers''' [[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. | ||
Note an alternate endpoint named [[MYOB Endpoint: SuppliersTable|SuppliersTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | |||
== Fields == | == Fields == | ||
The following fields are available for the Suppliers endpoint. | The following fields are available for the Suppliers endpoint. | ||
;DataFile | |||
:A [[Field Type: Record|record field]] that provides the [[Field: DataFile|DataFile]] associated with the data. | |||
;UID | ;UID | ||
| Line 71: | Line 77: | ||
;ForeignCurrency | ;ForeignCurrency | ||
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: | :A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: Currencies|foreign currency sub-field]]. | ||
;LastModified | ;LastModified | ||
| Line 97: | Line 103: | ||
;ExpenseAccount | ;ExpenseAccount | ||
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: | :A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: Accounts|account]] used for recording expenses. | ||
;PaymentMemo | ;PaymentMemo | ||
:A [[Field Type: Text|text field]] stores the default memo used for payments. | :A [[Field Type: Text|text field]] stores the default memo used for payments. | ||
;PurchaseComment | |||
:A [[Field Type: Text|text field]] stores the default comment used for purchases. | |||
;SupplierBillingRate | |||
:A [[Field Type: Decimal|decimal field]] that gives access to the tax exclusive billing rate of the supplier. | |||
;ShippingMethod | |||
:A [[Field Type: Text|text field]] stores the default shipping method used for purchases. | |||
;IsReportable | |||
:A [[Field Type: Boolean|true/false field]] that indicates if the supplier is setup for reportable taxable payments. | |||
:Only applicable to '''Australia'''. | |||
;CostPerHour | |||
:A [[Field Type: Decimal|decimal field]] that gives access to the cost per hour of the supplier. | |||
;Credit | |||
:A [[Field Type: Record|record field]] that gives access to fields used to indicate credit details. | |||
:See [[#BuyingDetails.Credit Fields|BuyingDetails.Credit Fields]] for more information. | |||
;ABN | |||
:A [[Field Type: Text|text field]] stores the ABN of the supplier. | |||
:Only applicable to '''Australia'''. | |||
;ABN | |||
:A [[Field Type: Text|text field]] stores the ABN branch number of the supplier. | |||
:Only applicable to '''Australia'''. | |||
;TaxIdNumber | |||
:A [[Field Type: Text|text field]] stores the tax id number of the supplier. | |||
;TaxCode | |||
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: TaxCodes|tax code]] used for recording expenses. | |||
;FreightTaxCode | |||
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: TaxCodes|freight tax code]] used for recording expenses. | |||
;UseSupplierTaxCode | |||
:A [[Field Type: Boolean|true/false field]] that indicates if the supplier is tax code is used. | |||
;Terms | |||
:A [[Field Type: Record|record field]] that gives access to fields used to the [[MYOB Field: Terms|payment terms]]. | |||
== BuyingDetails.Credit Fields Fields == | |||
The [[#BuyingDetails Fields|BuyingDetails.Credit]] field contains the following sub-fields. | |||
;Limit | |||
:A [[Field Type: Decimal|decimal field]] that gives access to the credit limit given by the supplier. | |||
;Available | |||
:A [[Field Type: Decimal|decimal field]] that gives access to the credit amount available for this supplier. | |||
;PastDue | |||
:A [[Field Type: Decimal|decimal field]] that gives access to overdue credit amount for this supplier. | |||
| Line 132: | Line 190: | ||
;Refund | ;Refund | ||
:A [[Field Type: Record|record field]] that gives access to the refund details. | :A [[Field Type: Record|record field]] that gives access to the refund details. | ||
:See [[#PaymentDetails.Refunds Fields|PaymentDetails .Refunds Fields]] for more information. | :See [[#PaymentDetails.Refunds Fields|PaymentDetails.Refunds Fields]] for more information. | ||
== PaymentDetails.Refunds Fields == | |||
The [[#PaymentDetails Fields|PaymentDetails.Refunds]] field contains the following sub-fields. | |||
;PaymentMethod | |||
:A [[Field Type: Text|text field]] used to store the payment method type when recording refunds. | |||
;CardNumber | |||
:A [[Field Type: Text|text field]] used to store the credit card number. | |||
:Note only the last 4 digits can be retrieved. | |||
;NameOnCard | |||
:A [[Field Type: Text|text field]] used to store the name on the credit card. | |||
;Notes | |||
:A [[Field Type: Text|text field]] used to store the notes for the payment method. | |||
== MYOB API == | == MYOB API == | ||
| Line 155: | Line 217: | ||
== Related Fields == | == Related Fields == | ||
:[[MYOB Field: Accounts|Accounts]] | |||
:[[MYOB Field: Addresses|Addresses]] | :[[MYOB Field: Addresses|Addresses]] | ||
:[[MYOB Field: Cards|Cards]] | :[[MYOB Field: Cards|Cards]] | ||
:[[MYOB Field: | :[[MYOB Field: Currencies|Currencies]] | ||
:[[MYOB Field: CustomList|CustomList]] | :[[MYOB Field: CustomList|CustomList]] | ||
:[[MYOB Field: CustomField|CustomField]] | :[[MYOB Field: CustomField|CustomField]] | ||
:[[MYOB Field: Identifiers|Identifiers]] | |||
:[[MYOB Field: TaxCodes|TaxCodes]] | |||
| Line 166: | Line 230: | ||
:[[MYOB Endpoint: Cards|Cards]] | :[[MYOB Endpoint: Cards|Cards]] | ||
== Related Topics == | |||
:[[MYOB Models]] | |||
:[[MYOB Endpoints]] | |||