CR_CARD_UPLOAD_DEF |
Default Table Name | CR_CARD_UPLOAD_DEF |
Definition |
CR_CARD_UPLOAD_DEF Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CR_CARD_TYPE![]() |
VARCHAR2(5) | NO | ||
CR_CARD_DESC | VARCHAR2(30) | NO | ||
VEND_ID_POS | NUMBER(5, 0) | NO | ||
CR_CARD_ACCT_POS | NUMBER(5, 0) | NO | ||
PAY_VEND_ID_POS | NUMBER(5, 0) | YES | ||
INVC_DT_POS | NUMBER(5, 0) | NO | ||
TRANS_AMT_POS | NUMBER(5, 0) | NO | ||
TRANS_DESC_POS | NUMBER(5, 0) | YES | ||
ACCT_ID_POS | NUMBER(5, 0) | NO | ||
ORG_ID_POS | NUMBER(5, 0) | NO | ||
PROJ_ID_POS | NUMBER(5, 0) | YES | ||
NOTES_POS | NUMBER(5, 0) | YES | ||
S_TAXABLE_CD_POS | NUMBER(5, 0) | NO | ||
TAX_CD_POS | NUMBER(5, 0) | YES | ||
TAX_AMT_POS | NUMBER(5, 0) | YES | ||
TICKET_NO_POS | NUMBER(5, 0) | YES | ||
TRIP_END_DT_POS | NUMBER(5, 0) | YES | ||
TRIP_ID_POS | NUMBER(5, 0) | YES | ||
TRIP_START_DT_POS | NUMBER(5, 0) | YES | ||
TVL_EXP_TYPE_POS | NUMBER(5, 0) | YES | ||
DEST_DESC_POS | NUMBER(5, 0) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
CR_CARD_UPLOAD_DEF Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6858 | PrimaryKey | CR_CARD_TYPE, COMPANY_ID |
CR_CARD_UPLOAD_DEF Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |