ERP 6.0: Top 10 requests

	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	BSEG	345	Accounting Document Segment
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	TCORT_CO	84	10	Correspondence Administrative Data	Transaction Manager

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	CO_UUID	Correspondence Object UUID	varbinary	16
3	CO_KEY	Semantic key for Corr	nvarchar	16	Allow NULL?
4	CODMD_UUID	Correspondence Object Deal's main data UUID	varbinary	16
5	COSA_UUID	CO: Securities account main data id	varbinary	16
6	COMPANY_CODE	Company Code	nvarchar	4	Allow NULL?
7	DEALNUMBER	Financial Transaction	nvarchar	13	Allow NULL?
8	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16
9	BUSTRANSCAT	Business Transaction Category	nvarchar	4	Allow NULL?
10	SEC_ACC	Securities Account	nvarchar	10	Allow NULL?
11	SECURITYID	Security ID Number	nvarchar	13	Allow NULL?
12	PRODUCTTYPE	Product Type	nvarchar	3	Allow NULL?
13	TRANSACTIONTYPE	Financial Transaction Type	nvarchar	3	Allow NULL?
14	ACTIVITY	Transaction activity	nvarchar	5	Allow NULL?
15	ACTIVITYCAT	Transaction Activity Category	nvarchar	2	Allow NULL?
16	SFUNKTL	Latest function used in editing activity	nvarchar	4	Allow NULL?
17	PARTNR	Business Partner Number	nvarchar	10	Allow NULL?
18	BPGROUP	Business Partner Group ID	nvarchar	15	Allow NULL?
19	PROFILE	Correspondence Profile	nvarchar	15	Allow NULL?
20	RECIPIENT_TYPE	Recipient/Sender Type	nvarchar	15	Allow NULL?
21	RECIPIENT	Correspondence Recipient	nvarchar	10	Allow NULL?
22	FUNCTION	Correspondence Class	nvarchar	15	Allow NULL?
23	CHANNEL	Correspondence Channel	nvarchar	15	Allow NULL?
24	MESSAGE_FORMAT	Format	nvarchar	15	Allow NULL?
25	DIRECTION	Direction of correspondence	char	1	Allow NULL?
26	OPERATION	Operation causing the creation of CO	nvarchar	4	Allow NULL?
27	REF_CO_KEY	Reference CO key	nvarchar	16	Allow NULL?
28	STATUS_GUID	TCO Status Object Id	varbinary	16
29	IS_AUTO_CORR	Auto Correspondence Required?	char	1	Allow NULL?
30	IS_REL_REQD	Release Required?	char	1	Allow NULL?
31	IS_STATUS_REL	Deal Status Relevant?	char	1	Allow NULL?
32	IS_CTRCONF_REQD	Counter Confirmation Required?	char	1	Allow NULL?
33	IS_AUTO_COMPLETE	Automatic completion required?	char	1	Allow NULL?
34	IS_UPD_EXT_REF	Get values from counterconfirmation	char	1	Allow NULL?
35	IS_MANUAL	'Is CO manually created' indicator	char	1	Allow NULL?
36	IS_ACK_REL	Indicator: Is Acknowledgement Relevant?	char	1	Allow NULL?
37	IS_RESENT	Flag: Is CO resent	char	1	Allow NULL?
38	RECONCILE	Reconcile	char	1	Allow NULL?
39	SET_DELIVERY	Physical Delivery	char	1	Allow NULL?
40	CRUSER	Entered by	nvarchar	12	Allow NULL?
41	DCRDAT	Entered On	nvarchar	8	Allow NULL?
42	TCRTIM	Entry Time	nvarchar	6	Allow NULL?
43	UPUSER	Last Changed by	nvarchar	12	Allow NULL?
44	DUPDAT	Changed on	nvarchar	8	Allow NULL?
45	TUPTIM	Time changed	nvarchar	6	Allow NULL?
46	EXEC_DATE	Outgoing Correspondence Execution Date	nvarchar	8	Allow NULL?
47	EXEC_TIME	Outgoing Correspondence Execution Time	nvarchar	6	Allow NULL?
48	EXEC_USER	Outgoing Correspondence Executed by User	nvarchar	12	Allow NULL?
49	DELV_DATE	Outgoing correspondence delivery date	nvarchar	8	Allow NULL?
50	DELV_TIME	Outgoing correspondence delivery time	nvarchar	6	Allow NULL?
51	DELV_USER	Outgoing correspondence delivered by user	nvarchar	12	Allow NULL?
52	RECON_DATE	Outgoing correspondence counter-confirmed date	nvarchar	8	Allow NULL?
53	RECON_TIME	Outgoing correspondence counter-confirmed time	nvarchar	6	Allow NULL?
54	RECON_USER	Outgoing correspondence counter-confirmed by user	nvarchar	12	Allow NULL?
55	MTCH_DATE	Correspondence object matched date	nvarchar	8	Allow NULL?
56	MTCH_TIME	Correspondence object matched time	nvarchar	6	Allow NULL?
57	MTCH_USER	Correspondence object matched by user	nvarchar	12	Allow NULL?
58	RECV_DATE	Correspondence object received date	nvarchar	8	Allow NULL?
59	RECV_TIME	Correspondence Object Receipt Time	nvarchar	6	Allow NULL?
60	RECV_USER	Correspondence object received by user	nvarchar	12	Allow NULL?
61	MATCH_ID	TCOR: Match Id (Number range: FTRN_MATCH)	nvarchar	16	Allow NULL?
62	CO_INT_REF	Correspondence internal reference	nvarchar	16	Allow NULL?
63	CO_EXT_REF	Correspondence external reference	nvarchar	16	Allow NULL?
64	IS_COMPLETE	Is Correspondence Object complete	char	1	Allow NULL?
65	IS_MANUAL_CHNG	Is CO manually changed	char	1	Allow NULL?
66	MSG_STATUS	Message status (Filled by customer)	nvarchar	16	Allow NULL?
67	MSG_REASON	Reason for message status (Filled by customer)	nvarchar	16	Allow NULL?
68	ERROR_CODE	Error code	nvarchar	3	Allow NULL?
69	ERROR_TEXT	Error text	nvarchar	30	Allow NULL?
70	ERROR_LINE	Error line number	nvarchar	3	Allow NULL?
71	CORR_COUNTRY	Country Key	nvarchar	3	Allow NULL?
72	CORR_LANGUAGE	Language Key	char	1	Allow NULL?
73	CORPACT_IND	Corporate action event indicator	nvarchar	4	Allow NULL?
74	ADR_COUNTRY	Country Key	nvarchar	3	Allow NULL?
75	FAX_NO	Business partner fax number	nvarchar	31	Allow NULL?
76	EMAIL_ADD	E-Mail Address	nvarchar	241	Allow NULL?
77	SENT_FOR_MATCH	Indicator : Is Correspondence Sent For Match?	char	1	Allow NULL?
78	LOG_HANDLE	Application Log: Log Handle	nvarchar	22	Allow NULL?
79	CORR_ADDTYPE	Alternative Address for Correspondence	nvarchar	10	Allow NULL?
80	SAP_USER	User Name in User Master Record	nvarchar	12	Allow NULL?
81	IS_AUTOMATCH_OUT	Auto. Matching Triggered on Delivery of Outbound Corresp.	char	1	Allow NULL?
82	IS_DEAL_REL_REQ	Do Not Send Before Deal Release	char	1	Allow NULL?
83	IS_CTRCNF_MAN	Is correspondence counterconfirmed manually?	char	1	Allow NULL?
84	ASSIGN_REASON	Reason for Assignment	nvarchar	2	Allow NULL?

