|
|
ACEMPEXPX FILE
REFERENCED BY
AC258 AC550 AC54.2 AC542 AC57.1
UPDATED BY
AC105 AC110 AC120 AC300 AC58.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AEA-ACTIVITY-GRP Alpha 15 AC105 AC110
Element: Group AC120 AC58.1
AEA-ALL-ACT-FLAG Alpha 1 AC105 AC110
Element: Account Flag AC120 AC58.1
AEA-ACTIVITY Alpha 15 AC105 AC110
Element: Activity Activities are the processes or AC120 AC58.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AEA-ACCT-CATEGORY Alpha 5 AC105 AC110
Element: Account CategoAccount categories are groupings of AC120 AC58.1
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
AEA-EXPENSE-CODE Alpha 20 AC105 AC110
Element: Expense Code AC120 AC58.1
AEA-GL-CODE Alpha 4 AC105 AC110
Element: Gl Code AC120 AC58.1
AEA-EXP-ACCT Numeric 6 AC105 AC110
Element: Exp Acct AC120 AC58.1
AEA-EXP-SUB-ACCT Numeric 4 AC105 AC110
Element: Subaccount AC120 AC58.1
AEA-EXP-DEFAULT-FL Alpha 1 AC105 AC110
Element: Exp Default FlA = Activity Company Account Unit AC120 AC58.1
E = Employee Comp Accounting Unit
ACEMPEXPX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AEASET1 ACTIVITY-GRP AC105 AC110
ACTIVITY AC120 AC258
ACCT-CATEGORY AC300 AC550
EXPENSE-CODE AC58.1
AEASET2 ACTIVITY-GRP
ACCT-CATEGORY
ACTIVITY
EXPENSE-CODE
AEASET3 ACTIVITY-GRP Subset
ACCT-CATEGORY Where (ALL-ACT-FLAG = "Y" )
ACTIVITY
EXPENSE-CODE
AEASET4 ACCT-CATEGORY
ACTIVITY-GRP
ACTIVITY
EXPENSE-CODE
AEASET5 EXPENSE-CODE AC54.2 AC542
ACTIVITY-GRP AC57.1 AC58.1
ACTIVITY
ACCT-CATEGORY
ACEMPEXPX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
AEA-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acempexp ACEMPEXP Required
AEA-EXPENSE-CODE -> AEE-EXPENSE-CODE
|
