SCR_HST_CRYPT

(SQL Table)
Index Back

SCR Bank Account Adjustment

SCR Bank Account Adjustment History

# 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