traders_deleted_20260317_092156
efacdb_full ยท Backups, snapshots and deleted-row stores
Potentially sensitive columns detected and intentionally not previewed as raw row data here: isbacs, bacssort, bacsaccno, bacsacccd, bacslim, iban.
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | id | varchar(20) | - | NO | - | - |
| 2 | name | varchar(127) | - | YES | - | - |
| 3 | source | varchar(20) | - | YES | - | - |
| 4 | discount | double | - | NO | 0 | - |
| 5 | discterms | varchar(40) | - | YES | - | - |
| 6 | creditlimit | decimal(19,4) | - | NO | 0.0000 | - |
| 7 | ourid | varchar(30) | - | YES | - | - |
| 8 | settledays | double | - | NO | 0 | - |
| 9 | settlediscount | double | - | NO | 0 | - |
| 10 | onorderval | decimal(19,4) | - | YES | 0.0000 | - |
| 11 | creditdays | double | - | NO | 0 | - |
| 12 | creditmethod | varchar(1) | - | NO | - | - |
| 13 | indclass | varchar(8) | - | YES | - | - |
| 14 | isonhold | tinyint(1) | - | NO | 0 | - |
| 15 | createddate | timestamp | - | NO | CURRENT_TIMESTAMP | - |
| 16 | lasttransactdate | datetime(6) | - | YES | - | - |
| 17 | paymentname | varchar(40) | - | YES | - | - |
| 18 | paymentpriority | smallint | - | NO | 0 | - |
| 19 | suspreason | varchar(4) | - | YES | - | - |
| 20 | isbacs | tinyint(1) | - | NO | 0 | - |
| 21 | bacssort | varchar(20) | - | YES | - | - |
| 22 | bacsaccno | varchar(50) | - | YES | - | - |
| 23 | bacsacccd | smallint | - | NO | 0 | - |
| 24 | bacslim | decimal(19,4) | - | NO | 0.0000 | - |
| 25 | acceptsplitorder | tinyint(1) | - | NO | 0 | - |
| 26 | acceptsplititem | tinyint(1) | - | NO | 0 | - |
| 27 | islocked | tinyint(1) | - | NO | 0 | - |
| 28 | definvoicestate | varchar(4) | - | NO | - | - |
| 29 | status | varchar(20) | - | NO | - | - |
| 30 | grouptraderid | varchar(20) | - | YES | - | - |
| 31 | tradertype | varchar(2) | - | NO | - | - |
| 32 | creditreference | varchar(20) | - | YES | - | - |
| 33 | createdby | varchar(36) | - | YES | - | - |
| 34 | modifiedby | varchar(36) | - | YES | - | - |
| 35 | modifieddate | datetime(6) | - | YES | - | - |
| 36 | auditoperation | varchar(8) | - | YES | - | - |
| 37 | modifiedtimestamp | binary(8) | - | NO | - | - |
| 38 | islive | tinyint(1) | - | NO | 1 | - |
| 39 | category | varchar(30) | - | YES | - | - |
| 40 | issuspended | tinyint(1) | - | NO | - | - |
| 41 | contratraderid | varchar(20) | - | YES | - | - |
| 42 | companyid | varchar(30) | - | YES | - | - |
| 43 | factoringaccount | tinyint(1) | - | YES | 0 | - |
| 44 | factoringcompany | varchar(20) | - | YES | - | - |
| 45 | isenduser | tinyint(1) | - | NO | - | - |
| 46 | ean | varchar(13) | - | YES | - | - |
| 47 | salesman | varchar(30) | - | YES | - | - |
| 48 | accountmanager | varchar(30) | - | YES | - | - |
| 49 | tradercategory | varchar(20) | - | YES | - | - |
| 50 | balance | decimal(19,4) | - | NO | 0.0000 | - |
| 51 | tradingstatus | varchar(20) | - | NO | - | - |
| 52 | olversionnumber | int | - | NO | 0 | - |
| 53 | defaultinvoicemethod | varchar(20) | - | YES | - | - |
| 54 | iban | varchar(34) | - | YES | - | - |
| 55 | companyregnumber | varchar(30) | - | YES | - | - |
| 56 | vatregnumber | varchar(15) | - | YES | - | - |
| 57 | website | varchar(80) | - | YES | - | - |
| 58 | iscarrier | tinyint(1) | - | NO | 0 | - |
| 59 | laststatementdate | datetime(6) | - | YES | - | - |
| 60 | defaultdespatchtypeid | varchar(20) | - | YES | - | - |
| 61 | invoicedocumenttype | varchar(18) | - | YES | - | - |
| 62 | spreadsheetsummaryreport | varchar(150) | - | YES | - | - |
| 63 | billingrequestreferral | tinyint(1) | - | YES | - | - |
| 64 | referraldocumenttype | varchar(11) | - | YES | - | - |
| 65 | approvaldocumentreport | varchar(150) | - | YES | - | - |
| 66 | billingrequestinvconsolidation | tinyint(1) | - | YES | - | - |
| 67 | outstandingbillingrequestvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 68 | uuid | varchar(36) | - | NO | - | - |
| 69 | costcentrecategoryid | varchar(30) | - | YES | - | - |
| 70 | creditmonths | smallint | - | YES | - | - |
| 71 | bic | varchar(11) | - | YES | - | - |
| 72 | isavailableoffline | tinyint(1) | - | YES | - | - |
| 73 | autoallocatecashreceipts | tinyint(1) | - | NO | 1 | - |
| 74 | invoicepaymentprofile | varchar(60) | - | YES | - | - |
| 75 | paymentmethodid | varchar(36) | - | YES | - | - |
| 76 | cashflowadjustmentdays | smallint | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| No indexes found. |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |