	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

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

175 COLUMNS | 1 INDEXES | ERP 6.0 | TRLC_DFT_ASSGN_M TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transfer to Financial Accounting
1	ERP EHP7	6.0	TRLC_DFT_ASSGN_M	175	1	Assignment: Update Types for Position Change Category M	Transfer to Financial Accounting

SQL: selectupdate insert create

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

SELECT MANDT, POS_MAN_PROC, M001, M002, M003, M004, M005, M006, M007, M008, M009, M010, M011, M012, M013, M014, M015, M016, M017, M018, M019, M020, M021, M022, M023, M024, M025, M026, M027, M028, M029, M030, M031, M032, M033, M034, M035, M036, M037, M038, M039, M040, M041, M042, M043, M044, M045, M046, M047, M048, M049, M050, M051, M052, M053, M054, M055, M056, M057, M058, M059, M060, M061, M062, M063, M064, M065, M066, M067, M068, M069, M070, M071, M072, M073, M074, M075, M076, M077, M078, M079, M080, M081, M082, M083, M084, M085, M086, M087, M088, M089, M090, M091, M092, M093, M094, M095, M096, M097, M098, M099, M100, M101, M102, M103, M104, M105, M106, M107, M108, M109, M110, M111, M112, M113, M114, M115, M116, M117, M118, M119, M120, M121, M122, M123, M124, M125, M126, M127, M128, M129, M130, M131, M132, M133, M134, M135, M136, M137, M138, M139, M140, M141, M142, M143, M144, M145, M146, M147, M148, M149, M150, M151, M152, M153, M154, M155, M156, M157, M158, M159, M160, M161, M162, M163, M164, M165, M166, M167, M168, M169, M170, M171, M172, M173 FROM TRLC_DFT_ASSGN_M

TOP ERP 6.0 | TRLC_DFT_ASSGN_M COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	POS_MAN_PROC	Position Management Procedure	nvarchar	4	CHAR	(N' ')	No	TRLC_DFT_ASSGN_A	TPM_POS_MAN_PROC	Allow NULL?
3	M001	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
4	M002	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
5	M003	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
6	M004	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
7	M005	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
8	M006	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
9	M007	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
10	M008	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
11	M009	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
12	M010	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
13	M011	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
14	M012	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
15	M013	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
16	M014	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
17	M015	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
18	M016	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
19	M017	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
20	M018	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
21	M019	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
22	M020	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
23	M021	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
24	M022	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
25	M023	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
26	M024	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
27	M025	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
28	M026	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
29	M027	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
30	M028	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
31	M029	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
32	M030	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
33	M031	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
34	M032	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
35	M033	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
36	M034	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
37	M035	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
38	M036	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
39	M037	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
40	M038	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
41	M039	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
42	M040	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
43	M041	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
44	M042	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
45	M043	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
46	M044	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
47	M045	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
48	M046	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
49	M047	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
50	M048	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
51	M049	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
52	M050	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
53	M051	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
54	M052	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
55	M053	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
56	M054	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
57	M055	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
58	M056	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
59	M057	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
60	M058	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
61	M059	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
62	M060	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
63	M061	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
64	M062	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
65	M063	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
66	M064	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
67	M065	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
68	M066	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
69	M067	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
70	M068	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
71	M069	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
72	M070	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
73	M071	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
74	M072	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
75	M073	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
76	M074	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
77	M075	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
78	M076	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
79	M077	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
80	M078	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
81	M079	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
82	M080	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
83	M081	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
84	M082	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
85	M083	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
86	M084	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
87	M085	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
88	M086	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
89	M087	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
90	M088	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
91	M089	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
92	M090	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
93	M091	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
94	M092	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
95	M093	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
96	M094	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
97	M095	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
98	M096	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
99	M097	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
100	M098	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
101	M099	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
102	M100	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
103	M101	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
104	M102	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
105	M103	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
106	M104	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
107	M105	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
108	M106	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
109	M107	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
110	M108	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
111	M109	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
112	M110	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
113	M111	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
114	M112	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
115	M113	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
116	M114	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
117	M115	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
118	M116	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
119	M117	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
120	M118	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
121	M119	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
122	M120	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
123	M121	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
124	M122	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
125	M123	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
126	M124	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
127	M125	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
128	M126	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
129	M127	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
130	M128	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
131	M129	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
132	M130	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
133	M131	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
134	M132	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
135	M133	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
136	M134	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
137	M135	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
138	M136	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
139	M137	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
140	M138	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
141	M139	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
142	M140	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
143	M141	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
144	M142	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
145	M143	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
146	M144	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
147	M145	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
148	M146	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
149	M147	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
150	M148	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
151	M149	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
152	M150	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
153	M151	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
154	M152	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
155	M153	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
156	M154	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
157	M155	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
158	M156	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
159	M157	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
160	M158	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
161	M159	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
162	M160	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
163	M161	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
164	M162	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
165	M163	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
166	M164	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
167	M165	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
168	M166	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
169	M167	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
170	M168	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
171	M169	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
172	M170	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
173	M171	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
174	M172	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
175	M173	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?

TOP ERP 6.0 | TRLC_DFT_ASSGN_M INDEXES

Name	Primary	Unique	Type	Columns
TRLC_DFT_ASSGN_M~0	Yes	Yes	CLUSTERED	MANDT, POS_MAN_PROC

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

175 COLUMNS | 1 INDEXES | ERP 6.0 | TRLC_DFT_ASSGN_M TABLE

TOP ERP 6.0 | TRLC_DFT_ASSGN_M COLUMNS

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

175 COLUMNS | 1 INDEXES | ERP 6.0 | TRLC_DFT_ASSGN_M TABLE

TOPERP 6.0 | TRLC_DFT_ASSGN_M COLUMNS

TOPERP 6.0 | TRLC_DFT_ASSGN_M INDEXES

TOP ERP 6.0 | TRLC_DFT_ASSGN_M COLUMNS

TOP ERP 6.0 | TRLC_DFT_ASSGN_M INDEXES