PS - Thought this might help as well - extracting from data tables and inserting data in to a temp table, so that the field size matches the bank requirements.

CREATE TABLE dbo.AP_POSPAY

(

ID char(1) NOT NULL,

[Bank Number] char(3) NOT NULL,

Account char(10) NOT NULL,

[Ck Number] char(10) NOT NULL,

Amount char (13) NOT NULL,

Issued char (8) NOT NULL,

[Additional Data] char(30) NOT NULL,

Payee char(80) NOT NULL,

Void char(1) NOT NULL

) ON [PRIMARY]