TABLE DETAIL REFERENCE: Preferences
(Online VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
| AccountingInfoPrefsTrackDepartments | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingInfoPrefsDepartmentTerminology | 12 | VARCHAR | 1000 | True | False | False | True | %s | |
| AccountingInfoPrefsClassTrackingPerTxnLine | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingInfoPrefsClassTrackingPerTxn | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingInfoPrefsBookCloseDate | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| AccountingInfoPrefsFirstMonthOfFiscalYear | 12 | VARCHAR | 9 | True | False | False | False | January February March April May June July August September October November December | |
| AccountingInfoPrefsTaxYearMonth | 12 | VARCHAR | 9 | True | False | False | False | January February March April May June July August September October November December | |
| AccountingInfoPrefsTaxForm | 12 | VARCHAR | 1000 | True | False | False | True | %s | |
| AccountingInfoPrefsUseAccountNumbers | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| AccountingInfoPrefsCustomerTerminology | 12 | VARCHAR | 1000 | True | False | False | True | %s | |
| ProductAndServicesPrefsForSales | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ProductAndServicesPrefsForPurchase | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ProductAndServicesPrefsQuantityWithPriceAndRate | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ProductAndServicesPrefsQuantityOnHand | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ProductAndServicesPrefsRevenueRecognitionEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| ProductAndServicesPrefsRevenueRecognitionFrequency | 12 | VARCHAR | 9 | True | False | False | False | Daily Weekly Monthly | |
| SalesFormsPrefsCustomTxnNumbers | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAllowDeposit | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsUsingPriceLevels | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAllowDiscount | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsDefaultDiscountAccount | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAllowEstimates | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAutoApplyCredit | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAutoApplyPayments | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsEstimateMessage | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsETransactionEnabledStatus | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsETransactionAttachPDF | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsETransactionPaymentEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsIPNSupportEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAllowServiceDate | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsAllowShipping | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsDefaultShippingAccount | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsDefaultCustomerMessage | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsEmailCopyToCompany | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesFormsPrefsInvoiceCcEmailAddress | 12 | VARCHAR | 200 | True | False | False | False | %s | |
| SalesFormsPrefsInvoiceBccEmailAddress | 12 | VARCHAR | 200 | True | False | False | False | %s | |
| EmailMessagesPrefsInvoiceMessage | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsInvoiceSubject | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsEstimateMessage | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsEstimateSubject | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsSalesReceiptMessage | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsSalesReceiptSubject | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsStatementMessage | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| EmailMessagesPrefsStatementSubject | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| VendorAndPurchasesPrefsTrackingByCustomer | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| VendorAndPurchasesPrefsBillableExpenseTracking | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| VendorAndPurchasesPrefsDefaultTerms | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| VendorAndPurchasesPrefsDefaultMarkup | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| TimeTrackingPrefsUseServices | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| TimeTrackingPrefsBillCustomers | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| TimeTrackingPrefsShowBillRateToAll | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| TimeTrackingPrefsWorkWeekStartDate | 12 | VARCHAR | 1000 | True | False | False | True | %s | |
| TimeTrackingPrefsMarkTimeEntiresBillable | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| TaxPrefsUsingSalesTax | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CurrencyPrefsMultiCurrencyEnabled | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| HomeCurrencyRefListID | 12 | VARCHAR | 36 | True | True | False | False | %s | Yes |
| ReportPrefsReportBasis | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CalcAgingReportFromTxnDate | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| OtherPrefs1Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs1Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs2Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs2Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs3Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs3Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs4Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs4Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs5Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs5Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs6Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs6Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs7Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs7Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs8Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs8Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs9Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs9Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs10Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs10Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs11Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs11Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs12Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs12Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs13Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs13Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs14Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs14Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs15Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs15Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs16Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs16Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs17Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs17Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs18Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs18Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs19Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs19Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs20Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs20Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs21Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs21Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs22Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs22Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs23Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs23Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs24Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs24Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs25Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs25Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs26Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs26Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs27Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs27Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs28Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs28Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs29Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs29Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs30Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs30Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs31Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs31Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs32Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs32Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs33Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs33Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs34Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs34Value | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs35Name | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| OtherPrefs35Value | 12 | VARCHAR | 1000 | True | False | False | False | %s |