Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ICTRANS FILE

                         Inventory Transaction

The Inventory Transaction file contains all the inventory transactions
entered in the Inventory Control system. Each transaction type is given a
unique document type.

REFERENCED BY

IC01.2    IC110     IC221     IC222     IC234     IC242
IC48.1    IC52.1    IC53.1    IC851     IC12.1    IC220
IC240     IC280     IC50.1    IC50.2    IC17.1    IC229
IC190     IC199

UPDATED BY

DR100     IC130     IC138     IC141     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     IC885     IC90.1
POIJ.1    WH130     WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICT-COMPANY          Numeric 4                                   DR100   IC138
Company              The company number represents an            IC141   IC175
                     established company and is entered on       IC20.1  IC20.2
                     all function codes.                         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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-LOCATION         Alpha 5                                     DR100   IC138
Location Code        This field contains a valid stocking        IC141   IC175
                     location within the company inventory.      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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-DOC-TYPE         Alpha 2                                     DR100   IC138
Document Type        This field contains the type of             IC141   IC175
                     transaction.                                IC20.1  IC20.2
                     AJ = Adjustment                             IC21.1  IC21.2
                     BT = Bin Transfer                           IC22.1  IC22.2
                     CA = Cost Adjustment                        IC23.1  IC23.2
                     CR = Customer Return                        IC23.3  IC23.4
                     DT = Direct Transfer                        IC23.5  IC24.1
                     IR = Intransit Receiving                    IC24.2  IC25.1
                     IS = Issue                                  IC26.1  IC26.2
                     IT = Transfer Issue                         IC28.1  IC29.1
                     PI = Physical Inventory Adjustment          IC29.2  IC29.3
                     RC = Receipt                                IC500   IC850
                     RR = Requisition Return                     IC90.1  POIJ.1
                     RT = Receiving Transfer                     WH130   WH33.1
                     SH = Shipment                               WH33.2  WH33.3
                     VA = Vendor Return Adjustment               WH33.4  WH33.5
                     VR = Vendor Return                          WH33.6  WH33.8
                     PO = PO Receiving                           WH33.9  WH34.1
                     RA = PO Receiving Adjustment                WH34.2  WH34.3
                     RJ = Rejected Inspection Item               WH34.4
                     AC = Accepted Inspection Item

ICT-SYSTEM-CD        Alpha 2                                     DR100   IC138
System Code          This field indicates on what system the     IC141   IC175
                     transaction originated.                     IC20.1  IC20.2
                     IC = Inventory Control                      IC21.1  IC21.2
                     OE = Order Entry                            IC22.1  IC22.2
                     RQ = Requisition                            IC23.1  IC23.2
                     CX = Case Cart                              IC23.3  IC23.4
                     PO = Purchase Order                         IC23.5  IC24.1
                     WO = Work Order                             IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-DOCUMENT         Alpha 10  (Right Justified)                 DR100   IC138
Document ID          This field identifies the document from     IC141   IC175
                     which this transaction record was           IC20.1  IC20.2
                     created.                                    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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-SHIPMENT-NBR     Numeric 10                                  IC175   IC20.1
Shipment Number      This field contains the shipment            IC20.2  IC21.2
                     number.  One order can have several         IC22.1  IC22.2
                     shipment numbers if the items of the        IC23.1  IC23.2
                     order were not shipped at the same time.    IC23.3  IC23.4
                                                                 IC23.5  IC24.1
                                                                 IC24.2  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-DOCUMENT-SEQ     Numeric 3
Document Seq         This field is a counter field.  It is
                     used in the Warehouse system to create
                     an audit trail for the Undo form action
                     in case a shipment is processed multiple
                     times.

ICT-LINE-NBR         Numeric 6                                   DR100   IC138
Line Number          This field displays the system-assigned     IC141   IC175
                     transaction number.                         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  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-COMPONENT-SEQ    Numeric 3                                   IC175   IC20.1
Component Sequence   This field contains the component           IC20.2  IC21.2
Number               sequence number.                            IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC24.1
                                                                 IC24.2  IC28.1
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-UPDATE-DATE      Numeric 8  (yyyymmdd)                       DR100   IC138
Update Date          This field contains the date the record     IC141   IC175
                     was updated.                                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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-UPDATE-TIME      Numeric 6                                   DR100   IC138
