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

87 COLUMNS | 3 INDEXES | Print definition?910 | 76B | F7601B TABLE

76B: Brazil - Reporting System Only
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F7601BFH873Nota Fiscal Header - BRA - 42Master Files76: Latin American LocalizationBusiness 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 FHBNNF, FHBSER, FHN001, FHDCT, FHBNF0, FHBSR0, FHN002, FHBNFS, FHOCTO, FHMCU, FHCO, FHFCO, FHSHAN, FHAN8, FHBCGT, FHBCPT, FHSHST, FHSHZP, FHVR01, FHBSFH, FHAN8V, FHBCGF, FHBCPF, FHADDS, FHBFRT, FHBSEG, FHBDFN, FHBDES, FHBVTM, FHGDVL, FHBVTN, FHBICM, FHBBCL, FHBVIS, FHBBIS, FHBREP, FHBDIZ, FHBVII, FHBVOI, FHBIPI, FHBBTP, FHBVOP, FHBVIP, FHBISS, FHBBCS, FHBIRT, FHBBCR, FHBIIT, FHBBCI, FHIRRI, FHISSU, FHSHPJ, FHADDJ, FHCNDJ, FHDETM, FHBINM, FHLNID, FHANCR, FHBCGC, FHCRTY, FHFRTH, FHLICP, FHSTCD, FHTOQN, FHEQUP, FHR2, FHREF, FHITWT, FHTOWT, FHBD01, FHAA1, FHBD02, FHAA2, FHBD03, FHBD04, FHBVLF, FHUSER, FHPID, FHJOBN, FHUPMJ, FHTDAY, FHBBIR, FHBIPR, FHCRCD, FHFTR, FHF1T, FHUSB1 FROM F7601B

