ACTRANS

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
AC256 ACBD.2 BR131 BR153 BR96.1 AC297
AP175 BR253 BR52.3 BR53.1 EE175 AC19.1
AC96.1 AC96.2 AC96.4 AC96.5 BR10.1 ACDL.1
SNAC.1 AC290 AC440 AC460 AC471 BR19.1


UPDATED BY
AC108 AC120 AC131 AC145 AC160 AC169
AC190 AC191 AC195 AC196 AC197 AC198
AC300 AC310 AC311 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC45.1 AC45.4 AC540 AC580
AC581 AC583 AC69.1 AC704 ACDR.1 AP125
AP126 AP178 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP520 API1.1
API2.1 BR02.3 BR120 BR121 BR122 BR123
BR130 BR140 BR142 BR151 BR152 BR156
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 CX05.1 CX30.1 GL146 GL197
GL199 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 EX175 EX542 IFGT.1 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA61.1 MA70.1 MA75.1 MAI1.1
AC00.1 AC08.3 AC08.7 AC10.1 AC10.6 AC112
AC12.1 AC50.1 AC56.1 AC560 BR430 BR515
BR516 AC121 AC123 AC130 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC295 AC32.1 AC37.1
AC46.1 AC490 AC90.2 AC90.4 AC90.6 AC90.8
AC95.2 AC95.4 AC95.6 AC97.2 AC97.4 AC97.6
ACAC.1 ACVW.1 SE90.1 AP131 AP170 AP193
AP510 CB10.1 CB15.1 CB15.2 CB150 CB191
CB20.1 CB30.1 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX300 CX506 CXCP.1
EE11.1 EE135 EE20.3 EE35.1 EE35.2 EE520
GL165 GL170 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 GL76.1 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 EX545 IFEB.1
MA180 MA278 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA80.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POIG.1 POII.1 POIJ.1 POIK.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 BR450 AC240
BR580

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATN-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Required key. This is the activity group for the transaction.
AC120 AC131
AC190 AC197
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-CONTROL-GROUP
Element: Control Group
Numeric 8
Required key. This field indicates the control group number used for process control of the activity transactions.
AC131 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
CX05.1 CX30.1
GL199 IFGT.1
ATN-SEQUENCE-NBR
Element: Sequence Number
Numeric 4
Required key. This user-assigned sequence number is used to keep the records unique and to determine order.
AC131 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
GL199 IFGT.1
ATN-OBJ-ID
Element: Object Identifier
Numeric 12
Required key. This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key generated by the system and used to drill back from Project Accounting to the subsystems.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.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 CX05.1
CX30.1 EX175
EX542 GL146
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
ATN-TRANS-TYPE
Element: Transaction Type
Alpha 1
This field determines if amounts or units are processed in the transaction.
A = Activity Management Only
B = AC side of AC and GL trans
I = Interface
G = GL side of AC and GL trans
T = Time Entry
AC131 AC190
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-COMPANY
Element: Company
Numeric 4
This is the responsible company.
AC131 AC190
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-FROM-COMPANY
Element: From Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AC131 AC190
AC197 AC198
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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-TRAN-DATE
Element: Transaction Date
Numeric 8 (yyyymmdd)
This is the date the transaction is posted.
AC131 AC190
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 CX05.1
CX30.1 EX175
EX542 GL199
IFGT.1
ATN-ACTIVITY
Element: Activity
Alpha 15
This is the activity for the transaction.
AC131 AC190
AC197 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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-VAR-LEVELS
Element: Variable Levels
Alpha 30
This is the variable level for the transaction.
AC120 AC131
AC190 AC197
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-STATUS
Element: Status
Numeric 1
The transaction status tells whether the transaction is released (these are considered commitments), unreleased, or posted.
0 = Unreleased
1 = Released
9 = Posted
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC45.4 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
CX05.1 CX30.1
EX175 EX542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
ATN-ACCT-CATEGORY
Element: Account Category
Alpha 5
This is the account category for the transaction.
AC131 AC190
AC197 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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-POSTING-DATE
Element: Posting Date
Numeric 8 (yyyymmdd)
For an Project Accounting transaction, this is the date the transaction was posted to the Activity Transaction file.
AC131 AC190
AC195 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
CX05.1 CX30.1
EX175 EX542
GL199 IFGT.1
ATN-SYSTEM
Element: System Code
Alpha 2
This is the system in which this transaction originated.
AC131 AC190
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-ACCT-UNIT
Element: Accounting Unit
Alpha 15
This is the general ledger accounting unit for the transaction.
AC131 AC190
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AC131 AC190
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This is the general ledger subaccount for the transaction.
AC131 AC190
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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-DESCRIPTION
Transaction
Description
Alpha 30 (Lower Case)
This is the description of the transaction.
AC131 AC190
AC197 AC198
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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
This is the reference for this transaction.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
This is the units amount for this transaction.
AC131 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
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-TRAN-CURRENCY
Element: Transaction Currency
Alpha 5
This is the currency for the transaction.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-TRAN-AMOUNT
Element: Transaction Amount
Signed 18.2
This is the amount in transaction currency.
AC131 AC190
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
CX05.1 CX30.1
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-TRAN-ND
Transaction Number
of Decimals
Numeric 1
This field indicates the defined number of decimal positions used for the transaction.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-ACT-CURRENCY
Element: Activity Currency
Alpha 5
This is the activity currency.
AC131 AC190
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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-ACT-BASERATE
Element: Activity Base Rate
Signed 14.7
This is the rate that converts the transaction amount to the activity amount.
AC131 AC190
AC197 AC198
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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-ACT-AMOUNT
Element: Activity Amount
Signed 18.2
This is the amount for the activity.
AC131 AC190
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
CX05.1 CX30.1
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-ACT-ND
Activity Number of
Decimals
Numeric 1
This is the number of decimals for the activity.
AC131 AC190
AC197 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.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-AG-CURRENCY
Activity Group
Currency
Alpha 5
This is the currency for the activity group.
AC131 AC190
AC197 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.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-AG-BASERATE
Activity Group Base
Rate
Signed 14.7
This is the rate that converts the transaction amount to the activity group amount.
AC131 AC190
AC197 AC198
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
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-AG-AMOUNT
Activity Group
Amount
Signed 18.2
This is the amount for the activity group for this transaction.
AC131 AC190
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
CX05.1 CX30.1
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-AG-ND
Activity Group Nbr
of Decimals
Numeric 1
This is the number of decimals for the activity group.
AC131 AC190
AC197 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.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-BILL-DATE
Element: Billing Date
Numeric 8 (yyyymmdd)
This is the date the transaction was billed.
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR41.1
BR41.4 BR420
BR43.1 BR46.1
BR46.2 BR46.4
BR521 BR530
BRIP.1 CX05.1
CX30.1 GL199
ATN-RUN-DATE
Element: Run Date
Numeric 8 (yyyymmdd)
This is the date the transaction was posted to the general ledger.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.4 AC540
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 CX05.1
CX30.1 EX175
EX542 GL199
IFGT.1
ATN-RUN-TIME
Element: Run Time
Numeric 6 (hhmmss)
This is the time the transaction was posted to the general ledger.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.4 AC540
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 CX05.1
CX30.1 EX175
EX542 GL199
IFGT.1
ATN-SOURCE-CODE
Element: Source Code
Alpha 2
This is the source code for the transaction. This value defaults from the program the user uses to enter a journal entry. This value is not necessarily the same as the system ID.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-BILL-RATE
Element: Billing Rate
Signed 13.4
This is the billing rate for the transaction.
AC131 AC145
AC190 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR142 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.4
BR41.1 BR41.4
BR42.1 BR43.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 GL199
ATN-BILLABLE
Element: Billable
Alpha 1
This field indicates whether the transaction is billable, on hold, a write-off, or a transfer.
Y = Yes
N = No
H = Hold
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR142 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR42.1
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
GL199
ATN-BILLED
Element: Billed
Alpha 1
This field indicates whether the transaction has been billed.
Y = Yes
N = No
H = Hold
E = Exceeded ceiling
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR02.3
BR120 BR121
BR122 BR123
BR140 BR142
BR151 BR152
BR156 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR42.1
BR420 BR43.1
BR46.1 BR46.2
BR46.4 BR521
BR530 BRIP.1
CX05.1 CX30.1
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLABLE-AMT
Element: Billable Amount
Signed 18.2
This is the billable amount for the transaction.
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR142
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
BR41.1 BR41.4
BR42.1 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLABLE-UNIT
Element: Billable Units
Signed 15.2
This is the number of billable units for the transaction.
AC131 AC145
AC190 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC540 BR142
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR42.1
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 GL146
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-OVERRIDE-FLAG
Element: Override Flag
Alpha 1
This field determines whether billing amounts are calculated or not. This flag is set to Yes if the billing amount or billing units values are defined for 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
AC190 AC197
AC198 AC310
AC41.1 AC41.4
AC42.1 AC540
BR142 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
BR41.1 BR41.4
BR42.1 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
GL199
ATN-REVENUE-FLAG
Element: Revenue Flag
Alpha 1
This flag indicates whether revenue has been recognized for the transaction. Valid values are Y = Yes N = No H = Hold
E = Exceeded ceiling
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR130 BR140
BR142 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR40.3
BR40.4 BR41.1
BR41.4 BR42.1
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-CAPITALIZE-FLG
Element: Capitalization Flag
Alpha 1
This flag indicates whether the transaction has been capitalized. Use Yes if the transaction has been capitalized. Use No if the transaction has not been capitalized.
Y = Yes
N = No
AC131 AC145
AC160 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-MATRIX-CAT
Element: Attribute
Alpha 12
Activity attributes can be assigned to transaction objects to define additional categories of information for reporting and processing. You can assign three user-defined attributes per source code.
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR40.3 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 CX05.1
CX30.1 GL199
ATN-MX-VALUE
Element: Attribute Value
Alpha 32
This is an attribute value assigned to a transaction to track additional information. Attribute values can then be used in selection and sorting for reporting and analysis.
AC131 AC145
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR40.3 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 CX05.1
CX30.1 GL199
ATN-RESOURCE-TYPE
Element: Resource Type
Alpha 1
This field indicates the type of the resource associated with the transaction.
E = PR Employee
V = AP/EE Vendor
A = AM Asset
P = Person
Q = Equipment
AC131 AC190
AC197 AC198
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
CX05.1 CX30.1
EX175 EX542
GL199 IFGT.1
ATN-RESOURCE-CODE
Element: Resource Code
Alpha 10
This is the resource code associated with the transaction.
AC131 AC190
AC197 AC198
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
CX05.1 CX30.1
EX175 EX542
GL199 IFGT.1
ATN-RESOURCE-DESC
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC190 AC191
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 GL199
IFGT.1
ATN-UNIT-MEASURE
Element: Unit of Measure
Alpha 12
This is the unit of measure for the transaction.
AC131 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 CX05.1
CX30.1 EX175
EX542 GL199
ATN-GLT-OBJ-ID
Element: Obj Id
Numeric 12
This is a subsystem-General Ledger interface identification number. It is used for Drill Around purposes.
AC310 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 GL199
IFGT.1
ATN-PERIOD
Element: Period
Numeric 2
This is the period for the transaction.
AC108 AC120
AC131 AC145
AC190 AC191
AC195 AC196
AC197 AC198
AC310 AC311
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
CX05.1 CX30.1
EX175 EX542
GL199 IFGT.1
ATN-FISCAL-YEAR
Element: Year
Numeric 4
This is the fiscal year for the transaction.
AC108 AC120
AC131 AC145
AC190 AC191
AC195 AC196
AC197 AC198
AC310 AC311
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
CX05.1 CX30.1
EX175 EX542
GL199 IFGT.1
ATN-AC191-UPDATED
Element: AC191 Updated
Alpha 1
This field indicates whether the transaction has been updated to the Activity GL Accounting Unit Master header and detail files. If the transaction has been added, this value is Yes. If the transaction has not been added, this value is No.
Y = Yes
AC145 AC190
AC191 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR41.1
BR41.4 BR43.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 GL199
ATN-RECONCILED
Element: Reconciled
Alpha 1
This flag is set to Yes when the payroll transaction has been reconciled by AC196 (Activity Payroll Reconciliation). Before the transaction is reconciled, the value in this field is No.
Y = Yes
N = No
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
GL199
ATN-SEGMENT-FLAG
Element: Segment Flag
Alpha 1
Indicates whether user analysis values (SL segment) have been populated for the distribution line.
Y = Yes
N = No
AC190 AC197
AC198 AC310
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
CX05.1 CX30.1
GL199
ATN-RPT-AMOUNT-1
Element: Intl Amt
Signed 18.2
AC131 AC190
AC197 AC198
AC310 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 BR40.4
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-RPT-RATE-1
Element: Rpt Rate 1
Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
AC131 AC190
AC197 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
AC581 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-RPT-ND-1
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 AC581
BR40.3 BR40.4
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-RPT-AMOUNT-2
Element: Intl Amt
Signed 18.2
AC131 AC190
AC197 AC198
AC310 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 BR40.4
BR41.1 BR41.4
BR43.1 BR44.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL45.1 IFGT.1
ATN-RPT-RATE-2
Element: Rpt Rate 1
Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
AC131 AC190
AC197 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
AC581 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-RPT-ND-2
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AC131 AC190
AC197 AC198
AC310 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC540 AC581
BR40.3 BR40.4
BR41.1 BR41.4
BR43.1 BR44.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
EX175 EX542
IFGT.1
ATN-BRDN-ORG-OBJID
Element: Brdn Org Objid
Numeric 12
If the transaction record is a burden transaction, this field stores the OBJ-ID of the transaction that this burden transaction was created from.
AC190 AC197
AC198 AC310
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR41.1
BR41.4 BR43.1
BR46.1 BR46.2
BR46.4
ATN-ORIG-OBJ-ID
Element: Orig Obj Id
Numeric 12
This field is used with the Databasics 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.
AC310 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
EX175 EX542
ATN-BILLED-AMT
Element: Intl Amt
Signed 18.2
AC310 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-REVENUE-AMT
Element: Intl Amt
Signed 18.2
AC145 AC190
AC197 AC198
AC310 AC45.1
AC540 BR142
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.3 BR40.4
BR41.1 BR41.4
BR42.1 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
EX175 EX542
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-EXPENSE-CODE
Element: Expense Code
Alpha 20
AC310 BR41.1
BR41.4 BR43.1
EX175 EX542
ATN-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
AC310 BR40.3
BR40.4 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4
ATN-COMMENT-CD
Element: Comment Cd
Numeric 3
This is the number representing a comment relating to the transaction.
AC310 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
CX05.1 CX30.1
GL199
ATN-AP-PAID
Element: Ap Paid
Alpha 1