Update Time          This field contains the system time         IC141   IC175
                     when the record was updated.                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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-TRAN-COUNTER     Numeric 6                                   IC175   IC20.1
Tran Counter         This field contains a transaction           IC20.2  IC21.1
                     object number used to determine the         IC21.2  IC22.1
                     sequence of updating of the Item            IC22.2  IC23.1
                     Location file.                              IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC26.1  IC28.1
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-TRANS-DATE       Numeric 8  (yyyymmdd)                       DR100   IC138
Transaction Date     The date of the transaction.                IC141   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
                                                                 IC851   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-ITEM             Alpha 32                                    DR100   IC138
Item Number          This field contains the item                IC141   IC175
                     identifier.                                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-SOH-QTY          Signed 13.4                                 DR100   IC138
Stock On Hand        This field contains the stock-on-hand       IC141   IC175
Quantity             quantity before this transaction.           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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-QUANTITY         Signed 13.4                                 DR100   IC138
Quantity             This field contains the quantity of the     IC141   IC175
                     transaction.                                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  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-ORIGINAL-QTY     Signed 13.4                                 DR100   IC141
Original Quantity    This field contains the original            IC22.1  IC22.2
                     intransit quantity. It is used only for     IC25.1  IC500
                     intransit transfers.                        IC850   POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-OPEN-QTY         Signed 13.4                                 DR100   IC138
Open Quantity        This field contains the open intransit      IC141   IC22.1
                     quantity not yet received.                  IC22.2  IC23.1
                                                                 IC23.2  IC25.1
                                                                 IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-STOCK-UOM        Alpha 4                                     DR100   IC138
Stocking Unit of     This field contains the stock unit of       IC141   IC175
Measure              measure for the item.                       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  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-UNIT-COST        Signed 13.5                                 DR100   IC138
Unit Cost            This field contains the unit cost for       IC141   IC175
                     this transaction.                           IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-UNIT-COST-CURR   Signed 13.5                                 POIJ.1  WH130
Unit Cost Curr       This field contains the unit cost for       WH33.1  WH33.2
                     this transaction in transaction             WH33.3  WH33.4
                     currency.                                   WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-CURR-ND          Numeric 1                                   POIJ.1  WH130
Currency Number of   Represents the number of decimals           WH33.1  WH33.2
Decimals             defined for the currency of the object.     WH33.3  WH33.4
                     0                                           WH33.5  WH33.6
                     2                                           WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-ADD-UNIT-COST    Signed 13.5                                 DR100   IC138
Add On Unit Cost     This field contains the add-on unit         IC141   IC23.1
Amount               cost or freight cost that is added to       IC23.2  IC25.1
                     the incoming unit cost to determine a       IC500   IC850
                     new unit cost for this intransit            POIJ.1  WH130
                     receiving.                                  WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-BASE-COST        Signed 13.5                                 DR100   IC138
Base Cost            This field contains the base cost used      IC141   IC175
                     for calculating the standard cost of an     IC20.1  IC20.2
                     item, if the company uses the standard      IC21.1  IC21.2
                     costing method. The base cost is then       IC22.1  IC22.2
                     used for standard cost variance             IC23.1  IC23.2
                     calculation.                                IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                     Also, this field is used for negative       IC500   IC850
                     average costing (if the company uses        POIJ.1  WH130
                     average costing and this field is           WH33.1  WH33.2
                     flagged for allowing negative               WH33.3  WH33.4
                     stock-on-hand). This field captures the     WH33.5  WH33.6
                     average cost of the item prior to the       WH33.8  WH33.9
                     transaction.                                WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-CURRENT-COST     Signed 13.5                                 DR100   IC138
Current Cost         This field contains the cost used for       IC141   IC175
                     capturing the current cost of the item      IC20.1  IC20.2
                     when the transaction is released. This      IC21.1  IC21.2
                     is the same overall cost used for           IC22.1  IC22.2
                     valuation, and is calculated by the         IC23.1  IC23.2
                     costing method of the company.              IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-UNIT-PRICE       Signed 13.5                                 DR100   IC138
Unit Price           This field is not used by the Inventory     IC141   IC850
                     Control system.                             POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-TRAN-UOM         Alpha 4                                     DR100   IC138
