ACCNTRACCT FILE
REFERENCED BY
AC04.1 BR210 BR430
UPDATED BY
AC300 AC310 BR10.1 BR10.3 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNA-CONTRACT Alpha 10 BR10.1 BR10.3
Contract
CNA-ACTIVITY Alpha 15 BR10.1 BR10.3
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
CNA-ACCT-CATEGORY Alpha 5 BR10.1 BR10.3
Account Category Account categories are groupings of
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.
CNA-REVENUE-GL-CD Alpha 4 BR10.1 BR10.3
Revenue Gl Cd
CNA-REV-ACCT-CAT Alpha 5 BR10.1 BR10.3
Rev Acct Cat
CNA-REV-ACCT Numeric 6 BR10.1 BR10.3
Rev Acct
CNA-REV-SUB-ACCT Numeric 4 BR10.1 BR10.3
Rev Sub Acct The general ledger revenue (sales)
subaccount for the category.
CNA-LOSS-GL-CD Alpha 4 BR10.1 BR10.3
Loss Gl Cd
CNA-LOSS-ACCT-CAT Alpha 5 BR10.1 BR10.3
Loss Account
Category
CNA-RSRV-LSS-GL-CD Alpha 4 BR10.1 BR10.3
Rsrv Lss Gl Cd
CNA-C-GAIN-GL-CD Alpha 4 BR10.1 BR10.3
C Gain Gl Cd
CNA-C-LOSS-GL-CD Alpha 4 BR10.1 BR10.3
C Loss Gl Cd
CNA-ADJ-GL-CD Alpha 4
Adj Gl Cd
CNA-ADJ-ACCT-CAT Alpha 5
Adj Acct Cat
CNA-ADJ-ACCOUNT Numeric 6
Adjustments Offset
Account Nbr
CNA-ADJ-SUB-ACCT Numeric 4
Adjustments Offset
Subaccount
ACCNTRACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNASET1 CONTRACT AC04.1 AC10.1
ACCT-CATEGORY AC300 AC310
BR10.1 BR10.3
BR210 BR430
ACCNTRACCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
CNA-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Accntract ACCNTRACT Required
CNA-CONTRACT -> CNT-CONTRACT
|
