ACH_LAYOUT_CD1=Employee
2=Supplier
3=Both
C=Customer Bank (Payer)
V=Supplier Bank (Payee)
Default Value: V
ACH_LAYOUT_TBL(SQL Table) |
Index Back |
|---|---|
ACH Layout |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACH_LAYOUT_CD |
Character(10) | VARCHAR2(10) NOT NULL | ACH Layout Code |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | LAST_EFT_FILE_ID | Character(4) | VARCHAR2(4) NOT NULL | Last File Number |
| 5 | EFT_FILE_NBR | Character(2) | VARCHAR2(2) NOT NULL | EFT File Number |
| 6 | OUTPUT_FILENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of the translated bank statement file after the translation has been run. |
| 7 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension |
| 8 | FEDRL_EFT_ACH_IND | Character(1) | VARCHAR2(1) NOT NULL |
To indicate if a particular EFT layout is applicable to an Employee vendor or other Vendor classifcation for purposes of editing at voucher save
1=Employee 2=Supplier 3=Both |
| 9 | DFI_ID_BANK_OPT | Character(1) | VARCHAR2(1) NOT NULL |
DFI ID Bank Options
C=Customer Bank (Payer) V=Supplier Bank (Payee) Default Value: V |
| 10 | MAX_FILES | Character(4) | VARCHAR2(4) NOT NULL | Field to store maximum daily limit for ACH Layout |