Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACADDLCNTR FILE

REFERENCED BY

AC00.1    ACBA.1    BR210     BR212     BRIP.1

UPDATED BY

AC300     AC310     BR10.1    BR10.5    BR13.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ADN-ACTIVITY-GRP     Alpha 15                                    BR10.1  BR10.5
Activity Group                                                   BR13.1

ADN-CONTRACT         Alpha 10                                    BR10.1  BR10.5
Contract                                                         BR13.1

ADN-CONTRACT-TYPE    Alpha 1                                     BR10.1  BR13.1
Contract Type

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

ADN-PRIME-SUB-FL     Alpha 1                                     BR10.1  BR13.1
Prime Sub Fl

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

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

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

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

ADN-CNT-VALUE        Signed 15.2                                 AC310   BR10.1
Cnt Value                                                        BR10.5

ADN-CNT-FEE          Signed 15.2                                 AC310   BR10.1
Cnt Fee                                                          BR10.5

ADN-CNT-FEE-PCT      Signed 7.4                                  AC310   BR10.1
Cnt Fee Pct                                                      BR10.5

ADN-CNT-HOURS        Signed 15.2                                 AC310   BR10.1
Cnt Hours                                                        BR10.5

ADN-AWARD-VALUE      Signed 15.2                                 AC310   BR10.1
Award Value                                                      BR10.5

ADN-AWARD-FEE        Signed 15.2                                 AC310   BR10.1
Award Fee                                                        BR10.5

ADN-AWARD-FEE-PCT    Signed 7.4                                  AC310   BR10.1
Award Fee Pct                                                    BR10.5

ADN-AWARD-HOURS      Signed 15.2                                 AC310   BR10.1
Award Hours                                                      BR10.5

ADN-FUNDED-VALUE     Signed 15.2                                 AC310   BR10.1
Funded Value                                                     BR10.5

ADN-FUNDED-FEE       Signed 15.2                                 AC310   BR10.1
Funded Fee                                                       BR10.5

ADN-FUNDED-FEE-PCT   Signed 7.4                                  AC310   BR10.1
Funded Fee Pct                                                   BR10.5

ADN-FUNDED-HOURS     Signed 15.2                                 AC310   BR10.1
Funded Hours                                                     BR10.5

ADN-CONTRACT-NBR     Alpha 14                                    BR10.1  BR13.1
Contract Number      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.1  BR13.1
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.1  BR10.5
To Tot Pop

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

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

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

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

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

ADN-CONTRACT-CLASS   Alpha 1                                     BR10.1  BR13.1
Contract Class

ADN-CNT-COST         Signed 15.2                                 BR10.1  BR10.5
Cnt Cost

ADN-AWARD-COST       Signed 15.2                                 BR10.1  BR10.5
Award Cost

ADN-FUNDED-COST      Signed 15.2                                 BR10.1  BR10.5
Funded Cost

ADN-LONG-DESC        Alpha 60  (Lower Case)                      BR10.1  BR10.5
Long Description                                                 BR13.1

                         ACADDLCNTR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADNSET1   ACTIVITY-GRP                                           AC00.1  AC300
          CONTRACT                                               AC310   ACBA.1
                                                                 BR10.1  BR10.4
                                                                 BR10.5  BR13.1
                                                                 BR210   BR212
                                                                 BRIP.1

                         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