ACTRANS

Activity Transaction

This file contains the detail records for transactions posted to activities in the Activity Management system (status 9). It also contains unreleased transactions created in Activity Management (status 0) and transactions released from subsystems (status 1). This file can be listed by running AC290 (Transaction Detail).

REFERENCED BY
AP175 EE175


UPDATED BY
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 GL146 GL197 GL199 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
EX175 EX542 IFGT.1 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MAI1.1 AC00.1 AC10.1 ACAC.1 ACVW.1
AP131 AP170 AP193 CB10.1 CB15.1 CB15.2
CB150 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 EE11.1
EE135 EE20.3 EE35.1 EE35.2 EE520 GL165
GL170 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 EX545 IFEB.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POIG.1 POII.1 POIJ.1
SNAC.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.
EX175 EX542
IFGT.1
ATN-CONTROL-GROUP
Element: Control Group		Numeric 8
Required key. This field indicates the control group number used for process control of the activity transactions.
GL199 IFGT.1
ATN-SEQUENCE-NBR
Element: Sequence Number		Numeric 4
Required key. This user-assigned sequence number is used to keep the records unique and to determine order.
GL199 IFGT.1
ATN-OBJ-ID
Element: Object Identifier		Numeric 12
Required key. This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key generated by the system and used to drill back from Project Accounting to the subsystems.
EX175 EX542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
ATN-TRANS-TYPE
Element: Transaction Type		Alpha 1
This field determines if amounts or units are processed in the transaction.
A = Activity Management Only
B = AC side of AC and GL trans
I = Interface
G = GL side of AC and GL trans
T = Time Entry
EX175 EX542
IFGT.1
ATN-COMPANY
Element: Company		Numeric 4
This is the responsible company.
EX175 EX542
IFGT.1
ATN-FROM-COMPANY
Element: From Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
EX175 EX542
IFGT.1
ATN-TRAN-DATE
Element: Transaction Date		Numeric 8 (yyyymmdd)
This is the date the transaction is posted.
EX175 EX542
GL199 IFGT.1
ATN-ACTIVITY
Element: Activity		Alpha 15
This is the activity for the transaction.
EX175 EX542
IFGT.1
ATN-VAR-LEVELS
Element: Variable Levels		Alpha 30
This is the variable level for the transaction.
EX175 EX542
IFGT.1
ATN-STATUS
Element: Status		Numeric 1
The transaction status tells whether the transaction is released (these are considered commitments), unreleased, or posted.
0 = Unreleased
1 = Released
9 = Posted
EX175 EX542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
ATN-ACCT-CATEGORY
Element: Account Category		Alpha 5
This is the account category for the transaction.
EX175 EX542
IFGT.1
ATN-POSTING-DATE
Element: Posting Date		Numeric 8 (yyyymmdd)
For an Project Accounting transaction, this is the date the transaction was posted to the Activity Transaction file.
EX175 EX542
GL199 IFGT.1
ATN-SYSTEM
Element: System Code		Alpha 2
This is the system in which this transaction originated.
EX175 EX542
IFGT.1
ATN-ACCT-UNIT
Element: Accounting Unit		Alpha 15
This is the general ledger accounting unit for the transaction.
EX175 EX542
IFGT.1
ATN-ACCOUNT
Element: Account		Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
EX175 EX542
IFGT.1
ATN-SUB-ACCOUNT
Element: Subaccount		Numeric 4
This is the general ledger subaccount for the transaction.
EX175 EX542
IFGT.1
ATN-DESCRIPTION
Transaction
Description		Alpha 30 (Lower Case)
This is the description of the transaction.
EX175 EX542
IFGT.1
ATN-REFERENCE
Element: Reference		Alpha 10 (Lower Case)
This is the reference for this transaction.
EX175 EX542
IFGT.1
ATN-UNITS-AMOUNT
Element: Units Amount		Signed 15.2
This is the units amount for this transaction.
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-TRAN-CURRENCY
Element: Transaction Currency		Alpha 5
This is the currency for the transaction.
EX175 EX542
IFGT.1
ATN-TRAN-AMOUNT
Element: Transaction Amount		Signed 18.2
This is the amount in transaction currency.
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-TRAN-ND
Transaction Number
of Decimals		Numeric 1
This field indicates the defined number of decimal positions used for the transaction.
EX175 EX542
IFGT.1
ATN-ACT-CURRENCY
Element: Activity Currency		Alpha 5
This is the activity currency.
EX175 EX542
IFGT.1
ATN-ACT-BASERATE
Element: Activity Base Rate		Signed 14.7
This is the rate that converts the transaction amount to the activity amount.
EX175 EX542
IFGT.1
ATN-ACT-AMOUNT
Element: Activity Amount		Signed 18.2
This is the amount for the activity.
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-ACT-ND
Activity Number of
Decimals		Numeric 1
This is the number of decimals for the activity.
EX175 EX542
IFGT.1
ATN-AG-CURRENCY
Activity Group
Currency		Alpha 5
This is the currency for the activity group.
EX175 EX542
IFGT.1
ATN-AG-BASERATE
Activity Group Base
Rate		Signed 14.7
This is the rate that converts the transaction amount to the activity group amount.
EX175 EX542
IFGT.1
ATN-AG-AMOUNT
Activity Group
Amount		Signed 18.2
This is the amount for the activity group for this transaction.
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-AG-ND
Activity Group Nbr
of Decimals		Numeric 1
This is the number of decimals for the activity group.
EX175 EX542
IFGT.1
ATN-BILL-DATE
Element: Billing Date		Numeric 8 (yyyymmdd)
This is the date the transaction was billed.
GL199
ATN-RUN-DATE
Element: Run Date		Numeric 8 (yyyymmdd)
This is the date the transaction was posted to the general ledger.
EX175 EX542
GL199 IFGT.1
ATN-RUN-TIME
Element: Run Time		Numeric 6 (hhmmss)
This is the time the transaction was posted to the general ledger.
EX175 EX542
GL199 IFGT.1
ATN-SOURCE-CODE
Element: Source Code		Alpha 2
This is the source code for the transaction. This value defaults from the program the user uses to enter a journal entry. This value is not necessarily the same as the system ID.
EX175 EX542
IFGT.1
ATN-BILL-RATE
Element: Billing Rate		Signed 13.4
This is the billing rate for the transaction.
GL199
ATN-BILLABLE
Element: Billable		Alpha 1
This field indicates whether the transaction is billable, on hold, a write-off, or a transfer.
Y = Yes
N = No
H = Hold
EX175 EX542
GL199
ATN-BILLED
Element: Billed		Alpha 1
This field indicates whether the transaction has been billed.
Y = Yes
N = No
H = Hold
E = Exceeded ceiling
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLABLE-AMT
Element: Billable Amount		Signed 18.2
This is the billable amount for the transaction.
EX175 EX542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-BILLABLE-UNIT
Element: Billable Units		Signed 15.2
This is the number of billable units for the transaction.
EX175 EX542
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-OVERRIDE-FLAG
Element: Override Flag		Alpha 1
This field determines whether billing amounts are calculated or not. This flag is set to Yes if the billing amount or billing units values are defined for this transaction by the client versus being calculated by the billing programs. If this flag is Yes, the billing amount and unit will not be initialized if the transaction is backed out. The default is Blank, which also means No.
Y = Yes - Bill amts overridden
N = No - Bill amts calculated
EX175 EX542
GL199
ATN-REVENUE-FLAG
Element: Revenue Flag		Alpha 1
This flag indicates whether revenue has been recognized for the transaction. Valid values are Y = Yes N = No H = Hold
E = Exceeded ceiling
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-CAPITALIZE-FLG
Element: Capitalization Flag		Alpha 1
This flag indicates whether the transaction has been capitalized. Use Yes if the transaction has been capitalized. Use No if the transaction has not been capitalized.
Y = Yes
N = No
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATN-MATRIX-CAT
Element: Attribute		Alpha 12
Activity attributes can be assigned to transaction objects to define additional categories of information for reporting and processing. You can assign three user-defined attributes per source code.
GL199
ATN-MX-VALUE
Element: Attribute Value		Alpha 32
This is an attribute value assigned to a transaction to track additional information. Attribute values can then be used in selection and sorting for reporting and analysis.
GL199
ATN-RESOURCE-TYPE
Element: Resource Type		Alpha 1
This field indicates the type of the resource associated with the transaction.
E = PR Employee
V = AP/EE Vendor
A = AM Asset
P = Person
Q = Equipment
EX175 EX542
GL199 IFGT.1
ATN-RESOURCE-CODE
Element: Resource Code		Alpha 10
This is the resource code associated with the transaction.
EX175 EX542
GL199 IFGT.1
ATN-RESOURCE-DESC
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
EX175 EX542
GL199 IFGT.1
ATN-UNIT-MEASURE
Element: Unit of Measure		Alpha 12
This is the unit of measure for the transaction.
EX175 EX542
GL199
ATN-GLT-OBJ-ID
Element: Obj Id		Numeric 12
This is a subsystem-General Ledger interface identification number. It is used for Drill Around purposes.
EX175 GL199
IFGT.1
ATN-PERIOD
Element: Period		Numeric 2
This is the period for the transaction.
EX175 EX542
GL199 IFGT.1
ATN-FISCAL-YEAR
Element: Year		Numeric 4
This is the fiscal year for the transaction.
EX175 EX542
GL199 IFGT.1
ATN-AC191-UPDATED
Element: AC191 Updated		Alpha 1
This field indicates whether the transaction has been updated to the Activity GL Accounting Unit Master header and detail files. If the transaction has been added, this value is Yes. If the transaction has not been added, this value is No.
Y = Yes
GL199
ATN-RECONCILED
Element: Reconciled		Alpha 1
This flag is set to Yes when the payroll transaction has been reconciled by AC196 (Activity Payroll Reconciliation). Before the transaction is reconciled, the value in this field is No.
Y = Yes
N = No
GL199
ATN-SEGMENT-FLAG
Element: Segment Flag		Alpha 1
Indicates whether user analysis values (SL segment) have been populated for the distribution line.
Y = Yes
N = No
GL199
ATN-RPT-AMOUNT-1
Element: Intl Amt		Signed 18.2
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-RPT-RATE-1
Element: Rpt Rate 1		Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
EX175 EX542
IFGT.1
ATN-RPT-ND-1
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
EX175 EX542
IFGT.1
ATN-RPT-AMOUNT-2
Element: Intl Amt		Signed 18.2
EX175 EX542
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL45.1
IFGT.1
ATN-RPT-RATE-2
Element: Rpt Rate 1		Signed 14.7
The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).
EX175 EX542
IFGT.1
ATN-RPT-ND-2
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
EX175 EX542
IFGT.1
ATN-BRDN-ORG-OBJID
Element: Brdn Org Objid		Numeric 12
If the transaction record is a burden transaction, this field stores the OBJ-ID of the transaction that this burden transaction was created from.
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.
EX175 EX542
ATN-BILLED-AMT
Element: Intl Amt		Signed 18.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-REVENUE-AMT
Element: Intl Amt		Signed 18.2
EX175 EX542
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
ATN-EXPENSE-CODE
Element: Expense Code		Alpha 20
EX175 EX542
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.
GL199
ATN-AP-PAID
Element: Ap Paid		Alpha 1

