ACCNTRACCT – Activity Contract Accounts

System
AC Billing Revenue (BR)
Prefix
CNA
Primary key
CONTRACT, ACCT-CATEGORY
Fields
14
Updated by
6 programs
Referenced by
7 programs

ACCNTRACCT is the Activity Contract Accounts table in Lawson AC Billing Revenue (prefix CNA). It is indexed by CONTRACT, ACCT-CATEGORY (CNASET1). It is related 1:1 to ACACCTBOD, ACACCTCAT and ACCNTRACT. It is updated by AC10.1, AC300, AC560, BR10.1, BR10.3 and BR10.9 and referenced by AC04.1, BR130, BR131, BR210, BR430, BR530 and BRBD.2. The table has 14 fields, 1 index and 3 documented relations.

About ACCNTRACCT

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.

Fields (14)

Column = COBOL field name without the CNA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CNA-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR10.1, BR10.3
CNA-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BR10.1, BR10.3
CNA-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Account 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 thruBR10.1, BR10.3
CNA-REVENUE-GL-CD
REVENUE_GL_CD		Alpha 4—BR10.1, BR10.3
CNA-REV-ACCT-CAT
REV_ACCT_CAT		Alpha 5Account 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 thruBR10.1, BR10.3
CNA-REV-ACCT
REV_ACCT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR10.1, BR10.3
CNA-REV-SUB-ACCT
REV_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR10.1, BR10.3
CNA-LOSS-GL-CD
LOSS_GL_CD		Alpha 4—BR10.1, BR10.3
CNA-LOSS-ACCT-CAT
LOSS_ACCT_CAT		Alpha 5Account 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 thruBR10.1, BR10.3
CNA-RSRV-LSS-GL-CD
RSRV_LSS_GL_CD		Alpha 4—BR10.1, BR10.3
CNA-ADJ-GL-CD
ADJ_GL_CD		Alpha 4——
CNA-ADJ-ACCT-CAT
ADJ_ACCT_CAT		Alpha 5—BR10.1, BR10.3
CNA-ADJ-ACCOUNT
ADJ_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR10.1, BR10.3
CNA-ADJ-SUB-ACCT
ADJ_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR10.1, BR10.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CNASET1CONTRACT, ACCT-CATEGORYPrimaryAC04.1, AC10.1, AC300, AC560, BR10.1, BR10.3, BR10.9, BR130 +5 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcacctbodACACCTBODNot Required, Delete CascadesValid When YAH- = CNA-CNA-CONTRACT → YAH-CONTRACT, CNA-ACCT-CATEGORY → YAH-ACCT-CATEGORY
AcacctcatACACCTCATNot RequiredCNA-ACCT-CATEGORY → AAX-ACCT-CATEGORY
AccntractACCNTRACTRequiredCNA-CONTRACT → CNT-CONTRACT

Programs

Updated by (6)

Referenced by (7)