PMT_PRTOINF_MAP

(SQL Table)
 Index Back

Payment Ultimate Party

Payment Ultimate Entry - Staging Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HEADER_ID Character(8) VARCHAR2(8) NOT NULL Header_id
2 BATCH_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Batch Number
3 PYMNT_REF_ID Character(20) VARCHAR2(20) NOT NULL Payment ID
4 PMT_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 PMT_PARTY_TYPE Character(4) VARCHAR2(4) NOT NULL Field for Identifying Various Party Types
CDTR=Creditor
CRAC=Creditor Account
CRAG=Creditor Agent
DBTR=Debtor
DRAC=Debtor Account
DRAG=Debtor Agent
INIT=Initiating Party
UCDT=Ultimate Creditor
UDBT=Ultimate Debtor
6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
10 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description
11 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

30 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
31 CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
B=Billing Contact
C=Contract Collaborator
D=Commercial Paper Contact
E=External Contact
F=Cash Forecast
G=General
I=Internal Corporate Contact
L=Line of Credit Contact
M=Executive Management
O=Investment Pool Contact
P=Accounts Payable
R=Broker
S=Sales Contact
V=Service Contact
W=Warehousing/Shipping Contact
32 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
33 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
34 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
35 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
36 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
37 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
38 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
39 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
40 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code