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

114 COLUMNS | 6 INDEXES | Print definition?920 | 76B | F7611B TABLE

76B: Brazil
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F7611BFD1146Nota Fiscal Detail - BRA - 42Master Files76B: BrazilBusiness 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 FDBNNF, FDBSER, FDN001, FDDCT, FDUKID, FDSOS1, FDBNF0, FDBSR0, FDN002, FDBNFS, FDOCTO, FDMATC, FDDOCO, FDPDCT, FDKCOO, FDSFXO, FDLNID, FDNLIN, FDDOC, FDDCTO, FDCO, FDFCO, FDITM, FDLITM, FDAITM, FDCITM, FDMCU, FDLOCN, FDLOTN, FDDSC1, FDDSC2, FDLNTY, FDUOM, FDUORG, FDUOM3, FDUOM4, FDUPRC, FDAEXP, FDBDES, FDGLC, FDSHAN, FDAN8, FDBCGT, FDBCPT, FDSHST, FDSHZP, FDBSFH, FDAN8V, FDBCGF, FDBCPF, FDADDS, FDBNOP, FDBSOP, FDBDIP, FDBCLF, FDBCTF, FDBIST, FDBORI, FDBCFC, FDBSTT, FDBST1, FDBFRT, FDBSEG, FDBDFN, FDBICM, FDTXR1, FDBBCL, FDBBIR, FDBVIS, FDBBIS, FDBREP, FDBDIZ, FDBICP, FDBFII, FDBIPR, FDBIPI, FDTXR2, FDBBTP, FDBFIP, FDBISS, FDTXR3, FDBBCS, FDBIRT, FDTXR4, FDBBCR, FDBIIT, FDTXR5, FDBBCI, FDANI, FDAID, FDOMCU, FDOBJ, FDSUB, FDSBLT, FDSBL, FDBINM, FDISSU, FDBNIV, FDPGNO, FDNXTR, FDLTTR, FDUSER, FDPID, FDJOBN, FDUPMJ, FDTDAY, FDCRCD, FDFTR, FDF1T, FDF2A, FDF2T, FDUSB1, FDFLD3, FDFLD4 FROM F7611B

