银行电子对账单格式

银行电子对账单

SAP支持的银行电子对账单格式

AUSZUG.TXT

----------

Field# Type min. max. opt. Description

1 A 0 1

2 bank key

2 A 0 24 bank account number

3 N 1

4 statement number

4 X 8 8 statement date

5 A 3 3 currency key

6 N 1 18.2 opening balance amount

7 N 1 18.2 debit total

8 N 1 18.2 credit total

9 N 1 18.2 closing balance amount

10 A 0 35 bank account holder

11 A 0 35 X special account name

12 X 8 8 X life start

13 X 8 8 X life end

14 －0 0 not used

15 －0 0 not used

16 －0 0 not used

17 －0 0 not used

18 N 1 5 number of records in statement

UMSATZ.TXT

--------------

Field# Type min. max. opt. Description

1 A 0 1

2 bank key

2 A 0 24 bank account number

3 N 1

4 statement number

4 X 8 8 value date

5 N 1 10 X primary note number

example of AUSZUG:

123;12345678;17;26.01.09;EUR;2047,28;0,00;4167,29;6214,57;;;;;0,000;0;0;27.01.09;3

UMSATZ:

123;12345678;17;27.01.09;0; XXXXXXXXXX XXXXXX XXXXXXXX;NONREF;0;CTR;;3281,60;0;3;26.01.09;XXXXXXXXXX;;09/01/26;;;;;;;;;;;;;;;;;;0;;

BAI格式

01 File Header –data relating to the ?le creation such as date/time stamp, ?le number, bank reference, and bank code

02 Group Header –this lists com-mon data for all of the accounts con-tained in the ?le

(e.g., currency key)

03 Account Header –speci?c infor-mation for one bank account, includ-ing: currency, closing balance, and total debit and credit values

88 – these indicate further informa-tion for the above line

16 –these are the actual transac-tions you would see on your paper statement, and indicate the external transaction code, amount, and text associated with it. Note the amounts include the two decimal places (1000 is actually $10.00).

49 –this indicates the end of the items for this particular account. It indi-cates end balances of all the transac-tions for this particular account.

98 –signi?es the end of all accountsin the ?le, and has a control check for all the “49” balance records in the ?le

99 –?le trailer –the sum of all 98 records in the ?le

01,EBSTEST,EBSTEST,100312,0944,1,99,99,2,,,,,,,/

02,EBSTEST,CMBCCNBS,1,100312,0944,USD,,,,,,,,,/

03,100202110100001,USD,010,100000,,,015,140000,,,045,140000,,,/

16,115,40000,Z,,,LOCKPAYMENT FROM 6015630,,,,,,,,,/

49,140000,99,,,,,,,,,,/

98,140000,99,,,,,,,,,,/

99,140000,99,,,,,,,,,,/