Transaction Unit of  This field contains the entered unit of     IC141   IC175
Measure              measure on this transaction.                IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC26.1
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-TRAN-UOM-MULT    Signed 13.7                                 DR100   IC138
Transaction UOM      This field contains the transaction         IC141   IC175
Multiplier           unit of measure multiplier.                 IC20.1  IC20.2
                                                                 IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC24.1  IC24.2
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-SECONDARY-QTY    Signed 13.4                                 DR100   IC138
Secondary Quantity   This field contains a secondary             IC175   IC20.1
                     quantity that is tracked if the item is     IC20.2  IC21.1
                     a catch weight item.                        IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-SEC-UOM          Alpha 4                                     DR100   IC138
Secondary Unit of    This field contains the secondary           IC175   IC20.1
Measure              quantity unit of measure.                   IC20.2  IC21.1
                                                                 IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-SEC-UOM-MULT     Signed 13.7                                 DR100   IC175
Secondary UOM        This field contains the secondary           IC20.2  IC21.2
Multiplier           quantity unit of measure multiplier. It     IC22.1  IC22.2
                     is used to convert the stock-on-hand        IC23.2  IC24.1
                     quantity to the secondary quantity or       IC500   IC850
                     visa versa.                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-GL-DATE          Numeric 8  (yyyymmdd)                       DR100   IC141
General Ledger Date  This field contains the date this           IC175   IC20.1
                     transaction is to be posted to the          IC20.2  IC21.1
                     General Ledger system.                      IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-EST-DEL-DATE     Numeric 8  (yyyymmdd)                       DR100   IC141
Estimated Delivery   This field contains the estimated           IC22.1  IC22.2
Date                 delivery date. This field is required on    IC25.1  IC500
                     an intransit transfer transaction.          IC850   POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-REFERENCE        Alpha 10  (Lower Case)                      DR100   IC138
Reference            This field contains the reference           IC141   IC20.2
                     information.                                IC21.2  IC22.2
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-BIN              Alpha 7                                     DR100   IC138
Bin                  This field contains a storage area for      IC141   IC175
                     an item or any number of items.             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  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-REASON-CODE      Alpha 4                                     DR100   IC138
Reason Code          This field contains the reason code for     IC141   IC175
                     the transaction.                            IC20.2  IC21.2
                                                                 IC22.2  IC23.2
                                                                 IC24.2  IC28.1
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-ACTIVITY         Alpha 15                                    DR100   IC138
Activity             Activities are the processes or             IC141   IC20.2
                     procedures that produce work. Cost          IC21.2  IC24.2
                     objects (products, services, customers,     IC28.1  IC500
                     and so on) are the reasons for              IC850   POIJ.1
                     performing the activity.                    WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-ACCT-CATEGORY    Alpha 5                                     IC138   IC141
Account Category     Account categories are groupings of         IC20.2  IC21.2
                     costs, revenues, or a combination of        IC24.2  IC28.1
                     both used for reporting and inquiries       IC500   IC850
                     for activities in the Activity              POIJ.1  WH130
                     Management system. All transactions are     WH33.1  WH33.2
                     posted to an account category within an     WH33.3  WH33.4
                     activity. You can assign a specific         WH33.5  WH33.6
                     General Ledger account or range of          WH33.8  WH33.9
                     accounts (company, accounting unit,         WH34.1  WH34.2
                     account, and subaccount) that make up       WH34.3  WH34.4
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.

ICT-LINE-COMMENT     Alpha 40  (Lower Case)                      DR100   IC138
Line Comments        This field contains the user-defined        IC141   IC20.2
                     comments for the transaction line. These    IC21.2  IC22.2
                     comments are for reference purposes         IC23.2  IC24.2
                     only.                                       IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-INV-ACCT-UNIT    Alpha 15                                    DR100   IC138
Inventory Account    This field contains the general ledger      IC141   IC175
Unit                 inventory account unit.                     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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-INV-ACCOUNT      Numeric 6                                   DR100   IC138
Inventory Account    This field contains the general ledger      IC141   IC175
Nbr                  inventory account number.                   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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-INV-SUB-ACCT     Numeric 4                                   DR100   IC138
Inventory Subaccount This field contains the general ledger      IC141   IC175
                     inventory subaccount number.                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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-OFF-ACCT-UNIT    Alpha 15                                    DR100   IC138
Offset Account Unit  This field contains the general ledger      IC141   IC175
                     offset account unit.                        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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-OFF-ACCOUNT      Numeric 6                                   DR100   IC138
Offset Account       This field contains the general ledger      IC141   IC175
                     offset account number.                      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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-OFF-SUB-ACCT     Numeric 4                                   DR100   IC138
Offset Subaccount    This field contains the general ledger      IC141   IC175
                     offset subaccount number.                   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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-VAR-ACCT-UNIT    Alpha 15                                    DR100   IC138
Cost Variance        This field contains the general ledger      IC141   IC175
Accounting Unit      cost variance account unit.                 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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-VAR-ACCOUNT      Numeric 6                                   DR100   IC138
Cost Variance        This field contains the general ledger      IC141   IC175
Account Number       cost variance account number.               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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-VAR-SUB-ACCT     Numeric 4                                   DR100   IC138
Cost Variance        This field contains the general ledger      IC141   IC175
Subaccount           cost variance subaccount number.            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
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-ADD-ACCT-UNIT    Alpha 15                                    DR100   IC138
Add On Cost Account  This field contains the general ledger      IC141   IC23.2
Unit                 add-on cost account unit.                   IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-ADD-ACCOUNT      Numeric 6                                   DR100   IC138
Add On Cost Account  This field contains the general ledger      IC141   IC23.2
                     add-on cost account  number.                IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-ADD-SUB-ACCT     Numeric 4                                   DR100   IC138
Add On Subaccount    This field contains the general ledger      IC141   IC23.2
                     add-on cost subaccount number.              IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-STATUS           Numeric 1                                   DR100   IC130
Status               This field contains the processing          IC138   IC141
                     status of the transaction.                  IC175   IC20.1
                     0 = Unreleased                              IC20.2  IC21.1
                     1 = Released                                IC21.2  IC22.1
                     2 = General Ledger Updated                  IC22.2  IC23.1
                     5 = Intermediate Status(see IC130)          IC23.2  IC24.1
                     3 = Non General Ledger                      IC24.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-FR-DOCUMENT      Alpha 10  (Right Justified)                 DR100   IC138
From Document        This field contains the document number     IC141   IC22.1
                     for the from-location for a transfer        IC22.2  IC23.1
                     transaction.                                IC23.2  IC25.1
                                                                 IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-FROM-TO-BIN      Alpha 7                                     DR100   IC138
From or To Bin       This field contains the from or to bin      IC141   IC22.1
                     for a transfer transaction.                 IC22.2  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-FROM-TO-LOC      Alpha 5                                     DR100   IC138
From or To Location  This field contains the from or to          IC141   IC21.1
                     location for a transfer location.           IC21.2  IC22.1
                                                                 IC22.2  IC25.1
                                                                 IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-DETAIL-BAL-FL    Alpha 1                                     DR100   IC138
Detail Balance Flag  This field is used to balance the bin,      IC141   IC20.1
                     lot, and serial number detail lines with    IC20.2  IC21.1
                     the transaction lines before releasing      IC21.2  IC22.1
                     the document.                               IC22.2  IC23.1
                     N = No                                      IC23.2  IC23.3
                     Y = Yes                                     IC23.4  IC23.5
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-SEQ              Numeric 3                                   IC500   IC885
Sequence Number      This field contains the sequence number
                     assigned to the last bin, lot, or serial
                     number detail line within a transaction
                     line.

ICT-LAST-DST-SEQ     Numeric 3                                   IC130   POIJ.1
Last Distribution                                                WH130   WH33.1
Sequence Nbr                                                     WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-ACTUAL-TIME      Numeric 4                                   DR100   IC138
Actual Time          This field contains the system time         IC141   IC20.1
                     when a transaction took place. This is      IC20.2  IC21.1
                     in 24-hour format (HHMM).                   IC21.2  IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC24.1
                                                                 IC24.2  IC25.1
                                                                 IC28.1  IC500
                                                                 IC850   IC90.1
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-FROM-TO-CMPY     Numeric 4                                   DR100   IC175
From or To Company   This field contains the from or to          IC20.1  IC20.2
                     company for an intercompany transaction.    IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC24.1  IC24.2
                                                                 IC25.1  IC28.1
                                                                 IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-TO-CO-B-UCOST    Signed 13.5                                 IC20.1  IC20.2
