EXP_BATCH_TYPE |
Default Table Name | EXP_BATCH_TYPE |
Definition |
EXP_BATCH_TYPE Columns |
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 | Initially Deferred |
PAY_METHOD | Non-Identifying | One To Zero or More | F00286 | PAY_METHOD_CD | NO | NO | NO | ||
PROVIDER | Non-Identifying | Zero or One to Zero or More | F00287 | DFLT_PROVIDER_CD | NO | NO | NO | ||
EMPL | Non-Identifying | Zero or One to Zero or More | F00288 | DFLT_EMPL_ID | NO | NO | NO | ||
CURRENCY | Non-Identifying | Zero or One to Zero or More | F00289 | DFLT_TRANS_CURRENCY_CD | NO | NO | NO | ||
CURRENCY | Non-Identifying | Zero or One to Zero or More | F00421 | PAY_CURRENCY_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EXP_BATCH_TYPE_FILTER | Identifying | One To Zero or More | F00290 | NO | NO | NO | |||
BATCH_EXPENSE_EDIT | Identifying | One To Zero or More | F00291 | NO | NO | NO | |||
BATCH_EXPENSE_OUTSTANDING | Identifying | One To Zero or More | F00297 | NO | NO | NO | |||
EXP_BATCH_TYPE_GHOST_CARD | Identifying | One To Zero or More | F00309 | NO | NO | NO | |||
EXP_BATCH_TYPE_FILTER_VISA | Identifying | One To Zero or More | F00410 | NO | NO | NO | |||
EXP_BATCH_TYPE_VISA_WIZARD | Identifying | One To Zero or More | F00412 | NO | NO | NO | |||
EXP_BATCH_TYPE_FILTER_MC | Identifying | One To Zero or More | FK_EXPBATCHTYPEFILTERMC_EX_IDX | NO | NO | NO |