|
|
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 AP225 AP226 AP25.1 AP25.2
AP26.1 BL120 BL123 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BL940 CX05.1 CX05.2 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CX805 CXCP.1 DR100 IC02.1 IC116
IC125 IC141 IC142 IC145 IC16.2 IC170
IC175 IC20.1 IC20.2 IC204 IC21.1 IC21.2
IC22.1 IC22.2 IC222 IC223 IC23.1 IC23.2
IC233 IC234 IC24.1 IC24.2 IC240 IC25.1
IC262 IC28.1 IC31.1 IC40.1 IC40.2 IC45.1
IC500 IC527 IC61.1 IC62.1 IC62.2 IC67.1
IC68.1 IC68.2 IC68.3 IC81.1 IC82.1 IC83.1
IC840 SEA1.1 IN20.1 MA530 MA540 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
OE113 OE114 OE129 OE130 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE81.1 OE81.3 OE810 OE830
OE90.1 OE920 OE950 PO100 PO135 PO180
PO20.1 PO21.1 PO21.6 PO22.1 PO22.3 PO220
PO225 PO236 PO25.2 PO28.4 PO30.1 PO31.1
PO33.1 PO34.1 PO35.1 PO530 PO821 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ111 RQ12.1 RQ13.1
RQ15.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1 RQ500
RQ961 SEA3.1 WH110 WH130 WH132 WH190
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH22.1 WH220 WH222 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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
WH961 WO10.1 WO120 WO130 WO131 WO132
WO133 WO140 WO20.1 WO215 WO220 WO232
WO235 WO250 WO251 WO252 WO255 WO256
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 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 stock
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 AP225 AP226
GL-CATEGORY AP25.1 AP25.2
AP26.1 BL120
BL123 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
...
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
|