|
ACCNTRACCT FILE
REFERENCED BY
AC04.1 BR130 BR131 BR210 BR430 BR530
UPDATED BY
AC300 AC310 BR10.1 BR10.3 AC10.1 BR15.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNA-CONTRACT Alpha 10 BR10.1 BR10.3
Element: Bid Name
CNA-ACTIVITY Alpha 15 BR10.1 BR10.3
Element: 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
Element: Account CategoAccount 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
Element: Retain Gl Cd
CNA-REV-ACCT-CAT Alpha 5 BR10.1 BR10.3
Element: Account Category
CNA-REV-ACCT Numeric 6 BR10.1 BR10.3
Element: Account
CNA-REV-SUB-ACCT Numeric 4 BR10.1 BR10.3
Element: Subaccount
CNA-LOSS-GL-CD Alpha 4 BR10.1 BR10.3
Element: Retain Gl Cd
CNA-LOSS-ACCT-CAT Alpha 5 BR10.1 BR10.3
Element: Account Category
CNA-RSRV-LSS-GL-CD Alpha 4 BR10.1 BR10.3
Element: Retain Gl Cd
CNA-C-GAIN-GL-CD Alpha 4 BR10.1 BR10.3
Element: C Gain Gl Cd
CNA-C-LOSS-GL-CD Alpha 4 BR10.1 BR10.3
Element: C Loss Gl Cd
CNA-ADJ-GL-CD Alpha 4
Element: Adj Gl Cd
CNA-ADJ-ACCT-CAT Alpha 5 BR10.1 BR10.3
Element: Adj Acct Cat
CNA-ADJ-ACCOUNT Numeric 6 BR10.1 BR10.3
Element: Account
CNA-ADJ-SUB-ACCT Numeric 4 BR10.1 BR10.3
Element: 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
BR130 BR131
BR15.1 BR210
BR430 BR530
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
|