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 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
|