	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

93 COLUMNS | 5 INDEXES | 920 | 17C | F1760 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
17C: Call Management
1	920	F1760	ZB	93	5	Time Entry	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 ZBDOCO, ZBSBLT, ZBLNID, ZBOPSQ, ZBDCTO, ZBKCO, ZBAN8, ZBSTRT, ZBSTRX, ZBPBTM, ZBPETM, ZBRCK7, ZBDSC1, ZBPHRW, ZBDATE, ZBANI, ZBHMCU, ZBOBJ, ZBSUB, ZBWRKT, ZBPBRT, ZBASN3, ZBBILL, ZBDTBIL, ZBCRRM, ZBCRDC, ZBCRCD, ZBACR, ZBAG, ZBAMTO, ZBFAP, ZBHRSO, ZBCOST, ZBMCUZ, ZBPDBA, ZBURAB, ZBURCD, ZBURAT, ZBURDT, ZBURRF, ZBCRTU, ZBUSER, ZBUPMJ, ZBUPMT, ZBJOBN, ZBPID, ZBPCOVR, ZBCOVGR, ZBGLCCV, ZBGLCNC, ZBGWAFL, ZBGWAUT, ZBGWANC, ZBENTCK, ZBUM, ZBCCR, ZBTBDT, ZBHRBL, ZBPHRT, ZBARTBD, ZBARTBF, ZBANC, ZBLANO, ZBANOB, ZBUSA5, ZBVR01, ZBMINHR, ZBMINAD, ZBMINAF, ZBDSFT, ZBDSPC, ZBIDSC, ZBCIDS, ZBITAM, ZBCITX, ZBJTAX, ZBJTXF, ZBAMTCD, ZBAMTCF, ZBATXCD, ZBATXCF, ZBEFTJ, ZBPTC, ZBRYIN, ZBTAX1, ZBTXA1, ZBEXR1, ZBMTHPR, ZBCRR, ZBPEFJ, ZBCO, ZBMCU, ZBDTWRK FROM F1760

