PeopleSoft 9 Account Payables |
Table Name | EFT_FILE_RPT |
Table Description |
EFT_FILE_RPT |
Columns |
Name | Datatype | Is PK | Is FK |
EFT_LAYOUT_CD | VARCHAR(10) | Yes | Yes |
FILE_NAME_SHORT | VARCHAR(30) | Yes | No |
PROCESS_INSTANCE | decimal(10) | Yes | No |
CURRENCY_CD | VARCHAR(3) | Yes | No |
BANK_ACCOUNT_NUM | VARCHAR(17) | Yes | No |
BANK_NAME | VARCHAR(30) | No | No |
BANK_ADDRESS1 | VARCHAR(35) | No | No |
BANK_ADDRESS2 | VARCHAR(35) | No | No |
BANK_ADDRESS3 | VARCHAR(35) | No | No |
BANK_ADDRESS4 | VARCHAR(35) | No | No |
BANK_CITY_ST_POST | VARCHAR(44) | No | No |
COUNTRY_NAME | VARCHAR(30) | No | No |
BUS_UNIT_NAME | VARCHAR(30) | No | No |
BUS_UNIT_ADDRESS1 | VARCHAR(35) | No | No |
BUS_UNIT_ADDRESS2 | VARCHAR(35) | No | No |
BUS_UNIT_ADDRESS3 | VARCHAR(35) | No | No |
BUS_UNIT_ADDRESS4 | VARCHAR(35) | No | No |
BUS_UNIT_CITY_POST | VARCHAR(44) | No | No |
COUNTRY_NAME1 | VARCHAR(30) | No | No |
MEDIA_DESCR | VARCHAR(10) | No | No |
PYMNT_AMT_TTL | decimal(18,3) | No | No |
PYMNT_REC_CNT | decimal(10) | No | No |
BANK_ACCT_NUM_SUM | VARCHAR(15) | No | No |
SEQ_NUM | SMALLINT | No | No |
CONTACT_NAME | VARCHAR(50) | No | No |
FILE_CREATE_DT | PSDATE | No | No |
CONTROL_TTL_CHAR | VARCHAR(25) | No | No |
BNK_ID_NBR | VARCHAR(20) | No | No |
PYMNT_REC_CNT_TTL | decimal(10) | No | No |
LANGUAGE_CD | VARCHAR(3) | No | No |
CONFIG_DTL_FLAG | VARCHAR(1) | No | No |
BANK_CODE_SUM | VARCHAR(20) | No | No |
IBAN_ID | VARCHAR(34) | No | No |
Index |
Name | Type | Unique | Member |
PS_EFT_FILE_RPT | PK | Yes |
![]() |
Member(s) of "PS_EFT_FILE_RPT" Index |
EFT_LAYOUT_CD |
FILE_NAME_SHORT |
PROCESS_INSTANCE |
CURRENCY_CD |
BANK_ACCOUNT_NUM |
Published June 06, 2007 |