Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTRACT


                             ACCNTRACT FILE

The ACCNTRACT file defines the activity contract.  Contract data is entered
and maintained via BR10 (Contract Parameters).  Contract activities are
defined via AC10 (Activity) by entering a "C" in the level type field.  Only
one activity in a branch can be defined as a contract activity.  Contract
information defines the revenue method, contract amount, contract currency,
customer, and billed/unbilled accounts / account categories for billing and
revenue.

REFERENCED BY

AC01.1    AC04.1    AC105     AC112     AC113     AC12.1
AC121     AC123     AC128     AC13.3    AC130     AC135
AC145     AC160     AC165     AC169     AC190     AC191
AC197     AC198     AC20.1    AC20.2    AC20.3    AC20.4
AC20.5    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    AC37.1
AC40.1    AC40.4    AC400     AC401     AC41.1    AC41.4
AC410     AC412     AC42.1    AC420     AC421     AC440
AC460     AC471     AC472     AC473     AC480     AC490
AC493     AC494     AC50.1    AC527     AC54.1    AC540
AC55.1    AC56.1    AC560     AC580     AC583     AC90.1
AC90.2    AC90.4    AC90.6    AC90.8    AC92.1    AC92.2
AC92.4    AC92.6    AC93.1    AC93.4    AC93.5    AC94.1
AC94.2    AC94.4    AC94.6    AC95.1    AC95.2    AC95.4
AC95.6    ACAC.1    ACBA.1    ACDL.1    ACDM.2    ACDM.9
ACVW.1    SE90.1    AP125     AP126     AP178     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP211     AP23.1    AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP520     API1.1    API2.1    AR21.2
AR237     AR239     AR250     AR251     AR257     AR27.2
AR29.1    AR296     AR30.1    AR30.5    AR32.1    AR33.1
AR33.2    AR38.5    AR39.1    AR39.2    AR39.3    AR39.4
AR42.1    AR42.2    AR42.7    AR43.1    AR502     AR503
AR55.1    AR560     AR575     AR800     AR91.1    ARLL.1
BR00.1    BR00.2    BR00.3    BR01.2    BR01.1    BR02.1
BR02.2    BR02.3    BR03.1    BR03.2    BR03.3    BR05.1
BR05.2    BR05.3    BR05.4    BR05.5    BR07.1    BR121
BR123     BR124     BR14.1    BR142     BR145     BR15.2
BR151     BR152     BR153     BR154     BR155     BR156
BR157     BR165     BR18.1    BR18.2    BR18.3    BR19.1
BR19.2    BR190     BR200     BR202     BR204     BR205
BR21.1    BR21.2    BR210     BR212     BR215     BR218
BR220     BR245     BR251     BR252     BR253     BR254
BR265     BR31.1    BR31.2    BR31.3    BR31.4    BR40.3
BR40.4    BR400     BR405     BR420     BR422     BR43.1
BR430     BR44.1    BR45.1    BR450     BR51.1    BR51.2
BR515     BR516     BR52.1    BR52.2    BR52.3    BR52.4
BR52.5    BR52.7    BR53.1    BR53.2    BR54.2    BR54.3
BR54.4    BR54.1    BR55.1    BR55.2    BR56.1    BR570
BR65.1    BR65.3    BR65.2    BR70.1    BR70.2    BR71.1
BR90.1    BR96.1    BRIP.1    ET175     ET540     ET542
MX123     MX500     MA41.1    MA41.2    MA41.4    MA41.7
MA43.2    MA61.1    MAI1.1    SN02.1    SNAC.1    AC110
AC19.1    AC45.1    AC500     BR206     BR41.1    BR41.4
BR42.1    PW510     BR11.1    BR91.1

UPDATED BY

