TABLE DETAIL REFERENCE: Preferences
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ID4 INTEGER 4TrueFalseFalseFalseFQID
AccountingPrefsIsUsingAccountNumbers-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingPrefsIsRequiringAccounts-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingPrefsIsUsingClassTracking-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingPrefsIsUsingAuditTrail-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingPrefsIsAssigningJournalEntryNumbers-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingPrefsClosingDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
FinanceChargePrefsAnnualInterestRate3 DECIMAL 18TrueFalseFalseFalse%10.5f
FinanceChargePrefsMinFinanceCharge3 DECIMAL 17TrueFalseFalseFalse%10.2f
FinanceChargePrefsGracePeriod4 INTEGER 4TrueFalseFalseFalse%11.0f
FinanceChargePrefsFinanceChargeAcctRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
FinanceChargePrefsFinanceChargeAcctRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
FinanceChargePrefsIsAssessingForOverdueCharges-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FinanceChargePrefsCalculateChargesFrom12 VARCHAR 20TrueFalseFalseFalse
DueDate
InvoiceOrBilledDate
FinanceChargePrefsIsMarkedToBePrinted-7 BIT 1TrueFalseFalseFalse
1
0
true
false
JobsAndEstimatesPrefsIsUsingEstimates-7 BIT 1TrueFalseFalseFalse
1
0
true
false
JobsAndEstimatesPrefsIsUsingProgressInvoicing-7 BIT 1TrueFalseFalseFalse
1
0
true
false
JobsAndEstimatesPrefsIsPrintingItemsWithZeroAmounts-7 BIT 1TrueFalseFalseFalse
1
0
true
false
MultiCurrencyPrefsIsMultiCurrencyOn-7 BIT 1TrueFalseFalseFalse
1
0
true
false
MultiCurrencyPrefsHomeCurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
MultiCurrencyPrefsHomeCurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
MultiLocationInventoryPrefsIsMultiLocationInventoryAvailable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
MultiLocationInventoryPrefsIsMultiLocationInventoryEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchasesAndVendorsPrefsIsUsingInventory-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchasesAndVendorsPrefsDaysBillsAreDue4 INTEGER 4TrueFalseFalseFalse%11.0f
PurchasesAndVendorsPrefsIsAutomaticallyUsingDiscounts-7 BIT 1TrueFalseFalseFalse
1
0
true
false
PurchasesAndVendorsPrefDefaultDisARefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PurchasesAndVendorsPrefDefaultDisARefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
PurchasesAndVendorsPrefsIsUsingUnitsOfMeasure-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ReportsPrefsAgingReportBasis12 VARCHAR 22TrueFalseFalseFalse
AgeFromDueDate
AgeFromTransactionDate
ReportsPrefsSummaryReportBasis12 VARCHAR 7TrueFalseFalseFalse
Accrual
Cash
SalesAndCustomersPrefsDeftShipMethRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesAndCustomersPrefsDeftShipMethRefFullName12 VARCHAR 15TrueFalseFalseFalse%s Yes
SalesAndCustomersPrefsDefaultFOB12 VARCHAR 13TrueFalseFalseFalse%s
SalesAndCustomersPrefsDefaultMarkup3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesAndCustomersPrefsIsTrackingReimbursedExpensesAsIncome-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesAndCustomersPrefsIsAutoApplyingPayments-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesAndCustomersPrefPriceLevelsIsUsingPriceLevels-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesAndCustomersPrefPriceLevelsIsRoundingSalesPriceUp-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesAndCustomersPrefsPLIsUsingPriceLevels-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesAndCustomersPrefsPLIsRoundingSalesPriceUp-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesTaxPrefsDefaultItemSalesTaxRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxPrefsDefaultItemSalesTaxRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
SalesTaxPrefsPaySalesTax12 VARCHAR 9TrueFalseFalseFalse
Monthly
Quarterly
Annually
SalesTaxPrefsDefaultTaxableSaleTCRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxPrefsDefaultTaxableSaleTCRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
SalesTaxPrefsDefaultNonTaxableSaleTCRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxPrefsDefaultNonTaxableSaleTCRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
TimeTrackingPrefsFirstDayOfWeek12 VARCHAR 9TrueFalseFalseFalse
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
CurrentAppAccessRightsIsAutomaticLoginAllowed-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CurrentAppAccessRightsAutomaticLoginUserName12 VARCHAR 29TrueFalseFalseFalse%s
CurrentAppAccessRightsIsPersonalDataAccessAllowed-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsEnhancedInventoryReceivingEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsIsTrackingSerialOrLotNumber12 VARCHAR 12TrueFalseFalseFalseNone
SerialNumber
LotNumber
ItemsAndInventoryPrefsIsTrackingOnSalesTransactionsEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsIsTrackingOnPurchaseTransactionsEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsIsTrackingOnInventoryAdjustmentEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsIsTrackingOnBuildAssemblyEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsFIFOEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsFIFOEffectiveDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
ItemsAndInventoryPrefsIsRSBEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemsAndInventoryPrefsIsBarcodeEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false