	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

211 COLUMNS | 13 INDEXES | 910 | 17C | F1755 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
17C: Call Management
1	910	F1755	ZA	211	13	Case Master	Master Files	17C: Call Management	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT ZASTAW, ZADOCO, ZAUPMJ, ZAUPMT, ZADCTO, ZAKCOO, ZACT01, ZACT02, ZAPRIOR, ZACLST, ZADESC, ZAISSUE, ZASERK, ZASCALL, ZAVRU, ZACALLRN, ZATASKNO, ZATIMEZONES, ZADSAVNAME, ZAREGION, ZALNGP, ZAPARCALL, ZACALLQ, ZAAN8, ZAPH1, ZAANC, ZAIDLN, ZAAR1, ZACPH, ZAWHO1, ZAREM1, ZAFAR1, ZACFAX1, ZAAAR1, ZAPHN1, ZACTR, ZAAN8CT1, ZAIDLNC1, ZAAR2, ZACPHC1, ZAWHO2, ZACEML1, ZAFAR2, ZACFAX2, ZAAAR2, ZAPHN2, ZAAN8CT2, ZAIDLNC2, ZAAR3, ZACPHC2, ZAWHO3, ZACEML2, ZAFAR3, ZACFAX3, ZAAAR3, ZAPHN3, ZAAN8CT3, ZAIDLNC3, ZAAR4, ZACPHC3, ZAWHO4, ZACEML3, ZAFAR4, ZACFAX4, ZAAAR4, ZAPHN4, ZANUMB, ZAPRODF, ZAPRODM, ZAPRODC, ZAITM, ZAMMCU, ZALOTN, ZAENV, ZALANO, ZADOCZ, ZARCTO, ZARKCO, ZARLIN, ZACOCH, ZAOORN, ZAOCTO, ZAOKCO, ZADOC, ZADCT, ZAKCO, ZADOCM, ZADCTM, ZAKCOP, ZAENTCK, ZAGWAUT, ZABILL, ZAMTHPR, ZAGLCCV, ZAGLCNC, ZACOST, ZALNTY, ZARSTM, ZAHMCU, ZAOBJ, ZASUB, ZACSCL, ZAISNO, ZAAG, ZAACR, ZAMODE, ZACRCD, ZACRDC, ZAHRSO, ZAAMTO, ZAFAP, ZADTBIL, ZAASN3, ZACOVGR, ZAMCUZ, ZACO, ZAPBTM, ZAEFTB, ZAPETM, ZAEND, ZADX, ZAINRT, ZAONSDT, ZAONSTM, ZADRQJ, ZADRQT, ZASESD, ZASEED, ZASEST, ZASEET, ZADEF, ZADL01, ZATELH, ZAEDAYS, ZAIDYS, ZACOMD, ZACDATE, ZACTIME, ZAESC1, ZAESC2, ZAESDTE, ZAESTME, ZAJC01, ZAJC02, ZAJC03, ZAJC04, ZAJC05, ZAJC06, ZAJC07, ZAJC08, ZAJC09, ZAJC10, ZAZE01, ZAZE02, ZAZE03, ZAZE04, ZAZE05, ZAZE06, ZAZE07, ZAZE08, ZAZE09, ZAZE10, ZAURAB, ZAURCD, ZAURAT, ZAURDT, ZAURRF, ZAEFFT, ZACRTU, ZAUSER, ZAPID, ZAJOBN, ZATYPS, ZACRRM, ZACRR, ZAPEFJ, ZABLCN, ZAUM, ZAAMTFD, ZAAMTFF, ZAPCOVR, ZAGWAFL, ZAGWANC, ZASERP, ZAANOB, ZAUSA5, ZAVR01, ZAMINHR, ZAMINAD, ZAMINAF, ZADSFT, ZADSPC, ZAIDSC, ZACIDS, ZAITAM, ZACITX, ZAJTAX, ZAJTXF, ZAAMTCD, ZAAMTCF, ZAATXCD, ZAATXCF, ZAEFTJ, ZAPTC, ZARYIN, ZATAX1, ZATXA1, ZAPRAN8, ZAPRCNCT, ZAPRCIDLN, ZAEXR1 FROM F1755

TOP 910 | 17C | F1755 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZASTAW	Status	Character	UDC (00 WS)	1	0	Allow NULL?
2	ZADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	ZAUPMJ	Date - Updated	Date	Generic Edit	6	0
4	ZAUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
5	ZADCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	ZAKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
7	ZACT01	Case Type - 1	Character	UDC (17 CT)	1	0	Allow NULL?
8	ZACT02	Case Type - 2	Character	UDC (17 SC)	1	0	Allow NULL?
9	ZAPRIOR	Issue Priority	String	UDC (17 PR)	2	0	Allow NULL?
10	ZACLST	Case Status Code	String	UDC (17 ST)	3	0	Allow NULL?
11	ZADESC	Description	String	Generic Edit	30	0	Allow NULL?
12	ZAISSUE	Problem Description	String	Generic Edit	80	0	Allow NULL?
13	ZASERK	Key Value Serial Number	Numeric	Generic Edit	15	0	Allow NULL?
14	ZASCALL	Call Backs	Character	UDC (17 CB)	1	0	Allow NULL?
15	ZAVRU	Voice Response Unit Session	String	Generic Edit	20	0	Allow NULL?
16	ZACALLRN	Case Reason	String	UDC (17 CR)	3	0	Allow NULL?
17	ZATASKNO	Number of Open Tasks	Numeric	Generic Edit	8	0	Allow NULL?
18	ZATIMEZONES	Time Zone List	String	UDC (H91 TZ)	2	0	Allow NULL?
19	ZADSAVNAME	Daylight Savings Rule Name	String	UDC	10	0	Allow NULL?
20	ZAREGION	Geographic Region Code	String	UDC (17 GR)	3	0	Allow NULL?
21	ZALNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
22	ZAPARCALL	Document- Parent Case	Numeric	Generic Edit	8	0	Allow NULL?
23	ZACALLQ	Case Provider Group	Numeric	Generic Edit	8	0	Allow NULL?
24	ZAAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
25	ZAPH1	Phone Number	String	Generic Edit	20	0	Allow NULL?
26	ZAANC	Address Number - Customer Number	Numeric	Generic Edit	8	0	Allow NULL?
27	ZAIDLN	Who's Who Line Number - ID	Numeric	Generic Edit	5	0	Allow NULL?
28	ZAAR1	Phone Prefix	String	Generic Edit	6	0	Allow NULL?
29	ZACPH	call from phone	String	Generic Edit	20	0	Allow NULL?
30	ZAWHO1	Contact Name 1	String	Generic Edit	40	0	Allow NULL?
31	ZAREM1	Remark 1	String	Generic Edit	40	0	Allow NULL?
32	ZAFAR1	FAX Prefix	String	Generic Edit	6	0	Allow NULL?
33	ZACFAX1	Case Fax Number 1	String	Generic Edit	20	0	Allow NULL?
34	ZAAAR1	Alt Phone Prefix 1	String	Generic Edit	6	0	Allow NULL?
35	ZAPHN1	Phone Number	String	Generic Edit	20	0	Allow NULL?
36	ZACTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
37	ZAAN8CT1	Contact1 Address Number	Numeric	Generic Edit	8	0	Allow NULL?
38	ZAIDLNC1	Who's Who Line Number Contact 1	Numeric	Generic Edit	5	0	Allow NULL?
39	ZAAR2	Phone Prefix 2	String	Generic Edit	6	0	Allow NULL?
40	ZACPHC1	Case From Phone Contact 1	String	Generic Edit	20	0	Allow NULL?
41	ZAWHO2	Contact Name 2	String	Generic Edit	40	0	Allow NULL?
42	ZACEML1	Case E-Mail Address 1	String	Generic Edit	40	0	Allow NULL?
43	ZAFAR2	FAX Prefix 2	String	Generic Edit	6	0	Allow NULL?
44	ZACFAX2	Case Fax Number 2	String	Generic Edit	20	0	Allow NULL?
45	ZAAAR2	Alt Phone Prefix 2	String	Generic Edit	6	0	Allow NULL?
46	ZAPHN2	Phone Number	String	Generic Edit	20	0	Allow NULL?
47	ZAAN8CT2	Contact2 Address Number	Numeric	Generic Edit	8	0	Allow NULL?
48	ZAIDLNC2	Who's Who Line Number Contact 2	Numeric	Generic Edit	5	0	Allow NULL?
49	ZAAR3	Phone Area Code 3	String	Generic Edit	6	0	Allow NULL?
50	ZACPHC2	Case From Phone Contact 2	String	Generic Edit	20	0	Allow NULL?
51	ZAWHO3	Contact Name 3	String	Generic Edit	40	0	Allow NULL?
52	ZACEML2	Case E-Mail Address 2	String	Generic Edit	40	0	Allow NULL?
53	ZAFAR3	FAX Prefix 3	String	Generic Edit	6	0	Allow NULL?
54	ZACFAX3	Case Fax Number 3	String	Generic Edit	20	0	Allow NULL?
55	ZAAAR3	Alt Phone Prefix 3	String	Generic Edit	6	0	Allow NULL?
56	ZAPHN3	Phone Number	String	Generic Edit	20	0	Allow NULL?
57	ZAAN8CT3	Contact3 Address Number	Numeric	Generic Edit	8	0	Allow NULL?
58	ZAIDLNC3	Who's Who Line Number Contact 3	Numeric	Generic Edit	5	0	Allow NULL?
59	ZAAR4	Phone Area Code 4	String	Generic Edit	6	0	Allow NULL?
60	ZACPHC3	Case From Phone Contact 3	String	Generic Edit	20	0	Allow NULL?
61	ZAWHO4	Contact Name 4	String	Generic Edit	40	0	Allow NULL?
62	ZACEML3	Case E-Mail Address 3	String	Generic Edit	40	0	Allow NULL?
63	ZAFAR4	FAX Prefix 4	String	Generic Edit	6	0	Allow NULL?
64	ZACFAX4	Case Fax Number 4	String	Generic Edit	20	0	Allow NULL?
65	ZAAAR4	Alt Phone Prefix 4	String	Generic Edit	6	0	Allow NULL?
66	ZAPHN4	Phone Number	String	Generic Edit	20	0	Allow NULL?
67	ZANUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
68	ZAPRODF	Product Family	String	UDC (17 PA)	8	0	Allow NULL?
69	ZAPRODM	Product Model	String	UDC (17 PM)	8	0	Allow NULL?
70	ZAPRODC	Product Component	String	UDC (17 PC)	10	0	Allow NULL?
71	ZAITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
72	ZAMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
73	ZALOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
74	ZAENV	Environment	String	UDC (17 EN)	10	0	Allow NULL?
75	ZALANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	0	Allow NULL?
76	ZADOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
77	ZARCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
78	ZARKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
79	ZARLIN	Related Payment Line ID	Numeric	Generic Edit	5	0	Allow NULL?
80	ZACOCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
81	ZAOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
82	ZAOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
83	ZAOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
84	ZADOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
85	ZADCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
86	ZAKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
87	ZADOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
88	ZADCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
89	ZAKCOP	Document Company (A/P Model Document)	String	Generic Edit	5	0	Allow NULL?
90	ZAENTCK	Entitlement Check	String	UDC (17 ER)	3	0	Allow NULL?
91	ZAGWAUT	Goodwill Authorization	String	UDC (41 9)	4	0	Allow NULL?
92	ZABILL	Billable (Y/N)	Character	UDC (H00 BI)	1	0	Allow NULL?
93	ZAMTHPR	Method of Pricing	Character	UDC (17 MP)	1	0	Allow NULL?
94	ZAGLCCV	Category - G/L Covered	String	UDC (41 9)	4	0	Allow NULL?
95	ZAGLCNC	Category - G/L Non-Covered	String	UDC (41 9)	4	0	Allow NULL?
96	ZACOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
97	ZALNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
98	ZARSTM	Time - Guaranteed Response	Numeric	Generic Edit	5	2	Allow NULL?
99	ZAHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
100	ZAOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
101	ZASUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
102	ZACSCL	Service/Warranty Claim Number	String	Generic Edit	20	0	Allow NULL?
103	ZAISNO	Issue Number	Numeric	Generic Edit	8	0	Allow NULL?
104	ZAAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
105	ZAACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
106	ZAMODE	Mode - Processing	Character	Generic Edit	1	0	Allow NULL?
107	ZACRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
108	ZACRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
109	ZAHRSO	Hours - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
110	ZAAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
111	ZAFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
112	ZADTBIL	Date - Billed	Date	Generic Edit	6	0
113	ZAASN3	Price and Adjustment Schedule-Cases	String	UDC (40 AS)	8	0	Allow NULL?
114	ZACOVGR	Coverage Group	String	UDC (17 CG)	8	0	Allow NULL?
115	ZAMCUZ	Business Unit - Alt	String	Generic Edit	12	0	Allow NULL?
116	ZACO	Company	String	Generic Edit	5	0	Allow NULL?
117	ZAPBTM	Time - Beginning (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
118	ZAEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
119	ZAPETM	Time - Ending (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
120	ZAEND	Date - Ending	Date	Generic Edit	6	0
121	ZADX	Date - Execution	Date	Generic Edit	6	0
122	ZAINRT	Initial Return	Numeric	Generic Edit	6	0	Allow NULL?
123	ZAONSDT	Date - On Site	Date	Generic Edit	6	0
124	ZAONSTM	Time - ON Site (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
125	ZADRQJ	Date - Requested	Date	Generic Edit	6	0
126	ZADRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
127	ZASESD	Date - Scheduled Start (Julian)	Date	Generic Edit	6	0
128	ZASEED	Date - Scheduled End (Julian)	Date	Generic Edit	6	0
129	ZASEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
130	ZASEET	Time - Scheduled End (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
131	ZADEF	Date - Effective	Date	Generic Edit	6	0
132	ZADL01	Description	String	Generic Edit	30	0	Allow NULL?
133	ZATELH	Time - Total Elapsed Hours	Numeric	Generic Edit	6	2	Allow NULL?
134	ZAEDAYS	Elapsed days	Numeric	Generic Edit	3	0	Allow NULL?
135	ZAIDYS	Initial days	Numeric	Generic Edit	3	0	Allow NULL?
136	ZACOMD	Commit Duration	Numeric	Generic Edit	6	0	Allow NULL?
137	ZACDATE	Date - Commitment	Date	Generic Edit	6	0
138	ZACTIME	Commit Time	Numeric	Generic Edit	6	0	Allow NULL?
139	ZAESC1	Escalation Status 1	Character	Generic Edit	1	0	Allow NULL?
140	ZAESC2	Escalation Status 2	Character	Generic Edit	1	0	Allow NULL?
141	ZAESDTE	Date - Escalation	Date	Generic Edit	6	0
142	ZAESTME	Time - Escalation(HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
143	ZAJC01	Category Code - Case 01	String	UDC (17 01)	3	0	Allow NULL?
144	ZAJC02	Category Code - Case 02	String	UDC (17 02)	3	0	Allow NULL?
145	ZAJC03	Category Code - Case 03	String	UDC (17 03)	3	0	Allow NULL?
146	ZAJC04	Category Code - Case 04	String	UDC (17 04)	3	0	Allow NULL?
147	ZAJC05	Category Code - Case 05	String	UDC (17 05)	3	0	Allow NULL?
148	ZAJC06	Category Code - Case 06	String	UDC (17 06)	3	0	Allow NULL?
149	ZAJC07	Category Code - Case 07	String	UDC (17 07)	3	0	Allow NULL?
150	ZAJC08	Category Code - Case 08	String	UDC (17 08)	3	0	Allow NULL?
151	ZAJC09	Category Code - Case 09	String	UDC (17 09)	3	0	Allow NULL?
152	ZAJC10	Category Code - Case 10	String	UDC (17 10)	3	0	Allow NULL?
153	ZAZE01	Category Code - Equipment 01	String	UDC (17 B1)	10	0	Allow NULL?
154	ZAZE02	Category Code - Equipment 02	String	UDC (17 B2)	10	0	Allow NULL?
155	ZAZE03	Category Code - Equipment 03	String	UDC (17 B3)	10	0	Allow NULL?
156	ZAZE04	Category Code - Equipment 04	String	UDC (17 B4)	10	0	Allow NULL?
157	ZAZE05	Category Code - Equipment 05	String	UDC (17 B5)	10	0	Allow NULL?
158	ZAZE06	Category Code - Equipment 06	String	UDC (17 B6)	10	0	Allow NULL?
159	ZAZE07	Category Code - Equipment 07	String	UDC (17 B7)	10	0	Allow NULL?
160	ZAZE08	Category Code - Equipment 08	String	UDC (17 B8)	10	0	Allow NULL?
161	ZAZE09	Category Code - Equipment 09	String	UDC (17 B9)	10	0	Allow NULL?
162	ZAZE10	Category Code - Equipment 10	String	UDC (17 B0)	10	0	Allow NULL?
163	ZAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
164	ZAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
165	ZAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
166	ZAURDT	User Reserved Date	Date	Generic Edit	6	0
167	ZAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
168	ZAEFFT	Effective - Thru Date	Date	Generic Edit	6	0
169	ZACRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
170	ZAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
171	ZAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
172	ZAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
173	ZATYPS	Type - W.O.	Character	UDC (00 TY)	1	0	Allow NULL?
174	ZACRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
175	ZACRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
176	ZAPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
177	ZABLCN	Billable Units	Numeric	Generic Edit	15	4	Allow NULL?
178	ZAUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
179	ZAAMTFD	Domestic Flat Rate Amount	Numeric	Generic Edit	15	2	Allow NULL?
180	ZAAMTFF	Foreign Flat Rate Amount	Numeric	Generic Edit	15	2	Allow NULL?
181	ZAPCOVR	Percent Covered	Numeric	Generic Edit	5	2	Allow NULL?
182	ZAGWAFL	Goodwill Authorization Code Flag	Character	UDC (17 YN)	1	0	Allow NULL?
183	ZAGWANC	Non-Covered Goodwill Authorization Code	String	UDC (41 9)	4	0	Allow NULL?
184	ZASERP	Service Package	String	Generic Edit	8	0	Allow NULL?
185	ZAANOB	Address Number - Owner Billing	Numeric	Generic Edit	8	0	Allow NULL?
186	ZAUSA5	Address Number - Send To	Numeric	Generic Edit	8	0	Allow NULL?
187	ZAVR01	Reference	String	Generic Edit	25	0	Allow NULL?
188	ZAMINHR	Minimum Hours	Numeric	Generic Edit	9	2	Allow NULL?
189	ZAMINAD	Minimum Domestic Amount	Numeric	Generic Edit	15	2	Allow NULL?
190	ZAMINAF	Minimum Foreign Amount	Numeric	Generic Edit	15	2	Allow NULL?
191	ZADSFT	Discount Factor Type - $ or % (D/P)	Character	UDC (H41 DS)	1	0	Allow NULL?
192	ZADSPC	Discount Percent	Numeric	Generic Edit	8	3	Allow NULL?
193	ZAIDSC	Amount - Invoice Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
194	ZACIDS	Amount - Foreign Invoice Discount Avail	Numeric	Generic Edit	15	2	Allow NULL?
195	ZAITAM	Amount - Invoice Tax	Numeric	Generic Edit	15	2	Allow NULL?
196	ZACITX	Amount - Foreign Invoice Tax	Numeric	Generic Edit	15	2	Allow NULL?
197	ZAJTAX	Amount - Journaled Tax	Numeric	Generic Edit	15	2	Allow NULL?
198	ZAJTXF	Amount - Journaled Tax - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
199	ZAAMTCD	Domestic Credit Amount	Numeric	Generic Edit	15	2	Allow NULL?
200	ZAAMTCF	Foreign Credit Amount	Numeric	Generic Edit	15	2	Allow NULL?
201	ZAATXCD	Domestic Credit Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
202	ZAATXCF	Foreign Credit Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
203	ZAEFTJ	Date - Effective	Date	Generic Edit	6	0
204	ZAPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
205	ZARYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
206	ZATAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
207	ZATXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
208	ZAPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
209	ZAPRCNCT	Partner Contact	Variable String	Generic Edit	50	0	Allow NULL?
210	ZAPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
211	ZAEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?

TOP 910 | 17C | F1755 INDEXES

Number

Description

Call Number Status+ (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	STAW	Status	Ascending
3	UPMJ	Date - Updated	Ascending
4	UPMT	Time - Last Updated	Ascending

Call Type Issue Priority

Element	Alias	Description	Sequence
1	CT01	Case Type - 1	Ascending
2	PRIOR	Issue Priority	Ascending
3	UPMJ	Date - Updated	Ascending

Call Type Status Code

Element	Alias	Description	Sequence
1	CT01	Case Type - 1	Ascending
2	CLST	Case Status Code	Ascending

Customer

Element	Alias	Description	Sequence
1	ANC	Address Number - Customer Number	Ascending

Product Family Product Model

Element	Alias	Description	Sequence
1	PRODF	Product Family	Ascending
2	PRODM	Product Model	Ascending

Message ID

Element	Alias	Description	Sequence
1	SERK	Key Value Serial Number	Ascending

Equipment

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending

Item Number

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending

Call Number Document Type+

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending

Call Number Approval Status

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	STAW	Status	Ascending

Address Number Status+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	STAW	Status	Ascending
3	CLST	Case Status Code	Ascending
4	SCALL	Call Backs	Descending
5	DOCO	Document (Order No Invoice etc.)	Descending
6	PRIOR	Issue Priority	Descending

Call Queue Status+

Element	Alias	Description	Sequence
1	CALLQ	Case Provider Group	Ascending
2	STAW	Status	Ascending
3	EFTB	Date - Beginning Effective	Ascending
4	SCALL	Call Backs	Descending
5	DOCO	Document (Order No Invoice etc.)	Descending
6	PRIOR	Issue Priority	Descending

Customer Number Status+

Element	Alias	Description	Sequence
1	ANC	Address Number - Customer Number	Ascending
2	STAW	Status	Ascending
3	SCALL	Call Backs	Descending
4	DOCO	Document (Order No Invoice etc.)	Descending
5	PRIOR	Issue Priority	Descending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

211 COLUMNS | 13 INDEXES | 910 | 17C | F1755 TABLE

TOP 910 | 17C | F1755 COLUMNS

TOP 910 | 17C | F1755 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

211 COLUMNS | 13 INDEXES | 910 | 17C | F1755 TABLE

TOP910 | 17C | F1755 COLUMNS

TOP910 | 17C | F1755 INDEXES

TOP 910 | 17C | F1755 COLUMNS

TOP 910 | 17C | F1755 INDEXES