SMT_ERROR_VW (SQL View)	Index Back
AP Mult P-Terms Error View

SMT_ERROR_VW

(SQL View)

AP Mult P-Terms Error View

SELECT A.RUN_CNTL_ID , A.PROCESS_INSTANCE , A.SMT_GROUP_ID , A.BUSINESS_UNIT , A.VOUCHER_ID , A.PYMNT_CNT , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.REMIT_SETID , A.REMIT_VENDOR , A.ADDRESS_SEQ_NUM , A.VNDR_LOC , A.PYMNT_HANDLING_CD , A.CURRENCY_PYMNT , A.PYMNT_GROSS_AMT , A.PYMNT_METHOD , A.PYMNT_TERMS_CD , A.DFT_SIGHT_CD , A.SMT_SPLIT_ID , A.SMT_STATUS , B.REQUEST_DT FROM PS_SMT_STG_DTL A ,PS_SMT_STG_HDR B WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND %Substring(SMT_STATUS, 1, 1 ) = 'E'

# 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 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

6 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

7 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

8 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

9 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

10 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

11 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

12 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

13 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

14 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

15 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

16 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount

17 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

18 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.

19 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code

20 SMT_SPLIT_ID Character(5) VARCHAR2(5) NOT NULL Payment Split ID

21 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

22 REQUEST_DT Date(10) DATE Request Date

#	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	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
6	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
7	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
8	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
9	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
10	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
11	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
12	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
13	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
14	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
15	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
16	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
17	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
18	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.
19	DFT_SIGHT_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Sight Code
20	SMT_SPLIT_ID	Character(5)	VARCHAR2(5) NOT NULL	Payment Split ID
21	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
22	REQUEST_DT	Date(10)	DATE	Request Date