	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	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

74 COLUMNS | 2 INDEXES | 920 | 75T | F75T004Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
75T: Taiwan
1	920	F75T004Z	ZH	74	2	GUI/VAT Transaction Header - Work - 75T	Work Files	75T: Taiwan

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 ZHUSER, ZHJOBN, ZHOKCO, ZHODCT, ZHODOC, ZH75TDCT, ZH75TTXT, ZH75TPGN, ZH75TYMH, ZH75TVTT, ZHTRDJ, ZHDGJ, ZH75TGFC, ZHEXR1, ZHTXA1, ZHTXR1, ZHBCRC, ZHATXA, ZHSTAM, ZHAAP, ZHT75STAM, ZHT75ATXA, ZHT75AAP, ZHCRCD, ZHCRR, ZHT75ANTX, ZHT75FONT, ZHT75AONT, ZHCTXA, ZHCTAM, ZHT75FNTX, ZHFAP, ZHT75FOAP, ZHT75FOTA, ZHT75FOTX, ZH75TSIT, ZH75TZTT, ZH75TSTT, ZH75TRVT, ZH75TFCW, ZHAN8, ZHAN8R, ZHSHAN, ZHALPH, ZHT75GUIP, ZHT75VDNT, ZHT75VDNF, ZH75TPUN, ZH75TCC4, ZH75TCC5, ZH75TCC6, ZH75TPDM, ZH75TPDN, ZH75TEPM, ZH75TDCU, ZH75TDET, ZH75TDEN, ZH75TEPD, ZH75TMGT, ZHT75VRE, ZHVDGJ, ZHKCO, ZHDCT, ZHICU, ZHDOC, ZHKCOO, ZHDCTO, ZHDOCO, ZH75TLNID, ZH75TLID, ZHUPMJ, ZHTDAY, ZHT75UPMJ, ZHT75TDAY FROM F75T004Z

