|
|
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 AP30.4 BL120 BL122 BL123 BL130
BL140 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1
BL29.2 BL520 BL820 BL92.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 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 IC62.4 IC67.1
IC68.1 IC68.2 IC68.3 IC82.1 IC83.1 IC840
PC120 SEA1.1 MA180 MA236 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 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.1 OE13.2 OE13.3 OE13.4 OE13.5
OE13.6 OE130 OE14.4 OE229 OE270 OE271
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE81.3
OE810 OE830 OE86.1 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO135 PO16.1 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO228 PO23.1 PO27.2 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 RQ13.2
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
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 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.
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
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
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
Element: Subaccount This field contains the general ledger
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 AP25.1
GL-CATEGORY AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL123 BL130
BL140 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC02.1 IC04.1
IC10.1 IC10.2
IC12.1 IC12.2
...
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
|
