vendor
5 rows where activeFlag = "_binary " and statusId = 20 sorted by dateLastModified descending
This data as json, CSV (advanced)
Suggested facets: defaultCarrierId, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 588 | 682 | _binary | 0.0 | 0.0 | 2026-03-26 12:49:39.797000 | 2026-03-26 12:52:01.636000 | 3 | 1 | 10 | EReed | 0.0 | CS Hyde Company | 20 | {"7": {"name": "Approval Method", "type": "Text", "value": ""}, "8": {"name": "Re-Approval Date", "type": "Date"}, "9": {"name": "Re-approval Method", "type": "Text", "value": ""}, "17": {"name": "Supplier Approval Method", "type": "Drop-Down List", "value": "Sole Source"}, "18": {"name": "Supplier Re-Approval Method", "type": "Drop-Down List", "value": ""}, "19": {"name": "Tier Level Assignment", "type": "Drop-Down List", "value": "Tier 2"}, "20": {"name": "Supplier Performance", "type": "Drop-Down List", "value": ""}, "21": {"name": "Supplier ID", "type": "Count", "value": "1502"}} | ||||||||||
| 587 | 681 | _binary | 0.0 | 0.0 | 2026-03-26 12:08:22.972000 | 2026-03-26 12:10:27.600000 | 3 | 1 | 10 | EReed | 0.0 | Nordson Medical | 20 | {"7": {"name": "Approval Method", "type": "Text", "value": ""}, "8": {"name": "Re-Approval Date", "type": "Date"}, "9": {"name": "Re-approval Method", "type": "Text", "value": ""}, "17": {"name": "Supplier Approval Method", "type": "Drop-Down List", "value": "Provisional"}, "18": {"name": "Supplier Re-Approval Method", "type": "Drop-Down List", "value": ""}, "19": {"name": "Tier Level Assignment", "type": "Drop-Down List", "value": "Tier 2"}, "20": {"name": "Supplier Performance", "type": "Drop-Down List", "value": ""}, "21": {"name": "Supplier ID", "type": "Count", "value": "1501"}} | ||||||||||
| 585 | 679 | _binary | 0.0 | 0.0 | 2026-03-25 16:29:36.293000 | 2026-03-26 12:08:21.324000 | 3 | 1 | 10 | EReed | 0.0 | MilliporeSigma | 20 | {"7": {"name": "Approval Method", "type": "Text", "value": ""}, "8": {"name": "Re-Approval Date", "type": "Date"}, "9": {"name": "Re-approval Method", "type": "Text", "value": ""}, "17": {"name": "Supplier Approval Method", "type": "Drop-Down List", "value": "Sole Source"}, "18": {"name": "Supplier Re-Approval Method", "type": "Drop-Down List", "value": "Sole Source"}, "19": {"name": "Tier Level Assignment", "type": "Drop-Down List", "value": "Tier 2"}, "20": {"name": "Supplier Performance", "type": "Drop-Down List", "value": ""}, "21": {"name": "Supplier ID", "type": "Count", "value": "1499"}} | ||||||||||
| 586 | 680 | _binary | 0.0 | 0.0 | 2026-03-26 11:04:39.181000 | 2026-03-26 11:07:24.086000 | 3 | 1 | 10 | EReed | 0.0 | AAdvance Instruments | 20 | {"7": {"name": "Approval Method", "type": "Text", "value": ""}, "8": {"name": "Re-Approval Date", "type": "Date"}, "9": {"name": "Re-approval Method", "type": "Text", "value": ""}, "17": {"name": "Supplier Approval Method", "type": "Drop-Down List", "value": "Provisional"}, "18": {"name": "Supplier Re-Approval Method", "type": "Drop-Down List", "value": "Other"}, "19": {"name": "Tier Level Assignment", "type": "Drop-Down List", "value": "Tier 2"}, "20": {"name": "Supplier Performance", "type": "Drop-Down List", "value": ""}, "21": {"name": "Supplier ID", "type": "Count", "value": "1500"}} | ||||||||||
| 584 | 678 | _binary | 0.0 | 0.0 | 2026-03-25 16:05:40.971000 | 2026-03-26 11:04:36.273000 | 8 | 1 | 10 | EReed | 0.0 | Agilent | 20 | {"7": {"name": "Approval Method", "type": "Text", "value": ""}, "8": {"name": "Re-Approval Date", "type": "Date"}, "9": {"name": "Re-approval Method", "type": "Text", "value": ""}, "17": {"name": "Supplier Approval Method", "type": "Drop-Down List", "value": "Provisional"}, "18": {"name": "Supplier Re-Approval Method", "type": "Drop-Down List", "value": "Sole Source"}, "19": {"name": "Tier Level Assignment", "type": "Drop-Down List", "value": "Tier 2"}, "20": {"name": "Supplier Performance", "type": "Drop-Down List", "value": ""}, "21": {"name": "Supplier ID", "type": "Count", "value": "1498"}} |
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")
);