AC10.1    AC120     AC300     AC310     BR10.1    BR10.2
BR10.9    BR12.2    BR120     BR122     BR130     BR131
BR140     BR20.1    BR20.2    BR20.3    BR20.4    BR20.5
BR22.1    BR300     BR46.1    BR46.2    BR46.4    BR521
BR530     BR580     PW110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CNT-CONTRACT           Alpha 15                                  BR10.1  BR10.9
Element: Contract      Activity Management contract.             PW110

CNT-ACTIVITY           Alpha 15                                  BR10.1  BR10.9
Element: Activity      Activities are the processes or           BR120   BR121
                       procedures that produce work. Cost        BR122   BR123
                       objects (products, services, customers,   BR140   BR151
                       and so on) are the reasons for            BR152   BR156
                       performing the activity.                  BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR420
                                                                 BR521   PW110

CNT-DESCRIPTION        Alpha 30  (Lower Case)                    BR07.1  BR10.1
Element: Description   This field displays the description.      BR10.9  PW110

CNT-REVENUE-MTHD       Alpha 1                                   BR10.1  BR10.9
Element: Revenue Mthd  A = Accrual                               PW110
                       P = Percent Complete
                       C = Completed Contract
                       9 = User Defined
                       M = Milestone
                       T = Cost Plus
                       1 = Product
                       2 = Maintenance
                       3 = Prod and Maint

CNT-CONTRCT-AMT-ND     Numeric 1                                 BR10.1  BR10.9
Element: Contrct Amt Nd                                          BR200   PW110

CNT-CONTRACT-AMT       Signed 18.2                               AC10.1  AC120
Element: Intl Amt                                                BR10.1  BR10.2
                                                                 BR10.9  BR12.2
                                                                 BR22.1  PW110

CNT-CURRENCY-CODE      Alpha 5                                   BR10.1  BR10.9
Element: Currency Code This field contains the company base      PW110
                       currency code established in Company
                       (GL10.1 ).

CNT-FIXED-EXCHANGE     Alpha 1                                   BR10.1  BR10.9
Element: Fixed ExchangeY = Yes                                   PW110
                       N = No

CNT-MULT-DIV           Alpha 1                                   BR10.1  BR10.9
Element: Mult Div      M = Multiply                              PW110
                       D = Divide

CNT-EXCHANGE-RATE      Signed 14.7                               BR10.1  BR10.9
Element: Acct Rate                                               PW110

CNT-CUST-PO-NBR        Alpha 22                                  BR10.1  BR10.9
Element: Cust Po Nbr                                             PW110

CNT-GROUP              Alpha 15                                  BR10.1  PW110
Element: Group

CNT-COMBINE-CONT       Alpha 1                                   BR10.1  PW110
Element: Combine Cont  C = Contract/Non-Segment
                       P = Posting/Segment
                       1 = Posting/Acct Cat/Segment
                       2 = Contract/Acct Cat/Non-Segment

CNT-PCT-CMPLT-MTHD     Alpha 1                                   BR10.1  PW110
Element: Pct Cmplt MthdA = Alternative A (% Complete)
                       B = Alternative B (Gross Margin)

CNT-BUDGET-TYPE        Alpha 1                                   BR10.1  PW110
Element: Budget Type   A = Amount
                       U = Units

CNT-TOTAL-BILLED       Signed 18.2                               AC300   BR122
Element: Intl Amt                                                BR140   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR580

CNT-TOT-UNT-BILLED     Signed 18.2                               AC300   BR122
Element: Intl Amt                                                BR140   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR580

CNT-TOT-REV-AMT        Signed 18.2                               AC300   BR580
Element: Intl Amt

CNT-TOT-REV-UNIT       Signed 15.2                               AC300   BR580
Element: Tot Rev Unit

CNT-CUSTOMER           Alpha 9  (Right Justified)                AR250   AR251
Element: Customer      This field contains the number that       AR30.1  AR32.1
                       represents a customer.                    AR33.1  AR39.1
                                                                 AR39.2  BR10.1
                                                                 BR10.9  PW110

CNT-AC-CUSTOMER-ID     Alpha 5                                   BR10.1  BR10.9
Element: Ac Customer Id                                          PW110

