SMT_STG2_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SMT_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Group ID
3	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
4	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
5	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
6	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
9	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
10	SMT_PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
11	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
12	BANK_SETID2	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
13	BANK_CD2	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents a bank or counterparty.
14	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
15	EFT_LAYOUT_CD	Character(10)	VARCHAR2(10) NOT NULL	EFT Layout Code
16	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle