	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

50 COLUMNS | 8 INDEXES | 812 | 76C | F76C575 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
76C: Colombia
1	812	F76C575	Q1	50	8	Work File Magnetic Media - COL - 04	Transaction Files	76C: Colombia

TOP 812 | 76C | F76C575 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	Q1ICU	Batch Number	Numeric	Generic Edit	8	Allow NULL?
2	Q1ICUT	Batch Type	String	UDC (98 IT)	2	Allow NULL?
3	Q1CTRY	Century	Numeric	Generic Edit	2	Allow NULL?
4	Q1FY	Fiscal Year	Numeric	Generic Edit	2	Allow NULL?
5	Q1CO	Company	String	Generic Edit	5	Allow NULL?
6	Q1LT	Ledger Types	String	UDC (09 LT)	2	Allow NULL?
7	Q1DCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
8	Q1DOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
9	Q1SFX	Document Pay Item	String	Generic Edit	3	Allow NULL?
10	Q1VINV	Supplier Invoice Number	String	Generic Edit	25	Allow NULL?
11	Q1AN8	Address Number	Numeric	UDC	8	Allow NULL?
12	Q1PN	Period Number - General Ledger	Numeric	Generic Edit	2	Allow NULL?
13	Q1DGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6
14	Q1DSVJ	Date - Service/Tax	Date	Generic Edit	6
15	Q1JELN	Journal Entry Line Number	Numeric	Generic Edit	7	Allow NULL?
16	Q1MCU	Business Unit	String	Generic Edit	12	Allow NULL?
17	Q1OBJ	Object Account	String	Generic Edit	6	Allow NULL?
18	Q1SUB	Subsidiary	String	Generic Edit	8	Allow NULL?
19	Q1SBL	Subledger - G/L	String	Generic Edit	8	Allow NULL?
20	Q1SBLT	Subledger Type	Character	UDC (00 ST)	1	Allow NULL?
21	Q1C76JCN	Tributary Identification Number	Numeric	Generic Edit	11	Allow NULL?
22	Q1C76JCD	Check Digit	Character	Generic Edit	1	Allow NULL?
23	Q1C76JCB	First Informed Value	Numeric	Generic Edit	15	Allow NULL?
24	Q1C76JCI	Second Informed Value	Numeric	Generic Edit	15	Allow NULL?
25	Q1C76RT	Tributary Code	String	Generic Edit	3	Allow NULL?
26	Q1C76JCS	Tributary Sub Code	String	Generic Edit	3	Allow NULL?
27	Q1C76JCA	Trade Name	String	Generic Edit	60	Allow NULL?
28	Q1ALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	Allow NULL?
29	Q1TAXC	Person/Corporation Code	Character	UDC (H00 TA)	1	Allow NULL?
30	Q1C76TPF	Invoicing Type	Numeric	Generic Edit	2	Allow NULL?
31	Q1C76PRF	Invoice Prefix	String	Generic Edit	9	Allow NULL?
32	Q1C76FT1	Initial Invoice Range	Numeric	Generic Edit	15	Allow NULL?
33	Q1C76FT2	Final Invoice Range	Numeric	Generic Edit	15	Allow NULL?
34	Q1C76NOE	Establishment Name	String	Generic Edit	15	Allow NULL?
35	Q1CBNK	Bank Account Number - Customer	String	Generic Edit	20	Allow NULL?
36	Q1C76MPO	Departament - Municipio Code	Numeric	Generic Edit	5	Allow NULL?
37	Q1C76CN1	Nit Control Company	Numeric	Generic Edit	15	Allow NULL?
38	Q1MATH10	Math Numeric 10	Numeric	Generic Edit	15	Allow NULL?
39	Q1USER	User ID	String	Generic Edit	10	Allow NULL?
40	Q1PID	Program ID	String	Generic Edit	10	Allow NULL?
41	Q1JOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
42	Q1UPMJ	Date - Updated	Date	Generic Edit	6
43	Q1C76DIR	Informant Direction	String	Generic Edit	40	Allow NULL?
44	Q1COGR	Agrupation Code	String	Generic Edit	2	Allow NULL?
45	Q1CAEC	Economy Activity	Numeric	Generic Edit	4	Allow NULL?
46	Q1ODOC	Document - Original	Numeric	Generic Edit	8	Allow NULL?
47	Q1ODCT	Document Type - Original	String	UDC (00 DT)	2	Allow NULL?
48	Q1TXA1	Tax Rate/Area	String	Generic Edit	10	Allow NULL?
49	Q1EXR1	Tax Expl Code 1	String	UDC (00 EX)	2	Allow NULL?
50	Q1UPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

TOP 812 | 76C | F76C575 INDEXES

Number

Description

L1 (Primary/Unique)

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	ICUT	Batch Type	Ascending
3	ICU	Batch Number	Ascending
4	JELN	Journal Entry Line Number	Ascending
5	DCT	Document Type	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
8	C76RT	Tributary Code	Ascending
9	C76JCS	Tributary Sub Code	Ascending

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	C76JCN	Tributary Identification Number	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	JELN	Journal Entry Line Number	Ascending

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	C76JCN	Tributary Identification Number	Ascending
3	COGR	Agrupation Code	Ascending
4	C76RT	Tributary Code	Ascending
5	C76JCS	Tributary Sub Code	Ascending

Element	Alias	Description	Sequence
1	COGR	Agrupation Code	Ascending
2	C76JCN	Tributary Identification Number	Ascending

Element	Alias	Description	Sequence
1	OBJ	Object Account	Ascending
2	SUB	Subsidiary	Ascending
3	ICUT	Batch Type	Ascending
4	DCT	Document Type	Ascending

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	ICUT	Batch Type	Ascending
3	CO	Company	Ascending
4	DCT	Document Type	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
7	JELN	Journal Entry Line Number	Ascending
8	AN8	Address Number	Ascending

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	ICUT	Batch Type	Ascending
3	CO	Company	Ascending
4	DCT	Document Type	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
7	JELN	Journal Entry Line Number	Ascending

Element	Alias	Description	Sequence
1	COGR	Agrupation Code	Ascending
2	C76JCN	Tributary Identification Number	Ascending
3	C76RT	Tributary Code	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

50 COLUMNS | 8 INDEXES | 812 | 76C | F76C575 TABLE

TOP 812 | 76C | F76C575 COLUMNS

TOP 812 | 76C | F76C575 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

50 COLUMNS | 8 INDEXES | 812 | 76C | F76C575 TABLE

TOP812 | 76C | F76C575 COLUMNS

TOP812 | 76C | F76C575 INDEXES

TOP 812 | 76C | F76C575 COLUMNS

TOP 812 | 76C | F76C575 INDEXES