ARCSTMXVAL FILE
This file contains an attribute value for a customer. The objet ID element
relates the value to a customer. Attribute values are used to help formulate
customer lists for reporting purposes within the AR system.
REFERENCED BY
AR120 AR129 AR130 AR131 AR135 AR170
AR210 AR211 AR217 AR222 AR223 AR227
AR228 AR229 AR230 AR232 AR233 AR235
AR237 AR238 AR239 AR245 AR250 AR251
AR253 AR258 AR264 AR265 AR271 AR275
AR282 AR285 AR290 AR291 AR292 AR293
AR294 AR296 AR300 BL232 BL290 MX123
WH110 WH130 WH226
UPDATED BY
AR23.1 AR23.2 AR501 AR515 AR550 MX500
AR09.1 AR10.1 AR301 BL02.1 BL802 PW550
TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTV-OBJ-ID Numeric 12 AR23.1 AR23.2
Element: Obj Id This is the object identifier that AR501 AR515
relates to a specific company customer AR550 MX500
record.
CTV-MATRIX-CAT Alpha 12 AR23.1 AR23.2
Element: Matrix Cat Attribute name assigned to an object AR501 AR515
(like customert) to track additional AR550 MX500
information.
CTV-MX-VALUE Alpha 32 AR23.1 AR23.2
Element: Mx Value The attribute value. AR501 AR515
AR550 MX500
ARCSTMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTVSET1 OBJ-ID AR09.1 AR10.1
MATRIX-CAT AR120 AR129
AR130 AR131
AR135 AR170
AR210 AR211
AR217 AR222
AR223 AR227
AR228 AR229
AR23.1 AR23.2
AR23.3 AR230
AR232 AR233
AR235 AR237
AR238 AR239
AR245 AR250
AR251 AR253
...
CTVSET2 MATRIX-CAT KeyChange AR120 AR129
MX-VALUE AR130 AR131
OBJ-ID AR135 AR170
AR210 AR211
AR217 AR222
AR223 AR227
AR228 AR229
AR23.3 AR230
AR232 AR233
AR235 AR237
AR238 AR239
AR245 AR250
AR251 AR253
AR258 AR264
AR265 AR271
...
ARCSTMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustomer ARCUSTOMER Not Required
CTV-OBJ-ID -> ACM-OBJ-ID
|