ACTRANS – Activity Transaction

System
Activity Management (AC)
Prefix
ATN
Primary key
ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID
Fields
81
Updated by
379 programs
Referenced by
24 programs

ACTRANS is the Activity Transaction table in Lawson Activity Management (prefix ATN). It is indexed by ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID (ATNSET1); alternate indexes: ATNSET10, ATNSET11, ATNSET12, ATNSET13, ATNSET14, ATNSET2, ATNSET3, ATNSET4 and 3 more. It is related 1:1 to ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACASSIGN, ACCUAMT, ACMASTER, ACTRANSBOD and 8 more and 1:M to ACBRDNADTR, ACCLGTRANS, ACDEFREV, ACHISTDTL, ACMNTSCHX, ACMXVAL, ACPMHSTDTL, AMTRANS and 9 more. It is updated by AC00.1, AC08.3, AC08.7, AC10.1, AC10.6, AC108, AC112, AC12.1 and 371 more and referenced by AC19.1, AC256, AC290, AC297, AC440, AC460, AC471, AC96.1 and 16 more. The table has 81 fields, 12 indexes and 36 documented relations.

About ACTRANS

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).

Fields (81)

Column = COBOL field name without the ATN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ATN-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15Required key. This is the activity group for the transaction.AC120, AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4 +20 more
ATN-CONTROL-GROUP
CONTROL_GROUP
Numeric 8Required 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 +8 more
ATN-SEQUENCE-NBR
SEQUENCE_NBR
Numeric 4Required 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 +16 more
ATN-OBJ-ID PK
OBJ_ID
Numeric 12Required 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 +34 more
ATN-TRANS-TYPE
TRANS_TYPE
Alpha 1This 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 +11 more
ATN-COMPANY PK
COMPANY
Numeric 4This is the responsible company.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +14 more
ATN-FROM-COMPANY
FROM_COMPANY
Numeric 4Identifies 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 +15 more
ATN-TRAN-DATE
TRAN_DATE
Numeric 8 (yyyymmdd)This is the date the transaction is posted.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +15 more
ATN-ACTIVITY PK
ACTIVITY
Alpha 15This is the activity for the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +19 more
ATN-VAR-LEVELS
VAR_LEVELS
Alpha 30This is the variable level for the transaction.AC120, AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4 +20 more
ATN-STATUS
STATUS
Numeric 1The 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 +37 more
ATN-ACCT-CATEGORY PK
ACCT_CATEGORY
Alpha 5This is the account category for the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +19 more
ATN-POSTING-DATE
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 +16 more
ATN-SYSTEM
SYSTEM
Alpha 2This is the system in which this transaction originated.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +14 more
ATN-ACCT-UNIT PK
ACCT_UNIT
Alpha 15This is the general ledger accounting unit for the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +14 more
ATN-ACCOUNT PK
ACCOUNT
Numeric 6This 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 +14 more
ATN-SUB-ACCOUNT PK
SUB_ACCOUNT
Numeric 4This is the general ledger subaccount for the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +14 more
ATN-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the description of the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +17 more
ATN-REFERENCE
REFERENCE
Alpha 10 (Lower Case)This is the reference for this transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +16 more
ATN-UNITS-AMOUNT
UNITS_AMOUNT
Signed 15.2This is the units amount for this transaction.AC131, AC310, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.1 +25 more
ATN-TRAN-CURRENCY
TRAN_CURRENCY
Alpha 5This is the currency for the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +13 more
ATN-TRAN-AMOUNT
TRAN_AMOUNT
Signed 18.2This is the amount in transaction currency.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +31 more
ATN-TRAN-ND
TRAN_ND
Numeric 1This field indicates the defined number of decimal positions used for the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +13 more
ATN-ACT-CURRENCY
ACT_CURRENCY
Alpha 5This is the activity currency.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +17 more
ATN-ACT-BASERATE
ACT_BASERATE
Signed 14.7This is the rate that converts the transaction amount to the activity amount.AC131, AC190, AC197, AC198, AC40.1, AC40.4, AC41.1, AC41.4 +17 more
ATN-ACT-AMOUNT
ACT_AMOUNT
Signed 18.2This is the amount for the activity.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +31 more
ATN-ACT-ND
ACT_ND
Numeric 1This is the number of decimals for the activity.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +18 more
ATN-AG-CURRENCY
AG_CURRENCY
Alpha 5This is the currency for the activity group.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +18 more
ATN-AG-BASERATE
AG_BASERATE
Signed 14.7This 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 +17 more
ATN-AG-AMOUNT
AG_AMOUNT
Signed 18.2This is the amount for the activity group for this transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +31 more
ATN-AG-ND
AG_ND
Numeric 1This is the number of decimals for the activity group.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +18 more
ATN-BILL-DATE
BILL_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 +26 more
ATN-RUN-DATE
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 +25 more
ATN-RUN-TIME
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 +25 more
ATN-SOURCE-CODE
SOURCE_CODE
Alpha 2This 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 +16 more
ATN-BILL-RATE
BILL_RATE
Signed 13.4This is the billing rate for the transaction.AC131, AC145, AC190, AC310, AC40.1, AC40.4, AC41.1, AC41.4 +22 more
ATN-BILLABLE
BILLABLE
Alpha 1This 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 +27 more
ATN-BILLED
BILLED
Alpha 1This 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 +46 more
ATN-BILLABLE-AMT
BILLABLE_AMT
Signed 18.2This is the billable amount for the transaction.AC131, AC145, AC190, AC197, AC198, AC310, AC40.1, AC40.4 +38 more
ATN-BILLABLE-UNIT
BILLABLE_UNIT
Signed 15.2This is the number of billable units for the transaction.AC131, AC145, AC190, AC310, AC40.1, AC40.4, AC41.1, AC41.4 +35 more
ATN-OVERRIDE-FLAG
OVERRIDE_FLAG
Alpha 1This 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 +23 more
ATN-REVENUE-FLAG
REVENUE_FLAG
Alpha 1This 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 +36 more
ATN-CAPITALIZE-FLG
CAPITALIZE_FLG
Alpha 1This 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 +30 more
ATN-MATRIX-CAT
MATRIX_CAT
Alpha 12Activity 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 +14 more
ATN-MX-VALUE
MX_VALUE
Alpha 32This 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 +14 more
ATN-RESOURCE-TYPE
RESOURCE_TYPE
Alpha 1This 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 +16 more
ATN-RESOURCE-CODE
RESOURCE_CODE
Alpha 10This is the resource code associated with the transaction.AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +16 more
ATN-RESOURCE-DESC
RESOURCE_DESC
Alpha 30 (Lower Case)This field displays the description.AC190, AC191, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +15 more
ATN-UNIT-MEASURE
UNIT_MEASURE
Alpha 12This is the unit of measure for the transaction.AC131, AC310, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC540 +12 more
ATN-GLT-OBJ-ID
GLT_OBJ_ID
Numeric 12This 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 +11 more
ATN-PERIOD
PERIOD
Numeric 2This is the period for the transaction.AC108, AC120, AC131, AC145, AC190, AC191, AC195, AC196 +30 more
ATN-FISCAL-YEAR
FISCAL_YEAR
Numeric 4This is the fiscal year for the transaction.AC108, AC120, AC131, AC145, AC190, AC191, AC195, AC196 +30 more
ATN-AC191-UPDATED
AC191_UPDATED
Alpha 1This 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 +20 more
ATN-RECONCILED
RECONCILED
Alpha 1This 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 +17 more
ATN-SEGMENT-FLAG
SEGMENT_FLAG
Alpha 1Indicates 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 +9 more
ATN-RPT-AMOUNT-1
RPT_AMOUNT_1
Signed 18.2AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +32 more
ATN-RPT-RATE-1
RPT_RATE_1
Signed 14.7The 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 +18 more
ATN-RPT-ND-1
RPT_ND_1
Numeric 1The 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 +19 more
ATN-RPT-AMOUNT-2
RPT_AMOUNT_2
Signed 18.2AC131, AC190, AC197, AC198, AC310, AC40.1, AC40.4, AC41.1 +32 more
ATN-RPT-RATE-2
RPT_RATE_2
Signed 14.7The 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 +18 more
ATN-RPT-ND-2
RPT_ND_2
Numeric 1The 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 +19 more
ATN-BRDN-ORG-OBJID
BRDN_ORG_OBJID
Numeric 12If 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 +7 more
ATN-ORIG-OBJ-ID
ORIG_OBJ_ID
Numeric 12This 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 +6 more
ATN-BILLED-AMT
BILLED_AMT
Signed 18.2AC310, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2 +10 more
ATN-REVENUE-AMT
REVENUE_AMT
Signed 18.2AC145, AC190, AC197, AC198, AC310, AC45.1, AC540, BR142 +27 more
ATN-EXPENSE-CODE
EXPENSE_CODE
Alpha 20AC310, BR41.1, BR41.4, BR43.1, EX175, EX542
ATN-REASON-CODE
REASON_CODE
Alpha 4This 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 +1 more
ATN-COMMENT-CD
COMMENT_CD
Numeric 3This is the number representing a comment relating to the transaction.AC310, BR41.1, BR41.4, BR43.1, BR530, BRIP.1, CX05.1, CX30.1 +1 more
ATN-AP-PAID
AP_PAID
Alpha 1" " = Eligible for Billing
  • H Hold for Billing
