Lawson Insight Technical Documentation |
|
COCOMP
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 IC28.1 IC83.1 MA180
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.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 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 PO100 PO101
PO122 PO131 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POI3.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIF.1 WH110 WH130 WH132
WH190 WH20.1 WH20.2 WH20.7 WH22.1 WH222
WH25.1 WH25.2 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 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
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 AP125 AP126
Element: Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Code This field indicates on which Lawson AP131 AP25.1
system the document originated. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-DOC-NBR Alpha 10 (Right Justified) AP125 AP126
Element: Document NumbeThis field contains the document number AP131 AP25.1
of the document containing the component AP25.2 AP26.1
item. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-DOC-NBR-NUM Numeric 10 AP125 AP126
Element: Doc Nbr Num This field contains the numeric value AP131 AP25.1
of the document number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field displays the system assigned AP131 AP25.1
line number within the transaction AP25.2 AP26.1
number. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-COMPONENT-SEQ Numeric 3 AP125 AP126
Element: Componenet SeqThis field contains the component AP131 AP25.1
sequence number for kit component items. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-OPT-SEQ Numeric 3 AP125 AP126
Element: Option SequencThis field contains the option's AP131 AP25.1
sequence number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-ITEM Alpha 32 AP125 AP126
Element: Item This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-OPTION-CD Alpha 1 AP125 AP126
Element: Option Code This field contains the option code AP131 AP25.1
which determines the status of the AP25.2 AP26.1
option. Valid values are: AP27.1 AP30.4
BL120 BL122
R = Review Required. BL130 BL20.1
N = Option Does Not Exist. BL20.3 BL21.2
E = Option Exists. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the quantity per AP131 AP25.1
kit in stock unit of measure. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
...
CKT-ITEM-16 Derived
Element: Item This field contains the first 16
characters of the item's identifier.
This information is used by inquiries
and reports.
CKT-DISP-QTY Derived
Element: 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 AP125 AP126
SYSTEM-CD updating the table. AP131 AP25.1
DOC-NBR AP25.2 AP26.1
LINE-NBR AP27.1 AP30.4
COMPONENT-SEQ BL120 BL122
BL123 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
IC28.1 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
...
CKTSET2 COMPANY Used to determine if review is required AP125 AP126
SYSTEM-CD for kit items whose options have not AP131 AP25.1
DOC-NBR been selected yet. AP25.2 AP26.1
LINE-NBR Subset AP27.1 AP30.4
COMPONENT-SEQ Where (OPTION-CD = "R" ) BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
CKTSET3 COMPANY
SYSTEM-CD
DOC-NBR
LINE-NBR
COMPONENT-SEQ
ITEM
CKTSET4 COMPANY This index was created as a solution to AP125 AP126
SYSTEM-CD the Find Next/Prev Flaf error. It is AP131 AP25.1
DOC-NBR only used where a modify must be done AP25.2 AP26.1
COMPONENT-SEQ within a 850-FIND-NLT or 850-FIND-BEGRNG AP27.1 AP30.4
LINE-NBR loop. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
IC83.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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 COM- != 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
|