zCMP_CostRollup_toMatchCRU_20260109

efacdb_full ยท Backups, snapshots and deleted-row stores
Back to EFACS Browser
Type
BASE TABLE
Rows est.
89,736
Size
12.52 MB
Updated
-

Columns

Full schema, no data mutation.
#NameTypeKeyNullableDefaultComment
1partnumvarchar(30)-NO--
2partdescvarchar(60)-YES--
3smvarchar(12)-YES--
4uomvarchar(30)-YES--
5rolledpurchasecostdouble-YES--
6rolledlabourcostdouble-YES--
7rolledoprcostdouble-YES--
8rolledsetcostdouble-YES--
9rolledtotalcostdouble-YES--
10warningvarchar(60)-YES--
11purchasingage_monthsdouble-YES--

Indexes

NameUniqueColumns
No indexes found.

Foreign Keys

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