CNT-COMPANY            Numeric 4                                 BR10.1  BR10.9
Element: Company       Identifies the AP company if the          PW110
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

CNT-UNBL-AR-GL-CD      Alpha 4                                   BR10.1  PW110
Element: Unbl Ar Gl Cd

CNT-UNBL-ACCT-CAT      Alpha 5                                   BR10.1  PW110
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

CNT-ADV-BILL-GL-CD     Alpha 4                                   BR10.1  PW110
Element: Adv Bill Gl Cd

CNT-ADV-BL-ACT-CAT     Alpha 5                                   BR10.1  PW110
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

CNT-PS-THRU-GL-CD      Alpha 4                                   BR10.1  PW110
Element: Ps Thru Gl Cd

CNT-PS-THRU-CAT        Alpha 5                                   BR10.1  PW110
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

CNT-TOLERANCE-AMT      Signed 18.2                               BR10.1  PW110
Element: Intl Amt

CNT-AUTO-JRL-CD        Alpha 4                                   BR10.1  PW110
Element: Auto Jrl Cd

CNT-JOURNAL-CODE       Alpha 4
Element: Journal Code

CNT-REVENUE-FLAG       Alpha 1                                   BR10.1  PW110
Element: Revenue Flag  This flag identifies whether an
                       activity/account category is eligible
                       for revenue recognition.
                       I = Include
                       E = Exclude

CNT-BILLING-FLAG       Alpha 1                                   BR10.1  PW110
Element: Billing Flag  I = Include
                       E = Exclude

CNT-APPLY-TOL-AMT      Signed 18.2                               AC300   BR130
Element: Intl Amt                                                BR131   BR530
                                                                 BR580

CNT-APPLY-TOL-UNIT     Signed 15.2                               AC300   BR580
Element: Apply Tol Unit

CNT-DFLT-ACTIVITY      Alpha 15                                  BR10.1  PW110
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


CNT-DFLT-ACCT-CAT      Alpha 5                                   BR10.1  PW110
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

CNT-DFLT-COMPANY       Numeric 4                                 BR10.1  PW110
Element: Dflt Company

CNT-DFLT-ACCT-UNIT     Alpha 15                                  BR10.1  PW110
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


CNT-DFLT-ACCOUNT       Numeric 6
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

CNT-DFLT-SUB-ACCT      Numeric 4
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

CNT-RETAIN-GL-CD       Alpha 4                                   BR10.1  PW110
Element: Retain Gl Cd

CNT-RETAIN-CAT         Alpha 5                                   BR10.1  PW110
Element: Retain Cat

CNT-REAL-METHOD-FL     Alpha 1                                   BR10.1  PW110
Element: Real Method Fl1 = Prorate
                       2 = No Prorate; Use Defaults
                       3 = No Prorate; Use Activity

CNT-REAL-AU-FL         Alpha 1                                   BR10.1  PW110
Element: Real Au Fl    A = Activity Company Acct Unit
                       T = Trans Company Acct Unit

CNT-FORCE-DETAIL       Alpha 1                                   BR10.1  PW110
Element: Force Detail  This field determines whether this
                       individual transaction can be summarized
                       along with other like transactions.
                       Y = Yes
                       N = No

CNT-RET-ACCOUNT        Numeric 6                                 BR10.1  PW110
Element: Ret Account

CNT-RET-SUB-ACCT       Numeric 4                                 BR10.1  PW110
Element: Ret Sub Acct

CNT-BILL-PAID-AP       Alpha 1                                   BR10.1  PW110
Element: Bill Paid Ap  This is the "Exclude Unpaid AP" flag
                       maintained in the contract parameters
                       (BR10).
                       The values are:
                       Y = Yes
                       N = No

CNT-LETTER-CREDIT      Alpha 20                                  BR10.1  PW110
Element: Letter Credit

CNT-DOCUMENT-NBR       Alpha 20                                  BR10.1  PW110
Element: Document Numbr

