ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_BATCH_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Batch Type. Description: The expense batch type unique identifier. |
EXP_BATCH_TYPE_DESC |
|
VARCHAR2(30) |
NO |
Name: Expense Batch Type Description. Description: The description of the expense batch type. |
S_SOURCE_CD |
|
VARCHAR2(10) |
NO |
Name: Batch Type Source. Description: The source of the expense batches for this type. The valid values are as follows:AMEX – American Express (KR-1025). . OFX – Open Financial Exchange (OFX). . MANUAL – Manual Entry . . VISAVCF40 – Visa VCF 4.0 |
PAY_METHOD_CD |
|
VARCHAR2(10) |
NO |
Name: Pay Method. Description: The pay method that is assigned to expenses of this type. |
DFLT_PROVIDER_CD |
|
VARCHAR2(20) |
YES |
Name: Default Provider. Description: The default provider code that should be used for expenses in this batch type. |
DFLT_EMPL_ID |
|
VARCHAR2(20) |
YES |
Name: Default Employee. Description: The default employee ID that should be used for all expenses in this batch type. |
DFLT_TRANS_CURRENCY_CD |
|
VARCHAR2(3) |
YES |
Name: Default Transaction Currency. Description: The default transaction currency that should be used for all expenses in this batch type. |
S_EMPL_MATCH_CD |
|
VARCHAR2(1) |
NO |
Name: Employee Match Option. Description: The method employee IDs are matched to expenses. The valid methods are as follows:I – Employee ID. G – Government ID. P – Pay Method Reference. 1 – Employee User Defined 1. 2 – Employee User Defined 2. 3 – Employee User Defined 3 |
S_PROVIDER_MATCH_CD |
|
VARCHAR2(1) |
NO |
Name: Provider Match Option. Description: The method providers are matched to expenses. The valid methods are as follows:P – Provider Code. 1 – Provider User Defined 1. 2 – Provider User Defined 2. 3 – Provider User Defined 3. The type of filter used for import transactions. The valid values are as follows:. I – Include |
S_FILTER_TYPE_CD |
|
VARCHAR2(1) |
NO |
Name: Transaction Filter Type. Description: The type of filter used for import transactions. The valid values are as follows:I – Include. E – Exclude. |
S_FILTER_METHOD_CD |
|
VARCHAR2(3) |
NO |
Name: Transaction Filter Method. Description: The method the filters are evaluated. The valid values are as follows:ALL – All True. ANY– Any True. |
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. |
DFLT_S_TYPE_CD |
|
VARCHAR2(10) |
YES |
Name: Default Wizard Type. Description: The default wizard type that should be used for all expenses in this batch. Valid values are:CARRENTAL. ENTERTAIN. LODGING. MEALS. MILEAGE. OTHER. TRANSPORT |
GHOST_CARD_START_POSITION_NO |
|
NUMBER(10, 0) |
NO |
Name: AMEX Ghost Card Starting Position. Description: The starting position to evaluate. |
DFLT_PERSONAL_FL |
|
VARCHAR2(1) |
NO |
Name: Default Personal Flag. Description: Logical as to whether transaction for all expenses in this batch type should default is a personal expense. |
DUE_DAYS_NO |
|
NUMBER(10, 0) |
NO |
Name: Number of Days Deadline. Description: The number of days that employees should account for expenses in this batch. |
AMEX_EMPL_START_POSITION_NO |
|
NUMBER(10, 0) |
NO |
Name: AMEX Employee ID Starting Position. Description: The starting position for employee identification value. |
AMEX_EMPL_END_POSITION_NO |
|
NUMBER(10, 0) |
NO |
Name: AMEX Employee ID Ending Postion. Description: The ending position for employee identification value. |
AMEX_PROV_START_POSITION_NO |
|
NUMBER(10, 0) |
NO |
Name: AMEX Provider Starting Position. Description: The starting position for provider identification value. |
AMEX_PROV_END_POSITION_NO |
|
NUMBER(10, 0) |
NO |
Name: AMEX Provider Ending Postion. Description: The ending position for provider identification value. |
GHOST_CARD_END_POSITION_NO |
|
NUMBER(10, 0) |
NO |
Name: AMEX Ghost Card Ending Position. Description: The ending position to evaluate. |
VISA_UPDATE_EMPL_ACCOUNT_FL |
|
VARCHAR2(1) |
NO |
Name: VISA Update Employee Account Flag. Description: Logical as to whether visa account records should update for account changes and when employees are assigned to transactions. |
VISA_UPDATE_PROVIDER_FL |
|
VARCHAR2(1) |
NO |
Name: VISA Update Provider Flag. Description: Logical as to whether visa transactions should try to assign providers based on visa merchant codes. Also whether when providers are assigned to transactions. |
MULTI_CURRENCY_FL |
|
VARCHAR2(1) |
NO |
Name: Multi-Currency Flag. Description: Logical as to whether transactions will use the transaction currency or the billed currency. |
S_AMEX_LODGING_WIZARD_CD |
|
VARCHAR2(10) |
NO |
Name: AMEX Lodging Wizard Mapping. Description: Indicates the type of wizard that lodging expenses should be mapped to. The valid options areo LODGING. OTHER. |
S_AMEX_TRANSPORT_WIZARD_CD |
|
VARCHAR2(10) |
NO |
Name: AMEX Transportation Wizard Mapping. Description: Indicates the type of wizard that transportation expenses should be mapped to. The valid options areo TRANSPORT. OTHER. |
S_AMEX_CAR_RENTAL_WIZARD_CD |
|
VARCHAR2(10) |
NO |
Name: AMEX Car Rental Wizard Mapping. Description: Indicates the type of wizard that car rental expenses should be mapped to. The valid options areo CARRENTAL. OTHER. |
S_AMEX_MEALS_WIZARD_CD |
|
VARCHAR2(10) |
NO |
Name: AMEX Meal Wizard Mapping. Description: Indicates the type of wizard that meal expenses should be mapped to. The valid options are MEALS. OTHER. |
ALLOW_PARTIAL_POST_FL |
|
VARCHAR2(1) |
NO |
Name: Allow Partial Post Flag. Description: Logical as to whether posting with partial complete transactions is allowed. |
S_AMEX_FILE_SIZE_CD |
|
VARCHAR2(2) |
NO |
Name: AMEX File Size Limit Setting. Description: Size allocated for the import of AMEX KR1025 file. Valid values are:o 5. o 10. o 20. o 40. o 50. |
PAY_CURRENCY_CD |
|
VARCHAR2(3) |
YES |
Name: Default Transaction Currency. Description: The pay currency that should be used for all expenses in this batch type. |