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

84 COLUMNS | 1 INDEXES | Print definition?812 | 15 | F1502WB TABLE

15: Property Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F1502WBN4841Estimated EP Recurring Billing Work File (OneWorld)Regular Work Files15: Property ManagementNo
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 N4ICU, N4DOCO, N4LSVR, N4LSET, N4LNID, N4BLGR, N4TRAN, N4GLC, N4RMK, N4AG, N4EFTB, N4EFTE, N4BLFC, N4BF01, N4BF02, N4BF03, N4BF04, N4BF05, N4BF06, N4BF07, N4BF08, N4BF09, N4BF10, N4BF11, N4BF12, N4BF13, N4MCU, N4SBL, N4AN8J, N4UNIT, N4SMCU, N4TRAR, N4SEPI, N4ITMG, N4SUSP, N4DEAL, N4RN01, N4RN02, N4RN03, N4RN04, N4RN05, N4AGSN, N4GENT, N4BCI, N4CRCD, N4CRR, N4ACR, N4TXA1, N4EXR1, N4STAM, N4ATXN, N4ATXA, N4SBLT, N4CRRM, N4FAP, N4CDS, N4CDSA, N4CTAM, N4CTXA, N4CTXN, N4BCI2, N4BPN, N4YR, N4BPN#, N4TRBM, N4TRBY, N4TRB#, N4TREM, N4TREY, N4TRE#, N4RNTA, N4BCI3, N4SUDT, N4UNGR, N4URCD, N4URDT, N4URAT, N4URAB, N4URRF, N4USER, N4PID, N4UPMJ, N4UPMT, N4JOBN FROM F1502WB

