Uploading A.E.B. Bank Information

To upload bank information provided by the A.E.B. directly to the A.E.B. Bank - Spain table (F74SCSB), you import the A.E.B. bank information file into the Text Processor Detail Table (F007111) using the Text File Processor program (P007101). When you import a file into the F007111 table, the system stores the contents of the imported file in the Text field (GPTX) of the F007111 table. Because the A.E.B. bank information file has no common format, you must create a custom batch program or table conversion to parse the value in the Text field (GPTX) of the F007111 table to correspond to the fields in the F74SCSB table and to update the parsed values to the F74SCSB table.

This table lists the fields in the F74SCSB table. You can use this information when creating a custom batch program or table conversion to parse the value in the Text field (GPTX) of the Text Processor Detail Table (F007111).

Alias	Description	Length
SBCO	Bank Code	4
SOCO	Office Code	4
SSNU	Sort	4
SBNA	Bank Name	36
SONA	Office Name	36
SOAD	Office Address	40
SCDI	Control Digit	1
SFI1	Filler One	1
SCNC	City Name in Castilian	40
SCNL	City Name in Other Language	40
SOFT	Office Type	1
SBSI	Business Site Code	9
SACO	Area Code	3
SPNU	Phone Number	7
SENU	Extension Number	7
STNU	Telex Number	7
SZCO	Zip Code	5
SFI2	Filler Two	17