ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Report Type. Description: Unique identifier for this Expense Report Type. |
EXP_CATEGORY_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Category. Description: The expense category unique identifier. |
EXP_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Type. Description: The expense type unique identifier. |
DEFAULT_FL |
|
VARCHAR2(1) |
NO |
Name: Default Flag. Description: Logical as to whether this is expense type is defaulted in Expense report wizard. |
S_TAXABLE_CD |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(10) |
YES |
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 |
|
VARCHAR2(1) |
NO |
Name: Modify Tax Rate Flag. Description: Logical as to whether user can modify tax rate. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
ACTIVE_FL |
|
VARCHAR2(1) |
NO |
Name: Active Flag. Description: Logical as to whether the expense type for this expense category and expense report type is active. |
DISTRIBUTE_TAXES_FL |
|
VARCHAR2(1) |
NO |
Name: Distribute Taxes Flag. Description: Logical as to whether or not taxes should be distributed for this Expense Type. |
COMMIT_FL |
|
VARCHAR2(1) |
NO |
Name: Expense Report Type Category Expense Type Description: Commitment flag for expense type by expense report. |