AC190, AC310, AC42.1, AC540, AP125, AP126, AP178, AP20.1 +41 more
ATN-QUICK-POST-FL
QUICK_POST_FL
Alpha 1
  • Y Yes
  • N No
AC145, AC190, AC197, AC198, AC310, AC45.1, BR20.1, BR20.2 +9 more
ATN-TRANSFER-FL
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 +2 more
ATN-TRANSFER-AMT
TRANSFER_AMT
Signed 18.2AC310, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2 +1 more
ATN-BILL-MTHD
BILL_MTHD
Numeric 1AC145, AC190, AC310, AC45.1, BR190, BR20.1, BR20.2, BR20.3 +5 more
ATN-REV-MTHD
REV_MTHD
Alpha 1AC145, AC190, AC310, AC45.1, BR190, BR20.1, BR20.2, BR20.3 +5 more
ATN-REV-OBJ-ID
REV_OBJ_ID
Numeric 12This 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 +2 more
ATN-SUM-ACCT-CAT
SUM_ACCT_CAT
Alpha 5The name of the summary account category.AC108, AC120, AC131, AC145, AC190, AC191, AC196, AC197 +28 more
ATN-HOLD-OBJ-ID
HOLD_OBJ_ID
Numeric 12This 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 +1 more
ATN-CAPITALIZABLE
CAPITALIZABLE
Alpha 1" " = No
  • N No
  • Y Yes
  • H Hold