" " = Eligible for Billing
H = Hold for Billing
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
EX542 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
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.
EX175 EX542
IFGT.1
ATN-HOLD-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
ATN-CAPITALIZABLE
Element: Capitalizable		Alpha 1

N = No
Y = Yes
H = Hold
" " = No
ATN-COMMENTS-FLAG
Element: Flag		Alpha 1

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

A = Accrual
C = Cost
P = Pass Thru
R = Revenue
IFGT.1
ATN-OPERATOR
Element: Operator		Alpha 10
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1


ACTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATNSET1 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
AC00.1 AC10.1
ATNSET10 ACTIVITY-GRP
VAR-LEVELS
STATUS
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
OBJ-ID
KeyChange, Subset
Where(STATUS !=Zeroes)
...
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
AP193 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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
ATNSET11 ACCT-CATEGORY
OBJ-ID
KeyChange, Subset
Where(STATUS =1)
ATNSET12 OBJ-ID
...
AP125 AP126
AP175 AP178
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 EE175
EX175 EX542
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
ATNSET13 ACTIVITY
ACCT-CATEGORY
POSTING-DATE
SYSTEM
SOURCE-CODE
OBJ-ID
KeyChange
AC10.1
ATNSET14 GLT-OBJ-ID
OBJ-ID
KeyChange
GL146 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
ATNSET2 STATUS
SUM-ACCT-CAT
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
OBJ-ID
KeyChange
...
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
AP193 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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
ATNSET3 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
POSTING-DATE
OBJ-ID
KeyChange, Subset
Where(STATUS =1)
...
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
AP193 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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
ATNSET4 ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
OBJ-ID
KeyChange, Subset
Where(STATUS =9)
ATNSET7 CONTROL-GROUP
SEQUENCE-NBR
TRAN-CURRENCY
OBJ-ID
ACTIVITY-GRP
KeyChange, Subset
Where(STATUS =Zeroes)
ATNSET8 ACTIVITY
ACCT-CATEGORY
TRAN-CURRENCY
UNIT-MEASURE
MATRIX-CAT
MX-VALUE
POSTING-DATE
OBJ-ID
KeyChange, Subset
Where((BILLABLE ="Y")
Or(BILLABLE ="H"))
And((REVENUE-FLAG !="Y")
Or(BILLED !="Y"))
AC10.1
ATNSET9 OBJ-ID
ACTIVITY-GRP
ACTIVITY
CONTROL-GROUP
SEQUENCE-NBR
KeyChange
IFGT.1


ACTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
ATN-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acacctcat Err ACACCTCAT Not Required
ATN-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acacctcatx ACACCTCATX Not Required
ATN-ACTIVITY-GRP->AXX-ACTIVITY-GRP
ATN-ACTIVITY->AXX-ACTIVITY
ATN-ACCT-CATEGORY->AXX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
ATN-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
ATN-ACTIVITY->ACV-ACTIVITY
Acassign ACASSIGN Not Required
ATN-ACTIVITY-GRP->AAN-ACTIVITY-GRP
ATN-ACTIVITY->AAN-ACTIVITY
ATN-FROM-COMPANY->AAN-COMPANY
ATN-RESOURCE-TYPE->AAN-RESOURCE-TYPE
ATN-RESOURCE-CODE->AAN-RESOURCE-CODE
Accuamt ACCUAMT Not Required
Valid When ACV-CURRENCY-CODE !=ATN-CURRENCY-CODE
ATN-ACTIVITY-GRP->ACU-ACTIVITY-GRP
ATN-ACTIVITY->ACU-ACTIVITY
ATN-ACT-CURRENCY->ACU-CURRENCY-CODE
Zeroes->ACU-BUDGET-NBR
ATN-FISCAL-YEAR->ACU-FISCAL-YEAR
ATN-ACCT-CATEGORY->ACU-ACCT-CATEGORY
Acmaster ACMASTER Not Required
ATN-ACTIVITY-GRP->MST-ACTIVITY-GRP
ATN-ACTIVITY->MST-ACTIVITY
ATN-ACCT-CATEGORY->MST-ACCT-CATEGORY
ATN-FISCAL-YEAR->MST-FISCAL-YEAR
Actranseg ACTRANSEG Not Required
ATN-OBJ-ID->TSG-OBJ-ID
Amasset AMASSET Not Required
Valid When ATN-RESOURCE-TYPE ="A"
AAN-EMPLOYEE-ASSET->AST-ASSET
Glnames GLNAMES Required
ATN-FROM-COMPANY->GLN-COMPANY
ATN-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ATN-COMPANY->GLS-COMPANY
Gltrans GLTRANS Not Required
ATN-GLT-OBJ-ID->GLT-OBJ-ID
Oeinvcline OEINVCLINE Not Required
ATN-OBJ-ID->OIL-ATN-OBJ-ID
Oeinvcmisc OEINVCMISC Not Required
ATN-OBJ-ID->OIM-ATN-OBJ-ID


ACTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Achistdtl ACHISTDTL
ATN-OBJ-ID->HDT-ATN-OBJ-ID
  HDT-CONTRACT
  HDT-OBJ-ID
  HDT-LINE-NBR
Acmxval ACMXVAL
ATN-OBJ-ID->ATV-OBJ-ID
  ATV-MATRIX-CAT
Amtrans AMTRANS
ATN-OBJ-ID->AMT-ATN-OBJ-ID
  AMT-ASSET
  AMT-SEQ-NUMBER
  AMT-COMPANY
Apapdhist APAPDHIST
ATN-OBJ-ID->AH2-ATN-OBJ-ID
  AH2-COMPANY
  AH2-VENDOR
  AH2-INVOICE
  AH2-SUFFIX
  AH2-CANCEL-SEQ
  AH2-DIST-SEQ-NBR
Apdistrib APDISTRIB
ATN-OBJ-ID->APD-ATN-OBJ-ID
  APD-COMPANY
  APD-VENDOR
  APD-INVOICE
  APD-SUFFIX
  APD-CANCEL-SEQ
  APD-DIST-SEQ-NBR
Ardistrib ARDISTRIB
ATN-OBJ-ID->AMD-ATN-OBJ-ID
  AMD-GL-COMPANY
  AMD-ACCT-UNIT
  AMD-ACCOUNT
  AMD-SUB-ACCT
  AMD-GL-DATE
  AMD-CREATE-DATE
  AMD-CREATE-TIME
  AMD-PROG-SEQ-NBR
