Export File Specifications

 

ScotiaConnect Export File Formats:                                 

                                   

Account Balance

                                   

Field Description                                          Field Size                   Field Type     

Account Number                                           16                                character       

Balance Date                                                10                                date   

Currency                                                         3                                  character

Closing Balance Amount                        16                         currency         

Opening Balance Amount                            16                                currency         

Adjusted Opening Balance Amount            16                                currency         

Adjusted Closing Balance Amount 16                                currency         

Total Debit Count                                          16                                number          

Total Debit Amount                                       16                                currency         

Total Credit Count                                         16                                currency         

Total Credi Amount                                       16                                currency         

                                   

Account Transaction ACCPAC Format Only 

                       

Field Description                                          Field Size                   Field Type     

Timestamp                                                     16                    YYYY-MM-DD HH:MM         

Account Number                                           16                                character       

Currency                                                         3                                  character       

Debit/Credit Indicator                                   1                                  character       

Transaction Mnemonic                                 3                                  character       

Transaction Amount                                      16                                currency         

Value Date                                                     10                                date   

Transaction Serial Number                          9                                  number          

 

Account Transaction (All other Formats)

           

Field Description                                          Field Size                   Field Type     

Account Number                                           16                                character       

Account Short Name                                    10                                character       

Timestamp                                                     16                    YYYY-MM-DD HH:MM         

Value Date                                                     10                                date   

Debit/Credit Indicator                                   1                                  character       

Transaction Amount                                      16                                currency         

Transaction Mnemonic                                 3                                  character

Transaction English Text                        50                         character       

Transaction Agent Id                         9                                  number          

Transaction Serial Number                          9                                  number          

Transaction Sundry Information                   15                                character       

                                   

Cheque Reconciliation

 

 

Field Description                                          Field Size                   Field Type     

Account Number                                           16                                character       

Cheque Serial Number                                10                                character       

Cheque Date                                                 10                                date   

Cheque Amount                                            16                                currency         

Payee Name                                                 32                                character       

Reconciliation Date                                      10                                date   

Matched Cheque Serial Number                10                                character       

Matched Cheque Value Date                      10                                date   

Matched Cheque Transaction Amount       16                                currency         

 

Global Account Balance

 

Field Description                                          Field Size                   Field Type     

Ticket Number                                               16                                character       

Swift Date                                                      10                                date   

Account Number                                           35                                character       

Account Name                                               20                                character       

Bank Id                                                           20                                character       

Opening Balance Date                                 10                                date   

Opening Balance Amount                            16                                currency         

Opening Balance Currency              3                                  character       

Closing Balance Date                                  10                                date

Closing Balance Amount                        16                         currency         

Closing Balance Currency                           3                                  character       

Available Balance Date                               10                                date   

Available Balance Amount                           16                                currency         

                                   

Global Account Transaction

 

Field Description                                          Field Size                   Field Type     

Ticket Number                                               16                                character       

Swift Date                                                      10                                date   

Account Number                                           35                                character       

Value Date                                                     10                                date   

Transaction Amount                                      16                                currency         

Transaction Type                                          3                                  character       

Debit/Credit Indicator                                   1                                  character