zAR-BIP-paramset-routings

efacdb_full ยท Custom/model/helper tables
Back to EFACS Browser
Type
BASE TABLE
Rows est.
95,385
Size
32.08 MB
Updated
2026-05-17 16:30:10

Columns

Full schema, no data mutation.
#NameTypeKeyNullableDefaultComment
1snapshot-row-idbigintPRINO--
2paramsetidbigintMULNO--
3partidvarchar(30)-NO--
4methodidvarchar(8)-NO--
5operationnumbersmallint-NO--
6workcentreidvarchar(8)-YES--
7operatorskillsmallint-NO--
8settimedouble-NO--
9runtimedouble-NO--
10transfertimedouble-NO--
11perquantitysmallint-NO--
12descriptionvarchar(255)-YES--
13drawingreferencevarchar(14)-YES--
14overlappercentagesmallint-NO--
15alternativeoperationvarchar(1)-YES--
16alternativeoperationpreferencesmallint-NO--
17losspercentagedouble-NO--
18numberofoperatorsdouble-NO--
19fixedsubcontractcostdouble-NO--
20unitsubcontractcostdouble-NO--
21numberofsettersdouble-NO--
22setterskillsmallint-NO--
23fiscalstandardsettimedouble-NO--
24fiscalstandardruntimedouble-NO--
25fiscalstandardperquantitysmallint-YES--
26fiscalstandardnumberofsettersdouble-NO--
27fiscalstdnumberofoperatorsdouble-NO--
28fiscalstdfixedsubcontractcostdouble-NO--
29fiscalstdunitsubcontractcostdouble-NO--
30goingtosettimedouble-NO--
31goingtoruntimedouble-NO--
32goingtoperquantitysmallint-NO--
33goingtonumberofsettersdouble-NO--
34goingtonumberofoperatorsdouble-NO--
35goingtofixedsubcontractcostdouble-NO--
36goingtounitsubcontractcostdouble-NO--
37standardoperationvarchar(30)-YES--
38createdbyvarchar(36)-YES--
39createddatetimestamp-YES--
40modifiedbyvarchar(36)-YES--
41modifieddatedatetime(6)-YES--
42auditoperationvarchar(8)-YES--
43modifiedtimestampbinary(8)-NO--
44companyidvarchar(30)-YES--
45olversionnumberint-NO0-
46part_smvarchar(12)-YES--

Indexes

NameUniqueColumns
PRIMARYYessnapshot-row-id
ix-zAR-BIP-paramset-routings-paramsetidNoparamsetid

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.
ColumnReferences
No enforced foreign keys found for this table.