AMDIVISION

Asset 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
AM05.1 AM06.1 AM06.2 AM06.3 AM06.5 AM09.1
AM125 AM135 AM145 AM154 AM155 AM16.1
AM180 AM190 AM192 AM200 AM212 AM220
AM221 AM222 AM223 AM224 AM225 AM230
AM235 AM240 AM245 AM25.1 AM250 AM252
AM255 AM258 AM260 AM267 AM278 AM280
AM281 AM282 AM285 AM287 AM288 AM290
AM292 AM295 AM30.1 AM30.2 AM30.3 AM330
AM35.1 AM40.1 AM40.2 AM40.3 AM40.4 AM41.1
AM41.2 AM45.1 AM502 AM580 AM60.1 AM70.1
AM90.1 AM90.4 AM90.5 AM91.1 AM91.4 AM91.5
AM92.1 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 AM12.2
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 AM22.1 AM22.2 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 AP22.2 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
AP510 API1.1 API2.1 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CXCP.1 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 MA126 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIV-DIVISION
Element: Division
Alpha 15
A user-defined division which is used for reporting assets.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM08.1 AM08.2
AM115 AM117
AM12.1 AM12.2
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
AM22.1 AM22.2
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
AP22.2 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
DIV-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the division.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM08.1 AM08.2
AM115 AM117
AM12.1 AM12.2
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
AM22.1 AM22.2
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
AP22.2 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305


AMDIVISION FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DIVSET1 DIVISION
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM05.1 AM06.1
AM06.2 AM06.3
AM06.5 AM08.1
AM08.2 AM09.1
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM15.5
AM15.6 AM154
AM155 AM16.1


AMDIVISION FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Amdivisnau AMDIVISNAU
DIV-DIVISION->ADW-DIVISION
  ADW-ACTION
  ADW-DATE
  ADW-TIME
  ADW-UNIQUE-I-D


File created: Thu Jun 09 02:05:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.