|
|
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
AP959 EE05.1 EE20.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTG-COMPANY Numeric 4 AP959 EE05.1
Company The company number. Must be a valid
record in the Accounts Payable Company
file.
CTG-CATEGORY Alpha 9 AP959 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) AP959 EE05.1
Description The description of the category.
CTG-CATEGORY-TYPE Alpha 1 AP959 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 AP959 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 AP959 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 AP959 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 AP959 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 AP959 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 AP959 EE05.1
Reference The default distribution reference
value.
CTG-DESCRIPTION Alpha 30 (Lower Case) AP959 EE05.1
Description The default description.
CTG-ACTIVITY-FLAG Alpha 1 AP959 EE05.1
Activity Flag Indicates whether this category code is EE20.3
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 AP959 EE05.1
Require Comments This field determines whether comments
are required during expense entry. If
this field is Yes, a comment must be
defined during expense entry for each
expense detail line that has this
category assigned.
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
|