|
|
ACCNTRACCT FILE
The ACCNTRACCT file maintains the revenue and loss GL accounts and AC account
categorys required for billing and revenue entries by contract. Contract
accounts and account categories are maintained via BR10.3 (Contract Accounts).
Default accounts must be defined with a blank account category. Unique
revenue accounts can be defined for each type of cost account category. For
example, revenue can be posted to a unique account / account category for
labor verses material revenue. Enter either a GL code (represents a GL
account string) or an account (company and accounting unit will be determined
by the cost transaction). Allows the ability to have revenue follow the cost
or the originator of the expense. Loss and revserve for loss accounts/account
categories are also defined.
REFERENCED BY
AC04.1 BR130 BR131 BR210 BR430 BR530
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
Element: Contract Activity Management contract.
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.
Valid account category types are:
cost
revenue
accrual
pass thru
CNA-REVENUE-GL-CD Alpha 4 BR10.1 BR10.3
Element: Revenue 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 The general ledger revenue (sales)
subaccount for the category.
CNA-LOSS-GL-CD Alpha 4 BR10.1 BR10.3
Element: Loss 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: Rsrv Lss 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
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
|
