 |
Lawson Insight Technical Documentation |
|
ACCNTRACT FILE
REFERENCED BY
AC04.1 AC121 AC123 AC130 AC170 AC190
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC30.2 AC30.3 AC32.1 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC490 AC493 AC530 AC54.1
AC540 AC541 AC551 AC70.1 AC70.4 AC741
AC93.4 AC93.5 ACBA.1 GR741 AR250 AR251
AR30.1 AR30.2 AR30.3 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 BR14.1 BR200 BR202 BR210 BR212
BR220 BR40.3 BR400 BR41.1 BR420 BR430
BR65.1 BR65.2 BRCC.1 BRIP.1 AC50.1 AC500
AC66.1 BR450 BR11.1
UPDATED BY
AC300 AC310 BR10.1 BR10.2 BR120 BR21.1
AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNT-CONTRACT Alpha 10 BR10.1
Contract
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 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 BR10.1 BR200
Contrct Amt Nd
CNT-CONTRACT-AMT Signed 15.2 BR10.1 BR10.2
Contract Amt BR65.1 BR65.2
CNT-CURRENCY-CODE Alpha 5 BR10.1
Currency Code This field contains the company base
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 AC190 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 BR21.1
Total Billed
CNT-TOT-UNT-BILLED Signed 15.2 BR21.1
Tot Unt Billed
CNT-TOT-REV-AMT Signed 15.2
Tot Rev Amt
CNT-TOT-REV-UNIT Signed 15.2
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 BR10.1
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
Apply Tol Amt
CNT-APPLY-TOL-UNIT Signed 15.2
Apply Tol Unit
ACCNTRACT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNTSET1 CONTRACT AC04.1 AC10.1
AC121 AC123
AC130 AC170
AC190 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC30.2
AC30.3 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.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
|