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.

Field / columnTypeDescription & valuesUpdated by
CNT-CONTRACT PK
CONTRACT
Alpha 15Activity Management contract.BR10.1, BR10.9
CNT-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.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 1BR10.1, BR10.9, BR200
CNT-CONTRACT-AMT
CONTRACT_AMT
Signed 18.2AC10.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.7BR10.1, BR10.9
CNT-CUST-PO-NBR
CUST_PO_NBR
Alpha 22BR10.1, BR10.9
CNT-GROUP
GROUP
Alpha 15BR10.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.2AC300, BR122, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +5 more
CNT-TOT-UNT-BILLED
TOT_UNT_BILLED
Signed 18.2AC300, BR122, BR140, BR20.1, BR20.2, BR20.3, BR20.4, BR20.5 +5 more
CNT-TOT-REV-AMT
TOT_REV_AMT
Signed 18.2AC300, BR580
CNT-TOT-REV-UNIT
TOT_REV_UNIT
Signed 15.2AC300, BR580
CNT-CUSTOMER
CUSTOMER
Alpha 9 (Right Justified)This field contains the number that represents a customer.BR10.1, BR10.9
CNT-AC-CUSTOMER-ID
AC_CUSTOMER_ID
Alpha 5BR10.1, BR10.9
CNT-COMPANY
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 4BR10.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 4BR10.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 4BR10.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.2BR10.1
CNT-AUTO-JRL-CD
AUTO_JRL_CD
Alpha 4BR10.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.2AC300, BR130, BR131, BR530, BR580
CNT-APPLY-TOL-UNIT
APPLY_TOL_UNIT
Signed 15.2AC300, 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 4BR10.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 4BR10.1
CNT-RETAIN-CAT
RETAIN_CAT
Alpha 5BR10.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 6BR10.1
CNT-RET-SUB-ACCT
RET_SUB_ACCT
Numeric 4BR10.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
LETTER_CREDIT
Alpha 20BR10.1
CNT-DOCUMENT-NBR
DOCUMENT_NBR
Alpha 20BR10.1
CNT-EX-CEILINGS
EX_CEILINGS
Alpha 1
  • Y Yes
  • N No
BR10.1
CNT-PURGE-FL
PURGE_FL
Alpha 1BR300
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CNTSET1CONTRACTPrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC04.1, AC05.2, AC05.3 +22 more (list truncated in source)
CNTSET2ACTIVITY, CONTRACTKeyChangeAC10.1, AC10.5, AC110, AC112, AC113, AC12.1, AC120, AC121 +22 more (list truncated in source)
CNTSET3COMPANY, CUSTOMER, AC-CUSTOMER-ID, CONTRACTKeyChangeAC56.1, AC560, BR11.1, BR19.1
CNTSET4LETTER-CREDIT, CONTRACT, ACTIVITYKeyChangeAC112, AC113, AC121, AC123, AC128, AC135, AC145, AC147 +22 more (list truncated in source)
CNTSET5COMPANY, CUSTOMER, CONTRACTKeyChangeBR91.1

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequiredCNT-ACTIVITYACV-ACTIVITY
AcaddlcntrACADDLCNTRNot RequiredACV-ACTIVITY-GRPADN-ACTIVITY-GRP, CNT-CONTRACTADN-CONTRACT
AccntbodACCNTBODNot Required, Delete CascadesCNT-CONTRACTYAI-CONTRACT
AccntrpcdACCNTRPCDNot RequiredCNT-CONTRACTCNP-CONTRACT
AccustdtlACCUSTDTLRequiredCNT-COMPANYCMB-COMPANY, CNT-CUSTOMERCMB-CUSTOMER
AccustomerACCUSTOMERRequiredCNT-COMPANYCMR-COMPANY, CNT-CUSTOMERCMR-CUSTOMER, CNT-AC-CUSTOMER-IDCMR-AC-CUSTOMER-ID
AcfeedtlACFEEDTLRequiredCNT-CONTRACTFDT-CONTRACT
AcmilestnACMILESTNNot RequiredValid When CNT-REVENUE-MTHD = "M"CNT-ACTIVITYMLS-ACTIVITY, "R"MLS-MILESTONE-CAT
AcprodhdrACPRODHDRNot RequiredCNT-CONTRACTAHR-CONTRACT
ArcompARCOMPRequiredCNT-COMPANYACO-COMPANY
ArcustomerARCUSTOMERRequiredCNT-COMPANYACM-COMPANY, CNT-CUSTOMERACM-CUSTOMER

One to many (25) — child tables

