	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

79 COLUMNS | 2 INDEXES | 920 | 15 | F1543B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Real Estate Management
1	920	F1543B	OA	79	2	Tenant Sales Analysis Reporting File	Balance Files	15: Real Estate 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 OASASC, OACTRY, OAYR, OARPRD, OAMCU, OAAN8, OAUNIT, OADBAN, OAPRDC, OAMCUS, OACO, OADOCO, OAFLOR, OAULI, OAULI2, OARM11, OARM12, OARM13, OARM14, OARM15, OARM21, OARM22, OARM23, OARM24, OARM25, OALSST, OALSET, OAMSTY, OAMSLY, OAMSCH, OAMFTY, OAMFLY, OAMFCH, OAMFPC, OAQSTY, OAQSLY, OAQSCH, OAQFTY, OAQFLY, OAQFCH, OAQFPC, OAYSTY, OAYSLY, OAYSCH, OAYFTY, OAYFLY, OAYFCH, OAYFPC, OASFTY, OASFLY, OANEMO, OANCSF, OAACSF, OANEMQ, OANCSQ, OAACSQ, OANEMY, OANCSY, OAACSY, OAPYSL, OARTMS, OANEMP, OACNTF, OACOL1, OACOL2, OAURCD, OAURDT, OAURAT, OAURAB, OAURRF, OAUSER, OAPID, OAUPMJ, OAUPMT, OAJOBN, OACRCD, OACRR, OADS40, OACRRM FROM F1543B

TOP 920 | 15 | F1543B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	OASASC	Summary Code - Sales Analysis	String	Generic Edit	2	0	Allow NULL?
2	OACTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
3	OAYR	Year - Calendar Year	Numeric	Generic Edit	2	0	Allow NULL?
4	OARPRD	Sales Report Period	Numeric	Generic Edit	2	0	Allow NULL?
5	OAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	OAAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
7	OAUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
8	OADBAN	Doing Business As	Numeric	Generic Edit	8	0	Allow NULL?
9	OAPRDC	Product Code	String	UDC (15 PC)	4	0	Allow NULL?
10	OAMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
11	OACO	Company	String	Generic Edit	5	0	Allow NULL?
12	OADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
13	OAFLOR	Number - Floor	String	UDC (15 FL)	4	0	Allow NULL?
14	OAULI	ULI Code	String	UDC (15 UL)	8	0	Allow NULL?
15	OAULI2	Tenant Sales Category	String	UDC (15 UL)	8	0	Allow NULL?
16	OARM11	Reporting Code - Property Management 11	String	UDC (15 11)	4	0	Allow NULL?
17	OARM12	Reporting Code - Property Management 12	String	UDC (15 12)	4	0	Allow NULL?
18	OARM13	Reporting Code - Property Management 13	String	UDC (15 13)	4	0	Allow NULL?
19	OARM14	Reporting Code - Property Management 14	String	UDC (15 14)	4	0	Allow NULL?
20	OARM15	Reporting Code - Property Management 15	String	UDC (15 15)	4	0	Allow NULL?
21	OARM21	Reporting Code - Property Management 21	String	UDC (15 21)	4	0	Allow NULL?
22	OARM22	Reporting Code - Property Management 22	String	UDC (15 22)	4	0	Allow NULL?
23	OARM23	Reporting Code - Property Management 23	String	UDC (15 23)	4	0	Allow NULL?
24	OARM24	Reporting Code - Property Management 24	String	UDC (15 24)	4	0	Allow NULL?
25	OARM25	Reporting Code - Property Management 25	String	UDC (15 25)	4	0	Allow NULL?
26	OALSST	Lease Status	Character	UDC (15 LS)	1	0	Allow NULL?
27	OALSET	Lease Type	String	UDC (15 LT)	2	0	Allow NULL?
28	OAMSTY	Amount - This Years Monthly Sales	Numeric	Generic Edit	15	2	Allow NULL?
29	OAMSLY	Amount - Last Years Monthly Sales	Numeric	Generic Edit	15	2	Allow NULL?
30	OAMSCH	Amount - Change In Monthly Sales	Numeric	Generic Edit	15	2	Allow NULL?
31	OAMFTY	Amount - This Years Monthly Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
32	OAMFLY	Amount - Last Years Monthly Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
33	OAMFCH	Amount - Change In Monthly Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
34	OAMFPC	Percent Change - Monthly Sales	Numeric	Generic Edit	5	0	Allow NULL?
35	OAQSTY	Amount - This Years Quarterly Sales	Numeric	Generic Edit	15	2	Allow NULL?
36	OAQSLY	Amount - Last Years Quarterly Sales	Numeric	Generic Edit	15	2	Allow NULL?
37	OAQSCH	Amount - Change In Quarterly Sales	Numeric	Generic Edit	15	2	Allow NULL?
38	OAQFTY	Amount -This Years Quarterly Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
39	OAQFLY	Amount -Last Years Quarterly Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
40	OAQFCH	Amount - Change In Quarterly Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
41	OAQFPC	Percent Change - Quarterly Sales	Numeric	Generic Edit	5	0	Allow NULL?
42	OAYSTY	Amount - This Year YTD Sales	Numeric	Generic Edit	15	2	Allow NULL?
43	OAYSLY	Amount - Last Years YTD Sales	Numeric	Generic Edit	15	2	Allow NULL?
44	OAYSCH	Amount - Change In YTD Sales	Numeric	Generic Edit	15	2	Allow NULL?
45	OAYFTY	Amount -This Years YTD Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
46	OAYFLY	Amount -Last Years Y-T-D Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
47	OAYFCH	Amount - Change In YTD Sales/Sq Ft	Numeric	Generic Edit	15	2	Allow NULL?
48	OAYFPC	Percent Change - YTD Sales	Numeric	Generic Edit	5	0	Allow NULL?
49	OASFTY	Square Feet - This Year	Numeric	Generic Edit	15	2	Allow NULL?
50	OASFLY	Square Feet - Last Year	Numeric	Generic Edit	15	2	Allow NULL?
51	OANEMO	Number of Empty Months	Numeric	Generic Edit	15	0	Allow NULL?
52	OANCSF	Net Change in Square Feet	Numeric	Generic Edit	15	2	Allow NULL?
53	OAACSF	Absolute Change in Square Feet	Numeric	Generic Edit	15	2	Allow NULL?
54	OANEMQ	Number of Empty Months - QTD	Numeric	Generic Edit	15	0	Allow NULL?
55	OANCSQ	Net Change in Square Feet QTD	Numeric	Generic Edit	15	2	Allow NULL?
56	OAACSQ	Absolute Change in Square Feet QTD	Numeric	Generic Edit	15	2	Allow NULL?
57	OANEMY	Number of Empty Months - YTD	Numeric	Generic Edit	15	0	Allow NULL?
58	OANCSY	Net Change in Square Feet YTD	Numeric	Generic Edit	15	2	Allow NULL?
59	OAACSY	Absolute Change in Square Feet YTD	Numeric	Generic Edit	15	2	Allow NULL?
60	OAPYSL	Amount - Prior Year Sales	Numeric	Generic Edit	15	2	Allow NULL?
61	OARTMS	Amount - Rolling Twelve Months Sales	Numeric	Generic Edit	15	2	Allow NULL?
62	OANEMP	Number of Empty Months - Prior Year	Numeric	Generic Edit	15	0	Allow NULL?
63	OACNTF	Count Field	Numeric	Generic Edit	15	0	Allow NULL?
64	OACOL1	Column 1 Heading	String	Generic Edit	15	0	Allow NULL?
65	OACOL2	Column 2 Heading	String	Generic Edit	15	0	Allow NULL?
66	OAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
67	OAURDT	User Reserved Date	Date	Generic Edit	6	0
68	OAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
69	OAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
70	OAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
71	OAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
72	OAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
73	OAUPMJ	Date - Updated	Date	Generic Edit	6	0
74	OAUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
75	OAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
76	OACRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
77	OACRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
78	OADS40	Description	String	Generic Edit	40	0	Allow NULL?
79	OACRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?

