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

81 COLUMNS | 16 INDEXES | Print definition?920 | 40 | F3002 TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3002IX8116Bill of Material Master FileMaster Files30: Product Data 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 IXTBM, IXKIT, IXKITL, IXKITA, IXMMCU, IXITM, IXLITM, IXAITM, IXCMCU, IXCPNT, IXSBNT, IXPRTA, IXQNTY, IXUM, IXBQTY, IXUOM, IXFVBT, IXEFFF, IXEFFT, IXFSER, IXTSER, IXITC, IXFTRC, IXOPTK, IXFORV, IXCSTM, IXCSMP, IXORDW, IXFORQ, IXCOBY, IXCOTY, IXFRMP, IXTHRP, IXFRGD, IXTHGD, IXOPSQ, IXBSEQ, IXFTRP, IXF$RP, IXRSCP, IXSCRP, IXREWP, IXASIP, IXCPYP, IXSTPP, IXLOVD, IXECO, IXECTY, IXECOD, IXDSC1, IXLNTY, IXPRIC, IXUNCS, IXPCTK, IXSHNO, IXOMCU, IXOBJ, IXSUB, IXBREV, IXCMRV, IXRVNO, IXUUPG, IXURCD, IXURDT, IXURAT, IXURRF, IXURAB, IXUSER, IXPID, IXJOBN, IXUPMJ, IXTDAY, IXAING, IXSUCO, IXSTRC, IXENDC, IXAPSC, IXCPNB, IXBSEQAN, IXBCHAR, IXBOSTR FROM F3002

TOP920 | 40 | F3002 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IXTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
2IXKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
3IXKITLKit - 2nd Item NumberStringGeneric Edit250 Allow NULL? 
4IXKITA3rd Item Number - KitStringGeneric Edit250 Allow NULL? 
5IXMMCUBranchStringGeneric Edit120 Allow NULL? 
6IXITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
7IXLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
8IXAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
9IXCMCUComponent BranchStringGeneric Edit120 Allow NULL? 
10IXCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
11IXSBNTSubstitute Item Sequence NumberNumericGeneric Edit52 Allow NULL? 
12IXPRTAPartials Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
13IXQNTYQuantity - Standard Required QuantityNumericGeneric Edit150 Allow NULL? 
14IXUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
15IXBQTYUnits - Batch QuantityNumericGeneric Edit150 Allow NULL? 
16IXUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
17IXFVBTFixed or Variable Batch SizeCharacterGeneric Edit10 Allow NULL? 
18IXEFFFEffective - From DateDateGeneric Edit60
19IXEFFTEffective - Thru DateDateGeneric Edit60
20IXFSEREffective From Serial NumberStringGeneric Edit250 Allow NULL? 
21IXTSEREffective Thru Serial NumberStringGeneric Edit250 Allow NULL? 
22IXITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
23IXFTRCRequiredCharacterGeneric Edit10 Allow NULL? 
24IXOPTKOptional Item (Kit)CharacterUDC (H40 OP)10 Allow NULL? 
25IXFORVDefault ComponentCharacterGeneric Edit10 Allow NULL? 
26IXCSTMComponent Costing MethodCharacterUDC (H40 CV)10 Allow NULL? 
27IXCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
28IXORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
29IXFORQFixed or Variable QuantityCharacterUDC (H40 FO)10 Allow NULL? 
30IXCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
31IXCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
32IXFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
33IXTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
34IXFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
35IXTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
36IXOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
37IXBSEQSequence - Bubble SequenceNumericGeneric Edit50 Allow NULL? 
38IXFTRPFeature Planned PercentNumericGeneric Edit52 Allow NULL? 
39IXF$RPFeature Cost PercentNumericGeneric Edit52 Allow NULL? 
40IXRSCPResource PercentNumericGeneric Edit52 Allow NULL? 
41IXSCRPPercent - Percent of ScrapNumericGeneric Edit52 Allow NULL? 
42IXREWPPercent - ReworkNumericGeneric Edit52 Allow NULL? 
43IXASIPPercent - As isNumericGeneric Edit52 Allow NULL? 
44IXCPYPPercent - Cumulative Planned YieldNumericGeneric Edit52 Allow NULL? 
45IXSTPPOperation Scrap PercentNumericGeneric Edit52 Allow NULL? 
46IXLOVDLeadtime Offset DaysNumericGeneric Edit60 Allow NULL? 
47IXECOECO NumberStringGeneric Edit120 Allow NULL? 
48IXECTYEngineering Change ReasonStringUDC (40 CR)20 Allow NULL? 
49IXECODDate - Engineering Change DateDateGeneric Edit60
50IXDSC1DescriptionStringGeneric Edit300 Allow NULL? 
51IXLNTYLine TypeStringGeneric Edit20 Allow NULL? 
52IXPRICUnit Price per PrimaryNumericGeneric Edit154 Allow NULL? 
53IXUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
54IXPCTKPercent Assembly Sales PriceNumericGeneric Edit73 Allow NULL? 
55IXSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
56IXOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
57IXOBJObject AccountStringGeneric Edit60 Allow NULL? 
58IXSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
59IXBREVBill Revision LevelStringGeneric Edit30 Allow NULL? 
60IXCMRVComponent Revision LevelStringGeneric Edit30 Allow NULL? 
61IXRVNOLast Revision No.StringGeneric Edit20 Allow NULL? 
62IXUUPGItem Number - Use Up/Go ToNumericGeneric Edit80 Allow NULL? 
63IXURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
64IXURDTUser Reserved DateDateGeneric Edit60
65IXURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
66IXURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
67IXURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
68IXUSERUser IDStringGeneric Edit100 Allow NULL? 
69IXPIDProgram IDStringGeneric Edit100 Allow NULL? 
70IXJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
71IXUPMJDate - UpdatedDateGeneric Edit60
72IXTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
73IXAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
74IXSUCOSubstitute CounterIntegerGeneric Edit110 Allow NULL? 
75IXSTRCConsumption StartNumericGeneric Edit154 Allow NULL? 
76IXENDCConsumption EndNumericGeneric Edit154 Allow NULL? 
77IXAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
78IXCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
79IXBSEQANBubble Sequence Alpha NumericStringGeneric Edit50 Allow NULL? 
80IXBCHARLean Superflush FlagCharacterGeneric Edit10 Allow NULL? 
81IXBOSTRPrep CodeStringUDC (F30L PC)40 Allow NULL? 

TOP920 | 40 | F3002 INDEXES

NumberDescription
1Parent Item Branch Type + (Primary/Unique)
ElementAliasDescriptionSequence
1KITParent (short) Item NumberAscending
2MMCUBranchAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5CPNBComponent Line Number BOMAscending
6SBNTSubstitute Item Sequence NumberAscending
7COBYCo-Products/By-Products/IntermediateAscending
2Component Branch Item +A
ElementAliasDescriptionSequence
1CMCUComponent BranchAscending
2ITMItem Number - ShortAscending
3KITParent (short) Item NumberAscending
4MMCUBranchAscending
5TBMType Bill of MaterialAscending
6BQTYUnits - Batch QuantityAscending
3PBranch PItem +A
ElementAliasDescriptionSequence
1MMCUBranchAscending
2KITParent (short) Item NumberAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5ITMItem Number - ShortAscending
6CMCUComponent BranchAscending
7OPSQSequence Number - OperationsAscending
8EFFTEffective - Thru DateAscending
4Bill Type Parent Item +A
ElementAliasDescriptionSequence
1TBMType Bill of MaterialAscending
2KITParent (short) Item NumberAscending
3MMCUBranchAscending
4BQTYUnits - Batch QuantityAscending
5ITMItem Number - ShortAscending
6CMCUComponent BranchAscending
7CPNBComponent Line Number BOMAscending
8EFFTEffective - Thru DateAscending
5PItem PBranch +B
ElementAliasDescriptionSequence
1KITParent (short) Item NumberAscending
2MMCUBranchAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5OPSQSequence Number - OperationsAscending
6CPNBComponent Line Number BOMAscending
6Bill Type PBranch +A
ElementAliasDescriptionSequence
1TBMType Bill of MaterialAscending
2MMCUBranchAscending
3KITParent (short) Item NumberAscending
4COBYCo-Products/By-Products/IntermediateAscending
7Item CBranch +A
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2CMCUComponent BranchAscending
3TBMType Bill of MaterialAscending
4QNTYQuantity - Standard Required QuantityAscending
5UMUnit of MeasureAscending
6OPSQSequence Number - OperationsAscending
7CPNBComponent Line Number BOMAscending
8CoByProduct PItem +A
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2KITParent (short) Item NumberAscending
3MMCUBranchAscending
4TBMType Bill of MaterialAscending
5BQTYUnits - Batch QuantityAscending
6OPSQSequence Number - OperationsAscending
7CPNBComponent Line Number BOMAscending
9CoByProduct Item +A
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2ITMItem Number - ShortAscending
3CMCUComponent BranchAscending
4TBMType Bill of MaterialAscending
5QNTYQuantity - Standard Required QuantityAscending
6UMUnit of MeasureAscending
7OPSQSequence Number - OperationsAscending
10CoByProduct PBranch +A
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2MMCUBranchAscending
3KITParent (short) Item NumberAscending
4TBMType Bill of MaterialAscending
5BQTYUnits - Batch QuantityAscending
6OPSQSequence Number - OperationsAscending
7CPNBComponent Line Number BOMAscending
8SBNTSubstitute Item Sequence NumberAscending
11PBranch PItem + B
ElementAliasDescriptionSequence
1MMCUBranchAscending
2KITParent (short) Item NumberAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5CPNBComponent Line Number BOMAscending
12PBranch PItem +C
ElementAliasDescriptionSequence
1MMCUBranchAscending
2KITParent (short) Item NumberAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5CPNBComponent Line Number BOMDescending
6LNTYLine TypeAscending
13PItem PBranch +C
ElementAliasDescriptionSequence
1KITParent (short) Item NumberAscending
2MMCUBranchAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5COBYCo-Products/By-Products/IntermediateAscending
6CPNBComponent Line Number BOMAscending
7SBNTSubstitute Item Sequence NumberAscending
14CoByProduct PBranch +B
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2MMCUBranchAscending
3KITParent (short) Item NumberAscending
4TBMType Bill of MaterialAscending
5BQTYUnits - Batch QuantityAscending
6CPNBComponent Line Number BOMDescending
7SBNTSubstitute Item Sequence NumberDescending
16PBranch PItem +D
ElementAliasDescriptionSequence
1MMCUBranchAscending
2KITParent (short) Item NumberAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending
5COBYCo-Products/By-Products/IntermediateAscending
17PBranch PItem +E
ElementAliasDescriptionSequence
1MMCUBranchAscending
2KITParent (short) Item NumberAscending
3TBMType Bill of MaterialAscending
4BQTYUnits - Batch QuantityAscending