	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

81 COLUMNS | 12 INDEXES | 920 | 74R | F74R0018 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
74R: Russia
1	920	F74R0018	TD	81	12	Russian Tax File - 74R	Files	74: EMEA Localization

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 TDY74RID, TDY74RID2, TDY74RARAP, TDY74RATTN, TDKCO, TDDOC, TDDCT, TDSFX, TDSFXE, TDDCTA, TDVINV, TDDIVJ, TDDSVJ, TDDGJ, TDAG, TDATXA, TDATXN, TDSTAM, TDACR, TDEXR1, TDIRDE, TDITM, TDTXA1, TDTXR1, TDTXR2, TDTXR3, TDTXR4, TDTXR5, TDTA1, TDTA2, TDTA3, TDTA4, TDTA5, TDSTA1, TDSTA2, TDSTA3, TDSTA4, TDSTA5, TDAID, TDCO, TDAN8, TDPYE, TDCRCD, TDCRRM, TDHCRR, TDCRR, TDY74RDPAY, TDRPD, TDY74RDREP, TDTNDI, TDY74RRA01, TDY74RRA02, TDY74RRA03, TDY74RRA04, TDY74RRA05, TDEXR, TDCTR, TDY74RGTD, TDY74RDA01, TDY74RDA02, TDTXAM, TDY74RDA03, TDY74RDA04, TDY74RDA05, TDPYID, TDRC5, TDDMTJ, TDPFAP, TDY74RTXAR, TDY74RDALC, TDLT, TDJELN, TDEXTL, TDY74RPSRR, TDY74RPPRR, TDUSER, TDPID, TDJOBN, TDUPMJ, TDUPMT, TDPOST FROM F74R0018

TOP 920 | 74R | F74R0018 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	TDY74RID	Tables PK Internal ID	Numeric	Generic Edit	15	0	Allow NULL?
2	TDY74RID2	Auxilary Table Internal ID	Numeric	Generic Edit	15	0	Allow NULL?
3	TDY74RARAP	A/P or A/R Marker	Character	Generic Edit	1	0	Allow NULL?
4	TDY74RATTN	Attention Marker	Character	UDC (74R YN)	1	0	Allow NULL?
5	TDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
6	TDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	TDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
8	TDSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
9	TDSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
10	TDDCTA	Document Type - Adjusting	String	UDC (00 DT)	2	0	Allow NULL?
11	TDVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
12	TDDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
13	TDDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
14	TDDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
15	TDAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
16	TDATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
17	TDATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
18	TDSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
19	TDACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
20	TDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
21	TDIRDE	Description - Withholding Tax (Long)	String	Generic Edit	50	0	Allow NULL?
22	TDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
23	TDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
24	TDTXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
25	TDTXR2	Tax Rate 2	Numeric	Generic Edit	7	3	Allow NULL?
26	TDTXR3	Tax Rate 3	Numeric	Generic Edit	7	3	Allow NULL?
27	TDTXR4	Tax Rate 4	Numeric	Generic Edit	7	3	Allow NULL?
28	TDTXR5	Tax Rate 5	Numeric	Generic Edit	7	3	Allow NULL?
29	TDTA1	Tax Authority	Numeric	Generic Edit	8	0	Allow NULL?
30	TDTA2	Tax Authority 2	Numeric	Generic Edit	8	0	Allow NULL?
31	TDTA3	Tax Authority 3	Numeric	Generic Edit	8	0	Allow NULL?
32	TDTA4	Tax Authority 4	Numeric	Generic Edit	8	0	Allow NULL?
33	TDTA5	Tax Authority 5	Numeric	Generic Edit	8	0	Allow NULL?
34	TDSTA1	Amount - Sales Tax Tax Authority 1	Numeric	Generic Edit	15	2	Allow NULL?
35	TDSTA2	Amount - Sales Tax Tax Authority 2	Numeric	Generic Edit	15	2	Allow NULL?
36	TDSTA3	Amount - Sales Tax Tax Authority 3	Numeric	Generic Edit	15	2	Allow NULL?
37	TDSTA4	Amount - Sales Tax Tax Authority 4	Numeric	Generic Edit	15	2	Allow NULL?
38	TDSTA5	Amount - Sales Tax Tax Authority 5	Numeric	Generic Edit	15	2	Allow NULL?
39	TDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
40	TDCO	Company	String	Generic Edit	5	0	Allow NULL?
41	TDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
42	TDPYE	Payee Address Number	Numeric	Generic Edit	8	0	Allow NULL?
43	TDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
44	TDCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
45	TDHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
46	TDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
47	TDY74RDPAY	Payment Date	Date	Generic Edit	6	0
48	TDRPD	Date - Report	Date	Generic Edit	6	0
49	TDY74RDREP	Date - Reposting	Date	Generic Edit	6	0
50	TDTNDI	VAT Document Number Generated	Numeric	Generic Edit	8	0	Allow NULL?
51	TDY74RRA01	Reason Allocated 01	Character	UDC (74R RA)	1	0	Allow NULL?
52	TDY74RRA02	Reason Allocated 02	Character	UDC (74R RA)	1	0	Allow NULL?
53	TDY74RRA03	Reason Allocated 03	Character	UDC (74R RA)	1	0	Allow NULL?
54	TDY74RRA04	Reason Allocated 04	Character	UDC (74R RA)	1	0	Allow NULL?
55	TDY74RRA05	Reason Allocated 05	Character	UDC (74R RA)	1	0	Allow NULL?
56	TDEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
57	TDCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
58	TDY74RGTD	Customs Declaration Number	String	Generic Edit	30	0	Allow NULL?
59	TDY74RDA01	Date Allocated 01	Date	Generic Edit	6	0
60	TDY74RDA02	Date Allocated 02	Date	Generic Edit	6	0
61	TDTXAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
62	TDY74RDA03	Date Allocated 03	Date	Generic Edit	6	0
63	TDY74RDA04	Date Allocated 04	Date	Generic Edit	6	0
64	TDY74RDA05	Date Allocated 05	Date	Generic Edit	6	0
65	TDPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
66	TDRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	0	Allow NULL?
67	TDDMTJ	Date - Matching Check or Item - Julian	Date	Generic Edit	6	0
68	TDPFAP	Payment Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
69	TDY74RTXAR	VAT Amount Reposted on Payment	Numeric	Generic Edit	15	2	Allow NULL?
70	TDY74RDALC	Allocation Date	Date	Generic Edit	6	0
71	TDLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
72	TDJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
73	TDEXTL	Line Extension Code	String	Generic Edit	2	0	Allow NULL?
74	TDY74RPSRR	Sales Report Print	Character	Generic Edit	1	0	Allow NULL?
75	TDY74RPPRR	Purchase Report Print	Character	Generic Edit	1	0	Allow NULL?
76	TDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
77	TDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
78	TDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
79	TDUPMJ	Date - Updated	Date	Generic Edit	6	0
80	TDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
81	TDPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 74R | F74R0018 INDEXES

Number

Description

Internal ID Internal ID 2 (Primary/Unique)

Element	Alias	Description	Sequence
1	Y74RID	Tables PK Internal ID	Ascending
2	Y74RID2	Auxilary Table Internal ID	Ascending

Doc Company Doc Number +A

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	SFX	Document Pay Item	Ascending
5	SFXE	Pay Item Extension Number	Ascending

A/P or A/R Marker Payment +

Element	Alias	Description	Sequence
1	Y74RARAP	A/P or A/R Marker	Ascending
2	PYID	Payment ID (Internal)	Ascending
3	RC5	File Line Identifier 5.0	Ascending

Allocation Date

Element	Alias	Description	Sequence
1	Y74RDALC	Allocation Date	Ascending

Matching Date

Element	Alias	Description	Sequence
1	DMTJ	Date - Matching Check or Item - Julian	Ascending

Doc Company Doc Number +B

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	Y74RATTN	Attention Marker	Ascending
5	EXR1	Tax Expl Code 1	Ascending
6	ITM	Item Number - Short	Ascending
7	TXA1	Tax Rate/Area	Ascending

Doc Company Doc Number +C

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	SFX	Document Pay Item	Ascending
5	SFXE	Pay Item Extension Number	Ascending
6	Y74RID	Tables PK Internal ID	Descending
7	Y74RID2	Auxilary Table Internal ID	Descending

Doc Type Doc Number +

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Descending
5	JELN	Journal Entry Line Number	Ascending
6	LT	Ledger Types	Ascending
7	EXTL	Line Extension Code	Ascending

Doc Company Doc Number +D

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	SFX	Document Pay Item	Ascending
5	SFXE	Pay Item Extension Number	Ascending
6	Y74RDALC	Allocation Date	Ascending
7	DMTJ	Date - Matching Check or Item - Julian	Descending
8	Y74RID	Tables PK Internal ID	Ascending
9	Y74RID2	Auxilary Table Internal ID	Ascending

Doc Company Doc Number +E

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	SFX	Document Pay Item	Ascending
5	RPD	Date - Report	Ascending
6	Y74RDPAY	Payment Date	Descending
7	Y74RID	Tables PK Internal ID	Ascending
8	Y74RID2	Auxilary Table Internal ID	Ascending

Doc Company Doc Number +F

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	SFX	Document Pay Item	Ascending
5	RPD	Date - Report	Descending
6	Y74RDPAY	Payment Date	Ascending
7	Y74RID	Tables PK Internal ID	Ascending
8	Y74RID2	Auxilary Table Internal ID	Ascending

Y74RARAP TNDI

Element	Alias	Description	Sequence
1	Y74RARAP	A/P or A/R Marker	Ascending
2	TNDI	VAT Document Number Generated	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

81 COLUMNS | 12 INDEXES | 920 | 74R | F74R0018 TABLE

TOP 920 | 74R | F74R0018 COLUMNS

TOP 920 | 74R | F74R0018 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

81 COLUMNS | 12 INDEXES | 920 | 74R | F74R0018 TABLE

TOP920 | 74R | F74R0018 COLUMNS

TOP920 | 74R | F74R0018 INDEXES

TOP 920 | 74R | F74R0018 COLUMNS

TOP 920 | 74R | F74R0018 INDEXES