To Company Base      This field contains the base unit cost      IC21.1  IC21.2
Unit Cost            for the To company. This field is           IC22.1  IC22.2
                     converted from the 'From' company unit      IC24.1  IC24.2
                     cost. It can be in a different currency     IC25.1  IC500
                     if the two companies have different base    IC850   POIJ.1
                     currencies.                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-FROM-CURR-CD     Alpha 5                                     IC141   IC20.1
From Currency Code   This field contains the currency code       IC21.1  IC21.2
                     of the company that initiated the           IC22.1  IC22.2
                     transaction.                                IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-TO-CURR-CD       Alpha 5                                     IC141   IC20.1
To Currency Code     This field contains the currency code       IC21.1  IC21.2
                     of the company to which the inventory is    IC22.1  IC22.2
                     being transferred.                          IC500   IC850
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-HIST-PERIOD      Numeric 2                                   IC130   IC850
Historical Period    This field and the history period to        POIJ.1  WH130
                     which the transaction was posted ties a     WH33.1  WH33.2
                     transaction to the period and year to       WH33.3  WH33.4
                     which it was posted in the history file.    WH33.5  WH33.6
                     This field is updated based on the          WH33.8  WH33.9
                     transaction date when General Ledger        WH34.1  WH34.2
                     Interface (IC130) is run.                   WH34.3  WH34.4

ICT-HIST-YEAR        Numeric 4                                   IC130   IC850
Historical Year      This field and the HIST YEAR field tie      POIJ.1  WH130
                     a transaction to the period and year it     WH33.1  WH33.2
                     was posted to on the history file. This     WH33.3  WH33.4
                     field is updated based on the               WH33.5  WH33.6
                     transaction date when General Ledger        WH33.8  WH33.9
                     Interface (IC130) is run.                   WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-OPERATOR-ID      Alpha 10                                    DR100   IC138
Operator             This field contains the terminal sign       IC141   IC175
Identification Code  on identifier when this transaction was     IC20.1  IC20.2
                     created.                                    IC21.1  IC21.2
                                                                 IC22.1  IC22.2
                                                                 IC23.1  IC23.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC24.1
                                                                 IC24.2  IC26.1
                                                                 IC26.2  IC28.1
                                                                 IC500   IC850
                                                                 IC90.1  POIJ.1
                                                                 WH130   WH33.1
                                                                 WH33.2  WH33.3
                                                                 WH33.4  WH33.5
                                                                 WH33.6  WH33.8
                                                                 WH33.9  WH34.1
                                                                 WH34.2  WH34.3
                                                                 WH34.4

ICT-TO-UOM           Alpha 4                                     IC22.1  IC22.2
To Unit of Measure   This field contains the unit of measure     IC25.1  IC26.1
                     resulting from a bin-to-bin transfer        IC500   IC850
                     from one unit of measure to another.        POIJ.1  WH130
                                                                 WH33.1  WH33.2
                     This is also used by IC22.1 (Transfers)     WH33.3  WH33.4
                     to store the unit of measure of a           WH33.5  WH33.6
                     quantity being transferred. It is only      WH33.8  WH33.9
                     used for intransit transfers.               WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-KIT-FL           Alpha 1                                     POIJ.1  WH130
Kit Flag             This field is used to indicate that         WH33.1  WH33.2
                     this transaction is for kit item.           WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-BL-INVOICED      Alpha 1                                     POIJ.1  WH130
Bl Invoiced          Not currently used.                         WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-SA-INVOICED      Alpha 1                                     POIJ.1  WH130
Sa Invoiced          Not currently used.                         WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

ICT-MATCH-DTL-KEY    Alpha 55
Match Dtl Key

ICT-NDC-NBR          Alpha 15
National Drug Code   National Drug Code.

ICT-GRANT-NBR        Alpha 12
Grant Nbr

ICT-TRANS-SEQ        Numeric 6                                   DR100   IC138
Trans Seq                                                        IC141   IC22.1
                                                                 IC22.2  IC23.1
                                                                 IC23.2  IC23.3
                                                                 IC23.4  IC25.1
                                                                 IC26.1  IC26.2
                                                                 IC29.1  IC29.2
                                                                 IC29.3  IC500
                                                                 IC850   IC885
                                                                 POIJ.1  WH130
                                                                 WH33.1  WH33.2
                                                                 WH33.3  WH33.4
                                                                 WH33.5  WH33.6
                                                                 WH33.8  WH33.9
                                                                 WH34.1  WH34.2
                                                                 WH34.3  WH34.4

                         ICTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICTSET1   COMPANY                                                DR100   IC01.2
          LOCATION                                               IC110   IC138
          DOC-TYPE                                               IC141   IC175
          SYSTEM-CD                                              IC20.1  IC20.2
          DOCUMENT                                               IC21.1  IC21.2
          SHIPMENT-NBR                                           IC22.1  IC22.2
          LINE-NBR                                               IC221   IC222
          COMPONENT-SEQ                                          IC23.1  IC23.2
                                                                 IC23.3  IC23.4
                                                                 IC23.5  IC234
                                                                 IC24.1  IC24.2
                                                                 IC242   IC25.1
                                                                 IC28.1  IC29.1
                                                                 IC29.2  IC29.3
                                                                 IC48.1  IC500
                                                                 ...

ICTSET2   COMPANY       KeyChange, Subset                        IC12.1  IC220
          LOCATION      Where STATUS != Zeroes                   IC234   IC240
          ITEM                                                   IC280   IC300
          UPDATE-DATE*                                           IC50.1  IC50.2
          UPDATE-TIME*                                           IC851   POIJ.1
          TRAN-COUNTER*

ICTSET3   COMPANY       KeyChange, Subset                        IC17.1  IC229
          REASON-CODE   Where STATUS != Zeroes
          LOCATION
          ITEM
          UPDATE-DATE
          UPDATE-TIME
          TRAN-COUNTER

ICTSET4   COMPANY       KeyChange, Subset                        IC130   IC190
          LOCATION      Where (STATUS = 1                        IC199
          ITEM          Or     STATUS = 5 )
          UPDATE-DATE*
          UPDATE-TIME*
          TRAN-COUNTER*

ICTSET5   COMPANY       KeyChange, Subset                        IC20.1  IC20.2
          LOCATION      Where STATUS = Zeroes                    IC21.1  IC21.2
          DOC-TYPE                                               IC22.1  IC22.2
          SYSTEM-CD                                              IC23.1  IC23.2
          DOCUMENT                                               IC24.1  IC24.2
          ITEM                                                   IC25.1  IC500
          BIN
          TRAN-UOM
          LINE-NBR

ICTSET7   COMPANY       KeyChange, Subset                        IC234   IC50.1
          LOCATION      Where STATUS != Zeroes
          ITEM
          TRANS-DATE*
          ACTUAL-TIME*
          TRAN-COUNTER*

                         ICTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        ICCOMPANY    Required

                            ICT-COMPANY          -> ICC-COMPANY

Hazard Code    HAZARD       Not Required

                            ITE-ITEM-GROUP       -> HAZ-ITEM-GROUP
                            ITE-HAZARD-CODE      -> HAZ-HAZARD-CODE

Iclocation     ICLOCATION   Required

                            ICT-COMPANY          -> ICL-COMPANY
                            ICT-LOCATION         -> ICL-LOCATION

Inspection     PORECADJLN   Required

                            ICT-COMPANY          -> PJL-COMPANY
                            ICT-DOCUMENT         -> PJL-DOCUMENT-A
                            ICT-LINE-NBR         -> PJL-LINE-NBR

Itemloc        ITEMLOC      Required

                            ICT-COMPANY          -> ITL-COMPANY
                            ICT-LOCATION         -> ITL-LOCATION
                            ICT-ITEM             -> ITL-ITEM

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            ICT-ITEM             -> ITE-ITEM

Mmuaval        MMUAVAL      Required

                            ICT-COMPANY          -> MUA-COMPANY
                            ICT-SYSTEM-CD        -> MUA-SYSTEM-CD
                            ICT-LOCATION         -> MUA-LOCATION
                            ICT-DOC-TYPE         -> MUA-DOC-TYPE
                            ICT-DOCUMENT         -> MUA-DOC-NUMBER
                            ICT-SHIPMENT-NBR     -> MUA-DOC-NBR-NUM
                            Spaces               -> MUA-PO-CODE
                            ICT-LINE-NBR         -> MUA-LINE-NBR
                            Zeroes               -> MUA-API-OBJ-ID
                            Zeroes               -> MUA-SEQ-NBR

Porecadjln     PORECADJLN   Required

                            ICT-COMPANY          -> PJL-COMPANY
                            ICT-DOCUMENT         -> PJL-DOCUMENT-A
                            ICT-LINE-NBR         -> PJL-LINE-NBR

Porecline      PORECLINE    Required
                            When ICT-DOC-TYPE = "PO"

                            ICT-COMPANY          -> PRL-COMPANY
                            ICT-DOCUMENT         -> PRL-REC-NUMBER-A
                            ICT-LINE-NBR         -> PRL-LINE-NBR

Poreturnln     PORETURNLN   Required
                            When ICT-DOC-TYPE = "VR"
                            Or   ICT-DOC-TYPE = "VA"

                            ICT-COMPANY          -> PTL-COMPANY
                            ICT-DOCUMENT         -> PTL-RETURN-NUMBERA
                            ICT-LINE-NBR         -> PTL-RET-LINE-NBR

Reason         REASON       Not Required

                            ICT-COMPANY          -> REA-COMPANY
                            ICT-REASON-CODE      -> REA-REASON-CODE

Reasoncode     REASON       Required
                            When ICT-REASON-CODE != Spaces

                            ICT-COMPANY          -> REA-COMPANY
                            ICT-REASON-CODE      -> REA-REASON-CODE

Reqline        REQLINE      Required
                            When ICT-SYSTEM-CD = "RQ"

                            ICT-COMPANY          -> RLN-COMPANY
                            ICT-DOCUMENT         -> RLN-REQ-NUMBER-A
                            ICT-LINE-NBR         -> RLN-LINE-NBR

Whshipline     WHSHIPLINE   Not Required

                            ICT-COMPANY          -> WHL-COMPANY
                            ICT-SYSTEM-CD        -> WHL-SYSTEM-CD
                            ICT-DOCUMENT         -> WHL-DOC-NBR
                            ICT-LINE-NBR         -> WHL-LINE-NBR
                            ICT-SHIPMENT-NBR     -> WHL-SHIPMENT-NBR

                         ICTRANS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ictransdtl     ICTRANSDTL

                            ICT-COMPANY          -> ICD-COMPANY
                            ICT-LOCATION         -> ICD-LOCATION
                            ICT-DOC-TYPE         -> ICD-DOC-TYPE
                            ICT-SYSTEM-CD        -> ICD-SYSTEM-CD
                            ICT-DOCUMENT         -> ICD-DOCUMENT
                            ICT-SHIPMENT-NBR     -> ICD-SHIPMENT-NBR
                            ICT-LINE-NBR         -> ICD-LINE-NBR
                            ICT-COMPONENT-SEQ    -> ICD-COMPONENT-SEQ
                                                    ICD-TRANS-SEQ
                                                    ICD-SEQ

Itcomment      ITCOMMENT

                            ITE-ITEM-GROUP       -> ICO-ITEM-GROUP
                            ITE-ITEM             -> ICO-ITEM
                                                    ICO-LANGUAGE-CODE
                                                    ICO-SEQ

Mmdist         MMDIST       Delete Cascades

                            ICT-COMPANY          -> MMD-COMPANY
                            ICT-SYSTEM-CD        -> MMD-SYSTEM-CD
                            ICT-LOCATION         -> MMD-LOCATION
                            ICT-DOC-TYPE         -> MMD-DOC-TYPE
                            ICT-DOCUMENT         -> MMD-DOC-NUMBER
                            ICT-SHIPMENT-NBR     -> MMD-DOC-NBR-NUM
                            Spaces               -> MMD-PO-CODE
                            ICT-LINE-NBR         -> MMD-LINE-NBR
                                                    MMD-COMPONENT-SEQ
                                                    MMD-AOC-CODE
                                                    MMD-LINE-SEQ
                                                    MMD-REQ-LOCATION
                                                    MMD-API-OBJ-ID

Serial         ITSERIAL

                            ICT-COMPANY          -> SER-COMPANY
                            ICT-ITEM             -> SER-ITEM
                                                    SER-SERIAL