Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACADDLCNTR


                            ACADDLCNTR FILE

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.

REFERENCED BY

AC00.1    AC01.1    AC105     AC112     AC113     AC120
AC121     AC123     AC13.3    AC130     AC135     AC14.3
AC145     AC160     AC165     AC190     AC191     AC197
AC198     AC200     AC203     AC206     AC207     AC210
AC213     AC218     AC220     AC240     AC246     AC261
AC265     AC290     AC295     AC298     AC30.3    AC32.1
AC34.1    AC346     AC35.1    AC36.1    AC400     AC401
AC410     AC412     AC420     AC421     AC440     AC460
AC471     AC472     AC473     AC480     AC490     AC493
AC494     AC55.1    AC580     AC583     AC90.1    AC92.1
AC93.1    AC94.1    AC95.1    ACBA.1    ACDL.1    ACDM.2
ACVW.1    SE90.1    AP211     AR250     AR30.5    AR33.2
BR120     BR121     BR130     BR131     BR140     BR142
BR145     BR165     BR19.2    BR190     BR20.9    BR200
BR202     BR204     BR205     BR210     BR212     BR215
BR220     BR245     BR265     BR300     BR400     BR405
BR430     BR450     BR521     BR530     BR580     BR90.1
BRCC.1    BRIP.1    MX123     MX223     MX500

UPDATED BY

AC300     AC310     BR10.1    BR10.4    BR10.5    BR10.8
BR13.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADN-ACTIVITY-GRP       Alpha 15                                  BR10.4  BR10.8
Element: Activity GroupThe activity group associated with the    BR13.1
                       contract activity.

ADN-CONTRACT           Alpha 10                                  BR10.4  BR10.8
Element: Contract      The contract name maintained on Contract  BR13.1
                       parameters (BR10.1).

ADN-CONTRACT-TYPE      Alpha 1                                   BR10.4  BR13.1
Element: Contract Type 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

ADN-GOV-ORDER-NBR      Alpha 30                                  BR10.4  BR13.1
Element: Gov Order Nbr

ADN-PRIME-SUB-FL       Alpha 1                                   BR10.4  BR13.1
Element: Prime Sub Fl  P = Prime Contractor
                       S = Subcontractor
                       2 = 2nd Tier

ADN-PRIME-CNT-NBR      Alpha 30                                  BR10.4  BR13.1
Element: Prime Cnt Nbr

ADN-SUB-CNT-NBR        Alpha 30                                  BR10.4  BR13.1
Element: Sub Cnt Nbr

ADN-SIC-CODE           Numeric 6                                 BR10.4  BR13.1
Element: Sic Code

ADN-REF-NBR            Alpha 20                                  BR10.4  BR13.1
Element: Ref Nbr

ADN-CNT-VALUE          Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-CNT-FEE            Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-CNT-FEE-PCT        Signed 7.4                                AC310   BR10.1
Element: Cnt Fee Pct                                             BR10.4  BR10.5
                                                                 BR10.8

ADN-CNT-HOURS          Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-AWARD-VALUE        Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-AWARD-FEE          Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-AWARD-FEE-PCT      Signed 7.4                                AC310   BR10.1
Element: Award Fee Pct                                           BR10.4  BR10.5
                                                                 BR10.8

ADN-AWARD-HOURS        Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-FUNDED-VALUE       Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-FUNDED-FEE         Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-FUNDED-FEE-PCT     Signed 7.4                                AC310   BR10.1
Element: Funded Fee Pct                                          BR10.4  BR10.5
                                                                 BR10.8

ADN-FUNDED-HOURS       Signed 18.2                               AC310   BR10.1
Element: Intl Amt                                                BR10.4  BR10.5
                                                                 BR10.8

ADN-CONTRACT-NBR       Alpha 14                                  BR10.4  BR13.1
Element: Contract NumbeThis 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.

ADN-PO-NBR             Alpha 14                                  BR10.4  BR13.1
Element: PO Number     The 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.

ADN-TO-TOT-POP         Numeric 8  (yyyymmdd)                     BR10.4  BR10.5
Element: To Tot Pop                                              BR10.8

ADN-FR-TOT-POP         Numeric 8  (yyyymmdd)                     BR10.4  BR10.5
Element: Fr Tot Pop                                              BR10.8

ADN-TO-AWARD-POP       Numeric 8  (yyyymmdd)                     BR10.4  BR10.5
Element: To Award Pop                                            BR10.8

ADN-FR-AWARD-POP       Numeric 8  (yyyymmdd)                     BR10.4  BR10.5
Element: Fr Award Pop                                            BR10.8

ADN-TO-FUNDED-POP      Numeric 8  (yyyymmdd)                     BR10.4  BR10.5
Element: To Funded Pop                                           BR10.8

ADN-FR-FUNDED-POP      Numeric 8  (yyyymmdd)                     BR10.4  BR10.5
Element: Fr Funded Pop                                           BR10.8

ADN-CONTRACT-CLASS     Alpha 1                                   BR10.4  BR13.1
Element: Contract ClassG = Government
                       C = Commercial

ADN-CNT-COST           Signed 18.2                               BR10.1  BR10.4
Element: Intl Amt                                                BR10.5  BR10.8

ADN-AWARD-COST         Signed 18.2                               BR10.1  BR10.4
Element: Intl Amt                                                BR10.5  BR10.8

ADN-FUNDED-COST        Signed 18.2                               BR10.1  BR10.4
Element: Intl Amt                                                BR10.5  BR10.8

ADN-LONG-DESC          Alpha 60  (Lower Case)                    BR10.4  BR13.1
Element: Long DescriptiLong description.

                         ACADDLCNTR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADNSET1   ACTIVITY-GRP                                           AC00.1  AC01.1
          CONTRACT                                               AC105   AC112
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC13.3  AC130
                                                                 AC135   AC14.3
                                                                 AC145   AC160
                                                                 AC165   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 AC246   AC261
                                                                 ...

                         ACADDLCNTR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            ADN-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Accntract      ACCNTRACT    Required

                            ADN-CONTRACT        -> CNT-CONTRACT

                         ACADDLCNTR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntmod       ACCNTMOD

                            ADN-CONTRACT        -> CMD-CONTRACT
                                                   CMD-MOD-NBR