 |
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.
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC141 IC142 IC28.1
IC83.1 MA180 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 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 RQ10.3 RQ11.1 RQ12.1 RQ13.1 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CKT-COMPANY Numeric 4 AP125 AP126
Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-SYSTEM-CD Alpha 2 AP125 AP126
System Code This field indicates on which Lawson AP131 AP25.1
system the document originated. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-DOC-NBR Alpha 10 (Right Justified) AP125 AP126
Doc Nbr This field contains the document number AP131 AP25.1
of the document containing the component AP25.2 AP26.1
item. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-DOC-NBR-NUM Numeric 10 AP125 AP126
Doc Nbr Num This field contains the numeric value AP131 AP25.1
of the document number. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-LINE-NBR Numeric 6 AP125 AP126
Line Number This field displays the system assigned AP131 AP25.1
line number within the transaction AP25.2 AP26.1
number. AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-COMPONENT-SEQ Numeric 3 AP125 AP126
Component Sequence This field contains the component AP131 AP25.1
Number sequence number for kit component items. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-OPT-SEQ Numeric 3 AP125 AP126
Options Sequence This field contains the option's AP131 AP25.1
Number sequence number. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-OPTION-CD Alpha 1 AP125 AP126
Option Cd 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 CXCP.1
DR100 IC141
R = Review Required. IC142 IC28.1
N = Option Does Not Exist. IC83.1 MA180
E = Option Exists. MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CKT-QUANTITY Signed 13.4 AP125 AP126
Quantity This field contains the quantity per AP131 AP25.1
kit in stock unit of measure. AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 AP125 AP126
SYSTEM-CD updating the table. AP131 AP25.1
DOC-NBR AP25.2 AP26.1
LINE-NBR AP27.1 CXCP.1
COMPONENT-SEQ DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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 CXCP.1
COMPONENT-SEQ Where (OPTION-CD = "R" ) DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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 CXCP.1
LINE-NBR loop. DR100 IC141
IC142 IC28.1
IC83.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
...
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
|