CNT-EX-CEILINGS        Alpha 1                                   BR10.1  PW110
Element: Ex Ceilings   Y = Yes
                       N = No

CNT-PURGE-FL           Alpha 1                                   BR300
Element: Purge Fl

CNT-MT-RENEW-DATE      Derived
Element: Mt Renew Date

                         ACCNTRACT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CNTSET1   CONTRACT                                               AC01.1  AC04.1
                                                                 AC10.1  AC10.5
                                                                 AC105   AC112
                                                                 AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC128
                                                                 AC13.3  AC130
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC200   AC203
                                                                 ...

CNTSET2   ACTIVITY      KeyChange                                AC10.1  AC10.5
          CONTRACT                                               AC110   AC112
                                                                 AC113   AC12.1
                                                                 AC120   AC121
                                                                 AC123   AC128
                                                                 AC135   AC145
                                                                 AC160   AC165
                                                                 AC169   AC19.1
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC225   AC240
                                                                 ...

CNTSET3   COMPANY       KeyChange                                AC56.1  AC560
          CUSTOMER                                               BR11.1  BR19.1
          AC-CUSTOMER-ID
          CONTRACT

CNTSET4   LETTER-CREDIT KeyChange                                AC112   AC113
          CONTRACT                                               AC121   AC123
          ACTIVITY                                               AC128   AC135
                                                                 AC145   AC160
                                                                 AC165   AC169
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC225   AC240
                                                                 AC246   AC261
                                                                 AC265   AC290
                                                                 AC295   AC298
                                                                 ...

CNTSET5   COMPANY       KeyChange                                BR91.1
          CUSTOMER
          CONTRACT

                         ACCNTRACT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            CNT-ACTIVITY          -> ACV-ACTIVITY

Acaddlcntr     ACADDLCNTR   Not Required

                            ACV-ACTIVITY-GRP      -> ADN-ACTIVITY-GRP
                            CNT-CONTRACT          -> ADN-CONTRACT

Accntrpcd      ACCNTRPCD    Not Required

                            CNT-CONTRACT          -> CNP-CONTRACT

Accustdtl      ACCUSTDTL    Required

                            CNT-COMPANY           -> CMB-COMPANY
                            CNT-CUSTOMER          -> CMB-CUSTOMER

Accustomer     ACCUSTOMER   Required

                            CNT-COMPANY           -> CMR-COMPANY
                            CNT-CUSTOMER          -> CMR-CUSTOMER
                            CNT-AC-CUSTOMER-ID    -> CMR-AC-CUSTOMER-ID

Acfeedtl       ACFEEDTL     Required

                            CNT-CONTRACT          -> FDT-CONTRACT

Acmilestn      ACMILESTN    Not Required
                            Valid When CNT-REVENUE-MTHD = "M"

                            CNT-ACTIVITY          -> MLS-ACTIVITY
                            "R"                   -> MLS-MILESTONE-CAT

Acprodhdr      ACPRODHDR    Not Required

                            CNT-CONTRACT          -> AHR-CONTRACT

Arcomp         ARCOMP       Required

                            CNT-COMPANY           -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            CNT-COMPANY           -> ACM-COMPANY
                            CNT-CUSTOMER          -> ACM-CUSTOMER

                         ACCNTRACT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acceiling      ACCEILING

                            CNT-ACTIVITY          -> CEH-ACTIVITY
                                                     CEH-ACCT-CATEGORY
                                                     CEH-SUM-ACCT-CAT
                                                     CEH-CTR-CAT-GRP
                                                     CEH-MATRIX-CAT

Acclgtrans     ACCLGTRANS

                            CNT-CONTRACT          -> CGT-CONTRACT
                                                     CGT-ATN-OBJ-ID
                                                     CGT-LEVEL

Accntmod       ACCNTMOD

                            CNT-CONTRACT          -> CMD-CONTRACT
                                                     CMD-MOD-NBR

