FIELD NAME |
TYPE |
LENGTH |
QRY |
MOD |
INS |
REQ INS |
VALIDATE |
REL |
OwnerID |
Varchar |
50 |
True |
False |
True |
Yes |
String |
|
Name |
Varchar |
31 |
True |
False |
True |
Yes |
String |
|
EntityType |
Varchar |
23 |
True |
False |
True |
No |
Customer Vendor Employee OtherName Item Account |
|
EntityRefListID |
Varchar |
36 |
True |
False |
True |
No |
String |
|
EntityRefFullName |
Varchar |
159 |
True |
False |
True |
No |
String |
|
TxnType |
Varchar |
23 |
True |
False |
True |
No |
Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck VendorCredit BuildAssembly ARRefundCreditCard |
|
TxnID |
Varchar |
36 |
True |
False |
True |
No |
String |
|
TxnLineID |
Varchar |
36 |
True |
False |
True |
No |
String |
|
OtherType |
Varchar |
7 |
True |
False |
True |
No |
Company |
|
Value |
Varchar |
4095 |
True |
False |
True |
Yes |
|
|
|
|