AC169, AC190, AC310, AC45.1, AC69.1, AC704, BR20.1, BR20.2 +6 more
ATN-COMMENTS-FLAG
COMMENTS_FLAG
Alpha 1
  • Y Yes
  • N No
AC310, AC540, EX175, EX542
ATN-CATEGORY-TYPE
CATEGORY_TYPE
Alpha 1
  • A Accrual
  • C Cost
  • P Pass Thru
  • R Revenue
AC108, AC120, AC131, AC145, AC190, AC191, AC196, AC197 +27 more
ATN-OPERATOR
OPERATOR
Alpha 10AC108, AC120, AC131, AC145, AC190, AC191, AC196, AC197 +42 more

Indexes (12)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATNSET1ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-IDPrimaryAC00.1, AC08.3, AC08.7, AC10.1, AC10.6, AC108, AC112, AC12.1 +22 more (list truncated in source)
ATNSET10ACTIVITY-GRP, VAR-LEVELS, STATUS, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, OBJ-IDKeyChange, SubsetWhere (STATUS != Zeroes)AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
ATNSET11ACCT-CATEGORY, OBJ-IDKeyChange, SubsetWhere (STATUS = 1)AC195
ATNSET12OBJ-IDAC145, AC160, AC169, AC191, AC195, AC197, AC198, AC300 +22 more (list truncated in source)
ATNSET13ACTIVITY, ACCT-CATEGORY, POSTING-DATE, SYSTEM, SOURCE-CODE, OBJ-IDKeyChangeAC10.1, AC19.1, AC256, AC50.1, AC56.1, AC560, AC96.1, AC96.2 +5 more
ATNSET14GLT-OBJ-ID, OBJ-IDKeyChangeAC108, AC120, AC145, AC190, AC191, AC196, AC311, AC45.1 +14 more
ATNSET2STATUS, SUM-ACCT-CAT, ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, OBJ-IDKeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
ATNSET3ACTIVITY-GRP, ACTIVITY, ACCT-CATEGORY, POSTING-DATE, OBJ-IDKeyChange, SubsetWhere (STATUS = 1)AC121, AC123, AC130, AC190, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
ATNSET4ACTIVITY, ACCT-CATEGORY, FISCAL-YEAR, PERIOD, OBJ-IDKeyChange, SubsetWhere (STATUS = 9)AC10.1, AC112, AC12.1, AC145, AC160, AC169, AC191, AC197 +22 more (list truncated in source)
ATNSET7CONTROL-GROUP, SEQUENCE-NBR, TRAN-CURRENCY, OBJ-ID, ACTIVITY-GRPKeyChange, SubsetWhere (STATUS = Zeroes)AC195, AC240, AC40.1, AC40.3, AC40.4, AC40.6, AC41.1, AC41.3 +7 more
ATNSET8ACTIVITY, ACCT-CATEGORY, TRAN-CURRENCY, UNIT-MEASURE, MATRIX-CAT, MX-VALUE, POSTING-DATE, OBJ-IDKeyChange, SubsetWhere ((BILLABLE = "Y") Or (BILLABLE = "H")) And ((REVENUE-FLAG != "Y") Or (BILLED != "Y"))AC10.1, AC112, AC12.1, AC50.1, BR120, BR121, BR122, BR123 +13 more
ATNSET9OBJ-ID, ACTIVITY-GRP, ACTIVITY, CONTROL-GROUP, SEQUENCE-NBRKeyChangeAC256, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, BR41.1, BR41.4 +1 more

