asaccount
619 rows
This data as json, CSV (advanced)
Suggested facets: typeId, dateCreated (date), dateLastModified (date)
| id ▼ | accountNumber | accountingHash | accountingId | activeFlag | dateCreated | dateLastModified | name | typeId |
|---|---|---|---|---|---|---|---|---|
| 345 | 3900 | 213 | _binary | 2023-04-19 18:04:34.441000 | 2023-04-19 18:04:34.441000 | (Retained Earnings) | 5 | |
| 346 | 1030 | 41 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | 1030 Middlesex Transit Acct. | 2 | |
| 347 | 3050 | 39 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | 30300 (Members Equity-Common) | 5 | |
| 348 | 233 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.795000 | 40000 (Sales Deposit) | 8 | ||
| 349 | 581 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 401K Loan Repayment | 13 | ||
| 350 | 2149 | 122 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | 401K Match Liability - Paid Qua | 13 | |
| 351 | 2113 | 70 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | 401K Payable | 13 | |
| 352 | 419 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 60000 (deleted):Excise Tax | 6 | ||
| 353 | 418 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 60200 (deleted):Buy-Out Life Ins. | 6 | ||
| 354 | 360 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 70400 (deleted):Heating Fuel-Fitchburg | 6 | ||
| 355 | 357 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 70400 (deleted):Phone-Fitchburg | 6 | ||
| 356 | 359 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 70400 (deleted):Utilities-Fitchburg | 6 | ||
| 357 | 163 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 70600 | 6 | ||
| 358 | 48 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.800000 | 77720 | 6 | ||
| 359 | 168 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | 80000 | 6 | ||
| 360 | 1504 | 146 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | A/D Furniture | 7 | |
| 361 | 2000 | 53 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accounts Payable | ||
| 362 | 2001 | 80 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accounts Payable - Other | 13 | |
| 363 | 240 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Accrued Bonus | 13 | ||
| 364 | 2130 | 112 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accrued Commissions | 13 | |
| 365 | 2100 | 285 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accrued Expenses | 13 | |
| 366 | 2101 | 379 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accrued payroll | 13 | |
| 367 | 247 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Accrued Vacation | 13 | ||
| 368 | 1105 | 214 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accts Receivable | 1 | |
| 369 | 1516 | 108 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accum. Amort.-LHI | 7 | |
| 370 | 1506 | 86 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accum. Dep. Drawing Mach | 7 | |
| 371 | 1511 | 87 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accum. Dep. Office | 7 | |
| 372 | 1501 | 85 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Accum. Dep.-Equipment | 7 | |
| 373 | 170 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Airborne | 6 | ||
| 374 | 261 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Amort. Developed Software | 7 | ||
| 375 | 3310 | 147 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Axia Capital | 5 | |
| 376 | 7040 | 29 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Axia Partners | 15 | |
| 377 | 1110 | 107 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Bad Debt Reserve | 1 | |
| 378 | 8810 | 250 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Bank Service Charges | 6 | |
| 379 | 554 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Billable Expense Income | 8 | ||
| 380 | 3380 | 150 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Black Beach | 5 | |
| 381 | 3340 | 148 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Brook Private 1A | 5 | |
| 382 | 3360 | 149 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Brook Private 1D | 5 | |
| 383 | 345 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Building Materials | 6 | ||
| 384 | 1518 | 205 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | CER Room Upgrade | 7 | |
| 385 | 258 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.810000 | Certifications and Regulatory | 6 | ||
| 386 | 1010 | 30 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Checking | 2 | |
| 387 | 2115 | 56 | _binary | 2023-04-19 18:04:34.456000 | 2023-04-19 18:04:34.456000 | Child Support | 13 | |
| 388 | 257 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold | 3 | ||
| 389 | 316 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold:Analytical | 3 | ||
| 390 | 330 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold:Analytical:Instrumentation | 3 | ||
| 391 | 331 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold:Analytical:Other | 3 | ||
| 392 | 329 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold:Analytical:Spetroscopy | 3 | ||
| 393 | 315 | _binary | 2023-04-19 18:04:34.456000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold:Industrial | 3 | ||
| 394 | 327 | _binary | 2023-04-19 18:04:34.472000 | 2026-04-21 10:03:54.842000 | Cost of Goods Sold:Industrial:Illumination | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "asaccount" (
"id" INTEGERNOT NULL ,
"accountNumber" TEXT DEFAULT NULL,
"accountingHash" TEXT DEFAULT NULL,
"accountingId" TEXT DEFAULT NULL,
"activeFlag" INTEGER DEFAULT NULL,
"dateCreated" TEXT DEFAULT NULL,
"dateLastModified" TEXT DEFAULT NULL,
"name" TEXT NOT NULL,
"typeId" INTEGERDEFAULT NULL,
PRIMARY KEY ("id")
);