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

134 COLUMNS | 2 INDEXES | Print definition?910 | 08 | F080434B TABLE

08: Human Resources
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F080434BVE1342Veterans Employment Reporting (VETS 100A)Files08: Human Resources
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 VESVER, VEPRNM, VEVRBY, VEWSST, VETPOS, VEDOCP, VECONAME, VECOMNT1, VEOFC, VETSKD1, VESTAC, VECUCD, VENEWVAL, VECOMNT2, VENME, VEWCPL, VECTAX, VENRSD, VECMPC, VEINSTY, VEADDN, VEETAX, VEEE01, VEEE02, VEEE03, VEEE04, VEEE05, VEEE06, VEEE07, VEEE08, VEEE09, VEEE10, VEEE11, VEEE12, VEEE13, VEEE14, VEEE15, VEEE16, VEEE17, VEEE18, VEEE19, VEEE20, VEEE21, VEEE22, VEEE23, VEEE24, VEEE25, VEEE26, VEEE27, VEEE28, VEEE29, VEEE30, VEEE31, VEEE32, VEEE33, VEEE34, VEEE35, VEEE36, VEEE37, VEEE38, VEEE39, VEEE40, VEEE41, VEEE42, VEEE43, VEEE44, VEEE45, VEEE46, VEEE47, VEEE48, VEEE49, VEEE50, VEBN01, VEBN02, VEBN03, VEBN04, VEBN05, VEBN06, VEBN07, VEBN08, VEBN09, VEBN10, VEBN11, VEBN12, VEBN13, VEN001, VEN002, VEN003, VEN004, VEN005, VEN006, VEN007, VEN008, VEN009, VEN010, VEDC01, VEDC02, VEDC03, VEDC04, VEDC05, VEDC06, VEDC07, VEDC08, VEDC09, VEAN8CM01, VEAN8CM02, VEAN8CM03, VEAN8CM04, VEAN8CM05, VEAN8CM06, VEAN8CM07, VEAN8CM08, VEAN8CM09, VEAN8CM10, VEAN8CM11, VEAN8CM12, VEAN8CM13, VEAN8CM14, VEAN8CM15, VEAN8CM16, VEAN8CM17, VEAN8CM18, VEAN8CM19, VEAN8CM20, VEANSM01, VEANSM02, VEANSM03, VEANSM04, VEANSM05, VEANSM06, VEANSM07, VEANSM08, VEANSM09, VEANSM10 FROM F080434B

