	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	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

94 COLUMNS | 5 INDEXES | 812 | 75T | F75T004 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
75T: Taiwan
1	812	F75T004	TH	94	5	GUI/VAT Transaction Header - 75T	Transaction Files	75: ASEAN 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 TH75TTNF, TH75TRAS, THCO, TH75TDSI, TH75TAUC, TH75TYMD, TH75TVTT, TH75TDCT, THTRDJ, THDGJ, TH75TYMH, TH75TGFC, TH75TTXT, THEXR1, THTXA1, THTXR1, THBCRC, THATXA, THSTAM, THAAP, THCRCD, THCRR, THCTXA, THCTAM, THFAP, TH75TUIP, TH75TGRF, TH75TGSF, TH75TGNF, TH75TGNT, TH75TTNT, TH75TSMN, TH75TSMC, TH75TSIT, TH75TZTT, TH75TDCU, TH75TPDM, TH75TPDN, TH75TEPM, TH75TDET, TH75TDEN, TH75TEPD, TH75TRVT, TH75TSTT, TH75TDDC, TH75TPIT, TH75TIIT, TH75TPUS, TH75TFCW, THAN8, THAN8R, THSHAN, THALPH, TH75TPUN, TH75TMGT, THKCO, THDCT, THDOC, THKCOO, THDCTO, THDOCO, THSFXO, THDSC1, THUORG, TH75TCC1, TH75TCC2, TH75TCC3, TH75TCC4, TH75TCC5, TH75TCC6, TH75TCC7, TH75TCC8, TH75TCC9, TH75TPCT, THMUSE, TH75TSPI, TH75TCRI, TH75TCID, TH75TCCN, TH75TPYT, TH75TPPS, TH75TPPB, TH75TDGM, THREMK, THURC1, THURDT, THURAT, THURAB, THURRF, THUSER, THPID, THJOBN, THUPMJ, THTDAY FROM F75T004

