Lawson Insight Technical Documentation

                            ICTRANSDTL FILE

                      Inventory Transaction Detail

The Inventory Transaction Detail file is a detail file associated with the
Inventory Transaction file and is created for lot or serial number tracked
items or for a multiple bin or unit of measure transaction. It contains the
serial number, lot, bin numbers, units of measure, and their quantities.

REFERENCED BY

IC110     IC220     IC222     IC50.1    IC50.2    PO133
PO230     RQ39.1    RQ39.2    IC52.1

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    IC175     IC20.1    IC20.2    IC21.1    IC21.2
IC22.1    IC22.2    IC23.1    IC23.2    IC23.3    IC23.4
IC23.5    IC24.1    IC24.2    IC25.1    IC26.1    IC26.2
IC28.1    IC29.1    IC29.2    IC29.3    IC300     IC500
IC850     IC90.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    RQ35.1    WH130     WH132     WH190
WH20.2    WH20.7    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

ICD-COMPANY          Numeric 4                                   AP125   AP126
Company              The company number represents an            AP131   AP25.1
                     established company and is entered on       AP25.2  AP26.1
                     all function codes.                         AP27.1  IC175
                                                                 IC22.1  IC22.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 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
                                                                 ...

ICD-LOCATION         Alpha 5                                     AP125   AP126
Location Code        This field contains a valid stocking        AP131   AP25.1
                     location within the company inventory.      AP25.2  AP26.1
                                                                 AP27.1  IC175
                                                                 IC22.1  IC22.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 MA180   MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1