APD_DRAFT_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	DFT_MASTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Draft Master ID
4	DFT_CREATE_KEY	Character(10)	VARCHAR2(10) NOT NULL	Draft Create Key
5	SOURCE_TXN	Character(4)	VARCHAR2(4) NOT NULL	Source Transaction
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	PAY_DOC_ID	Character(20)	VARCHAR2(20) NOT NULL	Advice ID
8	PAY_DOC_SEQ	Number(5,0)	INTEGER NOT NULL	Advice Sequence
9	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
10	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
11	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
12	PYMNT_SEPARATE	Character(1)	VARCHAR2(1) NOT NULL	Separate Payment
13	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
14	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
15	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
16	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
17	PAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Paid Amount
18	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
19	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
20	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
21	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
22	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
23	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
24	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
25	GRP_PYMNT_DT	Character(1)	VARCHAR2(1) NOT NULL	Group by Payment Date
26	DFT_GROUP_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Group Code
27	DFT_MAT_DT	Date(10)	DATE	Draft Maturity Date
28	DFT_SCHED_MAT_DT	Date(10)	DATE	Draft Scheduled Maturity Date
29	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
30	DFT_XREF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Used during Pay Cycle A=Amount Modified N=New U=Unchanged
31	DFT_XREF_INCL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used during Pay Cycle to include or exclude Drafts from Pay Cycle based after Draft rounding E=Xref Excluded I=Xref Included Default Value: I
32	DFT_MASTER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Master Status A=Approved N=Not Apprv R=Rejected
33	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments Default Value: 0