EECATEGORY

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTGSET1 COMPANY
CATEGORY
EE05.1 EE11.1
EE20.3 EE20.4
EE275 EE520
EE90.3


EECATEGORY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glmaster Full GLMASTER Not Required
Valid When CTG-DIS-ACCT-UNIT !=Spaces
AndCTG-DIS-ACCOUNT !=Zeroes
AndCTG-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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glmaster Acct GLMASTER Required
When CTG-DIS-ACCOUNT !=Zeroes
AndCTG-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
AndCTG-DIS-ACCOUNT =Zeroes
AndCTG-DIS-SUB-ACCT =Zeroes
CTG-COMPANY->GLM-COMPANY
CTG-DIS-ACCT-UNIT->GLM-ACCT-UNIT
  GLM-ACCOUNT
  GLM-SUB-ACCOUNT


File created: Wed Jun 08 20:47:37 2016

Home
Contact Us



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