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 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 DR100 IC02.1 IC125 IC130
IC140 IC141 IC142 IC145 IC170 IC175
IC20.1 IC20.2 IC204 IC21.1 IC21.2 IC211
IC22.1 IC22.2 IC222 IC223 IC225 IC226
IC23.1 IC23.2 IC233 IC234 IC24.1 IC24.2
IC25.1 IC262 IC28.1 IC280 IC281 IC31.1
IC320 IC330 IC36.1 IC40.1 IC40.2 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 IC840 PC120 SEA1.1
MA180 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 PO100 PO101 PO122 PO131
PO135 PO16.1 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO220 PO228 PO23.1 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO54.4
PO64.1 POI3.1 POIE.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 RQIF.1 RQIG.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
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
Company The company number represents an
established company and is entered on
all function codes.
ICA-LOCATION Alpha 5 IC04.1 IC841
Location Code This field contains a valid stocking
location within the company inventory.
ICA-GL-CATEGORY Alpha 4 IC04.1 IC841
General Ledger This field is used to extract the
Category appropriate account numbers for any
inventory movement.
ICA-ACTIVE-STATUS Alpha 1 IC04.1 IC841
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
Description This field is used to describe the
general ledger category code.
ICA-USED-FL Alpha 1 IC10.2 IC12.1
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
Inventory Account This field contains the general ledger
Unit inventory account unit.
ICA-INV-ACCOUNT Numeric 6 IC04.1 IC841
Inventory Account This field contains the general ledger
Nbr inventory account number.
ICA-INV-SUB-ACCT Numeric 4 IC04.1 IC841
Inventory Subaccount This field contains the general ledger
inventory subaccount number.
ICA-REC-ACCT-UNIT Alpha 15 IC04.1 IC841
Receipts Offset This field contains the general ledger
Account Unit receipts offset account unit.
ICA-REC-ACCOUNT Numeric 6 IC04.1 IC841
Receipts Offset This field contains the general ledger
Account Nbr 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
Issues Offset This field contains the general ledger
Accounting Unit issues offset account unit.
ICA-ISS-ACCOUNT Numeric 6 IC04.1 IC841
Issues Offset This field contains the general ledger
Account Number issues offset account number.
ICA-ISS-SUB-ACCT Numeric 4 IC04.1 IC841
Issues Offset This field contains the general ledger
Subaccount issues offset subaccount number.
ICA-ADJ-ACCT-UNIT Alpha 15 IC04.1 IC841
Adjustments Offset This field contains the general ledger
Acct Unit adjustment offset account unit.
ICA-ADJ-ACCOUNT Numeric 6 IC04.1 IC841
Adjustments Offset This field contains the general ledger
Account Nbr adjustment offset account number.
ICA-ADJ-SUB-ACCT Numeric 4 IC04.1 IC841
Adjustments Offset This field contains the general ledger
Subaccount adjustment offset subaccount number.
ICA-VAR-ACCT-UNIT Alpha 15 IC04.1 IC841
Cost Variance This field contains the general ledger
Accounting Unit cost variance accounting unit.
ICA-VAR-ACCOUNT Numeric 6 IC04.1 IC841
Cost Variance This field contains the general ledger
Account Number cost variance account number.
ICA-VAR-SUB-ACCT Numeric 4 IC04.1 IC841
Cost Variance This field contains the general ledger
Subaccount cost variance subaccount number.
ICA-INT-ACCT-UNIT Alpha 15 IC04.1 IC222
Intransit Account This field contains the general ledger IC841
Unit intransit account unit.
ICA-INT-ACCOUNT Numeric 6 IC04.1 IC222
Intransit Account This field contains the general ledger IC841
Nbr 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
Intransit Subaccount This field contains the general ledger IC841
intransit subaccount number.
ICA-PHY-ACCT-UNIT Alpha 15 IC04.1 IC841
Physical Inventory This field contains the general ledger
Acct Unit physical inventory variance account
unit.
ICA-PHY-ACCOUNT Numeric 6 IC04.1 IC841
Physical Inventory This field contains the general ledger
Account Nbr 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
Physical Inventory This field contains the general ledger
Subacct Nbr physical inventory variance subaccount
number.
ICA-ADD-ACCT-UNIT Alpha 15 IC04.1 IC841
Add On Cost Account This field contains the general ledger
Unit add-on cost or freight account unit.
ICA-ADD-ACCOUNT Numeric 6 IC04.1 IC841
Add On Cost 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
Add On Subaccount This field contains the general ledger
add-on freight subaccount number.
ICA-SHK-ACCT-UNIT Alpha 15 IC04.1 IC841
Shrinkage This field contains the general ledger
Accounting Unit shrinkage accounting unit.
ICA-SHK-ACCOUNT Numeric 6 IC04.1 IC841
Shrinkage Account This field contains the general ledger
shrinkage account number.
ICA-SHK-SUB-ACCT Numeric 4 IC04.1 IC841
Shrinkage 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 AP25.1
GL-CATEGORY AP25.2 AP26.1
AP27.1 CXCP.1
DR100 IC02.1
IC04.1 IC10.1
IC10.2 IC12.1
IC12.2 IC125
IC130 IC140
IC141 IC142
IC145 IC170
IC175 IC20.1
IC20.2 IC204
IC21.1 IC21.2
IC211 IC22.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
|
