Thursday, 28 August 2025, 6:30 PM
Created by: Ruvenss G. Wilches
Expenses has an amazing variety of fields, and is so extensive that it can touch the core of NIZU WorkSpace.
This are the possible fields to use in in this endpoint:
|
Field Name |
Type |
Length |
Allow NULL |
Default Value |
Mandatory |
|---|---|---|---|---|---|
|
id |
int |
11 |
NO |
AUTO_INCREMENT |
YES |
|
expense_date |
date |
- |
NO |
- |
YES |
|
category_id |
int |
11 |
NO |
- |
YES |
|
description |
mediumtext |
- |
YES |
NULL |
NO |
|
amount |
double |
- |
NO |
- |
YES |
|
files |
mediumtext |
- |
NO |
- |
YES |
|
title |
text |
- |
NO |
- |
YES |
|
project_id |
int |
11 |
NO |
0 |
YES |
|
user_id |
int |
11 |
NO |
0 |
YES |
|
tax_id |
int |
11 |
NO |
0 |
YES |
|
tax_id2 |
int |
11 |
NO |
0 |
YES |
|
client_id |
int |
11 |
NO |
0 |
YES |
|
recurring |
tinyint |
4 |
NO |
0 |
YES |
|
recurring_expense_id |
tinyint |
4 |
NO |
0 |
YES |
|
repeat_every |
int |
11 |
NO |
0 |
YES |
|
repeat_type |
enum |
days,weeks,months,years |
YES |
NULL |
NO |
|
no_of_cycles |
int |
11 |
NO |
0 |
YES |
|
next_recurring_date |
date |
- |
YES |
NULL |
NO |
|
no_of_cycles_completed |
int |
11 |
NO |
0 |
YES |
|
deleted |
tinyint |
1 |
NO |
0 |
YES |
|
created_by |
int |
11 |
NO |
- |
YES |
|
provider_id |
int |
11 |
YES |
NULL |
NO |
|
billable |
tinyint |
1 |
NO |
0 |
YES |
|
invoice_id |
int |
11 |
YES |
NULL |
NO |
|
paymentmode |
varchar |
50 |
YES |
NULL |
NO |
|
budget |
decimal |
10,2 |
YES |
NULL |
NO |
|
budget_year |
varchar |
4 |
YES |
NULL |
NO |