	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

152 COLUMNS | 1 INDEXES | ERP 6.0 | TRDTC_DFT_ASSGN TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	TRDTC_DFT_ASSGN	152	1	Update Types for Legacy Data Transfer	Transaction Manager

SQL: selectupdate insert create

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

SELECT MANDT, PRODUCT_TYPE, T001, T002, T003, T004, T005, T006, T007, T008, T009, T010, T011, T012, T013, T014, T015, T016, T017, T018, T019, T020, T021, T022, T023, T024, T025, T026, T027, T028, T029, T030, T031, T032, T033, T034, T035, T036, T037, T038, T039, T040, T041, T042, T043, T044, T045, T046, T047, T048, T049, T050, T051, T052, T053, T054, T055, T056, T057, T058, T059, T060, T061, T062, T063, T064, T065, T066, C001, C002, C003, C004, C005, C006, C007, C008, C009, C010, C011, C012, C013, C014, C015, C016, C017, C018, C019, C020, C021, C022, C023, C024, C025, C026, C027, C028, C029, C030, R005, R006, R007, R008, R009, R010, R013, R014, R015, R016, R017, R018, R019, R020, R021, R022, R023, R024, R025, R026, R027, R028, R029, R030, R033, R034, R035, R036, R037, R038, R039, R040, R041, R042, R047, R048, R053, R054, T070, T071, T072, T073, T074, T075, T076, T077, T078, T079, T080, T081, T082, T083, T084, T085 FROM TRDTC_DFT_ASSGN

TOP ERP 6.0 | TRDTC_DFT_ASSGN 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	PRODUCT_TYPE	Product Type	nvarchar	3	CHAR	(N' ')	No	TZPA	VVSART	Allow NULL?
3	T001	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
4	T002	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
5	T003	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
6	T004	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
7	T005	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
8	T006	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
9	T007	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
10	T008	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
11	T009	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
12	T010	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
13	T011	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
14	T012	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
15	T013	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
16	T014	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
17	T015	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
18	T016	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
19	T017	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
20	T018	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
21	T019	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
22	T020	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
23	T021	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
24	T022	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
25	T023	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
26	T024	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
27	T025	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
28	T026	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
29	T027	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
30	T028	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
31	T029	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
32	T030	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
33	T031	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
34	T032	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
35	T033	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
36	T034	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
37	T035	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
38	T036	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
39	T037	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
40	T038	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
41	T039	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
42	T040	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
43	T041	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
44	T042	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
45	T043	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
46	T044	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
47	T045	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
48	T046	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
49	T047	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
50	T048	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
51	T049	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
52	T050	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
53	T051	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
54	T052	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
55	T053	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
56	T054	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
57	T055	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
58	T056	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
59	T057	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
60	T058	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
61	T059	Update Type	nvarchar	8	CHAR	(N' ')	Yes	*	TPM_DIS_FLOWTYPE	Allow NULL?
62	T060	Update Type	nvarchar	8	CHAR	(N' ')	Yes	*	TPM_DIS_FLOWTYPE	Allow NULL?
63	T061	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
64	T062	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
65	T063	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
66	T064	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
67	T065	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
68	T066	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
69	C001	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
70	C002	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
71	C003	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
72	C004	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
73	C005	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
74	C006	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
75	C007	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
76	C008	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
77	C009	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
78	C010	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
79	C011	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
80	C012	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
81	C013	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
82	C014	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
83	C015	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
84	C016	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
85	C017	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
86	C018	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
87	C019	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
88	C020	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
89	C021	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
90	C022	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
91	C023	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
92	C024	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
93	C025	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
94	C026	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
95	C027	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
96	C028	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
97	C029	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
98	C030	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
99	R005	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
100	R006	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
101	R007	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
102	R008	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
103	R009	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
104	R010	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
105	R013	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
106	R014	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
107	R015	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
108	R016	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
109	R017	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
110	R018	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
111	R019	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
112	R020	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
113	R021	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
114	R022	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
115	R023	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
116	R024	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
117	R025	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
118	R026	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
119	R027	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
120	R028	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
121	R029	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
122	R030	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
123	R033	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
124	R034	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
125	R035	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
126	R036	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
127	R037	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
128	R038	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
129	R039	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
130	R040	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
131	R041	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
132	R042	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
133	R047	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
134	R048	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
135	R053	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
136	R054	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
137	T070	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
138	T071	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
139	T072	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
140	T073	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
141	T074	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
142	T075	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
143	T076	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
144	T077	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
145	T078	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
146	T079	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
147	T080	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
148	T081	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
149	T082	Update Type	nvarchar	8	CHAR	(N' ')	Yes	*	TPM_DIS_FLOWTYPE	Allow NULL?
150	T083	Update Type	nvarchar	8	CHAR	(N' ')	Yes	*	TPM_DIS_FLOWTYPE	Allow NULL?
151	T084	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
152	T085	Update Type	nvarchar	8	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?

TOP ERP 6.0 | TRDTC_DFT_ASSGN INDEXES

Name	Primary	Unique	Type	Columns
TRDTC_DFT_ASSGN~0	Yes	Yes	CLUSTERED	MANDT, PRODUCT_TYPE

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

152 COLUMNS | 1 INDEXES | ERP 6.0 | TRDTC_DFT_ASSGN TABLE

TOP ERP 6.0 | TRDTC_DFT_ASSGN COLUMNS

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

152 COLUMNS | 1 INDEXES | ERP 6.0 | TRDTC_DFT_ASSGN TABLE

TOPERP 6.0 | TRDTC_DFT_ASSGN COLUMNS

TOPERP 6.0 | TRDTC_DFT_ASSGN INDEXES

TOP ERP 6.0 | TRDTC_DFT_ASSGN COLUMNS

TOP ERP 6.0 | TRDTC_DFT_ASSGN INDEXES