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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET7 SET9
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 SET7 SET9
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 SET10
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 SET10 SET2
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 SET13 SET3 SET8
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 SET13
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 SET7 SET8
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 SET13
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 SET8
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 SET8
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 SET8
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 SET14
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 SET10 SET4
PERIOD		Numeric 2This is the period for the transaction.AC108, AC120, AC131, AC145, AC190, AC191, AC195, AC196 +30 more
#ATN-FISCAL-YEAR SET10 SET4
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.2—AC131, 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.2—AC131, 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.2—AC310, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2 +10 more
#ATN-REVENUE-AMT
REVENUE_AMT		Signed 18.2—AC145, AC190, AC197, AC198, AC310, AC45.1, AC540, BR142 +27 more
#ATN-EXPENSE-CODE
EXPENSE_CODE		Alpha 20—AC310, 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.2—AC310, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2 +1 more
#ATN-BILL-MTHD
BILL_MTHD		Numeric 1—AC145, AC190, AC310, AC45.1, BR190, BR20.1, BR20.2, BR20.3 +5 more
#ATN-REV-MTHD
REV_MTHD		Alpha 1—AC145, 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 SET2
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 10—AC108, AC120, AC131, AC145, AC190, AC191, AC196, AC197 +42 more

Indexes (12)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ATNSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. COMPANY
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
  8. OBJ-ID
PrimaryAC00.1, AC08.3, AC08.7, AC10.1, AC10.6, AC108, AC112, AC12.1 +22 more (list truncated in source)
ATNSET10
  1. ACTIVITY-GRP
  2. VAR-LEVELS
  3. STATUS
  4. ACCT-CATEGORY
  5. FISCAL-YEAR
  6. PERIOD
  7. OBJ-ID
KeyChange, SubsetWhere (STATUS != Zeroes)AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
ATNSET11
  1. ACCT-CATEGORY
  2. OBJ-ID
KeyChange, SubsetWhere (STATUS = 1)AC195
ATNSET12
  1. OBJ-ID
AC145, AC160, AC169, AC191, AC195, AC197, AC198, AC300 +22 more (list truncated in source)
ATNSET13
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. POSTING-DATE
  4. SYSTEM
  5. SOURCE-CODE
  6. OBJ-ID
KeyChangeAC10.1, AC19.1, AC256, AC50.1, AC56.1, AC560, AC96.1, AC96.2 +5 more
ATNSET14
  1. GLT-OBJ-ID
  2. OBJ-ID
KeyChangeAC108, AC120, AC145, AC190, AC191, AC196, AC311, AC45.1 +14 more
ATNSET2
  1. STATUS
  2. SUM-ACCT-CAT
  3. ACTIVITY-GRP
  4. ACTIVITY
  5. ACCT-CATEGORY
  6. OBJ-ID
KeyChangeAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
ATNSET3
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. POSTING-DATE
  5. OBJ-ID
KeyChange, SubsetWhere (STATUS = 1)AC121, AC123, AC130, AC190, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
ATNSET4
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. FISCAL-YEAR
  4. PERIOD
  5. OBJ-ID
KeyChange, SubsetWhere (STATUS = 9)AC10.1, AC112, AC12.1, AC145, AC160, AC169, AC191, AC197 +22 more (list truncated in source)
ATNSET7
  1. CONTROL-GROUP
  2. SEQUENCE-NBR
  3. TRAN-CURRENCY
  4. OBJ-ID
  5. ACTIVITY-GRP
KeyChange, SubsetWhere (STATUS = Zeroes)AC195, AC240, AC40.1, AC40.3, AC40.4, AC40.6, AC41.1, AC41.3 +7 more
ATNSET8
  1. ACTIVITY
  2. ACCT-CATEGORY
  3. TRAN-CURRENCY
  4. UNIT-MEASURE
  5. MATRIX-CAT
  6. MX-VALUE
  7. POSTING-DATE
  8. OBJ-ID
KeyChange, 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
ATNSET9
  1. OBJ-ID
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. CONTROL-GROUP
  5. SEQUENCE-NBR
KeyChangeAC256, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, BR41.1, BR41.4 +1 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACCTCATXACACTGRPACACTIVITYACASSIGNACCUAMTACMASTERACTRANSBODACTRANSEGACTRANSERRAMASSETGLNAMESGLSYSTEMGLTRANS+2 more belowACBRDNADTRACCLGTRANSACDEFREVACHISTDTLACMNTSCHXACMXVALACPMHSTDTLAMTRANSAPAPDHISTAPDISTRIBARDISTRIBCBDISTRIBEEDISTRIBMMDIST+3 more belowACTRANS

