AMDIVISNAU

AM Division Audit

REFERENCED BY
AC191 AM288 AM82.6 BR44.1 CB222 FB45.1
GL100 GL110 GL111 GL120 GL122 GL135
GL146 GL148 GL167 GL190 GL195 GL196
GL197 GL199 GL330 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL500 IC222
CU00.1 CU01.1 CU01.2 CU02.1 CU02.2 CU03.1
CU10.1 CU10.2 CU20.1 CU20.2 CU20.3 GL00.2
GL00.3 GL00.6 GL00.7 GL00.9 GL02.1 GL02.2
GL02.3 GL02.6 GL03.6 GL10.1 GL10.2 GL121
GL124 GL125 GL160 GL161 GL20.1 GL20.2
GL20.4 IFAC.1 ML146 ML167 ML190 ML195
ML196 ML199 ML330 ML40.1 ML40.2 ML40.3
ML40.7 ML40.8 ML44.1 ML45.1


UPDATED BY
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 AM154 AM155 AM16.1 AM17.1 AM170
AM180 AM19.1 AM19.2 AM190 AM192 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 AM230 AM282 AM30.1 AM30.2 AM30.3
AM305 AM40.1 AM40.2 AM40.3 AM40.4 AM41.1
AM41.2 AM500 AM502 AM551 AM88.7 AM92.1
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
ADW-UNIQUE-I-D
Element: Unique I D
Bad Type 36
ADW-DIVISION
Element: Division
Alpha 15
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-ACTION
Element: Action
Alpha 1
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-OPERATOR
Element: Operator
Alpha 10
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-TIME
Element: Sys Time
Numeric 6 (hhmmss)
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-PROGRAM
Element: Program Code
Alpha 5
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-FIELD-NAME
Element: Field Name
Alpha 20 (Lower Case)
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-FIELD-ID
Element: Field Id
Numeric 3
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-OLD-VALUE
Element: Account Desc
Alpha 60 (Lower Case)
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
ADW-NEW-VALUE
Element: Account Desc
Alpha 60 (Lower Case)
...
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 AM154
AM155 AM16.1
AM17.1 AM170
AM180 AM19.1
AM19.2 AM190
AM192 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 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2


AMDIVISNAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADWSET1 DIVISION
ACTION
DATE
TIME
UNIQUE-I-D
...
AC191 AM288
AM82.6 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 FB45.1
GL100 GL110
GL111 GL120
GL122 GL135
GL146 GL148
ADWSET2 OPERATOR
ACTION
DATE
DIVISION
UNIQUE-I-D
ADWSET3 ACTION
DATE
DIVISION
UNIQUE-I-D
ADWSET4 DATE
ACTION
DIVISION
UNIQUE-I-D
AM288 AM305
ADWUID UNIQUE-I-D


AMDIVISNAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amdivision AMDIVISION Required
ADW-DIVISION->DIV-DIVISION (DIVSET1)


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

Home
Contact Us



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