TOP 920 | 75T | F75T004Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
2	ZHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
3	ZHOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
4	ZHODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
5	ZHODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
6	ZH75TDCT	GUI/VAT Document Type	String	UDC (75T DT)	3	0	Allow NULL?
7	ZH75TTXT	VAT Tax Type	Character	UDC (75T TX)	1	0	Allow NULL?
8	ZH75TPGN	Page Number	Numeric	Generic Edit	3	0	Allow NULL?
9	ZH75TYMH	Year And Month Of Tax Document Happened	Numeric	Generic Edit	6	0	Allow NULL?
10	ZH75TVTT	GUI/VAT Transaction Type	String	UDC (75T TT)	3	0	Allow NULL?
11	ZHTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
12	ZHDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
13	ZH75TGFC	GUI Format Code	String	UDC (75T FC)	2	0	Allow NULL?
14	ZHEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
15	ZHTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
16	ZHTXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
17	ZHBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
18	ZHATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
19	ZHSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
20	ZHAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
21	ZHT75STAM	Original Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
22	ZHT75ATXA	Original Taxable Amount	Numeric	Generic Edit	15	2	Allow NULL?
23	ZHT75AAP	Original Gross Amount	Numeric	Generic Edit	15	2	Allow NULL?
24	ZHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
25	ZHCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
26	ZHT75ANTX	Non taxable Amount	Numeric	Generic Edit	15	2	Allow NULL?
27	ZHT75FONT	Original NonTaxable Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
28	ZHT75AONT	Original Non Taxable Amount	Numeric	Generic Edit	15	2	Allow NULL?
29	ZHCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
30	ZHCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
31	ZHT75FNTX	Foreign Non Taxable Amount	Numeric	Generic Edit	15	2	Allow NULL?
32	ZHFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
33	ZHT75FOAP	Foreign Original Gross Amount	Numeric	Generic Edit	15	2	Allow NULL?
34	ZHT75FOTA	Foreign Original Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
35	ZHT75FOTX	Foreign Original Taxable Amount	Numeric	Generic Edit	15	2	Allow NULL?
36	ZH75TSIT	GUI/VAT Sales Item Type	String	UDC (75T ST)	3	0	Allow NULL?
37	ZH75TZTT	Zero Tax Rate Item Type	String	UDC (75T ZT)	3	0	Allow NULL?
38	ZH75TSTT	Special Tax Item Type	String	UDC (75T SP)	3	0	Allow NULL?
39	ZH75TRVT	Revenue Type	String	UDC (75T RT)	3	0	Allow NULL?
40	ZH75TFCW	Foreign Cigarette / Wine Note	Character	UDC (75T CW)	1	0	Allow NULL?
41	ZHAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
42	ZHAN8R	Related - Address Number	Numeric	Generic Edit	8	0	Allow NULL?
43	ZHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
44	ZHALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
45	ZHT75GUIP	VAT Payment Document Number Prefix	String	Generic Edit	4	0	Allow NULL?
46	ZHT75VDNT	VAT Payment Document Number To	String	Generic Edit	14	0	Allow NULL?
47	ZHT75VDNF	VAT Payment Document Number From	String	Generic Edit	14	0	Allow NULL?
48	ZH75TPUN	Uniform Number Of Business Partner	String	Generic Edit	8	0	Allow NULL?
49	ZH75TCC4	GUI/VAT Cat. Code 4 - Customer	String	UDC (75T C4)	3	0	Allow NULL?
50	ZH75TCC5	GUI/VAT Cat. Code 5 - Customer	String	UDC (75T C5)	3	0	Allow NULL?
51	ZH75TCC6	GUI/VAT Cat. Code 6 - Customer	String	UDC (75T C6)	3	0	Allow NULL?
52	ZH75TPDM	Proof Document Name	String	UDC (75T PD)	10	0	Allow NULL?
53	ZH75TPDN	Proof Document Number	String	Generic Edit	25	0	Allow NULL?
54	ZH75TEPM	Exportation Method	Character	UDC (75T EX)	1	0	Allow NULL?
55	ZH75TDCU	Usage Description About Deduction Copy	Character	UDC (75T DD)	1	0	Allow NULL?
56	ZH75TDET	Type Of Declaration For Exportation	String	UDC (75T EP)	2	0	Allow NULL?
57	ZH75TDEN	Doc. No. Of Declaration For Exportation	String	Generic Edit	25	0	Allow NULL?
58	ZH75TEPD	Date - Exportation Date	Date	Generic Edit	6	0
59	ZH75TMGT	Merge Type	Character	Generic Edit	1	0	Allow NULL?
60	ZHT75VRE	Void Reason Code	String	UDC (75T VR)	3	0	Allow NULL?
61	ZHVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
62	ZHKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
63	ZHDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
64	ZHICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
65	ZHDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
66	ZHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
67	ZHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
68	ZHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
69	ZH75TLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
70	ZH75TLID	Line ID	Numeric	Generic Edit	3	0	Allow NULL?
71	ZHUPMJ	Date - Updated	Date	Generic Edit	6	0
72	ZHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
73	ZHT75UPMJ	Transaction Originator Date - Updated	Date	Generic Edit	6	0
74	ZHT75TDAY	Transaction Originator Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 75T | F75T004Z INDEXES

Number

Description

Idx75T004Z_1 (Primary/Unique)

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	JOBN	Work Station ID	Ascending
3	OKCO	Document Company (Original Order)	Ascending
4	ODCT	Document Type - Original	Ascending
5	ODOC	Document - Original	Ascending
6	75TDCT	GUI/VAT Document Type	Ascending
7	75TTXT	VAT Tax Type	Ascending
8	75TPGN	Page Number	Ascending

Idx75T004Z_2

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	JOBN	Work Station ID	Ascending
3	OKCO	Document Company (Original Order)	Ascending
4	ODCT	Document Type - Original	Ascending
5	ODOC	Document - Original	Ascending
6	75TDCT	GUI/VAT Document Type	Ascending
7	75TTXT	VAT Tax Type	Ascending
8	75TPGN	Page Number	Descending

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

74 COLUMNS | 2 INDEXES | 920 | 75T | F75T004Z TABLE

TOP 920 | 75T | F75T004Z COLUMNS

TOP 920 | 75T | F75T004Z 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

74 COLUMNS | 2 INDEXES | 920 | 75T | F75T004Z TABLE

TOP920 | 75T | F75T004Z COLUMNS

TOP920 | 75T | F75T004Z INDEXES

TOP 920 | 75T | F75T004Z COLUMNS

TOP 920 | 75T | F75T004Z INDEXES