	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

210 COLUMNS | 7 INDEXES | 920 | 03 | F03012 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03: Accounts Receivable
1	920	F03012	AI	210	7	Customer Master by Line of Business	Master Files	03: Accounts Receivable

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 AIAN8, AICO, AIARC, AIMCUR, AIOBAR, AIAIDR, AIKCOR, AIDCAR, AIDTAR, AICRCD, AITXA1, AIEXR1, AIACL, AIHDAR, AITRAR, AISTTO, AIRYIN, AISTMT, AIARPY, AIATCS, AISITO, AISQNL, AIALGM, AICYCN, AIBO, AITSTA, AICKHC, AIDLC, AIDNLT, AIPLCR, AIRVDJ, AIDSO, AICMGR, AICLMG, AIDLQT, AIDLQJ, AINBRR, AICOLL, AINBR1, AINBR2, AINBR3, AINBCL, AIAFC, AIFD, AIFP, AICFCE, AIAB2, AIDT1J, AIDFIJ, AIDLIJ, AIABC1, AIABC2, AIABC3, AIFNDJ, AIDLP, AIDB, AIDNBJ, AITRW, AITWDJ, AIAVD, AICRCA, AIAD, AIAFCP, AIAFCY, AIASTY, AISPYE, AIAHB, AIALP, AIABAM, AIABA1, AIAPRC, AIMAXO, AIMINO, AIOYTD, AIOPY, AIPOPN, AIDAOJ, AIAN8R, AIBADT, AICPGP, AIORTP, AITRDC, AIINMG, AIEXHD, AIHOLD, AIROUT, AISTOP, AIZON, AICARS, AIDEL1, AIDEL2, AILTDT, AIFRTH, AIAFT, AIAPTS, AISBAL, AIBACK, AIPORQ, AIPRIO, AIARTO, AIINVC, AIICON, AIBLFR, AINIVD, AILEDJ, AIPLST, AIMORD, AICMC1, AICMR1, AICMC2, AICMR2, AIPALC, AIVUMD, AIWUMD, AIEDPM, AIEDII, AIEDCI, AIEDQD, AIEDAD, AIEDF1, AIEDF2, AISI01, AISI02, AISI03, AISI04, AISI05, AIURCD, AIURAT, AIURAB, AIURDT, AIURRF, AICP01, AIASN, AIDSPA, AICRMD, AIPLY, AIMAN8, AIARL, AIAMCR, AIAC01, AIAC02, AIAC03, AIAC04, AIAC05, AIAC06, AIAC07, AIAC08, AIAC09, AIAC10, AIAC11, AIAC12, AIAC13, AIAC14, AIAC15, AIAC16, AIAC17, AIAC18, AIAC19, AIAC20, AIAC21, AIAC22, AIAC23, AIAC24, AIAC25, AIAC26, AIAC27, AIAC28, AIAC29, AIAC30, AISLPG, AISLDW, AICFPP, AICFSP, AICFDF, AIRQ01, AIRQ02, AIDR03, AIDR04, AIRQ03, AIRQ04, AIRQ05, AIRQ06, AIRQ07, AIRQ08, AIDR08, AIDR09, AIRQ09, AIUSER, AIPID, AIUPMJ, AIUPMT, AIJOBN, AIPRGF, AIBYAL, AIBSC, AIASHL, AIPRSN, AIOPBO, AIAPSB, AITIER1, AIPWPCP, AICUSTS, AISTOF, AITERRID, AICIG, AITORG, AIDTEE, AISYNCS, AICAAD, AIGOPASF FROM F03012

TOP 920 | 03 | F03012 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	AIAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	AICO	Company	String	Generic Edit	5	0	Allow NULL?
3	AIARC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
4	AIMCUR	Business Unit - A/R Default	String	Generic Edit	12	0	Allow NULL?
5	AIOBAR	Object - Accounts Receivable Default	String	Generic Edit	6	0	Allow NULL?
6	AIAIDR	Subsidiary - Accounts Receivable Default	String	Generic Edit	8	0	Allow NULL?
7	AIKCOR	Document Company (A/R Model Document)	String	Generic Edit	5	0	Allow NULL?
8	AIDCAR	Document - A/R Default for Model JE	Numeric	Generic Edit	8	0	Allow NULL?
9	AIDTAR	Document Type - A/R Default for Model JE	String	UDC (00 DT)	2	0	Allow NULL?
10	AICRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
11	AITXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
12	AIEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
13	AIACL	Amount - Credit Limit	Numeric	Generic Edit	15	0	Allow NULL?
14	AIHDAR	Hold Invoices	Character	UDC (H01 HC)	1	0	Allow NULL?
15	AITRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
16	AISTTO	Send Statement to C/P	Character	UDC (H00 SV)	1	0	Allow NULL?
17	AIRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
18	AISTMT	Print Statement Y/N	Character	UDC (H03 ST)	1	0	Allow NULL?
19	AIARPY	Alternate Payor	Numeric	Generic Edit	8	0	Allow NULL?
20	AIATCS	Auto Receipt (Y/N)	Character	Generic Edit	1	0	Allow NULL?
21	AISITO	Send Invoice to C/P	Character	UDC (H00 SI)	1	0	Allow NULL?
22	AISQNL	Ledger Inquiry Sequence	Character	UDC (H01 SQ)	1	0	Allow NULL?
23	AIALGM	Auto Receipt Algorithm Method	String	UDC (01 AA)	2	0	Allow NULL?
24	AICYCN	Statement Cycle	String	Generic Edit	2	0	Allow NULL?
25	AIBO	Balance Forward-Open Item	Character	UDC (H03 BO)	1	0	Allow NULL?
26	AITSTA	Temporary Credit Message	String	UDC (00 CM)	2	0	Allow NULL?
27	AICKHC	Credit Check Handling Code	Character	Generic Edit	1	0	Allow NULL?
28	AIDLC	Date - Last Credit Review	Date	Generic Edit	6	0
29	AIDNLT	Delinquency Notice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
30	AIPLCR	Person Completing Last Credit Limit Rev	String	Generic Edit	10	0	Allow NULL?
31	AIRVDJ	Date - Recall for Review	Date	Generic Edit	6	0
32	AIDSO	Days Sales Outstanding	Numeric	Generic Edit	5	0	Allow NULL?
33	AICMGR	Credit Manager	String	UDC (01 CR)	10	0	Allow NULL?
34	AICLMG	Collection Manager	String	UDC (01 CM)	10	0	Allow NULL?
35	AIDLQT	Dunning Letters - Number Sent	Numeric	Generic Edit	3	0	Allow NULL?
36	AIDLQJ	Date - Last Dunning Letter	Date	Generic Edit	6	0
37	AINBRR	Reminders - Number of Reminders to Send	Character	UDC (H00 NB)	1	0	Allow NULL?
38	AICOLL	Collection Report (Y/N)	Character	UDC (H00 CO)	1	0	Allow NULL?
39	AINBR1	Number of Sent Reminders - 1	Numeric	Generic Edit	3	0	Allow NULL?
40	AINBR2	Number of Sent Reminders - 2	Numeric	Generic Edit	3	0	Allow NULL?
41	AINBR3	Number of Sent Reminders - 3	Numeric	Generic Edit	3	0	Allow NULL?
42	AINBCL	Number of Invoices to Collection Report	Numeric	Generic Edit	3	0	Allow NULL?
43	AIAFC	Apply Finance Charges - Y/N	Character	UDC (H00 AF)	1	0	Allow NULL?
44	AIFD	Finance Charge Days	Numeric	Generic Edit	3	0	Allow NULL?
45	AIFP	Percentage Factor	Numeric	Generic Edit	9	6	Allow NULL?
46	AICFCE	Finance Charge - Create Entries Y/N	Character	Generic Edit	1	0	Allow NULL?
47	AIAB2	Address Book - Pending Cash Receipts	Character	Generic Edit	1	0	Allow NULL?
48	AIDT1J	Date - Last Statement Date	Date	Generic Edit	6	0
49	AIDFIJ	Date - First Invoice	Date	Generic Edit	6	0
50	AIDLIJ	Date - Last Invoice (Julian)	Date	Generic Edit	6	0
51	AIABC1	ABC Code Sales	Character	UDC (H01 A1)	1	0	Allow NULL?
52	AIABC2	ABC Code 2 - Investment - Inventory	Character	UDC (H01 A2)	1	0	Allow NULL?
53	AIABC3	ABC Code Average Days	Character	UDC (H01 A3)	1	0	Allow NULL?
54	AIFNDJ	Date - Financial Stmts on Hand	Date	Generic Edit	6	0
55	AIDLP	Date - Last Paid	Date	Generic Edit	6	0
56	AIDB	Dun & Bradstreet Rating	String	UDC (01 DB)	3	0	Allow NULL?
57	AIDNBJ	Date - Dun & Bradstreet	Date	Generic Edit	6	0
58	AITRW	TRW Rating	String	UDC (01 TR)	3	0	Allow NULL?
59	AITWDJ	TRW Date	Date	Generic Edit	6	0
60	AIAVD	Average Days Late	Numeric	Generic Edit	3	0	Allow NULL?
61	AICRCA	Currency Code - A/B Amounts	String	Generic Edit	3	0	Allow NULL?
62	AIAD	Amount - Due	Numeric	Generic Edit	15	2	Allow NULL?
63	AIAFCP	Amount - Prior Year Finance Charges	Numeric	Generic Edit	15	2	Allow NULL?
64	AIAFCY	Amount - YTD Finance Charges	Numeric	Generic Edit	15	2	Allow NULL?
65	AIASTY	Amount - Invoiced This Year	Numeric	Generic Edit	15	2	Allow NULL?
66	AISPYE	Amount - Invoiced Prior Year	Numeric	Generic Edit	15	2	Allow NULL?
67	AIAHB	Amount - High Balance	Numeric	Generic Edit	15	2	Allow NULL?
68	AIALP	Amount - Last Applied	Numeric	Generic Edit	15	2	Allow NULL?
69	AIABAM	Amount - Address Book	Numeric	Generic Edit	15	2	Allow NULL?
70	AIABA1	Amount - Address Book	Numeric	Generic Edit	15	2	Allow NULL?
71	AIAPRC	Amount - Open Order	Numeric	Generic Edit	15	2	Allow NULL?
72	AIMAXO	Maximum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
73	AIMINO	Minimum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
74	AIOYTD	Orders - Year-to-Date	Numeric	Generic Edit	3	0	Allow NULL?
75	AIOPY	Orders - Prior Year	Numeric	Generic Edit	3	0	Allow NULL?
76	AIPOPN	Person Opening Account	String	Generic Edit	10	0	Allow NULL?
77	AIDAOJ	Date - Account Opened	Date	Generic Edit	6	0
78	AIAN8R	Related - Address Number	Numeric	Generic Edit	8	0	Allow NULL?
79	AIBADT	Billing Address Type	Character	UDC (H42 BA)	1	0	Allow NULL?
80	AICPGP	Customer Price Group	String	UDC (40 PC)	8	0	Allow NULL?
81	AIORTP	Order Template	String	UDC (40 OT)	8	0	Allow NULL?
82	AITRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
83	AIINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
84	AIEXHD	Credit Hold Exempt	Character	Generic Edit	1	0	Allow NULL?
85	AIHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
86	AIROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
87	AISTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
88	AIZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
89	AICARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
90	AIDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
91	AIDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
92	AILTDT	Transit Days	Numeric	Generic Edit	5	0	Allow NULL?
93	AIFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
94	AIAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
95	AIAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
96	AISBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
97	AIBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
98	AIPORQ	Customer PO Required (Y/N)	Character	Generic Edit	1	0	Allow NULL?
99	AIPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
100	AIARTO	Credit Check Level	Character	UDC (H42 AR)	1	0	Allow NULL?
101	AIINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
102	AIICON	Invoice Consolidation	Character	Generic Edit	1	0	Allow NULL?
103	AIBLFR	Billing Frequency	Character	UDC (H42 BL)	1	0	Allow NULL?
104	AINIVD	Next Invoice Date	Date	Generic Edit	6	0
105	AILEDJ	Date - License Expiration	Date	Generic Edit	6	0
106	AIPLST	Price Pick List (Y/N)	Character	Generic Edit	1	0	Allow NULL?
107	AIMORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
108	AICMC1	Commission Code 1	Numeric	Generic Edit	8	0	Allow NULL?
109	AICMR1	Rate - Commission 1	Numeric	Generic Edit	7	3	Allow NULL?
110	AICMC2	Commission Code 2	Numeric	Generic Edit	8	0	Allow NULL?
111	AICMR2	Rate - Commission 2	Numeric	Generic Edit	7	3	Allow NULL?
112	AIPALC	Pallet Control	Character	Generic Edit	1	0	Allow NULL?
113	AIVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
114	AIWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
115	AIEDPM	Batch Processing Mode	Character	UDC (H40 EE)	1	0	Allow NULL?
116	AIEDII	Item Type Identifier	Character	UDC (40 II)	1	0	Allow NULL?
117	AIEDCI	Customer Type Identifier	Character	UDC (40 CI)	1	0	Allow NULL?
118	AIEDQD	Quantity Decimals	Numeric	Generic Edit	1	0	Allow NULL?
119	AIEDAD	Amount Decimals	Numeric	Generic Edit	1	0	Allow NULL?
120	AIEDF1	Delivery Note	Character	Generic Edit	1	0	Allow NULL?
121	AIEDF2	Item Restrictions	Character	UDC (H40 ED)	1	0	Allow NULL?
122	AISI01	Partial Order Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
123	AISI02	COA Print (Y/N)	Character	Generic Edit	1	0	Allow NULL?
124	AISI03	Override Territory Id Assignment	Character	Generic Edit	1	0	Allow NULL?
125	AISI04	Special Instruction 04	Character	Generic Edit	1	0	Allow NULL?
126	AISI05	Special Instruction 05	Character	Generic Edit	1	0	Allow NULL?
127	AIURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
128	AIURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
129	AIURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
130	AIURDT	User Reserved Date	Date	Generic Edit	6	0
131	AIURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
132	AICP01	Sales Price Based On Date	Character	UDC (40 DB)	1	0	Allow NULL?
133	AIASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
134	AIDSPA	Print Adjustments on Invoice (Y/N)	Character	Generic Edit	1	0	Allow NULL?
135	AICRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
136	AIPLY	Policy Number (Internal)	Numeric	Generic Edit	5	0	Allow NULL?
137	AIMAN8	Deduction Manager	Numeric	Generic Edit	8	0	Allow NULL?
138	AIARL	Auto Receipts Execution List	String	Generic Edit	10	0	Allow NULL?
139	AIAMCR	Administration Credit Limit	Numeric	Generic Edit	15	0	Allow NULL?
140	AIAC01	Category Code - Address Book 01	String	UDC (01 01)	3	0	Allow NULL?
141	AIAC02	Category Code - Address Book 02	String	UDC (01 02)	3	0	Allow NULL?
142	AIAC03	Category Code - Address Book 03	String	UDC (01 03)	3	0	Allow NULL?
143	AIAC04	Category Code - Address Book 04	String	UDC (01 04)	3	0	Allow NULL?
144	AIAC05	Category Code - Address Book 05	String	UDC (01 05)	3	0	Allow NULL?
145	AIAC06	Category Code - Address Book 06	String	UDC (01 06)	3	0	Allow NULL?
146	AIAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
147	AIAC08	Category Code - Address Book 08	String	UDC (01 08)	3	0	Allow NULL?
148	AIAC09	Category Code - Address Book 09	String	UDC (01 09)	3	0	Allow NULL?
149	AIAC10	Category Code - Address Book 10	String	UDC (01 10)	3	0	Allow NULL?
150	AIAC11	Sales Region	String	UDC (01 11)	3	0	Allow NULL?
151	AIAC12	Category Code - Address Book 12	String	UDC (01 12)	3	0	Allow NULL?
152	AIAC13	Category Code - Address Book 13	String	UDC (01 13)	3	0	Allow NULL?
153	AIAC14	Category Code - Address Book 14	String	UDC (01 14)	3	0	Allow NULL?
154	AIAC15	Category Code - Address Book 15	String	UDC (01 15)	3	0	Allow NULL?
155	AIAC16	Category Code - Address Book 16	String	UDC (01 16)	3	0	Allow NULL?
156	AIAC17	Category Code - Address Book 17	String	UDC (01 17)	3	0	Allow NULL?
157	AIAC18	Category Code - Address Book 18	String	UDC (01 18)	3	0	Allow NULL?
158	AIAC19	Category Code - Address Book 19	String	UDC (01 19)	3	0	Allow NULL?
159	AIAC20	Category Code - Address Book 20	String	UDC (01 20)	3	0	Allow NULL?
160	AIAC21	Category Code - Address Book 21	String	UDC (01 21)	3	0	Allow NULL?
161	AIAC22	Category Code - Address Book 22	String	UDC (01 22)	3	0	Allow NULL?
162	AIAC23	Category Code - Address Book 23	String	UDC (01 23)	3	0	Allow NULL?
163	AIAC24	Category Code - Address Book 24	String	UDC (01 24)	3	0	Allow NULL?
164	AIAC25	Category Code - Address Book 25	String	UDC (01 25)	3	0	Allow NULL?
165	AIAC26	Category Code - Address Book 26	String	UDC (01 26)	3	0	Allow NULL?
166	AIAC27	Category Code - Address Book 27	String	UDC (01 27)	3	0	Allow NULL?
167	AIAC28	Category Code - Address Book 28	String	UDC (01 28)	3	0	Allow NULL?
168	AIAC29	Category Code - Address Book 29	String	UDC (01 29)	3	0	Allow NULL?
169	AIAC30	Category Code - Address Book 30	String	UDC (01 30)	3	0	Allow NULL?
170	AISLPG	Program Name - Shipping Labels	String	Generic Edit	10	0	Allow NULL?
171	AISLDW	Version Name - Shipping Label Program	String	Generic Edit	10	0	Allow NULL?
172	AICFPP	Configuration Pick and Pack	String	Generic Edit	18	0	Allow NULL?
173	AICFSP	Configuration Standard Carton Pack	String	Generic Edit	18	0	Allow NULL?
174	AICFDF	Default Configuration	Character	Generic Edit	1	0	Allow NULL?
175	AIRQ01	Requires Packaging Code	Character	Generic Edit	1	0	Allow NULL?
176	AIRQ02	Requires Weight Code	Character	Generic Edit	1	0	Allow NULL?
177	AIDR03	Default Identification Code Qualifier 1	String	UDC (41 X3)	2	0	Allow NULL?
178	AIDR04	Default Identification Code Qualifier 2	String	UDC (41 X3)	2	0	Allow NULL?
179	AIRQ03	Requires Identification - Code 1	Character	Generic Edit	1	0	Allow NULL?
180	AIRQ04	Requires Identification - Code 2	Character	Generic Edit	1	0	Allow NULL?
181	AIRQ05	Requires Transportation Method	Character	Generic Edit	1	0	Allow NULL?
182	AIRQ06	Requires Routing	Character	Generic Edit	1	0	Allow NULL?
183	AIRQ07	Requires Equipment	Character	Generic Edit	1	0	Allow NULL?
184	AIRQ08	Requires Reference Number 1	Character	Generic Edit	1	0	Allow NULL?
185	AIDR08	Default Reference Number Qualifier 1	String	UDC (41 X6)	2	0	Allow NULL?
186	AIDR09	Default Identification Code Qualifier	String	UDC (41 X6)	2	0	Allow NULL?
187	AIRQ09	Requires Reference Number 2	Character	Generic Edit	1	0	Allow NULL?
188	AIUSER	User ID	String	Generic Edit	10	0	Allow NULL?
189	AIPID	Program ID	String	Generic Edit	10	0	Allow NULL?
190	AIUPMJ	Date - Updated	Date	Generic Edit	6	0
191	AIUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
192	AIJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
193	AIPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
194	AIBYAL	Bypass Audit Logging	Character	Generic Edit	1	0	Allow NULL?
195	AIBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
196	AIASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
197	AIPRSN	Preference Schedule	String	Generic Edit	8	0	Allow NULL?
198	AIOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
199	AIAPSB	APS Business Unit	Character	Generic Edit	1	0	Allow NULL?
200	AITIER1	Tier	String	UDC (01 TI)	5	0	Allow NULL?
201	AIPWPCP	Pay When Paid Cash Receipt Threshold	Numeric	Generic Edit	5	0	Allow NULL?
202	AICUSTS	Customer Status	Character	UDC (01 TY)	1	0	Allow NULL?
203	AISTOF	Override Sales Team Assignment	Character	Generic Edit	1	0	Allow NULL?
204	AITERRID	Territory Id	Numeric	Generic Edit	15	0	Allow NULL?
205	AICIG	Industry Group	Numeric	Generic Edit	15	0	Allow NULL?
206	AITORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
207	AIDTEE	Date - Entered	JDE UTime	Generic Edit	11	0
208	AISYNCS	Synchronization Status	Numeric	UDC (90CA SY)	2	0	Allow NULL?
209	AICAAD	Server Status	Numeric	UDC (90CA SE)	2	0	Allow NULL?
210	AIGOPASF	GOP Arrival or Ship Flag	Character	UDC (34A AS)	1	0	Allow NULL?

