vendor
1 row where activeFlag = "_binary " and statusId = 20 sorted by dateLastModified descending
This data as json, CSV (advanced)
Suggested facets: dateEntered (date), dateLastModified (date)
| id | accountId | accountNum | accountingHash | accountingId | activeFlag | creditLimit | currencyId | currencyRate | dateEntered | dateLastModified ▲ | defaultCarrierId | defaultCarrierServiceId | defaultPaymentTermsId | defaultShipTermsId | lastChangedUser | leadTime | minOrderAmount | name | note | statusId | sysUserId | taxRateId | url | customFields |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 558 | 644 | _binary | 0.0 | 0.0 | 2025-04-02 10:52:35.388000 | 2025-04-04 10:34:16.372000 | 3 | 4 | 4 | 35 | LWallace | 0.0 | IVG Fiber | 20 | {"7": {"name": "Approval Method", "type": "Text", "value": ""}, "8": {"name": "Re-Approval Date", "type": "Date", "value": "2026-04-02 00:00:00"}, "9": {"name": "Re-approval Method", "type": "Text", "value": ""}, "17": {"name": "Supplier Approval Method", "type": "Drop-Down List", "value": "Survey"}, "18": {"name": "Supplier Re-Approval Method", "type": "Drop-Down List", "value": "ISO9000 or Equivalent"}, "19": {"name": "Tier Level Assignment", "type": "Drop-Down List", "value": "Tier 1"}, "20": {"name": "Supplier Performance", "type": "Drop-Down List", "value": "0"}, "21": {"name": "Supplier ID", "type": "Count", "value": "1437"}} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "vendor" (
"id" INTEGERNOT NULL ,
"accountId" INTEGERNOT NULL,
"accountNum" TEXT DEFAULT NULL,
"accountingHash" TEXT DEFAULT NULL,
"accountingId" TEXT DEFAULT NULL,
"activeFlag" INTEGER NOT NULL,
"creditLimit" REAL DEFAULT NULL,
"currencyId" INTEGERDEFAULT NULL,
"currencyRate" REAL DEFAULT NULL,
"dateEntered" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"defaultCarrierId" INTEGERNOT NULL,
"defaultCarrierServiceId" INTEGERDEFAULT NULL,
"defaultPaymentTermsId" INTEGERNOT NULL,
"defaultShipTermsId" INTEGERNOT NULL,
"lastChangedUser" TEXT DEFAULT NULL,
"leadTime" INTEGERDEFAULT NULL,
"minOrderAmount" REAL DEFAULT NULL,
"name" TEXT NOT NULL,
"note" TEXT DEFAULT NULL,
"statusId" INTEGERNOT NULL,
"sysUserId" INTEGERDEFAULT NULL,
"taxRateId" INTEGERDEFAULT NULL,
"url" TEXT DEFAULT NULL,
"customFields" TEXT DEFAULT NULL,
PRIMARY KEY ("id")
);