PMT_ACK_TMP

(SQL Table)
Index Back

Payment Ack Temp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id
2 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process
3 BANK_REF_ID Character(16) VARCHAR2(16) NOT NULL A reference identifier associated with a given bank/counterparty transaction.
4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
6 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)
7 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
8 KEY_CHAR_40_02 Character(40) VARCHAR2(40) NOT NULL Key Char 40/02
9 KEY_CHAR_40_03 Character(40) VARCHAR2(40) NOT NULL Key Char 40/03
10 KEY_CHAR_40_04 Character(40) VARCHAR2(40) NOT NULL Key Char 40/04
11 KEY_CHAR_40_05 Character(40) VARCHAR2(40) NOT NULL Key Char 40/05
12 KEY_CHAR_40_06 Character(40) VARCHAR2(40) NOT NULL Key_Char 40/06
13 KEY_CHAR_40_07 Character(40) VARCHAR2(40) NOT NULL Key Char 40/07
14 KEY_CHAR_40_08 Character(40) VARCHAR2(40) NOT NULL Key Char 40/08
15 KEY_CHAR_40_09 Character(40) VARCHAR2(40) NOT NULL Key Char 40/09
16 KEY_CHAR_40_10 Character(40) VARCHAR2(40) NOT NULL Key Char 40/10
17 KEY_CHAR_40_11 Character(40) VARCHAR2(40) NOT NULL Key Char 40/11
18 KEY_CHAR_40_12 Character(40) VARCHAR2(40) NOT NULL Key Char 40/12
19 KEY_CHAR_40_13 Character(40) VARCHAR2(40) NOT NULL Key Char 40/13
20 KEY_CHAR_40_14 Character(40) VARCHAR2(40) NOT NULL Key Char 40/14
21 KEY_CHAR_40_15 Character(40) VARCHAR2(40) NOT NULL Key Char 40/15
22 KEY_DATE_01 Date(10) DATE Key Date 01
23 KEY_DATE_02 Date(10) DATE Key Date 02
24 KEY_DATE_03 Date(10) DATE Key Date 03
25 KEY_DATE_04 Date(10) DATE Key Date 04
26 KEY_DATE_05 Date(10) DATE Key Date 05
27 KEY_DTTM_01 DateTime(26) TIMESTAMP Key Date Time 01
28 KEY_DTTM_02 DateTime(26) TIMESTAMP Key Date Time 02
29 KEY_DTTM_03 DateTime(26) TIMESTAMP Key Date Time 03
30 KEY_DTTM_04 DateTime(26) TIMESTAMP Key Date Time 04
31 KEY_DTTM_05 DateTime(26) TIMESTAMP Key Date Time 05
32 KEY_SIGN_01 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 01
33 KEY_SIGN_02 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 02
34 KEY_SIGN_03 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 03
35 KEY_SIGN_04 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 04
36 KEY_SIGN_05 Signed Number(17,2) DECIMAL(15,2) NOT NULL Key Signed Number 05