Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICCATEGORY


                            ICCATEGORY FILE

                          GL Account Category

The GL Account Category file is a master file that defines the inventory and
offset general ledger accounts used to post inventory transactions. Examples
include issues, receipts, and adjustments of physical inventory count
variances. A valid category code is assigned to each location where items are
tracked.

REFERENCED 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    CXCP.1    DR100
IC02.1    IC125     IC130     IC140     IC141     IC142
IC145     IC170     IC175     IC182     IC20.1    IC20.2
IC204     IC21.1    IC21.2    IC22.1    IC22.2    IC222
IC223     IC225     IC226     IC23.1    IC23.2    IC233
IC234     IC24.1    IC24.2    IC25.1    IC262     IC270
IC28.1    IC280     IC281     IC282     IC285     IC31.1
IC320     IC330     IC331     IC36.1    IC40.1    IC40.2
IC44.1    IC45.1    IC500     IC520     IC521     IC522
IC523     IC524     IC525     IC526     IC527     IC530
IC531     IC598     IC61.1    IC62.1    IC62.2    IC67.1
IC68.1    IC68.2    IC68.3    IC82.1    IC83.1    IC84.1
IC84.2    IC840     PC120     SEA1.1    MA180     MA236
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA66.2    MA66.3    MA67.1    MA67.2    MA70.1
MA75.1    MA80.1    MAI1.1    PO100     PO101     PO122
PO131     PO135     PO139     PO16.1    PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO220
PO228     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     PO54.4    PO64.1
POI3.1    POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ111     RQ12.1    RQ13.1    RQ35.1    RQ500
RQIC.1    RQID.1    RQIE.1    RQIF.1    RQIG.1    RQIH.1
RQIJ.1    SEA3.1    WH110     WH120     WH126     WH130
WH132     WH190     WH20.1    WH20.2    WH20.3    WH20.4
WH20.5    WH20.6    WH20.7    WH22.1    WH220     WH222
WH25.1    WH25.2    WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4    WH34.5    WH40.1    WH40.2    WH520
WH830     WO10.1    WO120     WO130     WO131     WO132
WO133     WO140     WO20.1    WO215     WO220     WO232
WO235     WO250     WO251     WO252     WO255     WO256
WO280     WO30.1    WO30.2    WO300     WO32.1    WO32.2
WO32.3    WO32.4    WO32.5    WO35.1    WO40.1    WO40.2
WO40.3    WO40.4    WO40.5    WO40.6    WO41.1    WO41.2
WO41.3    WO41.4    WO42.1    WO42.2    WO42.3    WO42.4
WO42.5    WO45.1    WO510     WO80.1    WO81.1    WO81.2
WO82.1    WOEX.1    WOSP.1

UPDATED BY

IC04.1    IC10.2    IC12.1    IC81.1    IC812     IC841

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICA-COMPANY            Numeric 4                                 IC04.1  IC841
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

ICA-LOCATION           Alpha 5                                   IC04.1  IC841
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

ICA-GL-CATEGORY        Alpha 4                                   IC04.1  IC841
Element: Retain Gl Cd  This field is used to extract the
                       appropriate account numbers for any
                       inventory movement.

ICA-ACTIVE-STATUS      Alpha 1                                   IC04.1  IC841
Element: Status        This field is used to limit the use of
                       a general ledger category code.
                       A = Active
                       I = Inactive

ICA-DESCRIPTION        Alpha 30  (Lower Case)                    IC04.1  IC841
Element: Description   This field is used to describe the
                       general ledger category code.

ICA-USED-FL            Alpha 1                                   IC10.2  IC12.1
Element: Used          This field indicates whether the          IC812
                       general ledger category has been used on
                       the Item Location file.
                       N = No
                       Y = Yes

ICA-INV-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       inventory account unit.

ICA-INV-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       inventory account number.

ICA-INV-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       inventory subaccount number.

ICA-REC-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       receipts offset account unit.

ICA-REC-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       receipts offset account number.

ICA-REC-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Receipts Offset        This field contains the general ledger
Subaccount             receipts offset subaccount number.

ICA-ISS-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       issues offset account unit.

ICA-ISS-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       issues offset account number.

ICA-ISS-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       issues offset subaccount number.

