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 AC08.3 AC08.7 AC10.1 AC10.6 AC112
AC12.1 AC256 AC50.1 BR131 BR430 BR96.1
AC295 AC46.1 AC90.2 AC90.4 AC90.6 AC90.8
AC95.2 AC95.4 AC95.6 ACAC.1 ACVW.1 SE90.1
CB10.1 CB15.1 CB15.2 CB191 CB20.1 CB30.1
CB500 EE135 EE20.3 EE35.1 EE35.2 EE520
GL165 GL170 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 MA65.1 BR450 AC240 AC96.1
AC96.2 AC96.4 BR10.1 ACDL.1 AC290 AC440
AC460 AC471 AC490 BR19.1 BR515 BR516
BR580
UPDATED BY
AC108 AC120 AC131 AC145 AC160 AC190
AC191 AC195 AC197 AC198 AC300 AC310
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC45.1
AC45.4 AC540 AC580 AC581 AC583 ACDR.1
AP125 AP126 AP175 AP178 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP520 API1.1
API2.1 BR02.3 BR120 BR121 BR122 BR130
BR140 BR142 BR190 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR40.3 BR40.4 BR41.1 BR41.4
BR42.1 BR420 BR43.1 BR44.1 BR46.1 BR46.2
BR46.4 BR521 BR530 BRIP.1 GL146 GL190
GL197 GL199 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 IFGT.1 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATN-ACTIVITY-GRP Alpha 15 AC120 AC131
Element: Activity GroupRequired key. This is the activity AC190 AC197
group for the transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 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 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
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 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
GL199 IFGT.1
ATN-OBJ-ID Numeric 12 AC131 AC190
Element: Object IdentifRequired key. This is the object AC197 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 AC540 BR20.1
commitment or posted transaction is BR20.2 BR20.3
assigned an object identifier. The BR20.4 BR20.5
object identifier is maintained in the BR40.3 BR40.4
subsystem files and in the Activity BR41.1 BR41.4
Commitments Detail and Activity BR43.1 BR44.1
Transaction files. The object identifier BR46.1 BR46.2
is a unique key generated by the system BR46.4 BR530
and used to drill back from Activity BRIP.1 GL146
Management to the subsystems. GL190 GL197
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 AC540
B = AC side of AC and GL trans BR41.1 BR41.4
I = Interface BR43.1 BR530
G = GL side of AC and GL trans BRIP.1 IFGT.1
T = Time Entry
ATN-COMPANY Numeric 4 AC131 AC190
Element: Company This is the responsible company. AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 IFGT.1
ATN-FROM-COMPANY Numeric 4 AC131 AC190
Element: From Company This is the company that is the source AC197 AC198
of the items. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR46.1
BR530 BRIP.1
IFGT.1
ATN-TRAN-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: Transaction DaThis is the date the transaction is AC197 AC198
posted. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 GL199
IFGT.1
ATN-ACTIVITY Alpha 15 AC131 AC190
Element: Activity This is the activity for the AC197 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-VAR-LEVELS Alpha 30 AC120 AC131
Element: Variable LevelThis is the variable level for the AC190 AC197
transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 IFGT.1
ATN-STATUS Numeric 1 AC131 AC145
Element: Status The transaction status tells whether AC190 AC197
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 AC540
9 = Posted BR40.3 BR40.4
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.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 AC190
Element: Account CategoThis is the account category for the AC197 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-POSTING-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: Posting Date For an Activity Management transaction, AC195 AC197
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 AC540
BR41.1 BR41.4
BR43.1 BR46.1
BR530 BRIP.1
GL199 IFGT.1
ATN-SYSTEM Alpha 2 AC131 AC190
Element: System Code This is the system in which this AC197 AC198
transaction originated. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 IFGT.1
ATN-ACCT-UNIT Alpha 15 AC131 AC190
Element: Accounting UniThis is the general ledger accounting AC197 AC198
unit for the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 IFGT.1
ATN-ACCOUNT Numeric 6 AC131 AC190
Element: Account This field along with the accounting AC197 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
AC540 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 IFGT.1
ATN-SUB-ACCOUNT Numeric 4 AC131 AC190
Element: Subaccount This is the general ledger subaccount AC197 AC198
for the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 IFGT.1
ATN-DESCRIPTION Alpha 30 (Lower Case) AC131 AC190
Transaction This is the description of the AC197 AC198
Description transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-REFERENCE Alpha 10 (Lower Case) AC131 AC197
Element: Reference This is the reference for this AC310 AC40.1
transaction. AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR40.4 BR41.1
BR43.1 BR46.1
BR530 BRIP.1
IFGT.1
ATN-UNITS-AMOUNT Signed 15.2 AC131 AC310
Element: Units Amount This is the units amount for this AC40.1 AC40.4
transaction. AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
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 AC197 AC198
transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
IFGT.1
ATN-TRAN-AMOUNT Signed 18.2 AC131 AC190
Element: Transaction AmThis is the amount in transaction AC197 AC198
currency. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.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 AC197 AC198
of Decimals of decimal positions used for the AC310 AC40.1
transaction. AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
IFGT.1
ATN-ACT-CURRENCY Alpha 5 AC131 AC190
Element: Activity CurreThis is the activity currency. AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-ACT-BASERATE Signed 14.7 AC131 AC190
Element: Activity Base This is the rate that converts the AC197 AC198
transaction amount to the activity AC310 AC40.1
amount. AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 IFGT.1
ATN-ACT-AMOUNT Signed 18.2 AC131 AC190
Element: Activity AmounThis is the amount for the activity. AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.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 AC197 AC198
Decimals activity. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 IFGT.1
ATN-AG-CURRENCY Alpha 5 AC131 AC190
Activity Group This is the currency for the activity AC197 AC198
Currency group. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 IFGT.1
ATN-AG-BASERATE Signed 14.7 AC131 AC190
Activity Group Base This is the rate that converts the AC197 AC198
Rate transaction amount to the activity group AC310 AC40.1
amount. AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 IFGT.1
ATN-AG-AMOUNT Signed 18.2 AC131 AC190
Activity Group This is the amount for the activity AC197 AC198
Amount group for this transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.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 AC197 AC198
of Decimals activity group. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 IFGT.1
ATN-BILL-DATE Numeric 8 (yyyymmdd) AC310 AC40.1
Element: Billing Date This is the date the transaction was AC40.4 AC41.1
billed. AC41.4 AC42.1
BR40.3 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
GL199
ATN-RUN-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: Run Date This is the date the transaction was AC197 AC198
posted to the general ledger. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.4 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL199 IFGT.1
ATN-RUN-TIME Numeric 6 (hhmmss) AC131 AC190
Element: Run Time This is the time the transaction was AC197 AC198
posted to the general ledger. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.4 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL199 IFGT.1
ATN-SOURCE-CODE Alpha 2 AC131 AC190
Element: Source Code This is the source code for the AC197 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. AC540 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 IFGT.1
ATN-BILL-RATE Signed 13.4 AC131 AC145
Element: Billing Rate This is the billing rate for the AC190 AC310
transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR190 BR40.4
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL199
ATN-BILLABLE Alpha 1 AC131 AC145
Element: Billable This field indicates whether the AC190 AC197
transaction is billable, on hold, a AC198 AC310
write-off, or a transfer. AC40.1 AC40.4
Y = Yes AC41.1 AC41.4
N = No AC42.1 AC45.1
H = Hold BR142 BR190
BR40.3 BR40.4
BR41.1 BR41.4
BR42.1 BR43.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 GL199
ATN-BILLED Alpha 1 AC131 AC145
Element: Billed This field indicates whether the AC190 AC197
transaction has been billed. AC198 AC310
Y = Yes AC40.1 AC40.4
N = No AC41.1 AC41.4
H = Hold AC42.1 AC45.1
E = Exceeded ceiling BR02.3 BR120
BR121 BR122
BR140 BR142
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR42.1 BR420
BR43.1 BR46.1
BR46.2 BR46.4
BR521 BR530
BRIP.1 GL146
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLABLE-AMT Signed 18.2 AC131 AC145
Element: Billable AmounThis is the billable amount for the AC190 AC197
transaction. AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
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 AC145
Element: Billable UnitsThis is the number of billable units AC190 AC310
for the transaction. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-OVERRIDE-FLAG Alpha 1 AC190 AC197
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 BR44.1 BR46.1
programs. If this flag is Yes, the BR46.2 BR46.4
billing amount and unit will not be BR530 BRIP.1
initialized if the transaction is backed GL199
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 AC145
Element: Revenue Flag This flag indicates whether revenue has AC190 AC197
been recognized for the transaction. AC198 AC310
AC40.1 AC40.4
Valid values are AC41.1 AC41.4
AC42.1 AC45.1
Y = Yes BR130 BR140
N = No BR142 BR190
H = Hold BR20.1 BR20.2
E = Exceeded ceiling BR20.3 BR20.4
BR20.5 BR41.1
BR41.4 BR42.1
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-CAPITALIZE-FLG Alpha 1 AC131 AC145
Element: CapitalizationThis flag indicates whether the AC160 AC190
transaction has been capitalized. AC197 AC198
AC310 AC40.1
Use Yes if the transaction has been AC40.4 AC41.1
capitalized. Use No if the transaction AC41.4 AC42.1
has not been capitalized. AC45.1 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
GL146 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-MATRIX-CAT Alpha 12 AC131 AC145
Element: Attribute Activity attributes can be assigned to AC190 AC197
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
BR46.1 BR530
BRIP.1 GL199
ATN-MX-VALUE Alpha 32 AC131 AC145
Element: Attribute ValuThis is an attribute value assigned to AC190 AC197
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
BR46.1 BR530
BRIP.1 GL199
ATN-RESOURCE-TYPE Alpha 1 AC131 AC190
Element: Resource Type This field indicates the type of the AC197 AC198
resource associated with the AC310 AC40.1
transaction. AC40.4 AC41.1
E = PR Employee AC41.4 AC42.1
V = AP/EE Vendor AC540 BR40.3
A = AM Asset BR41.1 BR41.4
P = Person BR43.1 BR46.1
Q = Equipment BR530 BRIP.1
GL199 IFGT.1
ATN-RESOURCE-CODE Alpha 10 AC131 AC190
Element: Resource Code This is the resource code associated AC197 AC198
with the transaction. AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR46.1
BR530 BRIP.1
GL199 IFGT.1
ATN-RESOURCE-DESC Alpha 30 (Lower Case) AC190 AC191
Element: Description AC197 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
BR40.3 BR41.1
BR41.4 BR530
BRIP.1 GL199
IFGT.1
ATN-UNIT-MEASURE Alpha 12 AC131 AC310
Element: Unit of MeasurThis is the unit of measure for the AC40.1 AC40.4
transaction. AC41.1 AC41.4
AC42.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 GL199
ATN-GLT-OBJ-ID Numeric 12 BR41.1 BR41.4
Object This is a subsystem-General Ledger BR43.1 BR46.2
Identification interface identification number. It is BR46.4 BR530
used for Drill Around purposes. BRIP.1 GL199
IFGT.1
ATN-PERIOD Numeric 2 AC108 AC120
Element: Period This is the period for the transaction. AC131 AC145
AC190 AC191
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
AC580 AC581
AC583 ACDR.1
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 GL199
IFGT.1
ATN-FISCAL-YEAR Numeric 4 AC108 AC120
Element: Year This is the fiscal year for the AC131 AC145
transaction. AC190 AC191
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
AC580 AC581
AC583 ACDR.1
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 GL199
IFGT.1
ATN-AC191-UPDATED.html">AC191-UPDATED Alpha 1 AC145 AC190
Element: AC191 Updated This field indicates whether the AC191 AC197
transaction has been updated to the AC198 AC310
Activity GL Accounting Unit Master AC40.1 AC40.4
header and detail files. If the AC41.1 AC41.4
transaction has been added, this value AC42.1 AC45.1
is Yes. If the transaction has not been BR41.1 BR41.4
added, this value is No. BR43.1 BR46.2
Y = Yes BR46.4 BR530
BRIP.1 GL199
ATN-RECONCILED Alpha 1 AC190 AC197
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 BR46.2
is No. BR46.4 BR530
Y = Yes BRIP.1 GL199
N = No
ATN-SEGMENT-FLAG Alpha 1 AC190 AC197
Element: Segment Flag Indicates whether user analysis values AC198 AC40.1
(SL segment) have been populated for the AC40.4 AC41.1
distribution line. AC41.4 AC42.1
Y = Yes BR41.1 BR41.4
N = No BR43.1 BR530
BRIP.1 GL199
ATN-RPT-AMOUNT-1 Signed 18.2 AC131 AC190
Element: Intl Amt The transaction amount for Report AC197 AC198
Currency 1. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 AC581
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-RPT-RATE-1 Signed 14.7 AC131 AC190
Element: Rpt Rate 1 The exchange rate to convert the AC197 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 AC540
AC581 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-RPT-ND-1 Numeric 1 AC131 AC190
Account Currency The number of decimal positions for AC197 AC198
Code Report Currency 1. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
AC581 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-RPT-AMOUNT-2 Signed 18.2 AC131 AC190
Element: Intl Amt The transaction amount for Report AC197 AC198
Currency 2. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 AC581
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-RPT-RATE-2 Signed 14.7 AC131 AC190
Element: Rpt Rate 1 The exchange rate to convert the AC197 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 AC540
AC581 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-RPT-ND-2 Numeric 1 AC131 AC190
Account Currency The number of decimal positions for AC197 AC198
Code Report Currency 2. AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
AC581 BR40.3
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-BRDN-ORG-OBJID Numeric 12 AC190 AC197
Element: Brdn Org ObjidIf the transaction record is a burden AC198 BR41.1
transaction, this field stores the BR41.4 BR43.1
OBJ-ID of the transaction that this
burden transaction was created from.
ATN-ORIG-OBJ-ID Numeric 12 BR41.1 BR41.4
Element: Orig Obj Id This field is used with the Databasics BR43.1
time interface program (DI542) and in
some Payroll libraries. It is used for
adjustment transactions to link them
back to the original transaction that is
being adjusted.
ATN-BILLED-AMT Signed 18.2 GL146 GL190
Element: Intl Amt GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-REVENUE-AMT Signed 18.2 AC145 AC190
Element: Intl Amt AC197 AC198
AC45.1 AC540
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-EXPENSE-CODE Alpha 20 BR41.1 BR41.4
Element: Expense Code BR43.1
ATN-REASON-CODE Alpha 4 BR40.3 BR40.4
Element: Reason Code This field contains the reason code, BR41.1 BR41.4
which indicates the cause for credit BR43.1 BR44.1
memos. BR46.2 BR46.4
ATN-COMMENT-CD Numeric 3 BR41.1 BR41.4
Element: Comment Code This is the number representing a BR43.1 BR530
comment relating to the transaction. BRIP.1 GL199
ATN-AP-PAID Alpha 1 AC190 AC540
Element: Ap Paid " " = Eligible for Billing AP125 AP126
H = Hold for Billing AP175 AP178
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BR41.1
BR41.4 BR43.1
BR46.2 BR46.4
IFGT.1 MA61.1
MAI1.1
ATN-QUICK-POST-FL Alpha 1 AC145 AC190
Element: Quick Post Fl Y = Yes AC197 AC198
N = No AC45.1 BR41.1
BR41.4 BR43.1
BR46.2 BR46.4
ATN-TRANSFER-FL Alpha 1 BR44.1
Element: Transfer Fl Y = Yes
N = No
T = Transferred
ATN-TRANSFER-AMT Signed 18.2 BR46.2 BR46.4
Element: Adj Amt
ATN-BILL-MTHD Numeric 1 AC145 AC190
Element: Billing Method AC45.1 BR46.1
BR46.2 BR46.4
ATN-REV-MTHD Alpha 1 AC145 AC190
Element: Rev Mthd AC45.1 BR46.1
BR46.2 BR46.4
ATN-REV-OBJ-ID Numeric 12 BR130 BR530
Object
Identification
ATN-SUM-ACCT-CAT Alpha 5 AC108 AC120
Element: Sum Acct Cat The name of the summary account AC131 AC145
category. AC190 AC191
AC197 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 AC580
AC581 AC583
ACDR.1 BR41.1
BR41.4 BR42.1
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
IFGT.1
ATN-HOLD-OBJ-ID Numeric 12 BR20.1 BR20.2
Object BR20.3 BR20.4
Identification BR20.5 BR46.1
BR46.2 BR46.4
ACTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATNSET1 ACTIVITY-GRP AC00.1 AC08.3
ACTIVITY AC08.7 AC10.1
ACCT-CATEGORY AC10.6 AC108
COMPANY AC112 AC12.1
ACCT-UNIT AC120 AC145
ACCOUNT AC160 AC190
SUB-ACCOUNT AC191 AC256
OBJ-ID AC300 AC310
AC45.1 AC50.1
AC580 AC581
AC583 ACDR.1
BR130 BR131
BR140 BR42.1
BR430 BR530
BR96.1 BRIP.1
ATNSET10 ACTIVITY-GRP KeyChange, Subset AC295 AC40.1
VAR-LEVELS Where (STATUS != Zeroes ) AC40.4 AC41.1
STATUS AC41.4 AC42.1
ACCT-CATEGORY AC46.1 AC90.2
FISCAL-YEAR AC90.4 AC90.6
PERIOD AC90.8 AC95.2
OBJ-ID AC95.4 AC95.6
ACAC.1 ACVW.1
SE90.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB15.1
...
ATNSET11 ACCT-CATEGORY KeyChange, Subset
OBJ-ID Where (STATUS = 1 )
ATNSET12 OBJ-ID AC145 AC190
AC195 AC197
AC198 AC45.1
AP125 AP126
AP175 AP178
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 BR02.3
BR120 BR121
BR122 BR130
BR140 BR190
BR20.1 BR20.2
BR20.3 BR20.4
...
ATNSET13 ACTIVITY KeyChange AC10.1 AC240
ACCT-CATEGORY AC256 AC50.1
POSTING-DATE AC96.1 AC96.2
SYSTEM AC96.4 BR10.1
SOURCE-CODE BR44.1 BR96.1
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
ATNSET2 STATUS KeyChange AC295 AC40.1
SUM-ACCT-CAT AC40.4 AC41.1
ACTIVITY-GRP AC41.4 AC42.1
ACTIVITY AC46.1 AC90.2
ACCT-CATEGORY AC90.4 AC90.6
OBJ-ID AC90.8 AC95.2
AC95.4 AC95.6
ACAC.1 ACVW.1
SE90.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB15.1
...
ATNSET3 ACTIVITY-GRP KeyChange, Subset AC190 AC295
ACTIVITY Where (STATUS = 1 ) AC40.1 AC40.4
ACCT-CATEGORY AC41.1 AC41.4
POSTING-DATE AC42.1 AC45.1
OBJ-ID AC46.1 AC90.2
AC90.4 AC90.6
AC90.8 AC95.2
AC95.4 AC95.6
ACAC.1 ACDL.1
ACVW.1 SE90.1
AP125 AP126
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR130 BR131
...
ATNSET4 ACTIVITY KeyChange, Subset AC10.1 AC112
ACCT-CATEGORY Where (STATUS = 9 ) AC12.1 AC191
FISCAL-YEAR AC197 AC290
PERIOD AC310 AC440
OBJ-ID AC460 AC471
AC490 AC50.1
ACDR.1 BR142
BR19.1 BR190
BR40.1 BR40.3
BR40.4 BR42.1
BR430 BR450
BR515 BR516
BR580 BRIP.1
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 AC10.1 AC112
ACCT-CATEGORY Where((BILLABLE = "Y" ) AC12.1 AC50.1
TRAN-CURRENCY Or (BILLABLE = "H" )) BR120 BR121
UNIT-MEASURE And ((REVENUE-FLAG != "Y" ) BR122 BR130
MATRIX-CAT Or (BILLED != "Y" )) BR20.1 BR20.2
MX-VALUE BR20.3 BR20.4
POSTING-DATE BR20.5 BR420
OBJ-ID BR521 BR530
ATNSET9 OBJ-ID KeyChange AC256 AC40.1
ACTIVITY-GRP AC40.4 AC41.1
ACTIVITY AC41.4 AC42.1
CONTROL-GROUP BR41.1 BR41.4
SEQUENCE-NBR 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-FROM-COMPANY -> AAN-COMPANY
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
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
Actranseg ACTRANSEG Not Required
ATN-OBJ-ID -> TSG-OBJ-ID
Actranserr ACTRANSERR Not 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
BLA-CTR-CAT-GRP
BLA-SUM-ACCT-CAT
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-ATN-OBJ-ID
CGT-LEVEL
Achistdtl ACHISTDTL
ATN-OBJ-ID -> HDT-ATN-OBJ-ID
HDT-CONTRACT
HDT-OBJ-ID
HDT-LINE-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
Gmtranefrt GMTRANEFRT
ATN-OBJ-ID -> GEF-ATN-OBJ-ID
GEF-OBJ-ID
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
|