TOP910 | 76B | F7601B COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1FHBNNFNota Fiscal NumberNumericGeneric Edit60 Allow NULL? 
2FHBSERNota Fiscal SeriesStringGeneric Edit20 Allow NULL? 
3FHN001Next Number Range 1NumericGeneric Edit80 Allow NULL? 
4FHDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
5FHBNF0Nota Fiscal Number - OriginalNumericGeneric Edit60 Allow NULL? 
6FHBSR0Nota Fiscal Series - OriginalStringGeneric Edit20 Allow NULL? 
7FHN002Next Number Range 2NumericGeneric Edit80 Allow NULL? 
8FHBNFSNota Fiscal SourceCharacterUDC (76 NF)10 Allow NULL? 
9FHOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
10FHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
11FHCOCompanyStringGeneric Edit50 Allow NULL? 
12FHFCOCompany FromStringGeneric Edit50 Allow NULL? 
13FHSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
14FHAN8Address NumberNumericUDC80 Allow NULL? 
15FHBCGTCGC Tax ID - Ship ToStringGeneric Edit150 Allow NULL? 
16FHBCPTFederaL Taxpayer ID - Person- Ship ToStringGeneric Edit110 Allow NULL? 
17FHSHSTState - Ship to StateStringUDC (00 S)30 Allow NULL? 
18FHSHZPZip Code - Ship to Postal CodeStringGeneric Edit120 Allow NULL? 
19FHVR01ReferenceStringGeneric Edit250 Allow NULL? 
20FHBSFHAddress Number - Ship FromNumericGeneric Edit80 Allow NULL? 
21FHAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
22FHBCGFCGC Tax ID - Ship FromStringGeneric Edit150 Allow NULL? 
23FHBCPFFederaL Taxpayer ID - Person- Ship FromStringGeneric Edit110 Allow NULL? 
24FHADDSStateStringUDC (00 S)30 Allow NULL? 
25FHBFRTAmount - Nota Fiscal FreightNumericGeneric Edit152 Allow NULL? 
26FHBSEGAmount - Nota Fiscal InsuranceNumericGeneric Edit152 Allow NULL? 
27FHBDFNAmount - Nota Fiscal Financial ExpensesNumericGeneric Edit152 Allow NULL? 
28FHBDESAmount - Nota Fiscal DiscountNumericGeneric Edit152 Allow NULL? 
29FHBVTMAmount - Price NetNumericGeneric Edit152 Allow NULL? 
30FHGDVLAmount - Goods ValueNumericGeneric Edit152 Allow NULL? 
31FHBVTNAmount - Nota Fiscal TotalNumericGeneric Edit152 Allow NULL? 
32FHBICMAmount - ICMS TaxNumericGeneric Edit152 Allow NULL? 
33FHBBCLAmount - ICMS TaxableNumericGeneric Edit152 Allow NULL? 
34FHBVISAmount - ICMS SubstituteNumericGeneric Edit152 Allow NULL? 
35FHBBISAmount - ICMS Substitute TaxableNumericGeneric Edit152 Allow NULL? 
36FHBREPAmount - ICMS Repass DiscountNumericGeneric Edit152 Allow NULL? 
37FHBDIZAmount - ICMS Free Port Zone DiscountNumericGeneric Edit152 Allow NULL? 
38FHBVIIAmount - ICMS ExemptNumericGeneric Edit152 Allow NULL? 
39FHBVOIAmount - ICMS OtherNumericGeneric Edit152 Allow NULL? 
40FHBIPIAmount - IPI TaxNumericGeneric Edit152 Allow NULL? 
41FHBBTPAmount - IPI TaxableNumericGeneric Edit152 Allow NULL? 
42FHBVOPAmount - IPI OtherNumericGeneric Edit152 Allow NULL? 
43FHBVIPAmount - IPI ExemptNumericGeneric Edit152 Allow NULL? 
44FHBISSAmount - ISS TaxNumericGeneric Edit152 Allow NULL? 
45FHBBCSAmount - ISS TaxableNumericGeneric Edit152 Allow NULL? 
46FHBIRTAmount - IR TaxNumericGeneric Edit152 Allow NULL? 
47FHBBCRAmount - IR TaxableNumericGeneric Edit152 Allow NULL? 
48FHBIITAmount - II TaxNumericGeneric Edit152 Allow NULL? 
49FHBBCIAmount - II TaxableNumericGeneric Edit152 Allow NULL? 
50FHIRRIWithholding Tax AmountNumericGeneric Edit152 Allow NULL? 
51FHISSUDate - IssueDateGeneric Edit60
52FHSHPJDate - Shipped (Julian)DateGeneric Edit60
53FHADDJDate - Actual Ship DateDateGeneric Edit60
54FHCNDJDate - CancelDateGeneric Edit60
55FHDETMTime - DepartureNumericGeneric Edit60 Allow NULL? 
56FHBINMPrint Message - Fiscal PurposeStringUDC (40 PM)100 Allow NULL? 
57FHLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
58FHANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
59FHBCGCCGC Tax ID - CarrierStringGeneric Edit150 Allow NULL? 
60FHCRTYCarrier TypeStringGeneric Edit30 Allow NULL? 
61FHFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
62FHLICPLicense Plate NumberStringGeneric Edit100 Allow NULL? 
63FHSTCDState CodeStringGeneric Edit30 Allow NULL? 
64FHTOQNTotal QuantityNumericGeneric Edit152 Allow NULL? 
65FHEQUPDescription - EquipmentStringGeneric Edit150 Allow NULL? 
66FHR2Reference 2StringGeneric Edit80 Allow NULL? 
67FHREFReferenceStringGeneric Edit150 Allow NULL? 
68FHITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
69FHTOWTTotal WeightNumericGeneric Edit154 Allow NULL? 
70FHBD01Category Code - Fiscal Remarks 01StringUDC (76 MC)30 Allow NULL? 
71FHAA1AmountNumericGeneric Edit152 Allow NULL? 
72FHBD02Category Code - Fiscal Remarks 02StringUDC (76 MC)30 Allow NULL? 
73FHAA2AmountNumericGeneric Edit152 Allow NULL? 
74FHBD03Category Code - Fiscal Remarks 03StringUDC (76 FM)30 Allow NULL? 
75FHBD04Category Code - Fiscal Remarks 04StringUDC (76 FM)30 Allow NULL? 
76FHBVLFAmount - Fiscal Book ValueNumericGeneric Edit152 Allow NULL? 
77FHUSERUser IDStringGeneric Edit100 Allow NULL? 
78FHPIDProgram IDStringGeneric Edit100 Allow NULL? 
79FHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
80FHUPMJDate - UpdatedDateGeneric Edit60
81FHTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
82FHBBIRAmount - ICMS Reduced TaxableNumericGeneric Edit152 Allow NULL? 
83FHBIPRAmount - IPI Tax RecoverableNumericGeneric Edit152 Allow NULL? 
84FHCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
85FHFTRAmount - Future Amount DueNumericGeneric Edit152 Allow NULL? 
86FHF1TFuture 1 TextStringGeneric Edit300 Allow NULL? 
87FHUSB1Future 1 (Julian)DateGeneric Edit60

TOP910 | 76B | F7601B INDEXES

NumberDescription
1NotaFiscal (Primary/Unique)
ElementAliasDescriptionSequence
1BNNFNota Fiscal NumberAscending
2BSERNota Fiscal SeriesAscending
3N001Next Number Range 1Ascending
4DCTDocument TypeAscending
3NFNumber NFSeries DocumentType
ElementAliasDescriptionSequence
1BNNFNota Fiscal NumberAscending
2BSERNota Fiscal SeriesAscending
3DCTDocument TypeAscending
4ShipFrom NF Number +
ElementAliasDescriptionSequence
1BSFHAddress Number - Ship FromAscending
2BNNFNota Fiscal NumberAscending
3BSERNota Fiscal SeriesAscending
4DCTDocument TypeAscending