	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

32 COLUMNS | 4 INDEXES | 920 | 15 | F1512 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Real Estate Management
1	920	F1512	NA	32	4	Billing Code Extension	Constants Files	15: Real Estate Management	Business Data

TOP 920 | 15 | F1512 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	NAGLC	G/L Offset	String	Generic Edit	4	Allow NULL?
2	NAMCU	Business Unit	String	Generic Edit	12	Allow NULL?
3	NADL01	Description	String	Generic Edit	30	Allow NULL?
4	NAGRPC	Subject to GPR	Character	Generic Edit	1	Allow NULL?
5	NATNAR	Bill to Tenant	Character	Generic Edit	1	Allow NULL?
6	NALTFE	Subject to Late Fees	Character	Generic Edit	1	Allow NULL?
7	NAMGFE	Subject to Management Fees	Character	Generic Edit	1	Allow NULL?
8	NAPRAP	Priority Tenant A/R Application	Numeric	Generic Edit	2	Allow NULL?
9	NAAPPC	Applicable Applications	Character	UDC (15 AP)	1	Allow NULL?
10	NAALLW	Rent Allowance	Character	Generic Edit	1	Allow NULL?
11	NACONS	Rent Concession	Character	Generic Edit	1	Allow NULL?
12	NAAUTS	Automatic Suspend	Character	Generic Edit	1	Allow NULL?
13	NASPCD	Spread Code	Character	UDC (15 SQ)	1	Allow NULL?
14	NASECG	Security Group	Character	UDC (15 SG)	1	Allow NULL?
15	NAGRPU	Unit Gross Potential	Character	Generic Edit	1	Allow NULL?
16	NABRAJ	Bill Receipt or Adjustment	Character	UDC (15 BR)	1	Allow NULL?
17	NASTAX	Subject to Sales Tax	Character	Generic Edit	1	Allow NULL?
18	NAAPLY	Apply to Aging	String	Generic Edit	4	Allow NULL?
19	NACMNT	Comment Required	Character	Generic Edit	1	Allow NULL?
20	NAADEP	Admin Expense Participation	Character	Generic Edit	1	Allow NULL?
21	NACLSS	Classification	String	Generic Edit	3	Allow NULL?
22	NAADJR	Adjustment Classifications	String	UDC (15 AD)	2	Allow NULL?
23	NAJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
24	NAUSER	User ID	String	Generic Edit	10	Allow NULL?
25	NAPID	Program ID	String	Generic Edit	10	Allow NULL?
26	NAUPMJ	Date - Updated	Date	Generic Edit	6
27	NATBL	Late Fee Table	String	Generic Edit	3	Allow NULL?
28	NAMGTF	Management Fee	Character	Generic Edit	1	Allow NULL?
29	NAICST	Include on Statement (Y/N)	Character	Generic Edit	1	Allow NULL?
30	NARNTC	Rent Category	Character	Generic Edit	1	Allow NULL?
31	NAPJCC	PRO-JECT Bill Code No.	Numeric	Generic Edit	4	Allow NULL?
32	NAUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

TOP 920 | 15 | F1512 INDEXES

Number

Description

Bill Code Business Unit (Primary/Unique)

Element	Alias	Description	Sequence
1	GLC	G/L Offset	Ascending
2	MCU	Business Unit	Ascending

Classification App App +

Element	Alias	Description	Sequence
1	CLSS	Classification	Ascending
2	APPC	Applicable Applications	Ascending
3	MCU	Business Unit	Ascending

Business Unit

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending

PRO-JECT Bill Code No.

Element	Alias	Description	Sequence
1	PJCC	PRO-JECT Bill Code No.	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

32 COLUMNS | 4 INDEXES | 920 | 15 | F1512 TABLE

TOP 920 | 15 | F1512 COLUMNS

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

32 COLUMNS | 4 INDEXES | 920 | 15 | F1512 TABLE

TOP920 | 15 | F1512 COLUMNS

TOP920 | 15 | F1512 INDEXES

TOP 920 | 15 | F1512 COLUMNS

TOP 920 | 15 | F1512 INDEXES