AV_GIFT_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: AV_SESSION_TBL.BUSINESS_UNIT Prompt Table: AV_INST_BU_VW
2	SESSION_NO	Character(11)	VARCHAR2(11) NOT NULL	Session Nbr Prompt Table: AV_SESSION_TBL
3	GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Gift Nbr Prompt Table: %EDITTABLE2
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
5	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: AV_EXT_ORG_SRCH
6	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
7	GIFT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Gift Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
9	GIFT_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Gift Type Default Value: GIFT Prompt Table: %EDITTABLE
10	PLEDGE_GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Pledge Number Prompt Table: AV_PLEDGES_P_VW
11	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
12	GIFT_DT	Date(10)	DATE	Gift Date Default Value: %date
13	DATA_ENTRY_DT	Date(10)	DATE	Data Entry Date Default Value: %date
14	TENDER_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Tender Type Default Value: AV_BUS_UNIT_TBL.TENDER_TYPE Prompt Table: AV_TNDR_TYPE_VW
15	CHECK_NO	Character(10)	VARCHAR2(10) NOT NULL	Check Number
16	CREDIT_CARD_NO	Character(20)	VARCHAR2(20) NOT NULL	Credit Card Number
17	CREDIT_CARD_HOLDER	Character(30)	VARCHAR2(30) NOT NULL	Credit Card Holder
18	CREDIT_CARD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Credit Card Type AE=American Express DC=Diners' Club DI=Diners Club MC=MasterCard VI=VISA
19	CREDIT_CARD_EXP_DT	Date(10)	DATE	Expiration Date
20	TENDER_TYPE_NOTE	Character(50)	VARCHAR2(50) NOT NULL	Tender Type Notes
21	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
22	ADJUSTMENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Adjusted Flag N=No Y=Yes Default Value: N
23	CAE_GIFT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	CAE Type D=Deferred Gift E=Deferred Estate Gift G=Gift K=Gift In Kind N=Non-Gift
24	CHARITABLE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Charitable Amount
25	MBR_PMT_NO	Character(11)	VARCHAR2(11) NOT NULL	Member Payment Number
26	ACKN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Acknowledgement Flg Y/N Table Edit Default Value: N
27	GIFT_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Gift Amount
28	CURRENCY_CD_ENTRY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY
29	CHARITAB_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Charitable Amount
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
32	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_SESSION_TBL.INSTITUTION
33	FEED_GIFT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Feed Gift N=No Y=Yes Default Value: Y
34	AV_TNDR_GIFT_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Gift Description used for Gift in Kind and Security Tender Types
35	AV_TNDR_GIFT_PURP	Character(254)	VARCHAR2(254) NOT NULL	Gift Purpose used for Gift in Kind Tender Type
36	AV_EST_VAL	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Estimated Value
37	AV_APPRAISAL	Character(1)	VARCHAR2(1) NOT NULL	Written Appraisal used for Gift in Kind Tender Type Y/N Table Edit
38	AV_APPRAISE_VAL	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Appraised Value used in Gift in Kind Tender type
39	AV_APPRAISAL_DATE	Date(10)	DATE	Appraisal Date used in Gift i n Kind Tender Type
40	DESCRLONG	Long Character	CLOB	Long Description