TABLE DETAIL REFERENCE: CustomField
(USA VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| OwnerID | 12 | VARCHAR | 50 | True | False | True | True | %s | |
| Name | 12 | VARCHAR | 31 | True | False | True | True | %s | |
| EntityType | 12 | VARCHAR | 23 | True | False | True | False | Customer Vendor Employee OtherName Item Account | |
| EntityRefListID | 12 | VARCHAR | 36 | True | False | True | False | %s | Yes |
| EntityRefFullName | 12 | VARCHAR | 159 | True | False | True | False | %s | Yes |
| TxnType | 12 | VARCHAR | 23 | True | False | True | False | Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck VendorCredit BuildAssembly ARRefundCreditCard | |
| TxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| TxnLineID | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| OtherType | 12 | VARCHAR | 7 | True | False | True | False | Company | |
| Value | 12 | VARCHAR | 4095 | True | False | True | True |