" " = Eligible for Billing
H = Hold for Billing
AC190 AC310
AC42.1 AC540
AP125 AP126
AP178 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR41.1
BR41.4 BR43.1
BR46.1 BR46.2
BR46.4 EX542
IFGT.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA61.1
MA70.1 MA75.1
MAI1.1
ATN-QUICK-POST-FL
Element: Quick Post Fl
Alpha 1

Y = Yes
N = No
AC145 AC190
AC197 AC198
AC310 AC45.1
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR41.1
BR41.4 BR43.1
BR46.1 BR46.2
BR46.4
ATN-TRANSFER-FL
Element: Transfer Fl
Alpha 1

Y = Yes
N = No
T = Transferred
AC310 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR44.1 BR46.1
BR46.2 BR46.4
ATN-TRANSFER-AMT
Element: Adj Amt
Signed 18.2
AC310 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4
ATN-BILL-MTHD
Element: Billing Method
Numeric 1
AC145 AC190
AC310 AC45.1
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4
ATN-REV-MTHD
Element: Rev Mthd
Alpha 1
AC145 AC190
AC310 AC45.1
BR190 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4
ATN-REV-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AC310 BR130
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
ATN-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC108 AC120
AC131 AC145
AC190 AC191
AC196 AC197
AC198 AC310
AC311 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 CX05.1
CX30.1 EX175
EX542 IFGT.1
ATN-HOLD-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AC310 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4
ATN-CAPITALIZABLE
Element: Capitalizable
Alpha 1