TOP920 | 76B | F7611B COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1FDBNNFNota Fiscal NumberNumericGeneric Edit60 Allow NULL? 
2FDBSERNota Fiscal SeriesStringGeneric Edit20 Allow NULL? 
3FDN001Next Number Range 1NumericGeneric Edit80 Allow NULL? 
4FDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
5FDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
6FDSOS1Sequence NumberStringGeneric Edit30 Allow NULL? 
7FDBNF0Nota Fiscal Number - OriginalNumericGeneric Edit60 Allow NULL? 
8FDBSR0Nota Fiscal Series - OriginalStringGeneric Edit20 Allow NULL? 
9FDN002Next Number Range 2NumericGeneric Edit80 Allow NULL? 
10FDBNFSNota Fiscal SourceCharacterUDC (76 NF)10 Allow NULL? 
11FDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
12FDMATCType - Match Record TypeCharacterGeneric Edit10 Allow NULL? 
13FDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
14FDPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
15FDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
16FDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
17FDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
18FDNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
19FDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
20FDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
21FDCOCompanyStringGeneric Edit50 Allow NULL? 
22FDFCOCompany FromStringGeneric Edit50 Allow NULL? 
23FDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
24FDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
25FDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
26FDCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
27FDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
28FDLOCNLocationStringGeneric Edit200 Allow NULL? 
29FDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
30FDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
31FDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
32FDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
33FDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
34FDUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
35FDUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
36FDUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
37FDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
38FDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
39FDBDESAmount - Nota Fiscal DiscountNumericGeneric Edit152 Allow NULL? 
40FDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
41FDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
42FDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
43FDBCGTCGC Tax ID - Ship ToStringGeneric Edit150 Allow NULL? 
44FDBCPTFederaL Taxpayer ID - Person- Ship ToStringGeneric Edit110 Allow NULL? 
45FDSHSTState - Ship to StateStringUDC (00 S)30 Allow NULL? 
46FDSHZPZip Code - Ship to Postal CodeStringGeneric Edit120 Allow NULL? 
47FDBSFHAddress Number - Ship FromNumericGeneric Edit80 Allow NULL? 
48FDAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
49FDBCGFCGC Tax ID - Ship FromStringGeneric Edit150 Allow NULL? 
50FDBCPFFederaL Taxpayer ID - Person- Ship FromStringGeneric Edit110 Allow NULL? 
51FDADDSStateStringUDC (00 S)30 Allow NULL? 
52FDBNOPCode - Transaction NatureNumericGeneric Edit30 Allow NULL? 
53FDBSOPSuffix - Transaction NatureStringGeneric Edit20 Allow NULL? 
54FDBDIPCode - DIPI ClassificationStringGeneric Edit40 Allow NULL? 
55FDBCLFFiscal ClassificationStringGeneric Edit100 Allow NULL? 
56FDBCTFICMS/IPI Tax SummaryStringUDC (76 CT)20 Allow NULL? 
57FDBISTICMS Tax Substitution Mark-upCharacterUDC (76 SM)10 Allow NULL? 
58FDBORIItem OriginCharacterUDC (76 IO)10 Allow NULL? 
59FDBCFCPurchase UseStringUDC (76 PU)30 Allow NULL? 
60FDBSTTCode - ICMS Tax Situation (Nota Fiscal)StringGeneric Edit20 Allow NULL? 
61FDBST1Code - ICMS Tax Situation (Nota Fiscal)StringUDC (76 ST)30 Allow NULL? 
62FDBFRTAmount - Nota Fiscal FreightNumericGeneric Edit152 Allow NULL? 
63FDBSEGAmount - Nota Fiscal InsuranceNumericGeneric Edit152 Allow NULL? 
64FDBDFNAmount - Nota Fiscal Financial ExpensesNumericGeneric Edit152 Allow NULL? 
65FDBICMAmount - ICMS TaxNumericGeneric Edit152 Allow NULL? 
66FDTXR1Tax Rate 1NumericGeneric Edit73 Allow NULL? 
67FDBBCLAmount - ICMS TaxableNumericGeneric Edit152 Allow NULL? 
68FDBBIRAmount - ICMS Reduced TaxableNumericGeneric Edit152 Allow NULL? 
69FDBVISAmount - ICMS SubstituteNumericGeneric Edit152 Allow NULL? 
70FDBBISAmount - ICMS Substitute TaxableNumericGeneric Edit152 Allow NULL? 
71FDBREPAmount - ICMS Repass DiscountNumericGeneric Edit152 Allow NULL? 
72FDBDIZAmount - ICMS Free Port Zone DiscountNumericGeneric Edit152 Allow NULL? 
73FDBICPAmount - ICMS to be PaidNumericGeneric Edit152 Allow NULL? 
74FDBFIICode - ICMS Reporting Column (Fiscal B.)CharacterUDC (76 II)10 Allow NULL? 
75FDBIPRAmount - IPI Tax RecoverableNumericGeneric Edit152 Allow NULL? 
76FDBIPIAmount - IPI TaxNumericGeneric Edit152 Allow NULL? 
77FDTXR2Tax Rate 2NumericGeneric Edit73 Allow NULL? 
78FDBBTPAmount - IPI TaxableNumericGeneric Edit152 Allow NULL? 
79FDBFIPCode - IPI Reporting Column (Fiscal B.)CharacterUDC (76 IP)10 Allow NULL? 
80FDBISSAmount - ISS TaxNumericGeneric Edit152 Allow NULL? 
81FDTXR3Tax Rate 3NumericGeneric Edit73 Allow NULL? 
82FDBBCSAmount - ISS TaxableNumericGeneric Edit152 Allow NULL? 
83FDBIRTAmount - IR TaxNumericGeneric Edit152 Allow NULL? 
84FDTXR4Tax Rate 4NumericGeneric Edit73 Allow NULL? 
85FDBBCRAmount - IR TaxableNumericGeneric Edit152 Allow NULL? 
86FDBIITAmount - II TaxNumericGeneric Edit152 Allow NULL? 
87FDTXR5Tax Rate 5NumericGeneric Edit73 Allow NULL? 
88FDBBCIAmount - II TaxableNumericGeneric Edit152 Allow NULL? 
89FDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
90FDAIDAccount IDStringGeneric Edit80 Allow NULL? 
91FDOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
92FDOBJObject AccountStringGeneric Edit60 Allow NULL? 
93FDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
94FDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
95FDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
96FDBINMPrint Message - Fiscal PurposeStringUDC (40 PM)100 Allow NULL? 
97FDISSUDate - IssueDateGeneric Edit60
98FDBNIVFiscal Book NumberNumericGeneric Edit50 Allow NULL? 
99FDPGNOPage NumberNumericGeneric Edit40 Allow NULL? 
100FDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
101FDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
102FDUSERUser IDStringGeneric Edit100 Allow NULL? 
103FDPIDProgram IDStringGeneric Edit100 Allow NULL? 
104FDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
105FDUPMJDate - UpdatedDateGeneric Edit60
106FDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
107FDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
108FDFTRAmount - Future Amount DueNumericGeneric Edit152 Allow NULL? 
109FDF1TFuture 1 TextStringGeneric Edit300 Allow NULL? 
110FDF2AFuture 2 AmountNumericGeneric Edit150 Allow NULL? 
111FDF2TFuture 2 TextStringGeneric Edit300 Allow NULL? 
112FDUSB1Future 1 (Julian)DateGeneric Edit60
113FDFLD3Log Quality Management ChangesCharacterGeneric Edit10 Allow NULL? 
114FDFLD4% Bill StorageCharacterGeneric Edit10 Allow NULL? 

TOP920 | 76B | F7611B INDEXES

NumberDescription
1NotaFiscalDet (Primary/Unique)
ElementAliasDescriptionSequence
1BNNFNota Fiscal NumberAscending
2BSERNota Fiscal SeriesAscending
3N001Next Number Range 1Ascending
4DCTDocument TypeAscending
5UKIDUnique Key ID (Internal)Ascending
2Matc Doco +
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3PDCTDocument Type - Purchase OrderAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
7NLINNumber of LinesAscending
3ThreeWay
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3PDCTDocument Type - Purchase OrderAscending
4KCOOOrder Company (Order Number)Ascending
5LNIDLine NumberAscending
6NLINNumber of LinesAscending
7DOCDocument (Voucher Invoice etc.)Ascending
4KCOO BNNF BSER DOCO PDCT LNID
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2BNNFNota Fiscal NumberAscending
3BSERNota Fiscal SeriesAscending
4DOCODocument (Order No Invoice etc.)Ascending
5PDCTDocument Type - Purchase OrderAscending
6LNIDLine NumberAscending
5KCOO DOC DCTO
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCDocument (Voucher Invoice etc.)Ascending
3DCTOOrder TypeAscending
6UKIDDesc
ElementAliasDescriptionSequence
1BNNFNota Fiscal NumberAscending
2BSERNota Fiscal SeriesAscending
3N001Next Number Range 1Ascending
4DCTDocument TypeAscending
5UKIDUnique Key ID (Internal)Descending