Lawson Insight Technical Documentation |
|
ACCNTRACT
ACCNTRACT FILE
REFERENCED BY
AC01.1 AC04.1 AC105 AC112 AC113 AC121
AC123 AC13.3 AC130 AC135 AC160 AC165
AC190 AC191 AC192 AC196 AC198 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC203 AC206
AC207 AC210 AC213 AC218 AC220 AC240
AC258 AC261 AC265 AC290 AC295 AC297
AC298 AC30.3 AC32.1 AC34.1 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 AC530 AC54.1 AC540
AC541 AC55.1 AC551 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 AC97.1
ACBA.1 ACVW.1 SE90.1 AR250 AR251 AR30.1
AR30.2 AR30.3 AR30.5 BR00.1 BR00.2 BR01.2
BR01.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 BR123 BR124 BR131
BR14.1 BR142 BR151 BR152 BR153 BR154
BR155 BR156 BR157 BR165 BR200 BR202
BR204 BR205 BR21.1 BR210 BR212 BR215
BR220 BR251 BR252 BR253 BR254 BR265
BR31.1 BR31.2 BR31.3 BR31.4 BR40.3 BR40.4
BR400 BR405 BR420 BR43.1 BR430 BR450
BR51.1 BR51.2 BR52.1 BR52.2 BR52.3 BR52.4
BR52.5 BR52.7 BR521 BR53.1 BR53.2 BR54.2
BR54.3 BR54.4 BR54.1 BR55.1 BR55.2 BR56.1
BR65.1 BR65.2 BR900 BR901 BRCC.1 BRIP.1
BRPI.1 MX123 MX500 AC50.1 AC500 AC66.1
BR11.1 BR91.1
UPDATED BY
AC10.1 AC120 AC300 AC310 BR10.1 BR10.2
BR120 BR122 BR130 BR15.1 BR15.2 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CNT-CONTRACT Alpha 10 AC190 BR10.1
Element: Bid Name BR15.1
CNT-ACTIVITY Alpha 15 BR10.1 BR15.1
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-DESCRIPTION Alpha 30 (Lower Case) BR10.1 BR15.1
Element: Description This field displays the description.
CNT-REVENUE-MTHD Alpha 1 AC190 BR10.1
Element: Revenue Mthd A = Accrual BR15.1
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 AC190 BR10.1
Element: Contrct Amt Nd BR15.1 BR200
CNT-CONTRACT-AMT Signed 15.2 AC10.1 AC120
Element: Adj Amt BR10.1 BR10.2
BR15.1 BR15.2
CNT-CURRENCY-CODE Alpha 5 AC190 BR10.1
Element: Currency Code This field contains the company base BR15.1
currency code established in Company
(GL10.1 ).
CNT-FIXED-EXCHANGE Alpha 1 BR10.1 BR15.1
Element: Fixed ExchangeY = Yes
N = No
CNT-MULT-DIV Alpha 1 BR10.1 BR15.1
Multiply/Divide M = Multiply
Option D = Divide
CNT-EXCHANGE-RATE Signed 12.6 BR10.1 BR15.1
Element: Account Rate
CNT-CUST-PO-NBR Alpha 22 BR10.1 BR15.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 15.2 AC300 BR122
Element: Total Billed BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CNT-TOT-UNT-BILLED Signed 15.2 AC300 BR122
Element: Tot Unt Billed BR20.1 BR20.2
BR20.3 BR20.4
BR20.5
CNT-TOT-REV-AMT Signed 15.2 AC300
Element: Tot Rev Amt
CNT-TOT-REV-UNIT Signed 15.2 AC300
Element: Tot Rev Unit
CNT-CUSTOMER Alpha 9 (Right Justified) AR250 AR251
Element: Customer NumbeThis field contains the number that AR30.1 AR30.2
represents a customer. AR30.3 BR10.1
BR15.1
CNT-AC-CUSTOMER-ID Alpha 5 BR10.1 BR15.1
Element: Ac Customer Id
CNT-COMPANY Numeric 4 BR10.1 BR15.1
Element: Company The company number represents an
established company and is entered on
all function codes.
CNT-UNBL-AR-GL-CD Alpha 4 BR10.1
Element: Retain Gl Cd
CNT-UNBL-ACCT-CAT Alpha 5 BR10.1
Element: Account Category
CNT-ADV-BILL-GL-CD Alpha 4 BR10.1
Element: Retain 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 15.2 BR10.1
Element: Tolerance 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: All Flag
CNT-BILLING-FLAG Alpha 1 BR10.1
Element: Billing Flag
CNT-APPLY-TOL-AMT Signed 15.2 AC300 BR130
Element: Apply Tol Amt BR530
CNT-APPLY-TOL-UNIT Signed 15.2 AC300
Element: Apply Tol Unit
CNT-DFLT-ACTIVITY Alpha 15 BR10.1
Element: Dflt 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-DFLT-MX-CAT Alpha 12 BR10.1
Element: Dflt Mx Cat
CNT-DFLT-MX-VALUE Alpha 32 BR10.1
Element: Dflt Mx Value
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-RET-APPLY-FL Alpha 1
Element: Ret Apply 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 AC105
AC112 AC113
AC120 AC121
AC123 AC13.3
AC130 AC135
AC160 AC165
AC190 AC191
AC192 AC196
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC203 AC206
AC207 AC210
AC213 AC218
...
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 BR15.1
BR430 BR450
BR54.1 BR54.2
BR54.3 BR54.4
BR65.1 BR65.2
BRCC.1
CNTSET3 CUSTOMER KeyChange BR11.1
AC-CUSTOMER-ID
CONTRACT
CNTSET4 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 -> CMA-COMPANY
CNT-CUSTOMER -> CMA-CUSTOMER
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
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-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
Accntrcmtx ACCNTRCMTX
CNT-CONTRACT -> CXM-CONTRACT
CXM-MAINT-SCHEDULE
CXM-PRODUCT
CXM-PROD-VERSION
CXM-OBJ-ID
CXM-COMMENT-TYPE
CXM-DATE
CXM-SEQ-NBR
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
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
Acproforma ACPROFORMA
CNT-CONTRACT -> ATI-CONTRACT
ATI-MAINT-SCHEDULE
ATI-INVOICE-TYPE
ATI-DUE-DATE
Acretain ACRETAIN
CNT-ACTIVITY -> RET-ACTIVITY
RET-RETAIN-ID
Acretng ACRETNG
CNT-ACTIVITY -> RTG-ACTIVITY
RTG-ACCT-CAT-CLASS
RTG-ACCT-CATEGORY
|