Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICTRANSDTL


                            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     IC244     IC50.1    IC50.2
PO133     PO230     RQ39.1    RQ39.2    IC52.1

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.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
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
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    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POII.1
POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ35.1    RQIE.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     WO132     WO140     POD0.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICD-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company number represents an          AP131   AP20.1
                       established company and is entered on     AP20.2  AP20.3
                       all function codes.                       AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.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
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 ...

ICD-LOCATION           Alpha 5                                   AP125   AP126
Element: Location Code This field contains a valid stocking      AP131   AP20.1
                       location within the company inventory.    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.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
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 ...

ICD-DOC-TYPE           Alpha 2                                   AP125   AP126
Element: Document Type This field contains the type of           AP131   AP20.1
                       transaction.                              AP20.2  AP20.3
                       AJ = Adjustment                           AP20.4  AP20.5
                       BT = Bin Transfer                         AP20.7  AP23.1
                       CR = Customer Return                      AP25.1  AP25.2
                       DT = Direct Transfer                      AP26.1  AP27.1
                       HD = Lot Hold                             AP30.4  API1.1
                       IR = Intransit Receiving                  IC175   IC22.1
                       IS = Issue                                IC22.2  IC23.1
                       IT = Transfer Issue                       IC23.2  IC23.3
                       PI = Physical Inventory Adjustmnet        IC23.4  IC23.5
                       PO = PO Receiving                         IC25.1  IC26.1
                       RA = Receiving Adjustment                 IC26.2  IC28.1
                       RC = Receipt                              IC29.1  IC29.2
                       RJ = Inspection Reject                    IC29.3  IC500
                       RR = Requisition Return                   IC850   MA180
                       RT = Receiving Transfer                   MA41.2  MA41.7
                       SH = Shipment                             MA43.1  MA43.2
                       VR = Vendor Return                        MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 ...

ICD-SYSTEM-CD          Alpha 2                                   AP125   AP126
Element: System Code   This field indicates on what system the   AP131   AP20.1
                       transaction originated.                   AP20.2  AP20.3
                       CX = Case Cart                            AP20.4  AP20.5
                       IC = Inventory Control                    AP20.7  AP23.1
                       OE = Order Entry                          AP25.1  AP25.2
                       RQ = Requisition                          AP26.1  AP27.1
                       PO = Purchase Order                       AP30.4  API1.1
                       WO = Work Order                           IC175   IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC23.3
                                                                 IC23.4  IC23.5
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 ...

ICD-DOCUMENT           Alpha 10  (Right Justified)               AP125   AP126
Element: Document ID   This field contains the document ID,      AP131   AP20.1
                       which is used to reference transactions   AP20.2  AP20.3
                       in a transaction form.                    AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                       Transactions are released (updated) to    AP25.1  AP25.2
                       the Inventory Control system by document  AP26.1  AP27.1
                       ID.                                       AP30.4  API1.1
                                                                 IC175   IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC23.3
                                                                 IC23.4  IC23.5
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 ...

ICD-SHIPMENT-NBR       Numeric 10                                AP125   AP126
Element: Shipment NumbeThis field contains the shipment          AP131   AP20.1
                       number.  One order can have several       AP20.2  AP20.3
                       shipment numbers if the items of the      AP20.4  AP20.5
                       order were not shipped at the same time.  AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC25.1
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 ...

ICD-LINE-NBR           Numeric 6                                 AP125   AP126
Element: Line Number   This field contains the line number.      AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.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
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 ...

ICD-COMPONENT-SEQ      Numeric 3                                 AP125   AP126
Element: Sequence Number                                         AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC25.1
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 ...

ICD-UOM                Alpha 4                                   AP125   AP126
Element: Unit of MeasurThis field contains the transaction UOM   AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC25.1
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 IC90.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 ...

ICD-LOT-SERIAL         Alpha 16                                  AP125   AP126
Element: Serial Number This field contains the lot or sublot     AP131   AP20.1
                       number or the serial number for the       AP20.2  AP20.3
                       item.                                     AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC175   IC22.1
                                                                 IC22.2  IC23.3
                                                                 IC23.4  IC23.5
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC29.1  IC29.2
                                                                 IC500   IC850
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 ...

ICD-BIN                Alpha 7                                   AP125   AP126
Element: Bin           This field contains a storage area for    AP131   AP20.1
                       an item or any number of items.           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC175   IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 ...

ICD-TRANS-DATE         Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          This is the date a document was created   AP131   AP20.1
                       for one or more transactions.             AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 ...

ICD-ITEM               Alpha 32                                  AP125   AP126
Element: Item Number   This field contains the item number       AP131   AP20.1
                       defined in IC12.1 (Item Location) or      AP20.2  AP20.3
                       IC10.1 (Item Master and Location).        AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.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  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 ...

ICD-UOM-MULT           Signed 13.7                               AP125   AP126
Unit of Measure        This field contains the multiplier for    AP131   AP20.1
Multiplier             converting this unit of measure to the    AP20.2  AP20.3
                       stock unit of measure.                    AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC23.4  IC23.5
                                                                 IC25.1  IC28.1
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC500
                                                                 IC850   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 ...

ICD-QUANTITY           Signed 13.4                               AP125   AP126
Element: Quantity      This field contains the quantity of       AP131   AP20.1
                       this detail line.                         AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.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  IC500
                                                                 IC850   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 ...

ICD-OPEN-QTY           Signed 13.4                               AP125   AP126
Element: Quantity      This field contains the quantity of the   AP131   AP20.1
                       item not yet received. It is used only    AP20.2  AP20.3
                       for intransit transactions.               AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC23.4  IC25.1
                                                                 IC28.1  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 ...

ICD-ORIGINAL-QTY       Signed 13.4                               AP125   AP126
Element: Quantity      This field contains the original          AP131   AP20.1
                       quantity of the detail line. It is used   AP20.2  AP20.3
                       only for intransit transactions.          AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC28.1  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 PO27.2  PO29.1
                                                                 ...

ICD-SECONDARY-QTY      Signed 13.4                               AP125   AP126
Element: Quantity      This field contains a secondary           AP131   AP20.1
                       quantity that is tracked if the item is   AP20.2  AP20.3
                       a catch weight item.                      AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC23.3
                                                                 IC23.4  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC29.1
                                                                 IC29.3  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 ...

ICD-HOLD-FLAG          Alpha 1                                   AP125   AP126
Element: On Hold Flag  This field is used to place a lot on      AP131   AP20.1
                       hold, not allowing any issues or          AP20.2  AP20.3
                       transfers.                                AP20.4  AP20.5
                       N = No                                    AP20.7  AP23.1
                       Y = Yes                                   AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC22.1  IC22.2
                                                                 IC25.1  IC28.1
                                                                 IC29.1  IC500
                                                                 IC850   MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 PO22.1  PO23.1
                                                                 PO25.1  PO25.5
                                                                 PO25.6  PO25.7
                                                                 ...

ICD-EXPIRE-DATE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          This field contains the expiration date   AP131   AP20.1
                       for the lot.                              AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  IC29.1
                                                                 IC500   IC850
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 PO21.5  PO22.1
                                                                 PO23.1  PO25.1
                                                                 PO25.5  PO25.6
                                                                 PO25.7  PO27.2
                                                                 PO29.1  PO30.1
                                                                 ...

ICD-UPDATE-DATE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          This field contains the system date the   AP131   AP20.1
                       transaction was updated (released) to     AP20.2  AP20.3
                       the Inventory Control system.             AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                       This date is established by the system    AP25.1  AP25.2
                       when a transaction document is released   AP26.1  AP27.1
                       in a transaction form.                    AP30.4  API1.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 ...

ICD-UPDATE-TIME        Numeric 6                                 AP125   AP126
Element: Update Time   This field contains the system time       AP131   AP20.1
                       when the transaction was updated          AP20.2  AP20.3
                       (released) to the Inventory Control       AP20.4  AP20.5
                       system.                                   AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                       This time is established by the system    AP26.1  AP27.1
                       when you release a transaction document   AP30.4  API1.1
                       in a transaction form.                    IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 ...

ICD-STATUS             Numeric 1                                 AP125   AP126
Element: Status        This field displays the status of the     AP131   AP20.1
                       transaction.                              AP20.2  AP20.3
                       0 = Unreleased                            AP20.4  AP20.5
                       1 = Released                              AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC175   IC20.1
                                                                 IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 MA180   MA41.2
                                                                 MA41.7  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.9  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  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 ...

ICD-ACTUAL-TIME        Numeric 4                                 AP125   AP126
Element: Actual Time   This field contains the system time       AP131   AP20.1
                       when this transaction took place.         AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC850
                                                                 IC90.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 ...

ICD-TRAN-COUNTER       Numeric 6
Element: Item Count

ICD-TRANS-BARCODE      Alpha 25
Element: Trans Barcode

ICD-TRANS-SEQ          Numeric 6                                 AP125   AP126
Element: Trans Seq                                               AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.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
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 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
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.1
                                                                 PO21.2  PO21.3
                                                                 ...

                         ICTRANSDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICDSET1   COMPANY                                                IC110   IC20.1
          LOCATION                                               IC20.2  IC21.1
          DOC-TYPE                                               IC21.2  IC22.1
          SYSTEM-CD                                              IC22.2  IC220
          DOCUMENT                                               IC222   IC23.1
          SHIPMENT-NBR                                           IC23.2  IC23.3
          LINE-NBR                                               IC23.4  IC23.5
          COMPONENT-SEQ                                          IC24.1  IC24.2
          TRANS-SEQ                                              IC244   IC25.1
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC300
                                                                 IC50.1  IC50.2
                                                                 IC500   IC850
                                                                 IC90.1  PO131
                                                                 PO133   PO230
                                                                 ...

ICDSET2   COMPANY       KeyChange                                IC20.1  IC20.2
          LOCATION                                               IC21.1  IC21.2
          DOC-TYPE                                               IC22.1  IC22.2
          SYSTEM-CD                                              IC23.1  IC23.2
          DOCUMENT                                               IC23.3  IC23.4
          SHIPMENT-NBR                                           IC23.5  IC24.1
          ITEM                                                   IC24.2  IC25.1
          LOT-SERIAL                                             IC29.1  IC29.2
          BIN                                                    IC29.3  IC500
          LINE-NBR                                               RQ35.1  RQ39.1
          COMPONENT-SEQ                                          RQ39.2
          TRANS-SEQ

ICDSET3   COMPANY       KeyChange, Subset                        IC52.1  IC850
          LOCATION      Where LOT-SERIAL != Spaces
          ITEM          And   STATUS     != Zeroes
          LOT-SERIAL
          UPDATE-DATE*
          UPDATE-TIME*
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ
          TRANS-SEQ
          DOC-TYPE
          SYSTEM-CD
          DOCUMENT

ICDSET4   COMPANY       KeyChange, Subset
          ITEM          Where DOC-TYPE = "DT"
          LOT-SERIAL    Or    DOC-TYPE = "IS"
          UPDATE-DATE*  Or    DOC-TYPE = "IT"
          UPDATE-TIME*  Or    DOC-TYPE = "SH"
          LOCATION
          SHIPMENT-NBR
          LINE-NBR
          COMPONENT-SEQ
          TRANS-SEQ
          DOC-TYPE
          SYSTEM-CD
          DOCUMENT

                         ICTRANSDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bin            ICBIN        Required
                            When ICD-BIN != Spaces

                            ICD-COMPANY       -> ICB-COMPANY
                            ICD-LOCATION      -> ICB-LOCATION
                            ICD-BIN           -> ICB-BIN

Company        ICCOMPANY    Required

                            ICD-COMPANY       -> ICC-COMPANY

Item           ITEMMAST     Required

                            ICC-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ICD-ITEM          -> ITE-ITEM

Itserial       ITSERIAL     Not Required

                            ICD-COMPANY       -> SER-COMPANY
                            ICD-ITEM          -> SER-ITEM
                            ICD-LOT-SERIAL    -> SER-SERIAL

Rec Adjust     PORECLINE    Required
                            When ICD-DOC-TYPE = "RA"

                            ICD-COMPANY       -> PRL-COMPANY
                            ICD-DOCUMENT      -> PRL-REC-NUMBER
                            ICD-LINE-NBR      -> PRL-LINE-NBR

Rec Reject     PORECLINE    Required
                            When ICD-DOC-TYPE = "RJ"

                            ICD-COMPANY       -> PRL-COMPANY
                            ICD-DOCUMENT      -> PRL-REC-NUMBER
                            ICD-LINE-NBR      -> PRL-LINE-NBR

Receive        PORECLINE    Required
                            When ICD-DOC-TYPE = "PO"

                            ICD-COMPANY       -> PRL-COMPANY
                            ICD-DOCUMENT      -> PRL-REC-NUMBER
                            ICD-LINE-NBR      -> PRL-LINE-NBR