TOP 812 | 75T | F75T004 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	TH75TTNF	GUI/VAT Transaction Number (From)	String	Generic Edit	10	0	Allow NULL?
2	TH75TRAS	Returns/Allowances Sequence Number	Numeric	Generic Edit	5	0	Allow NULL?
3	THCO	Company	String	Generic Edit	5	0	Allow NULL?
4	TH75TDSI	GUI/VAT Declaration Site	String	UDC (75T DS)	5	0	Allow NULL?
5	TH75TAUC	Authorized Code	String	UDC (75T AC)	10	0	Allow NULL?
6	TH75TYMD	Year And Month Of VAT Declaration	Numeric	Generic Edit	6	0	Allow NULL?
7	TH75TVTT	GUI/VAT Transaction Type	String	UDC (75T TT)	3	0	Allow NULL?
8	TH75TDCT	GUI/VAT Document Type	String	UDC (75T DT)	3	0	Allow NULL?
9	THTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
10	THDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
11	TH75TYMH	Year And Month Of Tax Document Happened	Numeric	Generic Edit	6	0	Allow NULL?
12	TH75TGFC	GUI Format Code	String	UDC (75T FC)	2	0	Allow NULL?
13	TH75TTXT	VAT Tax Type	Character	UDC (75T TX)	1	0	Allow NULL?
14	THEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
15	THTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
16	THTXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
17	THBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
18	THATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
19	THSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
20	THAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
21	THCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
22	THCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
23	THCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
24	THCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
25	THFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
26	TH75TUIP	GUI / Receipt Prefix	String	Generic Edit	2	0	Allow NULL?
27	TH75TGRF	GUI / Receipt Register Numbers (From)	Numeric	Generic Edit	8	0	Allow NULL?
28	TH75TGSF	GUI / Receipt Segment Numbers (From)	Numeric	Generic Edit	8	0	Allow NULL?
29	TH75TGNF	GUI/VAT Number (From)	Numeric	Generic Edit	8	0	Allow NULL?
30	TH75TGNT	GUI/VAT Number (To)	Numeric	Generic Edit	8	0	Allow NULL?
31	TH75TTNT	GUI/VAT Transaction Number (To)	String	Generic Edit	10	0	Allow NULL?
32	TH75TSMN	Summary Note	Character	UDC (75T SN)	1	0	Allow NULL?
33	TH75TSMC	Count Of Doc in a GUI/VAT Transaction	Numeric	Generic Edit	8	0	Allow NULL?
34	TH75TSIT	GUI/VAT Sales Item Type	String	UDC (75T ST)	3	0	Allow NULL?
35	TH75TZTT	Zero Tax Rate Item Type	String	UDC (75T ZT)	3	0	Allow NULL?
36	TH75TDCU	Usage Description About Deduction Copy	Character	UDC (75T DD)	1	0	Allow NULL?
37	TH75TPDM	Proof Document Name	String	UDC (75T PD)	10	0	Allow NULL?
38	TH75TPDN	Proof Document Number	String	Generic Edit	25	0	Allow NULL?
39	TH75TEPM	Exportation Method	Character	UDC (75T EX)	1	0	Allow NULL?
40	TH75TDET	Type Of Declaration For Exportation	String	UDC (75T EP)	2	0	Allow NULL?
41	TH75TDEN	Doc. No. Of Declaration For Exportation	String	Generic Edit	25	0	Allow NULL?
42	TH75TEPD	Date - Exportation Date	Date	Generic Edit	6	0
43	TH75TRVT	Revenue Type	String	UDC (75T RT)	3	0	Allow NULL?
44	TH75TSTT	Special Tax Item Type	String	UDC (75T SP)	3	0	Allow NULL?
45	TH75TDDC	Deduction Code	Character	UDC (75T DC)	1	0	Allow NULL?
46	TH75TPIT	Purchase Item Type	String	UDC (75T PT)	3	0	Allow NULL?
47	TH75TIIT	Import Item Type	String	UDC (75T II)	3	0	Allow NULL?
48	TH75TPUS	Usage Description About Purchase	String	UDC (75T PU)	3	0	Allow NULL?
49	TH75TFCW	Foreign Cigarette / Wine Note	Character	UDC (75T CW)	1	0	Allow NULL?
50	THAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
51	THAN8R	Related - Address Number	Numeric	Generic Edit	8	0	Allow NULL?
52	THSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
53	THALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
54	TH75TPUN	Uniform Number Of Business Partner	String	Generic Edit	8	0	Allow NULL?
55	TH75TMGT	Merge Type	Character	Generic Edit	1	0	Allow NULL?
56	THKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
57	THDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
58	THDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
59	THKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
60	THDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
61	THDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
62	THSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
63	THDSC1	Description	String	Generic Edit	30	0	Allow NULL?
64	THUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
65	TH75TCC1	GUI/VAT Cat. Code 1 - Segment	String	UDC (75T C1)	3	0	Allow NULL?
66	TH75TCC2	GUI/VAT Cat. Code 2 - Segment	String	UDC (75T C2)	3	0	Allow NULL?
67	TH75TCC3	GUI/VAT Cat. Code 3 - Segment	String	UDC (75T C3)	3	0	Allow NULL?
68	TH75TCC4	GUI/VAT Cat. Code 4 - Customer	String	UDC (75T C4)	3	0	Allow NULL?
69	TH75TCC5	GUI/VAT Cat. Code 5 - Customer	String	UDC (75T C5)	3	0	Allow NULL?
70	TH75TCC6	GUI/VAT Cat. Code 6 - Customer	String	UDC (75T C6)	3	0	Allow NULL?
71	TH75TCC7	GUI/VAT Cat. Code 7 - Supplier	String	UDC (75T C7)	3	0	Allow NULL?
72	TH75TCC8	GUI/VAT Cat. Code 8 - Supplier	String	UDC (75T C8)	3	0	Allow NULL?
73	TH75TCC9	GUI/VAT Cat. Code 9 - Supplier	String	UDC (75T C9)	3	0	Allow NULL?
74	TH75TPCT	Print Count	Numeric	Generic Edit	3	0	Allow NULL?
75	THMUSE	User ID	String	Generic Edit	10	0	Allow NULL?
76	TH75TSPI	Salesperson ID	String	Generic Edit	10	0	Allow NULL?
77	TH75TCRI	Cash Register ID	String	Generic Edit	10	0	Allow NULL?
78	TH75TCID	Citizenship ID	String	Generic Edit	10	0	Allow NULL?
79	TH75TCCN	Credit Card Number	String	Generic Edit	16	0	Allow NULL?
80	TH75TPYT	Payment Type	String	Generic Edit	10	0	Allow NULL?
81	TH75TPPS	Prepayment Status	Character	UDC (75T PS)	1	0	Allow NULL?
82	TH75TPPB	Prepayment Balance	Numeric	Generic Edit	15	2	Allow NULL?
83	TH75TDGM	Data Generation Method	String	UDC (75T DG)	3	0	Allow NULL?
84	THREMK	Remarks	String	Generic Edit	30	0	Allow NULL?
85	THURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
86	THURDT	User Reserved Date	Date	Generic Edit	6	0
87	THURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
88	THURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
89	THURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	THUSER	User ID	String	Generic Edit	10	0	Allow NULL?
91	THPID	Program ID	String	Generic Edit	10	0	Allow NULL?
92	THJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
93	THUPMJ	Date - Updated	Date	Generic Edit	6	0
94	THTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 812 | 75T | F75T004 INDEXES

Number

Description

Idx75T004_1 (Primary/Unique)

Element	Alias	Description	Sequence
1	75TTNF	GUI/VAT Transaction Number (From)	Ascending
2	75TRAS	Returns/Allowances Sequence Number	Ascending

Idx75T004_2

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	75TDSI	GUI/VAT Declaration Site	Ascending

Idx75T004_5

Element	Alias	Description	Sequence
1	75TUIP	GUI / Receipt Prefix	Ascending
2	75TGRF	GUI / Receipt Register Numbers (From)	Ascending
3	75TGSF	GUI / Receipt Segment Numbers (From)	Ascending

Idx75T004_6

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending

Idx75T004_7

Element	Alias	Description	Sequence
1	75TTNF	GUI/VAT Transaction Number (From)	Ascending
2	75TRAS	Returns/Allowances Sequence 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

94 COLUMNS | 5 INDEXES | 812 | 75T | F75T004 TABLE

TOP 812 | 75T | F75T004 COLUMNS

TOP 812 | 75T | F75T004 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

94 COLUMNS | 5 INDEXES | 812 | 75T | F75T004 TABLE

TOP812 | 75T | F75T004 COLUMNS

TOP812 | 75T | F75T004 INDEXES

TOP 812 | 75T | F75T004 COLUMNS

TOP 812 | 75T | F75T004 INDEXES