JDBC Driver for MYOB

Build 22.0.8462

CompanyPreferences

Returns company data file preferences for an AccountRight company file.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type Description
PreferToReceiveMoneyIntoUndepositedFunds Boolean True indicates the preference When I receive money, I prefer to Group with Other Undeposited funds is turned on. False indicates the preference When I receive money, I prefer to Group with Other Undeposited funds is turned off.
PurchasesTermsBalanceDueDate Integer The balance due date which includes EOM (End of Month).
PurchasesTermsCreditLimit Decimal Default customer contact credit limit.
PurchasesTermsDiscountDate Integer The discount date which includes EOM (End of Month).
PurchasesTermsDiscountForEarlyPayment Double % discount for early payment.
PurchasesTermsMonthlyChargeForLatePayment Double % monthly charge for late payment.
PurchasesTermsPaymentIsDue String Default Terms of Payment definitions: CashOnDelivery, PrePaid, InAGivenNumberOfDays, OnADayOfTheMonth, NumberOfDaysAfterEOM, DayOfMonthAfterEOM.
PurchasesTermsPriceLevel String Default price level.
PurchasesTermsUseCustomerTaxCode Boolean True or false.
PurchasesTermsUseSupplierTaxCode Boolean True or false.
PurchasesTermsFreightTaxCodeID Uuid Unique guid identifier belonging to the assigned tax code.
PurchasesTermsFreightTaxCodeCode String 3 digit tax code.
PurchasesTermsFreightTaxCodeURI String Uniform resource identifier associated with the tax code object.
PurchasesTermsTaxCodeID Uuid Unique guid identifier belonging to the assigned tax code.
PurchasesTermsTaxCodeCode String 3 digit tax code.
PurchasesTermsTaxCodeURI String Uniform resource identifier associated with the tax code object.
ReportsAndFormsReportTaxablePayments Boolean True indicates that report taxable payments made to contractors is turned on. False indicates that report taxable payments made to contractors is turned off.
RowVersion String Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
SalesTermsBalanceDueDate Integer The balance due date which includes EOM (End of Month).
SalesTermsCreditLimit Decimal Default customer contact credit limit.
SalesTermsDiscountDate Integer The discount date which includes EOM (End of Month).
SalesTermsDiscountForEarlyPayment Double % discount for early payment.
SalesTermsMonthlyChargeForLatePayment Double % monthly charge for late payment.
SalesTermsPaymentIsDue String Default Terms of Payment definitions: CashOnDelivery, PrePaid, InAGivenNumberOfDays, OnADayOfTheMonth, NumberOfDaysAfterEOM, DayOfMonthAfterEOM.
SalesTermsPriceLevel String Default price level.
SalesTermsUseCustomerTaxCode Boolean True or false.
SalesTermsUseSupplierTaxCode Boolean True or false.
SalesTermsFreightTaxCodeID Uuid Unique guid identifier belonging to the assigned tax code.
SalesTermsFreightTaxCodeCode String 3 digit tax code.
SalesTermsFreightTaxCodeURI String Uniform resource identifier associated with the tax code object.
SalesTermsTaxCodeID Uuid Unique guid identifier belonging to the assigned tax code.
SalesTermsTaxCodeCode String 3 digit tax code.
SalesTermsTaxCodeURI String Uniform resource identifier associated with the tax code object.
SystemCategoryTracking String Can consist of the following values: Off ,OnAndNotRequired, OnAndRequired.
SystemLockPeriodPriorTo String Lock period disabling entries prior to a given date.
SystemTransactionsCannotBeChangedMustBeReversed Boolean True indicates that transctions cannot be changed or deleted, they must be reversed. False indicates transctions can be either changed or deleted.
TimesheetsUseTimesheetsFor String Can consist of either TimeBillingAndPayroll or Payroll.
TimesheetsWeekStartsOn String Day the week starts on ie: Monday, Tuesday, Wednesday.
CompanyFileId String The ID of the company file. Takes precedence over the CompanyFileId connection property.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462