Cbdistrib CBDISTRIB
ATN-OBJ-ID->CBD-ACT-OBJ-ID
  CBD-CASH-CODE
  CBD-BANK-INST-CODE
  CBD-TRANS-IDENT
  CBD-DIST-TYPE
  CBD-SEQ-NBR
Eedistrib EEDISTRIB
ATN-OBJ-ID->EED-ACT-OBJ-ID
  EED-COMPANY
  EED-VENDOR
  EED-EXPENSE-NBR
  EED-SEQ-NBR
Icmmdist MMDIST
Valid When ATN-SYSTEM ="IC"
ATN-OBJ-ID->MMD-ATN-OBJ-ID
  MMD-COMPANY
  MMD-SYSTEM-CD
  MMD-LOCATION
  MMD-DOC-TYPE
  MMD-DOC-NUMBER
  MMD-DOC-NBR-NUM
  MMD-LINE-NBR
  MMD-COMPONENT-SEQ
  MMD-LINE-SEQ
Mmdist MMDIST
ATN-OBJ-ID->MMD-ATN-OBJ-ID
  MMD-COMPANY
  MMD-SYSTEM-CD
  MMD-LOCATION
  MMD-DOC-TYPE
  MMD-DOC-NUMBER
  MMD-DOC-NBR-NUM
  MMD-LINE-NBR
  MMD-COMPONENT-SEQ
  MMD-LINE-SEQ
Oedist OEDIST
ATN-OBJ-ID->ODI-ATN-OBJ-ID
  ODI-INVC-PREFIX
  ODI-INVC-NUMBER
  ODI-AUTH-NO
  ODI-LINE-NBR
  ODI-SEQ
  ODI-POSTING-TYPE
Pommdist MMDIST
Valid When ATN-SYSTEM ="PO"
ATN-OBJ-ID->MMD-ATN-OBJ-ID
  MMD-COMPANY
  MMD-SYSTEM-CD
  MMD-LOCATION
  MMD-DOC-TYPE
  MMD-DOC-NUMBER
  MMD-DOC-NBR-NUM
  MMD-LINE-NBR
  MMD-COMPONENT-SEQ
  MMD-LINE-SEQ
Prdistrib PRDISTRIB
ATN-FROM-COMPANY->PRD-COMPANY
ATN-ACTIVITY->PRD-ACTIVITY
ATN-OBJ-ID->PRD-ATN-OBJ-ID
  PRD-EMPLOYEE
  PRD-OBJ-ID
Sltrans SLTRANS
ATN-GLT-OBJ-ID->SLT-GLT-OBJ-ID
  SLT-OBJ-ID

File created: Wed Jun 08 20:46:57 2016

Home
Contact Us



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