CT_PAYMENT_TYPE Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
CLEARING_ACCOUNT_CODE Indexed - yes Format - varchar2(20) May be null? yes
IS_DELETED Indexed - no Format - char(1) May be null? yes	Indicates whether the payment type record has been deleted from Concur.
PAT_CODE Indexed - yes Format - varchar2(4) May be null? yes	Unique code that identifies a payment method within Concur.
PAT_KEY Indexed - yes Format - char(4) May be null? no	Unique system-assigned key that identifies the payment type (method) used to pay the expense.
PAYMENT_TYPE_LAST_MODIFIED Indexed - no Format - date May be null? yes	Date on which the payment type record was last modified.
SYSTEM_RECORD Indexed - no Format - char(1) May be null? yes

Questions about this page? Email us at da-staff@isc.upenn.edu