TOP 920 | 17C | F1760 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZBDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	ZBSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
3	ZBLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
4	ZBOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
5	ZBDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	ZBKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
7	ZBAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
8	ZBSTRT	Date - Start (Julian)	Date	Generic Edit	6	0
9	ZBSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
10	ZBPBTM	Time - Beginning (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
11	ZBPETM	Time - Ending (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
12	ZBRCK7	Line Number ID - 5.0	Numeric	Generic Edit	5	0	Allow NULL?
13	ZBDSC1	Description	String	Generic Edit	30	0	Allow NULL?
14	ZBPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
15	ZBDATE	System Date	String	Generic Edit	8	0	Allow NULL?
16	ZBANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
17	ZBHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
18	ZBOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
19	ZBSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
20	ZBWRKT	Work Type	String	UDC (17 WT)	2	0	Allow NULL?
21	ZBPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
22	ZBASN3	Price and Adjustment Schedule-Cases	String	UDC (40 AS)	8	0	Allow NULL?
23	ZBBILL	Billable (Y/N)	Character	UDC (H00 BI)	1	0	Allow NULL?
24	ZBDTBIL	Date - Billed	Date	Generic Edit	6	0
25	ZBCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
26	ZBCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
27	ZBCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
28	ZBACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
29	ZBAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
30	ZBAMTO	Amount - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
31	ZBFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
32	ZBHRSO	Hours - Estimated	Numeric	Generic Edit	15	2	Allow NULL?
33	ZBCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
34	ZBMCUZ	Business Unit - Alt	String	Generic Edit	12	0	Allow NULL?
35	ZBPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
36	ZBURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
37	ZBURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
38	ZBURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	ZBURDT	User Reserved Date	Date	Generic Edit	6	0
40	ZBURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
41	ZBCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
42	ZBUSER	User ID	String	Generic Edit	10	0	Allow NULL?
43	ZBUPMJ	Date - Updated	Date	Generic Edit	6	0
44	ZBUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
45	ZBJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
46	ZBPID	Program ID	String	Generic Edit	10	0	Allow NULL?
47	ZBPCOVR	Percent Covered	Numeric	Generic Edit	5	2	Allow NULL?
48	ZBCOVGR	Coverage Group	String	UDC (17 CG)	8	0	Allow NULL?
49	ZBGLCCV	Category - G/L Covered	String	UDC (41 9)	4	0	Allow NULL?
50	ZBGLCNC	Category - G/L Non-Covered	String	UDC (41 9)	4	0	Allow NULL?
51	ZBGWAFL	Goodwill Authorization Code Flag	Character	UDC (17 YN)	1	0	Allow NULL?
52	ZBGWAUT	Goodwill Authorization	String	UDC (41 9)	4	0	Allow NULL?
53	ZBGWANC	Non-Covered Goodwill Authorization Code	String	UDC (41 9)	4	0	Allow NULL?
54	ZBENTCK	Entitlement Check	String	UDC (17 ER)	3	0	Allow NULL?
55	ZBUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
56	ZBCCR	Component Cost Rate Table	String	Generic Edit	10	0	Allow NULL?
57	ZBTBDT	Date - Table Basis (Julian)	Date	Generic Edit	6	0
58	ZBHRBL	Hours Billed	Numeric	Generic Edit	15	2	Allow NULL?
59	ZBPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
60	ZBARTBD	Domestic Billing Rate	Numeric	Generic Edit	15	2	Allow NULL?
61	ZBARTBF	Foreign Billing Rate	Numeric	Generic Edit	15	2	Allow NULL?
62	ZBANC	Address Number - Customer Number	Numeric	Generic Edit	8	0	Allow NULL?
63	ZBLANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	0	Allow NULL?
64	ZBANOB	Address Number - Owner Billing	Numeric	Generic Edit	8	0	Allow NULL?
65	ZBUSA5	Address Number - Send To	Numeric	Generic Edit	8	0	Allow NULL?
66	ZBVR01	Reference	String	Generic Edit	25	0	Allow NULL?
67	ZBMINHR	Minimum Hours	Numeric	Generic Edit	9	2	Allow NULL?
68	ZBMINAD	Minimum Domestic Amount	Numeric	Generic Edit	15	2	Allow NULL?
69	ZBMINAF	Minimum Foreign Amount	Numeric	Generic Edit	15	2	Allow NULL?
70	ZBDSFT	Discount Factor Type - $ or % (D/P)	Character	UDC (H41 DS)	1	0	Allow NULL?
71	ZBDSPC	Discount Percent	Numeric	Generic Edit	8	3	Allow NULL?
72	ZBIDSC	Amount - Invoice Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
73	ZBCIDS	Amount - Foreign Invoice Discount Avail	Numeric	Generic Edit	15	2	Allow NULL?
74	ZBITAM	Amount - Invoice Tax	Numeric	Generic Edit	15	2	Allow NULL?
75	ZBCITX	Amount - Foreign Invoice Tax	Numeric	Generic Edit	15	2	Allow NULL?
76	ZBJTAX	Amount - Journaled Tax	Numeric	Generic Edit	15	2	Allow NULL?
77	ZBJTXF	Amount - Journaled Tax - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
78	ZBAMTCD	Domestic Credit Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	ZBAMTCF	Foreign Credit Amount	Numeric	Generic Edit	15	2	Allow NULL?
80	ZBATXCD	Domestic Credit Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
81	ZBATXCF	Foreign Credit Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
82	ZBEFTJ	Date - Effective	Date	Generic Edit	6	0
83	ZBPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
84	ZBRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
85	ZBTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
86	ZBTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
87	ZBEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
88	ZBMTHPR	Method of Pricing	Character	UDC (17 MP)	1	0	Allow NULL?
89	ZBCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
90	ZBPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
91	ZBCO	Company	String	Generic Edit	5	0	Allow NULL?
92	ZBMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
93	ZBDTWRK	Date - Worked (Julian)	Date	Generic Edit	6	0

TOP 920 | 17C | F1760 INDEXES

Number

Description

Order Number Subledger Type + (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SBLT	Subledger Type	Ascending
3	LNID	Line Number	Ascending

Order No Subledger Type +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SBLT	Subledger Type	Ascending
3	AN8	Address Number	Ascending

Address No Order No +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	SBLT	Subledger Type	Ascending
4	LNID	Line Number	Ascending

Order No Subledger Type +B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SBLT	Subledger Type	Ascending
3	DTBIL	Date - Billed	Ascending

Order No Subledger Type +C

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	SBLT	Subledger Type	Ascending
3	TBDT	Date - Table Basis (Julian)	Ascending

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

93 COLUMNS | 5 INDEXES | 920 | 17C | F1760 TABLE

TOP 920 | 17C | F1760 COLUMNS

TOP 920 | 17C | F1760 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

93 COLUMNS | 5 INDEXES | 920 | 17C | F1760 TABLE

TOP920 | 17C | F1760 COLUMNS

TOP920 | 17C | F1760 INDEXES

TOP 920 | 17C | F1760 COLUMNS

TOP 920 | 17C | F1760 INDEXES