EXP_BATCH_TYPE 
Default Table Name  EXP_BATCH_TYPE 
Definition 
 Name: Expense Batch Types.     Description: This table contains the type of expense batches that have been setup in the system.
 

EXP_BATCH_TYPE Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_BATCH_TYPE_CD(PK)    VARCHAR(10)  NO 
Name: Expense Batch Type. Description: The expense batch type unique identifier.
 
EXP_BATCH_TYPE_DESC    VARCHAR(30)  NO 
Name: Expense Batch Type Description. Description: The description of the expense batch type.
 
S_SOURCE_CD    VARCHAR(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(FK)    VARCHAR(10)  NO 
Name: Pay Method. Description: The pay method that is assigned to expenses of this type.
 
DFLT_PROVIDER_CD(FK)    VARCHAR(20)  YES 
Name: Default Provider. Description: The default provider code that should be used for expenses in this batch type. 
 
DFLT_EMPL_ID(FK)    VARCHAR(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(FK)    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    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.
 
DFLT_S_TYPE_CD    VARCHAR(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    NUMERIC(10, 0)  NO 
Name: AMEX Ghost Card Starting Position. Description: The starting position to evaluate.
 
DFLT_PERSONAL_FL    VARCHAR(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    NUMERIC(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    NUMERIC(10, 0)  NO 
Name: AMEX Employee ID Starting Position. Description: The starting position for employee identification value.
 
AMEX_EMPL_END_POSITION_NO    NUMERIC(10, 0)  NO 
Name: AMEX Employee ID Ending Postion. Description: The ending position for employee identification value.
 
AMEX_PROV_START_POSITION_NO    NUMERIC(10, 0)  NO 
Name: AMEX Provider Starting Position. Description: The starting position for provider identification value.
 
AMEX_PROV_END_POSITION_NO    NUMERIC(10, 0)  NO 
Name: AMEX Provider Ending Postion. Description: The ending position for provider identification value.
 
GHOST_CARD_END_POSITION_NO    NUMERIC(10, 0)  NO 
Name: AMEX Ghost Card Ending Position. Description: The ending position to evaluate.
 
VISA_UPDATE_EMPL_ACCOUNT_FL    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(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    VARCHAR(1)  NO 
Name: Allow Partial Post Flag. Description: Logical as to whether posting with partial complete transactions is allowed.
 
S_AMEX_FILE_SIZE_CD    VARCHAR(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(FK)    VARCHAR(3)  YES 
Name: Default Transaction Currency. Description: The pay currency that should be used for all expenses in this batch type.
 

EXP_BATCH_TYPE Keys 
Key Name  Key Type  Keys 
RI_F00421  Inversion Entry  PAY_CURRENCY_CD 
RI_F00289  Inversion Entry  DFLT_TRANS_CURRENCY_CD 
RI_F00288  Inversion Entry  DFLT_EMPL_ID 
RI_F00287  Inversion Entry  DFLT_PROVIDER_CD 
RI_F00286  Inversion Entry  PAY_METHOD_CD 
PI_0222  PrimaryKey  EXP_BATCH_TYPE_CD 

EXP_BATCH_TYPE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
PAY_METHOD  Non-Identifying  One To Zero or More        PAY_METHOD_CD  NO 
PROVIDER  Non-Identifying  Zero or One to Zero or More        DFLT_PROVIDER_CD  NO 
EMPL  Non-Identifying  Zero or One to Zero or More        DFLT_EMPL_ID  NO 
CURRENCY  Non-Identifying  Zero or One to Zero or More        DFLT_TRANS_CURRENCY_CD  NO 
CURRENCY  Non-Identifying  Zero or One to Zero or More        PAY_CURRENCY_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
EXP_BATCH_TYPE_FILTER  Identifying  One To Zero or More          NO 
BATCH_EXPENSE_EDIT  Identifying  One To Zero or More          NO 
BATCH_EXPENSE_OUTSTANDING  Identifying  One To Zero or More          NO 
EXP_BATCH_TYPE_GHOST_CARD  Identifying  One To Zero or More          NO 
EXP_BATCH_TYPE_FILTER_VISA  Identifying  One To Zero or More          NO 
EXP_BATCH_TYPE_VISA_WIZARD  Identifying  One To Zero or More          NO