JDE_TS_F5606ZW |
Default Table Name | JDE_TS_F5606ZW |
Definition |
JDE_TS_F5606ZW Columns |
ColumnName | Domain | Datatype | NULL | Definition |
WKC5606EMP![]() |
CHAR(20) | NO | ||
WKC5606TS![]() |
CHAR(10) | NO | ||
WKC5606FYR![]() |
CHAR(4) | NO | ||
WKC5606PER![]() |
CHAR(3) | NO | ||
WKEDLN![]() |
FLOAT(126) | NO | ||
WKC5606CDT![]() |
CHAR(10) | NO | ||
WKC5606SDT | CHAR(10) | YES | ||
WKC5606EDT | CHAR(10) | YES | ||
WKEDBT | CHAR(15) | YES | ||
WKC5606TSD | CHAR(10) | YES | ||
WKC5606SID | CHAR(10) | YES | ||
WKC5606CCD | CHAR(10) | YES | ||
WKC5606OTH | CHAR(20) | YES | ||
WKC5606LDS | CHAR(120) | YES | ||
WKC5606GRP | CHAR(20) | YES | ||
WKC5606CHG | CHAR(45) | YES | ||
WKC5606CAI | CHAR(20) | YES | ||
WKC5606UTL | CHAR(10) | YES | ||
WKC5606T01 | CHAR(30) | YES | ||
WKC5606T02 | CHAR(30) | YES | ||
WKC5606T03 | CHAR(20) | YES | ||
WKC5606T04 | CHAR(20) | YES | ||
WKC5606T05 | CHAR(20) | YES | ||
WKC5606T06 | CHAR(20) | YES | ||
WKC5606T07 | CHAR(20) | YES | ||
WKC5606T08 | CHAR(20) | YES | ||
WKC5606T09 | CHAR(20) | YES | ||
WKC5606T10 | CHAR(20) | YES | ||
WKC5606TST | CHAR(254) | YES | ||
WKC5606LBR | CHAR(20) | YES | ||
WKC5606LAM | CHAR(20) | YES | ||
WKC5606BRT | CHAR(20) | YES | ||
WKC5606BAM | CHAR(20) | YES | ||
WKC5606HRS | CHAR(20) | YES | ||
WKC5606CRF | CHAR(1) | YES | ||
WKC5606CTX | CHAR(254) | YES | ||
WKC5606LTX | CHAR(254) | YES | ||
WKC5606STS | CHAR(1) | YES | ||
WKEDSP | CHAR(1) | YES | ||
WKC5606ETX | CHAR(254) | YES | ||
WKC5606ETK | CHAR(50) | YES | ||
WKUSER | CHAR(10) | YES | ||
WKPID | CHAR(10) | YES | ||
WKJOBN | CHAR(10) | YES | ||
WKUPMJ | NUMBER(6, 0) | YES | ||
WKUPMT | NUMBER(6, 0) | YES | ||
WKC5606T11 | CHAR(30) | YES | ||
WKC5606T12 | CHAR(30) | YES | ||
WKC5606T13 | CHAR(30) | YES | ||
WKC5606T14 | CHAR(30) | YES | ||
WKC5606T15 | CHAR(30) | YES |
JDE_TS_F5606ZW Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_O233 | PrimaryKey | WKC5606EMP, WKC5606TS, WKC5606FYR, WKC5606PER, WKEDLN, WKC5606CDT |
JDE_TS_F5606ZW Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |