USF_UEIDUSF_EFT_INDDUNS_NUMBERUSF_DUNS_PLUS4USF_VDHDR_CRYPT(SQL Table) |
Index Back |
|---|---|
AP NACHA - SAM Account ChildAP NACHA - SAM Account Child Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USF_UEID |
Character(12) | VARCHAR2(12) NOT NULL | Unique Entity Identifier |
| 2 | USF_EFT_IND |
Character(4) | VARCHAR2(4) NOT NULL | Entity EFT Indicator |
| 3 | DUNS_NUMBER |
Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 4 | USF_DUNS_PLUS4 |
Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |
| 5 | USF_BANK_ACCT_NBR | Character(30) | VARCHAR2(30) NOT NULL | Bank Account Nbr |
| 6 | BANK_ACCT_ENCRYPT | Character(250) | VARCHAR2(250) NOT NULL | Stores Encrypted BankAccount Value |
| 7 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |