TABLE DETAIL REFERENCE: PreferencesPOCustomField
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
AccountingInfoPrefsTrackDepartments-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingInfoPrefsDepartmentTerminology12 VARCHAR 1000TrueFalseFalseTrue%s
AccountingInfoPrefsClassTrackingPerTxnLine-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingInfoPrefsClassTrackingPerTxn-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingInfoPrefsBookCloseDate11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
AccountingInfoPrefsFirstMonthOfFiscalYear12 VARCHAR 9TrueFalseFalseFalse
January
February
March
April
May
June
July
August
September
October
November
December
AccountingInfoPrefsTaxYearMonth12 VARCHAR 9TrueFalseFalseFalse
January
February
March
April
May
June
July
August
September
October
November
December
AccountingInfoPrefsTaxForm12 VARCHAR 1000TrueFalseFalseTrue%s
AccountingInfoPrefsUseAccountNumbers-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AccountingInfoPrefsCustomerTerminology12 VARCHAR 1000TrueFalseFalseTrue%s
ProductAndServicesPrefsForSales-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ProductAndServicesPrefsForPurchase-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ProductAndServicesPrefsQuantityWithPriceAndRate-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ProductAndServicesPrefsQuantityOnHand-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsCustomTxnNumbers-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAllowDeposit-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAllowDiscount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsDefaultDiscountAccount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAllowEstimates-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAutoApplyCredit-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAutoApplyPayments-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsEstimateMessage-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsETransactionEnabledStatus-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsETransactionAttachPDF-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsETransactionPaymentEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsIPNSupportEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAllowServiceDate-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsAllowShipping-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsDefaultShippingAccount-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsDefaultCustomerMessage-7 BIT 1TrueFalseFalseFalse
1
0
true
false
SalesFormsPrefsInvoiceCcEmailAddress12 VARCHAR 200TrueFalseFalseFalse%s
SalesFormsPrefsInvoiceBccEmailAddress12 VARCHAR 200TrueFalseFalseFalse%s
EmailMessagesPrefsInvoiceMessage12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsInvoiceSubject12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsEstimateMessage12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsEstimateSubject12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsSalesReceiptMessage12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsSalesReceiptSubject12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsStatementMessage12 VARCHAR 1000TrueFalseFalseFalse%s
EmailMessagesPrefsStatementSubject12 VARCHAR 1000TrueFalseFalseFalse%s
VendorAndPurchasesPrefsTrackingByCustomer-7 BIT 1TrueFalseFalseFalse
1
0
true
false
VendorAndPurchasesPrefsBillableExpenseTracking-7 BIT 1TrueFalseFalseFalse
1
0
true
false
VendorAndPurchasesPrefsDefaultTerms-7 BIT 1TrueFalseFalseFalse
1
0
true
false
VendorAndPurchasesPrefsDefaultMarkup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TimeTrackingPrefsUseServices-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TimeTrackingPrefsBillCustomers-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TimeTrackingPrefsShowBillRateToAll-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TimeTrackingPrefsWorkWeekStartDate12 VARCHAR 1000TrueFalseFalseTrue%s
TimeTrackingPrefsMarkTimeEntiresBillable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
TaxPrefsUsingSalesTax-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CurrencyPrefsMultiCurrencyEnabled-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ReportPrefsReportBasis-7 BIT 1TrueFalseFalseFalse
1
0
true
false
CalcAgingReportFromTxnDate-7 BIT 1TrueFalseFalseFalse
1
0
true
false
OtherPrefs1Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs1Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs2Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs2Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs3Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs3Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs4Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs4Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs5Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs5Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs6Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs6Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs7Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs7Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs8Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs8Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs9Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs9Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs10Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs10Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs11Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs11Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs12Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs12Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs13Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs13Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs14Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs14Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs15Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs15Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs16Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs16Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs17Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs17Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs18Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs18Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs19Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs19Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs20Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs20Value12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs21Name12 VARCHAR 1000TrueFalseFalseFalse%s
OtherPrefs21Value12 VARCHAR 1000TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldListID12 VARCHAR 36TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldAppId12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldDomain12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldEntityType12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldHeaderFull12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldHeaderLite12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldHidden-7 BIT 1TrueFalseFalseFalse
1
0
true
false
VendorAndPurchasesPrefsPOCustomFieldName12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldNameAndId12 VARCHAR 100TrueFalseFalseFalse%s
VendorAndPurchasesPrefsPOCustomFieldRequired-7 BIT 1TrueFalseFalseFalse
1
0
true
false
VendorAndPurchasesPrefsPOCustomFieldSparse-7 BIT 1TrueFalseFalseFalse
1
0
true
false
VendorAndPurchasesPrefsPOCustomFieldStatus12 VARCHAR 25TrueFalseFalseFalse%s
FQPrimaryKey12 VARCHAR 73TrueTrueFalseFalseFQPrimaryKey