AMDIVISION FILE
Division
The Division file stores optional division records which are used to report
asset information. Divisions are subordinate to locations in the reporting
hierarchy.
REFERENCED BY
AM125 AM200 AM212 AM220 AM221 AM222
AM223 AM224 AM225 AM230 AM235 AM240
AM245 AM250 AM255 AM260 AM280 AM285
AM290 AM292 AM295 AM30.1 AM35.1 AM45.1
AM580 AM60.1 AM70.1 AM90.1 AM95.1
UPDATED BY
AM08.1 AM08.2 AM115 AM12.1 AM15.1 AM15.2
AM15.3 AM15.4 AM170 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM500 AM950 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIV-DIVISION Alpha 15 AM08.1 AM08.2
Division A user-defined division which is used AM115 AM12.1
for reporting assets. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM950 AM96.1
AM98.1
DIV-DESCRIPTION Alpha 30 (Lower Case) AM08.1 AM08.2
Description The description of the division. AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM950 AM96.1
AM98.1
AMDIVISION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DIVSET1 DIVISION AM08.1 AM08.2
AM115 AM12.1
AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM200 AM212
AM220 AM221
AM222 AM223
AM224 AM225
AM230 AM235
AM240 AM245
AM250 AM255
...
AMDIVISION FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset1 AMASSET
1 -> AST-STATUS
DIV-DIVISION -> AST-DIVISION
AST-DSP-ASSET
AST-ASSET
Amasset2 AMASSET
2 -> AST-STATUS
DIV-DIVISION -> AST-DIVISION
AST-DSP-ASSET
AST-ASSET
Amasset3 AMASSET
3 -> AST-STATUS
DIV-DIVISION -> AST-DIVISION
AST-DSP-ASSET
AST-ASSET
Amassetadj AMASSETADJ
DIV-DIVISION -> ASA-DIVISION
ASA-ASSET
ASA-PROCESS-SEQ
Amassetdsp AMASSET
9 -> AST-STATUS
DIV-DIVISION -> AST-DIVISION
AST-DSP-ASSET
AST-ASSET
Amassettrf AMASSETTRF
DIV-DIVISION -> ATF-DIVISION
ATF-ASSET
ATF-PROCESS-SEQ
|