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     AC128     AC13.3    AC130     AC135
AC14.3    AC145     AC160     AC165     AC169     AC190
AC191     AC197     AC198     AC200     AC203     AC206
AC207     AC210     AC213     AC218     AC220     AC225
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     AC527     AC55.1
AC580     AC583     AC90.1    AC92.1    AC93.1    AC94.1
AC95.1    ACBA.1    ACDL.1    ACDM.2    ACDM.9    ACVW.1
SE90.1    AP211     AR21.2    AR237     AR239     AR250
AR257     AR27.2    AR29.1    AR296     AR30.5    AR32.1
AR33.2    AR38.5    AR39.3    AR39.4    AR42.1    AR42.2
AR42.7    AR43.1    AR502     AR503     AR55.1    AR560
AR575     AR800     AR91.1    ARLL.1    BR120     BR121
BR130     BR131     BR140     BR142     BR145     BR151
BR152     BR153     BR154     BR155     BR156     BR157
BR165     BR19.2    BR190     BR20.9    BR200     BR202
BR204     BR205     BR210     BR212     BR215     BR220
BR245     BR251     BR252     BR253     BR254     BR265
BR300     BR400     BR405     BR422     BR430     BR450
BR521     BR530     BR580     BR90.1    BRIP.1    MX123
MX223     MX500     SN02.1    SNAC.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ADN-CONTRACT           Alpha 15                                  BR10.4  BR10.8
Element: Contract      The contract name maintained on           BR13.1
                       Contract 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  BR10.9

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ADN-LONG-DESC          Alpha 60  (Lower Case)                    BR10.4  BR13.1
Element: Long Desc     Long 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
                                                                 AC128   AC13.3
                                                                 AC130   AC135
                                                                 AC14.3  AC145
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC225
                                                                 ...

                         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