SETIDVENDOR_IDVNDR_LOCEFFDTBANK_ACCT_SEQ_NBRSTL_PARTY_IND1=Receiver
2=Agent
3=Account
ISSROTHER_IDPrompt Table: %EDITTABLE
Y/N Table Edit
Default Value: N
VNDR_BANK_OTH_W(SQL Table) |
Index Back |
|---|---|
ISO and SEPA OtherID supp bankThis table is used as a work scroll only-- - Must be in VNDR_ID component buffer - Does NOT autoselect or update - table should never have any rows This provides support for VNDR_BNK_OTHID (s/b kept in sync) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | BANK_ACCT_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Bank Account Sequence Number |
| 6 | STL_PARTY_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Party Indicator for Settlement Parties
1=Receiver 2=Agent 3=Account |
| 7 | ISSR |
Character(35) | VARCHAR2(35) NOT NULL | Issuer |
| 8 | OTHER_ID |
Character(35) | VARCHAR2(35) NOT NULL | Other Identification |
| 9 | CD | Character(30) | VARCHAR2(30) NOT NULL |
Code
Prompt Table: %EDITTABLE |
| 10 | PRTRY | Character(30) | VARCHAR2(30) NOT NULL | Proprietary |
| 11 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit Default Value: N |