ICA-ADJ-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       adjustment offset account unit.

ICA-ADJ-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       adjustment offset account number.

ICA-ADJ-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       adjustment offset subaccount number.

ICA-VAR-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       cost variance accounting unit.

ICA-VAR-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       cost variance account number.

ICA-VAR-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       cost variance subaccount number.

ICA-INT-ACCT-UNIT      Alpha 15                                  IC04.1  IC222
Element: Accounting UniThis field contains the general ledger    IC841
                       intransit account unit.

ICA-INT-ACCOUNT        Numeric 6                                 IC04.1  IC222
Element: Account       This field contains the general ledger    IC841
                       intransit account number. This number is
                       used when an item is put into intransit
                       between two inventory locations.

ICA-INT-SUB-ACCT       Numeric 4                                 IC04.1  IC222
Element: Intransit SubaThis field contains the general ledger    IC841
                       intransit subaccount number.

ICA-PHY-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       physical inventory variance account
                       unit.

ICA-PHY-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       physical inventory variance account
                       number. This number offsets the
                       inventory account when there is a
                       physical inventory variance.

ICA-PHY-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       physical inventory variance subaccount
                       number.

ICA-ADD-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       add-on cost or freight account unit.

ICA-ADD-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       add-on cost or freight account number.
                       This account is used if there is an
                       add-on cost entered when an intransit is
                       received.

ICA-ADD-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       add-on freight subaccount number.

ICA-SHK-ACCT-UNIT      Alpha 15                                  IC04.1  IC841
Element: Accounting UniThis field contains the general ledger
                       shrinkage accounting unit.

ICA-SHK-ACCOUNT        Numeric 6                                 IC04.1  IC841
Element: Account       This field contains the general ledger
                       shrinkage account number.

ICA-SHK-SUB-ACCT       Numeric 4                                 IC04.1  IC841
Element: Subaccount    This field contains the general ledger
                       shrinkage subaccount number.

                         ICCATEGORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICASET1   COMPANY                                                AP125   AP126
          LOCATION                                               AP131   AP20.1
          GL-CATEGORY                                            AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  DR100
                                                                 IC02.1  IC04.1
                                                                 IC10.1  IC10.2
                                                                 IC12.1  IC12.2
                                                                 IC125   IC130
                                                                 IC140   IC141
                                                                 IC142   IC145
                                                                 ...

                         ICCATEGORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Addonaccount   GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-ADD-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-ADD-ACCOUNT      -> GLM-ACCOUNT
                            ICA-ADD-SUB-ACCT     -> GLM-SUB-ACCOUNT

Adjustmentacct GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-ADJ-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-ADJ-ACCOUNT      -> GLM-ACCOUNT
                            ICA-ADJ-SUB-ACCT     -> GLM-SUB-ACCOUNT

Company        ICCOMPANY    Required

                            ICA-COMPANY          -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            ICA-COMPANY          -> ICL-COMPANY
                            ICA-LOCATION         -> ICL-LOCATION

Intransitacct  GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-INT-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-INT-ACCOUNT      -> GLM-ACCOUNT
                            ICA-INT-SUB-ACCT     -> GLM-SUB-ACCOUNT

Invaccount     GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-INV-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-INV-ACCOUNT      -> GLM-ACCOUNT
                            ICA-INV-SUB-ACCT     -> GLM-SUB-ACCOUNT

Issuesacct     GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-ISS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-ISS-ACCOUNT      -> GLM-ACCOUNT
                            ICA-ISS-SUB-ACCT     -> GLM-SUB-ACCOUNT

Physinvvaracct GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-PHY-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-PHY-ACCOUNT      -> GLM-ACCOUNT
                            ICA-PHY-SUB-ACCT     -> GLM-SUB-ACCOUNT

Receiptsacct   GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-REC-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-REC-ACCOUNT      -> GLM-ACCOUNT
                            ICA-REC-SUB-ACCT     -> GLM-SUB-ACCOUNT

Stdcostvaracct GLMASTER     Required

                            ICA-COMPANY          -> GLM-COMPANY
                            ICA-VAR-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ICA-VAR-ACCOUNT      -> GLM-ACCOUNT
                            ICA-VAR-SUB-ACCT     -> GLM-SUB-ACCOUNT