zAR-BIP-stateset-orders
efacdb_full ยท Custom/model/helper tables
Columns
Full schema, no data mutation.| # | Name | Type | Key | Nullable | Default | Comment |
|---|
| 1 | snapshot-row-id | bigint | PRI | NO | - | - |
| 2 | statesetid | bigint | MUL | NO | - | - |
| 3 | id | varchar(30) | - | NO | | - |
| 4 | createddate | timestamp | - | YES | - | - |
| 5 | traderid | varchar(20) | - | YES | - | - |
| 6 | tradertype | varchar(2) | - | YES | - | - |
| 7 | orderdate | timestamp | - | NO | - | - |
| 8 | status | varchar(20) | - | NO | | - |
| 9 | tradercontactid | varchar(40) | - | YES | - | - |
| 10 | responsibility | varchar(36) | - | YES | - | - |
| 11 | createdby | varchar(36) | - | YES | - | - |
| 12 | invoiceaddressid | varchar(30) | - | NO | | - |
| 13 | deliveryaddressid | varchar(30) | - | YES | - | - |
| 14 | acknowledgementaddressid | varchar(30) | - | NO | | - |
| 15 | orderaddressid | varchar(30) | - | YES | - | - |
| 16 | currencyid | varchar(3) | - | YES | - | - |
| 17 | exchangerate | double | - | NO | 0 | - |
| 18 | eudeliveryid | varchar(3) | - | YES | - | - |
| 19 | eutransportid | smallint | - | YES | - | - |
| 20 | documentsent | tinyint | - | NO | 0 | - |
| 21 | documentduedate | datetime(6) | - | YES | - | - |
| 22 | communicationmethodid | varchar(30) | - | YES | - | - |
| 23 | traderorderreference | varchar(30) | - | YES | - | - |
| 24 | pricelistid | varchar(20) | - | YES | - | - |
| 25 | acceptsplitorder | tinyint | - | NO | 0 | - |
| 26 | revision | smallint | - | YES | - | - |
| 27 | chasedate | datetime(6) | - | YES | - | - |
| 28 | ordertype | varchar(2) | - | NO | | - |
| 29 | isapproved | tinyint | - | NO | 0 | - |
| 30 | communicationcontactid | varchar(40) | - | YES | - | - |
| 31 | validtilldate | datetime(6) | - | YES | - | - |
| 32 | modifiedby | varchar(36) | - | YES | - | - |
| 33 | modifieddate | datetime(6) | - | YES | - | - |
| 34 | auditoperation | varchar(8) | - | YES | - | - |
| 35 | modifiedtimestamp | binary(8) | - | NO | 0x | - |
| 36 | schedulerevision | varchar(20) | - | YES | - | - |
| 37 | ordercategory | varchar(20) | - | YES | - | - |
| 38 | contractquantity | double | - | YES | - | - |
| 39 | reasoncode | varchar(30) | - | YES | - | - |
| 40 | companyid | varchar(30) | - | YES | - | - |
| 41 | settlementdays | double | - | YES | - | - |
| 42 | settlediscrate | double | - | YES | - | - |
| 43 | thresholddiscpercent | double | - | NO | 0 | - |
| 44 | olversionnumber | int | - | NO | 0 | - |
| 45 | isproformasent | tinyint | - | YES | - | - |
| 46 | isproformapaid | tinyint | - | YES | - | - |
| 47 | creditcheckpassed | tinyint | - | NO | 0 | - |
| 48 | probabilityid | varchar(20) | - | YES | - | - |
| 49 | source | varchar(30) | - | YES | - | - |
| 50 | quoterejectcode | varchar(20) | - | YES | - | - |
| 51 | quoterejectcompetitor | varchar(30) | - | YES | - | - |
| 52 | markup | double | - | YES | - | - |
| 53 | markuppercentage | double | - | YES | - | - |
| 54 | outcome | varchar(8) | - | NO | | - |
| 55 | rejectioncomment | varchar(255) | - | YES | - | - |
| 56 | losttocompetitor | tinyint | - | YES | - | - |
| 57 | quotationexpired | tinyint | - | YES | - | - |
| 58 | opportunityid | int | - | YES | - | - |
| 59 | despatchtypeid | varchar(20) | - | YES | - | - |
| 60 | issuspended | tinyint | - | NO | 0 | - |
| 61 | suspensionreasoncode | varchar(20) | - | YES | - | - |
| 62 | deliverystreet | varchar(255) | - | YES | - | - |
| 63 | deliverycity | varchar(80) | - | YES | - | - |
| 64 | deliverycounty | varchar(80) | - | YES | - | - |
| 65 | deliverypostcode | varchar(15) | - | YES | - | - |
| 66 | deliverycountryid | varchar(3) | - | YES | - | - |
| 67 | deliveryareacodeid | varchar(30) | - | YES | - | - |
| 68 | uuid | varchar(36) | - | NO | | - |
| 69 | deliveryaddresstype | varchar(18) | - | YES | - | - |
| 70 | requestedondate | datetime(6) | - | YES | - | - |
| 71 | requiredbydate | datetime(6) | - | YES | - | - |
| 72 | orderexpecteddate | datetime(6) | - | YES | - | - |
| 73 | isproformaposted | tinyint | - | YES | - | - |
| 74 | isproforma | tinyint | - | YES | - | - |
| 75 | invoicepaymentprofileid | varchar(36) | - | YES | - | - |
| 76 | discountterms | varchar(255) | - | YES | - | - |
| 77 | paymenttoaddress | varchar(40) | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | snapshot-row-id |
| ix-zAR-BIP-stateset-orders-statesetid | No | statesetid |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |