EFT_LAYOUT_CDPrompt Table: EFT_LAYOUT_TBL
PROCESS_INSTANCEROW_COUNTEFT_BANK_TMP(SQL Table) |
Index Back |
|---|---|
EFT Bank Advice Letter Rpt Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFT_LAYOUT_CD |
Character(10) | VARCHAR2(10) NOT NULL |
EFT Layout Code
Prompt Table: EFT_LAYOUT_TBL |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | ROW_COUNT |
Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 4 | BANK_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Name |
| 5 | BANK_ADDRESS1 | Character(35) | VARCHAR2(35) NOT NULL | Bank Address1 |
| 6 | BANK_ADDRESS2 | Character(35) | VARCHAR2(35) NOT NULL | Bank Address2 |
| 7 | BANK_ADDRESS3 | Character(35) | VARCHAR2(35) NOT NULL | Bank Address3 |
| 8 | BANK_ADDRESS4 | Character(35) | VARCHAR2(35) NOT NULL | Bank Address4 |
| 9 | BANK_CITY_ST_POST | Character(44) | VARCHAR2(44) NOT NULL | Bank City/State/Zip |
| 10 | COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 11 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 12 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 13 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 14 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 15 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 16 | VAT_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | VAT Registration ID |
| 17 | BUS_UNIT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Business Unit Name |
| 18 | BUS_UNIT_ADDRESS1 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Adress 1 |
| 19 | BUS_UNIT_ADDRESS2 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Address2 |
| 20 | BUS_UNIT_ADDRESS3 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Address3 |
| 21 | BUS_UNIT_ADDRESS4 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Address4 |
| 22 | BUS_UNIT_CITY_POST | Character(44) | VARCHAR2(44) NOT NULL | Bus Unit City/State/Zip |
| 23 | COUNTRY_NAME1 | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 24 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 25 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 26 | VENDOR_NAME | Character(30) | VARCHAR2(30) NOT NULL | Supplier Name |
| 27 | BNK_ID_NBR_CUST | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 28 | BRANCH_ID_CUST | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 29 | BANK_ACCOUNT_NUM1 | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given internal partner bank/counterparty acco |
| 30 | BENEFICIARY_BANK | Character(30) | VARCHAR2(30) NOT NULL | The bank/counterparty associated with a given beneficiary. |
| 31 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 32 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 33 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 34 | 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 |
| 35 | IBAN_ID1 | Character(34) | VARCHAR2(34) NOT NULL | IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders |