Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACADDLCNTR


                            ACADDLCNTR FILE

REFERENCED BY

AC00.1    AC01.1    AC105     AC112     AC113     AC120
AC121     AC123     AC13.3    AC130     AC135     AC160
AC165     AC190     AC191     AC196     AC198     AC200
AC203     AC206     AC207     AC210     AC213     AC218
AC220     AC240     AC258     AC261     AC265     AC290
AC295     AC297     AC298     AC30.3    AC32.1    AC34.1
AC35.1    AC36.1    AC400     AC401     AC410     AC412
AC420     AC421     AC440     AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC530
AC55.1    AC90.1    AC92.1    AC93.1    AC94.1    AC95.1
AC97.1    ACBA.1    ACVW.1    SE90.1    AR250     AR251
AR30.5    BR120     BR121     BR130     BR131     BR142
BR151     BR152     BR153     BR154     BR155     BR156
BR157     BR165     BR200     BR202     BR204     BR205
BR210     BR212     BR215     BR220     BR251     BR252
BR253     BR254     BR265     BR400     BR405     BR420
BR430     BR450     BR521     BR530     BR900     BRCC.1
BRIP.1    BRPI.1    MX123     MX500

UPDATED BY

AC300     AC310     BR10.1    BR10.4    BR10.5    BR13.1
BR15.1    BR15.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADN-ACTIVITY-GRP       Alpha 15                                  BR10.4  BR10.5
Element: Group                                                   BR13.1  BR15.3

ADN-CONTRACT           Alpha 10                                  BR10.4  BR10.5
Element: Bid Name                                                BR13.1  BR15.3

ADN-CONTRACT-TYPE      Alpha 1                                   BR10.4  BR13.1
Element: Contract Type                                           BR15.3

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

ADN-PRIME-SUB-FL       Alpha 1                                   BR10.4  BR13.1
Element: Prime Sub Fl                                            BR15.3

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

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

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

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

ADN-CNT-VALUE          Signed 15.2                               AC310   BR10.1
Element: Cnt Value                                               BR10.4  BR10.5
                                                                 BR15.1  BR15.3

ADN-CNT-FEE            Signed 15.2                               AC310   BR10.1
Element: Cnt Fee                                                 BR10.4  BR10.5
                                                                 BR15.1  BR15.3

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

ADN-CNT-HOURS          Signed 15.2                               AC310   BR10.1
Element: Cnt Hours                                               BR10.4  BR10.5
                                                                 BR15.1  BR15.3

ADN-AWARD-VALUE        Signed 15.2                               AC310   BR10.1
Element: Award Value                                             BR10.4  BR10.5
                                                                 BR15.1  BR15.3

ADN-AWARD-FEE          Signed 15.2                               AC310   BR10.1
Element: Award Fee                                               BR10.4  BR10.5
                                                                 BR15.1  BR15.3

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

ADN-AWARD-HOURS        Signed 15.2                               AC310   BR10.1
Element: Award Hours                                             BR10.4  BR10.5
                                                                 BR15.1  BR15.3

ADN-FUNDED-VALUE       Signed 15.2                               AC310   BR10.1
Element: Funded Value                                            BR10.4  BR10.5
                                                                 BR15.1  BR15.3

ADN-FUNDED-FEE         Signed 15.2                               AC310   BR10.1
Element: Funded Fee                                              BR10.4  BR10.5
                                                                 BR15.1  BR15.3

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

ADN-FUNDED-HOURS       Signed 15.2                               AC310   BR10.1
Element: Funded Hours                                            BR10.4  BR10.5
                                                                 BR15.1  BR15.3

ADN-CONTRACT-NBR       Alpha 14                                  BR10.4  BR13.1
Element: Contract NumbeThis is a number to indicate to the       BR15.3
                       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     BR15.3
                       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                                              BR15.3

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

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

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

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

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

ADN-CONTRACT-CLASS     Alpha 1                                   BR10.4  BR13.1
Element: Contract Class                                          BR15.3

ADN-CNT-COST           Signed 15.2                               BR10.1  BR10.4
Element: Cnt Cost                                                BR10.5  BR15.1
                                                                 BR15.3

ADN-AWARD-COST         Signed 15.2                               BR10.1  BR10.4
Element: Award Cost                                              BR10.5  BR15.1
                                                                 BR15.3

ADN-FUNDED-COST        Signed 15.2                               BR10.1  BR10.4
Element: Funded Cost                                             BR10.5  BR15.1
                                                                 BR15.3

ADN-LONG-DESC          Alpha 60  (Lower Case)                    BR10.4  BR13.1
Element: Long Description                                        BR15.3

                         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   AC160
                                                                 AC165   AC190
                                                                 AC191   AC196
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 AC258   AC261
                                                                 AC265   AC290
                                                                 ...

                         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