PMT_FORMX_TMP

(SQL Table)
Index Back

Manual cancel mandate

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CONTRACT_ID1 Character(60) VARCHAR2(60) NOT NULL Field's label for SEPA Direct Debit Form
3 PMT_MANDATE_REF Character(40) VARCHAR2(40) NOT NULL Mandate direct debit
4 CONTRACT_ID2 Character(60) VARCHAR2(60) NOT NULL Field's label for SEPA Direct Debit Form
5 CONTRACT_TEXT1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
6 CONTRACT_TEXT2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
7 COUNTRY1 Character(20) VARCHAR2(20) NOT NULL Field's label for SEPA Direct Debit Form
8 COUNTRY2 Character(20) VARCHAR2(20) NOT NULL Field's label for SEPA Direct Debit Form
9 CREDITOR_ID1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
10 CREDITOR_ID2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
11 CREDITOR_ONLY1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
12 CREDITOR_ONLY2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
13 HEADER_TEXT1 Long Character CLOB Field's label for SEPA Direct Debit Form
14 LBL_ACCOUNT_INFO1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
15 LBL_ACCOUNT_INFO2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
16 LBL_ADDRESS1 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
17 LBL_ADDRESS2 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
18 LBL_ASSIGN_CITY1 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
19 LBL_ASSIGN_CITY2 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
20 LBL_BIC Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
21 LBL_CITY1 Character(15) VARCHAR2(15) NOT NULL Field's label for SEPA Direct Debit Form
22 LBL_CITY2 Character(15) VARCHAR2(15) NOT NULL Field's label for SEPA Direct Debit Form
23 LBL_CONTRACT1 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
24 LBL_CONTRACT2 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
25 LBL_CRED_ADDR1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
26 LBL_CRED_ADDR2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
27 LBL_CRED_CITY1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
28 LBL_CRED_CITY2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
29 LBL_CRED_COUNTRY1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
30 LBL_CRED_COUNTRY2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
31 LBL_CRED_POSTAL1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
32 LBL_CRED_POSTAL2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
33 LBL_CREDITOR1 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
34 LBL_CREDITOR2 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
35 LBL_DATE1 Character(20) VARCHAR2(20) NOT NULL Field's label for SEPA Direct Debit Form
36 LBL_DATE2 Character(20) VARCHAR2(20) NOT NULL Field's label for SEPA Direct Debit Form
37 LBL_DEBTOR_DTL1 Character(100) VARCHAR2(100) NOT NULL Field's label for SEPA Direct Debit Form
38 LBL_DEBTOR_DTL2 Character(100) VARCHAR2(100) NOT NULL Field's label for SEPA Direct Debit Form
39 LBL_DEBTOR_ID1 Character(50) VARCHAR2(50) NOT NULL Debtor Information
40 LBL_DEBTOR_ID2 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
41 LBL_DEBTOR_NAME1 Character(35) VARCHAR2(35) NOT NULL Field's label for SEPA Direct Debit Form
42 LBL_DEBTOR_NAME2 Character(35) VARCHAR2(35) NOT NULL Field's label for SEPA Direct Debit Form
43 LBL_IBAN1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
44 LBL_IBAN2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
45 LBL_NAME1 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
46 LBL_NAME2 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
47 LBL_POSTAL1 Character(20) VARCHAR2(20) NOT NULL Field's label for SEPA Direct Debit Form
48 LBL_POSTAL2 Character(20) VARCHAR2(20) NOT NULL Field's label for SEPA Direct Debit Form
49 LBL_REF_PARTY1 Character(100) VARCHAR2(100) NOT NULL Field's label for SEPA Direct Debit Form
50 LBL_REF_PARTY2 Character(100) VARCHAR2(100) NOT NULL Field's label for SEPA Direct Debit Form
51 LBL_STREET1 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
52 LBL_STREET2 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
53 LBL_TITLE1 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
54 LBL_TITLE2 Character(50) VARCHAR2(50) NOT NULL Field's label for SEPA Direct Debit Form
55 LBL_TYPE_PAYMENT1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
56 LBL_TYPE_PAYMENT2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
57 LOCATION_TEXT1 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
58 LOCATION_TEXT2 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
59 OR_TEXT1 Character(10) VARCHAR2(10) NOT NULL Field's label for SEPA Direct Debit Form
60 OR_TEXT2 Character(10) VARCHAR2(10) NOT NULL Field's label for SEPA Direct Debit Form
61 PLEASE_RETURN1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
62 PLEASE_RETURN2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
63 REF_PARTY_TXT1 Character(250) VARCHAR2(250) NOT NULL Field's label for SEPA Direct Debit Form
64 REF_PARTY_TXT2 Character(250) VARCHAR2(250) NOT NULL Field's label for SEPA Direct Debit Form
65 SIGN_TEXT1 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
66 SIGN_TEXT2 Character(30) VARCHAR2(30) NOT NULL Field's label for SEPA Direct Debit Form
67 TYPE_PAYMENT_R1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
68 TYPE_PAYMENT_R2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
69 TYPE_PAYMENTO1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
70 TYPE_PAYMENTO2 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form
71 LBL_COUNTRY1 Character(25) VARCHAR2(25) NOT NULL Country
72 LBL_COUNTRY2 Character(25) VARCHAR2(25) NOT NULL Country