ACADDLCNTR – Additional Contract Info

System
AC Billing Revenue (BR)
Prefix
ADN
Primary key
ACTIVITY-GRP, CONTRACT
Fields
34
Updated by
8 programs
Referenced by
131 programs

ACADDLCNTR is the Additional Contract Info table in Lawson AC Billing Revenue (prefix ADN). It is indexed by ACTIVITY-GRP, CONTRACT (ADNSET1). It is related 1:1 to ACACTGRP and ACCNTRACT and 1:M to ACCNTMOD. It is updated by AC120, AC300, BR10.1, BR10.4, BR10.5, BR10.8, BR10.9 and BR13.1 and referenced by AC00.1, AC01.1, AC105, AC112, AC113, AC121, AC123, AC128 and 123 more. The table has 34 fields, 1 index and 3 documented relations.

About ACADDLCNTR

The ACADDLCNTR file maintains additional contract information for government contracts. Information can be stored at the activity group level or the contract level. Use BR10.4 (Additional Contract Information) for on-line entry. Use BR210 for listing.

Fields (34)

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

Field / columnTypeDescription & valuesUpdated by
ADN-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15The activity group associated with the contract activity.AC120, BR10.4, BR10.8, BR13.1
ADN-CONTRACT PK
CONTRACT		Alpha 15The contract name maintained on Contract parameters (BR10.1).BR10.4, BR10.8, BR13.1
ADN-CONTRACT-TYPE
CONTRACT_TYPE		Alpha 1—
  • 1 CPFF Cost Plus Fixed Fee
  • 2 CPAF Cost Plus Award Fee
  • 3 T & M Time and Materials
  • 4 FFP Firm Fixed Price
  • 5 Other
BR10.4, BR13.1
ADN-GOV-ORDER-NBR
GOV_ORDER_NBR		Alpha 30—BR10.4, BR13.1
ADN-PRIME-SUB-FL
PRIME_SUB_FL		Alpha 1—
  • P Prime Contractor
  • S Subcontractor
  • 2 2nd Tier
BR10.4, BR13.1
ADN-PRIME-CNT-NBR
PRIME_CNT_NBR		Alpha 30—BR10.4, BR13.1
ADN-SUB-CNT-NBR
SUB_CNT_NBR		Alpha 30—BR10.4, BR13.1
ADN-SIC-CODE
SIC_CODE		Numeric 6—BR10.4, BR13.1
ADN-REF-NBR
REF_NBR		Alpha 20—BR10.4, BR13.1
ADN-CNT-VALUE
CNT_VALUE		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-CNT-FEE
CNT_FEE		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-CNT-FEE-PCT
CNT_FEE_PCT		Signed 7.4—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-CNT-HOURS
CNT_HOURS		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-AWARD-VALUE
AWARD_VALUE		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-AWARD-FEE
AWARD_FEE		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-AWARD-FEE-PCT
AWARD_FEE_PCT		Signed 7.4—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-AWARD-HOURS
AWARD_HOURS		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-FUNDED-VALUE
FUNDED_VALUE		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-FUNDED-FEE
FUNDED_FEE		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-FUNDED-FEE-PCT
FUNDED_FEE_PCT		Signed 7.4—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-FUNDED-HOURS
FUNDED_HOURS		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-CONTRACT-NBR
CONTRACT_NBR		Alpha 14This is a number to indicate to the vendor which price agreement an item or items are operating under. If this number is entered on or defaulted to a purchase order line, it is an indication of the vendor contract that line is tied to. The contract number can be defaulted to the purchase order line. The default occurs by leaving the field blank when creating the purchase order and having the system attempt to find a contract number from a contract-type standard order. The system finds the number based on the item number for the line and vendor for the purchase order. If no contract number is entered on or defaulted to the line from a contract type standard order, a contract number entered on the purchase order header will default to the line. A contract number can also be tied to a blanket type standard order, and any purchase orders created from the blanket order will have the contract number from the blanket on the header and lines. The contract number can also be defaulted to a requisition line as the requisition line is created. The contract number will then be carried over to the purchase order line that is created from the requisition line.BR10.4, BR13.1
ADN-PO-NBR
PO_NBR		Alpha 14The purchase order number field is an optional field for your reference. It is assumed to contain the original purchase order number on which this asset was included.BR10.4, BR13.1
ADN-TO-TOT-POP
TO_TOT_POP		Numeric 8 (yyyymmdd)—BR10.4, BR10.5, BR10.8
ADN-FR-TOT-POP
FR_TOT_POP		Numeric 8 (yyyymmdd)—BR10.4, BR10.5, BR10.8
ADN-TO-AWARD-POP
TO_AWARD_POP		Numeric 8 (yyyymmdd)—BR10.4, BR10.5, BR10.8
ADN-FR-AWARD-POP
FR_AWARD_POP		Numeric 8 (yyyymmdd)—BR10.4, BR10.5, BR10.8
ADN-TO-FUNDED-POP
TO_FUNDED_POP		Numeric 8 (yyyymmdd)—BR10.4, BR10.5, BR10.8
ADN-FR-FUNDED-POP
FR_FUNDED_POP		Numeric 8 (yyyymmdd)—BR10.4, BR10.5, BR10.8
ADN-CONTRACT-CLASS
CONTRACT_CLASS		Alpha 1—
  • G Government
  • C Commercial
BR10.4, BR13.1
ADN-CNT-COST
CNT_COST		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-AWARD-COST
AWARD_COST		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-FUNDED-COST
FUNDED_COST		Signed 18.2—BR10.1, BR10.4, BR10.5, BR10.8, BR10.9
ADN-LONG-DESC
LONG_DESC		Alpha 60 (Lower Case)Long description.BR10.4, BR13.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ADNSET1ACTIVITY-GRP, CONTRACTPrimaryAC00.1, AC01.1, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredADN-ACTIVITY-GRP → AGP-ACTIVITY-GRP
AccntractACCNTRACTRequiredADN-CONTRACT → CNT-CONTRACT

One to many (1) — child tables

RelationTableRulesConditionField map
AccntmodACCNTMODADN-CONTRACT → CMD-CONTRACT, → CMD-MOD-NBR

Programs

Updated by (8)

Referenced by (131)