EXP_BATCH_TYPE_CD 
ColumnName  EXP_BATCH_TYPE_CD 
Definition 
Name: Expense Batch Type. Description: The expense batch type unique identifier.
 

EXP_BATCH_TYPE_DESC 
ColumnName  EXP_BATCH_TYPE_DESC 
Definition 
Name: Expense Batch Type Description. Description: The description of the expense batch type.
 

S_SOURCE_CD 
ColumnName  S_SOURCE_CD 
Definition 
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 
ColumnName  PAY_METHOD_CD 
Definition 
Name: Pay Method. Description: The pay method that is assigned to expenses of this type.
 

DFLT_PROVIDER_CD 
ColumnName  DFLT_PROVIDER_CD 
Definition 
Name: Default Provider. Description: The default provider code that should be used for expenses in this batch type. 
 

DFLT_EMPL_ID 
ColumnName  DFLT_EMPL_ID 
Definition 
Name: Default Employee. Description: The default employee ID that should be used for all expenses in this batch type.
 

DFLT_TRANS_CURRENCY_CD 
ColumnName  DFLT_TRANS_CURRENCY_CD 
Definition 
Name: Default Transaction Currency. Description: The default transaction currency that should be used for all expenses in this batch type.
 

S_EMPL_MATCH_CD 
ColumnName  S_EMPL_MATCH_CD 
Definition 
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 
ColumnName  S_PROVIDER_MATCH_CD 
Definition 
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 
ColumnName  S_FILTER_TYPE_CD 
Definition 
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 
ColumnName  S_FILTER_METHOD_CD 
Definition 
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 
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.
 

DFLT_S_TYPE_CD 
ColumnName  DFLT_S_TYPE_CD 
Definition 
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 
ColumnName  GHOST_CARD_START_POSITION_NO 
Definition 
Name: AMEX Ghost Card Starting Position. Description: The starting position to evaluate.
 

DFLT_PERSONAL_FL 
ColumnName  DFLT_PERSONAL_FL 
Definition 
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 
ColumnName  DUE_DAYS_NO 
Definition 
Name: Number of Days Deadline. Description: The number of days that employees should account for expenses in this batch.
 

AMEX_EMPL_START_POSITION_NO 
ColumnName  AMEX_EMPL_START_POSITION_NO 
Definition 
Name: AMEX Employee ID Starting Position. Description: The starting position for employee identification value.
 

AMEX_EMPL_END_POSITION_NO 
ColumnName  AMEX_EMPL_END_POSITION_NO 
Definition 
Name: AMEX Employee ID Ending Postion. Description: The ending position for employee identification value.
 

AMEX_PROV_START_POSITION_NO 
ColumnName  AMEX_PROV_START_POSITION_NO 
Definition 
Name: AMEX Provider Starting Position. Description: The starting position for provider identification value.
 

AMEX_PROV_END_POSITION_NO 
ColumnName  AMEX_PROV_END_POSITION_NO 
Definition 
Name: AMEX Provider Ending Postion. Description: The ending position for provider identification value.
 

GHOST_CARD_END_POSITION_NO 
ColumnName  GHOST_CARD_END_POSITION_NO 
Definition 
Name: AMEX Ghost Card Ending Position. Description: The ending position to evaluate.
 

VISA_UPDATE_EMPL_ACCOUNT_FL 
ColumnName  VISA_UPDATE_EMPL_ACCOUNT_FL 
Definition 
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 
ColumnName  VISA_UPDATE_PROVIDER_FL 
Definition 
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 
ColumnName  MULTI_CURRENCY_FL 
Definition 
Name: Multi-Currency Flag. Description: Logical as to whether transactions will use the transaction currency or the billed currency.
 

S_AMEX_LODGING_WIZARD_CD 
ColumnName  S_AMEX_LODGING_WIZARD_CD 
Definition 
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 
ColumnName  S_AMEX_TRANSPORT_WIZARD_CD 
Definition 
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 
ColumnName  S_AMEX_CAR_RENTAL_WIZARD_CD 
Definition 
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 
ColumnName  S_AMEX_MEALS_WIZARD_CD 
Definition 
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 
ColumnName  ALLOW_PARTIAL_POST_FL 
Definition 
Name: Allow Partial Post Flag. Description: Logical as to whether posting with partial complete transactions is allowed.
 

S_AMEX_FILE_SIZE_CD 
ColumnName  S_AMEX_FILE_SIZE_CD 
Definition 
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 
ColumnName  PAY_CURRENCY_CD 
Definition 
Name: Default Transaction Currency. Description: The pay currency that should be used for all expenses in this batch type.