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 AP510 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 IC02.1 IC125
IC130 IC140 IC141 IC142 IC145 IC170
IC175 IC182 IC194 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 IC243 IC247 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
IC598 IC61.1 IC62.1 IC62.2 IC62.4 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC67.1 IC68.1 IC68.2
IC68.3 IC82.1 IC83.1 IC84.1 IC84.2 IC840
IC91.3 PC120 MA180 MA236 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA53.1 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 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO135 PO136
PO139 PO15.1 PO15.2 PO15.4 PO150 PO16.1
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO22.5 PO220 PO222 PO224
PO225 PO228 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO253 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ11.5 RQ111 RQ12.1
RQ13.1 RQ13.2 RQ270 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIH.1 RQII.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


UPDATED BY
IC04.1 IC10.2 IC12.1 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
AP510 API1.1
API2.1 CX05.1
CX05.2 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX205 CX220
CX30.1 CX300


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


ICCATEGORY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Icaudit ICAUDIT
Spaces->IAU-ITEM-GROUP
ICA-COMPANY->IAU-COMPANY
ICA-LOCATION->IAU-LOCATION
Spaces->IAU-ITEM
ICA-GL-CATEGORY->IAU-GL-CATEGORY
  IAU-DATE
  IAU-TIME
  IAU-FLD-NBR

File created: Thu Jun 09 02:18:33 2016

Home
Contact Us



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