ERP 6.0 | /FLDQ/AD_MTCCODE TABLE
1 | ERP EHP7 | 6.0 | /FLDQ/AD_MTCCODE | 55 | 9 | FirstLogic Match Code Index Table |
ERP 6.0 | /FLDQ/AD_MTCCODE COLUMNS
ERP 6.0 | /FLDQ/AD_MTCCODE INDEXES
Name | Primary | Unique | Type | Columns |
---|---|---|---|---|
/FLDQ/AD_MTCCODE01 | No | No | NONCLUSTERED | MATCH_CODE1, CLIENT |
/FLDQ/AD_MTCCODE02 | No | No | NONCLUSTERED | MTC_CODE_NM1, CLIENT |
/FLDQ/AD_MTCCODE03 | No | No | NONCLUSTERED | MTC_CODE_NM2, CLIENT |
/FLDQ/AD_MTCCODE04 | No | No | NONCLUSTERED | MTC_CODE_NM3, CLIENT |
/FLDQ/AD_MTCCODE05 | No | No | NONCLUSTERED | MTC_CODE_NM4, CLIENT |
/FLDQ/AD_MTCCODE06 | No | No | NONCLUSTERED | MTC_CODE_NM5, CLIENT |
/FLDQ/AD_MTCCODE07 | No | No | NONCLUSTERED | PO_MATCH_CODE, CLIENT |
/FLDQ/AD_MTCCODE08 | No | No | NONCLUSTERED | NATION, DATE_FROM, PERSNUMBER, ADDRNUMBER |
/FLDQ/AD_MTCCODE~0 | Yes | Yes | CLUSTERED | APPL_FIELD, APPL_TABLE, NATION, DATE_FROM, ADDR_TYPE, PERSNUMBER, ADDRNUMBER, CLIENT |