TABLE DETAIL REFERENCE: CustomField
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
OwnerID12 VARCHAR 50TrueFalseTrueTrue%s
Name12 VARCHAR 31TrueFalseTrueTrue%s
EntityType12 VARCHAR 23TrueFalseTrueFalse
Customer
Vendor
Employee
OtherName
Item
Account
EntityRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
EntityRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnType12 VARCHAR 23TrueFalseTrueFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
VendorCredit
BuildAssembly
ARRefundCreditCard
TxnID12 VARCHAR 36TrueFalseTrueFalse%s
TxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
OtherType12 VARCHAR 7TrueFalseTrueFalse
Company
Value12 VARCHAR 4095TrueFalseTrueTrue