Relations

One to one (17) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequiredATN-ACCT-CATEGORYAAX-ACCT-CATEGORY
Acacctcat ErrACACCTCATNot RequiredATN-ACCT-CATEGORYAAX-ACCT-CATEGORY
AcacctcatxACACCTCATXNot RequiredATN-ACTIVITY-GRPAXX-ACTIVITY-GRP, ATN-ACTIVITYAXX-ACTIVITY, ATN-ACCT-CATEGORYAXX-ACCT-CATEGORY
AcactgrpACACTGRPRequiredATN-ACTIVITY-GRPAGP-ACTIVITY-GRP
AcactivityACACTIVITYRequiredATN-ACTIVITYACV-ACTIVITY
AcassignACASSIGNNot RequiredATN-ACTIVITY-GRPAAN-ACTIVITY-GRP, ATN-ACTIVITYAAN-ACTIVITY, ATN-FROM-COMPANYAAN-COMPANY, ATN-RESOURCE-TYPEAAN-RESOURCE-TYPE, ATN-RESOURCE-CODEAAN-RESOURCE-CODE
AccuamtACCUAMTNot RequiredValid When ACV-CURRENCY-CODE != ATN-CURRENCY-CODEATN-ACTIVITY-GRPACU-ACTIVITY-GRP, ATN-ACTIVITYACU-ACTIVITY, ATN-ACT-CURRENCYACU-CURRENCY-CODE, ZeroesACU-BUDGET-NBR, ATN-FISCAL-YEARACU-FISCAL-YEAR, ATN-ACCT-CATEGORYACU-ACCT-CATEGORY
AcmasterACMASTERNot RequiredATN-ACTIVITY-GRPMST-ACTIVITY-GRP, ATN-ACTIVITYMST-ACTIVITY, ATN-ACCT-CATEGORYMST-ACCT-CATEGORY, ATN-FISCAL-YEARMST-FISCAL-YEAR
ActransbodACTRANSBODNot Required, Delete CascadesATN-ACTIVITY-GRPYAO-ACTIVITY-GRP, ATN-ACTIVITYYAO-ACTIVITY, ATN-ACCT-CATEGORYYAO-ACCT-CATEGORY, ATN-COMPANYYAO-COMPANY, ATN-ACCT-UNITYAO-ACCT-UNIT, ATN-ACCOUNTYAO-ACCOUNT, ATN-SUB-ACCOUNTYAO-SUB-ACCOUNT, ATN-OBJ-IDYAO-OBJ-ID
ActransegACTRANSEGNot RequiredATN-OBJ-IDTSG-OBJ-ID
ActranserrACTRANSERRNot RequiredATN-OBJ-IDTER-OBJ-ID
AmassetAMASSETNot RequiredValid When ATN-RESOURCE-TYPE = "A"AAN-EMPLOYEE-ASSETAST-ASSET
GlnamesGLNAMESRequiredATN-FROM-COMPANYGLN-COMPANY, ATN-ACCT-UNITGLN-ACCT-UNIT
GlsystemGLSYSTEMRequiredATN-COMPANYGLS-COMPANY
GltransGLTRANSNot RequiredATN-GLT-OBJ-IDGLT-OBJ-ID
OeinvclineOEINVCLINENot RequiredATN-OBJ-IDOIL-ATN-OBJ-ID
OeinvcmiscOEINVCMISCNot RequiredATN-OBJ-IDOIM-ATN-OBJ-ID

