ACCNTRACT – Activity Contract

System
AC Billing Revenue (BR)
Prefix
CNT
Primary key
CONTRACT
Fields
63
Updated by
27 programs
Referenced by
517 programs

ACCNTRACT is the Activity Contract table in Lawson AC Billing Revenue (prefix CNT). It is indexed by CONTRACT (CNTSET1); alternate indexes: CNTSET2, CNTSET3, CNTSET4 and CNTSET5. It is related 1:1 to ACACTIVITY, ACADDLCNTR, ACCNTBOD, ACCNTRPCD, ACCUSTDTL, ACCUSTOMER, ACFEEDTL, ACMILESTN and 3 more and 1:M to ACCEILING, ACCHGORDX, ACCLGTRANS, ACCNTMOD, ACCNTRACCT, ACCNTRACTX, ACCNTRCAT, ACCONTACTS and 17 more. It is updated by AC10.1, AC120, AC300, BR10.1, BR10.2, BR10.9, BR11.1, BR12.2 and 19 more and referenced by AC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC04.1, AC05.2, AC05.3 and 509 more. The table has 63 fields, 5 indexes and 36 documented relations.

About ACCNTRACT

The ACCNTRACT file defines the activity contract. Contract data is entered and maintained via BR10 (Contract Parameters). Contract activities are defined via AC10 (Activity) by entering a "C" in the level type field. Only one activity in a branch can be defined as a contract activity. Contract information defines the revenue method, contract amount, contract currency, customer, and billed/unbilled accounts / account categories for billing and revenue.

Fields (63)

Column = COBOL field name without the CNT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CNT-CONTRACT PK
CONTRACT
Alpha 15Activity Management contract.BR10.1, BR10.9
#CNT-ACTIVITY SET2 SET4
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.9, BR120, BR121, BR122, BR123, BR140, BR151 +9 more
#CNT-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.BR07.1, BR10.1, BR10.9
#CNT-REVENUE-MTHD
REVENUE_MTHD
Alpha 1—
  • A Accrual
  • P Percent Complete
  • C Completed Contract
  • 9 User Defined
  • M Milestone
  • T Cost Plus
  • 1 Product
  • 2 Maintenance
  • 3 Prod and Maint
  • F Multi Funded Contract
BR10.1, BR10.9
#CNT-CONTRCT-AMT-ND
CONTRCT_AMT_ND
Numeric 1—BR10.1, BR10.9, BR200
#CNT-CONTRACT-AMT
CONTRACT_AMT
Signed 18.2—AC10.1, AC120, BR10.1, BR10.2, BR10.9, BR12.2, BR22.1
#CNT-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BR10.1, BR10.9
#CNT-FIXED-EXCHANGE
FIXED_EXCHANGE
Alpha 1—
  • Y Yes
  • N No
BR10.1, BR10.9
#CNT-MULT-DIV
MULT_DIV
Alpha 1—
  • M Multiply
  • D Divide
BR10.1, BR10.9
#CNT-EXCHANGE-RATE
EXCHANGE_RATE
Signed 14.7—BR10.1, BR10.9
#CNT-CUST-PO-NBR
CUST_PO_NBR
Alpha 22—BR10.1, BR10.9
#CNT-GROUP
GROUP
Alpha 15—BR10.1
#CNT-COMBINE-CONT
COMBINE_CONT
Alpha 1—
  • C Contract/Non-Segment
  • P Posting/Segment
  • 1 Posting/Acct Cat/Segment
  • 2 Contract/Acct Cat/Non-Segment
BR10.1
#CNT-PCT-CMPLT-MTHD
PCT_CMPLT_MTHD
Alpha 1—
  • A Alternative A (% Complete)
  • B Alternative B (Gross Margin)
BR10.1
#CNT-BUDGET-TYPE
BUDGET_TYPE
Alpha 1—
  • A Amount
  • U Units
BR10.1
#CNT-TOTAL-BILLED
TOTAL_BILLED
Signed 18.2—AC300, BR122, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +5 more
#CNT-TOT-UNT-BILLED
TOT_UNT_BILLED
Signed 18.2—AC300, BR122, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +5 more
#CNT-TOT-REV-AMT
TOT_REV_AMT
Signed 18.2—AC300, BR580
#CNT-TOT-REV-UNIT
TOT_REV_UNIT
Signed 15.2—AC300, BR580
#CNT-CUSTOMER SET3 SET5
CUSTOMER
Alpha 9 (Right Justified)This field contains the number that represents a customer.BR10.1, BR10.9
#CNT-AC-CUSTOMER-ID SET3
AC_CUSTOMER_ID
Alpha 5—BR10.1, BR10.9
#CNT-COMPANY SET3 SET5
COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.BR10.1, BR10.9
#CNT-UNBL-AR-GL-CD
UNBL_AR_GL_CD
Alpha 4—BR10.1
#CNT-UNBL-ACCT-CAT
UNBL_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
#CNT-ADV-BILL-GL-CD
ADV_BILL_GL_CD
Alpha 4—BR10.1
#CNT-ADV-BL-ACT-CAT
ADV_BL_ACT_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
#CNT-PS-THRU-GL-CD
PS_THRU_GL_CD
Alpha 4—BR10.1
#CNT-PS-THRU-CAT
PS_THRU_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
#CNT-TOLERANCE-AMT
TOLERANCE_AMT
Signed 18.2—BR10.1
#CNT-AUTO-JRL-CD
AUTO_JRL_CD
Alpha 4—BR10.1
#CNT-JOURNAL-CODE
JOURNAL_CODE
Alpha 4——
#CNT-REVENUE-FLAG
REVENUE_FLAG
Alpha 1This flag identifies whether an activity/account category is eligible for revenue recognition.
  • I Include
  • E Exclude
BR10.1
#CNT-BILLING-FLAG
BILLING_FLAG
Alpha 1—
  • I Include
  • E Exclude
BR10.1
#CNT-APPLY-TOL-AMT
APPLY_TOL_AMT
Signed 18.2—AC300, BR130, BR131, BR530, BR580
#CNT-APPLY-TOL-UNIT
APPLY_TOL_UNIT
Signed 15.2—AC300, BR580
#CNT-DFLT-ACTIVITY
DFLT_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
#CNT-DFLT-ACCT-CAT
DFLT_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
#CNT-DFLT-COMPANY
DFLT_COMPANY
Numeric 4—BR10.1
#CNT-DFLT-ACCT-UNIT
DFLT_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.BR10.1
#CNT-DFLT-ACCOUNT
DFLT_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.—
#CNT-DFLT-SUB-ACCT
DFLT_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.—
#CNT-RETAIN-GL-CD
RETAIN_GL_CD
Alpha 4—BR10.1
#CNT-RETAIN-CAT
RETAIN_CAT
Alpha 5—BR10.1
#CNT-REAL-METHOD-FL
REAL_METHOD_FL
Alpha 1—
  • 1 Prorate
  • 2 No Prorate; Use Defaults
  • 3 No Prorate; Use Activity
BR10.1
#CNT-REAL-AU-FL
REAL_AU_FL
Alpha 1—
  • A Activity Company Acct Unit
  • T Trans Company Acct Unit
BR10.1
#CNT-FORCE-DETAIL
FORCE_DETAIL
Alpha 1This field determines whether this individual transaction can be summarized along with other like transactions.
  • Y Yes
  • N No
BR10.1
#CNT-RET-ACCOUNT
RET_ACCOUNT
Numeric 6—BR10.1
#CNT-RET-SUB-ACCT
RET_SUB_ACCT
Numeric 4—BR10.1
#CNT-BILL-PAID-AP
BILL_PAID_AP
Alpha 1This is the "Exclude Unpaid AP" flag maintained in the contract parameters (BR10). The values are:
  • Y Yes
  • N No
BR10.1
#CNT-LETTER-CREDIT SET4
LETTER_CREDIT
Alpha 20—BR10.1
#CNT-DOCUMENT-NBR
DOCUMENT_NBR
Alpha 20—BR10.1
#CNT-EX-CEILINGS
EX_CEILINGS
Alpha 1—
  • Y Yes
  • N No
