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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger 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	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
47: Electronic Commerce
1	812	F471061	S3	66	1	EDI Response to RFQ Additional Header - Outbound	Batch Input Files	42: Sales Management	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	S3EDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
2	S3EDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
3	S3EKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
4	S3EDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
5	S3EDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	S3EDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	S3EDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
8	S3EDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
9	S3KCO	Document Company	String	Generic Edit	5	0	Allow NULL?
10	S3DOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
11	S3DCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
12	S3DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
13	S3DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
14	S3SFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
15	S3MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
16	S3AN8	Address Number	Numeric	UDC	8	0	Allow NULL?
17	S3TAX	Tax ID	String	Generic Edit	20	0	Allow NULL?
18	S3TAXC	Person/Corporation Code	Character	UDC (H00 TA)	1	0	Allow NULL?
19	S3TX1	Tax ID - Additional - Company	String	Generic Edit	16	0	Allow NULL?
20	S3TX2	Tax ID - Additional - Individual	String	Generic Edit	20	0	Allow NULL?
21	S3TA1	Tax Authority	Numeric	Generic Edit	8	0	Allow NULL?
22	S3TA2	Tax Authority 2	Numeric	Generic Edit	8	0	Allow NULL?
23	S3TA3	Tax Authority 3	Numeric	Generic Edit	8	0	Allow NULL?
24	S3TA4	Tax Authority 4	Numeric	Generic Edit	8	0	Allow NULL?
25	S3TA5	Tax Authority 5	Numeric	Generic Edit	8	0	Allow NULL?
26	S3TXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
27	S3TXR2	Tax Rate 2	Numeric	Generic Edit	7	3	Allow NULL?
28	S3TXR3	Tax Rate 3	Numeric	Generic Edit	7	3	Allow NULL?
29	S3TXR4	Tax Rate 4	Numeric	Generic Edit	7	3	Allow NULL?
30	S3TXR5	Tax Rate 5	Numeric	Generic Edit	7	3	Allow NULL?
31	S3TAXT	Amount - Sales Tax Total 1	Numeric	Generic Edit	15	2	Allow NULL?
32	S3TAX2	Amount - Sales Tax Total 2	Numeric	Generic Edit	15	2	Allow NULL?
33	S3TAX3	Amount - Sales Tax Total 3	Numeric	Generic Edit	15	2	Allow NULL?
34	S3TAX4	Amount - Sales Tax Total 4	Numeric	Generic Edit	15	2	Allow NULL?
35	S3TAX5	Amount - Sales Tax Total 5	Numeric	Generic Edit	15	2	Allow NULL?
36	S3NAID	Address Identification Code	Character	Generic Edit	1	0	Allow NULL?
37	S3MLNM	Name - Mailing	String	Generic Edit	40	0	Allow NULL?
38	S3PTD	Description - Payment Terms	String	Generic Edit	30	0	Allow NULL?
39	S3DCP	Discount % - Payment Terms	Numeric	Generic Edit	5	0	Allow NULL?
40	S3DCD	Discount Days	Numeric	Generic Edit	3	0	Allow NULL?
41	S3NDTP	Net Days to Pay	Numeric	Generic Edit	3	0	Allow NULL?
42	S3DDU	Date - Due	Date	Generic Edit	6	0
43	S3DSCT	Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
44	S3NSP	Number of Split Payments	Numeric	Generic Edit	2	0	Allow NULL?
45	S3DTPA	Days to Pay Aging	Numeric	Generic Edit	3	0	Allow NULL?
46	S3DDJ	Date - Net Due	Date	Generic Edit	6	0
47	S3AG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
48	S3AAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
49	S3ADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
50	S3ATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
51	S3ATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
52	S3STAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
53	S3ACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
54	S3FAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
55	S3CDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
56	S3CTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
57	S3CTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
58	S3CTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
59	S3DSVJ	Date - Service/Tax	Date	Generic Edit	6	0
60	S3IVD	Date - Invoice	Date	Generic Edit	6	0
61	S3TORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
62	S3USER	User ID	String	Generic Edit	10	0	Allow NULL?
63	S3PID	Program ID	String	Generic Edit	10	0	Allow NULL?
64	S3JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
65	S3UPMJ	Date - Updated	Date	Generic Edit	6	0
66	S3TDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

Su	Mo	Tu	We	Th	Fr	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

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

66 COLUMNS | 1 INDEXES | 812 | 47 | F471061 TABLE

TOP 812 | 47 | F471061 COLUMNS

TOP 812 | 47 | F471061 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

66 COLUMNS | 1 INDEXES | 812 | 47 | F471061 TABLE

TOP812 | 47 | F471061 COLUMNS

TOP812 | 47 | F471061 INDEXES

TOP 812 | 47 | F471061 COLUMNS

TOP 812 | 47 | F471061 INDEXES