|
|
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 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 DR100
IC02.1 IC125 IC130 IC140 IC141 IC142
IC145 IC170 IC175 IC182 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 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 IC530
IC531 IC598 IC61.1 IC62.1 IC62.2 IC67.1
IC68.1 IC68.2 IC68.3 IC82.1 IC83.1 IC84.1
IC84.2 IC840 PC120 SEA1.1 MA180 MA236
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.1 PO100 PO101 PO122
PO131 PO135 PO139 PO16.1 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO228 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 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 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ111 RQ12.1 RQ13.1 RQ35.1 RQ500
RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1 RQIH.1
RQIJ.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 WO10.1 WO120 WO130 WO131 WO132
WO133 WO140 WO20.1 WO215 WO220 WO232
WO235 WO250 WO251 WO252 WO255 WO256
WO280 WO30.1 WO30.2 WO300 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO35.1 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO40.6 WO41.1 WO41.2
WO41.3 WO41.4 WO42.1 WO42.2 WO42.3 WO42.4
WO42.5 WO45.1 WO510 WO80.1 WO81.1 WO81.2
WO82.1 WOEX.1 WOSP.1
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
Element: Company The company number represents an
established company and is entered on
all function codes.
ICA-LOCATION Alpha 5 IC04.1 IC841
Element: Location Code This field contains a valid stocking
location within the company inventory.
ICA-GL-CATEGORY Alpha 4 IC04.1 IC841
Element: Retain Gl Cd This field is used to extract the
appropriate account numbers for any
inventory movement.
ICA-ACTIVE-STATUS Alpha 1 IC04.1 IC841
Element: 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
Element: Description This field is used to describe the
general ledger category code.
ICA-USED-FL Alpha 1 IC10.2 IC12.1
Element: 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
Element: Accounting UniThis field contains the general ledger
inventory account unit.
ICA-INV-ACCOUNT Numeric 6 IC04.1 IC841
Element: Account This field contains the general ledger
inventory account number.
ICA-INV-SUB-ACCT Numeric 4 IC04.1 IC841
Element: Subaccount This field contains the general ledger
inventory subaccount number.
ICA-REC-ACCT-UNIT Alpha 15 IC04.1 IC841
Element: Accounting UniThis field contains the general ledger
receipts offset account unit.
ICA-REC-ACCOUNT Numeric 6 IC04.1 IC841
Element: Account This field contains the general ledger
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
Element: Accounting UniThis field contains the general ledger
issues offset account unit.
ICA-ISS-ACCOUNT Numeric 6 IC04.1 IC841
Element: Account This field contains the general ledger
issues offset account number.
ICA-ISS-SUB-ACCT Numeric 4 IC04.1 IC841
Element: Subaccount This field contains the general ledger
issues offset subaccount number.
ICA-ADJ-ACCT-UNIT Alpha 15 IC04.1 IC841
Element: Accounting UniThis field contains the general ledger
adjustment offset account unit.
ICA-ADJ-ACCOUNT Numeric 6 IC04.1 IC841
Element: Account This field contains the general ledger
adjustment offset account number.
ICA-ADJ-SUB-ACCT Numeric 4 IC04.1 IC841
Element: Subaccount This field contains the general ledger
adjustment offset subaccount number.
ICA-VAR-ACCT-UNIT Alpha 15 IC04.1 IC841
Element: Accounting UniThis field contains the general ledger
cost variance accounting unit.
ICA-VAR-ACCOUNT Numeric 6 IC04.1 IC841
Element: Account This field contains the general ledger
cost variance account number.
ICA-VAR-SUB-ACCT Numeric 4 IC04.1 IC841
Element: Subaccount This field contains the general ledger
cost variance subaccount number.
ICA-INT-ACCT-UNIT Alpha 15 IC04.1 IC222
Element: Accounting UniThis field contains the general ledger IC841
intransit account unit.
ICA-INT-ACCOUNT Numeric 6 IC04.1 IC222
Element: Account This field contains the general ledger IC841
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
Element: Intransit SubaThis field contains the general ledger IC841
intransit subaccount number.
ICA-PHY-ACCT-UNIT Alpha 15 IC04.1 IC841
Element: Accounting UniThis field contains the general ledger
physical inventory variance account
unit.
ICA-PHY-ACCOUNT Numeric 6 IC04.1 IC841
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 IC841
Element: Subaccount This field contains the general ledger
physical inventory variance subaccount
number.
ICA-ADD-ACCT-UNIT Alpha 15 IC04.1 IC841
Element: Accounting UniThis field contains the general ledger
add-on cost or freight account unit.
ICA-ADD-ACCOUNT Numeric 6 IC04.1 IC841
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 IC841
Element: Subaccount This field contains the general ledger
add-on freight subaccount number.
ICA-SHK-ACCT-UNIT Alpha 15 IC04.1 IC841
Element: Accounting UniThis field contains the general ledger
shrinkage accounting unit.
ICA-SHK-ACCOUNT Numeric 6 IC04.1 IC841
Element: Account This field contains the general ledger
shrinkage account number.
ICA-SHK-SUB-ACCT Numeric 4 IC04.1 IC841
Element: 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 AP20.1
GL-CATEGORY AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC02.1 IC04.1
IC10.1 IC10.2
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC145
...
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
|
