| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 2 |
BAX_TRANSFER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
An unique key identifier that represents a bank transfer transaction.
Prompt Table:
BAX_HEADER_TR
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 6 |
TRANSFER_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transfer Type
00=Internal Transfer
01=External Transfer
|
| 7 |
TRANSACTION_DT |
Date(10) |
DATE NOT NULL |
Transaction date (often used as trade date)
Default Value: %DATE
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 9 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
%EDITTABLE2
|
| 10 |
BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the customer bank or counterparty in a relationship that pairs differing sets of b
Prompt Table:
BAX_ACCT_VW1
|
| 11 |
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
Prompt Table:
%EDITTABLE
|
| 12 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 13 |
SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
|
| 14 |
TEMPLATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
Y/N Table Edit
Default Value: N
|
| 15 |
BAX_SWEEP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Transfer Sweep
Y/N Table Edit
Default Value: N
|
| 16 |
MASS_BAX_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Bank Transfer Switch
Y/N Table Edit
|
| 17 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 18 |
DTTM_ENTERED |
DateTime(26) |
TIMESTAMP |
Date Time Stamp for Entry
|
| 19 |
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
Prompt Table:
STL_PYMT_MTHD_V
|
| 20 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
Prompt Table:
TR_FORMAT_VW
|
| 21 |
TR_WR_TEMPLATE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Wires / Treasury Wire Templates
This uniquely identifies templates within a Business Unit.
Prompt Table:
TR_WR_TMPL_VW2
|
| 22 |
REPETITVE_TRNFR_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Repetitive Transfer Code assigned by customers Bank
|
| 23 |
DRAWDOWN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 24 |
TMPL_EXPIRATION_DT |
Date(10) |
DATE |
Transfer Template Expiration Date
|
| 25 |
DOC_TYPE_BAX_FROM |
Character(8) |
VARCHAR2(8) NOT NULL |
From Document Type
Prompt Table:
DOC_TYPE_TBL
|
| 26 |
DOC_TYPE_BAX_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
To Document Type
Prompt Table:
DOC_TYPE_TBL
|
| 27 |
CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Code
Prompt Table:
EXT_CODE_VW
|
| 28 |
PRTRY |
Character(30) |
VARCHAR2(30) NOT NULL |
Proprietary
|