BR10.1
#CNT-PURGE-FL
PURGE_FL
Alpha 1—BR300
#CNT-MT-RENEW-DATE
MT_RENEW_DATE
Derived——
#CNT-BILLING-METHOD
BILLING_METHOD
Numeric 1——
#CNT-FUND-AMOUNT
FUND_AMOUNT
Signed 18.2——
#CNT-EXPENDITURES
EXPENDITURES
Signed 18.2——
#CNT-RECEIVABLE
RECEIVABLE
Signed 18.2——
#CNT-RECEIPTS
RECEIPTS
Signed 18.2——
#CNT-REMAINING
REMAINING
Signed 18.2——
#CNT-AMT-TO-CLAIM
AMT_TO_CLAIM
Signed 18.2——
#CNT-LST-ALLOC-DATE
LST_ALLOC_DATE
Numeric 8 (yyyymmdd)——
#CNT-STATUS
STATUS
Numeric 1—
  • 0 Unapproved
  • 1 Approved
—

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CNTSET1
  1. CONTRACT
PrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC04.1, AC05.2, AC05.3 +22 more (list truncated in source)
CNTSET2
  1. ACTIVITY
  2. CONTRACT
KeyChangeAC10.1, AC10.5, AC110, AC112, AC113, AC12.1, AC120, AC121 +22 more (list truncated in source)
CNTSET3
  1. COMPANY
  2. CUSTOMER
  3. AC-CUSTOMER-ID
  4. CONTRACT
KeyChangeAC56.1, AC560, BR11.1, BR19.1
CNTSET4
  1. LETTER-CREDIT
  2. CONTRACT
  3. ACTIVITY
KeyChangeAC112, AC113, AC121, AC123, AC128, AC135, AC145, AC147 +22 more (list truncated in source)
CNTSET5
  1. COMPANY
  2. CUSTOMER
  3. CONTRACT
KeyChangeBR91.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYACADDLCNTRACCNTBODACCNTRPCDACCUSTDTLACCUSTOMERACFEEDTLACMILESTNACPRODHDRARCOMPARCUSTOMERACCEILINGACCHGORDXACCLGTRANSACCNTMODACCNTRACCTACCNTRACTXACCNTRCATACCONTACTSACCTRCATGACCTRCATGXACFEEBALACHISTCLGACHISTCNSLACHISTDTL+11 more belowACCNTRACT

One to one (11) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
CNT-ACTIVITY→ACV-ACTIVITY
AcaddlcntrACADDLCNTRNot Required
ACV-ACTIVITY-GRP→ADN-ACTIVITY-GRP
CNT-CONTRACT→ADN-CONTRACT
AccntbodACCNTBODNot Required, Delete Cascades
CNT-CONTRACT→YAI-CONTRACT
AccntrpcdACCNTRPCDNot Required
CNT-CONTRACT→CNP-CONTRACT
AccustdtlACCUSTDTLRequired
CNT-COMPANY→CMB-COMPANY
CNT-CUSTOMER→CMB-CUSTOMER
AccustomerACCUSTOMERRequired
CNT-COMPANY→CMR-COMPANY
CNT-CUSTOMER→CMR-CUSTOMER
CNT-AC-CUSTOMER-ID→CMR-AC-CUSTOMER-ID
AcfeedtlACFEEDTLRequired
CNT-CONTRACT→FDT-CONTRACT
AcmilestnACMILESTNNot RequiredValid When CNT-REVENUE-MTHD = "M"
CNT-ACTIVITY→MLS-ACTIVITY
"R"→MLS-MILESTONE-CAT
AcprodhdrACPRODHDRNot Required
CNT-CONTRACT→AHR-CONTRACT
ArcompARCOMPRequired
CNT-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
CNT-COMPANY→ACM-COMPANY
CNT-CUSTOMER→ACM-CUSTOMER

One to many (25) — child tables

