 |
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
AC720 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
AC61.1 AC96.1 AC96.2 BR10.1 ACAC.1 ACDL.1
BR430 BRIP.1 AC290 AC440 AC460 AC471
AC490
UPDATED BY
AC120 AC131 AC160 AC170 AC190 AC191
AC195 AC196 AC198 AC300 AC310 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC45.1 AC45.4
AC530 AC540 AC542 AC581 AC742 ACDR.1
GR742 BR120 BR142 BR21.1 BR40.3 BR40.4
BR41.1 BR42.1 GL146 GL190 GL199 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
AC742 BR40.3
BR41.1 GL199
GR742 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 AC742 BR40.3
object identifier is maintained in the BR40.4 BR41.1
subsystem files and in the Activity GL146 GL190
Commitments Detail and Activity GL199 GL45.1
Transaction files. The object identifier GR742 IFGT.1
is a unique key generated by the system
and used to drill back from Activity
Management to the subsystems.
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 AC742
G = GL side of AC and GL trans GL199 GR742
T = Time Entry IFGT.1
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
AC742 BR41.1
GL199 GR742
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 AC742
BR41.1 GL199
GR742 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 AC742
BR41.1 GL199
GR742 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 AC742
BR40.3 BR41.1
GL199 GR742
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
AC742 BR41.1
GL199 GR742
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
AC742 BR40.3
BR40.4 BR41.1
GL146 GL190
GL199 GL45.1
GR742 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 AC742
BR40.3 BR41.1
GL199 GR742
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 AC742
GL199 GR742
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
AC742 BR41.1
GL199 GR742
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
AC742 BR41.1
GL199 GR742
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
AC742 BR41.1
GL199 GR742
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 AC742
BR41.1 GL199
GR742 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
AC742 BR41.1
GL199 GR742
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
AC742 BR40.3
BR40.4 BR41.1
GL199 GR742
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 AC742
BR40.3 BR40.4
GL199 GL45.1
GR742 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 AC742
BR41.1 GL199
GR742 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
AC742 BR40.3
BR40.4 BR41.1
GL199 GL45.1
GR742 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 AC742
BR41.1 GL199
GR742 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 AC742
BR40.3 BR41.1
GL199 GR742
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
AC742 BR40.3
BR41.1 GL199
GR742 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
AC742 BR40.3
BR40.4 BR41.1
GL199 GL45.1
GR742 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
AC742 BR40.3
BR41.1 GL199
GR742 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
AC742 BR40.3
BR41.1 GL199
GR742 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
AC742 BR40.3
BR41.1 GL199
GR742 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
AC742 BR40.3
BR40.4 BR41.1
GL199 GL45.1
GR742 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
AC742 BR40.3
BR41.1 GL199
GR742 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 AC742
BR40.3 BR41.1
GL199 GR742
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 AC742
BR40.3 BR41.1
GL199 GR742
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
AC742 BR40.3
BR40.4 BR41.1
GL199 GR742
IFGT.1
ATN-BILL-RATE Signed 13.4 AC131 AC170
Billing Rate This is the billing rate for the AC190 AC310
transaction. 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 AC198
transaction is billable, on hold, a AC310 AC40.1
write-off, or a transfer. AC40.4 AC41.1
Y = Yes AC41.4 AC42.1
N = No AC45.1 BR142
H = Hold BR40.3 BR40.4
BR41.1 BR42.1
GL199
ATN-BILLED Alpha 1 AC131 AC190
Billed This field indicates whether the AC196 AC198
transaction has been billed. AC310 AC40.1
Y = Yes AC40.4 AC41.1
N = No AC41.4 AC42.1
H = Hold BR120 BR142
E = Exceeded ceiling BR21.1 BR41.1
BR42.1 GL199
ATN-BILLABLE-AMT Signed 15.2 AC131 AC190
Billable Amount This is the billable amount for the AC196 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
AC542 AC742
BR40.4 GL146
GL190 GL199
GL45.1 GR742
ATN-BILLABLE-UNIT Signed 15.2 AC131 AC190
Billable Units This is the number of billable units AC196 AC310
for the transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 AC542
AC742 GL146
GL190 GL199
GL45.1 GR742
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 AC742 GL199
billing units values are defined for GR742
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 AC198
been recognized for the transaction. AC310 AC40.1
AC40.4 AC41.1
Valid values are AC41.4 AC42.1
BR142 BR41.1
Y = Yes BR42.1 GL199
N = No
H = Hold
E = Exceeded ceiling
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. GL199
ATN-MATRIX-CAT Alpha 12 AC131 AC190
Attribute Activity attributes can be assigned to AC196 AC198
transaction objects to define additional AC310 AC40.1
categories of information for reporting AC40.4 AC41.1
and processing. You can assign three AC41.4 AC42.1
user-defined attributes per source code. AC45.1 BR40.3
GL199
ATN-MX-VALUE Alpha 32 AC131 AC190
Attribute Value This is an attribute value assigned to AC196 AC198
a transaction to track additional AC310 AC40.1
information. Attribute values can then AC40.4 AC41.1
be used in selection and sorting for AC41.4 AC42.1
reporting and analysis. 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 AC742 BR40.3
Q = Equipment GL199 GR742
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
AC742 BR40.3
GL199 GR742
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
AC742 BR40.3
GL199 GR742
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 AC742
BR40.3 GL199
GR742
ATN-COMMENT-CD Numeric 3 GL199
Comment Code This is the number representing a
comment relating to the transaction.
ATN-GLT-OBJ-ID Numeric 12 AC190 GL199
Subsystem GL This is a subsystem-General Ledger IFGT.1
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
AC742 ACDR.1
GL199 GR742
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
AC742 ACDR.1
GL199 GR742
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 AC40.1 AC40.4
Activity GL Accounting Unit Master AC41.1 AC41.4
header and detail files. If the AC42.1 BR41.1
transaction has been added, this value GL199
is Yes. If the transaction has not been
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 AC742
BR41.1 GL199
GR742 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 AC742
BR41.1 GL199
GR742 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 AC742
BR41.1 GL199
GR742 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 AC742
BR41.1 GL199
GR742 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 AC742
BR41.1 GL199
GR742 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 AC742
BR41.1 GL199
GR742 IFGT.1
ATN-BRDN-ORG-OBJID Numeric 12 AC190
Brdn Org Objid
ATN-ORIG-OBJ-ID Numeric 12 AC542 AC742
Orig Obj Id GR742
ATN-BILLED-AMT Signed 15.2
Billed Amt
ATN-REVENUE-AMT Signed 15.2 AC190 AC198
Revenue Amt AC540
ATN-EXPENSE-CODE Alpha 20 AC542
Expense Code
ATN-REBILL-AMT Signed 15.2
Rebill Amt
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 AC190
ACCT-UNIT AC191 AC195
ACCOUNT AC196 AC256
SUB-ACCOUNT AC300 AC310
OBJ-ID AC45.1 AC50.1
AC581 AC720
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 AC198
AC542 AC742
GR742 BR21.1
BR41.1 BR450
ATNSET13 ACTIVITY KeyChange AC06.1 AC10.1
ACCT-CATEGORY AC196 AC240
POSTING-DATE AC256 AC50.1
SYSTEM AC61.1 AC96.1
SOURCE-CODE AC96.2 BR10.1
OBJ-ID
ATNSET14 GLT-OBJ-ID KeyChange GL146 GL190
OBJ-ID GL45.1
ATNSET3 ACTIVITY-GRP KeyChange, Subset AC190 AC196
ACTIVITY Where (STATUS = 1 ) AC45.1 AC530
ACCT-CATEGORY ACAC.1 ACDL.1
POSTING-DATE BR430 BRIP.1
OBJ-ID
ATNSET4 ACTIVITY KeyChange, Subset AC196 AC290
ACCT-CATEGORY Where (STATUS = 9 ) AC310 AC440
FISCAL-YEAR AC460 AC471
PERIOD AC490 ACDR.1
OBJ-ID 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
ACCT-CATEGORY Where((BILLABLE = "Y" )
TRAN-CURRENCY Or (BILLABLE = "H" ))
UNIT-MEASURE
MATRIX-CAT
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
Oeinvcmisc OEINVCMISC Not Required
ATN-OBJ-ID -> OIM-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
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
Oedist OEDIST
ATN-OBJ-ID -> ODI-ATN-OBJ-ID
ODI-INVC-PREFIX
ODI-INVC-NUMBER
ODI-AUTH-NO
ODI-LINE-NBR
ODI-SEQ
ODI-POSTING-TYPE
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
|