 |
Lawson Insight Technical Documentation |
|
ACCNTRACT FILE
REFERENCED BY
AC04.1 AC121 AC123 AC130 AC170 AC190
AC192 AC198 AC20.1 AC20.2 AC20.3 AC20.4
AC20.5 AC32.1 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC490 AC493 AC530 AC54.1 AC540
AC541 AC551 AC70.1 AC70.4 AC93.4 AC93.5
DA233 AR250 AR251 AR30.1 AR30.2 AR30.3
DA90.1 DA91.1 BR00.1 BR00.2 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
BR131 BR14.1 BR200 BR202 BR210 BR212
BR220 BR40.3 BR40.4 BR400 BR41.1 BR420
BR430 BR65.1 BR65.2 BRCC.1 BRIP.1 AC50.1
AC500 AC66.1 BR450 BR11.1
UPDATED BY
AC10.1 AC120 AC300 AC310 BR10.1 BR10.2
BR120 BR130 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR21.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNT-CONTRACT Alpha 10 AC190 AC541
Contract BR10.1
CNT-ACTIVITY Alpha 15 BR10.1
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-DESCRIPTION Alpha 30 (Lower Case) BR10.1
Description This field displays the description.
CNT-REVENUE-MTHD Alpha 1 AC190 BR10.1
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 BR10.1
Contrct Amt Nd BR200
CNT-CONTRACT-AMT Signed 15.2 AC10.1 AC120
Contract Amt BR10.1 BR10.2
BR65.1
CNT-CURRENCY-CODE Alpha 5 AC190 AC541
Currency Code This field contains the company base BR10.1
currency code established in Company
(GL10.1 ).
CNT-FIXED-EXCHANGE Alpha 1 BR10.1
Fixed Exchange Y = Yes
N = No
CNT-MULT-DIV Alpha 1 BR10.1
Multiply/Divide M = Multiply
Option D = Divide
CNT-EXCHANGE-RATE Signed 12.6 AC192 BR10.1
Exchange Rate
CNT-CUST-PO-NBR Alpha 22 BR10.1
Customer P.O. Number
CNT-GROUP Alpha 15 BR10.1
Group
CNT-COMBINE-CONT Alpha 1 BR10.1
Combine Cont C = Contract/Non-Segment
P = Posting/Segment
CNT-PCT-CMPLT-MTHD Alpha 1 BR10.1
Pct Cmplt Mthd A = Alternative A (% Complete)
B = Alternative B (Gross Margin)
CNT-BUDGET-TYPE Alpha 1 BR10.1
Budget Type A = Amount
U = Units
CNT-TOTAL-BILLED Signed 15.2 AC300 BR20.1
Total Billed BR20.2 BR20.3
BR20.4 BR20.5
BR21.1
CNT-TOT-UNT-BILLED Signed 15.2 AC300 BR20.1
Tot Unt Billed BR20.2 BR20.3
BR20.4 BR20.5
BR21.1
CNT-TOT-REV-AMT Signed 15.2 AC300
Tot Rev Amt
CNT-TOT-REV-UNIT Signed 15.2 AC300
Tot Rev Unit
CNT-CUSTOMER Alpha 9 (Right Justified) AR250 AR251
Customer Number This field contains the number that AR30.1 AR30.2
represents a customer. AR30.3 BR10.1
CNT-AC-CUSTOMER-ID Alpha 5 BR10.1
Ac Customer Id
CNT-COMPANY Numeric 4 BR10.1
Company The company number represents an
established company and is entered on
all function codes.
CNT-UNBL-AR-GL-CD Alpha 4 BR10.1
Unbl Ar Gl Cd
CNT-UNBL-ACCT-CAT Alpha 5 BR10.1
Unbl Acct Cat
CNT-ADV-BILL-GL-CD Alpha 4 BR10.1
Adv Bill Gl Cd
CNT-ADV-BL-ACT-CAT Alpha 5 BR10.1
Adv Bl Act Cat
CNT-PS-THRU-GL-CD Alpha 4 BR10.1
Ps Thru Gl Cd
CNT-PS-THRU-CAT Alpha 5 BR10.1
Ps Thru Cat
CNT-TOLERANCE-AMT Signed 15.2 BR10.1
Tolerance Amt
CNT-AUTO-JRL-CD Alpha 4 BR10.1
Auto Jrl Cd
CNT-JOURNAL-CODE Alpha 4
Journal Code
CNT-REVENUE-FLAG Alpha 1 BR10.1
Revenue Flag
CNT-BILLING-FLAG Alpha 1 BR10.1
Billing Flag
CNT-APPLY-TOL-AMT Signed 15.2 AC300 BR130
Apply Tol Amt
CNT-APPLY-TOL-UNIT Signed 15.2 AC300
Apply Tol Unit
CNT-DFLT-ACTIVITY Alpha 15 BR10.1
Dflt Activity
CNT-DFLT-ACCT-CAT Alpha 5 BR10.1
Dflt Acct Cat
CNT-DFLT-COMPANY Numeric 4 BR10.1
Dflt Company
CNT-DFLT-ACCT-UNIT Alpha 15 BR10.1
Dflt Acct Unit
CNT-DFLT-ACCOUNT Numeric 6
Dflt Account
CNT-DFLT-SUB-ACCT Numeric 4
Dflt Sub Acct
CNT-DFLT-MX-CAT Alpha 12 BR10.1
Dflt Mx Cat
CNT-DFLT-MX-VALUE Alpha 32 BR10.1
Dflt Mx Value
CNT-RETAIN-GL-CD Alpha 4 BR10.1
Retain Gl Cd
CNT-RETAIN-CAT Alpha 5 BR10.1
Retain Cat
CNT-REAL-METHOD-FL Alpha 1 BR10.1
Real Method Fl 1
2
3
CNT-REAL-AU-FL Alpha 1 BR10.1
Real Au Fl
CNT-FORCE-DETAIL Alpha 1 BR10.1
Force Detail This field determines whether this
individual transaction can be summarized
along with other like transactions.
CNT-RET-ACCOUNT Numeric 6 BR10.1
Ret Account
CNT-RET-SUB-ACCT Numeric 4 BR10.1
Ret Sub Acct
CNT-RET-APPLY-FL Alpha 1
Ret Apply Fl
ACCNTRACT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNTSET1 CONTRACT AC04.1 AC10.1
AC120 AC121
AC123 AC130
AC170 AC190
AC192 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC310
AC32.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC490 AC493
AC530 AC54.1
AC540 AC541
AC551 AC70.1
...
CNTSET2 ACTIVITY KeyChange AC10.1 AC300
CONTRACT AC50.1 AC500
AC66.1 BR02.2
BR02.3 BR05.1
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR210
BR430 BR450
BR65.1 BR65.2
BRCC.1
CNTSET3 CUSTOMER KeyChange BR11.1
AC-CUSTOMER-ID
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
Accustomer ACCUSTOMER Required
CNT-COMPANY -> CMR-COMPANY
CNT-CUSTOMER -> CMR-CUSTOMER
CNT-AC-CUSTOMER-ID -> CMR-AC-CUSTOMER-ID
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-ACCT-CAT-CLASS
CEH-MATRIX-CAT
Acclgtrans ACCLGTRANS
CNT-ACTIVITY -> CGT-CONT-ACTIVITY
CGT-BILL-ACTIVITY
CGT-ACCT-CATEGORY
CGT-ACCT-CAT-CLASS
CGT-MATRIX-CAT
CGT-MX-VALUE
CGT-OBJ-ID
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
Achistcnsl ACHISTCNSL
CNT-CONTRACT -> IHC-CONTRACT
IHC-COMPANY
IHC-CUSTOMER
IHC-AC-CUSTOMER-ID
IHC-INVOICE-PREFIX
IHC-INVOICE-NBR
IHC-LINE-NBR
Achisthdr ACHISTHDR
CNT-CONTRACT -> HIH-CONTRACT
HIH-COMPANY
HIH-CUSTOMER
HIH-AC-CUSTOMER-ID
HIH-INVOICE-PREFIX
HIH-INVOICE-NBR
Acinvhdr ACINVHDR
CNT-CONTRACT -> IVH-CONTRACT
IVH-COMPANY
IVH-CUSTOMER
IVH-AC-CUSTOMER-ID
IVH-INVOICE-PREFIX
IVH-INVOICE-NBR
Acretain ACRETAIN
CNT-ACTIVITY -> RET-ACTIVITY
RET-RETAIN-ID
Acretng ACRETNG
CNT-ACTIVITY -> RTG-ACTIVITY
RTG-ACCT-CAT-CLASS
RTG-ACCT-CATEGORY
|