920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
75A: Australia - Reporting System Only
1	812	F75A0010	A0	85	1	Australian Employee Termination Details	Secondary Master Files	07: Payroll	No

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	A0AN8	Address Number	Numeric	UDC	8	0	Allow NULL?
2	A0DST	Data Item - Secondary	Date	Generic Edit	6	0
3	A0DT	Date - Terminated	Date	Generic Edit	6	0
4	A0OWTRS	Change Reason	String	UDC (06 T)	3	0	Allow NULL?
5	A0TERTYP	Termination Type	String	UDC (75 T1)	3	0	Allow NULL?
6	A0SKLFLG	Pay out sick Leave Flag	Character	Generic Edit	1	0	Allow NULL?
7	A0LSLFLG	Include LSL Flag	Character	Generic Edit	1	0	Allow NULL?
8	A0ETPFLG	ETP Rollover Flag	Character	Generic Edit	1	0	Allow NULL?
9	A0NTERPAY	Net Termination Pay	Numeric	Generic Edit	11	2	Allow NULL?
10	A0PERNOT	Period of Notice	Numeric	Generic Edit	9	2	Allow NULL?
11	A0STDGPAY	Standard Gross/Week	Numeric	Generic Edit	15	2	Allow NULL?
12	A0GRSSEV	Gross Severance	Numeric	Generic Edit	11	2	Allow NULL?
13	A0INCAMT	Incentive Amount	Numeric	Generic Edit	11	2	Allow NULL?
14	A0COMYSER	Completed Years Of Service	Numeric	Generic Edit	9	2	Allow NULL?
15	A0REDUAMT	Redundancy Amount	Numeric	Generic Edit	11	2	Allow NULL?
16	A0REDUTRH	Redundancy Threshold	Numeric	Generic Edit	11	2	Allow NULL?
17	A0TAXREDU	Taxable Redundancy	Numeric	Generic Edit	11	2	Allow NULL?
18	A0ULLHRS	Unused LL Hours	Numeric	Generic Edit	9	2	Allow NULL?
19	A0ULLVAL	Unused LL $	Numeric	Generic Edit	11	2	Allow NULL?
20	A0ALBHRS	Annual Leave Bal Hours	Numeric	Generic Edit	9	2	Allow NULL?
21	A0ALBVAL	Annual Leave Bal Value	Numeric	Generic Edit	11	2	Allow NULL?
22	A0ALBTAX	Annual Leave Bal Tax	Numeric	Generic Edit	11	2	Allow NULL?
23	A0USKHRS	Unused Sick Leave Hours	Numeric	Generic Edit	9	2	Allow NULL?
24	A0USKVAL	Unused Sick Leave Value	Numeric	Generic Edit	11	2	Allow NULL?
25	A0URDOHR	Unused RDO Balance Hours	Numeric	Generic Edit	9	2	Allow NULL?
26	A0URDOVL	Unused RDO Balance Value	Numeric	Generic Edit	11	2	Allow NULL?
27	A0BD1HRS	Band 1 LSL hours	Numeric	Generic Edit	9	2	Allow NULL?
28	A0BD1VAL	Band 1 Value	Numeric	Generic Edit	11	2	Allow NULL?
29	A0BD1TAX	Band 1 Tax	Numeric	Generic Edit	11	2	Allow NULL?
30	A0BD2HRS	Band 2 LSL hours	Numeric	Generic Edit	9	2	Allow NULL?
31	A0BD2VAL	Band 2 Value	Numeric	Generic Edit	11	2	Allow NULL?
32	A0BD2TAX	Band 2 Tax	Numeric	Generic Edit	11	2	Allow NULL?
33	A0BD3HRS	Band 3 LSL hours	Numeric	Generic Edit	9	2	Allow NULL?
34	A0BD3VAL	Band 3 Value	Numeric	Generic Edit	11	2	Allow NULL?
35	A0BD3TAX	Band 3 Tax	Numeric	Generic Edit	11	2	Allow NULL?
36	A0BD4HRS	Band 4 LSL hours	Numeric	Generic Edit	9	2	Allow NULL?
37	A0BD4VAL	Band 4 Value	Numeric	Generic Edit	11	2	Allow NULL?
38	A0BD4TAX	Band 4 Tax	Numeric	Generic Edit	11	2	Allow NULL?
39	A0PR83DAY	Pre 83 Days	Numeric	Generic Edit	5	0	Allow NULL?
40	A0PT83DAY	Post 83 Days	Numeric	Generic Edit	5	0	Allow NULL?
41	A0PR83VAL	Pre 83 Value	Numeric	Generic Edit	11	2	Allow NULL?
42	A0PT83VAL	Post 83 Value	Numeric	Generic Edit	11	2	Allow NULL?
43	A0ASSAMT	Assessable Amount	Numeric	Generic Edit	11	2	Allow NULL?
44	A0ROLAMT	Rollover Amount	Numeric	Generic Edit	11	2	Allow NULL?
45	A0ETPTAX	ETP tax deducted	Numeric	Generic Edit	11	2	Allow NULL?
46	A0ETPPAY	Net ETP pay	Numeric	Generic Edit	11	2	Allow NULL?
47	A0PAYFLG	Payment Made	Character	Generic Edit	1	0	Allow NULL?
48	A0ATOFLG	Extracted for ATO Flagr	Character	Generic Edit	1	0	Allow NULL?
49	A0RETDTE	Retirement Date	Date	Generic Edit	6	0
50	A0INVCOMP	Post 94 Invalidity	Numeric	Generic Edit	11	2	Allow NULL?
51	A0INVDAY	Post 94 Days	Numeric	Generic Edit	5	0	Allow NULL?
52	A0TAXFNO	Tax File Number	String	Generic Edit	11	0	Allow NULL?
53	A0ATTL	Professional Title	String	Generic Edit	40	0	Allow NULL?
54	A0SRNM	Name - Surname	String	Generic Edit	25	0	Allow NULL?
55	A0GNNM	Name - Given	String	Generic Edit	25	0	Allow NULL?
56	A0MDNM	Name - Middle	String	Generic Edit	25	0	Allow NULL?
57	A0ADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
58	A0ADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
59	A0CTY1	City	String	Generic Edit	25	0	Allow NULL?
60	A0ADDS	State	String	UDC (00 S)	3	0	Allow NULL?
61	A0ADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
62	A0CTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
63	A0DOB	Date - Birth	Date	Generic Edit	6	0
64	A0PAYTYP	Payee Type	String	UDC (75 PT)	2	0	Allow NULL?
65	A0ROLNME	Rollover Fund Name	String	Generic Edit	40	0	Allow NULL?
66	A0ROLAD1	Rollover Address Line 1	String	Generic Edit	40	0	Allow NULL?
67	A0ROLAD2	Rollover Address Line 2	String	Generic Edit	40	0	Allow NULL?
68	A0ROLCTY	Rollover City	String	Generic Edit	25	0	Allow NULL?
69	A0ROLSTE	Rollover State	String	Generic Edit	3	0	Allow NULL?
70	A0ROLPOST	Rollover Postcode	String	Generic Edit	12	0	Allow NULL?
71	A0ROLCTR	Rollover Country	String	Generic Edit	3	0	Allow NULL?
72	A0APD	Amount - Paid	Numeric	Generic Edit	15	2	Allow NULL?
73	A0SPANO01	Spare Numeric 01	Numeric	Generic Edit	15	0	Allow NULL?
74	A0SPANO02	Spare Numeric 02	Numeric	Generic Edit	15	0	Allow NULL?
75	A0SPANO03	Spare Numeric 03	Numeric	Generic Edit	15	0	Allow NULL?
76	A0SPAGR01	Spare Gross 01	Numeric	Generic Edit	15	2	Allow NULL?
77	A0SPATX01	Spare Tax 01	Numeric	Generic Edit	15	2	Allow NULL?
78	A0UPMJ	Date - Updated	Date	Generic Edit	6	0
79	A0UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
80	A0PID	Program ID	String	Generic Edit	10	0	Allow NULL?
81	A0JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
82	A0ICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
83	A0CO	Company	String	Generic Edit	5	0	Allow NULL?
84	A0USER	User ID	String	Generic Edit	10	0	Allow NULL?
85	A0CKDT	Date - Pay Check	Date	Generic Edit	6	0

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

85 COLUMNS | 1 INDEXES | 812 | 75A | F75A0010 TABLE

TOP 812 | 75A | F75A0010 COLUMNS

TOP 812 | 75A | F75A0010 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

85 COLUMNS | 1 INDEXES | 812 | 75A | F75A0010 TABLE

TOP812 | 75A | F75A0010 COLUMNS

TOP812 | 75A | F75A0010 INDEXES

TOP 812 | 75A | F75A0010 COLUMNS

TOP 812 | 75A | F75A0010 INDEXES