SUPP_CRYPT_AET

(SQL Table)
Index Back

State Record

State Record for FSCM_CRYPTAE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
4 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
5 BANK_ACCT_MASK Character(35) VARCHAR2(35) NOT NULL Account Number
6 BANK_ACCT_ENCRYPT Character(250) VARCHAR2(250) NOT NULL Stores Encrypted BankAccount Value
7 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
8 IBAN_ID_MASK Character(34) VARCHAR2(34) NOT NULL International Bank Account Num
9 IBAN_ID_ENCRYPT Character(250) VARCHAR2(250) NOT NULL Encrypt IBAN
10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
11 VALUE Character(254) VARCHAR2(254) NOT NULL Value
12 VALUE_ENCRYPT Character(250) VARCHAR2(250) NOT NULL Value
13 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
14 SCR_SEQ_NUM Number(5,0) INTEGER NOT NULL Update Sequence Number
15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
16 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
17 EFFDT Date(10) DATE Effective Date

Default Value: %date

18 SCR_EFFDT Date(10) DATE Approved Changes Take Effect
19 SCR_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number
20 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
21 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

Default Value: 1

22 PROFILE_FLAG Character(1) VARCHAR2(1) NOT NULL Profile Selected
N=Un-Check
Y=Check
23 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
24 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
25 ENCRYPT_PRFL_ID Character(30) VARCHAR2(30) NOT NULL Encryption Profile ID
26 DECRYPT_PRFL_ID Character(30) VARCHAR2(30) NOT NULL Decryption Profile ID