 |
Lawson Insight Technical Documentation |
|
ACTRANS FILE
Activity Transaction
This file contains the detail records for transactions posted to activities
in the Activity Management system (status 9). It also contains unreleased
transactions created in Activity Management (status 0) and transactions
released from subsystems (status 1).
This file can be listed by running AC290 (Transaction Detail).
REFERENCED BY
AC00.1 AC10.1 AC112 AC12.1 AC256 AC50.1
ACAC.1 DA233 DA240 GR240 AC295 AC297
AC90.2 AC90.4 AC90.6 AC90.8 AC95.2 AC95.4
AC95.6 AC97.2 AC97.4 AC97.6 ACVW.1 SE90.1
BR450 AC06.1 AC240 AC96.1 AC96.2 BR10.1
DA290 ACDL.1 BR131 BR430 BRIP.1 AC290
AC440 AC460 AC471 AC490
UPDATED BY
AC120 AC131 AC160 AC170 AC190 AC191
AC192 AC195 AC196 AC198 AC300 AC310
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC45.1
AC45.4 AC530 AC540 AC542 AC581 ACDR.1
BR120 BR130 BR142 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR21.1 BR40.3 BR40.4 BR41.1
BR42.1 GL146 GL190 GL197 GL199 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATN-ACTIVITY-GRP Alpha 15 AC120 AC131
Activity Group Required key. This is the activity AC170 AC190
group for the transaction. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
IFGT.1
ATN-CONTROL-GROUP Numeric 8 AC131 AC310
Control Group Required key. This field indicates the AC40.1 AC40.4
control group number used for process AC41.1 AC41.4
control of the activity transactions. AC42.1 AC530
GL199 IFGT.1
ATN-SEQUENCE-NBR Numeric 4 AC131 AC310
Sequence Number Required key. This user-assigned AC40.1 AC40.4
sequence number is used to keep the AC41.1 AC41.4
records unique and to determine order. AC42.1 AC530
GL199 IFGT.1
ATN-OBJ-ID Numeric 12 AC131 AC170
Object Identifier Required key. This is the object AC190 AC196
identifier. It is used to relate AC198 AC310
commitments or posted transactions back AC40.1 AC40.4
to the originating subsystems. Each AC41.1 AC41.4
subsystem record that is updated as a AC42.1 AC530
commitment or posted transaction is AC540 AC542
assigned an object identifier. The BR20.1 BR20.2
object identifier is maintained in the BR20.3 BR20.4
subsystem files and in the Activity BR20.5 BR40.3
Commitments Detail and Activity BR40.4 BR41.1
Transaction files. The object identifier GL146 GL190
is a unique key generated by the system GL197 GL199
and used to drill back from Activity GL40.1 GL40.2
Management to the subsystems. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
ATN-TRANS-TYPE Alpha 1 AC131 AC170
Transaction Type This field determines if amounts or AC310 AC40.1
units are processed in the transaction. AC40.4 AC41.1
A = Activity Management Only AC41.4 AC42.1
B = AC side of AC and GL trans AC530 AC540
I = Interface AC542 IFGT.1
G = GL side of AC and GL trans
T = Time Entry
ATN-COMPANY Numeric 4 AC131 AC170
Company This is the responsible company. AC190 AC196
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR41.1 IFGT.1
ATN-FROM-COMPANY Numeric 4 AC131 AC190
From Company This is the company that is the source AC196 AC198
of the items. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
IFGT.1
ATN-TRAN-DATE Numeric 8 (yyyymmdd) AC131 AC190
Transaction Date This is the date the transaction is AC196 AC198
posted. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
GL199 IFGT.1
ATN-ACTIVITY Alpha 15 AC131 AC170
Activity This is the activity for the AC190 AC196
transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC530 AC540
AC542 BR40.3
BR41.1 IFGT.1
ATN-VAR-LEVELS Alpha 30 AC120 AC131
Variable Levels This is the variable level for the AC170 AC190
transaction. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR41.1 IFGT.1
ATN-STATUS Numeric 1 AC131 AC170
Status The transaction status tells whether AC190 AC196
the transaction is released (these are AC198 AC310
considered commitments), unreleased, or AC40.1 AC40.4
posted. AC41.1 AC41.4
0 = Unreleased AC42.1 AC45.1
1 = Released AC45.4 AC530
9 = Posted AC540 AC542
BR40.3 BR40.4
BR41.1 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
ATN-ACCT-CATEGORY Alpha 5 AC131 AC170
Account Category This is the account category for the AC190 AC196
transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC530 AC540
AC542 BR40.3
BR41.1 IFGT.1
ATN-POSTING-DATE Numeric 8 (yyyymmdd) AC131 AC170
Posting Date For an Activity Management transaction, AC190 AC195
this is the date the transaction was AC196 AC198
posted to the Activity Transaction file. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 GL199
IFGT.1
ATN-SYSTEM Alpha 2 AC131 AC170
System Code This is the system in which this AC190 AC196
transaction originated. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR41.1 IFGT.1
ATN-ACCT-UNIT Alpha 15 AC131 AC170
Accounting Unit This is the general ledger accounting AC190 AC196
unit for the transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR41.1 IFGT.1
ATN-ACCOUNT Numeric 6 AC131 AC170
Account This field along with the accounting AC190 AC196
unit and subaccount make up the location AC198 AC310
(account) where amounts and other AC40.1 AC40.4
account information is stored. AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR41.1 IFGT.1
ATN-SUB-ACCOUNT Numeric 4 AC131 AC190
Subaccount This is the general ledger subaccount AC196 AC198
for the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
IFGT.1
ATN-DESCRIPTION Alpha 30 (Lower Case) AC131 AC170
Transaction This is the description of the AC190 AC198
Description transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR41.1 IFGT.1
ATN-REFERENCE Alpha 10 (Lower Case) AC131 AC170
Reference This is the reference for this AC196 AC310
transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR40.3 BR40.4
BR41.1 IFGT.1
ATN-UNITS-AMOUNT Signed 15.2 AC131 AC170
Units Amount This is the units amount for this AC196 AC310
transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC530 AC540
AC542 BR40.3
BR40.4 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-TRAN-CURRENCY Alpha 5 AC131 AC190
Transaction Currency This is the currency for the AC196 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
IFGT.1
ATN-TRAN-AMOUNT Signed 15.2 AC131 AC170
Transaction Amount This is the amount in transaction AC190 AC196
currency. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-TRAN-ND Numeric 1 AC131 AC190
Transaction Number This field indicates the defined number AC196 AC198
of Decimals of decimal positions used for the AC310 AC40.1
transaction. AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
IFGT.1
ATN-ACT-CURRENCY Alpha 5 AC131 AC190
Activity Currency This is the activity currency. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR40.3
BR41.1 IFGT.1
ATN-ACT-BASERATE Signed 12.6 AC131 AC190
Activity Base Rate This is the rate that converts the AC196 AC198
transaction amount to the activity AC310 AC40.1
amount. AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
IFGT.1
ATN-ACT-AMOUNT Signed 15.2 AC131 AC190
Activity Amount This is the amount for the activity. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-ACT-ND Numeric 1 AC131 AC190
Activity Number of This is the number of decimals for the AC196 AC198
Decimals activity. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
IFGT.1
ATN-AG-CURRENCY Alpha 5 AC131 AC190
Activity Group This is the currency for the activity AC196 AC198
Currency group. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
IFGT.1
ATN-AG-BASERATE Signed 12.6 AC131 AC190
Activity Group Base This is the rate that converts the AC196 AC198
Rate transaction amount to the activity group AC310 AC40.1
amount. AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
IFGT.1
ATN-AG-AMOUNT Signed 15.2 AC131 AC190
Activity Group This is the amount for the activity AC196 AC198
Amount group for this transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-AG-ND Numeric 1 AC131 AC190
Activity Group Nbr This is the number of decimals for the AC196 AC198
of Decimals activity group. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
IFGT.1
ATN-BILL-DATE Numeric 8 (yyyymmdd) AC196 AC310
Billing Date This is the date the transaction was AC40.1 AC40.4
billed. AC41.1 AC41.4
AC42.1 BR120
BR40.3 GL199
ATN-RUN-DATE Numeric 8 (yyyymmdd) AC131 AC190
Run Date This is the date the transaction was AC198 AC310
posted to the general ledger. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC530 AC540
AC542 BR40.3
BR41.1 GL199
IFGT.1
ATN-RUN-TIME Numeric 6 (hhmmss) AC131 AC190
Run Time This is the time the transaction was AC198 AC310
posted to the general ledger. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC530 AC540
AC542 BR40.3
BR41.1 GL199
IFGT.1
ATN-SOURCE-CODE Alpha 2 AC131 AC170
Source Code This is the source code for the AC190 AC196
transaction. This value defaults from AC198 AC310
the program the user uses to enter a AC40.1 AC40.4
journal entry. This value is not AC41.1 AC41.4
necessarily the same as the system ID. AC42.1 AC530
AC540 AC542
BR40.3 BR40.4
BR41.1 IFGT.1
ATN-BILL-RATE Signed 13.4 AC131 AC170
Billing Rate This is the billing rate for the AC190 AC192
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 BR40.4
GL199
ATN-BILLABLE Alpha 1 AC131 AC190
Billable This field indicates whether the AC196 AC310
transaction is billable, on hold, a AC40.1 AC40.4
write-off, or a transfer. AC41.1 AC41.4
Y = Yes AC42.1 AC45.1
N = No BR142 BR40.3
H = Hold BR40.4 BR41.1
BR42.1 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLED Alpha 1 AC131 AC190
Billed This field indicates whether the AC196 AC310
transaction has been billed. AC40.1 AC40.4
Y = Yes AC41.1 AC41.4
N = No AC42.1 AC45.1
H = Hold BR120 BR142
E = Exceeded ceiling BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR21.1
BR41.1 BR42.1
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-BILLABLE-AMT Signed 15.2 AC131 AC190
Billable Amount This is the billable amount for the AC192 AC196
transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 AC542
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLABLE-UNIT Signed 15.2 AC131 AC190
Billable Units This is the number of billable units AC192 AC196
for the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
AC542 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-OVERRIDE-FLAG Alpha 1 AC190 AC198
Override Flag This field determines whether billing AC41.1 AC41.4
amounts are calculated or not. This flag AC42.1 AC540
is set to Yes if the billing amount or BR40.3 BR40.4
billing units values are defined for GL199
this transaction by the client versus
being calculated by the billing
programs. If this flag is Yes, the
billing amount and unit will not be
initialized if the transaction is backed
out.
The default is Blank, which also means
No.
Y = Yes - Bill amts overridden
N = No - Bill amts calculated
ATN-REVENUE-FLAG Alpha 1 AC131 AC190
Revenue Flag This flag indicates whether revenue has AC196 AC310
been recognized for the transaction. AC40.1 AC40.4
AC41.1 AC41.4
Valid values are AC42.1 AC45.1
BR130 BR142
Y = Yes BR41.1 BR42.1
N = No GL146 GL190
H = Hold GL197 GL199
E = Exceeded ceiling GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-CAPITALIZE-FLG Alpha 1 AC131 AC160
Capitalization Flag This flag indicates whether the AC190 AC196
transaction has been capitalized. AC198 AC310
AC40.1 AC40.4
Use Yes if the transaction has been AC41.1 AC41.4
capitalized. Use No if the transaction AC42.1 BR41.1
has not been capitalized. GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-MATRIX-CAT Alpha 12 AC131 AC190
Attribute Activity attributes can be assigned to AC192 AC196
transaction objects to define additional AC198 AC310
categories of information for reporting AC40.1 AC40.4
and processing. You can assign three AC41.1 AC41.4
user-defined attributes per source code. AC42.1 AC45.1
BR40.3 GL199
ATN-MX-VALUE Alpha 32 AC131 AC190
Attribute Value This is an attribute value assigned to AC192 AC196
a transaction to track additional AC198 AC310
information. Attribute values can then AC40.1 AC40.4
be used in selection and sorting for AC41.1 AC41.4
reporting and analysis. AC42.1 AC45.1
BR40.3 GL199
ATN-RESOURCE-TYPE Alpha 1 AC131 AC170
Resource Type This field indicates the type of the AC190 AC196
resource associated with the AC198 AC310
transaction. AC40.1 AC40.4
E = PR Employee AC41.1 AC41.4
V = AP/EE Vendor AC42.1 AC530
A = AM Asset AC540 AC542
P = Person BR40.3 GL199
Q = Equipment IFGT.1
ATN-RESOURCE-CODE Alpha 10 AC131 AC170
Resource Code This is the resource code associated AC190 AC196
with the transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR40.3 GL199
IFGT.1
ATN-RESOURCE-DESC Alpha 30 (Lower Case) AC170 AC190
Resource Desc AC191 AC196
AC198 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 AC542
BR40.3 GL199
IFGT.1
ATN-UNIT-MEASURE Alpha 12 AC131 AC170
Unit of Measure This is the unit of measure for the AC196 AC310
transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
AC542 BR40.3
GL199
ATN-GLT-OBJ-ID Numeric 12 GL199 IFGT.1
Subsystem GL This is a subsystem-General Ledger
Interface ID interface identification number. It is
used for Drill Around purposes.
ATN-PERIOD Numeric 2 AC131 AC190
Period This is the period for the transaction. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
ACDR.1 GL199
IFGT.1
ATN-FISCAL-YEAR Numeric 4 AC131 AC190
Year This is the fiscal year for the AC196 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
ACDR.1 GL199
IFGT.1
ATN-AC191-UPDATED.html">AC191-UPDATED Alpha 1 AC190 AC191
AC191 Updated This field indicates whether the AC196 AC198
transaction has been updated to the AC310 AC40.1
Activity GL Accounting Unit Master AC40.4 AC41.1
header and detail files. If the AC41.4 AC42.1
transaction has been added, this value AC45.1 BR41.1
is Yes. If the transaction has not been GL199
added, this value is No.
Y = Yes
ATN-RECONCILED Alpha 1 AC190 AC196
Reconciled This flag is set to Yes when the AC198 AC40.1
payroll transaction has been reconciled AC40.4 AC41.1
by AC196 (Activity Payroll AC41.4 AC42.1
Reconciliation). Before the transaction BR41.1 GL199
is reconciled, the value in this field
is No.
Y = Yes
N = No
ATN-SEGMENT-FLAG Alpha 1 AC190 AC198
Segment Flag Y = Yes AC40.1 AC40.4
N = No AC41.1 AC41.4
AC42.1 GL199
ATN-RPT-AMOUNT-1 Signed 15.2 AC131 AC190
Report Currency 1 The transaction amount for Report AC196 AC198
Amount Currency 1. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-RPT-RATE-1 Signed 12.6 AC131 AC190
Rpt Rate 1 The exchange rate to convert the AC196 AC198
transaction amount to Report Currency 1. AC40.1 AC40.4
The exchange rate is defined in CU10.1 AC41.1 AC41.4
(Exchange Rate). AC42.1 AC530
AC540 AC542
AC581 BR41.1
IFGT.1
ATN-RPT-ND-1 Numeric 1 AC131 AC190
Rpt Nd 1 The number of decimal positions for AC196 AC198
Report Currency 1. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR41.1
IFGT.1
ATN-RPT-AMOUNT-2 Signed 15.2 AC131 AC190
Report Currency 2 The transaction amount for Report AC196 AC198
Amount Currency 2. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-RPT-RATE-2 Signed 12.6 AC131 AC190
Rpt Rate 2 The exchange rate to convert the AC196 AC198
transaction amount to Report Currency 2. AC40.1 AC40.4
The exchange rate is defined in CU10.1 AC41.1 AC41.4
(Exchange Rate). AC42.1 AC530
AC540 AC542
AC581 BR41.1
IFGT.1
ATN-RPT-ND-2 Numeric 1 AC131 AC190
Rpt Nd 2 The number of decimal positions for AC196 AC198
Report Currency 2. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR41.1
IFGT.1
ATN-BRDN-ORG-OBJID Numeric 12 AC190 AC198
Brdn Org Objid
ATN-ORIG-OBJ-ID Numeric 12 AC542
Orig Obj Id
ATN-BILLED-AMT Signed 15.2 GL146 GL190
Billed Amt GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-REVENUE-AMT Signed 15.2 AC190 AC192
Revenue Amt AC198 AC45.1
AC540 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
GL146 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-EXPENSE-CODE Alpha 20 AC542
Expense Code
ATN-REBILL-AMT Signed 15.2 GL146 GL190
Rebill Amt GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-REASON-CODE Alpha 4 BR40.3 BR40.4
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
ATN-COMMENT-CD Numeric 3 GL199
Comment Code This is the number representing a
comment relating to the transaction.
ACTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATNSET1 ACTIVITY-GRP AC00.1 AC10.1
ACTIVITY AC112 AC12.1
ACCT-CATEGORY AC120 AC160
COMPANY AC170 AC192
ACCT-UNIT AC195 AC196
ACCOUNT AC256 AC300
SUB-ACCOUNT AC310 AC45.1
OBJ-ID AC50.1 AC581
ACAC.1 DA233
DA240 GR240
ATNSET10 ACTIVITY-GRP KeyChange, Subset AC295 AC297
VAR-LEVELS Where (STATUS != Zeroes ) AC90.2 AC90.4
STATUS AC90.6 AC90.8
ACCT-CATEGORY AC95.2 AC95.4
FISCAL-YEAR AC95.6 AC97.2
PERIOD AC97.4 AC97.6
OBJ-ID ACVW.1 SE90.1
ATNSET11 ACCT-CATEGORY KeyChange, Subset
OBJ-ID Where (STATUS = 1 )
ATNSET12 OBJ-ID AC170 AC190
AC192 AC198
AC45.1 AC542
ACDR.1 BR130
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR21.1
BR41.1 BR450
ATNSET13 ACTIVITY KeyChange AC06.1 AC10.1
ACCT-CATEGORY AC196 AC240
POSTING-DATE AC256 AC50.1
SYSTEM AC96.1 AC96.2
SOURCE-CODE BR10.1
OBJ-ID
ATNSET14 GLT-OBJ-ID KeyChange DA290 GL146
OBJ-ID GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATNSET3 ACTIVITY-GRP KeyChange, Subset AC190 AC196
ACTIVITY Where (STATUS = 1 ) AC45.1 AC530
ACCT-CATEGORY ACDL.1 BR130
POSTING-DATE BR131 BR20.1
OBJ-ID BR20.2 BR20.3
BR20.4 BR20.5
BR430 BRIP.1
ATNSET4 ACTIVITY KeyChange, Subset AC10.1 AC112
ACCT-CATEGORY Where (STATUS = 9 ) AC12.1 AC191
FISCAL-YEAR AC196 AC290
PERIOD AC310 AC440
OBJ-ID AC460 AC471
AC490 AC50.1
ACDR.1 BR142
BR40.1 BR40.3
BR40.4 BR42.1
BR430 BR450
ATNSET7 CONTROL-GROUP KeyChange, Subset AC240 AC40.1
SEQUENCE-NBR Where (STATUS = Zeroes ) AC40.3 AC40.4
TRAN-CURRENCY AC40.6 AC41.1
OBJ-ID AC41.3 AC41.4
ACTIVITY-GRP AC41.6 AC42.1
AC45.4
ATNSET8 ACTIVITY KeyChange, Subset BR120 BR130
ACCT-CATEGORY Where((BILLABLE = "Y" )
TRAN-CURRENCY Or (BILLABLE = "H" ))
UNIT-MEASURE And ((REVENUE-FLAG != "Y" )
MATRIX-CAT Or (BILLED != "Y" ))
MX-VALUE
POSTING-DATE
OBJ-ID
ATNSET9 OBJ-ID KeyChange AC256 AC40.1
ACTIVITY-GRP AC40.4 AC41.1
ACTIVITY AC41.4 AC42.1
CONTROL-GROUP BR120 IFGT.1
SEQUENCE-NBR
ACTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
ATN-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acacctcat Err ACACCTCAT Not Required
ATN-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acacctcatx ACACCTCATX Not Required
ATN-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
ATN-ACTIVITY -> AXX-ACTIVITY
ATN-ACCT-CATEGORY -> AXX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
ATN-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
ATN-ACTIVITY -> ACV-ACTIVITY
Acassign ACASSIGN Not Required
ATN-ACTIVITY-GRP -> AAN-ACTIVITY-GRP
ATN-ACTIVITY -> AAN-ACTIVITY
ATN-RESOURCE-TYPE -> AAN-RESOURCE-TYPE
ATN-RESOURCE-CODE -> AAN-RESOURCE-CODE
Accuamt ACCUAMT Not Required
Valid When ATN-CURRENCY-CODE != ATN-CURRENCY-CODE
ATN-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
ATN-ACTIVITY -> ACU-ACTIVITY
ATN-ACT-CURRENCY -> ACU-CURRENCY-CODE
Zeroes -> ACU-BUDGET-NBR
ATN-FISCAL-YEAR -> ACU-FISCAL-YEAR
ATN-ACCT-CATEGORY -> ACU-ACCT-CATEGORY
Accuamtx ACCUAMTX Not Required
Valid When ATN-CURRENCY-CODE != ATN-CURRENCY-CODE
ATN-ACTIVITY-GRP -> ACX-ACTIVITY-GRP
ATN-ACTIVITY -> ACX-ACTIVITY
ATN-ACT-CURRENCY -> ACX-CURRENCY-CODE
Zeroes -> ACX-BUDGET-NBR
ATN-FISCAL-YEAR -> ACX-FISCAL-YEAR
ATN-ACCT-CATEGORY -> ACX-ACCT-CATEGORY
ATN-PERIOD -> ACX-PERIOD
Acglmastx ACGLMASTX Required
ATN-ACTIVITY-GRP -> GMX-ACTIVITY-GRP
ATN-ACTIVITY -> GMX-ACTIVITY
ATN-ACCT-CATEGORY -> GMX-ACCT-CATEGORY
ATN-COMPANY -> GMX-COMPANY
ATN-ACCT-UNIT -> GMX-ACCT-UNIT
ATN-FISCAL-YEAR -> GMX-FISCAL-YEAR
ATN-PERIOD -> GMX-PERIOD
ATN-RESOURCE-TYPE -> GMX-RESOURCE-TYPE
ATN-RESOURCE-CODE -> GMX-RESOURCE-CODE
Aclevel ACLEVEL Required
ATN-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ATN-VAR-LEVELS -> LVL-VAR-LEVELS
Acmaster ACMASTER Not Required
ATN-ACTIVITY-GRP -> MST-ACTIVITY-GRP
ATN-ACTIVITY -> MST-ACTIVITY
ATN-ACCT-CATEGORY -> MST-ACCT-CATEGORY
ATN-FISCAL-YEAR -> MST-FISCAL-YEAR
Acmasterx ACMASTERX Not Required
ATN-ACTIVITY-GRP -> MSX-ACTIVITY-GRP
ATN-ACTIVITY -> MSX-ACTIVITY
ATN-ACCT-CATEGORY -> MSX-ACCT-CATEGORY
ATN-FISCAL-YEAR -> MSX-FISCAL-YEAR
ATN-PERIOD -> MSX-PERIOD
Actranseg ACTRANSEG Not Required
ATN-OBJ-ID -> TSG-OBJ-ID
Actranserr ACTRANSERR Required
ATN-OBJ-ID -> TER-OBJ-ID
Amasset AMASSET Not Required
Valid When ATN-RESOURCE-TYPE = "A"
AAN-EMPLOYEE-ASSET -> AST-ASSET
Employee EMPLOYEE Not Required
Valid When ATN-RESOURCE-TYPE = "E"
ATN-FROM-COMPANY -> EMP-COMPANY
AAN-EMPLOYEE-ASSET -> EMP-EMPLOYEE
Glnames GLNAMES Required
ATN-FROM-COMPANY -> GLN-COMPANY
ATN-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ATN-COMPANY -> GLS-COMPANY
Gltrans GLTRANS Not Required
ATN-GLT-OBJ-ID -> GLT-OBJ-ID
Oeinvcline OEINVCLINE Not Required
ATN-OBJ-ID -> OIL-ATN-OBJ-ID
ACTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acblactv ACBLACTV
ATN-ACTIVITY -> BLA-ACTIVITY
ATN-ACCT-CATEGORY -> BLA-ACCT-CATEGORY
Spaces -> BLA-ACCT-CAT-CLASS
BLA-BILL-ACTIVITY
Acblactv Class ACBLACTV
ATN-ACTIVITY -> BLA-ACTIVITY
Spaces -> BLA-ACCT-CATEGORY
AXX-ACCT-CAT-CLASS -> BLA-ACCT-CAT-CLASS
BLA-BILL-ACTIVITY
Acbrdnadtr ACBRDNADTR
ATN-OBJ-ID -> BAT-ATN-OBJ-ID
BAT-BURDEN-CD
BAT-BURDEN-TYPE
BAT-POOL-NBR
Acclgtrans ACCLGTRANS
ATN-OBJ-ID -> CGT-OBJ-ID
CGT-CONT-ACTIVITY
CGT-BILL-ACTIVITY
CGT-ACCT-CATEGORY
CGT-ACCT-CAT-CLASS
CGT-MATRIX-CAT
CGT-MX-VALUE
Achistdtl ACHISTDTL
ATN-OBJ-ID -> HDT-ATN-OBJ-ID
HDT-CONTRACT
HDT-COMPANY
HDT-CUSTOMER
HDT-AC-CUSTOMER-ID
HDT-INVOICE-PREFIX
HDT-INVOICE-NBR
HDT-LINE-NBR
HDT-SEQ-NBR
Acmxval ACMXVAL
ATN-OBJ-ID -> ATV-OBJ-ID
ATV-MATRIX-CAT
Amtrans AMTRANS
ATN-OBJ-ID -> AMT-ATN-OBJ-ID
AMT-ASSET
AMT-SEQ-NUMBER
AMT-COMPANY
Apapdhist APAPDHIST
ATN-OBJ-ID -> AH2-ATN-OBJ-ID
AH2-COMPANY
AH2-VENDOR
AH2-INVOICE
AH2-SUFFIX
AH2-CANCEL-SEQ
AH2-DIST-SEQ-NBR
Apdistrib APDISTRIB
ATN-OBJ-ID -> APD-ATN-OBJ-ID
APD-COMPANY
APD-VENDOR
APD-INVOICE
APD-SUFFIX
APD-CANCEL-SEQ
APD-DIST-SEQ-NBR
Ardistrib ARDISTRIB
ATN-OBJ-ID -> AMD-ATN-OBJ-ID
AMD-GL-COMPANY
AMD-ACCT-UNIT
AMD-ACCOUNT
AMD-SUB-ACCT
AMD-GL-DATE
AMD-CREATE-DATE
AMD-CREATE-TIME
AMD-PROG-SEQ-NBR
Cbdistrib CBDISTRIB
ATN-OBJ-ID -> CBD-ACT-OBJ-ID
CBD-CASH-CODE
CBD-BANK-INST-CODE
CBD-TRANS-IDENT
CBD-DIST-TYPE
CBD-SEQ-NBR
Eedistrib EEDISTRIB
ATN-OBJ-ID -> EED-ACT-OBJ-ID
EED-COMPANY
EED-VENDOR
EED-EXPENSE-NBR
EED-SEQ-NBR
Icmmdist MMDIST
Valid When ATN-SYSTEM = "IC"
ATN-OBJ-ID -> MMD-ATN-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Mmdist MMDIST
ATN-OBJ-ID -> MMD-ATN-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Pbdistrib PBDISTRIB
ATN-COMPANY -> PDB-COMPANY
ATN-ACTIVITY -> PDB-ACTIVITY
ATN-OBJ-ID -> PDB-ATN-OBJ-ID
PDB-EMPLOYEE
PDB-OBJ-ID
Pommdist MMDIST
Valid When ATN-SYSTEM = "PO"
ATN-OBJ-ID -> MMD-ATN-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Prdistrib PRDISTRIB
ATN-FROM-COMPANY -> PRD-COMPANY
ATN-ACTIVITY -> PRD-ACTIVITY
ATN-OBJ-ID -> PRD-ATN-OBJ-ID
PRD-EMPLOYEE
PRD-OBJ-ID
Sltrans SLTRANS
ATN-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|