Name	Primary	Unique	Type	Columns
TCORT_CO~0	Yes	Yes	CLUSTERED	CO_UUID, MANDT
TCORT_CO~I10	No	No	NONCLUSTERED	CO_EXT_REF, MANDT
TCORT_CO~ID1	No	No	NONCLUSTERED	BUSTRANSID, MANDT
TCORT_CO~ID2	No	No	NONCLUSTERED	MATCH_ID, MANDT
TCORT_CO~ID3	No	No	NONCLUSTERED	CO_INT_REF, MANDT
TCORT_CO~ID4	No	No	NONCLUSTERED	CO_KEY, MANDT
TCORT_CO~ID5	No	No	NONCLUSTERED	IS_COMPLETE, MANDT
TCORT_CO~ID7	No	No	NONCLUSTERED	COMPANY_CODE, MANDT
TCORT_CO~ID8	No	No	NONCLUSTERED	DEALNUMBER, MANDT
TCORT_CO~ID9	No	No	NONCLUSTERED	SEC_ACC, 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

84 COLUMNS | 10 INDEXES | ERP 6.0 | TCORT_CO TABLE

TOP ERP 6.0 | TCORT_CO COLUMNS

TOP ERP 6.0 | TCORT_CO 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

84 COLUMNS | 10 INDEXES | ERP 6.0 | TCORT_CO TABLE

TOPERP 6.0 | TCORT_CO COLUMNS

TOPERP 6.0 | TCORT_CO INDEXES

TOP ERP 6.0 | TCORT_CO COLUMNS

TOP ERP 6.0 | TCORT_CO INDEXES