Json Fields for Add and Edit
These keys go under the object field of the json string. This section describes the required field name,
the data type, and the character limit for each field.
Note: The respective ID field for each item type is not needed when doing an Add
Note 2:The format for smalldatetime is "YYYY-MM-DD HH:MM:SS"
- Users
- UserID:integer:10
- Name:string:30
- Department:string:15
- Email:string:50
- UserLogin:string:60
- UserPassword:string:15
- Admin:1 or 0:1
- Support:1 or 0:1
- Active:1 or 0:1
- Clients
- ClientID:integer:10
- ClientLogin:string:60
- ClientPassword:string:15
- Client:string:75
- Email:string:60
- Tel:string:20
- Fax:string:20
- Contact:string:40
- Address:string:50
- Address2:string:50
- City:string:30
- State:string:20
- Zip:string:10
- Country:string:30
- LastLogin:smalldatetime:16
- Active:1 or 0:1
- Notes:string:1073741823
- CustomField:string:30
- CustomFieldValue:string:30
- ReceiveMail:1 or 0:1
- NextBillDate:smalldatetime:16
- FreqUnit:string:4
- FreqDuration:integer:10
- AutoCharge:1 or 0:1
- ClientCard:string:50
- ClientExp:string:10
- ClientCardType:string:16
- ClientFirstName:string:30
- ClientLastName:string:40
- DateDeleted:smalldatetime:16
- GST:1 or 0:1
- PST:1 or 0:1
- HST:1 or 0:1
- PSTCompound:1 or 0:1
- GSTRate:decimal:24
- PSTRate:decimal:24
- HSTRate:decimal:24
- CustomFieldTwo:string:20
- DefaultRate:decimal:24
- BankAcctFirstName:string:30
- BankAcctLastName:string:30
- BankAcctRoutingNum:string:30
- BankAcctNum:string:30
- BankAcctHolderType:string:20
- BankAcctType:string:20
- AutoChargeACH:1 or 0:1
- CustomField2:string:55
- CustomFieldValue2:string:55
- CustomField3:string:55
- CustomFieldValue3:string:55
- CustomField4:string:55
- CustomFieldValue4:string:55
- CellNum:string:10
- HourlyServices
- ItemID:integer:10
- Service:string:30
- Description:string:1073741823
- HourlyRate:decimal:24
- Taxable:1 or 0:1
- Invoices
- ClientID:integer:10
- Invoice:integer:19
- InvoiceDate:smalldatetime:16
- DueDate:smalldatetime:16
- Notes:string:1073741823
- HowSent:string:50
- Terms:string:1073741823
- TotalCost:money (45.45):19
- OutstandingAmount:money (45.45):19
- UserID:integer:10
- InvoiceCustom:integer:10
- TotalTax:money (45.45):10
- ProjectID:integer:10
- LastChargeDate:smalldatetime:16
- Resent:1 or 0:1
- LastResendDate:smalldatetime:16
- Payments
- PaymentID:integer:10
- Invoice:integer:19
- ClientID:integer:10
- AmountPaid:decimal:24
- PaymentDate:smalldatetime:16
- Notes:string:1073741823
- AmountPaidBalance:decimal:24
- BilledMisc
- BMID:integer:10
- UserID:integer:10
- ClientID:integer:10
- DateCompleted:smalldatetime:16
- Qty:decimal:24
- Title:string:50
- Description:string:1073741823
- Invoiced:1 or 0:1
- InvoiceNumber:integer:19
- Taxable:1 or 0:1
- Rate:decimal:24
- ProjectID:integer:10
- MiscItems
- MiscID:integer:10
- Item:string:53
- Description:string:1073741823
- Rate:decimal:24
- Taxable:1 or 0:1
- BilledHourly
- BHID:integer:10
- UserID:integer:10
- DateCompleted:smalldatetime:16
- ClientID:integer:10
- Service:string:50
- Hours:decimal:24
- Rate:decimal:24
- Description:string:1073741823
- Invoiced:1 or 0:1
- InvoiceNumber:integer:19
- Taxable:1 or 0:1
- ProjectID:integer:10
- Subscribers
- Company:string:50
- Email:string:60
- Tel:string:20
- Contact:string:40
- TrialSignupDate:smalldatetime:16
- TrialVersion:1 or 0:1
- Active:1 or 0:1
- PID:string:35
- PaidUntilDate:smalldatetime:16
- RecurringBilling
- RBID:integer:10
- UserID:integer:10
- ClientID:integer:10
- DateCompleted:smalldatetime:16
- Qty:decimal:24
- Title:string:50
- Description:string:1073741823
- Taxable:1 or 0:1
- Rate:decimal:24
- NextBillingDate:smalldatetime:16
- FrequencyUnit:string:4
- FrequencyDuration:integer:10
- ProjectID:integer:10