RelationTableRulesConditionField map
AcceilingACCEILINGCNT-ACTIVITYCEH-ACTIVITY, CEH-ACCT-CATEGORY, CEH-SUM-ACCT-CAT, CEH-CTR-CAT-GRP, CEH-MATRIX-CAT
Acchgordx TotACCHGORDXCNT-CONTRACTCHX-ACTIVITY-GRP, CNT-ACTIVITYCHX-ACTIVITY, ZeroesCHX-BUDGET-NBR, CHX-CHG-ORDER-NBR, CHX-ACCT-CATEGORY, CHX-FISCAL-YEAR, CHX-PERIOD
AcclgtransACCLGTRANSCNT-CONTRACTCGT-CONTRACT, CGT-ATN-OBJ-ID, CGT-LEVEL
AccntmodACCNTMODCNT-CONTRACTCMD-CONTRACT, CMD-MOD-NBR
AccntracctACCNTRACCTCNT-CONTRACTCNA-CONTRACT, CNA-ACCT-CATEGORY
AccntractxACCNTRACTXCNT-CONTRACTCNX-CONTRACT, CNX-ACTIVITY
AccntrcatACCNTRCATCNT-CONTRACTCNC-CONTRACT, CNC-ACTIVITY, CNC-ACCT-CATEGORY
AccontactsACCONTACTSACV-ACTIVITY-GRPCTS-ACTIVITY-GRP, CNT-CONTRACTCTS-CONTRACT, CTS-RESP-CODE
AcctrcatgACCTRCATGCNT-CONTRACTBCG-CONTRACT, BCG-CTR-CAT-GRP
AcctrcatgxACCTRCATGXCNT-CONTRACTBCX-CONTRACT, BCX-ACCT-CATEGORY
AcfeebalACFEEBALCNT-CONTRACTFBL-CONTRACT, FBL-ACTIVITY, FBL-TYPE, FBL-FEE-CD, FBL-COMPANY, FBL-ACCT-UNIT
AchistclgACHISTCLGCNT-CONTRACTHCT-CONTRACT, HCT-OBJ-ID, HCT-LINE-NBR, HCT-ATN-OBJ-ID, HCT-LEVEL
AchistcnslACHISTCNSLCNT-CONTRACTIHC-CONTRACT, IHC-OBJ-ID, IHC-LINE-NBR
AchistdtlACHISTDTLCNT-CONTRACTHDT-CONTRACT, HDT-OBJ-ID, HDT-LINE-NBR
AchisthdrACHISTHDRCNT-CONTRACTHIH-CONTRACT, HIH-COMPANY, HIH-CUSTOMER, HIH-AC-CUSTOMER-ID, HIH-INVOICE, HIH-OBJ-ID
AcmnthdrACMNTHDRCNT-CONTRACTMSE-CONTRACT, MSE-MAINT-SCHEDULE
AcmntschACMNTSCHCNT-CONTRACTMSC-CONTRACT, MSC-MAINT-SCHEDULE, MSC-PRODUCT, MSC-PROD-VERSION, MSC-OBJ-ID
AcpmhsthdrACPMHSTHDRCNT-CONTRACTPMH-CONTRACT, PMH-COMPANY, PMH-CUSTOMER, PMH-AC-CUSTOMER-ID, PMH-INVOICE, PMH-OBJ-ID
AcproadjACPROADJCNT-CONTRACTBRJ-CONTRACT, BRJ-HIH-OBJ-ID, BRJ-LINE-NBR-MAP, BRJ-ADJ-LEVEL, BRJ-REASON-CODE
AcprodinvACPRODINVCNT-CONTRACTPDI-CONTRACT, PDI-OBJ-ID
AcretainACRETAINCNT-ACTIVITYRET-ACTIVITY, RET-RETAIN-ID
AcretngACRETNGCNT-ACTIVITYRTG-ACTIVITY, RTG-SUM-ACCT-CAT, RTG-CTR-CAT-GRP, RTG-ACCT-CATEGORY
AracpivotARACPIVOTCNT-CONTRACTCCP-CONTRACT, CCP-DUE-DATE, CCP-TRANS-TYPE, CCP-BATCH-NBR, CCP-TRANSACTION, CCP-PAYMENT-SEQ, CCP-COMPANY
ArpaymentARPAYMENTCNT-CONTRACTAPM-CONTRACT, APM-COMPANY, APM-BATCH-NBR, APM-PAYMENT-SEQ
GmcntrfndGMCNTRFNDCNT-CONTRACTGCF-CONTRACT, GCF-GRANT

Programs

Updated by (27)

Referenced by (517)