TOP910 | 08 | F080434B COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1VESVERSnapshot VersionStringGeneric Edit100 Allow NULL? 
2VEPRNMPreferred NameStringGeneric Edit200 Allow NULL? 
3VEVRBYVerified ByStringGeneric Edit80 Allow NULL? 
4VEWSSTWork State Supplemental Tax TypeCharacterGeneric Edit10 Allow NULL? 
5VETPOSPosition TypeStringGeneric Edit30 Allow NULL? 
6VEDOCPDocument #- PredecessorNumericGeneric Edit80 Allow NULL? 
7VECONAMECompany NameStringGeneric Edit400 Allow NULL? 
8VECOMNT1CommentStringGeneric Edit400 Allow NULL? 
9VEOFCOfficeNumberStringGeneric Edit200 Allow NULL? 
10VETSKD1Short DescriptionStringGeneric Edit200 Allow NULL? 
11VESTACState Return CodeStringGeneric Edit20 Allow NULL? 
12VECUCDCourse CodeStringUDC100 Allow NULL? 
13VENEWVALNew ValueStringGeneric Edit200 Allow NULL? 
14VECOMNT2CommentStringGeneric Edit400 Allow NULL? 
15VENMEEmployee NameStringGeneric Edit400 Allow NULL? 
16VEWCPLWorkers Comp Policy NumberStringGeneric Edit200 Allow NULL? 
17VECTAXTax Identification Number - CountyStringGeneric Edit200 Allow NULL? 
18VENRSDState Residence StatusStringUDC20 Allow NULL? 
19VECMPCCompetency CodeStringGeneric Edit100 Allow NULL? 
20VEINSTYInstitution CodeStringUDC (05 IC)100 Allow NULL? 
21VEADDNAdditional NameStringGeneric Edit200 Allow NULL? 
22VEETAXTax Identification Number -Business UnitStringGeneric Edit200 Allow NULL? 
23VEEE01Address Number - Payroll1NumericGeneric Edit80 Allow NULL? 
24VEEE02Address Number - Payroll2NumericGeneric Edit80 Allow NULL? 
25VEEE03Address Number - Payroll3NumericGeneric Edit80 Allow NULL? 
26VEEE04Address Number - Payroll4NumericGeneric Edit80 Allow NULL? 
27VEEE05Address Number - Payroll5NumericGeneric Edit80 Allow NULL? 
28VEEE06Address Number - Payroll6NumericGeneric Edit80 Allow NULL? 
29VEEE07Address Number - Payroll7NumericGeneric Edit80 Allow NULL? 
30VEEE08Address Number - Payroll8NumericGeneric Edit80 Allow NULL? 
31VEEE09Address Number - Payroll9NumericGeneric Edit80 Allow NULL? 
32VEEE10Address Number - Payroll10NumericGeneric Edit80 Allow NULL? 
33VEEE11Address Number - Payroll11NumericGeneric Edit80 Allow NULL? 
34VEEE12Address Number - Payroll12NumericGeneric Edit80 Allow NULL? 
35VEEE13Address Number - Payroll13NumericGeneric Edit80 Allow NULL? 
36VEEE14Address Number - Payroll14NumericGeneric Edit80 Allow NULL? 
37VEEE15Address Number - Payroll15NumericGeneric Edit80 Allow NULL? 
38VEEE16Address Number - Payroll16NumericGeneric Edit80 Allow NULL? 
39VEEE17Address Number - Payroll17NumericGeneric Edit80 Allow NULL? 
40VEEE18Address Number - Payroll18NumericGeneric Edit80 Allow NULL? 
41VEEE19Address Number - Payroll19NumericGeneric Edit80 Allow NULL? 
42VEEE20Address Number - Payroll20NumericGeneric Edit80 Allow NULL? 
43VEEE21Address Number - Payroll21NumericGeneric Edit80 Allow NULL? 
44VEEE22Address Number - Payroll22NumericGeneric Edit80 Allow NULL? 
45VEEE23Address Number - Payroll23NumericGeneric Edit80 Allow NULL? 
46VEEE24Address Number - Payroll24NumericGeneric Edit80 Allow NULL? 
47VEEE25Address Number - Payroll25NumericGeneric Edit80 Allow NULL? 
48VEEE26Address Number - Payroll26NumericGeneric Edit80 Allow NULL? 
49VEEE27Address Number - Payroll27NumericGeneric Edit80 Allow NULL? 
50VEEE28Address Number - Payroll28NumericGeneric Edit80 Allow NULL? 
51VEEE29Address Number - Payroll29NumericGeneric Edit80 Allow NULL? 
52VEEE30Address Number - Payroll30NumericGeneric Edit80 Allow NULL? 
53VEEE31Address Number - Payroll31NumericGeneric Edit80 Allow NULL? 
54VEEE32Address Number - Payroll32NumericGeneric Edit80 Allow NULL? 
55VEEE33Address Number - Payroll33NumericGeneric Edit80 Allow NULL? 
56VEEE34Address Number - Payroll34NumericGeneric Edit80 Allow NULL? 
57VEEE35Address Number - Payroll35NumericGeneric Edit80 Allow NULL? 
58VEEE36Address Number - Payroll36NumericGeneric Edit80 Allow NULL? 
59VEEE37Address Number - Payroll37NumericGeneric Edit80 Allow NULL? 
60VEEE38Address Number - Payroll38NumericGeneric Edit80 Allow NULL? 
61VEEE39Address Number - Payroll39NumericGeneric Edit80 Allow NULL? 
62VEEE40Address Number - Payroll40NumericGeneric Edit80 Allow NULL? 
63VEEE41Address Number - Payroll41NumericGeneric Edit80 Allow NULL? 
64VEEE42Address Number - Payroll42NumericGeneric Edit80 Allow NULL? 
65VEEE43Address Number - Payroll43NumericGeneric Edit80 Allow NULL? 
66VEEE44Address Number - Payroll44NumericGeneric Edit80 Allow NULL? 
67VEEE45Address Number - Payroll45NumericGeneric Edit80 Allow NULL? 
68VEEE46Address Number - Payroll46NumericGeneric Edit80 Allow NULL? 
69VEEE47Address Number - Payroll47NumericGeneric Edit80 Allow NULL? 
70VEEE48Address Number - Payroll48NumericGeneric Edit80 Allow NULL? 
71VEEE49Address Number - Payroll49NumericGeneric Edit80 Allow NULL? 
72VEEE50Address Number - Payroll50NumericGeneric Edit80 Allow NULL? 
73VEBN01Batch NumberNumericGeneric Edit80 Allow NULL? 
74VEBN02Batch NumberNumericGeneric Edit80 Allow NULL? 
75VEBN03Batch NumberNumericGeneric Edit80 Allow NULL? 
76VEBN04Batch NumberNumericGeneric Edit80 Allow NULL? 
77VEBN05Batch NumberNumericGeneric Edit80 Allow NULL? 
78VEBN06Batch NumberNumericGeneric Edit80 Allow NULL? 
79VEBN07Batch NumberNumericGeneric Edit80 Allow NULL? 
80VEBN08Batch NumberNumericGeneric Edit80 Allow NULL? 
81VEBN09Batch NumberNumericGeneric Edit80 Allow NULL? 
82VEBN10Batch NumberNumericGeneric Edit80 Allow NULL? 
83VEBN11Batch NumberNumericGeneric Edit80 Allow NULL? 
84VEBN12Batch NumberNumericGeneric Edit80 Allow NULL? 
85VEBN13Batch NumberNumericGeneric Edit80 Allow NULL? 
86VEN001Next Number Range 1NumericGeneric Edit80 Allow NULL? 
87VEN002Next Number Range 2NumericGeneric Edit80 Allow NULL? 
88VEN003Next Number 003NumericGeneric Edit80 Allow NULL? 
89VEN004Next Number 004NumericGeneric Edit80 Allow NULL? 
90VEN005Next Number 005NumericGeneric Edit80 Allow NULL? 
91VEN006Next Number 006NumericGeneric Edit80 Allow NULL? 
92VEN007Next Number 007NumericGeneric Edit80 Allow NULL? 
93VEN008Next Number 008NumericGeneric Edit80 Allow NULL? 
94VEN009Next Number 009NumericGeneric Edit80 Allow NULL? 
95VEN010Next Number 010NumericGeneric Edit80 Allow NULL? 
96VEDC01Order Number - Ship To Location 01NumericGeneric Edit80 Allow NULL? 
97VEDC02Order Number - Ship To Location 02NumericGeneric Edit80 Allow NULL? 
98VEDC03Order Number - Ship To Location 03NumericGeneric Edit80 Allow NULL? 
99VEDC04Order Number - Ship To Location 04NumericGeneric Edit80 Allow NULL? 
100VEDC05Order Number - Ship To Location 05NumericGeneric Edit80 Allow NULL? 
101VEDC06Order Number - Ship To Location 06NumericGeneric Edit80 Allow NULL? 
102VEDC07Order Number - Ship To Location 07NumericGeneric Edit80 Allow NULL? 
103VEDC08Order Number - Ship To Location 08NumericGeneric Edit80 Allow NULL? 
104VEDC09Order Number - Ship To Location 09NumericGeneric Edit80 Allow NULL? 
105VEAN8CM01Address Number - Community 01NumericGeneric Edit80 Allow NULL? 
106VEAN8CM02Address Number - Community 02NumericGeneric Edit80 Allow NULL? 
107VEAN8CM03Address Number - Community 03NumericGeneric Edit80 Allow NULL? 
108VEAN8CM04Address Number - Community 04NumericGeneric Edit80 Allow NULL? 
109VEAN8CM05Address Number - Community 05NumericGeneric Edit80 Allow NULL? 
110VEAN8CM06Address Number - Community 06NumericGeneric Edit80 Allow NULL? 
111VEAN8CM07Address Number - Community 07NumericGeneric Edit80 Allow NULL? 
112VEAN8CM08Address Number - Community 08NumericGeneric Edit80 Allow NULL? 
113VEAN8CM09Address Number - Community 09NumericGeneric Edit80 Allow NULL? 
114VEAN8CM10Address Number - Community 10NumericGeneric Edit80 Allow NULL? 
115VEAN8CM11Address Number - Community 11NumericGeneric Edit80 Allow NULL? 
116VEAN8CM12Address Number - Community 12NumericGeneric Edit80 Allow NULL? 
117VEAN8CM13Address Number - Community 13NumericGeneric Edit80 Allow NULL? 
118VEAN8CM14Address Number - Community 14NumericGeneric Edit80 Allow NULL? 
119VEAN8CM15Address Number - Community 15NumericGeneric Edit80 Allow NULL? 
120VEAN8CM16Address Number - Community 16NumericGeneric Edit80 Allow NULL? 
121VEAN8CM17Address Number - Community 17NumericGeneric Edit80 Allow NULL? 
122VEAN8CM18Address Number - Community 18NumericGeneric Edit80 Allow NULL? 
123VEAN8CM19Address Number - Community 19NumericGeneric Edit80 Allow NULL? 
124VEAN8CM20Address Number - Community 20NumericGeneric Edit80 Allow NULL? 
125VEANSM01Address Number - Sales Master 1NumericGeneric Edit80 Allow NULL? 
126VEANSM02Address Number - Sales Master 2NumericGeneric Edit80 Allow NULL? 
127VEANSM03Address Number - Sales Master 3NumericGeneric Edit80 Allow NULL? 
128VEANSM04Address Number - Sales Master 4NumericGeneric Edit80 Allow NULL? 
129VEANSM05Address Number - Sales Master 5NumericGeneric Edit80 Allow NULL? 
130VEANSM06Address Number - Sales Master 6NumericGeneric Edit80 Allow NULL? 
131VEANSM07Address Number - Sales Master 7NumericGeneric Edit80 Allow NULL? 
132VEANSM08Address Number - Sales Master 8NumericGeneric Edit80 Allow NULL? 
133VEANSM09Address Number - Sales Master 9NumericGeneric Edit80 Allow NULL? 
134VEANSM10Address Number - Sales Master 10NumericGeneric Edit80 Allow NULL? 

TOP910 | 08 | F080434B INDEXES

NumberDescription
1Version CompanyNo EndDate BU (Primary/Unique)
ElementAliasDescriptionSequence
1SVERSnapshot VersionAscending
2PRNMPreferred NameAscending
3VRBYVerified ByAscending
4NEWVALNew ValueAscending
2Version CompNo EndDate CompNam
ElementAliasDescriptionSequence
1SVERSnapshot VersionAscending
2PRNMPreferred NameAscending
3VRBYVerified ByAscending
4CONAMECompany NameAscending