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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

72 COLUMNS | 2 INDEXES | Print definition?920 | 08 | F080436 TABLE

08: Human Resources
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F080436VT722VETS-4212 Employment ReportFiles08: 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 VTSVER, VTACYV, VTTORO, VTTYOF, VTNMSC, VTTMEP, VTNMCY, VTAPC1, VTAPC2, VTCPTC, VTCNYP, VTSTYV, VTPCYV, VTNMPC, VTPHYV, VTEPCY, VTNAMH, VTAHL1, VTAHL2, VTCTHL, VTCYHL, VTSTHL, VTPCHL, VTNAIS, VTDUVT, VTEIDV, VTVTVV01, VTVTVV02, VTVTVV03, VTVTVV04, VTVTVV05, VTVTVV06, VTVTVV07, VTVTVV08, VTVTVV09, VTVTVV10, VTVTVV11, VTVTVV12, VTVTVV13, VTVTVV14, VTVTVV15, VTVTVV16, VTVTVV17, VTVTVV18, VTVTVV19, VTVTVV20, VTVTVV21, VTVTVV22, VTVTVV23, VTVTVV24, VTVTVV25, VTVTVV26, VTVTVV27, VTVTVV28, VTVTVV29, VTVTVV30, VTVTVV31, VTVTVV32, VTVTVV33, VTVTVV34, VTVTVV35, VTVTVV36, VTVTVV37, VTVTVV38, VTVTVV39, VTVTVV40, VTVTVV41, VTVTVV42, VTVTVV43, VTVTVV44, VTVTVVMX, VTVTVVMN FROM F080436

