| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 2 |
PMT_MANDATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate direct debit
Prompt Table:
PMT_MANDATE_LN
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Default Value: 1
|
| 6 |
PMT_APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandate direct debit
A=Approved
N=Need Correction
O=No Action
P=Pending For Approval
R=Denied
Default Value: P
|
| 7 |
PMT_APPR_DT |
Date(10) |
DATE |
Mandate direct debit
Default Value: %date
|
| 8 |
PMT_APPR_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval By
|
| 9 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 10 |
PMT_MANDATE_DT |
Date(10) |
DATE |
Mandate direct debit
|
| 11 |
PMT_MANDATE_REF |
Character(40) |
VARCHAR2(40) NOT NULL |
Mandate direct debit
|
| 12 |
PMT_MANDATE_ORIG |
Character(40) |
VARCHAR2(40) NOT NULL |
Mandate direct debit
|
| 13 |
PMT_AMEND_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag On = amendment row
Flag = Off = no amendment row
Y/N Table Edit
Default Value: N
|
| 14 |
PMT_DEBTOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandate direct debit
B=Treasury Counterparty
C=Customer
Default Value: C
|
| 15 |
PMT_DEBTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Debtor Identifier
|
| 16 |
PMT_DEBTOR_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate direct debit
|
| 17 |
PMT_DEBTOR_PARTY |
Character(30) |
VARCHAR2(30) NOT NULL |
Mandate direct debit
|
| 18 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 19 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
CUSTOMER
|
| 20 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 21 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Counterparty
Prompt Table:
BANK_CD_TBL
|
| 22 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table:
COUNTRY_TBL
|
| 23 |
ADDRESS1_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1 Other
|
| 24 |
ADDRESS2_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2 Other
|
| 25 |
ADDRESS3_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3 Other
|
| 26 |
ADDRESS4_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4 Other
|
| 27 |
CITY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
City Other
|
| 28 |
COUNTY_OTHER |
Character(30) |
VARCHAR2(30) NOT NULL |
County Other
|
| 29 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
Prompt Table:
%EDIT_STATE_OTH
|
| 30 |
POSTAL_OTHER |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Other
|
| 31 |
NUM1_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1 Other
|
| 32 |
NUM2_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2 Other
|
| 33 |
HOUSE_TYPE_OTHER |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type Other
AB=House Boat Reference
WW=House Trailer Reference
|
| 34 |
ADDR_FIELD1_OTHER |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1 Other
|
| 35 |
ADDR_FIELD2_OTHER |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2 Other
|
| 36 |
ADDR_FIELD3_OTHER |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3 Other
|
| 37 |
IN_CITY_LMT_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit Other
|
| 38 |
GEO_CODE_OTHER |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code Other
|
| 39 |
PMT_PAYMENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandate direct debit
O=One-Off Payment
R=Recurrence Payment
Default Value: R
|
| 40 |
PMT_ORIG_CRED_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Mandate direct debit
|
| 41 |
PMT_ORIG_CRED_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
Mandate direct debit
|
| 42 |
PMT_ORIG_CRED_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Mandate direct debit
|
| 43 |
PMT_CRED_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Mandate direct debit
|
| 44 |
PMT_CREDITOR_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
Mandate direct debit
|
| 45 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 46 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 47 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 48 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 49 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 50 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 51 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 52 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 53 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 54 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 55 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 56 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 57 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 58 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 59 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 60 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 61 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 62 |
IBAN_ID |
Character(34) |
VARCHAR2(34) NOT NULL |
IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
|
| 63 |
IBAN_CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
IBAN Check Digit
|
| 64 |
USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 65 |
PMT_SIGNED_LOC |
Character(30) |
VARCHAR2(30) NOT NULL |
Mandate direct debit
|
| 66 |
PMT_SIGNED_DT |
Date(10) |
DATE |
Mandate direct debit
Default Value: %date
|
| 67 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
Prompt Table:
TR_MICR_CUST_VW
|
| 68 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 69 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
PMT_REASON_VW
|
| 70 |
PMT_ORIG_IBAN_ID |
Character(34) |
VARCHAR2(34) NOT NULL |
IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
|
| 71 |
PMT_ORIG_BIC_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
The Bank Identifier Code, also known as a BIC or BIC code, is a universal method of identifying financial institutions in order to facilitate the automated processing of payments.
|
| 72 |
DFI_ID_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
Default Value: 02
|
| 73 |
DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
|