AMSYSOPTAU

REFERENCED BY
AC191 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 GL167 GL190
GL195 GL196 GL197 GL199 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL500 DR100 IC141 IC142 IC222 IC83.1
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 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA44.1 MA44.2 MA61.1 MAI1.1
ML146 ML167 ML190 ML195 ML196 ML199
ML330 ML40.1 ML40.2 ML40.3 ML40.7 ML40.8
ML44.1 ML45.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
AOA-COMPANY
Element: Company		Numeric 4
AOA-CREATION-DATE
Element: Creation Date		Numeric 8 (yyyymmdd)
AOA-CREATION-TIME
Element: Creation Time		Numeric 6 (hhmmss)
AOA-ACTION
Element: Action		Alpha 1
AOA-OPERATOR
Element: Operator		Alpha 10
AOA-DATE
Element: Date		Numeric 8 (yyyymmdd)
AOA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
AOA-PROGRAM
Element: Program Code		Alpha 5
AOA-FIELD-NAME
Element: Field Name		Alpha 20 (Lower Case)
AOA-FIELD-ID
Element: Field Id		Numeric 3
AOA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
AOA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)


AMSYSOPTAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOASET1 COMPANY
CREATION-DATE
CREATION-TIME
ACTION
DATE
TIME
UNIQUE-I-D
...
AC191 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
GL167 GL190
AOASET2 COMPANY
ACTION
DATE
TIME
UNIQUE-I-D
AOASET3 OPERATOR
ACTION
DATE
COMPANY
UNIQUE-I-D
AOASET4 ACTION
DATE
COMPANY
UNIQUE-I-D
AOASET5 DATE
ACTION
COMPANY
UNIQUE-I-D
AOAUID UNIQUE-I-D


AMSYSOPTAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Amsysopts AMSYSOPTS Required
AOA-COMPANY->AMO-COMPANY (AMOSET1)
AOA-CREATION-DATE->AMO-CREATION-DATE
AOA-CREATION-TIME->AMO-CREATION-TIME

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

Home
Contact Us



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