	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	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

60 COLUMNS | 8 INDEXES | 812 | 01 | F01301D TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
01: Address Book
1	812	F01301D	AD	60	8	Activity Detail	Files	01: Address Book

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 ADINSTID, ADACTIVID, ADINDID, ADINDIDTY, ADCALTY, ADPACTVID, ADACTVTYP, ADSUBJECT, ADACTVDESC, ADLOCATION, ADORIGNTOR, ADTDSTR, ADTDEND, ADALRM, ADLEADTIME, ADLEADTMEU, ADACTCAT, ADACTVPSF, ADCOMITLVL, ADADI, ADRECURID, ADRCCUR, ADACTPRV, ADACTCMPL, ADTDCMPL, ADINTE, ADSTPIM, ADDOCAL, ADACCNT, ADPARTN, ADACCNTC, ADPARTNC, ADPLNTY, ADISTODO, ADATVCD1, ADATVCD2, ADATVCD3, ADATVCD4, ADATVCD5, ADURCH, ADURNUM, ADDOCO, ADURTIME, ADIDAN8, ADUDTTM, ADUSER, ADEDATE, ADMKEY, ADENTDBY, ADPID, ADOWNERID, ADOWNERIDT, ADOWNCALT, ADANOMALY, ADLEADID, ADOPPID, ADACSTS, ADOUTRES, ADACTINST, ADCO FROM F01301D

TOP 812 | 01 | F01301D COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ADINSTID	Instance Identifier	String	Generic Edit	36	0	Allow NULL?
2	ADACTIVID	Activity ID	String	Generic Edit	36	0	Allow NULL?
3	ADINDID	Identifier ID	String	Generic Edit	16	0	Allow NULL?
4	ADINDIDTY	Identifier ID Type	String	UDC (01 IT)	50	0	Allow NULL?
5	ADCALTY	Calendar Type	String	UDC (01 CY)	50	0	Allow NULL?
6	ADPACTVID	Group Activity ID	String	Generic Edit	37	0	Allow NULL?
7	ADACTVTYP	Activity Type	String	UDC (01 AC)	41	0	Allow NULL?
8	ADSUBJECT	Subject	String	Generic Edit	51	0	Allow NULL?
9	ADACTVDESC	Description	String	Generic Edit	1999	0	Allow NULL?
10	ADLOCATION	Location	String	Generic Edit	51	0	Allow NULL?
11	ADORIGNTOR	Originator	Numeric	Generic Edit	8	0	Allow NULL?
12	ADTDSTR	Time Date Start	JDE UTime	Generic Edit	11	0
13	ADTDEND	Time Date End	JDE UTime	Generic Edit	11	0
14	ADALRM	Alarm for activity	Character	Generic Edit	1	0	Allow NULL?
15	ADLEADTIME	Lead Time	Numeric	Generic Edit	8	0	Allow NULL?
16	ADLEADTMEU	Lead Time Unit	String	UDC (01 LT)	41	0	Allow NULL?
17	ADACTCAT	Category	String	UDC (01 CG)	51	0	Allow NULL?
18	ADACTVPSF	Activity Post Synchronization Flag	Character	Generic Edit	1	0	Allow NULL?
19	ADCOMITLVL	Commitment Level	Numeric	UDC (01 PT)	1	0	Allow NULL?
20	ADADI	All Day Indicator	Character	Generic Edit	1	0	Allow NULL?
21	ADRECURID	Recurrence ID	String	Generic Edit	36	0	Allow NULL?
22	ADRCCUR	Recurrence master flag	Character	Generic Edit	1	0	Allow NULL?
23	ADACTPRV	Private Activity	Character	Generic Edit	1	0	Allow NULL?
24	ADACTCMPL	Completed Activity	Character	Generic Edit	1	0	Allow NULL?
25	ADTDCMPL	Date Completed	JDE UTime	Generic Edit	11	0
26	ADINTE	Internal origination	Character	Generic Edit	1	0	Allow NULL?
27	ADSTPIM	Synch to PIM server	Character	Generic Edit	1	0	Allow NULL?
28	ADDOCAL	Display Activity On Calendar	Character	Generic Edit	1	0	Allow NULL?
29	ADACCNT	Address Book1 for an activity	Numeric	Generic Edit	8	0	Allow NULL?
30	ADPARTN	Address Book2 for an activity	Numeric	Generic Edit	8	0	Allow NULL?
31	ADACCNTC	Address Book1 Contact for an activity	Numeric	Generic Edit	8	0	Allow NULL?
32	ADPARTNC	Address Book2 contact for an activity	Numeric	Generic Edit	8	0	Allow NULL?
33	ADPLNTY	Plan type for an activity	String	UDC (01 PL)	3	0	Allow NULL?
34	ADISTODO	Is To Do	Character	Generic Edit	1	0	Allow NULL?
35	ADATVCD1	Category Code 1	String	UDC (01 AD)	3	0	Allow NULL?
36	ADATVCD2	Category Code 2	String	UDC (01 AE)	3	0	Allow NULL?
37	ADATVCD3	Category Code 3	String	UDC (01 AF)	3	0	Allow NULL?
38	ADATVCD4	Category Code 4	String	UDC (01 AG)	3	0	Allow NULL?
39	ADATVCD5	Category Code 5	String	UDC (01 AH)	3	0	Allow NULL?
40	ADURCH	Time Zone	String	Generic Edit	50	0	Allow NULL?
41	ADURNUM	User Reserved Numeric	Numeric	Generic Edit	8	0	Allow NULL?
42	ADDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
43	ADURTIME	User Reserved Time	JDE UTime	Generic Edit	11	0
44	ADIDAN8	Identifier AN8	Numeric	Generic Edit	8	0	Allow NULL?
45	ADUDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0
46	ADUSER	User ID	String	Generic Edit	10	0	Allow NULL?
47	ADEDATE	Date Entered	JDE UTime	Generic Edit	11	0
48	ADMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
49	ADENTDBY	Entered By	Numeric	Generic Edit	8	0	Allow NULL?
50	ADPID	Program ID	String	Generic Edit	10	0	Allow NULL?
51	ADOWNERID	Owner Identifier	String	Generic Edit	16	0	Allow NULL?
52	ADOWNERIDT	Owner Identifier Type	String	UDC (01 IT)	50	0	Allow NULL?
53	ADOWNCALT	Owner Calendar Type	String	UDC (01 CY)	50	0	Allow NULL?
54	ADANOMALY	Anomaly Flag	Character	Generic Edit	1	0	Allow NULL?
55	ADLEADID	Lead Id	Numeric	Generic Edit	15	0	Allow NULL?
56	ADOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
57	ADACSTS	Activity Processed	Character	Generic Edit	1	0	Allow NULL?
58	ADOUTRES	Activity Result	String	UDC (01 OR)	10	0	Allow NULL?
59	ADACTINST	Activity Instance	Numeric	Generic Edit	15	2	Allow NULL?
60	ADCO	Company	String	Generic Edit	5	0	Allow NULL?

