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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

125 COLUMNS | 1 INDEXES | Print definition?812 | 42 | F42800G1 TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F42800G1DG1251Sales Update G Batch Detail WorkfileFiles42: Sales 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 DGBDID, DGGBJN, DGJELN, DGLACTN, DGPMODE, DGGBEF, DGUKERRO, DGRWFL, DGTYDC, DGAA, DGANI, DGAID, DGMCU, DGOBJ, DGSUB, DGAM, DGFY, DGPN, DGCTRY, DGSBL, DGSBLT, DGU, DGUM, DGDSVJ, DGEXTL, DGASID, DGPOST, DGEXR, DGR2, DGSFX, DGBC, DGDOI, DGWR01, DGALID, DGDCTO, DGLNID, DGPDCT, DGPKCO, DGPO, DGPSFX, DGTNN, DGACR, DGCTAM, DGCTXA, DGSTAM, DGATXA, DGEXR1, DGTXA1, DGCRYR, DGCO, DGDKJ, DGKCO, DGCRDC, DGCRCD, DGCRR, DGCRRM, DGLLNM, DGANOG, DGFAA, DGALT1, DGALT2, DGALT3, DGALT4, DGALT5, DGALT6, DGALT7, DGALT8, DGALT9, DGALT0, DGALTX, DGCN, DGDKC, DGSUMM, DGPRGE, DGBRE, DGJBCD, DGJBST, DGWY, DGWN, DGFNLP, DGASM, DGOPSQ, DGODOC, DGOKCO, DGCFF1, DGCFF2, DGGLC, DGDLNA, DGALTY, DGSBDS, DGACTDS, DGBEFL, DGRCND, DGTXAG, DGFTAG, DGPM01, DGPM02, DGPM03, DGPM04, DGPM05, DGPM06, DGPM07, DGPM08, DGPM09, DGPM10, DGABT1, DGABR1, DGABT2, DGABR2, DGABT3, DGABR3, DGABT4, DGABR4, DGITM, DGAN8, DGEXA, DGTXITM, DGTKTX, DGUSER, DGPID, DGUPMJ, DGTDAY, DGJOBN, DGDLNID, DGALTW FROM F42800G1

