	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

157 COLUMNS | 24 INDEXES | 910 | 03B | F03B11 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	910	F03B11	RP	157	24	Customer Ledger	Transaction Files	03B: Enhanced Accounts Receivable	Business Data

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 RPDOC, RPDCT, RPKCO, RPSFX, RPAN8, RPDGJ, RPDIVJ, RPICUT, RPICU, RPDICJ, RPFY, RPCTRY, RPPN, RPCO, RPGLC, RPAID, RPPA8, RPAN8J, RPPYR, RPPOST, RPISTR, RPBALJ, RPPST, RPAG, RPAAP, RPADSC, RPADSA, RPATXA, RPATXN, RPSTAM, RPBCRC, RPCRRM, RPCRCD, RPCRR, RPDMCD, RPACR, RPFAP, RPCDS, RPCDSA, RPCTXA, RPCTXN, RPCTAM, RPTXA1, RPEXR1, RPDSVJ, RPGLBA, RPAM, RPAID2, RPAM2, RPMCU, RPOBJ, RPSUB, RPSBLT, RPSBL, RPPTC, RPDDJ, RPDDNJ, RPRDDJ, RPRDSJ, RPLFCJ, RPSMTJ, RPNBRR, RPRDRL, RPRMDS, RPCOLL, RPCORC, RPAFC, RPDNLT, RPRSCO, RPODOC, RPODCT, RPOKCO, RPOSFX, RPVINV, RPPO, RPPDCT, RPPKCO, RPDCTO, RPLNID, RPSDOC, RPSDCT, RPSKCO, RPSFXO, RPVLDT, RPCMC1, RPVR01, RPUNIT, RPMCU2, RPRMK, RPALPH, RPRF, RPDRF, RPCTL, RPFNLP, RPITM, RPU, RPUM, RPALT6, RPRYIN, RPVDGJ, RPVOD, RPRP1, RPRP2, RPRP3, RPAR01, RPAR02, RPAR03, RPAR04, RPAR05, RPAR06, RPAR07, RPAR08, RPAR09, RPAR10, RPISTC, RPPYID, RPURC1, RPURDT, RPURAT, RPURAB, RPURRF, RPRNID, RPPPDI, RPTORG, RPUSER, RPJCL, RPPID, RPUPMJ, RPUPMT, RPDDEX, RPJOBN, RPHCRR, RPHDGJ, RPSHPN, RPDTXS, RPOMOD, RPCLMG, RPCMGR, RPATAD, RPCTAD, RPNRTA, RPFNRT, RPPRGF, RPGFL1, RPGFL2, RPDOCO, RPKCOO, RPSOTF, RPDTPB, RPERDJ, RPPWPG, RPNETTCID, RPNETDOC, RPNETRC5, RPNETST, RPAJCL, RPRMR1 FROM F03B11

TOP 910 | 03B | F03B11 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RPDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	RPDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
3	RPKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
4	RPSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
5	RPAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
6	RPDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
7	RPDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
8	RPICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
9	RPICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
10	RPDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
11	RPFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
12	RPCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
13	RPPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
14	RPCO	Company	String	Generic Edit	5	0	Allow NULL?
15	RPGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
16	RPAID	Account ID	String	Generic Edit	8	0	Allow NULL?
17	RPPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
18	RPAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
19	RPPYR	Payor Address Number	Numeric	Generic Edit	8	0	Allow NULL?
20	RPPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
21	RPISTR	A/R Post Status	Character	Generic Edit	1	0	Allow NULL?
22	RPBALJ	Balanced - Journal Entries	Character	UDC (H00 BB)	1	0	Allow NULL?
23	RPPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
24	RPAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
25	RPAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
26	RPADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
27	RPADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
28	RPATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
29	RPATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
30	RPSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
31	RPBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
32	RPCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
33	RPCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
34	RPCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
35	RPDMCD	Domestic Entry w/Mult Currency Distr	Character	Generic Edit	1	0	Allow NULL?
36	RPACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
37	RPFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
38	RPCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
39	RPCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
40	RPCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
41	RPCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
42	RPCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
43	RPTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
44	RPEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
45	RPDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
46	RPGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
47	RPAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
48	RPAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
49	RPAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
50	RPMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
51	RPOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
52	RPSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
53	RPSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
54	RPSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
55	RPPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
56	RPDDJ	Date - Net Due	Date	Generic Edit	6	0
57	RPDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
58	RPRDDJ	Date of Last Sent Reminder	Date	Generic Edit	6	0
59	RPRDSJ	Date - Reminder Stop Until Date	Date	Generic Edit	6	0
60	RPLFCJ	Date - Last Fee Calculated (Julian)	Date	Generic Edit	6	0
61	RPSMTJ	Date - Statement	Date	Generic Edit	6	0
62	RPNBRR	Reminders - Number of Reminders to Send	Character	UDC (H00 NB)	1	0	Allow NULL?
63	RPRDRL	Level of Last Sent Reminder	Character	UDC	1	0	Allow NULL?
64	RPRMDS	Number of Sent Reminders - Total	Numeric	Generic Edit	3	0	Allow NULL?
65	RPCOLL	Collection Report (Y/N)	Character	UDC (H00 CO)	1	0	Allow NULL?
66	RPCORC	Collection Reason Code	String	UDC (03B CL)	2	0	Allow NULL?
67	RPAFC	Apply Finance Charges - Y/N	Character	UDC (H00 AF)	1	0	Allow NULL?
68	RPDNLT	Delinquency Notice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
69	RPRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
70	RPODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
71	RPODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
72	RPOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
73	RPOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
74	RPVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
75	RPPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
76	RPPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
77	RPPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
78	RPDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
79	RPLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
80	RPSDOC	Sales Document Number	Numeric	Generic Edit	8	0	Allow NULL?
81	RPSDCT	Sales Document Type	String	UDC (00 DT)	2	0	Allow NULL?
82	RPSKCO	Document Company (Sales Order)	String	Generic Edit	5	0	Allow NULL?
83	RPSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
84	RPVLDT	Date - Cleared/Value	Date	Generic Edit	6	0
85	RPCMC1	Commission Code 1	Numeric	Generic Edit	8	0	Allow NULL?
86	RPVR01	Reference	String	Generic Edit	25	0	Allow NULL?
87	RPUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
88	RPMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
89	RPRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
90	RPALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
91	RPRF	Frequency - Recurring	String	UDC (H00 RF)	2	0	Allow NULL?
92	RPDRF	Recurring Frequency # of Payments	Numeric	Generic Edit	3	0	Allow NULL?
93	RPCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
94	RPFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
95	RPITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
96	RPU	Units	Numeric	Generic Edit	15	2	Allow NULL?
97	RPUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
98	RPALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
99	RPRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
100	RPVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
101	RPVOD	Void Flag	Character	Generic Edit	1	0	Allow NULL?
102	RPRP1	A/R - A/P - Miscellaneous Code 1	Character	Generic Edit	1	0	Allow NULL?
103	RPRP2	A/R - A/P - Miscellaneous Code 2	Character	Generic Edit	1	0	Allow NULL?
104	RPRP3	A/R - A/P - Cash Rcpts/Inv Reg Code	Character	Generic Edit	1	0	Allow NULL?
105	RPAR01	A/R Reporting Code 1	String	UDC (01 01)	3	0	Allow NULL?
106	RPAR02	A/R Reporting Code 2	String	UDC (01 02)	3	0	Allow NULL?
107	RPAR03	A/R Reporting Code 3	String	UDC (01 03)	3	0	Allow NULL?
108	RPAR04	A/R Reporting Code 4	String	UDC (01 04)	3	0	Allow NULL?
109	RPAR05	A/R Reporting Code 5	String	UDC (01 05)	3	0	Allow NULL?
110	RPAR06	A/R Reporting Code 6	String	UDC (01 06)	3	0	Allow NULL?
111	RPAR07	A/R Reporting Code 7	String	UDC (01 07)	3	0	Allow NULL?
112	RPAR08	A/R Reporting Code 8	String	UDC (01 08)	3	0	Allow NULL?
113	RPAR09	A/R Reporting Code 9	String	UDC (01 09)	3	0	Allow NULL?
114	RPAR10	A/R Reporting Code 10	String	UDC (01 10)	3	0	Allow NULL?
115	RPISTC	A/R Post to Cash Management	Character	Generic Edit	1	0	Allow NULL?
116	RPPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
117	RPURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
118	RPURDT	User Reserved Date	Date	Generic Edit	6	0
119	RPURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
120	RPURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
121	RPURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
122	RPRNID	Batch Run ID (Internal)	Numeric	Generic Edit	3	0	Allow NULL?
123	RPPPDI	Date - Invoice Printed	Date	Generic Edit	6	0
124	RPTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
125	RPUSER	User ID	String	Generic Edit	10	0	Allow NULL?
126	RPJCL	Date Invoice Closed	Date	Generic Edit	6	0
127	RPPID	Program ID	String	Generic Edit	10	0	Allow NULL?
128	RPUPMJ	Date - Updated	Date	Generic Edit	6	0
129	RPUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
130	RPDDEX	Deduction Reason Code	String	UDC (03B CR)	2	0	Allow NULL?
131	RPJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
132	RPHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
133	RPHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
134	RPSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
135	RPDTXS	Deferred Tax Status - VAT	Character	Generic Edit	1	0	Allow NULL?
136	RPOMOD	Originating System	Character	UDC (03B OS)	1	0	Allow NULL?
137	RPCLMG	Collection Manager	String	Generic Edit (01 CM)	10	0	Allow NULL?
138	RPCMGR	Credit Manager	String	UDC (01 CR)	10	0	Allow NULL?
139	RPATAD	Amount - To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
140	RPCTAD	Amount - Currency To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
141	RPNRTA	Non-Recoverable Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
142	RPFNRT	Foreign Non-Recoverable Tax	Numeric	Generic Edit	15	2	Allow NULL?
143	RPPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
144	RPGFL1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
145	RPGFL2	Generic Flag 2	Character	Generic Edit	1	0	Allow NULL?
146	RPDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
147	RPKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
148	RPSOTF	Sales Order Tax Flag	Character	Generic Edit	1	0	Allow NULL?
149	RPDTPB	Notification Payment Date	Date	Generic Edit	6	0
150	RPERDJ	Date - For Exchange Rate - Julian	Date	Generic Edit	6	0
151	RPPWPG	Pay When Paid Group Number	Numeric	Generic Edit	15	0	Allow NULL?
152	RPNETTCID	Netting Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
153	RPNETDOC	Netting Document Number	Numeric	Generic Edit	15	0	Allow NULL?
154	RPNETRC5	Netting Line ID	Numeric	Generic Edit	6	0	Allow NULL?
155	RPNETST	Netting Status Code	Character	UDC (00 NS)	1	0	Allow NULL?
156	RPAJCL	Actual Date Invoice Closed	Date	Generic Edit	6	0
157	RPRMR1	Generic AR Receipt Matching Reference1	String	Generic Edit	50	0	Allow NULL?

