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 |
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. |
|
||||
CTG-CATEGORY Element: Category | Alpha 9 A user-defined representing a general ledger expense distribution account for a specific type of expense. |
|
||||
CTG-CATEGORY-DESC Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||||
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 |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
CTG-DST-REFERENCE Element: Cross Ref | Alpha 10 The default distribution reference value. |
|
||||
CTG-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The default description. |
|
||||
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. |
|
||||
CTG-REQ-COMMENTS Element: Required Comments | Alpha 1 This field is not currently used. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CTGSET1 |
COMPANY CATEGORY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Glmaster Full | GLMASTER |
Not Required
| ||||||||||||||||||||||||||||||
Txtaxcode | TXTAXCODE |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Glmaster Acct | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Glmaster Au | GLMASTER |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.