TOP812 | 42 | F42800G1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DGBDIDBegin Doc Unique IDNumericGeneric Edit150 Allow NULL? 
2DGGBJNG Batch Job NumberNumericGeneric Edit150 Allow NULL? 
3DGJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
4DGLACTNLine Action CodeCharacterGeneric Edit10 Allow NULL? 
5DGPMODEProcessing ModeCharacterGeneric Edit10 Allow NULL? 
6DGGBEFEdit FlagCharacterGeneric Edit10 Allow NULL? 
7DGUKERROError FlagCharacterGeneric Edit10 Allow NULL? 
8DGRWFLRecord Written FlagCharacterGeneric Edit10 Allow NULL? 
9DGTYDCType DocCharacterGeneric Edit10 Allow NULL? 
10DGAAAmountNumericGeneric Edit152 Allow NULL? 
11DGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
12DGAIDAccount IDStringGeneric Edit80 Allow NULL? 
13DGMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
14DGOBJObject AccountStringGeneric Edit60 Allow NULL? 
15DGSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
16DGAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
17DGFYFiscal YearNumericGeneric Edit20 Allow NULL? 
18DGPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
19DGCTRYCenturyNumericGeneric Edit20 Allow NULL? 
20DGSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
21DGSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
22DGUUnitsNumericGeneric Edit152 Allow NULL? 
23DGUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
24DGDSVJDate - Service/TaxDateGeneric Edit60
25DGEXTLLine Extension CodeStringGeneric Edit20 Allow NULL? 
26DGASIDSerial NumberStringGeneric Edit250 Allow NULL? 
27DGPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
28DGEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
29DGR2Reference 2StringGeneric Edit80 Allow NULL? 
30DGSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
31DGBCBill CodeCharacterUDC (98 BC)10 Allow NULL? 
32DGDOIDOI SubNumericGeneric Edit20 Allow NULL? 
33DGWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
34DGALIDOutsider Lease or Well IDStringGeneric Edit250 Allow NULL? 
35DGDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
36DGLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
37DGPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
38DGPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
39DGPOPurchase OrderStringGeneric Edit80 Allow NULL? 
40DGPSFXPurchase Order SuffixStringGeneric Edit30 Allow NULL? 
41DGTNNFlag for 1099CharacterGeneric Edit10 Allow NULL? 
42DGACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
43DGCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
44DGCTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
45DGSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
46DGATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
47DGEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
48DGTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
49DGCRYRCurrency Conversion Y/N/ZCharacterUDC (H00 CR)10 Allow NULL? 
50DGCOCompanyStringGeneric Edit50 Allow NULL? 
51DGDKJDate - Check - JulianDateGeneric Edit60
52DGKCODocument CompanyStringGeneric Edit50 Allow NULL? 
53DGCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
54DGCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
55DGCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
56DGCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
57DGLLNMLast Line NumberNumericGeneric Edit70 Allow NULL? 
58DGANOGAmount - OriginalNumericGeneric Edit152 Allow NULL? 
59DGFAAForeign AmountNumericGeneric Edit152 Allow NULL? 
60DGALT1G/L Posting Code - Alternate 1CharacterGeneric Edit10 Allow NULL? 
61DGALT2G/L Posting Code - Alternate 2CharacterGeneric Edit10 Allow NULL? 
62DGALT3G/L Posting Code - Alternate 3CharacterGeneric Edit10 Allow NULL? 
63DGALT4G/L Posting Code - Alternate 4CharacterGeneric Edit10 Allow NULL? 
64DGALT5G/L Posting Code - Alternate 5CharacterGeneric Edit10 Allow NULL? 
65DGALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
66DGALT7Commitment Relief FlagCharacterGeneric Edit10 Allow NULL? 
67DGALT8Billing ControlCharacterGeneric Edit10 Allow NULL? 
68DGALT9Currency UpdateCharacterGeneric Edit10 Allow NULL? 
69DGALT0G/L Posting Code - Alternate 0CharacterGeneric Edit10 Allow NULL? 
70DGALTXConsumption Tax Cross ReferenceCharacterGeneric Edit10 Allow NULL? 
71DGCNPayment NumberStringGeneric Edit80 Allow NULL? 
72DGDKCDate - Check ClearedDateGeneric Edit60
73DGSUMMSummarized CodeCharacterGeneric Edit10 Allow NULL? 
74DGPRGEPurge CodeCharacterGeneric Edit10 Allow NULL? 
75DGBREBatch Rear End Posted CodeCharacterUDC (09 BR)10 Allow NULL? 
76DGJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
77DGJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
78DGWYFiscal Year - WeeklyNumericGeneric Edit20 Allow NULL? 
79DGWNFiscal Period - WeeklyNumericGeneric Edit20 Allow NULL? 
80DGFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
81DGASMLease Cost Ledger Posted CodeCharacterGeneric Edit10 Allow NULL? 
82DGOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
83DGODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
84DGOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
85DGCFF1Client Free Form - Alternate 1CharacterGeneric Edit10 Allow NULL? 
86DGCFF2Client Free Form - Alternate 2CharacterGeneric Edit10 Allow NULL? 
87DGGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
88DGDLNADelete Not AllowedCharacterGeneric Edit10 Allow NULL? 
89DGALTYID TypeStringUDC (00 AL)20 Allow NULL? 
90DGSBDSSubledger DescriptionStringGeneric Edit300 Allow NULL? 
91DGACTDSAccount DescriptionStringGeneric Edit300 Allow NULL? 
92DGBEFLBypass MEdit FlagCharacterGeneric Edit10 Allow NULL? 
93DGRCNDReconciled CodeCharacterUDC (09 RC)10 Allow NULL? 
94DGTXAGTax Amount GrossNumericGeneric Edit152 Allow NULL? 
95DGFTAGForeign Tax Amount GrossNumericGeneric Edit152 Allow NULL? 
96DGPM01Posting Code 1 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
97DGPM02Posting Code 2 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
98DGPM03Posting Code 3 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
99DGPM04Posting Code 4 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
100DGPM05Posting Code 5 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
101DGPM06Posting Code 6 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
102DGPM07Posting Code 7 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
103DGPM08Posting Code 8 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
104DGPM09Posting Code 9 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
105DGPM10Posting Code 10- Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
106DGABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
107DGABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
108DGABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
109DGABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
110DGABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
111DGABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
112DGABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
113DGABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
114DGITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
115DGAN8Address NumberNumericUDC80 Allow NULL? 
116DGEXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
117DGTXITMTax - Short Item NumberNumericGeneric Edit80 Allow NULL? 
118DGTKTXTrack Taxes FlagCharacterGeneric Edit10 Allow NULL? 
119DGUSERUser IDStringGeneric Edit100 Allow NULL? 
120DGPIDProgram IDStringGeneric Edit100 Allow NULL? 
121DGUPMJDate - UpdatedDateGeneric Edit60
122DGTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
123DGJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
124DGDLNIDDistributionLine NumberNumericGeneric Edit63 Allow NULL? 
125DGALTWG/L Posting Code - Alternate WCharacterGeneric Edit10 Allow NULL? 

TOP812 | 42 | F42800G1 INDEXES

NumberDescription
1BDID GBJN JELN (Primary/Unique)
ElementAliasDescriptionSequence
1BDIDBegin Doc Unique IDAscending
2GBJNG Batch Job NumberAscending
3JELNJournal Entry Line NumberAscending