ICCATEGORY – GL Account Category
- System
- Inventory Control (IC)
- Prefix
ICA- Primary key
COMPANY,LOCATION,GL-CATEGORY- Fields
- 33
- Updated by
- 6 programs
- Referenced by
- 323 programs
ICCATEGORY is the GL Account Category table in Lawson Inventory Control (prefix ICA). It is indexed by COMPANY, LOCATION, GL-CATEGORY (ICASET1). It is related 1:1 to GLMASTER, ICCOMPANY and ICLOCATION and 1:M to ICAUDIT. It is updated by IC04.1, IC10.2, IC12.1, IC81.1, IC812 and IC841 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 315 more. The table has 33 fields, 1 index and 11 documented relations.
About ICCATEGORY
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.
Fields (33)
Column = COBOL field name without the ICA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ICA-COMPANY PKCOMPANY | Numeric 4 | 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. | IC04.1, IC841 |
#ICA-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | IC04.1, IC841 |
#ICA-GL-CATEGORY PKGL_CATEGORY | Alpha 4 | This field is used to extract the appropriate account numbers for any inventory movement. | IC04.1, IC841 |
#ICA-ACTIVE-STATUSACTIVE_STATUS | Alpha 1 | This field is used to limit the use of a general ledger category code.
| IC04.1, IC841 |
#ICA-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field is used to describe the general ledger category code. | IC04.1, IC841 |
#ICA-USED-FLUSED_FL | Alpha 1 | This field indicates whether the general ledger category has been used on the Item Location file.
| IC10.2, IC12.1, IC812 |
#ICA-INV-ACCT-UNITINV_ACCT_UNIT | Alpha 15 | This field contains the general ledger inventory account unit. | IC04.1, IC841 |
#ICA-INV-ACCOUNTINV_ACCOUNT | Numeric 6 | This field contains the general ledger inventory account number. | IC04.1, IC841 |
#ICA-INV-SUB-ACCTINV_SUB_ACCT | Numeric 4 | This field contains the general ledger inventory subaccount number. | IC04.1, IC841 |
#ICA-REC-ACCT-UNITREC_ACCT_UNIT | Alpha 15 | This field contains the general ledger receipts offset account unit. | IC04.1, IC841 |
#ICA-REC-ACCOUNTREC_ACCOUNT | Numeric 6 | This field contains the general ledger receipts offset account number. | IC04.1, IC841 |
#ICA-REC-SUB-ACCTREC_SUB_ACCT | Numeric 4 | This field contains the general ledger receipts offset subaccount number. | IC04.1, IC841 |
#ICA-ISS-ACCT-UNITISS_ACCT_UNIT | Alpha 15 | This field contains the general ledger issues offset account unit. | IC04.1, IC841 |
#ICA-ISS-ACCOUNTISS_ACCOUNT | Numeric 6 | This field contains the general ledger issues offset account number. | IC04.1, IC841 |
#ICA-ISS-SUB-ACCTISS_SUB_ACCT | Numeric 4 | This field contains the general ledger issues offset subaccount number. | IC04.1, IC841 |
#ICA-ADJ-ACCT-UNITADJ_ACCT_UNIT | Alpha 15 | This field contains the general ledger adjustment offset account unit. | IC04.1, IC841 |
#ICA-ADJ-ACCOUNTADJ_ACCOUNT | Numeric 6 | This field contains the general ledger adjustment offset account number. | IC04.1, IC841 |
#ICA-ADJ-SUB-ACCTADJ_SUB_ACCT | Numeric 4 | This field contains the general ledger adjustment offset subaccount number. | IC04.1, IC841 |
#ICA-VAR-ACCT-UNITVAR_ACCT_UNIT | Alpha 15 | This field contains the general ledger cost variance accounting unit. | IC04.1, IC841 |
#ICA-VAR-ACCOUNTVAR_ACCOUNT | Numeric 6 | This field contains the general ledger cost variance account number. | IC04.1, IC841 |
#ICA-VAR-SUB-ACCTVAR_SUB_ACCT | Numeric 4 | This field contains the general ledger cost variance subaccount number. | IC04.1, IC841 |
#ICA-INT-ACCT-UNITINT_ACCT_UNIT | Alpha 15 | This field contains the general ledger intransit account unit. | IC04.1, IC222, IC841 |
#ICA-INT-ACCOUNTINT_ACCOUNT | Numeric 6 | This field contains the general ledger intransit account number. This number is used when an item is put into intransit between two inventory locations. | IC04.1, IC222, IC841 |
#ICA-INT-SUB-ACCTINT_SUB_ACCT | Numeric 4 | This field contains the general ledger intransit subaccount number. | IC04.1, IC222, IC841 |
#ICA-PHY-ACCT-UNITPHY_ACCT_UNIT | Alpha 15 | This field contains the general ledger physical inventory variance account unit. | IC04.1, IC841 |
#ICA-PHY-ACCOUNTPHY_ACCOUNT | Numeric 6 | This field contains the general ledger physical inventory variance account number. This number offsets the inventory account when there is a physical inventory variance. | IC04.1, IC841 |
#ICA-PHY-SUB-ACCTPHY_SUB_ACCT | Numeric 4 | This field contains the general ledger physical inventory variance subaccount number. | IC04.1, IC841 |
#ICA-ADD-ACCT-UNITADD_ACCT_UNIT | Alpha 15 | This field contains the general ledger add-on cost or freight account unit. | IC04.1, IC841 |
#ICA-ADD-ACCOUNTADD_ACCOUNT | Numeric 6 | 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. | IC04.1, IC841 |
#ICA-ADD-SUB-ACCTADD_SUB_ACCT | Numeric 4 | This field contains the general ledger add-on freight subaccount number. | IC04.1, IC841 |
#ICA-SHK-ACCT-UNITSHK_ACCT_UNIT | Alpha 15 | This field contains the general ledger shrinkage accounting unit. | IC04.1, IC841 |
#ICA-SHK-ACCOUNTSHK_ACCOUNT | Numeric 6 | This field contains the general ledger shrinkage account number. | IC04.1, IC841 |
#ICA-SHK-SUB-ACCTSHK_SUB_ACCT | Numeric 4 | This field contains the general ledger shrinkage subaccount number. | IC04.1, IC841 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ICASET1 |
| Primary | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) |
Relations
One to one (10) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Addonaccount | GLMASTER | Required |
| |||||||||||||
| Adjustmentacct | GLMASTER | Required |
| |||||||||||||
| Company | ICCOMPANY | Required |
| |||||||||||||
| Iclocation | ICLOCATION | Required |
| |||||||||||||
| Intransitacct | GLMASTER | Required |
| |||||||||||||
| Invaccount | GLMASTER | Required |
| |||||||||||||
| Issuesacct | GLMASTER | Required |
| |||||||||||||
| Physinvvaracct | GLMASTER | Required |
| |||||||||||||
| Receiptsacct | GLMASTER | Required |
| |||||||||||||
| Stdcostvaracct | GLMASTER | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Icaudit | ICAUDIT |
|
Programs
Updated by (6)
- IC04.1 General Ledger Category
- IC10.2 Item Master and Location
- IC12.1 Item Location
- IC81.1 Cart, Par Location
- IC812 Item Location Load
- IC841 General Ledger Category Conversion
Referenced by (323)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX05.1 Preference Template
- CX05.2 Preference Template Diagnostics
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX205 Preference Template Items
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CX805 Template Card Conversion
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- IC02.1 Location
- IC125 Standard Cost Valuation
- IC130 General Ledger Interface
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC170 Freeze Selected Items
- IC175 Update Variances
- IC182 Par Location Utilization
- IC194 GL Category Audit Report
- IC20.1 Receipts
- IC20.2 Detail Receipts
- IC204 General Ledger Category Listing
- IC21.1 Issues
- IC21.2 Detail Issues
- IC22.1 Transfers
- IC22.2 Detail Transfer
- IC222 Unreleased Documents
- IC223 Availability Report
- IC225 Inventory Reorder Advice
- IC226 Leadtime Review Report
- IC23.1 Intransit Receiving
- IC23.2 Detail Intransit Receiving
- IC233 Inventory Valuation
- IC234 Period End Valuation
- IC24.1 Adjustments
- IC24.2 Detail Adjustments
- IC243 Killed Item Report
- IC247 IFRS FIFO Period End Valuation
- IC25.1 Document Release
- IC262 Finished Good Listing
- IC270 Count Sheets
- IC28.1 Cost Adjustments
- IC280 Distribution History Report
- IC281 Par Inventory Worksheet
- IC282 Requesting Location Usage
- IC285 Detail Par Loc Utilization
- IC31.1 Item Location Balances
- IC320 Mass Item Location Copy
- IC330 Item Mass Change
- IC331 Par Cart Mass Changes
- IC36.1 User Defined Item Inquiry
- IC40.1 Availability by Location
- IC40.2 Secondary Quantity Availability
- IC44.1 Inventory Stock Status
- IC45.1 Stock Status
- IC500 Transaction Interface
- IC520 Handheld Item Master Interface
- IC521 Bar Code Item Master Interface
- IC522 HL7 Item Master - Atwork
- IC523 HL7 Item Master - OmniCell
- IC524 CSV Item Master
- IC525 HL7 Item Master Interface
- IC526 HL7 Item Master - McKesson
- IC527 HL7 Item Master - DeRoyal
- IC598 Bin Label Export
- IC61.1 Kit Component Replacement
- IC62.1 Finished Goods
- IC62.2 Finished Good Byproducts
- IC62.4 Component Finished Goods
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC67.1 Kit Availability
- IC68.1 Finished Good Component Availability
- IC68.2 Finished Good Component Availability
- IC68.3 Finished Good Component Sub Location Availability
- IC82.1 Par Location Item Mass Change
- IC83.1 Par Location Counts
- IC84.1 Detail Par Location Utilization by Month
- IC84.2 Detail Par Location Utilization by Month
- IC840 Cart Par Location Conversion
- IC91.3 GL Category Audit Inquiry
- MA180 Open Receipt Archive
- MA236 Invoiced, Not Received Report
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA69.2 AOC Level Selections
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- PC120 Price Calculation
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO135 Received, Not Invoiced Report
- PO136 Matched, Not Received Report
- PO139 Standard Cost Calculation
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO16.1 Bid
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO228 Consolidated Demand Report
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO253 Item Receipt Volume Report
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.4 Purchase Order Inquiry
- PO54.5 PO Line Detail List
- PO64.1 PO Line Item History
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- POIM.1 GL Budget Ck for PO and RQ
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ11.5 Item AOC
- RQ111 Print Requisitions
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ270 RQ Fill Rate Analysis
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH110 Batch Allocation
- WH120 Route Creation
- WH126 POD Print
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.1 Inventoried Allocation
- WH20.2 Nonstock and Special Allocation
- WH20.3 Bin Allocation
- WH20.4 Lot Allocation
- WH20.5 Serial Allocation
- WH20.6 UOM Allocation
- WH20.7 Substitute Location
- WH22.1 Kit Options
- WH220 Ready to Allocate
- WH222 Shipments In Process
- WH224 Packing List Print
- WH226 Items on Backorder Report
- WH25.1 Cancellation By Item
- WH25.2 Cancellation By Document
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH34.5 Catch Weight
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program