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
AM200 AM212 AM220 AM221 AM222 AM223
AM224 AM225 AM230 AM235 AM240 AM245
AM25.1 AM250 AM252 AM255 AM258 AM260
AM267 AM278 AM280 AM281 AM285 AM287
AM290 AM292 AM295 AM30.1 AM330 AM35.1
AM45.1 AM580 AM60.1 AM70.1 AM90.1 AM90.4
AM90.5 AM91.1 AM91.4 AM91.5 AM95.1 AM95.4
AM95.5 AM95.6
UPDATED BY
AC10.1 AC10.3 AC160 AC56.1 AC560 AC71.1
AM08.1 AM08.2 AM115 AM117 AM12.1 AM15.1
AM15.2 AM15.3 AM15.4 AM17.1 AM170 AM19.1
AM19.2 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5
AM20.6 AM21.1 AM21.2 AM21.3 AM21.4 AM21.5
AM21.6 AM500 AM551 AM88.7 AM96.1 AM98.1
AP115 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 API1.1 API2.1 BL120 BL122
BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POI3.1 POID.1 POII.1 POIJ.1
RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIV-DIVISION Alpha 15 AC10.1 AC10.3
Element: Division A user-defined division which is used AC160 AC56.1
for reporting assets. AC560 AC71.1
AM08.1 AM08.2
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM88.7
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
...
DIV-DESCRIPTION Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Description The description of the division. AC160 AC56.1
AC560 AC71.1
AM08.1 AM08.2
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM88.7
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
...
AMDIVISION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DIVSET1 DIVISION AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM08.1 AM08.2
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM15.5
AM15.6 AM17.1
AM170 AM19.1
AM19.2 AM19.4
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM200 AM21.1
...
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
|