EFT_LAYOUT_CDPrompt Table: EFT_LAYOUT_TBL
PROCESS_INSTANCEROW_COUNTEFT_ADVICE_TMP(SQL Table) |
Index Back |
|---|---|
EFT Remittance Advice 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 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 5 | VENDOR_NAME | Character(30) | VARCHAR2(30) NOT NULL | Supplier Name |
| 6 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 7 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 8 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 9 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 10 | ADDR_CITY_ST_POST | Character(50) | VARCHAR2(50) NOT NULL | Address City, State, Postal |
| 11 | COUNTRY_NAME1 | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 12 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 13 | PYMNT_DT | Date(10) | DATE | Payment Date |
| 14 | BANK_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Name |
| 15 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 16 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 17 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 18 | BENEFICIARY_BANK | Character(30) | VARCHAR2(30) NOT NULL | The bank/counterparty associated with a given beneficiary. |
| 19 | BNK_ID_NBR_CUST | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 20 | BRANCH_ID_CUST | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 21 | BANK_ACCOUNT_NUM1 | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given internal partner bank/counterparty acco |
| 22 | VAT_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | VAT Registration ID |
| 23 | BUS_UNIT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Business Unit Name |
| 24 | BUS_UNIT_ADDRESS1 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Adress 1 |
| 25 | BUS_UNIT_ADDRESS2 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Address2 |
| 26 | BUS_UNIT_ADDRESS3 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Address3 |
| 27 | BUS_UNIT_ADDRESS4 | Character(35) | VARCHAR2(35) NOT NULL | Business Unit Address4 |
| 28 | BUS_UNIT_CITY_POST | Character(44) | VARCHAR2(44) NOT NULL | Bus Unit City/State/Zip |
| 29 | COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 30 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 31 | PAY_DOC_ID | Character(20) | VARCHAR2(20) NOT NULL | Advice ID |
| 32 | CREATION_DT | Date(10) | DATE | Creation Date |
| 33 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 34 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 35 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 36 | 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 |
| 37 | 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 |