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 AC56.1 AC560 BR131
BR153 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 AP170 AP193 CB10.1
CB15.1 CB15.2 CB150 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 EE135 EE20.3 EE35.1 EE35.2 EE520
GL165 GL170 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 MA65.1 POIG.1 BR02.3 BR253
BR450 BR52.3 BR53.1 AC19.1 AC240 AC96.1
AC96.2 AC96.4 BR10.1 PW110 ACDL.1 SNAC.1
AC290 AC440 AC460 AC471 AC490 BR19.1
BR515 BR516 BR580
UPDATED BY
AC108 AC120 AC131 AC145 AC160 AC169
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
AC69.1 AC704 AC902 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
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
ET175 ET540 ET542 GL146 GL197 GL199
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 IFGT.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.2 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 ET175
ET540 ET542
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 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
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 Project BRIP.1 ET175
Accounting to the subsystems. ET540 ET542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
ATN-TRANS-TYPE Alpha 1 AC131 AC190
Element: Transaction TyThis field determines if amounts or AC310 AC40.1
units are processed in the transaction. AC40.4 AC41.1
A = Activity Management Only AC41.4 AC42.1
B = AC side of AC and GL trans AC540 BR41.1
I = Interface BR41.4 BR43.1
G = GL side of AC and GL trans BR530 BRIP.1
T = Time Entry ET175 ET540
ET542 IFGT.1
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 ET175
ET540 ET542
IFGT.1
ATN-FROM-COMPANY Numeric 4 AC131 AC190
Element: From Company Identifies the AP company if the AC197 AC198
resource type = V. Identifies the HR AC310 AC40.1
company if the resource type = E. It is AC40.4 AC41.1
blank for type A, P or Q resources. AC41.4 AC42.1
AC540 BR40.3
BR41.1 BR41.4
BR43.1 BR46.1
BR530 BRIP.1
ET175 ET540
ET542 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 ET175
ET540 ET542
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
ET175 ET540
ET542 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 ET175
ET540 ET542
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 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
ET175 ET540
ET542 GL146
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
ET175 ET540
ET542 IFGT.1
ATN-POSTING-DATE Numeric 8 (yyyymmdd) AC131 AC190
Element: Posting Date For an Project Accounting 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
ET175 ET540
ET542 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 ET175
ET540 ET542
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 ET175
ET540 ET542
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 ET175
ET540 ET542
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 ET175
ET540 ET542
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
ET175 ET540
ET542 IFGT.1
ATN-REFERENCE Alpha 10 (Lower Case) AC131 AC190
Element: Reference This is the reference for this AC197 AC198
transaction. 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 ET175
ET540 ET542
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
ET175 ET540
ET542 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
ET175 ET540
ET542 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
ET175 ET540
ET542 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
ET175 ET540
ET542 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
ET175 ET540
ET542 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 ET175
ET540 ET542
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
ET175 ET540
ET542 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 ET175
ET540 ET542
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 ET175
ET540 ET542
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 ET175
ET540 ET542
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
ET175 ET540
ET542 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 ET175
ET540 ET542
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
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
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
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 ET175
ET540 ET542
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
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 ET175
ET540 ET542
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 ET175
ET540 ET542
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 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR40.4 BR41.1
BR41.4 BR43.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 ET540
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
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
ET175 ET540
ET542 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 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
GL146 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
ET175 ET540
ET542 GL146
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
ET540 GL146
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 BR20.1
billing units values are defined for BR20.2 BR20.3
this transaction by the client versus BR20.4 BR20.5
being calculated by the billing BR40.3 BR40.4
programs. If this flag is Yes, the BR41.1 BR41.4
billing amount and unit will not be BR43.1 BR44.1
initialized if the transaction is backed BR46.1 BR46.2
out. BR46.4 BR530
BRIP.1 ET175
The default is Blank, which also means ET540 ET542
No. GL199
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 BR40.3
BR40.4 BR41.1
BR41.4 BR42.1
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL146 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 BR20.1
Y = Yes BR20.2 BR20.3
N = No BR20.4 BR20.5
BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
GL146 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 ET540
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 ET540
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
ET175 ET540
ET542 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 AC902
BR40.3 BR41.1
BR41.4 BR43.1
BR46.1 BR530
BRIP.1 ET175
ET540 ET542
GL199 IFGT.1
ATN-RESOURCE-DESC Alpha 30 (Lower Case) AC190 AC191
Element: Description This field displays the description. AC197 AC198
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC540
BR40.3 BR41.1
BR41.4 BR43.1
BR530 BRIP.1
ET175 ET540
ET542 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 ET175
ET540 ET542
GL199
ATN-GLT-OBJ-ID Numeric 12 BR20.1 BR20.2
Element: Obj Id This is a subsystem-General Ledger BR20.3 BR20.4
interface identification number. It is BR20.5 BR41.1
used for Drill Around purposes. BR41.4 BR43.1
BR46.1 BR46.2
BR46.4 BR530
BRIP.1 ET175
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 ET175
ET540 ET542
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 ET175
ET540 ET542
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 BR20.1 BR20.2
added, this value is No. BR20.3 BR20.4
Y = Yes BR20.5 BR41.1
BR41.4 BR43.1
BR46.1 BR46.2
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 BR20.1 BR20.2
is reconciled, the value in this field BR20.3 BR20.4
is No. BR20.5 BR41.1
Y = Yes BR41.4 BR43.1
N = No BR46.1 BR46.2
BR46.4 BR530
BRIP.1 GL199
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 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 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
ET175 ET540
ET542 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. AC310 AC40.1
The exchange rate is defined in CU10.1 AC40.4 AC41.1
(Exchange Rate). AC41.4 AC42.1
AC540 AC581
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 ET175
ET540 ET542
IFGT.1
ATN-RPT-ND-1 Numeric 1 AC131 AC190
Element: Acct Nd The number of decimals assigned to a AC197 AC198
particular account as determined by the AC310 AC40.1
account currency. 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 ET175
ET540 ET542
IFGT.1
ATN-RPT-AMOUNT-2 Signed 18.2 AC131 AC190
Element: Intl Amt 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 BR41.1
BR41.4 BR43.1
BR44.1 BR46.1
BR46.2 BR46.4
BR530 BRIP.1
ET175 ET540
ET542 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 1. AC310 AC40.1
The exchange rate is defined in CU10.1 AC40.4 AC41.1
(Exchange Rate). AC41.4 AC42.1
AC540 AC581
BR40.3 BR41.1
BR41.4 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 ET175
ET540 ET542
IFGT.1
ATN-RPT-ND-2 Numeric 1 AC131 AC190
Element: Acct Nd The number of decimals assigned to a AC197 AC198
particular account as determined by the AC310 AC40.1
account currency. 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 ET175
ET540 ET542
IFGT.1
ATN-BRDN-ORG-OBJID Numeric 12 AC190 AC197
Element: Brdn Org ObjidIf the transaction record is a burden AC198 BR20.1
transaction, this field stores the BR20.2 BR20.3
OBJ-ID of the transaction that this BR20.4 BR20.5
burden transaction was created from. BR41.1 BR41.4
BR43.1 BR46.1
BR46.2 BR46.4
ATN-ORIG-OBJ-ID Numeric 12 BR20.1 BR20.2
Element: Orig Obj Id This field is used with the Databasics BR20.3 BR20.4
time interface program (DI542) and in BR20.5 BR41.1
some Payroll libraries. It is used for BR41.4 BR43.1
adjustment transactions to link them BR46.1 BR46.2
back to the original transaction that is BR46.4 ET175
being adjusted. ET540 ET542
ATN-BILLED-AMT Signed 18.2 BR20.1 BR20.2
Element: Intl Amt 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 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 ET540
GL146 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 ET175
ET542
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 Cd This is the number representing a BR43.1 BR530
comment relating to the transaction. BRIP.1 GL199
ATN-AP-PAID Alpha 1 AC190 AC42.1
Element: Ap Paid " " = Eligible for Billing AC540 AP125
H = Hold for Billing 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
ET540 ET542
IFGT.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MAI1.1
ATN-QUICK-POST-FL Alpha 1 AC145 AC190
Element: Quick Post Fl Y = Yes AC197 AC198
N = No 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 Alpha 1 BR20.1 BR20.2
Element: Transfer Fl Y = Yes BR20.3 BR20.4
N = No BR20.5 BR44.1
T = Transferred BR46.1 BR46.2
BR46.4
ATN-TRANSFER-AMT Signed 18.2 BR20.1 BR20.2
Element: Adj Amt BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
ATN-BILL-MTHD Numeric 1 AC145 AC190
Element: Billing Method AC45.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR46.1 BR46.2
BR46.4
ATN-REV-MTHD Alpha 1 AC145 AC190
Element: Rev Mthd AC45.1 BR190
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
ATN-REV-OBJ-ID Numeric 12 BR130 BR20.1
Element: Obj Id This is the object identifier. It is BR20.2 BR20.3
used to relate commitments or posted BR20.4 BR20.5
transactions back to the originating BR46.1 BR46.2
subsystems. Each subsystem record that BR46.4 BR530
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.
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 BR43.1
BR44.1 BR46.2
BR46.4 BR530
BRIP.1 ET175
ET540 ET542
IFGT.1
ATN-HOLD-OBJ-ID Numeric 12 BR20.1 BR20.2
Element: Obj Id This is the object identifier. It is BR20.3 BR20.4
used to relate commitments or posted BR20.5 BR46.1
transactions back to the originating BR46.2 BR46.4
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.
ATN-CAPITALIZABLE Alpha 1 AC169 AC190
Element: Capitalizable N = No AC45.1 AC69.1
Y = Yes AC704 BR20.1
H = Hold BR20.2 BR20.3
" " = No BR20.4 BR20.5
BR46.1 BR46.2
BR46.4
ATN-COMMENTS-FLAG Alpha 1 AC540 ET175
Element: Flag Y = Yes ET540 ET542
N = No
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 AC190 AC191
SUB-ACCOUNT AC256 AC300
OBJ-ID AC310 AC45.1
AC50.1 AC56.1
AC560 AC580
AC581 AC583
ACDR.1 BR130
BR131 BR140
BR153 BR42.1
BR430 BR530
...
ATNSET10 ACTIVITY-GRP KeyChange, Subset AC295 AC40.1
VAR-LEVELS Where (STATUS != Zeroes ) AC40.4 AC41.1
STATUS AC41.4 AC42.1
ACCT-CATEGORY AC45.4 AC46.1
FISCAL-YEAR AC90.2 AC90.4
PERIOD AC90.6 AC90.8
OBJ-ID AC95.2 AC95.4
AC95.6 ACAC.1
ACVW.1 SE90.1
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR41.1 BR41.4
...
ATNSET11 ACCT-CATEGORY KeyChange, Subset AC195
OBJ-ID Where (STATUS = 1 )
ATNSET12 OBJ-ID AC145 AC160
AC169 AC191
AC195 AC197
AC198 AC300
AC42.1 AC45.1
AC540 AC704
AC902 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
...
ATNSET13 ACTIVITY KeyChange AC10.1 AC19.1
ACCT-CATEGORY AC240 AC256
POSTING-DATE AC50.1 AC56.1
SYSTEM AC560 AC96.1
SOURCE-CODE AC96.2 AC96.4
OBJ-ID BR10.1 BR44.1
BR96.1 PW110
ATNSET14 GLT-OBJ-ID KeyChange GL146 GL197
OBJ-ID 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 AC45.4 AC46.1
ACCT-CATEGORY AC90.2 AC90.4
OBJ-ID AC90.6 AC90.8
AC95.2 AC95.4
AC95.6 ACAC.1
ACVW.1 SE90.1
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR41.1 BR41.4
...
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 AC45.4 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 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
...
ATNSET4 ACTIVITY KeyChange, Subset AC10.1 AC112
ACCT-CATEGORY Where (STATUS = 9 ) AC12.1 AC145
FISCAL-YEAR AC160 AC169
PERIOD AC191 AC197
OBJ-ID AC290 AC310
AC440 AC460
AC471 AC490
AC50.1 AC69.1
AC704 AC902
ACDR.1 BR142
BR19.1 BR190
BR40.1 BR40.3
BR40.4 BR42.1
BR430 BR450
BR515 BR516
...
ATNSET7 CONTROL-GROUP KeyChange, Subset AC195 AC240
SEQUENCE-NBR Where (STATUS = Zeroes ) AC40.1 AC40.3
TRAN-CURRENCY AC40.4 AC40.6
OBJ-ID AC41.1 AC41.3
ACTIVITY-GRP AC41.4 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 BR123
MATRIX-CAT Or (BILLED != "Y" )) BR130 BR140
MX-VALUE BR151 BR152
POSTING-DATE BR156 BR20.1
OBJ-ID BR20.2 BR20.3
BR20.4 BR20.5
BR420 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
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
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
|