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

EE11.1

EE20.3

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CTG-COMPANY Element: Company	Numeric 4 The company number. Must be a valid record in the Accounts Payable Company file.	EE05.1
CTG-CATEGORY Element: Category	Alpha 9 A user-defined representing a general ledger expense distribution account for a specific type of expense.	EE05.1
CTG-CATEGORY-DESC Element: Description	Alpha 30 (Lower Case) This field displays the description.	EE05.1
CTG-CATEGORY-TYPE Element: Category Type	Alpha 1 Indicates the type of expense category. Valid values are: E = Employee Paid Expense. C = Company Paid Expense. P = Cash Payment (Payback). U = Units	EE05.1
CTG-DIS-ACCT-UNIT Element: Acct Unit	Alpha 15 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.	EE05.1
CTG-DIS-ACCOUNT Element: Account	Numeric 6 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.	EE05.1
CTG-DIS-SUB-ACCT Element: Sub Acct	Numeric 4 The default general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file.	EE05.1
CTG-TAX-CODE Element: Tax Code	Alpha 10 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.	EE05.1
CTG-ACCR-CODE Element: Invoice Accrual Code	Alpha 4 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.	EE05.1
CTG-DST-REFERENCE Element: Cross Ref	Alpha 10 The default distribution reference value.	EE05.1
CTG-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The default description.	EE05.1
CTG-ACTIVITY-FLAG Element: Activity Flag	Alpha 1 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.	EE05.1 EE11.1 EE20.3
CTG-REQ-COMMENTS Element: Required Comments	Alpha 1 This field is not currently used.	EE05.1

EECATEGORY FILE INDEX

EECATEGORY FILE RELATIONS

ONE TO ONE RELATIONS

EECATEGORY FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.