	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

83 COLUMNS | 4 INDEXES | 910 | 13C | F1310 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
13C: Condition-Base Maintenance
1	910	F1310	CA	83	4	Condition-Based Alerts	Files	13C: Condition-Base Maintenance

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 CAUKID, CANUMB, CAAPID, CAASID, CAMELC, CAAN8, CALANO, CALOC, CAEQST, CATYRP, CASRVT, CADOCO, CADL01, CAEVTDT, CAEVTTM, CAEVTUTC, CATIMEZONES, CADSAVNAME, CAQTST, CAQSPC, CADSC1, CAQVAL, CAQPF, CATOVR, CAANO, CAPDFL, CADQLT, CAPNST, CAPMUKID, CAWONA, CASNDN, CANOTR, CANSTT, CAASTC, CASNDV, CAINVR, CAISTT, CAIVCP, CAISSUE, CASEST, CASCHSTTIME, CAVR01, CAVR02, CAWHO2, CAAR1, CAPHN1, CAADD1, CAADD2, CAADD3, CAADD4, CACTY1, CAADDS, CAADDZ, CACOUN, CACTR, CAURAB, CAURAT, CAURCD, CAURDT, CAURRF, CACBURCH1, CACBURCH2, CACBURDT1, CACBURDT2, CACBURMN1, CACBURMN2, CACBURAB1, CACBURAB2, CACBURST1, CACBURST2, CACBURST3, CACBURST4, CACBURST5, CACBURST6, CACBURST7, CACBURST8, CACBURST9, CACBURST0, CAUSER, CAPID, CAMKEY, CAUPMJ, CAUPMT FROM F1310