Accntracct     ACCNTRACCT

                            CNT-CONTRACT          -> CNA-CONTRACT
                                                     CNA-ACCT-CATEGORY

Accntractx     ACCNTRACTX

                            CNT-CONTRACT          -> CNX-CONTRACT
                                                     CNX-ACTIVITY

Accntrcat      ACCNTRCAT

                            CNT-CONTRACT          -> CNC-CONTRACT
                                                     CNC-ACTIVITY
                                                     CNC-ACCT-CATEGORY

Accontacts     ACCONTACTS

                            ACV-ACTIVITY-GRP      -> CTS-ACTIVITY-GRP
                            CNT-CONTRACT          -> CTS-CONTRACT
                                                     CTS-RESP-CODE

Acctrcatg      ACCTRCATG

                            CNT-CONTRACT          -> BCG-CONTRACT
                                                     BCG-CTR-CAT-GRP

Acctrcatgx     ACCTRCATGX

                            CNT-CONTRACT          -> BCX-CONTRACT
                                                     BCX-ACCT-CATEGORY

Acfeebal       ACFEEBAL

                            CNT-CONTRACT          -> FBL-CONTRACT
                                                     FBL-ACTIVITY
                                                     FBL-TYPE
                                                     FBL-FEE-CD
                                                     FBL-COMPANY
                                                     FBL-ACCT-UNIT

Achistclg      ACHISTCLG

                            CNT-CONTRACT          -> HCT-CONTRACT
                                                     HCT-OBJ-ID
                                                     HCT-LINE-NBR
                                                     HCT-ATN-OBJ-ID
                                                     HCT-LEVEL

Achistcnsl     ACHISTCNSL

                            CNT-CONTRACT          -> IHC-CONTRACT
                                                     IHC-OBJ-ID
                                                     IHC-LINE-NBR

Achistdtl      ACHISTDTL

                            CNT-CONTRACT          -> HDT-CONTRACT
                                                     HDT-OBJ-ID
                                                     HDT-LINE-NBR

Achisthdr      ACHISTHDR

                            CNT-CONTRACT          -> HIH-CONTRACT
                                                     HIH-COMPANY
                                                     HIH-CUSTOMER
                                                     HIH-AC-CUSTOMER-ID
                                                     HIH-INVOICE
                                                     HIH-OBJ-ID

Acmnthdr       ACMNTHDR

                            CNT-CONTRACT          -> MSE-CONTRACT
                                                     MSE-MAINT-SCHEDULE

Acmntsch       ACMNTSCH

                            CNT-CONTRACT          -> MSC-CONTRACT
                                                     MSC-MAINT-SCHEDULE
                                                     MSC-PRODUCT
                                                     MSC-PROD-VERSION
                                                     MSC-OBJ-ID

Acpmhsthdr     ACPMHSTHDR

                            CNT-CONTRACT          -> PMH-CONTRACT
                                                     PMH-COMPANY
                                                     PMH-CUSTOMER
                                                     PMH-AC-CUSTOMER-ID
                                                     PMH-INVOICE
                                                     PMH-OBJ-ID

Acprodinv      ACPRODINV

                            CNT-CONTRACT          -> PDI-CONTRACT
                                                     PDI-OBJ-ID

Acretain       ACRETAIN

                            CNT-ACTIVITY          -> RET-ACTIVITY
                                                     RET-RETAIN-ID

Acretng        ACRETNG

                            CNT-ACTIVITY          -> RTG-ACTIVITY
                                                     RTG-SUM-ACCT-CAT
                                                     RTG-CTR-CAT-GRP
                                                     RTG-ACCT-CATEGORY

Aracpivot      ARACPIVOT

                            CNT-CONTRACT          -> CCP-CONTRACT
                                                     CCP-DUE-DATE
                                                     CCP-TRANS-TYPE
                                                     CCP-BATCH-NBR
                                                     CCP-TRANSACTION
                                                     CCP-PAYMENT-SEQ
                                                     CCP-COMPANY