COLINEDTL FILE Order Line Allocated Details The Order Line Allocated Details file contains line allocation information. This record is created only when the item is tracked by bin, lot, serial number, or multiple unit of measure. It is created at the time of allocation and deleted when the Shipment Detail file is created. 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 OE310 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 WH130 WH132 WH190 WH20.1 WH20.2 WH20.7 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 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 CLD-COMPANY Numeric 4 Company This field contains the company number. CLD-ORDER-NBR Numeric 8 Order Number This field contains the order number. CLD-LINE-NBR Numeric 6 Line Number This field contains the line number. CLD-COMPONENT-SEQ Numeric 3 Component Sequence This field contains the line number of the kit component, if the kit component is bin tracked and you specified a bin during allocation in the Lawson Warehouse system. CLD-ITEM Alpha 32 Item This field contains the item identifier. CLD-UOM Alpha 4 Unit of Measure This field contains the valid stock unit of measure for this item. CLD-UOM-MULT Signed 13.7 Unit of Measure This field contains the multiplier for Multiplier converting the sell unit of measure to stock unit of measure for the line. CLD-LOT Alpha 10 Lot This field contains the identifier for the homogeneous quantity of material. Items are identified as being lot tracked in the item location record. CLD-SUBLOT Alpha 6 Sublot This field contains the identifier for a detail breakdown of a lot number. CLD-BIN Alpha 7 Bin This field contains a storage area for an item or any number of items. CLD-SERIAL Alpha 16 Serial This field contains the serial number of the item on the line. Items are identified as requiring serial numbers for tracking on the item location record. CLD-ALLOCATE-QTY Signed 13.4 Allocate Quantity This field contains the quantity allocated on this line. COLINEDTL FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN CLDSET1 COMPANY BL92.1 CX100 ORDER-NBR CX20.1 CX20.2 LINE-NBR CX20.4 CX20.5 COMPONENT-SEQ CX220 CX30.1 UOM CX300 CX506 LOT CXCP.1 DR100 SUBLOT IC141 IC142 BIN IC83.1 OE10.1 SERIAL 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 ... COLINEDTL FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Coline COLINE Required CLD-COMPANY -> COL-COMPANY CLD-ORDER-NBR -> COL-ORDER-NBR CLD-LINE-NBR -> COL-LINE-NBR Iccompany ICCOMPANY Required CLD-COMPANY -> ICC-COMPANY Iclot ICLOT Not Required Valid When CLD-LOT-TRACK-FL = "Y" CLD-COMPANY -> ILT-COMPANY COL-INV-LOC -> ILT-LOCATION CLD-ITEM -> ILT-ITEM CLD-LOT -> ILT-LOT Itemloc ITEMLOC Required CLD-COMPANY -> ITL-COMPANY COL-INV-LOC -> ITL-LOCATION CLD-ITEM -> ITL-ITEM Itemmast ITEMMAST Required ICC-ITEM-GROUP -> ITE-ITEM-GROUP CLD-ITEM -> ITE-ITEM Sohdetail SOHDETAIL Required When CLD-BIN-TRACK-FL = "Y" Or CLD-LOT-TRACK-FL = "Y" CLD-COMPANY -> SDT-COMPANY COL-INV-LOC -> SDT-LOCATION CLD-ITEM -> SDT-ITEM CLD-UOM -> SDT-UOM CLD-LOT -> SDT-LOT CLD-SUBLOT -> SDT-SUBLOT CLD-BIN -> SDT-BIN |