 |
Lawson Insight Technical Documentation |
|
COCOMP FILE
Demand Line Kit Components
The Demand Line Kit Components file contains the kit components that make up
a line on a document.
REFERENCED BY
BL123
UPDATED BY
CXCP.1 DR100 IC141 IC142 IC83.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 WH110 WH130 WH22.1
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CKT-COMPANY Numeric 4 CXCP.1 DR100
Company This field contains the company number. IC141 IC142
IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-SYSTEM-CD Alpha 2 CXCP.1 DR100
System Code This field indicates on which Lawson IC141 IC142
system the document originated. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-DOC-NBR Alpha 10 (Right Justified) CXCP.1 DR100
Doc Nbr This field contains the document number IC141 IC142
of the document containing the component IC83.1 POIJ.1
item. RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-DOC-NBR-NUM Numeric 10 CXCP.1 DR100
Doc Nbr Num This field contains the numeric value IC141 IC142
of the document number. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-LINE-NBR Numeric 6 CXCP.1 DR100
Line Number This field displays the system assigned IC141 IC142
line number within the transaction IC83.1 POIJ.1
number. RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-COMPONENT-SEQ Numeric 3 CXCP.1 DR100
Component Sequence This field contains the component IC141 IC142
Number sequence number for kit component items. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-OPT-SEQ Numeric 3 CXCP.1 DR100
Options Sequence This field contains the option's IC141 IC142
Number sequence number. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-ITEM Alpha 32 CXCP.1 DR100
Item Number This field contains the item IC141 IC142
identifier. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-OPTION-CD Alpha 1 CXCP.1 DR100
Option Cd This field contains the option code IC141 IC142
which determines the status of the IC83.1 POIJ.1
option. Valid values are: RQ11.1 RQ12.1
RQ13.1 WH110
R = Review Required. WH130 WH22.1
N = Option Does Not Exist. WH33.1 WH33.2
E = Option Exists. WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-QUANTITY Signed 13.4 CXCP.1 DR100
Quantity This field contains the quantity per IC141 IC142
kit in stock unit of measure. IC83.1 POIJ.1
RQ11.1 RQ12.1
RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKT-ITEM-16 Derived
Item 16 This field contains the first 16
characters of the item's identifier.
This information is used by inquiries
and reports.
CKT-DISP-QTY Derived
Disp Quantity This field contains the quantity needed
for the line in stock quantity.
COCOMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CKTSET1 COMPANY Primary index used for accessing and BL123 CXCP.1
SYSTEM-CD updating the table. DR100 IC141
DOC-NBR IC142 IC83.1
LINE-NBR POIJ.1 RQ11.1
COMPONENT-SEQ RQ12.1 RQ13.1
WH110 WH130
WH22.1 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CKTSET2 COMPANY Used to determine if review is required CXCP.1 DR100
SYSTEM-CD for kit items whose options have not IC141 IC142
DOC-NBR been selected yet. IC83.1 POIJ.1
LINE-NBR Subset RQ11.1 RQ12.1
COMPONENT-SEQ Where (OPTION-CD = "R" ) RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
CKTSET3 COMPANY
SYSTEM-CD
DOC-NBR
LINE-NBR
COMPONENT-SEQ
ITEM
CKTSET4 COMPANY This index was created as a solution to CXCP.1 DR100
SYSTEM-CD the Find Next/Prev Flaf error. It is IC141 IC142
DOC-NBR only used where a modify must be done IC83.1 POIJ.1
COMPONENT-SEQ within a 850-FIND-NLT or 850-FIND-BEGRNG RQ11.1 RQ12.1
LINE-NBR loop. RQ13.1 WH110
WH130 WH22.1
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
COCOMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Required
CKT-COMPANY -> COL-COMPANY
CKT-DOC-NBR-NUM -> COL-ORDER-NBR
CKT-LINE-NBR -> COL-LINE-NBR
Component COMPONENT Not Required
ICC-ITEM-GROUP -> COM-ITEM-GROUP
CKT-COMPANY -> COM-COMPANY
COL-INV-LOC -> COM-LOCATION
COL-ITEM -> COM-KIT-ITEM
CKT-COMPONENT-SEQ -> COM-SEQ
CKT-OPT-SEQ -> COM-OPT-SEQ
Iccompany ICCOMPANY Required
CKT-COMPANY -> ICC-COMPANY
Itemloc ITEMLOC Required
CKT-COMPANY -> ITL-COMPANY
COL-INV-LOC -> ITL-LOCATION
CKT-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
CKT-ITEM -> ITE-ITEM
Kititem ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
COL-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
CKT-COMPANY -> OEC-COMPANY
COCOMP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Options Comp COMPONENT
ICC-ITEM-GROUP -> COM-ITEM-GROUP
CKT-COMPANY -> COM-COMPANY
COL-INV-LOC -> COM-LOCATION
COL-ITEM -> COM-KIT-ITEM
CKT-COMPONENT-SEQ -> COM-SEQ
COM-OPT-SEQ
Options Group COMPONENT
Valid When CKT- != CKT-
ICC-ITEM-GROUP -> COM-ITEM-GROUP
Zeroes -> COM-COMPANY
Spaces -> COM-LOCATION
ITE-ITEM -> COM-KIT-ITEM
CKT-COMPONENT-SEQ -> COM-SEQ
COM-OPT-SEQ
|