zAR-BIP-stateset-purchase-orderitems
efacdb_full ยท Custom/model/helper tables
Updated
2026-05-17 17:09:07
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 | orderid | varchar(30) | - | NO | | - |
| 4 | itemnumber | int | - | NO | 0 | - |
| 5 | partid | varchar(30) | - | NO | | - |
| 6 | eucommodityid | varchar(10) | - | YES | - | - |
| 7 | contractid | varchar(30) | - | YES | - | - |
| 8 | unitprice | double | - | NO | 0 | - |
| 9 | foreignunitprice | double | - | NO | 0 | - |
| 10 | nettprice | decimal(19,4) | - | NO | 0.0000 | - |
| 11 | foreignnettprice | decimal(19,4) | - | NO | 0.0000 | - |
| 12 | discountvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 13 | foreigndiscountvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 14 | vatcode | varchar(1) | - | YES | - | - |
| 15 | vatvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 16 | foreignvatvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 17 | costcentreid | varchar(30) | - | YES | - | - |
| 18 | pricingmethod | varchar(255) | - | YES | - | - |
| 19 | discountpercentage | double | - | NO | 0 | - |
| 20 | duedate | timestamp | - | NO | - | - |
| 21 | partrevisionid | varchar(30) | - | YES | - | - |
| 22 | description | varchar(255) | - | YES | - | - |
| 23 | status | varchar(20) | - | NO | | - |
| 24 | traderquantity | double | - | NO | 0 | - |
| 25 | subcontractworksorderid | varchar(30) | - | YES | - | - |
| 26 | subcontractoperationnumber | int | - | YES | - | - |
| 27 | category | varchar(20) | - | YES | - | - |
| 28 | traderuom | varchar(30) | - | YES | - | - |
| 29 | stockedquantity | double | - | NO | 0 | - |
| 30 | eusupplementaryunits | double | - | YES | - | - |
| 31 | traderorderreference | varchar(30) | - | YES | - | - |
| 32 | traderorderreferenceitemnumber | smallint | - | YES | - | - |
| 33 | traderpartreference | varchar(60) | - | YES | - | - |
| 34 | eutransactiontype | smallint | - | YES | - | - |
| 35 | requesteddate | timestamp | - | NO | - | - |
| 36 | originalduedate | timestamp | - | NO | - | - |
| 37 | acceptsplititem | tinyint | - | NO | 0 | - |
| 38 | originalorderid | varchar(30) | - | YES | - | - |
| 39 | originalorderitemnumber | int | - | YES | - | - |
| 40 | originalordertype | varchar(2) | - | YES | - | - |
| 41 | shippedquantity | double | - | NO | 0 | - |
| 42 | assembledquantity | double | - | NO | 0 | - |
| 43 | currentunitcost | double | - | NO | 0 | - |
| 44 | standardunitcost | double | - | NO | 0 | - |
| 45 | actualunitcost | double | - | NO | 0 | - |
| 46 | nettvalueinvoiced | decimal(19,4) | - | NO | 0.0000 | - |
| 47 | invoicedquantity | double | - | NO | 0 | - |
| 48 | invoiced | varchar(1) | - | NO | | - |
| 49 | ordertype | varchar(2) | - | NO | | - |
| 50 | vatpercentage | double | - | NO | 0 | - |
| 51 | createdby | varchar(36) | - | YES | - | - |
| 52 | createddate | timestamp | - | YES | - | - |
| 53 | modifiedby | varchar(36) | - | YES | - | - |
| 54 | modifieddate | datetime(6) | - | YES | - | - |
| 55 | auditoperation | varchar(8) | - | YES | - | - |
| 56 | schedulereference | varchar(30) | - | YES | - | - |
| 57 | modifiedtimestamp | binary(8) | - | NO | 0x | - |
| 58 | invoicemethod | varchar(20) | - | NO | | - |
| 59 | isinvoiced | tinyint | - | NO | 0 | - |
| 60 | nominalaccountid | varchar(20) | - | YES | - | - |
| 61 | isscheduleitem | tinyint | - | YES | - | - |
| 62 | companyid | varchar(30) | - | YES | - | - |
| 63 | settlediscvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 64 | foreignsettlediscvalue | decimal(19,4) | - | NO | 0.0000 | - |
| 65 | schedulerevision | int | - | YES | - | - |
| 66 | horizon | varchar(10) | - | YES | - | - |
| 67 | nlapportionmentid | varchar(20) | - | YES | - | - |
| 68 | isconsignment | tinyint | - | NO | 0 | - |
| 69 | traderunitprice | double | - | NO | 0 | - |
| 70 | foreigntraderunitprice | double | - | NO | 0 | - |
| 71 | olversionnumber | int | - | NO | 0 | - |
| 72 | allocationnumber | int | - | YES | - | - |
| 73 | packsize | double | - | YES | - | - |
| 74 | markup | double | - | YES | - | - |
| 75 | markuppercentage | double | - | YES | - | - |
| 76 | outcome | varchar(8) | - | NO | | - |
| 77 | groupitemnumber | int | - | NO | 0 | - |
| 78 | isprimeitem | tinyint | - | NO | 0 | - |
| 79 | batchquantity | double | - | YES | - | - |
| 80 | sequencenumber | int | - | YES | - | - |
| 81 | extnominalaccountid | varchar(20) | - | YES | - | - |
| 82 | isprocessed | tinyint | - | NO | 0 | - |
| 83 | zeropricereasoncode | varchar(20) | - | YES | - | - |
| 84 | ismanuallypriced | tinyint | - | NO | 0 | - |
| 85 | uuid | varchar(36) | - | NO | | - |
| 86 | costcentreassignmentid | varchar(36) | - | YES | - | - |
| 87 | consignmentid | int | - | YES | - | - |
| 88 | part_sm | varchar(12) | - | YES | - | - |
| 89 | expected-receipt-date | date | - | YES | - | - |
Indexes
| Name | Unique | Columns |
|---|
| PRIMARY | Yes | snapshot-row-id |
| ix-zAR-BIP-stateset-purchase-orderitems-statesetid | No | statesetid |
Foreign Keys
EFACS has few enforced keys; many relationships are conventional.| Column | References |
|---|
| No enforced foreign keys found for this table. |