TOP920 | 08 | F080436 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1VTSVERSnapshot VersionStringGeneric Edit100 Allow NULL? 
2VTACYVAssigned Company No.StringGeneric Edit70 Allow NULL? 
3VTTOROType of Reporting OrganizationCharacterGeneric Edit10 Allow NULL? 
4VTTYOFType of FormStringGeneric Edit30 Allow NULL? 
5VTNMSCNumber of MSC LocationsStringGeneric Edit80 Allow NULL? 
6VTTMEPTwelve Month Ending PeriodStringGeneric Edit100 Allow NULL? 
7VTNMCYName - Parent CompanyStringGeneric Edit1000 Allow NULL? 
8VTAPC1Address Line 1 - Parent CompanyStringGeneric Edit1000 Allow NULL? 
9VTAPC2Address Line 2 - Parent CompanyStringGeneric Edit1000 Allow NULL? 
10VTCPTCCity - Parent CompanyStringGeneric Edit500 Allow NULL? 
11VTCNYPCounty - Parent CompanyStringGeneric Edit500 Allow NULL? 
12VTSTYVState - Parent CompanyStringGeneric Edit20 Allow NULL? 
13VTPCYVPostal Code - Parent CompanyStringGeneric Edit90 Allow NULL? 
14VTNMPCName - Parent Company ContactStringGeneric Edit1000 Allow NULL? 
15VTPHYVPhone - Parent Company ContactStringGeneric Edit200 Allow NULL? 
16VTEPCYEmail - Parent Company ContactStringGeneric Edit1000 Allow NULL? 
17VTNAMHName - Hiring LocationStringGeneric Edit1000 Allow NULL? 
18VTAHL1Address Line 1 - Hiring LocationStringGeneric Edit1000 Allow NULL? 
19VTAHL2Address Line 2 - Hiring LocationStringGeneric Edit1000 Allow NULL? 
20VTCTHLCity - Hiring LocationStringGeneric Edit500 Allow NULL? 
21VTCYHLCounty - Hiring LocationStringGeneric Edit500 Allow NULL? 
22VTSTHLState - Hiring LocationStringGeneric Edit20 Allow NULL? 
23VTPCHLPostal Code - Hiring LocationStringGeneric Edit90 Allow NULL? 
24VTNAISNAICS for Veterans ReportsStringGeneric Edit60 Allow NULL? 
25VTDUVTDUNS for Veterans ReportsStringGeneric Edit90 Allow NULL? 
26VTEIDVEIN for Veterans ReportsStringGeneric Edit90 Allow NULL? 
27VTVTVV01Employee Count 01NumericGeneric Edit80 Allow NULL? 
28VTVTVV02Employee Count 02NumericGeneric Edit80 Allow NULL? 
29VTVTVV03Employee Count 03NumericGeneric Edit80 Allow NULL? 
30VTVTVV04Employee Count 04NumericGeneric Edit80 Allow NULL? 
31VTVTVV05Employee Count 05NumericGeneric Edit80 Allow NULL? 
32VTVTVV06Employee Count 06NumericGeneric Edit80 Allow NULL? 
33VTVTVV07Employee Count 07NumericGeneric Edit80 Allow NULL? 
34VTVTVV08Employee Count 08NumericGeneric Edit80 Allow NULL? 
35VTVTVV09Employee Count 09NumericGeneric Edit80 Allow NULL? 
36VTVTVV10Employee Count 10NumericGeneric Edit80 Allow NULL? 
37VTVTVV11Employee Count 11NumericGeneric Edit80 Allow NULL? 
38VTVTVV12Employee Count 12NumericGeneric Edit80 Allow NULL? 
39VTVTVV13Employee Count 13NumericGeneric Edit80 Allow NULL? 
40VTVTVV14Employee Count 14NumericGeneric Edit80 Allow NULL? 
41VTVTVV15Employee Count 15NumericGeneric Edit80 Allow NULL? 
42VTVTVV16Employee Count 16NumericGeneric Edit80 Allow NULL? 
43VTVTVV17Employee Count 17NumericGeneric Edit80 Allow NULL? 
44VTVTVV18Employee Count 18NumericGeneric Edit80 Allow NULL? 
45VTVTVV19Employee Count 19NumericGeneric Edit80 Allow NULL? 
46VTVTVV20Employee Count 20NumericGeneric Edit80 Allow NULL? 
47VTVTVV21Employee Count 21NumericGeneric Edit80 Allow NULL? 
48VTVTVV22Employee Count 22NumericGeneric Edit80 Allow NULL? 
49VTVTVV23Employee Count 23NumericGeneric Edit80 Allow NULL? 
50VTVTVV24Employee Count 24NumericGeneric Edit80 Allow NULL? 
51VTVTVV25Employee Count 25NumericGeneric Edit80 Allow NULL? 
52VTVTVV26Employee Count 26NumericGeneric Edit80 Allow NULL? 
53VTVTVV27Employee Count 27NumericGeneric Edit80 Allow NULL? 
54VTVTVV28Employee Count 28NumericGeneric Edit80 Allow NULL? 
55VTVTVV29Employee Count 29NumericGeneric Edit80 Allow NULL? 
56VTVTVV30Employee Count 30NumericGeneric Edit80 Allow NULL? 
57VTVTVV31Employee Count 31NumericGeneric Edit80 Allow NULL? 
58VTVTVV32Employee Count 32NumericGeneric Edit80 Allow NULL? 
59VTVTVV33Employee Count 33NumericGeneric Edit80 Allow NULL? 
60VTVTVV34Employee Count 34NumericGeneric Edit80 Allow NULL? 
61VTVTVV35Employee Count 35NumericGeneric Edit80 Allow NULL? 
62VTVTVV36Employee Count 36NumericGeneric Edit80 Allow NULL? 
63VTVTVV37Employee Count 37NumericGeneric Edit80 Allow NULL? 
64VTVTVV38Employee Count 38NumericGeneric Edit80 Allow NULL? 
65VTVTVV39Employee Count 39NumericGeneric Edit80 Allow NULL? 
66VTVTVV40Employee Count 40NumericGeneric Edit80 Allow NULL? 
67VTVTVV41Employee Count 41NumericGeneric Edit80 Allow NULL? 
68VTVTVV42Employee Count 42NumericGeneric Edit80 Allow NULL? 
69VTVTVV43Employee Count 43NumericGeneric Edit80 Allow NULL? 
70VTVTVV44Employee Count 44NumericGeneric Edit80 Allow NULL? 
71VTVTVVMXMaximum NumberNumericGeneric Edit80 Allow NULL? 
72VTVTVVMNMinimum NumberNumericGeneric Edit80 Allow NULL? 

TOP920 | 08 | F080436 INDEXES

NumberDescription
1Version CompanyNo EndDate HL (Primary/Unique)
ElementAliasDescriptionSequence
1SVERSnapshot VersionAscending
2ACYVAssigned Company No.Ascending
3TMEPTwelve Month Ending PeriodAscending
4NAMHName - Hiring LocationAscending
2Version CompanyNo EndDate Comp
ElementAliasDescriptionSequence
1SVERSnapshot VersionAscending
2ACYVAssigned Company No.Ascending
3TMEPTwelve Month Ending PeriodAscending
4NMCYName - Parent CompanyAscending