TOP 910 | 13C | F1310 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CAUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	CANUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
3	CAAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
4	CAASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
5	CAMELC	Measurement Location	String	UDC (13 LC)	10	0	Allow NULL?
6	CAAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
7	CALANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	0	Allow NULL?
8	CALOC	Business Unit - Location	String	Generic Edit	12	0	Allow NULL?
9	CAEQST	Equipment Status	String	UDC (12 ES)	2	0	Allow NULL?
10	CATYRP	Automated Response Type	Character	UDC (13 AR)	1	0	Allow NULL?
11	CASRVT	Service Type	String	UDC (12 ST)	8	0	Allow NULL?
12	CADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
13	CADL01	Description	String	Generic Edit	30	0	Allow NULL?
14	CAEVTDT	Event Date	Date	Generic Edit	6	0
15	CAEVTTM	Event Time	Numeric	Generic Edit	6	0	Allow NULL?
16	CAEVTUTC	Event Time UTC	Numeric	Generic Edit	15	0	Allow NULL?
17	CATIMEZONES	Time Zone List	String	UDC (H91 TZ)	2	0	Allow NULL?
18	CADSAVNAME	Daylight Savings Rule Name	String	UDC	10	0	Allow NULL?
19	CAQTST	Test ID	String	Generic Edit	25	0	Allow NULL?
20	CAQSPC	Specification	String	Generic Edit	25	0	Allow NULL?
21	CADSC1	Description	String	Generic Edit	30	0	Allow NULL?
22	CAQVAL	Test Value	String	Generic Edit	15	0	Allow NULL?
23	CAQPF	Pass/Fail (P/F)	Character	Generic Edit	1	0	Allow NULL?
24	CATOVR	Test override flag	Character	Generic Edit	1	0	Allow NULL?
25	CAANO	Address Number - Originator	Numeric	Generic Edit	8	0	Allow NULL?
26	CAPDFL	Alert Level	Character	UDC (13 AL)	1	0	Allow NULL?
27	CADQLT	Data Quality	Character	UDC (13 DQ)	1	0	Allow NULL?
28	CAPNST	Date - Planned Start (Julian)	Date	Generic Edit	6	0
29	CAPMUKID	PM Unique ID	Numeric	Generic Edit	15	0	Allow NULL?
30	CAWONA	Work Order Number Assigned	Numeric	Generic Edit	8	0	Allow NULL?
31	CASNDN	Send Notification Message	Character	Generic Edit	1	0	Allow NULL?
32	CANOTR	Notification Recipient	Numeric	Generic Edit	8	0	Allow NULL?
33	CANSTT	Notification Structure Type	String	UDC (01 TS)	3	0	Allow NULL?
34	CAASTC	Alert Status	Character	UDC (13 AS)	1	0	Allow NULL?
35	CASNDV	Investigation Message Sent	Character	Generic Edit	1	0	Allow NULL?
36	CAINVR	Investigation Recipient	Numeric	Generic Edit	8	0	Allow NULL?
37	CAISTT	Investigation Structure Type	String	UDC (01 TS)	3	0	Allow NULL?
38	CAIVCP	Investigation Completed	Character	Generic Edit	1	0	Allow NULL?
39	CAISSUE	Problem Description	String	Generic Edit	80	0	Allow NULL?
40	CASEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
41	CASCHSTTIME	Scheduled Start ANSI C UTC Time	Numeric	Generic Edit	15	0	Allow NULL?
42	CAVR01	Reference	String	Generic Edit	25	0	Allow NULL?
43	CAVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
44	CAWHO2	Contact Name 2	String	Generic Edit	40	0	Allow NULL?
45	CAAR1	Phone Prefix	String	Generic Edit	6	0	Allow NULL?
46	CAPHN1	Phone Number	String	Generic Edit	20	0	Allow NULL?
47	CAADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
48	CAADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
49	CAADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
50	CAADD4	Address Line 4	String	Generic Edit	40	0	Allow NULL?
51	CACTY1	City	String	Generic Edit	25	0	Allow NULL?
52	CAADDS	State	String	UDC (00 S)	3	0	Allow NULL?
53	CAADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
54	CACOUN	County	String	UDC (00 CT)	25	0	Allow NULL?
55	CACTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
56	CAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
57	CAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
58	CAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
59	CAURDT	User Reserved Date	Date	Generic Edit	6	0
60	CAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
61	CACBURCH1	User Reserved Char 01	Character	Generic Edit	1	0	Allow NULL?
62	CACBURCH2	User Reserved Char 02	Character	Generic Edit	1	0	Allow NULL?
63	CACBURDT1	User Reserved Date 01	Date	Generic Edit	6	0
64	CACBURDT2	User Reserved Date 02	Date	Generic Edit	6	0
65	CACBURMN1	User Reserved Numeric 01	Numeric	Generic Edit	15	4	Allow NULL?
66	CACBURMN2	User Reserved Numeric 02	Numeric	Generic Edit	15	4	Allow NULL?
67	CACBURAB1	User Reserved Number 01	Numeric	Generic Edit	8	0	Allow NULL?
68	CACBURAB2	User Reserved Number 02	Numeric	Generic Edit	8	0	Allow NULL?
69	CACBURST1	User Reserved String 01	String	Generic Edit	5	0	Allow NULL?
70	CACBURST2	User Reserved String 02	String	Generic Edit	5	0	Allow NULL?
71	CACBURST3	User Reserved String 03	String	Generic Edit	15	0	Allow NULL?
72	CACBURST4	User Reserved String 04	String	Generic Edit	15	0	Allow NULL?
73	CACBURST5	User Reserved String 05	String	Generic Edit	30	0	Allow NULL?
74	CACBURST6	User Reserved String 06	String	Generic Edit	30	0	Allow NULL?
75	CACBURST7	User Reserved String 07	String	Generic Edit	30	0	Allow NULL?
76	CACBURST8	User Reserved String 08	String	Generic Edit	80	0	Allow NULL?
77	CACBURST9	User Reserved String 09	String	Generic Edit	80	0	Allow NULL?
78	CACBURST0	User Reserved String 10	String	Generic Edit	80	0	Allow NULL?
79	CAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
80	CAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
81	CAMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
82	CAUPMJ	Date - Updated	Date	Generic Edit	6	0
83	CAUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 910 | 13C | F1310 INDEXES

Number

Description

Unique ID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

PM Unique ID

Element	Alias	Description	Sequence
1	PMUKID	PM Unique ID	Ascending

Asset Number

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending

Assigned Work Order

Element	Alias	Description	Sequence
1	WONA	Work Order Number Assigned	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

83 COLUMNS | 4 INDEXES | 910 | 13C | F1310 TABLE

TOP 910 | 13C | F1310 COLUMNS

TOP 910 | 13C | F1310 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

83 COLUMNS | 4 INDEXES | 910 | 13C | F1310 TABLE

TOP910 | 13C | F1310 COLUMNS

TOP910 | 13C | F1310 INDEXES

TOP 910 | 13C | F1310 COLUMNS

TOP 910 | 13C | F1310 INDEXES