EXP_RPT_TYPE_CD |
ColumnName | EXP_RPT_TYPE_CD |
Definition | Name: Expense Report Type. Description: Unique identifier for this Expense Report Type. |
EXP_CATEGORY_CD |
ColumnName | EXP_CATEGORY_CD |
Definition | Name: Expense Category. Description: The expense category unique identifier. |
EXP_TYPE_CD |
ColumnName | EXP_TYPE_CD |
Definition | Name: Expense Type. Description: The expense type unique identifier. |
DEFAULT_FL |
ColumnName | DEFAULT_FL |
Definition | Name: Default Flag. Description: Logical as to whether this is expense type is defaulted in Expense report wizard. |
S_TAXABLE_CD |
ColumnName | S_TAXABLE_CD |
Definition | Name: Taxable Option. Description: Indicates whether expense type for this expense category and expense report type is taxable and if so, what type of tax. The valid values are as follows: N – Not Taxable. V – Vat Taxable. U – Use Taxable. S – Sales Taxable |
TAX_SCHEDULE_CD |
ColumnName | TAX_SCHEDULE_CD |
Definition | Name: Tax Schedule. Description: The tax schedule that must be used for this expense type, expense category, and expense report type. |
MODIFY_TAX_RATE_FL |
ColumnName | MODIFY_TAX_RATE_FL |
Definition | Name: Modify Tax Rate Flag. Description: Logical as to whether user can modify tax rate. |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition | Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
ColumnName | ROWVERSION |
Definition | Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition | Name: Time Stamp. Description: Date and time the record was last modified. |
ACTIVE_FL |
ColumnName | ACTIVE_FL |
Definition | Name: Active Flag. Description: Logical as to whether the expense type for this expense category and expense report type is active. |
DISTRIBUTE_TAXES_FL |
ColumnName | DISTRIBUTE_TAXES_FL |
Definition | Name: Distribute Taxes Flag. Description: Logical as to whether or not taxes should be distributed for this Expense Type. |
COMMIT_FL |
ColumnName | COMMIT_FL |
Definition | Name: Expense Report Type Category Expense Type Description: Commitment flag for expense type by expense report. |