# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
SCR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Change Request ID
|
2 |
SCR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Update Sequence Number
|
3 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
4 |
SCR_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
5 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
6 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
7 |
BANK_ACCT_ENCRYPT |
Character(250) |
VARCHAR2(250) NOT NULL |
Stores Encrypted BankAccount Value
|
8 |
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
|
9 |
IBAN_ID_ENCRYPT |
Character(250) |
VARCHAR2(250) NOT NULL |
Encrypt IBAN
|