ICCATEGORY

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 API2.1
CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX205 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 DR100 IC125 IC130 IC140
IC141 IC142 IC145 IC170 IC175 IC182
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC222 IC223 IC225 IC226 IC23.1 IC23.2
IC233 IC234 IC24.1 IC24.2 IC247 IC25.1
IC262 IC270 IC28.1 IC280 IC281 IC282
IC285 IC31.1 IC330 IC331 IC36.1 IC40.1
IC40.2 IC44.1 IC45.1 IC500 IC520 IC521
IC522 IC523 IC524 IC525 IC526 IC527
IC598 IC61.1 IC62.1 IC62.2 IC62.4 IC66.1
IC67.1 IC68.1 IC68.2 IC68.3 IC82.1 IC83.1
IC84.1 IC84.2 IC840 PC120 ZC522 MA180
MA236 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA66.2
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
PO150 PO16.1 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO22.5 PO220 PO222 PO228
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO253 PO27.2 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 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 PO54.5 PO64.1 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 POIM.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ111 RQ12.1
RQ13.1 RQ13.2 RQ270 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 WH32.5 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 ZW130 IC204


UPDATED BY
IC02.1 IC04.1 IC10.2 IC12.1 IC320 IC81.1
IC812 IC841

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICA-COMPANY
Element: Company		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
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
IC04.1 IC841
ICA-GL-CATEGORY
Element: Gl Category		Alpha 4
This field is used to extract the appropriate account numbers for any inventory movement.
IC04.1 IC841
ICA-ACTIVE-STATUS
Element: Active Status		Alpha 1
This field is used to limit the use of a general ledger category code.
A = Active
I = Inactive
IC04.1 IC841
ICA-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field is used to describe the general ledger category code.
IC04.1 IC841
ICA-USED-FL
Element: Used Fl		Alpha 1
This field indicates whether the general ledger category has been used on the Item Location file.
N = No
Y = Yes
IC10.2 IC12.1
IC812
ICA-INV-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger inventory account unit.
IC04.1 IC841
ICA-INV-ACCOUNT
Element: Account		Numeric 6
This field contains the general ledger inventory account number.
IC04.1 IC841
ICA-INV-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger inventory subaccount number.
IC04.1 IC841
ICA-REC-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger receipts offset account unit.
IC04.1 IC841
ICA-REC-ACCOUNT
Element: Account		Numeric 6
This field contains the general ledger receipts offset account number.
IC04.1 IC841
ICA-REC-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger receipts offset subaccount number.
IC04.1 IC841
ICA-ISS-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger issues offset account unit.
IC04.1 IC841
ICA-ISS-ACCOUNT
Element: Account		Numeric 6
This field contains the general ledger issues offset account number.
IC04.1 IC841
ICA-ISS-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger issues offset subaccount number.
IC04.1 IC841
ICA-ADJ-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger adjustment offset account unit.
IC04.1 IC841
ICA-ADJ-ACCOUNT
Element: Account		Numeric 6
This field contains the general ledger adjustment offset account number.
IC04.1 IC841
ICA-ADJ-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger adjustment offset subaccount number.
IC04.1 IC841
ICA-VAR-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger cost variance accounting unit.
IC04.1 IC841
ICA-VAR-ACCOUNT
Element: Account		Numeric 6
This field contains the general ledger cost variance account number.
IC04.1 IC841
ICA-VAR-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger cost variance subaccount number.
IC04.1 IC841
ICA-INT-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger intransit account unit.
IC04.1 IC222
IC841
ICA-INT-ACCOUNT
Element: 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-ACCT
Element: Intransit Subaccount		Numeric 4
This field contains the general ledger intransit subaccount number.
IC04.1 IC222
IC841
ICA-PHY-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger physical inventory variance account unit.
IC04.1 IC841
ICA-PHY-ACCOUNT
Element: 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-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger physical inventory variance subaccount number.
IC04.1 IC841
ICA-ADD-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger add-on cost or freight account unit.
IC04.1 IC841
ICA-ADD-ACCOUNT
Element: 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-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger add-on freight subaccount number.
IC04.1 IC841
ICA-SHK-ACCT-UNIT
Element: Acct Unit		Alpha 15
This field contains the general ledger shrinkage accounting unit.
IC04.1 IC841
ICA-SHK-ACCOUNT
Element: Account		Numeric 6
This field contains the general ledger shrinkage account number.
IC04.1 IC841
ICA-SHK-SUB-ACCT
Element: Sub Acct		Numeric 4
This field contains the general ledger shrinkage subaccount number.
IC04.1 IC841


ICCATEGORY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICASET1 COMPANY
LOCATION
GL-CATEGORY
...
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 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506


ICCATEGORY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:16:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.