N = No
Y = Yes
H = Hold
" " = No
AC169 AC190
AC310 AC45.1
AC69.1 AC704
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
ATN-COMMENTS-FLAG
Element: Flag
Alpha 1

Y = Yes
N = No
AC310 AC540
EX175 EX542
ATN-CATEGORY-TYPE
Element: Category Type
Alpha 1

A = Accrual
C = Cost
P = Pass Thru
R = Revenue
AC108 AC120
AC131 AC145
AC190 AC191
AC196 AC197
AC198 AC310
AC311 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
AC580 AC581
AC583 ACDR.1
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
CX05.1 CX30.1
IFGT.1
ATN-OPERATOR
Element: Operator
Alpha 10
AC108 AC120
AC131 AC145
AC190 AC191
AC196 AC197
AC198 AC310
AC311 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC540
AC580 AC581
AC583 ACDR.1
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
CX05.1 CX30.1
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1


ACTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATNSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
...
AC00.1 AC08.3
AC08.7 AC10.1
AC10.6 AC108
AC112 AC12.1
AC120 AC145
AC190 AC191
AC196 AC256
AC300 AC310
AC311 AC45.1
AC50.1 AC56.1
AC560 AC580
AC581 AC583
ACBD.2 ACDR.1
BR130 BR131
BR140 BR153
ATNSET10 ACTIVITY-GRP
VAR-LEVELS
STATUS
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
OBJ-ID
KeyChange, Subset
Where(STATUS !=Zeroes)
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC295 AC297
AC32.1 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 AC490
AC540 AC90.2
AC90.4 AC90.6
AC90.8 AC95.2
AC95.4 AC95.6
AC97.2 AC97.4
ATNSET11 ACCT-CATEGORY
OBJ-ID
KeyChange, Subset
Where(STATUS =1)
AC195
ATNSET12 OBJ-ID
...
AC145 AC160
AC169 AC191
AC195 AC197
AC198 AC300
AC310 AC42.1
AC45.1 AC540
AC704 AP125
AP126 AP175
AP178 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
ATNSET13 ACTIVITY
ACCT-CATEGORY
POSTING-DATE
SYSTEM
SOURCE-CODE
OBJ-ID
KeyChange
AC10.1 AC19.1
AC256 AC50.1
AC56.1 AC560
AC96.1 AC96.2
AC96.4 AC96.5
BR10.1 BR44.1
BR96.1
ATNSET14 GLT-OBJ-ID
OBJ-ID
KeyChange
AC108 AC120
AC145 AC190
AC191 AC196
AC311 AC45.1
AC580 AC581
AC583 ACDR.1
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATNSET2 STATUS
SUM-ACCT-CAT
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
OBJ-ID
KeyChange
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC240 AC295
AC32.1 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 AC490
AC540 AC90.2
AC90.4 AC90.6
AC90.8 AC95.2
AC95.4 AC95.6
AC97.2 AC97.4
ATNSET3 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
POSTING-DATE
OBJ-ID
KeyChange, Subset
Where(STATUS =1)
...
AC121 AC123
AC130 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC295
AC32.1 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC45.4 AC46.1
AC490 AC540
AC90.2 AC90.4
AC90.6 AC90.8
AC95.2 AC95.4
AC95.6 AC97.2
ATNSET4 ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
OBJ-ID
KeyChange, Subset
Where(STATUS =9)
...
AC10.1 AC112
AC12.1 AC145
AC160 AC169
AC191 AC197
AC290 AC310
AC440 AC460
AC471 AC490
AC50.1 AC69.1
AC704 ACDR.1
BR142 BR19.1
BR190 BR40.1
BR40.3 BR40.4
BR42.1 BR430
BR450 BR515
BR516 BR580
ATNSET7 CONTROL-GROUP
SEQUENCE-NBR
TRAN-CURRENCY
OBJ-ID
ACTIVITY-GRP
KeyChange, Subset
Where(STATUS =Zeroes)
AC195 AC240
AC40.1 AC40.3
AC40.4 AC40.6
AC41.1 AC41.3
AC41.4 AC41.6
AC42.1 AC45.4
BR41.1 BR41.4
BR43.1
ATNSET8 ACTIVITY
ACCT-CATEGORY
TRAN-CURRENCY
UNIT-MEASURE
MATRIX-CAT
MX-VALUE
POSTING-DATE
OBJ-ID
KeyChange, Subset
Where((BILLABLE ="Y")
Or(BILLABLE ="H"))
And((REVENUE-FLAG !="Y")
Or(BILLED !="Y"))
AC10.1 AC112
AC12.1 AC50.1
BR120 BR121
BR122 BR123
BR130 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
BR530
ATNSET9 OBJ-ID
ACTIVITY-GRP
ACTIVITY
CONTROL-GROUP
SEQUENCE-NBR
KeyChange
AC256 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
BR41.1 BR41.4
IFGT.1


ACTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
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
Actransbod ACTRANSBOD Not Required, Delete Cascades
ATN-ACTIVITY-GRP->YAO-ACTIVITY-GRP
ATN-ACTIVITY->YAO-ACTIVITY
ATN-ACCT-CATEGORY->YAO-ACCT-CATEGORY
ATN-COMPANY->YAO-COMPANY
ATN-ACCT-UNIT->YAO-ACCT-UNIT
ATN-ACCOUNT->YAO-ACCOUNT
ATN-SUB-ACCOUNT->YAO-SUB-ACCOUNT
ATN-OBJ-ID->YAO-OBJ-ID
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
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
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-OBJ-ID
  HDT-LINE-NBR
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
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
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


File created: Thu Jun 09 02:03:19 2016

Home
Contact Us



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