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 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXP_BATCH_TYPE_CD(PK)    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(FK)    VARCHAR2(10)  NO 
Name: Pay Method. Description: The pay method that is assigned to expenses of this type.
 
DFLT_PROVIDER_CD(FK)    VARCHAR2(20)  YES 
Name: Default Provider. Description: The default provider code that should be used for expenses in this batch type. 
 
DFLT_EMPL_ID(FK)    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(FK)    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(FK)    VARCHAR2(3)  YES 
Name: Default Transaction Currency. Description: The pay currency that should be used for all expenses in this batch type.
 

EXP_BATCH_TYPE Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0222  PrimaryKey  EXP_BATCH_TYPE_CD 

EXP_BATCH_TYPE Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
PAY_METHOD  Non-Identifying  One To Zero or More  F00286      PAY_METHOD_CD  NO  NO 
PROVIDER  Non-Identifying  Zero or One to Zero or More  F00287      DFLT_PROVIDER_CD  NO  NO 
EMPL  Non-Identifying  Zero or One to Zero or More  F00288      DFLT_EMPL_ID  NO  NO 
CURRENCY  Non-Identifying  Zero or One to Zero or More  F00289      DFLT_TRANS_CURRENCY_CD  NO  NO 
CURRENCY  Non-Identifying  Zero or One to Zero or More  F00421      PAY_CURRENCY_CD  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
EXP_BATCH_TYPE_FILTER  Identifying  One To Zero or More  F00290        NO  NO 
BATCH_EXPENSE_EDIT  Identifying  One To Zero or More  F00291        NO  NO 
BATCH_EXPENSE_OUTSTANDING  Identifying  One To Zero or More  F00297        NO  NO 
EXP_BATCH_TYPE_GHOST_CARD  Identifying  One To Zero or More  F00309        NO  NO 
EXP_BATCH_TYPE_FILTER_VISA  Identifying  One To Zero or More  F00410        NO  NO 
EXP_BATCH_TYPE_VISA_WIZARD  Identifying  One To Zero or More  F00412        NO  NO