GVT_PAM_VEN_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GVT_SCHED_PREFIX	Character(10)	VARCHAR2(10) NOT NULL	Schedule Prefix represents user defined part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
2	GVT_SCHED_CODE	Character(1)	VARCHAR2(1) NOT NULL	Schedule Code identifies PeopleSoft supported schedules and it is middle part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. A=PAMSALCHK B=PAMSALEFT C=PAMMISCHK D=PAMMISEFT
3	GVT_SCHED_SEQ	Number(3,0)	SMALLINT NOT NULL	Schedule Sequence represents last part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence. Schedule may have multiple schedule sequences in case there is a schedule split due to processing requirements such as max TAS BETC amount or max number of TAS BETC per schedule.
4	GVT_PYMNT_SEQ	Number(6,0)	INTEGER NOT NULL	Payment Sequence
5	GVT_SCHED_REC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identify the record type - D (Deduction), E (Earning), G (Garnishment) or T (Tax) D=Deduction E=Earning G=Garnishment T=Tax
6	GVT_TAS_GWA	Character(26)	VARCHAR2(26) NOT NULL	TAS GWA
7	GVT_BETC_CD	Character(8)	VARCHAR2(8) NOT NULL	Business Event Type Code
8	GVT_CHECK_REF_NO	Number(4,0)	SMALLINT NOT NULL	Paycheck Reference Number
9	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
10	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
11	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
12	GVT_CR_REMIT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Credit Remit Amount
13	GVT_DR_REMIT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Debit Remit Amount
14	GVT_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Amount