paymentterms
13 rows
This data as json, CSV (advanced)
Suggested facets: dateCreated, dateLastModified, defaultTerm, discount, netDays, readOnly, typeId, dateCreated (date), dateLastModified (date)
| id ▼ | accountingHash | accountingId | activeFlag | dateCreated | dateLastModified | defaultTerm | discount | discountDays | name | netDays | nextMonth | readOnly | typeId |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | _binary | 2023-01-05 17:27:13.505000 | 2023-01-05 17:27:13.505000 | _binary | 0.0 | COD | _binary | 20 | |||||
| 2 | _binary | 2023-01-05 17:27:13.505000 | 2023-01-05 17:27:13.505000 | _binary | 0.0 | CIA | _binary | 30 | |||||
| 3 | _binary | 2023-01-05 17:27:13.505000 | 2023-01-05 17:27:13.505000 | _binary | 0.0 | CCD | _binary | 40 | |||||
| 4 | _binary | 2023-01-05 17:27:13.520000 | 2023-01-05 17:27:13.520000 | _binary | 0.0 | NET 30 | 30 | _binary | 10 | ||||
| 5 | _binary | 2023-01-25 15:39:05.420000 | 2023-01-25 15:39:16.521000 | _binary | 0.0 | NET 60 | 60 | _binary | 10 | ||||
| 6 | _binary | 2023-01-25 15:39:18.795000 | 2023-01-25 15:39:26.945000 | _binary | 0.0 | NET 45 | 45 | _binary | 10 | ||||
| 7 | _binary | 2023-01-25 18:44:33.514000 | 2023-01-25 18:44:45.747000 | _binary | 0.0 | NET 40 | 40 | _binary | 10 | ||||
| 8 | _binary | 2023-01-25 21:47:56.293000 | 2023-01-25 21:48:03.960000 | _binary | 0.0 | NET 90 | 90 | _binary | 10 | ||||
| 9 | _binary | 2023-02-10 12:26:27.967000 | 2023-02-10 12:27:14.450000 | _binary | 0.02 | 10 | 2% 10 NET 30 | 30 | _binary | 10 | |||
| 10 | _binary | 2023-08-10 16:23:14.237000 | 2023-08-10 16:23:22.272000 | _binary | 0.0 | NET 15 | 15 | _binary | 10 | ||||
| 11 | _binary | 2023-11-27 12:16:44.315000 | 2023-11-27 12:17:04.384000 | _binary | 0.0 | NET 20 | 20 | _binary | 10 | ||||
| 12 | _binary | 2024-06-04 13:01:02.228000 | 2024-06-04 13:01:12.399000 | _binary | 0.0 | NET 10 | 10 | _binary | 10 | ||||
| 13 | _binary | 2024-08-28 16:52:45.323000 | 2024-08-28 16:58:20.450000 | _binary | 0.015 | 1.5% NET 15 | 15 | _binary | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "paymentterms" (
"id" INTEGERNOT NULL ,
"accountingHash" TEXT DEFAULT NULL,
"accountingId" TEXT DEFAULT NULL,
"activeFlag" INTEGER NOT NULL,
"dateCreated" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"defaultTerm" INTEGER NOT NULL,
"discount" REAL DEFAULT NULL,
"discountDays" INTEGERDEFAULT NULL,
"name" TEXT NOT NULL,
"netDays" INTEGERDEFAULT NULL,
"nextMonth" INTEGERDEFAULT NULL,
"readOnly" INTEGER NOT NULL,
"typeId" INTEGERNOT NULL,
PRIMARY KEY ("id")
);