	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

94 COLUMNS | 2 INDEXES | 812 | 76A | F76AUI20 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76A: Argentina
1	812	F76AUI20	HF	94	2	Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00	Work Files	76A: Argentina	AS400 Coexistence Tables

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 HFJOBS, HFCTID, HFDOC, HFDCT, HFKCO, HFARYO, HFINTY, HFEV01, HFINVC, HFEV02, HFACEM, HFAINW, HFAGRP, HFDL01, HFDIVJ, HFEFDJ, HFADD1, HFADD2, HFADD3, HFADD4, HFTAX, HFTX1, HFAN8, HFADD5, HFADD6, HFADD7, HFADD8, HFTAXX, HFTX2, HFSHAN, HFAD1I, HFAD2I, HFAD3I, HFAD4I, HFPTD, HFDEL1, HFDEL2, HFDOCO, HFDCTO, HFKCOO, HFODOC, HFODCT, HFTAXA, HFDL0, HFDL03, HFSTA1, HFSTA2, HFSTA3, HFSTA4, HFAG, HFDL02, HFCRR, HFADSA, HFITWT, HFWTUM, HFITVL, HFVLUM, HFADD0, HFTAXS, HFAPIT, HFACAI, HFCXPJ, HFRLNO, HFLDNM, HFSTUM, HFBUM6, HFPNMG, HFINMG, HFEV03, HFEV04, HFEV05, HFEV06, HFEV07, HFORIG, HFICON, HFFLGA, HFEFT, HFURAB, HFURAT, HFURC1, HFURC2, HFURCD, HFURDD, HFURDT, HFURNUM01, HFURNUM02, HFURNUM03, HFURRF, HFADD10, HFADD11, HFADD12, HFADD13, HFCTY1, HFADDZ FROM F76AUI20

