|
|
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 AC560 BR10.1 BR10.3 BR10.9
PW110 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNA-CONTRACT Alpha 15 BR10.1 BR10.3
Element: Contract Activity Management contract. PW110
CNA-ACTIVITY Alpha 15 BR10.1 BR10.3
Element: Activity Activities are the processes or PW110
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: Acct Category Account categories are groupings of PW110
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 PW110
CNA-REV-ACCT-CAT Alpha 5 BR10.1 BR10.3
Element: Acct Category Account categories are groupings of PW110
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-REV-ACCT Numeric 6 BR10.1 BR10.3
Element: Account This field along with the accounting PW110
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
CNA-REV-SUB-ACCT Numeric 4 BR10.1 BR10.3
Element: Sub Acct This field contains the subaccount from PW110
your general ledger chart of accounts
that was charged with the amount carried
on this record.
CNA-LOSS-GL-CD Alpha 4 BR10.1 BR10.3
Element: Loss Gl Cd PW110
CNA-LOSS-ACCT-CAT Alpha 5 BR10.1 BR10.3
Element: Acct Category Account categories are groupings of PW110
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-RSRV-LSS-GL-CD Alpha 4 BR10.1 BR10.3
Element: Rsrv Lss Gl Cd PW110
CNA-ADJ-GL-CD Alpha 4
Element: Adj Gl Cd
CNA-ADJ-ACCT-CAT Alpha 5 BR10.1 BR10.3
Element: Adj Acct Cat PW110
CNA-ADJ-ACCOUNT Numeric 6 BR10.1 BR10.3
Element: Account This field along with the accounting PW110
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
CNA-ADJ-SUB-ACCT Numeric 4 BR10.1 BR10.3
Element: Sub Acct This field contains the subaccount from PW110
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ACCNTRACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNASET1 CONTRACT AC04.1 AC10.1
ACCT-CATEGORY AC300 AC310
AC560 BR10.1
BR10.3 BR10.9
BR130 BR131
BR210 BR430
BR530 PW110
ACCNTRACCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
CNA-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Accntract ACCNTRACT Required
CNA-CONTRACT -> CNT-CONTRACT
|
