TCJ_POSITIONS - Cash Journal Document Items

Cash Journal Document Items information is stored in SAP table TCJ_POSITIONS.
It is part of development package CAJO in software component FI-BL-PT. This development package consists of objects that can be grouped under "Cash Journal Development".

Fields for table TCJ_POSITIONS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
COMP_CODE	Company Code	X	BUKRS	CHAR	8	T001
CAJO_NUMBER	Cash Journal Number	X	CJNR	CHAR	8	TCJ_C_JOURNALS
FISC_YEAR	Fiscal Year	X	GJAHR	NUMC	8
POSTING_NUMBER	Cash Journal Document Number	X	CJBELNR	CHAR	20	TCJ_DOCUMENTS
POSITION_NUMBER	Number of Line Item within Cash Journal Document	X	CJBUZEI	NUMC	6
POSITION_TYPE	Cash Journal Item Type		CJPOSTYPE	CHAR	4
TRANSACT_NUMBER	Number of Cash Journal Business Transaction		CJTRANSNUMB	CHAR	8	TCJ_TRANSACTIONS
TRANSACT_TYPE	Business Transaction Type		CJTRANSTYP	CHAR	2
POSTING_DATE	Posting Date in the Document		BUDAT	DATS	16
CURRENCY	Currency Key		WAERS	CUKY	10	TCURC
P_RECEIPTS	Cash Journal Amount Field with +/- Sign		CJAMOUNT	CURR	12
P_PAYMENTS	Cash Journal Amount Field with +/- Sign		CJAMOUNT	CURR	12
P_NET_AMOUNT	Cash Journal Document Net Amount - Document Currency		CJNET_AMOUNT	CURR	12
P_NET_PAYMENT_WT	Net Payment Amount (Withholding Tax Deducted)		CJNET_PAYMENT_WT	CURR	12
P_TAX_AMOUNT	Tax Amount in Document Currency		WMWST	CURR	12
TAX_CODE	Tax on sales/purchases code		MWSKZ	CHAR	4	T007A
TAXCALCDATE	Date for Determining Tax Rates		TXDAT	DATS	16
GL_ACCOUNT	General Ledger Account		HKONT	CHAR	20	SKA1
TAX_PERCENT	Tax rate		MSATZ_F05L	DEC	4
POSITION_TEXT	Cash Journal Line Item Text		CJPOSTEXT	CHAR	100
VENDOR_NO	Account Number of Supplier		LIFNR	CHAR	20	LFA1
CUSTOMER	Customer Number		KUNNR	CHAR	20	KNA1
.INCLUDE				COBL_DB_INCLUDE	0
GSBER	Business Area		GSBER	CHAR	8	*
PARGB	Trading partner's business area		PARGB	CHAR	8	*
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	*
RMVCT	Transaction type		RMVCT	CHAR	6	*
FKBER	Functional Area		FKBER	CHAR	32	*
KOKRS	Controlling Area		KOKRS	CHAR	8	*
KOSTL	Cost Center		KOSTL	CHAR	20	*
LSTAR	Activity Type		LSTAR	CHAR	12	*
AUFNR	Order Number		AUFNR	CHAR	24	*
AFPOS	Order item number		CO_POSNR	NUMC	8
BEMOT	Accounting Indicator		BEMOT	CHAR	4	*
KSTRG	Cost Object		KSTRG	CHAR	24	*
PRZNR	Business Process		CO_PRZNR	CHAR	24	*
PRCTR	Profit Center		PRCTR	CHAR	20	*
PPRCTR	Partner Profit Center		PPRCTR	CHAR	20	*
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24	*
VORNR	Operation/Activity Number		VORNR	CHAR	8
ANLN1	Main Asset Number		BF_ANLN1	CHAR	24
ANLN2	Asset Subnumber		BF_ANLN2	CHAR	8
BZDAT	Reference date		BF_BZDAT	DATS	16
ANBWA	Asset transaction type		BF_ANBWA	CHAR	6
WERKS	Plant		WERKS_D	CHAR	8	*
BWTAR	Valuation Type		BWTAR_D	CHAR	20	*
BWKEY	Valuation area		BWKEY	CHAR	8	*
MATNR	Material Number		MATNR	CHAR	80	*
HRKFT	Origin Group as Subdivision of Cost Element		HRKFT	CHAR	8	*
HKMAT	Material-related origin		HKMAT	CHAR	2
KDAUF	Sales Order Number		KDAUF	CHAR	20
KDEIN	Delivery schedule for sales order		KDEIN	NUMC	8
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
VNAME	Joint venture		JV_NAME	CHAR	12	*
RECID	Recovery Indicator		JV_RECIND	CHAR	4	*
RECID_MAN	Indicator: Recovery Indicator Set Manually.		JV_RECID_M	CHAR	2
EGRUP	Equity group		JV_EGROUP	CHAR	6	*
ETYPE	Equity type		JV_ETYPE	CHAR	6	*
VPTNR	Partner account number		JV_PART	CHAR	20	*
CONDI	Joint Venture Indicator (Condition Key)		JV_CONDCOD	CHAR	4	*
CRPCAL	Flag CRP Calculation: Yes or NO		JV_CRPCAL	CHAR	2
FIKRS	Financial Management Area		FIKRS	CHAR	8	*
FISTL	Funds Center		FISTL	CHAR	32	*
FIPOS	Commitment Item		FIPOS	CHAR	28	*
FIPEX	Commitment Item		FM_FIPEX	CHAR	48	*
GEBER	Fund		BP_GEBER	CHAR	20	*
KBLNR	Document Number for Earmarked Funds		KBLNR_FI	CHAR	20	*
KBLPOS	Earmarked Funds: Document Item		KBLPOS	NUMC	6	*
ERLKZ	Used earmarked funds set to "Complete"		REFSETERLK	CHAR	2
PERNR	Personnel Number		PERNR_D	NUMC	16
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
KONTT	Account Assignment Category for Industry Solution		KONTT_FI	CHAR	4
KONTL	Acct assignment string for industry-specific acct assignmnts		KONTL_FI	CHAR	100
.INCLUDE				INCL_EEW_COBL	0
.INCLUDE				CI_COBL	0
DUMMY_INCL_EEW_COBL	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
SMIVE	Lease-Out Number		SMIVE	CHAR	26
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
DABRZ	Reference date for settlement		DABRBEZ	DATS	16
BUDGET_PD	Budget Period		FM_BUDGET_PERIOD	CHAR	20	*
MONAT	Fiscal period		MONAT	NUMC	4
LOGSYS_KDAUF	Source System		FINS_CFIN_LOGSYSTEM_SENDER	CHAR	20	*
TAXJURCODE	Tax Jurisdiction		TXJCD	CHAR	30	TTXJ
ALLOC_NMBR	Assignment number		DZUONR	CHAR	36
BRANCH	Account Number of the Branch		FILKD	CHAR	20
P_FWBAS	Tax Base Amount in Document Currency		FWBAS	CURR	12
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	FAGL_SEGM
PSEGMENT	Partner Segment for Segmental Reporting		FB_PSEGMENT	CHAR	20	FAGL_SEGM
STCEG	VAT Registration Number		STCEG	CHAR	40
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
HKTID	ID for Account Details		HKTID	CHAR	10	T012K
BVTYP	Partner bank type		BVTYP	CHAR	8
TAX_COUNTRY	Tax Reporting Country/Region		FOT_TAX_COUNTRY	CHAR	6