TOP812 | 15 | F1502WB COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1N4ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
2N4DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3N4LSVRLease VersionNumericGeneric Edit60 Allow NULL? 
4N4LSETLease TypeStringUDC (15 LT)20 Allow NULL? 
5N4LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
6N4BLGRBilling GroupStringGeneric Edit120 Allow NULL? 
7N4TRANTransaction TypeCharacterUDC (15 TR)10 Allow NULL? 
8N4GLCG/L OffsetStringGeneric Edit40 Allow NULL? 
9N4RMKName - RemarkStringGeneric Edit300 Allow NULL? 
10N4AGAmount - GrossNumericGeneric Edit152 Allow NULL? 
11N4EFTBDate - Beginning EffectiveDateGeneric Edit60
12N4EFTEDate - Ending EffectiveDateGeneric Edit60
13N4BLFCBilling Frequency CodeCharacterUDC10 Allow NULL? 
14N4BF01Billing Period 01CharacterGeneric Edit10 Allow NULL? 
15N4BF02Billing Period 02CharacterGeneric Edit10 Allow NULL? 
16N4BF03Billing Period 03CharacterGeneric Edit10 Allow NULL? 
17N4BF04Billing Period 04CharacterGeneric Edit10 Allow NULL? 
18N4BF05Billing Period 05CharacterGeneric Edit10 Allow NULL? 
19N4BF06Billing Period 06CharacterGeneric Edit10 Allow NULL? 
20N4BF07Billing Period 07CharacterGeneric Edit10 Allow NULL? 
21N4BF08Billing Period 08CharacterGeneric Edit10 Allow NULL? 
22N4BF09Billing Period 09CharacterGeneric Edit10 Allow NULL? 
23N4BF10Billing Period 10CharacterGeneric Edit10 Allow NULL? 
24N4BF11Billing Period 11CharacterGeneric Edit10 Allow NULL? 
25N4BF12Billing Period 12CharacterGeneric Edit10 Allow NULL? 
26N4BF13Billing Period 13CharacterGeneric Edit10 Allow NULL? 
27N4MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
28N4SBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
29N4AN8JAddress Number - Alternate PayeeNumericGeneric Edit80 Allow NULL? 
30N4UNITUnitStringGeneric Edit80 Allow NULL? 
31N4SMCUBusiness Unit - SecurityStringGeneric Edit120 Allow NULL? 
32N4TRARPayment Terms - A/RStringGeneric Edit30 Allow NULL? 
33N4SEPISeparate Invoice CodeCharacterGeneric Edit10 Allow NULL? 
34N4ITMGItem GroupingStringGeneric Edit30 Allow NULL? 
35N4SUSPSuspend CodeCharacterUDC (15 SU)10 Allow NULL? 
36N4DEALDeal NumberStringGeneric Edit80 Allow NULL? 
37N4RN01Reporting Codes - Recurring Billings 01StringUDC (15 R1)30 Allow NULL? 
38N4RN02Reporting Codes - Recurring Billings 02StringUDC (15 R2)30 Allow NULL? 
39N4RN03Reporting Codes - Recurring Billings 03StringUDC (15 R3)30 Allow NULL? 
40N4RN04Reporting Codes - Recurring Billings 04StringUDC (15 R4)30 Allow NULL? 
41N4RN05Reporting Codes - Recurring Billings 05StringUDC (15 R5)30 Allow NULL? 
42N4AGSNAuto Generation Sequence NumberNumericGeneric Edit30 Allow NULL? 
43N4GENTGeneration TypeCharacterUDC (15 GE)10 Allow NULL? 
44N4BCIBilling Control IDNumericGeneric Edit80 Allow NULL? 
45N4CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
46N4CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
47N4ACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
48N4TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
49N4EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
50N4STAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
51N4ATXNAmount - Non-TaxableNumericGeneric Edit152 Allow NULL? 
52N4ATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
53N4SBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
54N4CRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
55N4FAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
56N4CDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
57N4CDSAAmount - Foreign Discount TakenNumericGeneric Edit152 Allow NULL? 
58N4CTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
59N4CTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
60N4CTXNAmount - Foreign Non-TaxableNumericGeneric Edit152 Allow NULL? 
61N4BCI2Billing Control ID - SecondNumericGeneric Edit80 Allow NULL? 
62N4BPNPeriod Number - BillingNumericGeneric Edit20 Allow NULL? 
63N4YRYear - Calendar YearNumericGeneric Edit20 Allow NULL? 
64N4BPN#Century - BillingNumericGeneric Edit20 Allow NULL? 
65N4TRBMDate - Term Beginning MonthNumericGeneric Edit20 Allow NULL? 
66N4TRBYDate - Term Beginning YearNumericGeneric Edit20 Allow NULL? 
67N4TRB#Date - Term Beginning CenturyNumericGeneric Edit20 Allow NULL? 
68N4TREMDate - Term Ending MonthNumericGeneric Edit20 Allow NULL? 
69N4TREYDate - Term Ending YearNumericGeneric Edit20 Allow NULL? 
70N4TRE#Date - Term Ending CenturyNumericGeneric Edit20 Allow NULL? 
71N4RNTAUnits - Rentable Area (Sq. Ft.)NumericGeneric Edit152 Allow NULL? 
72N4BCI3Billing Control ID - ThirdNumericGeneric Edit80 Allow NULL? 
73N4SUDTDate - SuspendedDateGeneric Edit60
74N4UNGRUnit Group CodeCharacterGeneric Edit10 Allow NULL? 
75N4URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
76N4URDTUser Reserved DateDateGeneric Edit60
77N4URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
78N4URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
79N4URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
80N4USERUser IDStringGeneric Edit100 Allow NULL? 
81N4PIDProgram IDStringGeneric Edit100 Allow NULL? 
82N4UPMJDate - UpdatedDateGeneric Edit60
83N4UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
84N4JOBNWork Station IDStringGeneric Edit100 Allow NULL? 

TOP812 | 15 | F1502WB INDEXES

NumberDescription
1Batch No. Lease Building + (Primary/Unique)
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2DOCODocument (Order No Invoice etc.)Ascending
3MCUBusiness UnitAscending
4UNITUnitAscending
5GLCG/L OffsetAscending
6UNGRUnit Group CodeAscending
7BCIBilling Control IDAscending