itemadjust
2 rows
This data as json, CSV (advanced)
| id ▼ | activeFlag | amount | description | expenseAsAccountId | incomeAsAccountId | name | percentage | taxRateId | taxableFlag | typeId |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | _binary | 0.0 | Ten Percent | 0.1 | _binary | 20 | ||||
| 2 | _binary | 15.0 | Flat Rate | 0.0 | _binary | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "itemadjust" (
"id" INTEGERNOT NULL ,
"activeFlag" INTEGER NOT NULL,
"amount" REAL DEFAULT NULL,
"description" TEXT DEFAULT NULL,
"expenseAsAccountId" INTEGERDEFAULT NULL,
"incomeAsAccountId" INTEGERDEFAULT NULL,
"name" TEXT NOT NULL,
"percentage" REAL DEFAULT NULL,
"taxRateId" INTEGERDEFAULT NULL,
"taxableFlag" INTEGER NOT NULL,
"typeId" INTEGERNOT NULL,
PRIMARY KEY ("id")
);