	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

99 COLUMNS | 6 INDEXES | 812 | 45 | F4511W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
45: Advanced Pricing
1	812	F4511W	AP	99	6	Pricing Structure View	Files	45: Advanced Pricing	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 APCTID, APJOBS, APPEID, APTCID, APOSEQ, APAST, APPRGR, APCPGP, APSDGR, APPRFR, APLBT, APGLC, APSBIF, APACNT, APLNTY, APMDED, APABAS, APOLVL, APTXB, APPA01, APPA02, APPA03, APPA04, APPA05, APENBM, APSRFLAG, APUSADJ, APATIER, APBTIER, APAPRP1, APAPRP2, APAPRP3, APAPRP4, APAPRP5, APAPRP6, APADJGRP, APMEADJ, APPDCL, APITM, APLITM, APAITM, APAN8, APIGID, APCGID, APOGID, APCRCD, APMNQ, APUOM, APEFTJ, APEXDJ, APBSCD, APLEDG, APFRMN, APFVTR, APFGY, APATID, APNBRORD, APUOMVID, APFVUM, APPARTFG, APAPRS, APIGP1, APIGP2, APIGP3, APIGP4, APIGP5, APIGP6, APIGP7, APIGP8, APIGP9, APIGP10, APCGP1, APCGP2, APCGP3, APCGP4, APCGP5, APCGP6, APCGP7, APCGP8, APCGP9, APCGP10, APSDV1, APSDV2, APSDV3, APSDV4, APSDV5, APSDV6, APSDV7, APSDV8, APSDV9, APSDV10, APASN, APURCD, APURDT, APURAT, APURAB, APURRF, APMCU, APCO FROM F4511W

