	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

176 COLUMNS | 1 INDEXES | ERP 6.0 | OTC_CONV_FHAPO TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	OTC_CONV_FHAPO	176	1	Backup Table for Financial Transaction Flows	Transaction Manager

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BUKRS, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB, CRUSER, UPUSER, DUPDAT, TUPTIM, RANTYP, SFHAZBA, SBKKLAS, SBKTYP, SBERFIMA, SSIGN, SHERKUNFT, SABVERF, RKONDGR, RKOND, DGUEL_KP, NSTUFE, SKOART, RREFKONT, SBZVABW, RAHABKI, RAHKTID, RPZAHL, RPBANK, SZART, ZLSCH, UZAWE, SPAYRQ, SPRSNG, SPRGRD, SCSPAY, ZWELS, PAYGR, SBEWEBE, SSPRGRD, SBFREI, SSTORNOBWG, PRKEY, BELNR, BELNR2, GJAHR, DBUCHUNG, DFAELL, DZTERM, BZBETR, WZBETR, BHWBETR, KHWKURS, ASTUECK, BPRICE, WPRICE, BHWPREIS, BINDEX, VVBASIS, PWKURS, PRKKURS, BNWHR, RHANDPL, SKURSART, DBERVON, DBERBIS, ATAGE, ABASTAGE, PKOND, DPKOND, DZFEST, SZBMETH, SKALIDWT, BBASIS, WBASIS, JEXPOZINS, SINCL, SINCLBIS, SULTBIS, SEXCLVON, SULTVON, SAEND, DVALUT, SVINCL, SVULT, JSOFVERR, DVERRECH, SINCLVERR, SULTVERR, SSTORNOMAN, SSTORNOART, SBWGARTREF, SKHWFIX, ZUONR, RLDEPO, RANL, RTRBELNR, BUPRC, BPPRC, WBBETR, BBBETR, WEBETR, BEBETR, SRUNIT, KZWKURS, KBWKURS, WSBETR, DBESTAND, SSTCKKZ, SSTCKTG, SFLAT, SCOUPON, DCOUPON, AWKEY, INDEX_VALUE, SBASIS, REGI_STATE, RPCODE, RP_TEXT, HEDGE_ID, DBPERIOD, SPAEXCL, SPAULT, DEPERIOD, SPEINCL, SPEULT, AMMRHY, PPAYMENT, AMMRHYZV, LZBKZ, LANDL, BDIRTY, BAMOUNTCOMP, NOMINAL_ORG_AMT, NOM_FACTOR, RLDEPO2, INDEX_PRICE, FLOWUUID, FLAGBYTE1, QUANTITY, UNIT_OF_MEASURE, CONTRACT_PRICE, SPOT_PRICE, CONTANGO_BACKWRD, BPRC_SPOT1, BPRC_SPOT2, COST_FWD, INTEREST_FWD, REF_FLOWUUID, RGATT, COMMODITY_ID, QUOTATION_NAME, QUOTATION_SOURCE, QUOTATION_TYPE, SPREAD, PRICE_CURR_UNIT, PRICE_UOM, DIV_PCTC_OTC, TAINTED, CLEARED, DCSID, MIC, PRICE_TYPE, TIME_TO_MATURITY, TIMING, EXCH_RATE_TYPE, PRICE_PAYM_CURR, SPREAD_PAYM_CURR, FX_TRANSLATION, MNDID, IDCFM_USHA_TYPE, IDCFM_USHA_PERC, IDCFM_USHA_TOTA, IDCFM_USHA_CURR, IDCFM_USHA_FORM FROM OTC_CONV_FHAPO

