AV_ADJ_MBR_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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	MBR_PMT_NO	Character(11)	VARCHAR2(11) NOT NULL	Member Payment Number
4	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: AV_PEOPLE_SRCH
6	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
7	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person Default Value: P
8	DUES_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Dues Amt
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
10	AV_DUES_PERIOD	Number(2,0)	SMALLINT NOT NULL	Dues Periods Default Value: 1
11	AV_TTL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total Amt
12	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
13	DATA_ENTRY_DT	Date(10)	DATE	Data Entry Date Default Value: %date
14	TENDER_TYPE	Character(6)	VARCHAR2(6) NOT NULL	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	CHARITABLE_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Charitable Amount
22	MOTIVATION_CD	Character(9)	VARCHAR2(9) NOT NULL	Appeal Code Prompt Table: AV_MTVTN_MBR_VW
23	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code Prompt Table: AV_MBR_ORG_TBL
24	AV_DUES_LVL	Character(5)	VARCHAR2(5) NOT NULL	Dues Level Prompt Table: AV_MBR_DUES_TBL
25	EXPIRATION_DT	Date(10)	DATE	Expiration Date
26	AV_MBR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Membership Status A=Reactivated L=Lapsed N=New R=Renewed Default Value: N
27	START_DT	Date(10)	DATE	Start Date
28	GIFT_NO	Character(11)	VARCHAR2(11) NOT NULL	Gift Nbr
29	ADJ_REASON_CD	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
30	ADJ_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Adjusted Amt
31	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD
32	REFUND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Refund
33	AV_TTL_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total Amt
34	CURRENCY_CD_ENTRY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY
35	CHARITAB_AMT_ENTRY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Charitable Amount
36	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
37	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
38	AV_COMP_CHK	Character(1)	VARCHAR2(1) NOT NULL	Complimentary Y/N Table Edit Default Value: N
39	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_SESSION_TBL.INSTITUTION
40	AV_TNDR_GIFT_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Gift Description used for Gift in Kind and Security Tender Types
41	AV_TNDR_GIFT_PURP	Character(254)	VARCHAR2(254) NOT NULL	Gift Purpose used for Gift in Kind Tender Type
42	AV_EST_VAL	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Estimated Value
43	AV_APPRAISAL	Character(1)	VARCHAR2(1) NOT NULL	Written Appraisal used for Gift in Kind Tender Type
44	AV_APPRAISE_VAL	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Appraised Value used in Gift in Kind Tender type
45	AV_APPRAISAL_DATE	Date(10)	DATE	Appraisal Date used in Gift i n Kind Tender Type