TOP 910 | 03B | F03B11 INDEXES

Number

Description

Doc Number Doc Type +A (Primary/Unique)

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

Address Number Due Date +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DDJ	Date - Net Due	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	Ascending
6	SFX	Document Pay Item	Ascending

Batch Type Number +A

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	Ascending
6	SFX	Document Pay Item	Ascending
7	CO	Company	Ascending
8	GLC	G/L Offset	Ascending

Batch Type Number +B

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	CO	Company	Ascending
4	GLC	G/L Offset	Ascending
5	PN	Period Number - General Ledger	Ascending
6	FY	Fiscal Year	Ascending
7	CTRY	Century	Ascending

Batch Type Number Post

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	POST	G/L Posted Code	Ascending

Address Number Company

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	KCO	Document Company	Ascending

PaymentID DocType Doc KCO SFX

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	Ascending
2	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	KCO	Document Company	Ascending
5	SFX	Document Pay Item	Ascending

StamentNo AddressNumber

Element	Alias	Description	Sequence
1	CTL	Control/Statement Field	Ascending
2	AN8	Address Number	Ascending

Payor Number Due Date +

Element	Alias	Description	Sequence
1	PYR	Payor Address Number	Ascending
2	DDJ	Date - Net Due	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	Ascending
6	SFX	Document Pay Item	Ascending

Doc Number Doc Type +B

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

Document 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	SFX	Document Pay Item	Ascending

Company PayorAddressNumber +

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	PYR	Payor Address Number	Ascending
3	AN8	Address Number	Ascending
4	CRCD	Currency Code - From	Ascending
5	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	DCT	Document Type	Ascending
8	KCO	Document Company	Ascending

PurchaseOrder GLClass +

Element	Alias	Description	Sequence
1	PO	Purchase Order	Ascending
2	GLC	G/L Offset	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

PurchaseOrder InvoiceDate

Element	Alias	Description	Sequence
1	PO	Purchase Order	Ascending
2	DIVJ	Date - Invoice - Julian	Ascending

AddressNumber DocumentType +

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

AddressNumber GLDate +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	KCO	Document Company	Ascending
6	SFX	Document Pay Item	Ascending

AddressNumber LineNumber +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	LNID	Line Number	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DDJ	Date - Net Due	Ascending
5	PO	Purchase Order	Ascending

DocNumber DocType DocCompany

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

AddressNum(AN8) Company(CO)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CO	Company	Ascending

PuchaseOrder PO Type +

Element	Alias	Description	Sequence
1	PO	Purchase Order	Ascending
2	PDCT	Document Type - Purchase Order	Ascending
3	PKCO	Document Company (Purchase Order)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending

AddressNumber Company +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CO	Company	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
4	VDGJ	Void Date - For G/L - Julian	Ascending

PayWhenPaidGroupNumber +

Element	Alias	Description	Sequence
1	PWPG	Pay When Paid Group Number	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending

NetTransID NetDocNum +A

Element	Alias	Description	Sequence
1	NETTCID	Netting Transaction ID	Ascending
2	NETDOC	Netting Document Number	Ascending
3	NETRC5	Netting Line ID	Ascending

NetTransID NetDocNum +B

Element	Alias	Description	Sequence
1	NETTCID	Netting Transaction ID	Ascending
2	NETDOC	Netting Document Number	Ascending
3	NETRC5	Netting Line ID	Ascending
4	VOD	Void Flag	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

157 COLUMNS | 24 INDEXES | 910 | 03B | F03B11 TABLE

TOP 910 | 03B | F03B11 COLUMNS

TOP 910 | 03B | F03B11 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

157 COLUMNS | 24 INDEXES | 910 | 03B | F03B11 TABLE

TOP910 | 03B | F03B11 COLUMNS

TOP910 | 03B | F03B11 INDEXES

TOP 910 | 03B | F03B11 COLUMNS

TOP 910 | 03B | F03B11 INDEXES