Lawson Insight Technical Documentation |
|
ACTRANS
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 AC06.1 AC10.1 AC112 AC12.1 AC256
AC50.1 BR131 BR153 BR430 BRIP.1 BRPI.1
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 BR253 BR450 BR52.3 BR53.1
AC240 AC96.1 AC96.2 BR10.1 ACAC.1 ACDL.1
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
AP520 CB10.1 CB191 CB20.1 CB30.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL165 GL170
GL75.1 MA65.1 POIG.1 AC290 AC440 AC460
AC471 AC490
UPDATED BY
AC120 AC131 AC160 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
BR122 BR130 BR142 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR40.3 BR40.4 BR41.1 BR41.4
BR42.1 BR43.1 BR521 BR530 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
Element: Activity GroupRequired key. This is the activity AC190 AC196
group for the transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC530 AC540
AC542 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 IFGT.1
ATN-CONTROL-GROUP Numeric 8 AC131 AC310
Element: 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
BR41.1 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-SEQUENCE-NBR Numeric 4 AC131 AC310
Element: Sequence NumbeRequired 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
BR41.1 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-OBJ-ID Numeric 12 AC131 AC190
Element: Object IdentifRequired key. This is the object AC196 AC198
identifier. It is used to relate AC310 AC40.1
commitments or posted transactions back AC40.4 AC41.1
to the originating subsystems. Each AC41.4 AC42.1
subsystem record that is updated as a AC530 AC540
commitment or posted transaction is AC542 BR20.1
assigned an object identifier. The BR20.2 BR20.3
object identifier is maintained in the BR20.4 BR20.5
subsystem files and in the Activity BR40.3 BR40.4
Commitments Detail and Activity BR41.1 BR41.4
Transaction files. The object identifier BR43.1 BR521
is a unique key generated by the system BR530 GL146
and used to drill back from Activity GL190 GL197
Management to the subsystems. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
ATN-TRANS-TYPE Alpha 1 AC131 AC310
Element: Transaction TyThis field determines if amounts or AC40.1 AC40.4
units are processed in the transaction. AC41.1 AC41.4
A = Activity Management Only AC42.1 AC530
B = AC side of AC and GL trans AC540 AC542
I = Interface BR41.1 BR41.4
G = GL side of AC and GL trans BR43.1 BR521
T = Time Entry BR530 IFGT.1
ATN-COMPANY Numeric 4 AC131 AC190
Element: Company This is the responsible company. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-FROM-COMPANY Numeric 4 AC131 AC190
Element: From Company AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-TRAN-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: Transaction DaThis 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
BR41.4 BR43.1
BR521 BR530
GL199 IFGT.1
ATN-ACTIVITY Alpha 15 AC131 AC190
Element: Activity This is the activity for the AC196 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-VAR-LEVELS Alpha 30 AC120 AC131
Element: Variable LevelThis is the variable level 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 BR41.4
BR43.1 BR521
BR530 IFGT.1
ATN-STATUS Numeric 1 AC131 AC190
Element: Status The transaction status tells whether AC196 AC198
the transaction is released (these are AC310 AC40.1
considered commitments), unreleased, or AC40.4 AC41.1
posted. AC41.4 AC42.1
0 = Unreleased AC45.1 AC45.4
1 = Released AC530 AC540
9 = Posted AC542 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR521 BR530
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 AC190
Element: Account CategoThis is the account category for the AC196 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC530
AC540 AC542
BR40.3 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-POSTING-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: Posting Date For an Activity Management transaction, AC195 AC196
this is the date the transaction was AC198 AC310
posted to the Activity Transaction file. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
BR41.1 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-SYSTEM Alpha 2 AC131 AC190
Element: System Code This is the system in which this AC196 AC198
transaction originated. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-ACCT-UNIT Alpha 15 AC131 AC190
Element: Accounting UniThis is the general ledger accounting AC196 AC198
unit for the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-ACCOUNT Numeric 6 AC131 AC190
Element: Account This field along with the accounting AC196 AC198
unit and subaccount make up the location AC310 AC40.1
(account) where amounts and other AC40.4 AC41.1
account information is stored. AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-SUB-ACCOUNT Numeric 4 AC131 AC190
Element: 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
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-DESCRIPTION Alpha 30 (Lower Case) AC131 AC190
Transaction This is the description of the AC198 AC310
Description transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-REFERENCE Alpha 10 (Lower Case) AC131 AC196
Element: Reference This is the reference for this AC310 AC40.1
transaction. AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-UNITS-AMOUNT Signed 15.2 AC131 AC196
Element: Units Amount This is the units amount for this AC310 AC40.1
transaction. 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 BR521
BR530 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-TRAN-CURRENCY Alpha 5 AC131 AC190
Element: Transaction CuThis is the currency for the AC196 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-TRAN-AMOUNT Signed 15.2 AC131 AC190
Element: Transaction AmThis is the amount in transaction AC196 AC198
currency. 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 BR41.4
BR43.1 BR521
BR530 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
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-ACT-CURRENCY Alpha 5 AC131 AC190
Element: Activity CurreThis is the activity currency. AC196 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 IFGT.1
ATN-ACT-BASERATE Signed 12.6 AC131 AC190
Element: Activity Base 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
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-ACT-AMOUNT Signed 15.2 AC131 AC190
Element: Activity AmounThis 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
BR41.4 BR43.1
BR521 BR530
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
BR41.4 BR43.1
BR521 BR530
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
BR41.4 BR43.1
BR521 BR530
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
BR41.4 BR43.1
BR521 BR530
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
BR41.4 BR43.1
BR521 BR530
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
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-BILL-DATE Numeric 8 (yyyymmdd) AC196 AC310
Element: Billing Date This is the date the transaction was AC40.1 AC40.4
billed. AC41.1 AC41.4
AC42.1 BR120
BR122 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 GL199
ATN-RUN-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: 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 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-RUN-TIME Numeric 6 (hhmmss) AC131 AC190
Element: 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 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-SOURCE-CODE Alpha 2 AC131 AC190
Element: Source Code This is the source code for the AC196 AC198
transaction. This value defaults from AC310 AC40.1
the program the user uses to enter a AC40.4 AC41.1
journal entry. This value is not AC41.4 AC42.1
necessarily the same as the system ID. AC530 AC540
AC542 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR521 BR530
IFGT.1
ATN-BILL-RATE Signed 13.4 AC131 AC190
Element: Billing Rate This is the billing rate for the AC192 AC310
transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR40.4 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199
ATN-BILLABLE Alpha 1 AC131 AC190
Element: Billable This field indicates whether the AC192 AC196
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 BR41.4
BR42.1 BR43.1
BR521 BR530
GL199
ATN-BILLED Alpha 1 AC131 AC190
Element: Billed This field indicates whether the AC192 AC196
transaction has been billed. AC310 AC40.1
Y = Yes AC40.4 AC41.1
N = No AC41.4 AC42.1
H = Hold AC45.1 BR120
E = Exceeded ceiling BR122 BR142
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR42.1
BR43.1 BR521
BR530 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
Element: Billable AmounThis 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 BR41.1
BR41.4 BR43.1
BR521 BR530
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
Element: Billable UnitsThis 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 BR40.4
BR41.1 BR41.4
BR43.1 BR521
BR530 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-OVERRIDE-FLAG Alpha 1 AC190 AC196
Element: Override Flag This field determines whether billing AC198 AC41.1
amounts are calculated or not. This flag AC41.4 AC42.1
is set to Yes if the billing amount or AC540 BR40.3
billing units values are defined for BR40.4 BR41.1
this transaction by the client versus BR41.4 BR43.1
being calculated by the billing BR521 BR530
programs. If this flag is Yes, the GL199
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
Element: Revenue Flag This flag indicates whether revenue has AC192 AC196
been recognized for the transaction. AC310 AC40.1
AC40.4 AC41.1
Valid values are AC41.4 AC42.1
AC45.1 BR130
Y = Yes BR142 BR40.3
N = No BR40.4 BR41.1
H = Hold BR41.4 BR42.1
E = Exceeded ceiling BR43.1 BR521
BR530 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-CAPITALIZE-FLG Alpha 1 AC131 AC160
Element: CapitalizationThis 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. BR41.4 BR43.1
BR521 BR530
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
Element: 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 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199
ATN-MX-VALUE Alpha 32 AC131 AC190
Element: Attribute ValuThis 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 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199
ATN-RESOURCE-TYPE Alpha 1 AC131 AC190
Element: Resource Type This field indicates the type of the AC196 AC198
resource associated with the AC310 AC40.1
transaction. AC40.4 AC41.1
E = PR Employee AC41.4 AC42.1
V = AP/EE Vendor AC530 AC540
A = AM Asset AC542 BR40.3
P = Person BR41.1 BR41.4
Q = Equipment BR43.1 BR521
BR530 GL199
IFGT.1
ATN-RESOURCE-CODE Alpha 10 AC131 AC190
Element: Resource Code This is the resource code associated AC196 AC198
with the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC530 AC540
AC542 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-RESOURCE-DESC Alpha 30 (Lower Case) AC190 AC191
Element: Description AC196 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
AC542 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 GL199
IFGT.1
ATN-UNIT-MEASURE Alpha 12 AC131 AC196
Element: Unit of MeasurThis is the unit of measure for the AC310 AC40.1
transaction. AC40.4 AC41.1
AC41.4 AC42.1
AC540 AC542
BR40.3 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199
ATN-GLT-OBJ-ID Numeric 12 BR41.1 BR41.4
Object This is a subsystem-General Ledger BR43.1 BR521
Identification interface identification number. It is BR530 GL199
used for Drill Around purposes. IFGT.1
ATN-PERIOD Numeric 2 AC131 AC190
Element: 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 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199 IFGT.1
ATN-FISCAL-YEAR Numeric 4 AC131 AC190
Element: 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 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199 IFGT.1
ATN-AC191-UPDATED.html">AC191-UPDATED Alpha 1 AC190 AC191
Element: 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 BR41.4 BR43.1
added, this value is No. BR521 BR530
Y = Yes GL199
ATN-RECONCILED Alpha 1 AC190 AC196
Element: 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 BR41.4
is reconciled, the value in this field BR43.1 BR521
is No. BR530 GL199
Y = Yes
N = No
ATN-SEGMENT-FLAG Alpha 1 AC190 AC198
Element: Segment Flag Y = Yes AC40.1 AC40.4
N = No AC41.1 AC41.4
AC42.1 BR41.1
BR41.4 BR43.1
BR521 BR530
GL199
ATN-RPT-AMOUNT-1 Signed 15.2 AC131 AC190
Element: Adj Amt AC196 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR41.1
BR41.4 BR43.1
BR521 BR530
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-RPT-RATE-1 Signed 12.6 AC131 AC190
Element: 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 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 IFGT.1
ATN-RPT-ND-1 Numeric 1 AC131 AC190
Account Currency AC196 AC198
Code AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 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
BR40.3 BR41.1
BR41.4 BR43.1
BR521 BR530
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-RPT-RATE-2 Signed 12.6 AC131 AC190
Element: Rpt Rate 1 AC196 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC530
AC540 AC542
AC581 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 IFGT.1
ATN-RPT-ND-2 Numeric 1 AC131 AC190
Element: 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 BR40.3
BR41.1 BR41.4
BR43.1 BR521
BR530 IFGT.1
ATN-BRDN-ORG-OBJID Numeric 12 AC190 AC198
Element: Brdn Org Objid BR41.1 BR41.4
BR43.1
ATN-ORIG-OBJ-ID Numeric 12 AC542 BR41.1
Element: Orig Obj Id BR41.4 BR43.1
ATN-BILLED-AMT Signed 15.2 GL146 GL190
Element: 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
Element: Adj Amt AC198 AC45.1
AC540 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
BR41.1 BR41.4
BR43.1 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-EXPENSE-CODE Alpha 20 AC542 BR41.1
Element: Expense Code BR41.4 BR43.1
ATN-REBILL-AMT Signed 15.2 GL146 GL190
Element: 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
Accounts Receivable This field contains the reason code, BR41.1 BR41.4
Code which indicates the cause for credit BR43.1
memos.
ATN-COMMENT-CD Numeric 3 BR41.1 BR41.4
Element: Comment Code This is the number representing a BR43.1 BR521
comment relating to the transaction. BR530 GL199
ACTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATNSET1 ACTIVITY-GRP AC00.1 AC06.1
ACTIVITY AC10.1 AC112
ACCT-CATEGORY AC12.1 AC120
COMPANY AC160 AC192
ACCT-UNIT AC196 AC256
ACCOUNT AC300 AC310
SUB-ACCOUNT AC45.1 AC50.1
OBJ-ID AC581 BR130
BR131 BR153
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR430
BR521 BR530
BRIP.1 BRPI.1
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 AC190 AC192
AC195 AC198
AC45.1 AC542
ACDR.1 BR122
BR130 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR253 BR450
BR52.3 BR53.1
BR530
ATNSET13 ACTIVITY KeyChange AC10.1 AC196
ACCT-CATEGORY AC240 AC256
POSTING-DATE AC50.1 AC96.1
SYSTEM AC96.2 BR10.1
SOURCE-CODE
OBJ-ID
ATNSET14 GLT-OBJ-ID KeyChange GL146 GL190
OBJ-ID 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 ) AC40.1 AC40.4
ACCT-CATEGORY AC41.1 AC41.4
POSTING-DATE AC42.1 AC45.1
OBJ-ID AC530 ACAC.1
ACDL.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP520
BR130 BR131
BR153 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR430
...
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 BR41.1
BR41.4 BR43.1
ATNSET8 ACTIVITY KeyChange, Subset BR120 BR130
ACCT-CATEGORY Where((BILLABLE = "Y" ) BR530
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 BR41.1
SEQUENCE-NBR BR41.4 IFGT.1
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 ACV-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 ACV-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
Acdefrev ACDEFREV
ATN-GLT-OBJ-ID -> DRD-GLT-OBJ-ID
ATN-OBJ-ID -> DRD-ATN-OBJ-ID
DRD-CONTRACT
DRD-PRODUCT
DRD-PROD-VERSION
DRD-OBJ-ID
DRD-SEQ-NBR
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
HDT-SEQ-NBR-2
Acmntschx ACMNTSCHX
ATN-GLT-OBJ-ID -> MSD-GLT-OBJ-ID
ATN-OBJ-ID -> MSD-ATN-OBJ-ID
MSD-CONTRACT
MSD-MAINT-SCHEDULE
MSD-PRODUCT
MSD-PROD-VERSION
MSD-OBJ-ID
MSD-TRAN-DATE
Acmxval ACMXVAL
ATN-OBJ-ID -> ATV-OBJ-ID
ATV-MATRIX-CAT
Acpmhstdtl ACPMHSTDTL
ATN-GLT-OBJ-ID -> PML-GLT-OBJ-ID
ATN-OBJ-ID -> PML-ATN-OBJ-ID
PML-OBJ-ID
PML-LINE-NBR
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
|