TCORT_CO - Correspondence Administrative Data

Correspondence Administrative Data information is stored in SAP table TCORT_CO.
It is part of development package FTR_CORRESPONDENCE in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury Correspondence (Confirmations & Matching)".

Fields for table TCORT_CO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CO_UUID	Correspondence Object UUID	X	FTR_COID	RAW	16
.INCLUDE				TCORS_CO_INCL	0
CO_KEY	Correspondence Key		FTR_CO_KEY	CHAR	32
CODMD_UUID	Correspondence Object Deal's main data UUID		FTR_CODMDID	RAW	16
COSA_UUID	CO: Securities account main data id		FTR_COSAID	RAW	16
COMPANY_CODE	Company Code		BUKRS	CHAR	8
DEALNUMBER	Financial Transaction		TB_RFHA	CHAR	26
BUSTRANSID	Identifier of the Distributor Business Transaction		TPM_BUSTRANSID	RAW	16
BUSTRANSCAT	Business Transaction Category		TPM_BUSTRANSCAT	NUMC	8	*
SEC_ACC	Securities Account		VRLDEPO	CHAR	20	*
SECURITYID	Security Class ID Number		VVRANLW	CHAR	26
PRODUCTTYPE	Product Type		VVSART	CHAR	6
TRANSACTIONTYPE	Financial Transaction Type		TB_SFHAART	CHAR	6
ACTIVITY	Transaction Activity		TB_RFHAZU	NUMC	10
ACTIVITYCAT	Transaction Activity Category		TB_SFGZUTY	NUMC	4
SFUNKTL	Latest function used in editing activity		TB_SFUNKTL	CHAR	8	*
PARTNR	Business Partner Number		BP_PARTNR_NEW	CHAR	20	BUT000
BPGROUP	Business Partner Group ID		FTR_BPGRP	CHAR	30	TCORC_BUSGRP
PROFILE	Correspondence Profile		FTR_PROFILE	CHAR	30	TCORFC_PROFILE
RECIPIENT_TYPE	Recipient/Sender Type		FTR_RECIPIENT_TYPE	CHAR	30	TCORFC_REC_TYPE
RECIPIENT	Correspondence Recipient		FTR_RECIPIENT	CHAR	20
FUNCTION	Correspondence Class		FTR_FUNCTION	CHAR	30	TCORFC_FUNCTION
CHANNEL	Correspondence Channel		FTR_CHANNEL	CHAR	30	TCORFTS_CHANNEL
MESSAGE_FORMAT	Format		FTR_FORMAT	CHAR	30	TCORFTS_FORMAT
DIRECTION	Direction of Correspondence		FTR_CODIR	CHAR	2
OPERATION	Operation causing the creation of CO		FTR_OPER	CHAR	8
REF_CO_KEY	Reference CO Key		FTR_REFCOID	CHAR	32
STATUS_GUID	TCO Status Object Id		FTR_STATUS_OBJID	RAW	16
IS_AUTO_CORR	Automatic Correspondence Required?		FTR_AUTO_CORR_FLG	CHAR	2
IS_REL_REQD	Release Required?		FTR_REL_FLG	CHAR	2
IS_STATUS_REL	Status Relevant for Financial Transactions?		FTR_STAT_REL_FLG	CHAR	2
IS_CTRCONF_REQD	Counterconfirmation Required?		FTR_CTRCONF_FLG	CHAR	2
IS_AUTO_COMPLETE	Automatic Completion Required?		FTR_AUTOCOMP	CHAR	2
IS_UPD_EXT_REF	Get Values from Counterconfirmation		FTR_UPD_EXTREF	CHAR	2
IS_MANUAL	'Is CO manually created' indicator		FTR_MANUAL_FLG	CHAR	2
IS_ACK_REL	Indicator: Is Acknowledgement Relevant?		FTR_ACK_FLAG	CHAR	2
IS_RESENT	Flag: Is CO resent		FTR_RESENT_FLAG	CHAR	2
RECONCILE	Reconcile		FTR_RECONCILE	CHAR	2
SET_DELIVERY	Physical Delivery		FTR_PHYDEL_IND	CHAR	2
CRUSER	Entered By		FTR_CRUSER	CHAR	24
DCRDAT	Entered On		TB_DCRDAT	DATS	16
TCRTIM	Entry Time		TB_TCRTIM	TIMS	12
UPUSER	Last Changed By		FTR_UPUSER	CHAR	24
DUPDAT	Changed On		TB_DUPDAT	DATS	16
TUPTIM	Time Changed		TB_TUPTIM	TIMS	12
EXEC_DATE	Outgoing Correspondence Execution Date		FTR_EXEC_DATE	DATS	16
EXEC_TIME	Outgoing Correspondence Execution Time		FTR_EXEC_TIME	TIMS	12
EXEC_USER	Outgoing Correspondence Executed by User		FTR_EXEC_USER	CHAR	24
DELV_DATE	Outgoing Correspondence Delivery Date		FTR_DELV_DATE	DATS	16
DELV_TIME	Outgoing correspondence delivery time		FTR_DELV_TIME	TIMS	12
DELV_USER	Outgoing Correspondence: Delivered By User		FTR_DELV_USER	CHAR	24
RECON_DATE	Outgoing correspondence counter-confirmed date		FTR_RECON_DATE	DATS	16
RECON_TIME	Outgoing correspondence counter-confirmed time		FTR_RECON_TIME	TIMS	12
RECON_USER	Outgoing correspondence counter-confirmed by user		FTR_RECON_USER	CHAR	24
MTCH_DATE	Correspondence Object Matched Date		FTR_MTCH_DATE	DATS	16
MTCH_TIME	Correspondence object matched time		FTR_MTCH_TIME	TIMS	12
MTCH_USER	Correspondence Object Matched by User		FTR_MTCH_USER	CHAR	24
RECV_DATE	Correspondence object received date		FTR_RECV_DATE	DATS	16
RECV_TIME	Correspondence Object Receipt Time		FTR_RECV_TIME	TIMS	12
RECV_USER	Correspondence object received by user		FTR_RECV_USER	CHAR	24
MATCH_ID	TCOR: Match Id (Number range: FTRN_MATCH)		FTR_MATCH_ID	CHAR	32
CO_INT_REF	Correspondence internal reference		FTR_INT_REF	CHAR	32
CO_EXT_REF	Correspondence External Reference		FTR_EXT_REF	CHAR	32
IS_COMPLETE	Is Correspondence Object complete		FTR_COMPLETE	CHAR	2
IS_MANUAL_CHNG	Is CO manually changed		FTR_MANUAL_CHNG	CHAR	2
MSG_STATUS	Message Status		FTR_MSG_STATUS	CHAR	32
MSG_REASON	Reason for Message Status		FTR_MSG_REASON	CHAR	32
ERROR_CODE	Error code		FTR_ERROR_CODE	CHAR	6
ERROR_TEXT	Error text		FTR_ERROR_TEXT	CHAR	60
ERROR_LINE	Error line number		FTR_ERROR_LINE	CHAR	6
CORR_COUNTRY	Country/Region Key		LAND1	CHAR	6	*
CORR_LANGUAGE	Language Key		SPRAS	LANG	2	T002
CORPACT_IND	Corporate action event indicator		FTR_CORP_ACTION	CHAR	8
.INCLUDE				TCORS_RECIPIENT_ADDR	0
ADR_COUNTRY	Country/Region Key		LAND1_GP	CHAR	6
FAX_NO	Business Partner Fax Number		TB_KOTELFX	CHAR	62
EMAIL_ADD	E-Mail Address		AD_SMTPADR	CHAR	482
SENT_FOR_MATCH	Indicator : Is Correspondence Sent For Match?		FTR_SENT_FOR_MATCH	CHAR	2
LOG_HANDLE	Application Log: Log Handle		BALLOGHNDL	CHAR	44
CORR_ADDTYPE	Alternative Address for Correspondence		TB_CORR_AD_NEW	CHAR	20	*
SAP_USER	User Name in User Master Record		XUBNAME	CHAR	24	*
IS_AUTOMATCH_OUT	Auto-Matching Triggered on Delivery of Outgoing Corresp.		FTR_AUTOMATCH_O	CHAR	2
IS_DEAL_REL_REQ	Do Not Send Before Release of Financial Transaction		FTR_DEAL_REL_FLG	CHAR	2
IS_CTRCNF_MAN	Is correspondence counterconfirmed manually?		FTR_CTRCNF_MAN	CHAR	2
ASSIGN_REASON	Reason for Assignment		FTR_ASSIGNMENT_REASON	CHAR	4
PRESENT_ID	Presentation Item		FTR_PERSENT_ID	CHAR	20
PRESENT_STATUS	Status		FTR_STATUS	CHAR	4