APD_DRAFT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DFT_MASTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Draft Master ID
3	DFT_CREATE_KEY	Character(10)	VARCHAR2(10) NOT NULL	Draft Create Key
4	DFT_GROUP_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Group Code
5	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
6	DFT_MAT_DT	Date(10)	DATE	Draft Maturity Date
7	DFT_SCHED_MAT_DT	Date(10)	DATE	Draft Scheduled Maturity Date
8	PYMNT_METHOD_ALT	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House CHK=System Check DD=Direct Debit EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check WIR=Wire Report
9	DFT_LAST_MST_NUM	Character(10)	VARCHAR2(10) NOT NULL	Used during Pay Cycle for Draft grouping
10	DFT_OPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Draft Optimization D=Use Pay Cycle Default N=Do Not Use S=Specify Y/N Table Edit Default Value: N
11	DFT_MAX_NUM	Number(2,0)	SMALLINT NOT NULL	Max Number of Drafts
12	MIN_DFT_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Minimum Draft Amount
13	DFT_AMT_POS	Number(2,0)	SMALLINT NOT NULL	Rounding Position
14	DFT_REMAIN_OPT	Character(1)	VARCHAR2(1) NOT NULL	Remaining Amount Action A=Alternate Pay Mthd N=Do not issue Draft
15	DFT_STMP_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Draft StampTax Amount
16	DFT_CRRNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used during Pay Cycle for Draft rounding and Stamp tax minimization
17	DFT_XREF_ASSIGN	Character(1)	VARCHAR2(1) NOT NULL	Used during Pay Cycle for Draft rounding and Stamp tax minimization
18	DFT_XREF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Used during Pay Cycle A=Amount Modified N=New U=Unchanged
19	PROC_DFT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Process Optimization
20	PROC_DFT_ROUND	Character(1)	VARCHAR2(1) NOT NULL	Process Draft Rounding
21	DFT_ROUND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Draft Rounding D=Use Pay Cycle Default N=Do Not Use S=Specify
22	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number