JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

73 COLUMNS | 2 INDEXES | Print definition?910 | 41F | FCW50 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910FCW50BX732Bill of Material Association MatrixFiles41F: Apparel Management
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 BXKIT, BXMMCU, BXTBM, BXBQTY, BXITM, BXCPNT, BXSBNT, BXCOBY, BXC9LVC0, BXC9LVNO, BXC9LVCO1, BXC9LVCO2, BXC9LVCO3, BXC9LVCO4, BXC9LVCO5, BXC9LVCO6, BXC9LVCO7, BXC9LVCO8, BXC9LVCO9, BXC9LVCO10, BXC9LVCO11, BXC9LVCO12, BXC9LVCO13, BXC9LVCO14, BXC9LVCO15, BXC9LVCO16, BXC9LVCO17, BXC9LVCO18, BXC9LVCO19, BXC9LVCO20, BXC9LVCO21, BXC9LVCO22, BXC9LVCO23, BXC9LVCO24, BXC9LVCO25, BXC9LVCO26, BXC9LVCO27, BXC9LVCO28, BXC9LVCO29, BXC9LVCO30, BXC9STRC, BXC9GRCD, BXCPNB, BXCOQNTY1, BXCOQNTY2, BXCOQNTY3, BXCOQNTY4, BXCOQNTY5, BXCOQNTY6, BXCOQNTY7, BXCOQNTY8, BXCOQNTY9, BXCOQNTY10, BXCOQNTY11, BXCOQNTY12, BXCOQNTY13, BXCOQNTY14, BXCOQNTY15, BXCOQNTY16, BXCOQNTY18, BXCOQNTY17, BXCOQNTY19, BXCOQNTY20, BXCOQNTY21, BXCOQNTY22, BXCOQNTY23, BXCOQNTY24, BXCOQNTY25, BXCOQNTY26, BXCOQNTY27, BXCOQNTY28, BXCOQNTY29, BXCOQNTY30 FROM FCW50

