SAP ABAP Table OFX_STMTTRN_1 (Transaction for Account Statement (V1))

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_1	Table Relationship Diagram
Short Description	Transaction for Account Statement (V1)

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	CHECKNUM	☐	OFX_CHECKNUM	CHAR12	CHAR	12	0	Check Number
11	REFNUM	☐	OFX_REFNUM	CHAR32	CHAR	32	0	Unique Reference Number of Transaction
12	SIC	☐	OFX_SIC	NUM6	NUMC	6	0	Standard Industry Code
13	PAYEEID	☐	OFX_PAYEEID	CHAR12	CHAR	12	0	Receiver's Identification
14	NAME	☐	OFX_NAME	CHAR32	CHAR	32	0	Name of Recipient or of Transaction
15	PAYEE	☐	OFX_PAYEE		STRU	0	0
16	NAME	☐	OFX_NAME	CHAR32	CHAR	32	0	Name of Recipient or of Transaction
17	ADDR1	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
18	ADDR2	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
19	ADDR3	☐	OFX_ADDR	CHAR32	CHAR	32	0	Address Line
20	CITY	☐	OFX_CITY	CHAR32	CHAR	32	0	City
21	STATE	☐	OFX_STATE	CHAR5	CHAR	5	0	State
22	POSTALCODE	☐	OFX_POSTALCODE	CHAR11	CHAR	11	0	Postal Code
23	COUNTRY	☐	OFX_COUNTRY	CHAR3	CHAR	3	0	Country (3 Character Code from ISO/DIS-3166)
24	PHONE	☐	OFX_PHONE	CHAR32	CHAR	32	0	Telephone Number
25	BANKACCTTO	☐	OFX_BANKACCTTO1		STRU	0	0
26	BANKID	☐	OFX_BANKID	CHAR9	CHAR	9	0	Bank ID for Routing and Transit
27	BRANCHID	☐	OFX_BRANCHID	CHAR22	CHAR	22	0	Bank ID for International Banks
28	ACCTID	☐	OFX_ACCTID	CHAR22	CHAR	22	0	Account Number
29	ACCTTYPE	☐	OFX_ACCTTYPE	OFX_ACCTTYPE	CHAR	10	0	Account Type
30	ACCTKEY	☐	OFX_ACCTKEY	CHAR22	CHAR	22	0	Control Total for International Banks
31	CCACCTTO	☐	OFX_CCACCTFROM		STRU	0	0
32	ACCTID	☐	OFX_ACCTID	CHAR22	CHAR	22	0	Account Number
33	ACCTKEY	☐	OFX_ACCTKEY	CHAR22	CHAR	22	0	Control Total for International Banks
34	MEMO	☐	OFX_MEMO	CHAR255	CHAR	255	0	Additional Information
35	CURRENCY	☐	OFX_CURRENCY		STRU	0	0
36	CURRATE	☐	OFX_CURRATE	OFX_AMOUNT	CHAR	32	0	Exchange Rate Between CURDEF Currency and CURSYM Currency
37	CURSYM	☐	OFX_CURSYM	OFX_CURRSYMBOL	CHAR	3	0	Currency (3-Letter Code from ISO-4217)
38	ORIGCURRENCY	☐	OFX_CURRENCY		STRU	0	0
39	CURRATE	☐	OFX_CURRATE	OFX_AMOUNT	CHAR	32	0	Exchange Rate Between CURDEF Currency and CURSYM Currency
40	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