TOP 812 | 45 | F4511W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	APCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	APJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	APPEID	Process ID	Numeric	Generic Edit	15	0	Allow NULL?
4	APTCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
5	APOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
6	APAST	Price Adjustment Name	String	UDC (40 TY)	8	0	Allow NULL?
7	APPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
8	APCPGP	Customer Price Group	String	UDC (40 PC)	8	0	Allow NULL?
9	APSDGR	Order Detail Group	String	UDC (40 SD)	8	0	Allow NULL?
10	APPRFR	Preference Type	String	UDC (40 PR)	2	0	Allow NULL?
11	APLBT	Level Break Type	Character	UDC (40 LT)	1	0	Allow NULL?
12	APGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
13	APSBIF	Subledger Information	Character	UDC (40 SI)	1	0	Allow NULL?
14	APACNT	Adjustment Control Code	Character	UDC (40 CO)	1	0	Allow NULL?
15	APLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
16	APMDED	Manual Addition/Change (Y/N)	Character	Generic Edit	1	0	Allow NULL?
17	APABAS	Override Price (Y/N)	Character	Generic Edit	1	0	Allow NULL?
18	APOLVL	Adjustment Level	Character	UDC (40 AL)	1	0	Allow NULL?
19	APTXB	Adjustment Taxable	Character	UDC (H00 TV)	1	0	Allow NULL?
20	APPA01	Rebate Beneficiary	Character	UDC (40 RA)	1	0	Allow NULL?
21	APPA02	Mandatory Adjustment	Character	Generic Edit	1	0	Allow NULL?
22	APPA03	Exclude from Payment Discount	Character	Generic Edit	1	0	Allow NULL?
23	APPA04	Target Application	Character	UDC (40 TA)	1	0	Allow NULL?
24	APPA05	Price Adjustment Code 05	Character	Generic Edit	1	0	Allow NULL?
25	APENBM	Enable Basket Master	Character	Check Box	1	0	Allow NULL?
26	APSRFLAG	Sliding Rate Flag	Character	Generic Edit	1	0	Allow NULL?
27	APUSADJ	Up Sell Adjustment	Character	Generic Edit	1	0	Allow NULL?
28	APATIER	Accumulate at Tier	Numeric	Generic Edit	2	0	Allow NULL?
29	APBTIER	Beneficiary Tier	Numeric	Generic Edit	2	0	Allow NULL?
30	APAPRP1	Pricing Reporting Code 1	String	UDC (45 P1)	3	0	Allow NULL?
31	APAPRP2	Pricing Reporting Code 2	String	UDC (45 P2)	3	0	Allow NULL?
32	APAPRP3	Pricing Reporting Code 3	String	UDC (45 P3)	3	0	Allow NULL?
33	APAPRP4	Pricing Reporting Code 4	String	UDC (45 P4)	6	0	Allow NULL?
34	APAPRP5	Pricing Reporting Code 5	String	UDC (45 P5)	6	0	Allow NULL?
35	APAPRP6	Pricing Reporting Code 6	String	UDC (45 P6)	6	0	Allow NULL?
36	APADJGRP	Mutually Exclusive Adjustment Group	String	UDC (45 AG)	10	0	Allow NULL?
37	APMEADJ	Mutually Exclusive Adjustment	Character	Generic Edit	1	0	Allow NULL?
38	APPDCL	Promotion Display Control	Character	Check Box	1	0	Allow NULL?
39	APITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
40	APLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
41	APAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
42	APAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
43	APIGID	Item Group Key ID	Numeric	Generic Edit	8	0	Allow NULL?
44	APCGID	Customer Group Key ID	Numeric	Generic Edit	8	0	Allow NULL?
45	APOGID	Order Group Key ID	Numeric	Generic Edit	8	0	Allow NULL?
46	APCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
47	APMNQ	Quantity - From	Numeric	Generic Edit	15	2	Allow NULL?
48	APUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
49	APEFTJ	Date - Effective	Date	Generic Edit	6	0
50	APEXDJ	Date - Expired	Date	Generic Edit	6	0
51	APBSCD	Basis Code	Character	UDC (40 BC)	1	0	Allow NULL?
52	APLEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
53	APFRMN	Price Formula Name	String	UDC (40 FM)	10	0	Allow NULL?
54	APFVTR	Factor Value	Numeric	Generic Edit	15	5	Allow NULL?
55	APFGY	Free Goods (Y/N)	Character	Generic Edit	1	0	Allow NULL?
56	APATID	Price Adjustment Key ID	Numeric	Generic Edit	8	0	Allow NULL?
57	APNBRORD	Number of Orders	Numeric	Generic Edit	15	0	Allow NULL?
58	APUOMVID	Unit of Measure - Volume Incentives	String	UDC (00 UM)	2	0	Allow NULL?
59	APFVUM	Factor Value Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
60	APPARTFG	Price Partial Quantites Flag	Character	Check Box	1	0	Allow NULL?
61	APAPRS	Approval Status	Character	UDC (45 AS)	1	0	Allow NULL?
62	APIGP1	Item Group Category Code 01	String	Generic Edit	6	0	Allow NULL?
63	APIGP2	Item Group Category Code 02	String	Generic Edit	6	0	Allow NULL?
64	APIGP3	Item Group Category Code 03	String	Generic Edit	6	0	Allow NULL?
65	APIGP4	Item Group Category Code 04	String	Generic Edit	6	0	Allow NULL?
66	APIGP5	Item Group Category Code 05	String	Generic Edit	6	0	Allow NULL?
67	APIGP6	Item Group Category Code 06	String	Generic Edit	6	0	Allow NULL?
68	APIGP7	Item Group Category Code 07	String	Generic Edit	6	0	Allow NULL?
69	APIGP8	Item Group Category Code 08	String	Generic Edit	6	0	Allow NULL?
70	APIGP9	Item Group Category Code 09	String	Generic Edit	6	0	Allow NULL?
71	APIGP10	Item Group Category Code 10	String	Generic Edit	6	0	Allow NULL?
72	APCGP1	Customer Group Category Code 01	String	Generic Edit	3	0	Allow NULL?
73	APCGP2	Customer Group Category Code 02	String	Generic Edit	3	0	Allow NULL?
74	APCGP3	Customer Group Category Code 03	String	Generic Edit	3	0	Allow NULL?
75	APCGP4	Customer Group Category Code 04	String	Generic Edit	3	0	Allow NULL?
76	APCGP5	Customer Group Category Code 05	String	Generic Edit	3	0	Allow NULL?
77	APCGP6	Customer Group Category Code 06	String	Generic Edit	3	0	Allow NULL?
78	APCGP7	Customer Group Category Code 07	String	Generic Edit	3	0	Allow NULL?
79	APCGP8	Customer Group Category Code 08	String	Generic Edit	3	0	Allow NULL?
80	APCGP9	Customer Group Category Code 09	String	Generic Edit	3	0	Allow NULL?
81	APCGP10	Customer Group Category Code 10	String	Generic Edit	3	0	Allow NULL?
82	APSDV1	Sales Detail Value 01	String	Generic Edit	12	0	Allow NULL?
83	APSDV2	Sales Detail Value 02	String	Generic Edit	12	0	Allow NULL?
84	APSDV3	Sales Detail Value 03	String	Generic Edit	12	0	Allow NULL?
85	APSDV4	Sales Detail Value 04	String	Generic Edit	12	0	Allow NULL?
86	APSDV5	Sales Detail Value 05	String	Generic Edit	12	0	Allow NULL?
87	APSDV6	Sales Detail Value 06	String	Generic Edit	12	0	Allow NULL?
88	APSDV7	Sales Detail Value 07	String	Generic Edit	12	0	Allow NULL?
89	APSDV8	Sales Detail Value 08	String	Generic Edit	12	0	Allow NULL?
90	APSDV9	Sales Detail Value 09	String	Generic Edit	12	0	Allow NULL?
91	APSDV10	Sales Detail Value 10	String	Generic Edit	12	0	Allow NULL?
92	APASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
93	APURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
94	APURDT	User Reserved Date	Date	Generic Edit	6	0
95	APURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
96	APURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
97	APURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
98	APMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
99	APCO	Company	String	Generic Edit	5	0	Allow NULL?

