EECATEGORY FILE
Expense-Advance Category Code
The Category Code file contains expense category code records. Category codes
are used to link general ledger distribution and accrual accounts to an
employee expense. They can also be used to default a tax code, invoice accrual
code, expense type, reference value, and description on the detail lines of an
employee expense.
REFERENCED BY
EE275 EE520 EE90.3
UPDATED BY
EE05.1 EE20.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTG-COMPANY Numeric 4 EE05.1
Company The company number. Must be a valid
record in the Accounts Payable Company
file.
CTG-CATEGORY Alpha 9 EE05.1
Category A user-defined representing a general
ledger expense distribution account for
a specific type of expense.
CTG-CATEGORY-DESC Alpha 30 (Lower Case) EE05.1
Description The description of the category.
CTG-CATEGORY-TYPE Alpha 1 EE05.1
Category Type Indicates the type of expense category.
Valid values are:
E = Employee Paid Expense.
C = Company Paid Expense.
P = Cash Payment (Payback).
U = Units
CTG-DIS-ACCT-UNIT Alpha 15 EE05.1
Accounting Unit The default general ledger distribution
accounting unit. Select a valid
accounting unit if you want the
interface program to create general
ledger transactions for transactions
with a record status of 1 and 2 only. A
transaction will be created to this
account and an offset transaction to the
cash account. Must be a valid record in
the General Ledger Names file.
CTG-DIS-ACCOUNT Numeric 6 EE05.1
Account Number Required if the distribution accounting
unit field is not blank. The default
general ledger distribution account
number. Must be a valid record in the
General Ledger Account Master file.
CTG-DIS-SUB-ACCT Numeric 4 EE05.1
Subaccount Number The default general ledger distribution
subaccount number. Must be a valid
record in the General Ledger Account
Master file.
CTG-TAX-CODE Alpha 10 EE05.1
Tax Code The tax code associated with the
expense category. Used to calculate tax
information for an expense distribution.
Must be a valid record in the Tax Code
file.
CTG-ACCR-CODE Alpha 4 EE05.1
Invoice Accrual Code The invoice accrual code associated
with the expense category. Represents a
general ledger accrual account. Must be
a valid record in the Invoice Accrual
Code file.
CTG-DST-REFERENCE Alpha 10 EE05.1
Reference The default distribution reference
value.
CTG-DESCRIPTION Alpha 30 (Lower Case) EE05.1
Description The default description.
CTG-ACTIVITY-FLAG Alpha 1 EE05.1 EE20.3
Activity Flag Indicates whether this category code is
used. This flag is set to "Y" once the
category code is assigned to an employee
expense payback. Valid values are:
N = No.
Y = Yes.
CTG-REQ-COMMENTS Alpha 1 EE05.1
Required Comments This field is not currently used.
EECATEGORY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTGSET1 COMPANY This index is used to validate a EE05.1 EE20.3
CATEGORY category code for a specific company. EE20.4 EE275
EE520 EE90.3
EECATEGORY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glmaster Full GLMASTER Not Required
Valid When CTG-DIS-ACCT-UNIT != Spaces
And CTG-DIS-ACCOUNT != Zeroes
And CTG-DIS-SUB-ACCT != Zeroes
CTG-COMPANY -> GLM-COMPANY
CTG-DIS-ACCT-UNIT -> GLM-ACCT-UNIT
CTG-DIS-ACCOUNT -> GLM-ACCOUNT
CTG-DIS-SUB-ACCT -> GLM-SUB-ACCOUNT
Txtaxcode TXTAXCODE Not Required
CTG-COMPANY -> TAC-COMPANY
CTG-TAX-CODE -> TAC-TAX-CODE
EECATEGORY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glmaster Acct GLMASTER Required
When CTG-DIS-ACCOUNT != Zeroes
And CTG-DIS-ACCT-UNIT = Spaces
CTG-COMPANY -> GLM-COMPANY
CTG-DIS-ACCOUNT -> GLM-ACCOUNT
CTG-DIS-SUB-ACCT -> GLM-SUB-ACCOUNT
GLM-ACCT-UNIT
Glmaster Au GLMASTER Required
When CTG-DIS-ACCT-UNIT != Spaces
And CTG-DIS-ACCOUNT = Zeroes
And CTG-DIS-SUB-ACCT = Zeroes
CTG-COMPANY -> GLM-COMPANY
CTG-DIS-ACCT-UNIT -> GLM-ACCT-UNIT
GLM-ACCOUNT
GLM-SUB-ACCOUNT
|
