Lawson Insight Technical Documentation |
|
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 AC13.3 AC130 AC135 AC145
AC160 AC165 AC190 AC191 AC197 AC198
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 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 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
AC54.1 AC540 AC55.1 AC580 AC583 AC90.1
AC92.1 AC93.1 AC93.4 AC93.5 AC94.1 AC95.1
ACAC.1 ACBA.1 ACDL.1 ACDM.2 ACVW.1 SE90.1
AP125 AP126 AP175 AP178 AP211 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP520
API1.1 API2.1 AR250 AR251 AR30.1 AR30.5
AR33.1 AR33.2 BR00.1 BR00.2 BR00.3 BR02.1
BR02.2 BR02.3 BR03.1 BR03.2 BR03.3 BR05.1
BR05.2 BR05.3 BR05.4 BR05.5 BR07.1 BR12.1
BR121 BR14.1 BR142 BR145 BR15.2 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
BR265 BR40.3 BR40.4 BR400 BR405 BR420
BR43.1 BR430 BR44.1 BR45.1 BR450 BR515
BR516 BR65.1 BR65.2 BR90.1 BR96.1 BRCC.1
BRIP.1 MX123 MX500 MA61.1 MAI1.1 TX101
AC110 AC45.1 AC500 BR01.1 BR01.2 BR206
BR41.1 BR41.4 BR11.1
UPDATED BY
AC10.1 AC120 AC300 AC310 BR10.1 BR10.2
BR120 BR122 BR130 BR131 BR140 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR300 BR46.1
BR46.2 BR46.4 BR521 BR530 BR580
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNT-CONTRACT Alpha 10 AC190 AC197
Element: Contract Activity Management contract. BR10.1
CNT-ACTIVITY Alpha 15 AC197 BR10.1
Element: Activity Activities are the processes or BR122 BR20.1
procedures that produce work. Cost BR20.2 BR20.3
objects (products, services, customers, BR20.4 BR20.5
and so on) are the reasons for
performing the activity.
CNT-DESCRIPTION Alpha 30 (Lower Case) BR07.1 BR10.1
Element: Description This field displays the description.
CNT-REVENUE-MTHD Alpha 1 AC190 BR10.1
Element: Revenue Mthd A = Accrual
P = Percent Complete
C = Completed Contract
9 = User Defined
M = Milestone
T = Cost Plus
CNT-CONTRCT-AMT-ND Numeric 1 AC190 AC197
Element: Contrct Amt Nd BR10.1 BR200
CNT-CONTRACT-AMT Signed 18.2 AC10.1 AC120
Element: Intl Amt BR10.1 BR10.2
CNT-CURRENCY-CODE Alpha 5 AC190 AC197
Element: Currency Code This field contains the company base BR10.1
currency code established in Company
(GL10.1 ).
CNT-FIXED-EXCHANGE Alpha 1 BR10.1
Element: Fixed ExchangeY = Yes
N = No
CNT-MULT-DIV Alpha 1 BR10.1
Multiply/Divide M = Multiply
Option D = Divide
CNT-EXCHANGE-RATE Signed 14.7 BR10.1
Element: Account Rate
CNT-CUST-PO-NBR Alpha 22 BR10.1
Element: Customer P.O. Number
CNT-GROUP Alpha 15 BR10.1
Element: Group
CNT-COMBINE-CONT Alpha 1 BR10.1
Element: Combine Cont C = Contract/Non-Segment
P = Posting/Segment
CNT-PCT-CMPLT-MTHD Alpha 1 BR10.1
Element: Pct Cmplt MthdA = Alternative A (% Complete)
B = Alternative B (Gross Margin)
CNT-BUDGET-TYPE Alpha 1 BR10.1
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 NumbeThis field contains the number that AR30.1 AR33.1
represents a customer. BR10.1
CNT-AC-CUSTOMER-ID Alpha 5 BR10.1
Element: Ac Customer Id
CNT-COMPANY Numeric 4 BR10.1
Element: Company Identifies the AP company if the
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
Element: Unbl Ar Gl Cd
CNT-UNBL-ACCT-CAT Alpha 5 BR10.1
Element: Account Category
CNT-ADV-BILL-GL-CD Alpha 4 BR10.1
Element: Adv Bill Gl Cd
CNT-ADV-BL-ACT-CAT Alpha 5 BR10.1
Element: Account Category
CNT-PS-THRU-GL-CD Alpha 4 BR10.1
Element: Ps Thru Gl Cd
CNT-PS-THRU-CAT Alpha 5 BR10.1
Element: Account Category
CNT-TOLERANCE-AMT Signed 18.2 BR10.1
Element: Intl Amt
CNT-AUTO-JRL-CD Alpha 4 BR10.1
Element: Auto Jrl Cd
CNT-JOURNAL-CODE Alpha 4
Element: Journal Code
CNT-REVENUE-FLAG Alpha 1 BR10.1
Element: Revenue Flag This flag identifies whether an
activity/account category is eligible
for revenue recognition.
CNT-BILLING-FLAG Alpha 1 BR10.1
Element: Billing Flag
CNT-APPLY-TOL-AMT Signed 18.2 AC300 BR130
Element: Intl Amt This field applies to revenue only. This BR131 BR530
field accummulates the totla amount of BR580
fee tolerance already used for this
contract. This amount is used to
determine whether or not additonal fee
over the maximum is recognized as risk
revenue. The value stored in this feld
will be in contract currency.
CNT-APPLY-TOL-UNIT Signed 15.2 AC300 BR580
Element: Apply Tol Unit
CNT-DFLT-ACTIVITY Alpha 15 BR10.1
Element: Activity
CNT-DFLT-ACCT-CAT Alpha 5 BR10.1
Element: Account Category
CNT-DFLT-COMPANY Numeric 4 BR10.1
Element: Dflt Company
CNT-DFLT-ACCT-UNIT Alpha 15 BR10.1
Element: Accounting Unit
CNT-DFLT-ACCOUNT Numeric 6
Element: Account
CNT-DFLT-SUB-ACCT Numeric 4
Element: Subaccount
CNT-RETAIN-GL-CD Alpha 4 BR10.1
Element: Retain Gl Cd
CNT-RETAIN-CAT Alpha 5 BR10.1
Element: Retain Cat
CNT-REAL-METHOD-FL Alpha 1 BR10.1
Element: Real Method Fl1
2
3
CNT-REAL-AU-FL Alpha 1 BR10.1
Element: Real Au Fl
CNT-FORCE-DETAIL Alpha 1 BR10.1
Element: Force Detail This field determines whether this
individual transaction can be summarized
along with other like transactions.
CNT-RET-ACCOUNT Numeric 6 BR10.1
Element: Ret Account
CNT-RET-SUB-ACCT Numeric 4 BR10.1
Element: Ret Sub Acct
CNT-BILL-PAID-AP Alpha 1 BR10.1
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
Element: Letter Credit
CNT-DOCUMENT-NBR Alpha 20 BR10.1
Element: Document NumbrThe number assigned to the transaction
(invoice, credit memo, etc.) for which
the intrastat data was entered.
CNT-EX-CEILINGS Alpha 1 BR10.1
Element: Ex Ceilings Y = Yes
N = No
CNT-PURGE-FL Alpha 1 BR300
Element: Purge
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 AC13.3
AC130 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
AC206 AC207
...
CNTSET2 ACTIVITY KeyChange AC10.1 AC10.5
CONTRACT AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC261
AC265 AC290
...
CNTSET3 COMPANY KeyChange BR11.1 BR19.1
CUSTOMER
AC-CUSTOMER-ID
CONTRACT
CNTSET4 LETTER-CREDIT KeyChange
ACTIVITY
CONTRACT
ACCNTRACT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
CNT-ACTIVITY -> ACV-ACTIVITY (ACVSET1)
Acaddlcntr ACADDLCNTR Not Required
ACV-ACTIVITY-GRP -> ADN-ACTIVITY-GRP
CNT-CONTRACT -> ADN-CONTRACT
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
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
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
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
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
|