JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

89 COLUMNS | 7 INDEXES | Print definition?920 | 44H | F44H611 TABLE

44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F44H611BD897Bid DetailsFiles44H: Homebuilder 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 BDKCOO, BDDOCO, BDDCTO, BDSFXO, BDLNID, BDHBAREA, BDMCU, BDANI, BDAID, BDCPHASE, BDOBJ, BDSUB, BDOPTION, BDHBPLAN, BDHBELEV, BDR001, BDBIDTYPE, BDVNDAOVR, BDUNIDOC, BDBUDONLY, BDVNDTBD, BDAVEL, BDAN8, BDSHAN, BDDGL, BDBDEFDT, BDBDCLDT, BDPDDJ, BDOPDJ, BDTRDJ, BDPN, BDVR01, BDVR02, BDITM, BDLITM, BDDSC1, BDDSC2, BDLNTY, BDNXTR, BDLTTR, BDPDP1, BDPDP2, BDPDP3, BDPDP4, BDPDP5, BDUOM, BDPRRC, BDUORG, BDAEXP, BDPERFCTR, BDFTN1, BDPTC, BDTX, BDEXR1, BDTXA1, BDANBY, BDGLC, BDCTRY, BDFY, BDRCD, BDFUF1, BDFUF2, BDLT, BDPCRT, BDRTNR, BDPURG, BDCRRM, BDCRCD, BDCRR, BDFRRC, BDFEA, BDFUC, BDFEC, BDHBST1, BDHBST2, BDHBST3, BDHBST4, BDHBST5, BDURRF, BDCRTU, BDCRTJ, BDCRTT, BDWRKSTNID, BDHBOPID, BDUPMB, BDUPMJ, BDUPMT, BDJOBN, BDPID FROM F44H611

TOP920 | 44H | F44H611 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1BDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2BDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3BDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4BDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
5BDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
6BDHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
7BDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
8BDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
9BDAIDAccount IDStringGeneric Edit80 Allow NULL? 
10BDCPHASEPhaseStringGeneric Edit30 Allow NULL? 
11BDOBJObject AccountStringGeneric Edit60 Allow NULL? 
12BDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
13BDOPTIONOption NumberStringGeneric Edit80 Allow NULL? 
14BDHBPLANPlan NumberStringGeneric Edit40 Allow NULL? 
15BDHBELEVElevationStringGeneric Edit30 Allow NULL? 
16BDR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
17BDBIDTYPEBid TypeStringUDC (44H6 BT)20 Allow NULL? 
18BDVNDAOVRVendor Assignment OverrideCharacterGeneric Edit10 Allow NULL? 
19BDUNIDOCUnique DocumentCharacterGeneric Edit10 Allow NULL? 
20BDBUDONLYBudget OnlyCharacterGeneric Edit10 Allow NULL? 
21BDVNDTBDSupplier TBDCharacterGeneric Edit10 Allow NULL? 
22BDAVELAutovoucher Eligible FlagCharacterGeneric Edit10 Allow NULL? 
23BDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
24BDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
25BDDGLDate - For G/L (and Voucher)DateGeneric Edit60
26BDBDEFDTBid Effective DateDateGeneric Edit60
27BDBDCLDTBid Cancel DateDateGeneric Edit60
28BDPDDJDate - Scheduled PickDateGeneric Edit60
29BDOPDJDate - Original Promised DeliveryDateGeneric Edit60
30BDTRDJDate - Order/TransactionDateGeneric Edit60
31BDPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
32BDVR01ReferenceStringGeneric Edit250 Allow NULL? 
33BDVR02Reference 2StringGeneric Edit250 Allow NULL? 
34BDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
35BDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
36BDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
37BDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
38BDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
39BDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
40BDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
41BDPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
42BDPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
43BDPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
44BDPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
45BDPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
46BDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
47BDPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
48BDUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
49BDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
50BDPERFCTRFactor PercentageNumericGeneric Edit156 Allow NULL? 
51BDFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
52BDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
53BDTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
54BDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
55BDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
56BDANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
57BDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
58BDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
59BDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
60BDRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
61BDFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
62BDFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
63BDLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
64BDPCRTPercent - RetainageNumericGeneric Edit73 Allow NULL? 
65BDRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
66BDPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
67BDCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
68BDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
69BDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
70BDFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
71BDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
72BDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
73BDFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
74BDHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
75BDHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
76BDHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
77BDHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
78BDHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 
79BDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
80BDCRTUCreated by userStringGeneric Edit100 Allow NULL? 
81BDCRTJDate - CreatedDateGeneric Edit60
82BDCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
83BDWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
84BDHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
85BDUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
86BDUPMJDate - UpdatedDateGeneric Edit60
87BDUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
88BDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
89BDPIDProgram IDStringGeneric Edit100 Allow NULL? 

TOP920 | 44H | F44H611 INDEXES

NumberDescription
1DOCO DCTO KCOO SFXO LNID (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
2DOCO DCTO KCOO SFXO(d) LNID(d)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixDescending
5LNIDLine NumberDescending
3HBAREA VNDAOVR OPTION SUB OBJ+
ElementAliasDescriptionSequence
1HBAREAHomeBuilder Area IDAscending
2VNDAOVRVendor Assignment OverrideAscending
3OPTIONOption NumberAscending
4SUBSubsidiaryAscending
5OBJObject AccountAscending
6MCUBusiness UnitDescending
7CPHASEPhaseDescending
8HBPLANPlan NumberDescending
9HBELEVElevationDescending
5SUB OBJ OPTION CPHASE HBPLAN+
ElementAliasDescriptionSequence
1SUBSubsidiaryAscending
2OBJObject AccountAscending
3OPTIONOption NumberAscending
4CPHASEPhaseAscending
5HBPLANPlan NumberAscending
6HBELEVElevationAscending
7AN8Address NumberAscending
8MCUBusiness UnitAscending
9BDEFDTBid Effective DateAscending
10BDCLDTBid Cancel DateAscending
6HBAREA SUB OBJ OPTION
ElementAliasDescriptionSequence
1HBAREAHomeBuilder Area IDAscending
2SUBSubsidiaryAscending
3OBJObject AccountAscending
4OPTIONOption NumberAscending
7DOCO DCTO KCOO LNID(d)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberDescending
8HBAREA MCU CPHASE OBJ SUB OPT+
ElementAliasDescriptionSequence
1HBAREAHomeBuilder Area IDAscending
2MCUBusiness UnitAscending
3CPHASEPhaseAscending
4OBJObject AccountAscending
5SUBSubsidiaryAscending
6OPTIONOption NumberAscending
7HBPLANPlan NumberAscending
8HBELEVElevationAscending
9VNDAOVRVendor Assignment OverrideAscending
10BUDONLYBudget OnlyAscending
11AN8Address NumberAscending
12BDEFDTBid Effective DateAscending
13BDCLDTBid Cancel DateAscending