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 OE288 OE289 OE290 SA100
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC141 IC142 IC83.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE90.1 OE920 OE950 PO31.1 RQ10.1
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ35.1
RQ500 RQ961 WH110 WH130 WH132 WH190
WH20.1 WH20.2 WH20.7 WH22.1 WH222 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WH964 WO120 WO132 WO140 WO20.1 WO30.1
WO32.1 WO40.1 WO40.2 WO40.3 WO40.4 WO40.5
WO41.1 WO41.2 WO41.3 WO41.4 WO42.1 WO42.2
WO42.3 WO42.4 WO42.5 WO45.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CKT-COMPANY Numeric 4 BL92.1 CX100
Company This field contains the company number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-SYSTEM-CD Alpha 2 BL92.1 CX100
System Code This field indicates on which Lawson CX20.1 CX20.2
system the document originated. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-DOC-NBR Alpha 10 (Right Justified) BL92.1 CX100
Document Number This field contains the document number CX20.1 CX20.2
of the document containing the component CX20.4 CX20.5
item. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-DOC-NBR-NUM Numeric 10 BL92.1 CX100
Document Number This field contains the numeric value CX20.1 CX20.2
Numeric Value of the document number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-LINE-NBR Numeric 6 BL92.1 CX100
Line Number This field displays the system assigned CX20.1 CX20.2
line number within the transaction CX20.4 CX20.5
number. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-COMPONENT-SEQ Numeric 3 BL92.1 CX100
Component Sequence This field contains the component CX20.1 CX20.2
sequence number for kit component items. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-OPT-SEQ Numeric 3 BL92.1 CX100
Option Sequence This field contains the option's CX20.1 CX20.2
sequence number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-ITEM Alpha 32 BL92.1 CX100
Item This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-OPTION-CD Alpha 1 BL92.1 CX100
Option Code This field contains the option code CX20.1 CX20.2
which determines the status of the CX20.4 CX20.5
option. Valid values are: CX220 CX30.1
CX300 CX506
R = Review Required. CXCP.1 DR100
N = Option Does Not Exist. IC141 IC142
E = Option Exists. IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
CKT-QUANTITY Signed 13.4 BL92.1 CX100
Quantity This field contains the quantity per CX20.1 CX20.2
kit in stock unit of measure. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE90.1
OE920 OE950
PO31.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ20.1 RQ35.1
...
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 BL92.1
SYSTEM-CD updating the table. CX100 CX20.1
DOC-NBR CX20.2 CX20.4
LINE-NBR CX20.5 CX220
COMPONENT-SEQ CX30.1 CX300
CX506 CXCP.1
DR100 IC141
IC142 IC83.1
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
...
CKTSET2 COMPANY Used to determine if review is required BL92.1 CX100
SYSTEM-CD for kit items whose options have not CX20.1 CX20.2
DOC-NBR been selected yet. CX20.4 CX20.5
LINE-NBR Subset CX220 CX30.1
COMPONENT-SEQ Where (OPTION-CD = "R" ) CX300 CX506
CXCP.1 DR100
IC141 IC142
IC83.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
...
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
|