TOP 812 | 76A | F76AUI20 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	HFJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
2	HFCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
3	HFDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	HFDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
5	HFKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
6	HFARYO	Shipment Note(Y/N) - Argentina	Character	UDC (76 A3)	1	0	Allow NULL?
7	HFINTY	Invoice Type	Character	UDC (48 IT)	1	0	Allow NULL?
8	HFEV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	0	Allow NULL?
9	HFINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
10	HFEV02	J.D. EnterpriseOne Event Point 02	Character	Generic Edit	1	0	Allow NULL?
11	HFACEM	Issue Place - Argentina	String	Generic Edit	4	0	Allow NULL?
12	HFAINW	Invoice Legal Next Number - Argentina	String	Generic Edit	8	0	Allow NULL?
13	HFAGRP	Invoice Group - Argentina	Character	UDC (76 B1)	1	0	Allow NULL?
14	HFDL01	Description	String	Generic Edit	30	0	Allow NULL?
15	HFDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
16	HFEFDJ	Date - Expiration (Julian)	Date	Generic Edit	6	0
17	HFADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
18	HFADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
19	HFADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
20	HFADD4	Address Line 4	String	Generic Edit	40	0	Allow NULL?
21	HFTAX	Tax ID	String	Generic Edit	20	0	Allow NULL?
22	HFTX1	Tax ID - Additional - Company	String	Generic Edit	16	0	Allow NULL?
23	HFAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
24	HFADD5	Address Line 5	String	Generic Edit	40	0	Allow NULL?
25	HFADD6	Address Line 6	String	Generic Edit	40	0	Allow NULL?
26	HFADD7	Address Line 8	String	Generic Edit	40	0	Allow NULL?
27	HFADD8	Address Line 8	String	Generic Edit	40	0	Allow NULL?
28	HFTAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
29	HFTX2	Tax ID - Additional - Individual	String	Generic Edit	20	0	Allow NULL?
30	HFSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
31	HFAD1I	Address Line 1 - Italy	String	Generic Edit	40	0	Allow NULL?
32	HFAD2I	Address Line 2 - Italy	String	Generic Edit	40	0	Allow NULL?
33	HFAD3I	Address Line 3 - Italy	String	Generic Edit	40	0	Allow NULL?
34	HFAD4I	Address Line 4 - Italy	String	Generic Edit	40	0	Allow NULL?
35	HFPTD	Description - Payment Terms	String	Generic Edit	30	0	Allow NULL?
36	HFDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
37	HFDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
38	HFDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
39	HFDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
40	HFKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
41	HFODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
42	HFODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
43	HFTAXA	Description - Tax Area	String	Generic Edit	30	0	Allow NULL?
44	HFDL0	Description	String	Generic Edit	30	0	Allow NULL?
45	HFDL03	Description 03	String	Generic Edit	30	0	Allow NULL?
46	HFSTA1	Amount - Sales Tax Tax Authority 1	Numeric	Generic Edit	15	2	Allow NULL?
47	HFSTA2	Amount - Sales Tax Tax Authority 2	Numeric	Generic Edit	15	2	Allow NULL?
48	HFSTA3	Amount - Sales Tax Tax Authority 3	Numeric	Generic Edit	15	2	Allow NULL?
49	HFSTA4	Amount - Sales Tax Tax Authority 4	Numeric	Generic Edit	15	2	Allow NULL?
50	HFAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
51	HFDL02	Description 02	String	Generic Edit	30	0	Allow NULL?
52	HFCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
53	HFADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
54	HFITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
55	HFWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
56	HFITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
57	HFVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
58	HFADD0	Address Line	String	Generic Edit	40	0	Allow NULL?
59	HFTAXS	State Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
60	HFAPIT	Number of Pages - ARG - 00	Numeric	Generic Edit	2	0	Allow NULL?
61	HFACAI	Autoprinter Inscription Number-ARG-76A	String	Generic Edit	14	0	Allow NULL?
62	HFCXPJ	Date - Expiration (Julian)	Date	Generic Edit	6	0
63	HFRLNO	Registration/License Number	String	Generic Edit	13	0	Allow NULL?
64	HFLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
65	HFSTUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
66	HFBUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
67	HFPNMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
68	HFINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
69	HFEV03	J.D. EnterpriseOne Point 03	Character	Generic Edit	1	0	Allow NULL?
70	HFEV04	EnterpriseOne Point 04	Character	Generic Edit	1	0	Allow NULL?
71	HFEV05	EnterpriseOne Point 05	Character	Generic Edit	1	0	Allow NULL?
72	HFEV06	EnterpriseOne Point 06	Character	Generic Edit	1	0	Allow NULL?
73	HFEV07	EnterpriseOne Point 07	Character	Generic Edit	1	0	Allow NULL?
74	HFORIG	Country of Origin	String	UDC (00 CN)	3	0	Allow NULL?
75	HFICON	Invoice Consolidation	Character	Generic Edit	1	0	Allow NULL?
76	HFFLGA	Approval Flag	Character	Generic Edit	1	0	Allow NULL?
77	HFEFT	Date - Effective	Date	Generic Edit	6	0
78	HFURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
79	HFURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
80	HFURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
81	HFURC2	User Reserved Code	String	Generic Edit	10	0	Allow NULL?
82	HFURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
83	HFURDD	User Reserved Date - Gregorian - DA	Numeric	Generic Edit	2	0	Allow NULL?
84	HFURDT	User Reserved Date	Date	Generic Edit	6	0
85	HFURNUM01	User Defined Numeric	Numeric	Generic Edit	15	0	Allow NULL?
86	HFURNUM02	User Defined Numeric	Numeric	Generic Edit	15	0	Allow NULL?
87	HFURNUM03	User Defined Numeric	Numeric	Generic Edit	15	0	Allow NULL?
88	HFURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
89	HFADD10	Address Line 10	String	Generic Edit	40	0	Allow NULL?
90	HFADD11	Address Line 11	String	Generic Edit	40	0	Allow NULL?
91	HFADD12	Address Line 12	String	Generic Edit	40	0	Allow NULL?
92	HFADD13	Address Line 13	String	Generic Edit	40	0	Allow NULL?
93	HFCTY1	City	String	Generic Edit	25	0	Allow NULL?
94	HFADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?

TOP 812 | 76A | F76AUI20 INDEXES

Number

Description

JOBS CTID DOC DCT KCO (Primary/Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	CTID	Computer ID	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	Ascending

JOBS CTID ARYO INTY EV01

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	CTID	Computer ID	Ascending
3	ARYO	Shipment Note(Y/N) - Argentina	Ascending
4	INTY	Invoice Type	Ascending
5	EV01	J.D. EnterpriseOne Event Point 01	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

94 COLUMNS | 2 INDEXES | 812 | 76A | F76AUI20 TABLE

TOP 812 | 76A | F76AUI20 COLUMNS

TOP 812 | 76A | F76AUI20 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 | 2 INDEXES | 812 | 76A | F76AUI20 TABLE

TOP812 | 76A | F76AUI20 COLUMNS

TOP812 | 76A | F76AUI20 INDEXES

TOP 812 | 76A | F76AUI20 COLUMNS

TOP 812 | 76A | F76AUI20 INDEXES