TOP910 | 41F | FCW50 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1BXKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
2BXMMCUBranchStringGeneric Edit120 Allow NULL? 
3BXTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
4BXBQTYUnits - Batch QuantityNumericGeneric Edit152 Allow NULL? 
5BXITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
6BXCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
7BXSBNTSubstitute Item Sequence NumberNumericGeneric Edit52 Allow NULL? 
8BXCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
9BXC9LVC0Component Level 0StringGeneric Edit250 Allow NULL? 
10BXC9LVNOLevel NoNumericGeneric Edit20 Allow NULL? 
11BXC9LVCO1Level Code 1StringGeneric Edit250 Allow NULL? 
12BXC9LVCO2Level Code 2StringGeneric Edit250 Allow NULL? 
13BXC9LVCO3Level Code 3StringGeneric Edit250 Allow NULL? 
14BXC9LVCO4Level Code 4StringGeneric Edit250 Allow NULL? 
15BXC9LVCO5Level Code 5StringGeneric Edit250 Allow NULL? 
16BXC9LVCO6Level Code 6StringGeneric Edit250 Allow NULL? 
17BXC9LVCO7Level Code 7StringGeneric Edit250 Allow NULL? 
18BXC9LVCO8Level Code 8StringGeneric Edit250 Allow NULL? 
19BXC9LVCO9Level Code 9StringGeneric Edit250 Allow NULL? 
20BXC9LVCO10Level Code 10StringGeneric Edit250 Allow NULL? 
21BXC9LVCO11Level Code 11StringGeneric Edit250 Allow NULL? 
22BXC9LVCO12Level Code 12StringGeneric Edit250 Allow NULL? 
23BXC9LVCO13Level Code 13StringGeneric Edit250 Allow NULL? 
24BXC9LVCO14Level Code 14StringGeneric Edit250 Allow NULL? 
25BXC9LVCO15Level Code 15StringGeneric Edit250 Allow NULL? 
26BXC9LVCO16Level Code 16StringGeneric Edit250 Allow NULL? 
27BXC9LVCO17Level Code 17StringGeneric Edit250 Allow NULL? 
28BXC9LVCO18Level Code 18StringGeneric Edit250 Allow NULL? 
29BXC9LVCO19Level Code 19StringGeneric Edit250 Allow NULL? 
30BXC9LVCO20Level Code 20StringGeneric Edit250 Allow NULL? 
31BXC9LVCO21Level Code 21StringGeneric Edit250 Allow NULL? 
32BXC9LVCO22Level Code 22StringGeneric Edit250 Allow NULL? 
33BXC9LVCO23Level Code 23StringGeneric Edit250 Allow NULL? 
34BXC9LVCO24Level Code 24StringGeneric Edit250 Allow NULL? 
35BXC9LVCO25Level Code 25StringGeneric Edit250 Allow NULL? 
36BXC9LVCO26Level Code 26StringGeneric Edit250 Allow NULL? 
37BXC9LVCO27Level Code 27StringGeneric Edit250 Allow NULL? 
38BXC9LVCO28Level Code 28StringGeneric Edit250 Allow NULL? 
39BXC9LVCO29Level Code 29StringGeneric Edit250 Allow NULL? 
40BXC9LVCO30Level Code 30StringGeneric Edit250 Allow NULL? 
41BXC9STRCStructureStringUDC (41F IS)30 Allow NULL? 
42BXC9GRCDGrid CodeStringUDC (41F GD)30 Allow NULL? 
43BXCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
44BXCOQNTY1Quantity 1NumericGeneric Edit156 Allow NULL? 
45BXCOQNTY2Quantity 2NumericGeneric Edit156 Allow NULL? 
46BXCOQNTY3Quantity 3NumericGeneric Edit156 Allow NULL? 
47BXCOQNTY4Quantity 4NumericGeneric Edit156 Allow NULL? 
48BXCOQNTY5Quantity 5NumericGeneric Edit156 Allow NULL? 
49BXCOQNTY6Quantity 6NumericGeneric Edit156 Allow NULL? 
50BXCOQNTY7Quantity 7NumericGeneric Edit156 Allow NULL? 
51BXCOQNTY8Quantity 8NumericGeneric Edit156 Allow NULL? 
52BXCOQNTY9Quantity 9NumericGeneric Edit156 Allow NULL? 
53BXCOQNTY10Quantity 10NumericGeneric Edit156 Allow NULL? 
54BXCOQNTY11Quantity 11NumericGeneric Edit156 Allow NULL? 
55BXCOQNTY12Quantity 12NumericGeneric Edit156 Allow NULL? 
56BXCOQNTY13Quantity 13NumericGeneric Edit156 Allow NULL? 
57BXCOQNTY14Quantity 14NumericGeneric Edit156 Allow NULL? 
58BXCOQNTY15Quantity 15NumericGeneric Edit156 Allow NULL? 
59BXCOQNTY16Quantity 16NumericGeneric Edit156 Allow NULL? 
60BXCOQNTY18Quantity 18NumericGeneric Edit156 Allow NULL? 
61BXCOQNTY17Quantity 17NumericGeneric Edit156 Allow NULL? 
62BXCOQNTY19Quantity 19NumericGeneric Edit156 Allow NULL? 
63BXCOQNTY20Quantity 20NumericGeneric Edit156 Allow NULL? 
64BXCOQNTY21Quantity 21NumericGeneric Edit156 Allow NULL? 
65BXCOQNTY22Quantity 22NumericGeneric Edit156 Allow NULL? 
66BXCOQNTY23Quantity 23NumericGeneric Edit156 Allow NULL? 
67BXCOQNTY24Quantity 24NumericGeneric Edit156 Allow NULL? 
68BXCOQNTY25Quantity 25NumericGeneric Edit156 Allow NULL? 
69BXCOQNTY26Quantity 26NumericGeneric Edit156 Allow NULL? 
70BXCOQNTY27Quantity 27NumericGeneric Edit156 Allow NULL? 
71BXCOQNTY28Quantity 28NumericGeneric Edit156 Allow NULL? 
72BXCOQNTY29Quantity 29NumericGeneric Edit156 Allow NULL? 
73BXCOQNTY30Quantity 30NumericGeneric Edit156 Allow NULL? 

TOP910 | 41F | FCW50 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1KITParent (short) Item NumberAscending
2MMCUBranchAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5ITMItem Number - ShortAscending
6CPNBComponent Line Number BOMAscending
7SBNTSubstitute Item Sequence NumberAscending
8COBYCo-Products/By-Products/IntermediateAscending
9C9LVC0Component Level 0Ascending
3KIT to ITM
ElementAliasDescriptionSequence
1KITParent (short) Item NumberAscending
2MMCUBranchAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5ITMItem Number - ShortAscending