zAR-BIP-paramset-orderitems

efacdb_full · Custom/model/helper tables

Back to EFACS Browser

Type

BASE TABLE

Rows est.

3,721

Size

2.63 MB

Updated

2026-05-17 16:30:10

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	snapshot-row-id	bigint	PRI	NO	-	-
2	paramsetid	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	-	-

Indexes

Name	Unique	Columns
PRIMARY	Yes	snapshot-row-id
ix-zAR-BIP-paramset-orderitems-paramsetid	No	paramsetid

Status Counts

Status	Count
ACTIVE	2,898
COMPLETE	901

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.