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    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL123     BL130     BL140     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL80.1
BL820     BL92.1    CXCP.1    IC02.1    IC130     IC204
IC320     IC330     MA180     MA236     MA41.1    MA41.2
MA41.4    MA41.7    MA43.1    MA43.2    MA43.3    MA43.7
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA69.1    MA69.2    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO100     PO101     PO122     PO131
PO135     PO136     PO139     PO16.1    PO190     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO228     PO23.1    PO24.1    PO25.1    PO25.5
PO25.6    PO25.7    PO253     PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO32.4    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    POID.1
POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1
RQ111     RQ12.1    RQ13.1    RQ13.2    RQ35.1    RQ500
RQIC.1    RQID.1    RQIF.1    RQIG.1    RQIH.1    RQIJ.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     WH224     WH226
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

UPDATED BY

IC04.1    IC12.1    IC812

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICA-COMPANY            Numeric 4                                 IC04.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

ICA-ACTIVE-STATUS      Alpha 1                                   IC04.1
Element: Active 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
Element: Description   This field is used to describe the
                       general ledger category code.

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

ICA-INV-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       inventory account unit.

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

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

ICA-REC-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       receipts offset account unit.

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

ICA-REC-SUB-ACCT       Numeric 4                                 IC04.1
Element: Sub Acct      This field contains the general ledger
                       receipts offset subaccount number.

ICA-ISS-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       issues offset account unit.

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

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

ICA-ADJ-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       adjustment offset account unit.

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

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

ICA-VAR-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       cost variance accounting unit.

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

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

ICA-INT-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       intransit account unit.

ICA-INT-ACCOUNT        Numeric 6                                 IC04.1
Element: Account       This field contains the general ledger
                       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
Element: Intransit SubaThis field contains the general ledger
                       intransit subaccount number.

ICA-PHY-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       physical inventory variance account
                       unit.

ICA-PHY-ACCOUNT        Numeric 6                                 IC04.1
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
Element: Sub Acct      This field contains the general ledger
                       physical inventory variance subaccount
                       number.

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

ICA-ADD-ACCOUNT        Numeric 6                                 IC04.1
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
Element: Sub Acct      This field contains the general ledger
                       add-on freight subaccount number.

ICA-SHK-ACCT-UNIT      Alpha 15                                  IC04.1
Element: Acct Unit     This field contains the general ledger
                       shrinkage accounting unit.

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

ICA-SHK-SUB-ACCT       Numeric 4                                 IC04.1
Element: Sub Acct      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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL123
                                                                 BL130   BL140
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL80.1
                                                                 ...

                         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