One to many (19) — child tables

RelationTableRulesConditionField map
AcbrdnadtrACBRDNADTRATN-OBJ-IDBAT-ATN-OBJ-ID, BAT-BURDEN-CD, BAT-BURDEN-TYPE, BAT-POOL-NBR
AcclgtransACCLGTRANSATN-OBJ-IDCGT-ATN-OBJ-ID, CGT-LEVEL
AcdefrevACDEFREVATN-GLT-OBJ-IDDRD-GLT-OBJ-ID, ATN-OBJ-IDDRD-ATN-OBJ-ID, DRD-CONTRACT, DRD-PRODUCT, DRD-PROD-VERSION, DRD-OBJ-ID, DRD-SEQ-NBR
AchistdtlACHISTDTLATN-OBJ-IDHDT-ATN-OBJ-ID, HDT-CONTRACT, HDT-OBJ-ID, HDT-LINE-NBR
AcmntschxACMNTSCHXATN-GLT-OBJ-IDMSD-GLT-OBJ-ID, ATN-OBJ-IDMSD-ATN-OBJ-ID, MSD-CONTRACT, MSD-MAINT-SCHEDULE, MSD-PRODUCT, MSD-PROD-VERSION, MSD-OBJ-ID, MSD-TRAN-DATE
AcmxvalACMXVALATN-OBJ-IDATV-OBJ-ID, ATV-MATRIX-CAT
AcpmhstdtlACPMHSTDTLATN-GLT-OBJ-IDPML-GLT-OBJ-ID, ATN-OBJ-IDPML-ATN-OBJ-ID, PML-OBJ-ID, PML-LINE-NBR
AmtransAMTRANSATN-OBJ-IDAMT-ATN-OBJ-ID, AMT-ASSET, AMT-SEQ-NUMBER, AMT-COMPANY
ApapdhistAPAPDHISTATN-OBJ-IDAH2-ATN-OBJ-ID, AH2-COMPANY, AH2-VENDOR, AH2-INVOICE, AH2-SUFFIX, AH2-CANCEL-SEQ, AH2-DIST-SEQ-NBR
ApdistribAPDISTRIBATN-OBJ-IDAPD-ATN-OBJ-ID, APD-COMPANY, APD-VENDOR, APD-INVOICE, APD-SUFFIX, APD-CANCEL-SEQ, APD-DIST-SEQ-NBR
ArdistribARDISTRIBATN-OBJ-IDAMD-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
CbdistribCBDISTRIBATN-OBJ-IDCBD-ACT-OBJ-ID, CBD-CASH-CODE, CBD-BANK-INST-CODE, CBD-TRANS-IDENT, CBD-DIST-TYPE, CBD-SEQ-NBR
EedistribEEDISTRIBATN-OBJ-IDEED-ACT-OBJ-ID, EED-COMPANY, EED-VENDOR, EED-EXPENSE-NBR, EED-SEQ-NBR
IcmmdistMMDISTValid When ATN-SYSTEM = "IC"ATN-OBJ-IDMMD-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
MmdistMMDISTATN-OBJ-IDMMD-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
OedistOEDISTATN-OBJ-IDODI-ATN-OBJ-ID, ODI-INVC-PREFIX, ODI-INVC-NUMBER, ODI-AUTH-NO, ODI-LINE-NBR, ODI-SEQ, ODI-POSTING-TYPE
PommdistMMDISTValid When ATN-SYSTEM = "PO"ATN-OBJ-IDMMD-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
PrdistribPRDISTRIBATN-FROM-COMPANYPRD-COMPANY, ATN-ACTIVITYPRD-ACTIVITY, ATN-OBJ-IDPRD-ATN-OBJ-ID, PRD-EMPLOYEE, PRD-OBJ-ID
SltransSLTRANSATN-GLT-OBJ-IDSLT-GLT-OBJ-ID, SLT-OBJ-ID

Programs

Updated by (379)

Referenced by (24)