SMT_MST_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	SMT_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Group ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
6	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
7	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
8	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
9	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
11	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
12	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
13	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
14	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
15	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
16	SMT_TERMS_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
17	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
18	SMT_SIGHT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
19	DFT_SIGHT_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Sight Code
20	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.
21	SCHEDULED_PAY_DT	Date(10)	DATE	Scheduled to Pay
22	DFT_MAT_DT	Date(10)	DATE	Draft Maturity Date
23	DFT_SCHED_MAT_DT	Date(10)	DATE	Draft Scheduled Maturity Date
24	BANK_ACCT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Bank Account Sequence Number
25	SMT_SPLIT_ID	Character(5)	VARCHAR2(5) NOT NULL	Payment Split ID
26	SMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Split/Multi Payment Status C=Canceled E=Group Error EB=Bank Account SEQ NBR Not Found EI=Invalid Split ID EP=Invalid Payment Method ES=Invalid Sight Code ET=Invalid Term Code I=Inserted PM=Valid Payment Method S=Selected SC=Valid Sight Code SD=Set Due Date SE=Set Scheduled Pay Date SM=Set Maturity Date SP=Set Payment Information SS=Set Scheduled Maturity Date U=Updated
27	NUM_OF_VOUCHERS	Number(8,0)	INTEGER NOT NULL	Sched Pymnts
28	REUSABLE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reusable Item Flag
29	BANK_SETID2	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
30	BANK_CD2	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents a bank or counterparty.
31	BANK_ACCT_KEY2	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank