银行电子对账单格式

银行电子对账单
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 file creation such as date/time stamp, file number, bank reference, and bank code
02 Group Header – this lists com-mon data for all of the accounts con-tained in the file
(e.g., currency key)
03 Account Header –specific 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 –signifies the end of all accountsin the file, and has a control check for all the “49” balance records in the file
99 –file trailer –the sum of all 98 records in the file
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,,,,,,,,,,/。