TOP 920 | 03 | F03012 INDEXES

Number

Description

ADDRESS_COMPANY (Primary/Unique)

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

POLICY AN8 CO (Unique)

Element	Alias	Description	Sequence
1	PLY	Policy Number (Internal)	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending

ADDRESS_NO

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

COMPANY ADDRESS

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

INDUSTRY ADDRESS COMPANY

Element	Alias	Description	Sequence
1	CIG	Industry Group	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending

TERRITORYID ADDRESS COMPANY

Element	Alias	Description	Sequence
1	TERRID	Territory Id	Ascending
2	AN8	Address Number	Ascending
3	CO	Company	Ascending

CUSTOMER GROUP CATEGORY CODES

Element	Alias	Description	Sequence
1	CPGP	Customer Price Group	Ascending
2	AC01	Category Code - Address Book 01	Ascending
3	AC02	Category Code - Address Book 02	Ascending
4	AC03	Category Code - Address Book 03	Ascending
5	AC04	Category Code - Address Book 04	Ascending
6	AC05	Category Code - Address Book 05	Ascending
7	AC06	Category Code - Address Book 06	Ascending
8	AC07	Category Code - Address Book 07	Ascending
9	AC08	Category Code - Address Book 08	Ascending
10	AC09	Category Code - Address Book 09	Ascending
11	AC10	Category Code - Address Book 10	Ascending
12	AC11	Sales Region	Ascending
13	AC12	Category Code - Address Book 12	Ascending
14	AC13	Category Code - Address Book 13	Ascending
15	AC14	Category Code - Address Book 14	Ascending
16	AC15	Category Code - Address Book 15	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

210 COLUMNS | 7 INDEXES | 920 | 03 | F03012 TABLE

TOP 920 | 03 | F03012 COLUMNS

TOP 920 | 03 | F03012 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

210 COLUMNS | 7 INDEXES | 920 | 03 | F03012 TABLE

TOP920 | 03 | F03012 COLUMNS

TOP920 | 03 | F03012 INDEXES

TOP 920 | 03 | F03012 COLUMNS

TOP 920 | 03 | F03012 INDEXES