home / fishbowl_archive

📥 Export to Excel (CSV) ⚙ Advanced filters

taxrate

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dateCreated (date), dateLastModified (date)

id ▼ accountingHash accountingId activeFlag code dateCreated dateLastModified defaultFlag description name orderTypeId rate taxAccountId typeCode typeId unitCost vendorId
1     _binary  NON 2023-01-05 17:27:13.943000 2023-01-05 17:27:13.943000 _binary    None   0.0     10 0.0  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "taxrate" (
 "id" INTEGERNOT NULL ,
 "accountingHash" TEXT DEFAULT NULL,
 "accountingId" TEXT DEFAULT NULL,
 "activeFlag" INTEGER NOT NULL,
 "code" TEXT DEFAULT NULL,
 "dateCreated" TEXT DEFAULT NULL,
 "dateLastModified" TEXT DEFAULT NULL,
 "defaultFlag" INTEGER NOT NULL,
 "description" TEXT DEFAULT NULL,
 "name" TEXT NOT NULL,
 "orderTypeId" INTEGERDEFAULT NULL,
 "rate" REAL DEFAULT NULL,
 "taxAccountId" INTEGERDEFAULT NULL,
 "typeCode" TEXT DEFAULT NULL,
 "typeId" INTEGERNOT NULL,
 "unitCost" REAL DEFAULT NULL,
 "vendorId" INTEGERDEFAULT NULL,
 PRIMARY KEY ("id")
);
Powered by Datasette · Queries took 13.623ms