SAP ABAP Table OFX_STMTTRN (Transaction for Account Statement (All Versions))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-BL-PT (Application Component) Payment Transactions
     ⤷ FBZI (Package) Payments via Internet

Basic Data

Table Category	INTTAB	Structure
Structure	OFX_STMTTRN	Table Relationship Diagram
Short Description	Transaction for Account Statement (All Versions)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TRNTYPE	☐	OFX_TRNTYPE	CHAR64	CHAR	64	0	Transaction Type (There are Currently 17 Types)
2	DTPOSTED	☐	OFX_DTPOSTED	OFX_DATETIMESTR	CHAR	27	0	Date at Which the Transaction Reaches the Account
3	DTUSER	☐	OFX_DTUSER	OFX_DATETIMESTR	CHAR	27	0	Date on Which the User Started the Transaction
4	DTAVAIL	☐	OFX_DTAVAIL	OFX_DATETIMESTR	CHAR	27	0	Date at Which Funds are Available
5	TRNAMT	☐	OFX_TRNAMT	OFX_AMOUNT	CHAR	32	0	Transaction Amount
6	FITID	☐	OFX_FITID	OFX_FITID	CHAR	255	0	Transaction Identification Assigned by Financial Institution
7	CORRECTFITID	☐	OFX_CORRECTFITID	OFX_FITID	CHAR	255	0	FITID of Transaction to be Corrected by this Transaction
8	CORRECTACTION	☐	OFX_CORRECTACTION	CHAR16	CHAR	16	0	Action with Transaction to be Corrected (REPLACE or DELETE)
9	SRVRTID	☐	OFX_SRVRTID	OFX_SRVRTID	CHAR	10	0	Identification Assigned by Server
10	SRVRTID2	☐	OFX_SRVRTID2	CHAR36	CHAR	36	0	Identification Assigned by Server
11	CHECKNUM	☐	OFX_CHECKNUM	CHAR12	CHAR	12	0	Check Number
12	REFNUM	☐	OFX_REFNUM	CHAR32	CHAR	32	0	Unique Reference Number of Transaction
13	SIC	☐	OFX_SIC	NUM6	NUMC	6	0	Standard Industry Code
14	PAYEEID	☐	OFX_PAYEEID	CHAR12	CHAR	12	0	Receiver's Identification
15	PAYEEID2	☐	OFX_PAYEEID2	CHAR36	CHAR	36	0	Receiver's Identification
16	NAME	☐	OFX_NAME	CHAR32	CHAR	32	0	Name of Recipient or of Transaction
17	PAYEE	☐	OFX_PAYEE		STRU	0	0
18	NAME	☐	OFX_NAME	CHAR32	CHAR	32	0	Name of Recipient or of Transaction
19	ADDR1	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
20	ADDR2	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
21	ADDR3	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
22	CITY	☐	OFX_CITY	CHAR32	CHAR	32	0	City
23	STATE	☐	OFX_STATE	CHAR5	CHAR	5	0	State
24	POSTALCODE	☐	OFX_POSTALCODE	CHAR11	CHAR	11	0	Postal Code
25	COUNTRY	☐	OFX_COUNTRY	CHAR3	CHAR	3	0	Country (3 Character Code from ISO/DIS-3166)
26	PHONE	☐	OFX_PHONE	CHAR32	CHAR	32	0	Telephone Number
27	PAYEE2	☐	OFX_PAYEE		STRU	0	0
28	NAME	☐	OFX_NAME	CHAR32	CHAR	32	0	Name of Recipient or of Transaction
29	ADDR1	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
30	ADDR2	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
31	ADDR3	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
32	CITY	☐	OFX_CITY	CHAR32	CHAR	32	0	City
33	STATE	☐	OFX_STATE	CHAR5	CHAR	5	0	State
34	POSTALCODE	☐	OFX_POSTALCODE	CHAR11	CHAR	11	0	Postal Code
35	COUNTRY	☐	OFX_COUNTRY	CHAR3	CHAR	3	0	Country (3 Character Code from ISO/DIS-3166)
36	PHONE	☐	OFX_PHONE	CHAR32	CHAR	32	0	Telephone Number
37	BANKACCTTO	☐	OFX_BANKACCTTO2		STRU	0	0
38	BANKID	☐	OFX_BANKID	CHAR9	CHAR	9	0	Bank ID for Routing and Transit
39	BRANCHID	☐	OFX_BRANCHID	CHAR22	CHAR	22	0	Bank ID for International Banks
40	ACCTID	☐	OFX_ACCTID	CHAR22	CHAR	22	0	Account Number
41	ACCTTYPE	☐	OFX_ACCTTYPE	OFX_ACCTTYPE	CHAR	10	0	Account Type
42	ACCTKEY	☐	OFX_ACCTKEY	CHAR22	CHAR	22	0	Control Total for International Banks
43	EXTBANKACCTTO	☐	OFX_EXTBANKACCTTO		STRU	0	0
44	BANKNAME	☐	OFX_BANKNAME	CHAR32	CHAR	32	0	OFX: Bank Name (for CHE, DEU, ITA)
45	BANKBRANCH	☐	OFX_BANKBRANCH	CHAR32	CHAR	32	0	OFX: Bank Branch
46	BANKCITY	☐	OFX_BANKCITY	CHAR32	CHAR	32	0	OFX: City in Which the Bank Branch is Located
47	BANKPOSTALCODE	☐	OFX_BANKPOSTALCODE	CHAR11	CHAR	11	0	OFX: Bank Postal Code
48	CHEPTTACCTID	☐	OFX_CHEPTTACCTID	CHAR9	CHAR	9	0	OFX: Account Number for Indirect Payments (CHE only)
49	CCACCTTO	☐	OFX_CCACCTFROM		STRU	0	0
50	ACCTID	☐	OFX_ACCTID	CHAR22	CHAR	22	0	Account Number
51	ACCTKEY	☐	OFX_ACCTKEY	CHAR22	CHAR	22	0	Control Total for International Banks
52	MEMO	☐	OFX_MEMO	CHAR255	CHAR	255	0	Additional Information
53	MEMO2	☐	OFX_MEMO2	CHAR390	CHAR	390	0	Additional Information
54	CURRENCY	☐	OFX_CURRENCY		STRU	0	0
55	CURRATE	☐	OFX_CURRATE	OFX_AMOUNT	CHAR	32	0	Exchange Rate Between CURDEF Currency and CURSYM Currency
56	CURSYM	☐	OFX_CURSYM	OFX_CURRSYMBOL	CHAR	3	0	Currency (3-Letter Code from ISO-4217)
57	ORIGCURRENCY	☐	OFX_CURRENCY		STRU	0	0
58	CURRATE	☐	OFX_CURRATE	OFX_AMOUNT	CHAR	32	0	Exchange Rate Between CURDEF Currency and CURSYM Currency
59	CURSYM	☐	OFX_CURSYM	OFX_CURRSYMBOL	CHAR	3	0	Currency (3-Letter Code from ISO-4217)

History

Last changed by/on	SAP	20001204
SAP Release Created in