Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EXP_BATCH_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Expense Batch Type. Description: The expense batch type unique identifier. |
FROM_VISA_MERCHANT_CATEGORY_CD |
|
NUMERIC(10, 0) |
NO |
Name: Starting Merchant Category Code. Description: Starting Merchant Category Code. |
TO_VISA_MERCHANT_CATEGORY_CD |
|
NUMERIC(10, 0) |
NO |
Name: Ending Merchant Category Code. Description: Ending Merchant Category Code |
S_TYPE_CD |
|
VARCHAR(10) |
NO |
Name: Wizard Type. Description: Internal system reference code of the type of this expense type. The valid values are: CARRENTAL ENTERTAIN LODGING MEALS MILEAGE OTHER TRANSPORT |
PAY_METHOD_CD |
|
VARCHAR(10) |
NO |
Name: Pay Method. Description: The pay method for transactions for this merchant category code range. |
PERSONAL_FL |
|
VARCHAR(1) |
NO |
Name: Personal Flag. Description: Logical as to whether transactions for this merchant category code range should default is a personal expense. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(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. |