RelationTableRulesConditionField map
AcceilingACCEILING
CNT-ACTIVITY→CEH-ACTIVITY
—→CEH-ACCT-CATEGORY
—→CEH-SUM-ACCT-CAT
—→CEH-CTR-CAT-GRP
—→CEH-MATRIX-CAT
Acchgordx TotACCHGORDX
CNT-CONTRACT→CHX-ACTIVITY-GRP
CNT-ACTIVITY→CHX-ACTIVITY
Zeroes→CHX-BUDGET-NBR
—→CHX-CHG-ORDER-NBR
—→CHX-ACCT-CATEGORY
—→CHX-FISCAL-YEAR
—→CHX-PERIOD
AcclgtransACCLGTRANS
CNT-CONTRACT→CGT-CONTRACT
—→CGT-ATN-OBJ-ID
—→CGT-LEVEL
AccntmodACCNTMOD
CNT-CONTRACT→CMD-CONTRACT
—→CMD-MOD-NBR
AccntracctACCNTRACCT
CNT-CONTRACT→CNA-CONTRACT
—→CNA-ACCT-CATEGORY
AccntractxACCNTRACTX
CNT-CONTRACT→CNX-CONTRACT
—→CNX-ACTIVITY
AccntrcatACCNTRCAT
CNT-CONTRACT→CNC-CONTRACT
—→CNC-ACTIVITY
—→CNC-ACCT-CATEGORY
AccontactsACCONTACTS
ACV-ACTIVITY-GRP→CTS-ACTIVITY-GRP
CNT-CONTRACT→CTS-CONTRACT
—→CTS-RESP-CODE
AcctrcatgACCTRCATG
CNT-CONTRACT→BCG-CONTRACT
—→BCG-CTR-CAT-GRP
AcctrcatgxACCTRCATGX
CNT-CONTRACT→BCX-CONTRACT
—→BCX-ACCT-CATEGORY
AcfeebalACFEEBAL
CNT-CONTRACT→FBL-CONTRACT
—→FBL-ACTIVITY
—→FBL-TYPE
—→FBL-FEE-CD
—→FBL-COMPANY
—→FBL-ACCT-UNIT
AchistclgACHISTCLG
CNT-CONTRACT→HCT-CONTRACT
—→HCT-OBJ-ID
—→HCT-LINE-NBR
—→HCT-ATN-OBJ-ID
—→HCT-LEVEL
AchistcnslACHISTCNSL
CNT-CONTRACT→IHC-CONTRACT
—→IHC-OBJ-ID
—→IHC-LINE-NBR
AchistdtlACHISTDTL
CNT-CONTRACT→HDT-CONTRACT
—→HDT-OBJ-ID
—→HDT-LINE-NBR
AchisthdrACHISTHDR
CNT-CONTRACT→HIH-CONTRACT
—→HIH-COMPANY
—→HIH-CUSTOMER
—→HIH-AC-CUSTOMER-ID
—→HIH-INVOICE
—→HIH-OBJ-ID
AcmnthdrACMNTHDR
CNT-CONTRACT→MSE-CONTRACT
—→MSE-MAINT-SCHEDULE
AcmntschACMNTSCH
CNT-CONTRACT→MSC-CONTRACT
—→MSC-MAINT-SCHEDULE
—→MSC-PRODUCT
—→MSC-PROD-VERSION
—→MSC-OBJ-ID
AcpmhsthdrACPMHSTHDR
CNT-CONTRACT→PMH-CONTRACT
—→PMH-COMPANY
—→PMH-CUSTOMER
—→PMH-AC-CUSTOMER-ID
—→PMH-INVOICE
—→PMH-OBJ-ID
AcproadjACPROADJ
CNT-CONTRACT→BRJ-CONTRACT
—→BRJ-HIH-OBJ-ID
—→BRJ-LINE-NBR-MAP
—→BRJ-ADJ-LEVEL
—→BRJ-REASON-CODE
AcprodinvACPRODINV
CNT-CONTRACT→PDI-CONTRACT
—→PDI-OBJ-ID
AcretainACRETAIN
CNT-ACTIVITY→RET-ACTIVITY
—→RET-RETAIN-ID
AcretngACRETNG
CNT-ACTIVITY→RTG-ACTIVITY
—→RTG-SUM-ACCT-CAT
—→RTG-CTR-CAT-GRP
—→RTG-ACCT-CATEGORY
AracpivotARACPIVOT
CNT-CONTRACT→CCP-CONTRACT
—→CCP-DUE-DATE
—→CCP-TRANS-TYPE
—→CCP-BATCH-NBR
—→CCP-TRANSACTION
—→CCP-PAYMENT-SEQ
—→CCP-COMPANY
ArpaymentARPAYMENT
CNT-CONTRACT→APM-CONTRACT
—→APM-COMPANY
—→APM-BATCH-NBR
—→APM-PAYMENT-SEQ
GmcntrfndGMCNTRFND
CNT-CONTRACT→GCF-CONTRACT
—→GCF-GRANT

Programs

Updated by (27)

Referenced by (517)