TOP 812 | 45 | F4511W INDEXES

Number

Description

Ctid Jobs Peid Tcid Oseq (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	PEID	Process ID	Ascending
4	TCID	Transaction ID	Ascending
5	OSEQ	Sequence Number	Ascending

Customer

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	AST	Price Adjustment Name	Ascending
3	CPGP	Customer Price Group	Ascending
4	PRGR	Item Price Group	Ascending
5	SDGR	Order Detail Group	Ascending
6	LITM	2nd Item Number	Ascending
7	CRCD	Currency Code - From	Ascending
8	MNQ	Quantity - From	Ascending
9	UOM	Unit of Measure as Input	Ascending

Customer Group

Element	Alias	Description	Sequence
1	CPGP	Customer Price Group	Ascending
2	AST	Price Adjustment Name	Ascending
3	AN8	Address Number	Ascending
4	PRGR	Item Price Group	Ascending
5	SDGR	Order Detail Group	Ascending
6	LITM	2nd Item Number	Ascending
7	CRCD	Currency Code - From	Ascending
8	MNQ	Quantity - From	Ascending
9	UOM	Unit of Measure as Input	Ascending

Item

Element	Alias	Description	Sequence
1	LITM	2nd Item Number	Ascending
2	AST	Price Adjustment Name	Ascending
3	PRGR	Item Price Group	Ascending
4	CPGP	Customer Price Group	Ascending
5	SDGR	Order Detail Group	Ascending
6	AN8	Address Number	Ascending
7	CRCD	Currency Code - From	Ascending
8	MNQ	Quantity - From	Ascending
9	UOM	Unit of Measure as Input	Ascending

Item Group

Element	Alias	Description	Sequence
1	PRGR	Item Price Group	Ascending
2	AST	Price Adjustment Name	Ascending
3	LITM	2nd Item Number	Ascending
4	CPGP	Customer Price Group	Ascending
5	SDGR	Order Detail Group	Ascending
6	AN8	Address Number	Ascending
7	CRCD	Currency Code - From	Ascending
8	MNQ	Quantity - From	Ascending
9	UOM	Unit of Measure as Input	Ascending

Adjustment

Element	Alias	Description	Sequence
1	AST	Price Adjustment Name	Ascending
2	AN8	Address Number	Ascending
3	LITM	2nd Item Number	Ascending
4	CPGP	Customer Price Group	Ascending
5	PRGR	Item Price Group	Ascending
6	SDGR	Order Detail Group	Ascending
7	CRCD	Currency Code - From	Ascending
8	MNQ	Quantity - From	Ascending
9	UOM	Unit of Measure as Input	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

99 COLUMNS | 6 INDEXES | 812 | 45 | F4511W TABLE

TOP 812 | 45 | F4511W COLUMNS

TOP 812 | 45 | F4511W 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

99 COLUMNS | 6 INDEXES | 812 | 45 | F4511W TABLE

TOP812 | 45 | F4511W COLUMNS

TOP812 | 45 | F4511W INDEXES

TOP 812 | 45 | F4511W COLUMNS

TOP 812 | 45 | F4511W INDEXES