TOP 812 | 01 | F01301D INDEXES

Number

Description

Instance ID (Primary/Unique)

Element	Alias	Description	Sequence
1	INSTID	Instance Identifier	Ascending

Activity ID Instance

Element	Alias	Description	Sequence
1	ACTIVID	Activity ID	Ascending
2	ACTINST	Activity Instance	Ascending

GroupID Anomaly Instance

Element	Alias	Description	Sequence
1	PACTVID	Group Activity ID	Ascending
2	ANOMALY	Anomaly Flag	Ascending
3	ACTINST	Activity Instance	Ascending

Case ID

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

Lead ID

Element	Alias	Description	Sequence
1	LEADID	Lead Id	Ascending

Opportunity ID

Element	Alias	Description	Sequence
1	OPPID	Opportunity Number	Ascending

Customer ID

Element	Alias	Description	Sequence
1	ACCNT	Address Book1 for an activity	Ascending
2	CO	Company	Ascending
3	ACCNTC	Address Book1 Contact for an activity	Ascending

Partner ID

Element	Alias	Description	Sequence
1	PARTN	Address Book2 for an activity	Ascending
2	PARTNC	Address Book2 contact for an activity	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

60 COLUMNS | 8 INDEXES | 812 | 01 | F01301D TABLE

TOP 812 | 01 | F01301D COLUMNS

TOP 812 | 01 | F01301D 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

60 COLUMNS | 8 INDEXES | 812 | 01 | F01301D TABLE

TOP812 | 01 | F01301D COLUMNS

TOP812 | 01 | F01301D INDEXES

TOP 812 | 01 | F01301D COLUMNS

TOP 812 | 01 | F01301D INDEXES