TOP ERP 6.0 | OTC_CONV_FHAPO COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	RFHA	Financial Transaction	nvarchar	13	0	CHAR	(N' ')	No	VTBFHA	TB_RFHA	Allow NULL?
4	RFHAZU	Transaction activity	nvarchar	5	0	NUMC	(N'00000')	No		TB_RFHAZU	Allow NULL?
5	DCRDAT	Entered On	nvarchar	8	0	DATS	(N'00000000')	No		TB_CRDAT	Allow NULL?
6	TCRTIM	Entry Time	nvarchar	6	0	TIMS	(N'000000')	No		TB_TCRTIM	Allow NULL?
7	RFHAZB	Transaction flow	nvarchar	4	0	NUMC	(N'0000')	No		TB_RFHAZB	Allow NULL?
8	CRUSER	Entered by	nvarchar	12	0	CHAR	(N' ')	Yes		TB_CRUSER	Allow NULL?
9	UPUSER	Last Changed by	nvarchar	12	0	CHAR	(N' ')	Yes		TB_UPUSER	Allow NULL?
10	DUPDAT	Changed on	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DUPDAT	Allow NULL?
11	TUPTIM	Time changed	nvarchar	6	0	TIMS	(N'000000')	Yes		TB_TUPTIM	Allow NULL?
12	RANTYP	Contract Type	char	1	0	CHAR	(N' ')	Yes		RANTYP	Allow NULL?
13	SFHAZBA	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	TZB0A	TB_SFHAZBA	Allow NULL?
14	SBKKLAS	Classification of flows and conditions	char	1	0	CHAR	(N' ')	Yes		TB_SBKKLAS	Allow NULL?
15	SBKTYP	Category of Flows and Conditions	nvarchar	2	0	CHAR	(N' ')	Yes	AT07	TB_SBKTYP	Allow NULL?
16	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	CHAR	(N' ')	Yes	AT40	SBEWFIMA	Allow NULL?
17	SSIGN	Direction of flow	char	1	0	CHAR	(N' ')	Yes		TB_SSIGN	Allow NULL?
18	SHERKUNFT	Display Area of Flow or Condition	nvarchar	4	0	CHAR	(N' ')	Yes		TB_SHERK	Allow NULL?
19	SABVERF	Procedure to Generate Derived Flows	nvarchar	5	0	CHAR	(N' ')	Yes	AT22	TB_SABVERF	Allow NULL?
20	RKONDGR	Direction of Transaction	char	1	0	NUMC	(N'0')	Yes		TB_RKONDGR	Allow NULL?
21	RKOND	Condition	nvarchar	4	0	NUMC	(N'0000')	Yes		TB_KOND	Allow NULL?
22	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	DATS	(N'00000000')	Yes		DGUEL_KP	Allow NULL?
23	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	NUMC	(N'00')	Yes		NSTUFE	Allow NULL?
24	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	NUMC	(N'0000')	Yes	TZK01	SKOART	Allow NULL?
25	RREFKONT	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	nvarchar	8	0	CHAR	(N' ')	Yes	T037S	RREFKONT_OBSOLETE	Allow NULL?
26	SBZVABW	Alternative payment details stated in flow	char	1	0	CHAR	(N' ')	Yes		TB_SBZVABW	Allow NULL?
27	RAHABKI	Short key for own house bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	TB_RHABKI	Allow NULL?
28	RAHKTID	Short key for house bank account	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	TB_RHKTID	Allow NULL?
29	RPZAHL	Payer/payee	nvarchar	10	0	CHAR	(N' ')	Yes	*	TB_RPZAHL_NEW	Allow NULL?
30	RPBANK	Partner bank details	nvarchar	4	0	CHAR	(N' ')	Yes		TB_RPBANK	Allow NULL?
31	SZART	Payment transaction	char	1	0	CHAR	(N' ')	Yes		TB_SZART	Allow NULL?
32	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	DZLSCH	Allow NULL?
33	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	T042F	UZAWE	Allow NULL?
34	SPAYRQ	Generate payment request	char	1	0	CHAR	(N' ')	Yes		TB_SPAYRQK	Allow NULL?
35	SPRSNG	Individual payment	char	1	0	CHAR	(N' ')	Yes		TB_SPRSNGK	Allow NULL?
36	SPRGRD	Determine grouping definition	char	1	0	CHAR	(N' ')	Yes		TB_SPRGRD	Allow NULL?
37	SCSPAY	Same direction necessary for joint payment?	char	1	0	CHAR	(N' ')	Yes		TB_SCSPAY	Allow NULL?
38	ZWELS	List of the Payment Methods to be Considered	nvarchar	10	0	CHAR	(N' ')	Yes		DZWELS	Allow NULL?
39	PAYGR	Grouping Field for Automatic Payments	nvarchar	20	0	CHAR	(N' ')	Yes		PAYGR	Allow NULL?
40	SBEWEBE	Posting Status of Flow	char	1	0	CHAR	(N' ')	Yes		TB_SBEWEBE	Allow NULL?
41	SSPRGRD	Reason Why Flow Is Blocked for Posting	char	1	0	NUMC	(N'0')	Yes		TB_SSPRGRD	Allow NULL?
42	SBFREI	Release Given for Flow to Be Posted?	char	1	0	CHAR	(N' ')	Yes		TB_SBFREI	Allow NULL?
43	SSTORNOBWG	Flow reversal in Treasury	char	1	0	CHAR	(N' ')	Yes		TB_SBWGSTO	Allow NULL?
44	PRKEY	Key Number for Payment Request	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRQ_KEYNO	Allow NULL?
45	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
46	BELNR2	Doc. no. of a second accounting doc. for currency swap	nvarchar	10	0	CHAR	(N' ')	Yes		TB_BELNR2	Allow NULL?
47	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
48	DBUCHUNG	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
49	DFAELL	Due date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DFAELL	Allow NULL?
50	DZTERM	Payment or Delivery Date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DZTERM	Allow NULL?
51	BZBETR	Payment amount in payment currency	decimal	13	2	CURR	((0))	Yes		TB_BZBETR
52	WZBETR	Payment Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TB_WZBETR	Allow NULL?
53	BHWBETR	Payment Amount in Local Currency	decimal	13	2	CURR	((0))	Yes		TB_HWBETR
54	KHWKURS	Local currency rate	decimal	9	5	DEC	((0))	Yes		TB_KHWKURS
55	ASTUECK	No. of Units for Financial Instruments	decimal	15	5	DEC	((0))	Yes		TB_ASTUECK
56	BPRICE	Price per unit	decimal	13	2	CURR	((0))	Yes		TB_BPRICE
57	WPRICE	Price currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TB_WPRICE	Allow NULL?
58	BHWPREIS	Price in local currency	decimal	13	2	CURR	((0))	Yes		TB_HWPREIS
59	BINDEX	Value of a point	decimal	13	2	CURR	((0))	Yes		TB_BINDEX
60	VVBASIS	Price in points	decimal	11	6	DEC	((0))	Yes		TB_VVBASIS
61	PWKURS	Price as percentage quotation	decimal	10	7	DEC	((0))	Yes		TB_PWKURS
62	PRKKURS	Currency option premium with price in points	decimal	13	9	DEC	((0))	Yes		TI_PRKUR
63	BNWHR	Nominal amount	decimal	13	2	CURR	((0))	Yes		TB_BNWHR
64	RHANDPL	Exchange	nvarchar	10	0	CHAR	(N' ')	Yes	TWH01	VVRHANDPL	Allow NULL?
65	SKURSART	Rate/Price Type - Treasury Instruments	nvarchar	2	0	CHAR	(N' ')	Yes	TW56	TI_KURSART	Allow NULL?
66	DBERVON	Start of Calculation Period	nvarchar	8	0	DATS	(N'00000000')	Yes		DBERVON	Allow NULL?
67	DBERBIS	End of Calculation Period	nvarchar	8	0	DATS	(N'00000000')	Yes		DBERBIS	Allow NULL?
68	ATAGE	Number of days	nvarchar	6	0	NUMC	(N'000000')	Yes		VVATAGE	Allow NULL?
69	ABASTAGE	Number of base days in a calculation period	nvarchar	6	0	NUMC	(N'000000')	Yes		ABASTAGE	Allow NULL?
70	PKOND	Percentage rate for condition items	decimal	10	7	DEC	((0))	Yes		PKOND
71	DPKOND	Determination date for percentage rate of condition items	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDPKOND	Allow NULL?
72	DZFEST	Interest rate fixing date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DZFEST	Allow NULL?
73	SZBMETH	Interest Calculation Method	char	1	0	CHAR	(N' ')	Yes		SZBMETH	Allow NULL?
74	SKALIDWT	Interest Calendar	nvarchar	2	0	CHAR	(N' ')	Yes	*	TFMSKALIDWT	Allow NULL?
75	BBASIS	Calculation base amount	decimal	13	2	CURR	((0))	Yes		BBASIS
76	WBASIS	Currency of calculation basis	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TB_WBASIS	Allow NULL?
77	JEXPOZINS	Exponential Interest Calculation	char	1	0	CHAR	(N' ')	Yes		TB_JZINSRE	Allow NULL?
78	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	NUMC	(N'0')	Yes		VVSINCL	Allow NULL?
79	SINCLBIS	Inclusive Indicator for the End of a Calculation Period	char	1	0	NUMC	(N'0')	Yes		VVSINCLBIS	Allow NULL?
80	SULTBIS	Month-End Indicator for the End of a Calculation Period	char	1	0	CHAR	(N' ')	Yes		VVSULTBIS	Allow NULL?
81	SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	char	1	0	NUMC	(N'0')	Yes		VVSEXCLVON	Allow NULL?
82	SULTVON	Month-End Indicator for Start of a Calculation Period	char	1	0	CHAR	(N' ')	Yes		VVSULTVON	Allow NULL?
83	SAEND	Change Indicator for FiMa Flow Records	char	1	0	NUMC	(N'0')	Yes		TFM_SAEND	Allow NULL?
84	DVALUT	Calculation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DVALUT	Allow NULL?
85	SVINCL	Inclusive indicator for value date	char	1	0	NUMC	(N'0')	Yes		VVSVINCL	Allow NULL?
86	SVULT	Month-End Indicator for Value Date	char	1	0	CHAR	(N' ')	Yes		VVSVULT	Allow NULL?
87	JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)	char	1	0	CHAR	(N' ')	Yes		TFMSOFVERR	Allow NULL?
88	DVERRECH	Settlement date	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDVERRECH	Allow NULL?
89	SINCLVERR	Inclusive Indicator for Clearing Date	char	1	0	NUMC	(N'0')	Yes		VVSINCLVER	Allow NULL?
90	SULTVERR	Month-End Indicator for Clearing Date	char	1	0	CHAR	(N' ')	Yes		VVSULTVERR	Allow NULL?
91	SSTORNOMAN	Manual reversal of flows posted in FI	char	1	0	CHAR	(N' ')	Yes		TB_SBWGSTM	Allow NULL?
92	SSTORNOART	Type of manual reversal of flows posted in FI	nvarchar	2	0	CHAR	(N' ')	Yes	AT90	TB_SSTOART	Allow NULL?
93	SBWGARTREF	Referenced flow type	nvarchar	4	0	CHAR	(N' ')	Yes	TZB0A	TB_SBWGREF	Allow NULL?
94	SKHWFIX	Indicator for translation into local currency	char	1	0	CHAR	(N' ')	Yes		TB_SKHWFIX	Allow NULL?
95	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
96	RLDEPO	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	RLDEPO	Allow NULL?
97	RANL	Security ID Number	nvarchar	13	0	CHAR	(N' ')	Yes	*	VVRANLW	Allow NULL?
98	RTRBELNR	Internal document number of derivatives document	nvarchar	15	0	CHAR	(N' ')	Yes		TPM_DEDOC_RDOCNRINT	Allow NULL?
99	BUPRC	Security Price Without Currency Ref. with Unit Quotation	decimal	15	6	DEC	((0))	Yes		TB_BUPRC
100	BPPRC	Security Price for Percentage Quotation	decimal	15	6	DEC	((0))	Yes		TB_BPPRC
101	WBBETR	Currency of Position Amount	nvarchar	5	0	CUKY	(N' ')	Yes	*	TB_WBBETR	Allow NULL?
102	BBBETR	Amount that Changes the Position	decimal	13	2	CURR	((0))	Yes		TB_BBBETR
103	WEBETR	Price currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TB_WEBETR	Allow NULL?
104	BEBETR	Market Value in Quotation Currency	decimal	13	2	CURR	((0))	Yes		TB_BEBETR
105	SRUNIT	Currency Unit of the Rate	nvarchar	5	0	CHAR	(N' ')	Yes	TZUNI	TB_RUNIT	Allow NULL?
106	KZWKURS	Payment currency rate	decimal	9	5	DEC	((0))	Yes		TB_KZWKURS
107	KBWKURS	Position currency rate	decimal	9	5	DEC	((0))	Yes		TB_KBWKURS
108	WSBETR	Currency Key for Currency Conversion: Source Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TB_WFROM	Allow NULL?
109	DBESTAND	Position Value Date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DBESTAND	Allow NULL?
110	SSTCKKZ	Accrued interest method	char	1	0	CHAR	(N' ')	Yes		SSTCKKZ	Allow NULL?
111	SSTCKTG	Accrued interest: Daily method	char	1	0	CHAR	(N' ')	Yes		SSTCKTG	Allow NULL?
112	SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation	char	1	0	CHAR	(N' ')	Yes		VVSFLAT	Allow NULL?
113	SCOUPON	Coupon ID for interest and accrued interest calculation	char	1	0	CHAR	(N' ')	Yes		VVSCOUPON	Allow NULL?
114	DCOUPON	Coupon date of next delivered coupon	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDCOUPON	Allow NULL?
115	AWKEY	Reference Key	nvarchar	20	0	CHAR	(N' ')	Yes		AWKEY	Allow NULL?
116	INDEX_VALUE	Index Value (Independent of Basis)	decimal	18	12	DEC	((0))	Yes		TIDX_INDEX_VALUE_NO_RATIO
117	SBASIS	Calculation base indicator	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBASIS	Allow NULL?
118	REGI_STATE	Status of Interest Rate Adjustment	nvarchar	2	0	CHAR	(N' ')	Yes		TB_IRA_REGISTRATION_STATE	Allow NULL?
119	RPCODE	Repetitive Code	nvarchar	20	0	CHAR	(N' ')	Yes	*	RPCODE	Allow NULL?
120	RP_TEXT	Reference Text for Repetitive Code	nvarchar	50	0	CHAR	(N' ')	Yes		RPCODE_TEXT	Allow NULL?
121	HEDGE_ID	Identification for Hedging Relationship	nvarchar	10	0	CHAR	(N' ')	Yes		TPM_HEDGE_ID	Allow NULL?
122	DBPERIOD	Period start	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDBPERIOD	Allow NULL?
123	SPAEXCL	Exclusive Indicator for Start Date of a Period	char	1	0	NUMC	(N'0')	Yes		TFMSPAEXCL	Allow NULL?
124	SPAULT	Month-End Indicator for Start Date of a Period	char	1	0	CHAR	(N' ')	Yes		TFMSPAULT	Allow NULL?
125	DEPERIOD	Period End	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDEPERIOD	Allow NULL?
126	SPEINCL	Inclusive Indicator for End Date of a Period	char	1	0	NUMC	(N'0')	Yes		TFMSPEINCL	Allow NULL?
127	SPEULT	Month-End Indicator for End of a Period	char	1	0	CHAR	(N' ')	Yes		TFMSPEULT	Allow NULL?
128	AMMRHY	Frequency in months	nvarchar	3	0	NUMC	(N'000')	Yes		AMMRHY	Allow NULL?
129	PPAYMENT	Payment Rate	decimal	11	7	DEC	((0))	Yes		TFM_PPAYMENT
130	AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	nvarchar	2	0	NUMC	(N'00')	Yes		TFM_AMMRHYZV	Allow NULL?
131	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
132	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
133	BDIRTY	Dirty Price	decimal	13	2	CURR	((0))	Yes		TB_BDIRTY
134	BAMOUNTCOMP	Amount to be Capitalized	decimal	13	2	CURR	((0))	Yes		TB_AMOUNTCOMP
135	NOMINAL_ORG_AMT	Orignal Nominal Amount	decimal	13	2	CURR	((0))	Yes		TB_BNWHR_ORG
136	NOM_FACTOR	Factor	decimal	12	9	DEC	((0))	Yes		RDPT_FACTOR_VAL
137	RLDEPO2	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	VRLDEPO	Allow NULL?
138	INDEX_PRICE	Indicator: Security Price Including Price Index Value	char	1	0	CHAR	(N' ')	Yes		TB_INDEX_PRICE	Allow NULL?
139	FLOWUUID	Transaction Flow UUID	varbinary	16	0	RAW		Yes		TB_FLOWUUID
140	FLAGBYTE1	Indicator for Financial Transaction Flow (See Documentation)	varbinary	1	0	RAW		Yes		TB_FLAGBYTE1
141	QUANTITY	Quantity	decimal	13	3	QUAN	((0))	Yes		FTR_QUAN
142	UNIT_OF_MEASURE	Unit of Measure for the Commodity	nvarchar	3	0	UNIT	(N' ')	Yes	*	TPM_CTY_UOM	Allow NULL?
143	CONTRACT_PRICE	Commodity Price	decimal	13	5	DEC	((0))	Yes		FTR_COMPRICE
144	SPOT_PRICE	Commodity Spot Price	decimal	13	5	DEC	((0))	Yes		FTR_COMSPOT
145	CONTANGO_BACKWRD	Commodity Contango / Backwardation	decimal	13	5	DEC	((0))	Yes		FTR_CONBACK
146	BPRC_SPOT1	Current Spot Rate in Percentage	decimal	15	6	DEC	((0))	Yes		TB_BPPRC_SPOT1
147	BPRC_SPOT2	Spot Rate at Maturity in Percentage	decimal	15	6	DEC	((0))	Yes		TB_BPPRC_SPOT_MAT
148	COST_FWD	Forward Rate Cost	decimal	15	6	DEC	((0))	Yes		TB_COSTFWD
149	INTEREST_FWD	Forward Rate Interest	decimal	15	6	DEC	((0))	Yes		TB_INTERESTFWD
150	REF_FLOWUUID	Flow Reference (UUID)	varbinary	16	0	RAW		Yes		TB_REFFLOWUUID
151	RGATT	Class	nvarchar	13	0	CHAR	(N' ')	Yes		TI_RGATT	Allow NULL?
152	COMMODITY_ID	Commodity ID	nvarchar	18	0	CHAR	(N' ')	Yes		TRCO_COMM_ID	Allow NULL?
153	QUOTATION_NAME	Quotation Name	nvarchar	18	0	CHAR	(N' ')	Yes		CPET_QUOTNAME	Allow NULL?
154	QUOTATION_SOURCE	Quotation Source	nvarchar	2	0	CHAR	(N' ')	Yes	TRCOCC_QUOTSRC	TCR_CTY_QUOTSRC	Allow NULL?
155	QUOTATION_TYPE	Commodity Quotation Type	nvarchar	5	0	CHAR	(N' ')	Yes	TRCOCC_QUOTTYPE	TCR_CTY_QUOTTYPE	Allow NULL?
156	SPREAD	Commodity Spread	decimal	13	5	DEC	((0))	Yes		FTR_COMSPREAD
157	PRICE_CURR_UNIT	Currency Unit of the Rate	nvarchar	5	0	CHAR	(N' ')	Yes	TZUNI	TB_RUNIT	Allow NULL?
158	PRICE_UOM	Unit of Measure for the Commodity	nvarchar	3	0	UNIT	(N' ')	Yes	*	TPM_CTY_UOM	Allow NULL?
159	DIV_PCTC_OTC	Percentage of Dividend agreed for Payment in OTC Instruments	decimal	7	4	DEC	((0))	Yes		TB_DIV_PCTC_OTC
160	TAINTED	Manipulated Cash Flow	char	1	0	CHAR	(N' ')	Yes		TB_TAINTED_CASHFLOW	Allow NULL?
161	CLEARED	Clearing at Flow Level	char	1	0	CHAR	(N' ')	Yes		FTR_FLOW_CLEARED	Allow NULL?
162	DCSID	Derivative Contract Specification ID	nvarchar	6	0	CHAR	(N' ')	Yes	*	TBA_DCSID	Allow NULL?
163	MIC	Market Identifier Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	TBA_MIC	Allow NULL?
164	PRICE_TYPE	Type of Price Quotation	nvarchar	2	0	CHAR	(N' ')	Yes	*	TBA_PRICETYPE	Allow NULL?
165	TIME_TO_MATURITY	Time to Maturity	nvarchar	10	0	CHAR	(N' ')	Yes	*	TBA_TENOR	Allow NULL?
166	TIMING	Timing/Periodicity of Commodity Forward Indexes	nvarchar	2	0	NUMC	(N'00')	Yes		TBA_TIMING	Allow NULL?
167	EXCH_RATE_TYPE	Exchange Rate Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	KURST_CURR	Allow NULL?
168	PRICE_PAYM_CURR	Commodity Price in Payment Currency	decimal	13	5	DEC	((0))	Yes		FTR_COMPRICE_PAYMENT_CURR
169	SPREAD_PAYM_CURR	Commodity Spread in Payment Currency	decimal	13	5	DEC	((0))	Yes		FTR_COMSPREAD_PAYMENT_CURR
170	FX_TRANSLATION	Defines when quotation crcy is converted into payment crcy	char	1	0	CHAR	(N' ')	Yes		FTR_CURRENCY_CONV_POINT_IN_TIM	Allow NULL?
171	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
172	IDCFM_USHA_TYPE	Haircut Rate Type	char	1	0	CHAR	(N' ')	Yes		IDCFM_USHA_DEL_TYPE	Allow NULL?
173	IDCFM_USHA_PERC	Percentage Value	decimal	10	7	DEC	((0))	Yes		IDCFM_USHA_DEL_PERC
174	IDCFM_USHA_TOTA	Enter Haircut Amount in PC	decimal	13	2	CURR	((0))	Yes		IDCFM_USHA_DEL_TOTA
175	IDCFM_USHA_CURR	Currency of Haircut Amount	nvarchar	5	0	CUKY	(N' ')	Yes	*	IDCFM_USHA_DEL_CURR	Allow NULL?
176	IDCFM_USHA_FORM	European Formula Calculation	char	1	0	CHAR	(N' ')	Yes		IDCFM_USHA_DEL_FORM	Allow NULL?

TOP ERP 6.0 | OTC_CONV_FHAPO INDEXES

Name	Primary	Unique	Type	Columns
OTC_CONV_FHAPO~0	Yes	Yes	CLUSTERED	RFHAZB, TCRTIM, DCRDAT, RFHAZU, RFHA, BUKRS, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

176 COLUMNS | 1 INDEXES | ERP 6.0 | OTC_CONV_FHAPO TABLE

TOP ERP 6.0 | OTC_CONV_FHAPO COLUMNS

TOP ERP 6.0 | OTC_CONV_FHAPO INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

176 COLUMNS | 1 INDEXES | ERP 6.0 | OTC_CONV_FHAPO TABLE

TOPERP 6.0 | OTC_CONV_FHAPO COLUMNS

TOPERP 6.0 | OTC_CONV_FHAPO INDEXES

TOP ERP 6.0 | OTC_CONV_FHAPO COLUMNS

TOP ERP 6.0 | OTC_CONV_FHAPO INDEXES