One to one (17) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
ATN-ACCT-CATEGORY→AAX-ACCT-CATEGORY
Acacctcat ErrACACCTCATNot Required
ATN-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcacctcatxACACCTCATXNot Required
ATN-ACTIVITY-GRP→AXX-ACTIVITY-GRP
ATN-ACTIVITY→AXX-ACTIVITY
ATN-ACCT-CATEGORY→AXX-ACCT-CATEGORY
AcactgrpACACTGRPRequired
ATN-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
ATN-ACTIVITY→ACV-ACTIVITY
AcassignACASSIGNNot 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
AccuamtACCUAMTNot RequiredValid 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
AcmasterACMASTERNot Required
ATN-ACTIVITY-GRP→MST-ACTIVITY-GRP
ATN-ACTIVITY→MST-ACTIVITY
ATN-ACCT-CATEGORY→MST-ACCT-CATEGORY
ATN-FISCAL-YEAR→MST-FISCAL-YEAR
ActransbodACTRANSBODNot 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
ActransegACTRANSEGNot Required
ATN-OBJ-ID→TSG-OBJ-ID
ActranserrACTRANSERRNot Required
ATN-OBJ-ID→TER-OBJ-ID
AmassetAMASSETNot RequiredValid When ATN-RESOURCE-TYPE = "A"
AAN-EMPLOYEE-ASSET→AST-ASSET
GlnamesGLNAMESRequired
ATN-FROM-COMPANY→GLN-COMPANY
ATN-ACCT-UNIT→GLN-ACCT-UNIT
GlsystemGLSYSTEMRequired
ATN-COMPANY→GLS-COMPANY
GltransGLTRANSNot Required
ATN-GLT-OBJ-ID→GLT-OBJ-ID
OeinvclineOEINVCLINENot Required
ATN-OBJ-ID→OIL-ATN-OBJ-ID
OeinvcmiscOEINVCMISCNot Required
ATN-OBJ-ID→OIM-ATN-OBJ-ID

One to many (19) — child tables

RelationTableRulesConditionField map
AcbrdnadtrACBRDNADTR
ATN-OBJ-ID→BAT-ATN-OBJ-ID
—→BAT-BURDEN-CD
—→BAT-BURDEN-TYPE
—→BAT-POOL-NBR
AcclgtransACCLGTRANS
ATN-OBJ-ID→CGT-ATN-OBJ-ID
—→CGT-LEVEL
AcdefrevACDEFREV
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
AchistdtlACHISTDTL
ATN-OBJ-ID→HDT-ATN-OBJ-ID
—→HDT-CONTRACT
—→HDT-OBJ-ID
—→HDT-LINE-NBR
AcmntschxACMNTSCHX
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
AcmxvalACMXVAL
ATN-OBJ-ID→ATV-OBJ-ID
—→ATV-MATRIX-CAT
AcpmhstdtlACPMHSTDTL
ATN-GLT-OBJ-ID→PML-GLT-OBJ-ID
ATN-OBJ-ID→PML-ATN-OBJ-ID
—→PML-OBJ-ID
—→PML-LINE-NBR
AmtransAMTRANS
ATN-OBJ-ID→AMT-ATN-OBJ-ID
—→AMT-ASSET
—→AMT-SEQ-NUMBER
—→AMT-COMPANY
ApapdhistAPAPDHIST
ATN-OBJ-ID→AH2-ATN-OBJ-ID
—→AH2-COMPANY
—→AH2-VENDOR
—→AH2-INVOICE
—→AH2-SUFFIX
—→AH2-CANCEL-SEQ
—→AH2-DIST-SEQ-NBR
ApdistribAPDISTRIB
ATN-OBJ-ID→APD-ATN-OBJ-ID
—→APD-COMPANY
—→APD-VENDOR
—→APD-INVOICE
—→APD-SUFFIX
—→APD-CANCEL-SEQ
—→APD-DIST-SEQ-NBR
ArdistribARDISTRIB
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
CbdistribCBDISTRIB
ATN-OBJ-ID→CBD-ACT-OBJ-ID
—→CBD-CASH-CODE
—→CBD-BANK-INST-CODE
—→CBD-TRANS-IDENT
—→CBD-DIST-TYPE
—→CBD-SEQ-NBR
EedistribEEDISTRIB
ATN-OBJ-ID→EED-ACT-OBJ-ID
—→EED-COMPANY
—→EED-VENDOR
—→EED-EXPENSE-NBR
—→EED-SEQ-NBR
IcmmdistMMDISTValid 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
MmdistMMDIST
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
OedistOEDIST
ATN-OBJ-ID→ODI-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-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
PrdistribPRDISTRIB
ATN-FROM-COMPANY→PRD-COMPANY
ATN-ACTIVITY→PRD-ACTIVITY
ATN-OBJ-ID→PRD-ATN-OBJ-ID
—→PRD-EMPLOYEE
—→PRD-OBJ-ID
SltransSLTRANS
ATN-GLT-OBJ-ID→SLT-GLT-OBJ-ID
—→SLT-OBJ-ID

Programs

Updated by (379)

Referenced by (24)