TOP 920 | 15 | F1543B INDEXES

Number

Description

Summary Code Century + (Primary/Unique)

Element	Alias	Description	Sequence
1	SASC	Summary Code - Sales Analysis	Ascending
2	CTRY	Century	Ascending
3	YR	Year - Calendar Year	Ascending
4	RPRD	Sales Report Period	Ascending
5	CO	Company	Ascending
6	MCUS	Business Unit - Subsequent	Ascending
7	MCU	Business Unit	Ascending
8	FLOR	Number - Floor	Ascending
9	UNIT	Unit	Ascending
10	AN8	Address Number	Ascending
11	DOCO	Document (Order No Invoice etc.)	Ascending
12	DBAN	Doing Business As	Ascending
13	PRDC	Product Code	Ascending
14	ULI	ULI Code	Ascending
15	ULI2	Tenant Sales Category	Ascending
16	DS40	Description	Ascending

Summary Code Company +

Element	Alias	Description	Sequence
1	SASC	Summary Code - Sales Analysis	Ascending
2	CO	Company	Ascending
3	MCUS	Business Unit - Subsequent	Ascending
4	MCU	Business Unit	Ascending
5	FLOR	Number - Floor	Ascending
6	UNIT	Unit	Ascending
7	AN8	Address Number	Ascending
8	DBAN	Doing Business As	Ascending
9	PRDC	Product Code	Ascending
10	ULI	ULI Code	Ascending
11	ULI2	Tenant Sales Category	Ascending
12	DS40	Description	Ascending
13	CTRY	Century	Ascending
14	YR	Year - Calendar Year	Ascending
15	RPRD	Sales Report Period	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

79 COLUMNS | 2 INDEXES | 920 | 15 | F1543B TABLE

TOP 920 | 15 | F1543B COLUMNS

TOP 920 | 15 | F1543B 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

79 COLUMNS | 2 INDEXES | 920 | 15 | F1543B TABLE

TOP920 | 15 | F1543B COLUMNS

TOP920 | 15 | F1543B INDEXES

TOP 920 | 15 | F1543B COLUMNS

TOP 920 | 15 | F1543B INDEXES