|
|
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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL123 BL130 BL140 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL80.1
BL820 BL92.1 CXCP.1 IC02.1 IC130 IC204
IC320 IC330 MA180 MA236 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.7
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA66.2 MA66.3 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 PO16.1 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO228 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 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 PO64.1 POI3.1 POID.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 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 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 IC12.1 IC812
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICA-COMPANY Numeric 4 IC04.1
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
Element: Location This field contains a valid stocking
location within the company inventory.
ICA-GL-CATEGORY Alpha 4 IC04.1
Element: Gl Category This field is used to extract the
appropriate account numbers for any
inventory movement.
ICA-ACTIVE-STATUS Alpha 1 IC04.1
Element: Active 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
Element: Description This field is used to describe the
general ledger category code.
ICA-USED-FL Alpha 1 IC12.1 IC812
Element: Used Fl This field indicates whether the
general ledger category has been used on
the Item Location file.
N = No
Y = Yes
ICA-INV-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
inventory account unit.
ICA-INV-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
inventory account number.
ICA-INV-SUB-ACCT Numeric 4 IC04.1
Element: Sub Acct This field contains the general ledger
inventory subaccount number.
ICA-REC-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
receipts offset account unit.
ICA-REC-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
receipts offset account number.
ICA-REC-SUB-ACCT Numeric 4 IC04.1
Element: Sub Acct This field contains the general ledger
receipts offset subaccount number.
ICA-ISS-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
issues offset account unit.
ICA-ISS-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
issues offset account number.
ICA-ISS-SUB-ACCT Numeric 4 IC04.1
Element: Sub Acct This field contains the general ledger
issues offset subaccount number.
ICA-ADJ-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
adjustment offset account unit.
ICA-ADJ-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
adjustment offset account number.
ICA-ADJ-SUB-ACCT Numeric 4 IC04.1
Element: Sub Acct This field contains the general ledger
adjustment offset subaccount number.
ICA-VAR-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
cost variance accounting unit.
ICA-VAR-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
cost variance account number.
ICA-VAR-SUB-ACCT Numeric 4 IC04.1
Element: Sub Acct This field contains the general ledger
cost variance subaccount number.
ICA-INT-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
intransit account unit.
ICA-INT-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
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
Element: Intransit SubaThis field contains the general ledger
intransit subaccount number.
ICA-PHY-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
physical inventory variance account
unit.
ICA-PHY-ACCOUNT Numeric 6 IC04.1
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
Element: Sub Acct This field contains the general ledger
physical inventory variance subaccount
number.
ICA-ADD-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
add-on cost or freight account unit.
ICA-ADD-ACCOUNT Numeric 6 IC04.1
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
Element: Sub Acct This field contains the general ledger
add-on freight subaccount number.
ICA-SHK-ACCT-UNIT Alpha 15 IC04.1
Element: Acct Unit This field contains the general ledger
shrinkage accounting unit.
ICA-SHK-ACCOUNT Numeric 6 IC04.1
Element: Account This field contains the general ledger
shrinkage account number.
ICA-SHK-SUB-ACCT Numeric 4 IC04.1
Element: Sub Acct 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL123
BL130 BL140
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL80.1
...
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
|
