ACDETAILAU

CA Alloc Code Detail Audit

REFERENCED BY
AC191 API1.1 API2.1 BR44.1 CB222 CA278
CA91.4 FB45.1 GL100 GL111 GL120 GL122
GL135 GL195 GL330 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 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


UPDATED BY
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 AP30.2 AP30.4 CA00.1 CA00.2
CA05.1 CA05.2 CA10.1 CA10.2 CA10.4 CA10.6
CA10.7 CA15.1 CA15.2 CA160 CA305 GL110
GL145 GL146 GL148 GL167 GL170 GL190
GL191 GL196 GL197 GL199 GL300 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL41.4
GL44.1 GL45.1 GL500 GL70.1 GL70.2 GL70.3
GL70.6 GL75.1 IFGT.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA61.1
MA70.1 MA75.1 MAI1.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALU-UNIQUE-I-D
Element: Unique I D		Bad Type 36
ALU-ALLOC-CODE
Element: Alloc Code		Alpha 12
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-COMPANY
Element: Company		Numeric 4
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-ACCT-UNIT
Element: Acct Unit		Alpha 15
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-ACTION
Element: Action		Alpha 1

A = Add
C = Change
D = Delete		 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-OPERATOR
Element: Operator		Alpha 10
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-DATE
Element: Date		Numeric 8 (yyyymmdd)
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-TIME
Element: Sys Time		Numeric 6 (hhmmss)
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-PROGRAM
Element: Program Code		Alpha 5
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-FIELD-NAME
Element: Field Name		Alpha 20 (Lower Case)
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-FIELD-ID
Element: Field Id		Numeric 3
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
ALU-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7


ACDETAILAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALUSET1 ALLOC-CODE
COMPANY
ACCT-UNIT
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 CA278
CA91.4 FB45.1
GL100 GL110
GL111 GL120
GL122 GL135
GL146 GL148
ALUSET2 ALLOC-CODE
ACTION
DATE
COMPANY
ACCT-UNIT
TIME
UNIQUE-I-D
ALUSET3 OPERATOR
ACTION
DATE
ALLOC-CODE
COMPANY
ACCT-UNIT
TIME
UNIQUE-I-D
ALUSET4 ACTION
DATE
ALLOC-CODE
COMPANY
ACCT-UNIT
TIME
UNIQUE-I-D
ALUSET5 DATE
ALLOC-CODE
ACTION
COMPANY
ACCT-UNIT
TIME
UNIQUE-I-D
CA305
ALUUID UNIQUE-I-D


ACDETAILAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acdetail ACDETAIL Required
ALU-ALLOC-CODE->ALD-ALLOC-CODE (ALDSET1)
ALU-COMPANY->ALD-COMPANY
ALU-ACCT-UNIT->ALD-ACCT-UNIT

File created: Thu Jun 09 02:13:34 2016

Home
Contact Us



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