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 |
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. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||||
ATN-COMPANY Element: Company | Numeric 4 This is the responsible company. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-TRAN-DATE Element: Transaction Date | Numeric 8 (yyyymmdd) This is the date the transaction is posted. |
|
||||||||||||||||||||||||||||
ATN-ACTIVITY Element: Activity | Alpha 15 This is the activity for the transaction. |
|
||||||||||||||||||||||||||||
ATN-VAR-LEVELS Element: Variable Levels | Alpha 30 This is the variable level for the transaction. |
|
||||||||||||||||||||||||||||
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 |
|||||||||||||||||||||||||||||
ATN-ACCT-CATEGORY Element: Account Category | Alpha 5 This is the account category for the transaction. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-SYSTEM Element: System Code | Alpha 2 This is the system in which this transaction originated. |
|
||||||||||||||||||||||||||||
ATN-ACCT-UNIT Element: Accounting Unit | Alpha 15 This is the general ledger accounting unit for the transaction. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-SUB-ACCOUNT Element: Subaccount | Numeric 4 This is the general ledger subaccount for the transaction. |
|
||||||||||||||||||||||||||||
ATN-DESCRIPTION Transaction Description | Alpha 30 (Lower Case) This is the description of the transaction. |
|
||||||||||||||||||||||||||||
ATN-REFERENCE Element: Reference | Alpha 10 (Lower Case) This is the reference for this transaction. |
|
||||||||||||||||||||||||||||
ATN-UNITS-AMOUNT Element: Units Amount | Signed 15.2 This is the units amount for this transaction. |
|||||||||||||||||||||||||||||
ATN-TRAN-CURRENCY Element: Transaction Currency | Alpha 5 This is the currency for the transaction. |
|
||||||||||||||||||||||||||||
ATN-TRAN-AMOUNT Element: Transaction Amount | Signed 18.2 This is the amount in transaction currency. |
|||||||||||||||||||||||||||||
ATN-TRAN-ND Transaction Number of Decimals | Numeric 1 This field indicates the defined number of decimal positions used for the transaction. |
|
||||||||||||||||||||||||||||
ATN-ACT-CURRENCY Element: Activity Currency | Alpha 5 This is the activity currency. |
|
||||||||||||||||||||||||||||
ATN-ACT-BASERATE Element: Activity Base Rate | Signed 14.7 This is the rate that converts the transaction amount to the activity amount. |
|
||||||||||||||||||||||||||||
ATN-ACT-AMOUNT Element: Activity Amount | Signed 18.2 This is the amount for the activity. |
|||||||||||||||||||||||||||||
ATN-ACT-ND Activity Number of Decimals | Numeric 1 This is the number of decimals for the activity. |
|
||||||||||||||||||||||||||||
ATN-AG-CURRENCY Activity Group Currency | Alpha 5 This is the currency for the activity group. |
|
||||||||||||||||||||||||||||
ATN-AG-BASERATE Activity Group Base Rate | Signed 14.7 This is the rate that converts the transaction amount to the activity group amount. |
|
||||||||||||||||||||||||||||
ATN-AG-AMOUNT Activity Group Amount | Signed 18.2 This is the amount for the activity group for this transaction. |
|||||||||||||||||||||||||||||
ATN-AG-ND Activity Group Nbr of Decimals | Numeric 1 This is the number of decimals for the activity group. |
|
||||||||||||||||||||||||||||
ATN-BILL-DATE Element: Billing Date | Numeric 8 (yyyymmdd) This is the date the transaction was billed. |
|||||||||||||||||||||||||||||
ATN-RUN-DATE Element: Run Date | Numeric 8 (yyyymmdd) This is the date the transaction was posted to the general ledger. |
|||||||||||||||||||||||||||||
ATN-RUN-TIME Element: Run Time | Numeric 6 (hhmmss) This is the time the transaction was posted to the general ledger. |
|||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-BILL-RATE Element: Billing Rate | Signed 13.4 This is the billing rate for the transaction. |
|||||||||||||||||||||||||||||
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 |
|||||||||||||||||||||||||||||
ATN-BILLED Element: Billed | Alpha 1 This field indicates whether the transaction has been billed. Y = Yes N = No H = Hold E = Exceeded ceiling |
|||||||||||||||||||||||||||||
ATN-BILLABLE-AMT Element: Billable Amount | Signed 18.2 This is the billable amount for the transaction. |
|||||||||||||||||||||||||||||
ATN-BILLABLE-UNIT Element: Billable Units | Signed 15.2 This is the number of billable units for the transaction. |
|||||||||||||||||||||||||||||
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 |
|||||||||||||||||||||||||||||
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 |
|||||||||||||||||||||||||||||
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 |
|||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||||
ATN-RESOURCE-CODE Element: Resource Code | Alpha 10 This is the resource code associated with the transaction. |
|
||||||||||||||||||||||||||||
ATN-RESOURCE-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||||||||||||||||||||||||||||
ATN-UNIT-MEASURE Element: Unit of Measure | Alpha 12 This is the unit of measure for the transaction. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-PERIOD Element: Period | Numeric 2 This is the period for the transaction. |
|||||||||||||||||||||||||||||
ATN-FISCAL-YEAR Element: Year | Numeric 4 This is the fiscal year for the transaction. |
|||||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||||
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 |
|
||||||||||||||||||||||||||||
ATN-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 |
|||||||||||||||||||||||||||||
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). |
|
||||||||||||||||||||||||||||
ATN-RPT-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||
ATN-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 |
|||||||||||||||||||||||||||||
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). |
|
||||||||||||||||||||||||||||
ATN-RPT-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-BILLED-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
ATN-REVENUE-AMT Element: Intl Amt | Signed 18.2 |
|||||||||||||||||||||||||||||
ATN-EXPENSE-CODE Element: Expense Code | Alpha 20 |
|
||||||||||||||||||||||||||||
ATN-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||||||||||||||||||||||||||||
ATN-COMMENT-CD Element: Comment Cd | Numeric 3 This is the number representing a comment relating to the transaction. |
|
||||||||||||||||||||||||||||
ATN-AP-PAID Element: Ap Paid | Alpha 1 " " = Eligible for Billing H = Hold for Billing |
|||||||||||||||||||||||||||||
ATN-QUICK-POST-FL Element: Quick Post Fl | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||||||||
ATN-TRANSFER-FL Element: Transfer Fl | Alpha 1 Y = Yes N = No T = Transferred |
|
||||||||||||||||||||||||||||
ATN-TRANSFER-AMT Element: Adj Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||
ATN-BILL-MTHD Element: Billing Method | Numeric 1 |
|
||||||||||||||||||||||||||||
ATN-REV-MTHD Element: Rev Mthd | Alpha 1 |
|
||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-SUM-ACCT-CAT Element: Sum Acct Cat | Alpha 5 The name of the summary account category. |
|||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||
ATN-CAPITALIZABLE Element: Capitalizable | Alpha 1 N = No Y = Yes H = Hold " " = No |
|
||||||||||||||||||||||||||||
ATN-COMMENTS-FLAG Element: Flag | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||||||||||||
ATN-CATEGORY-TYPE Element: Category Type | Alpha 1 A = Accrual C = Cost P = Pass Thru R = Revenue |
|||||||||||||||||||||||||||||
ATN-OPERATOR Element: Operator | Alpha 10 |
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Required
| ||||||||||||||||||||||||
Acacctcat Err | ACACCTCAT |
Not Required
| ||||||||||||||||||||||||
Acacctcatx | ACACCTCATX |
Not Required
| ||||||||||||||||||||||||
Acactgrp | ACACTGRP |
Required
| ||||||||||||||||||||||||
Acactivity | ACACTIVITY |
Required
| ||||||||||||||||||||||||
Acassign | ACASSIGN |
Not Required
| ||||||||||||||||||||||||
Accuamt | ACCUAMT |
Not Required
| ||||||||||||||||||||||||
Acmaster | ACMASTER |
Not Required
| ||||||||||||||||||||||||
Actransbod | ACTRANSBOD |
Not Required, Delete Cascades
| ||||||||||||||||||||||||
Actranseg | ACTRANSEG |
Not Required
| ||||||||||||||||||||||||
Actranserr | ACTRANSERR |
Not Required
| ||||||||||||||||||||||||
Amasset | AMASSET |
Not Required
| ||||||||||||||||||||||||
Glnames | GLNAMES |
Required
| ||||||||||||||||||||||||
Glsystem | GLSYSTEM |
Required
| ||||||||||||||||||||||||
Gltrans | GLTRANS |
Not Required
| ||||||||||||||||||||||||
Oeinvcline | OEINVCLINE |
Not Required
| ||||||||||||||||||||||||
Oeinvcmisc | OEINVCMISC |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acbrdnadtr | ACBRDNADTR |
| ||||||||||||||||||||||||||||||||||||
Acclgtrans | ACCLGTRANS |
| ||||||||||||||||||||||||||||||||||||
Acdefrev | ACDEFREV |
| ||||||||||||||||||||||||||||||||||||
Achistdtl | ACHISTDTL |
| ||||||||||||||||||||||||||||||||||||
Acmntschx | ACMNTSCHX |
| ||||||||||||||||||||||||||||||||||||
Acmxval | ACMXVAL |
| ||||||||||||||||||||||||||||||||||||
Acpmhstdtl | ACPMHSTDTL |
| ||||||||||||||||||||||||||||||||||||
Amtrans | AMTRANS |
| ||||||||||||||||||||||||||||||||||||
Apapdhist | APAPDHIST |
| ||||||||||||||||||||||||||||||||||||
Apdistrib | APDISTRIB |
| ||||||||||||||||||||||||||||||||||||
Ardistrib | ARDISTRIB |
| ||||||||||||||||||||||||||||||||||||
Cbdistrib | CBDISTRIB |
| ||||||||||||||||||||||||||||||||||||
Eedistrib | EEDISTRIB |
| ||||||||||||||||||||||||||||||||||||
Icmmdist | MMDIST |
| ||||||||||||||||||||||||||||||||||||
Mmdist | MMDIST |
| ||||||||||||||||||||||||||||||||||||
Oedist | OEDIST |
| ||||||||||||||||||||||||||||||||||||
Pommdist | MMDIST |
| ||||||||||||||||||||||||||||||||||||
Prdistrib | PRDISTRIB |
| ||||||||||||||||||||||||||||||||||||
Sltrans | SLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.