TABLE DETAIL REFERENCE: Preferences
(USA VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ID | 4 | INTEGER | 4 | True | False | False | False | FQID | |
| AccountingPrefsIsUsingAccountNumbers | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingPrefsIsRequiringAccounts | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingPrefsIsUsingClassTracking | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingPrefsIsUsingAuditTrail | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingPrefsIsAssigningJournalEntryNumbers | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingPrefsClosingDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| FinanceChargePrefsAnnualInterestRate | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
| FinanceChargePrefsMinFinanceCharge | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| FinanceChargePrefsGracePeriod | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| FinanceChargePrefsFinanceChargeAcctRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| FinanceChargePrefsFinanceChargeAcctRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| FinanceChargePrefsIsAssessingForOverdueCharges | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| FinanceChargePrefsCalculateChargesFrom | 12 | VARCHAR | 20 | True | False | False | False | DueDate InvoiceOrBilledDate | |
| FinanceChargePrefsIsMarkedToBePrinted | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| JobsAndEstimatesPrefsIsUsingEstimates | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| JobsAndEstimatesPrefsIsUsingProgressInvoicing | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| JobsAndEstimatesPrefsIsPrintingItemsWithZeroAmounts | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| MultiCurrencyPrefsIsMultiCurrencyOn | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| MultiCurrencyPrefsHomeCurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| MultiCurrencyPrefsHomeCurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| MultiLocationInventoryPrefsIsMultiLocationInventoryAvailable | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| MultiLocationInventoryPrefsIsMultiLocationInventoryEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| PurchasesAndVendorsPrefsIsUsingInventory | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| PurchasesAndVendorsPrefsDaysBillsAreDue | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| PurchasesAndVendorsPrefsIsAutomaticallyUsingDiscounts | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| PurchasesAndVendorsPrefDefaultDisARefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| PurchasesAndVendorsPrefDefaultDisARefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| PurchasesAndVendorsPrefsIsUsingUnitsOfMeasure | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ReportsPrefsAgingReportBasis | 12 | VARCHAR | 22 | True | False | False | False | AgeFromDueDate AgeFromTransactionDate | |
| ReportsPrefsSummaryReportBasis | 12 | VARCHAR | 7 | True | False | False | False | Accrual Cash | |
| SalesAndCustomersPrefsDeftShipMethRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesAndCustomersPrefsDeftShipMethRefFullName | 12 | VARCHAR | 15 | True | False | False | False | %s | Yes |
| SalesAndCustomersPrefsDefaultFOB | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| SalesAndCustomersPrefsDefaultMarkup | 3 | DECIMAL | 18 | True | False | False | False | %10.5f | |
| SalesAndCustomersPrefsIsTrackingReimbursedExpensesAsIncome | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesAndCustomersPrefsIsAutoApplyingPayments | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesAndCustomersPrefPriceLevelsIsUsingPriceLevels | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesAndCustomersPrefPriceLevelsIsRoundingSalesPriceUp | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesAndCustomersPrefsPLIsUsingPriceLevels | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesAndCustomersPrefsPLIsRoundingSalesPriceUp | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesTaxPrefsDefaultItemSalesTaxRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesTaxPrefsDefaultItemSalesTaxRefFullName | 12 | VARCHAR | 31 | True | False | False | False | %s | Yes |
| SalesTaxPrefsPaySalesTax | 12 | VARCHAR | 9 | True | False | False | False | Monthly Quarterly Annually | |
| SalesTaxPrefsDefaultTaxableSaleTCRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesTaxPrefsDefaultTaxableSaleTCRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| SalesTaxPrefsDefaultNonTaxableSaleTCRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesTaxPrefsDefaultNonTaxableSaleTCRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| TimeTrackingPrefsFirstDayOfWeek | 12 | VARCHAR | 9 | True | False | False | False | Monday Tuesday Wednesday Thursday Friday Saturday Sunday | |
| CurrentAppAccessRightsIsAutomaticLoginAllowed | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CurrentAppAccessRightsAutomaticLoginUserName | 12 | VARCHAR | 29 | True | False | False | False | %s | |
| CurrentAppAccessRightsIsPersonalDataAccessAllowed | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsEnhancedInventoryReceivingEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsIsTrackingSerialOrLotNumber | 12 | VARCHAR | 12 | True | False | False | False | None SerialNumber LotNumber | |
| ItemsAndInventoryPrefsIsTrackingOnSalesTransactionsEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsIsTrackingOnPurchaseTransactionsEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsIsTrackingOnInventoryAdjustmentEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsIsTrackingOnBuildAssemblyEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsFIFOEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsFIFOEffectiveDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| ItemsAndInventoryPrefsIsRSBEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ItemsAndInventoryPrefsIsBarcodeEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false |