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

125 COLUMNS | 2 INDEXES | Print definition?812 | 75T | F75T403 TABLE

75T: Taiwan
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F75T403D31252GUI/VAT Declaration Report 403 - 75TBalance Files75: ASEAN Localization
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 D3CO, D375TDSI, D375TYMD, D3PSQ, D375TVID, D375TYMS, D375TYMT, D375TDBM, D375TMDU, D375TTRM, D375TUIC, D375TGDC, D375TPDC, D375TCVC, D375TRAC, D375TPFC, D375TZDC, D375TTDD, D375T001, D375T002, D375T005, D375T006, D375T009, D375T010, D375T013, D375T014, D375T017, D375T018, D375T021, D375T022, D375T003, D375T007, D375T011, D375T015, D375T019, D375T023, D375T004, D375T008, D375T012, D375T016, D375T020, D375T024, D375T052, D375T053, D375T054, D375T055, D375T056, D375T057, D375T058, D375T059, D375T060, D375T061, D375T062, D375T063, D375T064, D375T065, D375T066, D375T025, D375T026, D375T027, D375T028, D375T029, D375T030, D375T031, D375T032, D375T033, D375T034, D375T035, D375T036, D375T037, D375T038, D375T039, D375T078, D375T079, D375T080, D375T081, D375T040, D375T041, D375T042, D375T043, D375T044, D375T045, D375T046, D375T047, D375T048, D375T049, D375T050, D375T051, D375T067, D375T068, D375T069, D375T070, D375T071, D375T072, D375T073, D375T074, D375T075, D375T076, D375T101, D375T102, D375T103, D375T104, D375T105, D375T106, D375T107, D375T108, D375T109, D375T110, D375T111, D375T112, D375T113, D375T114, D375T115, D375T082, D375TGES, D3URC1, D3URDT, D3URAT, D3URAB, D3URRF, D3USER, D3PID, D3JOBN, D3UPMJ, D3TDAY FROM F75T403

TOP812 | 75T | F75T403 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1D3COCompanyStringGeneric Edit50 Allow NULL? 
2D375TDSIGUI/VAT Declaration SiteStringUDC (75T DS)50 Allow NULL? 
3D375TYMDYear And Month Of VAT DeclarationNumericGeneric Edit60 Allow NULL? 
4D3PSQPrimary Sequence NumberNumericGeneric Edit62 Allow NULL? 
5D375TVIDPrompt - Whether GUI/VAT Is DeclaredCharacterGeneric Edit10 Allow NULL? 
6D375TYMSBeginning Year / Month Of Sales DocNumericGeneric Edit60 Allow NULL? 
7D375TYMTEnding YM Of Sal./Pur. DocNumericGeneric Edit60 Allow NULL? 
8D375TDBMPrompt - Declaration By Month (Y/N)CharacterGeneric Edit10 Allow NULL? 
9D375TMDUApproved Declaration UnitStringUDC (75T DU)20 Allow NULL? 
10D375TTRMTax Refund MethodStringUDC (75T TR)30 Allow NULL? 
11D375TUICCount Of Used GUIsNumericGeneric Edit100 Allow NULL? 
12D375TGDCCount Of GUI Detail ReportsNumericGeneric Edit100 Allow NULL? 
13D375TPDCCount Of Purchase DocumentsNumericGeneric Edit100 Allow NULL? 
14D375TCVCCount Of Customs VAT DocumentsNumericGeneric Edit100 Allow NULL? 
15D375TRACCount Of Returns And AllowancesNumericGeneric Edit100 Allow NULL? 
16D375TPFCCount Of VAT Payment FormNumericGeneric Edit50 Allow NULL? 
17D375TZDCCount Of Zero Tax Rate DocumentsNumericGeneric Edit100 Allow NULL? 
18D375TTDDDate - VAT Declaration DateDateGeneric Edit60
19D375T001Amount - VAT: Field 001NumericGeneric Edit150 Allow NULL? 
20D375T002Amount - VAT: Field 002NumericGeneric Edit150 Allow NULL? 
21D375T005Amount - VAT: Field 005NumericGeneric Edit150 Allow NULL? 
22D375T006Amount - VAT: Field 006NumericGeneric Edit150 Allow NULL? 
23D375T009Amount - VAT: Field 009NumericGeneric Edit150 Allow NULL? 
24D375T010Amount - VAT: Field 010NumericGeneric Edit150 Allow NULL? 
25D375T013Amount - VAT: Field 013NumericGeneric Edit150 Allow NULL? 
26D375T014Amount - VAT: Field 014NumericGeneric Edit150 Allow NULL? 
27D375T017Amount - VAT: Field 017NumericGeneric Edit150 Allow NULL? 
28D375T018Amount - VAT: Field 018NumericGeneric Edit150 Allow NULL? 
29D375T021Amount - VAT: Field 021NumericGeneric Edit150 Allow NULL? 
30D375T022Amount - VAT: Field 022NumericGeneric Edit150 Allow NULL? 
31D375T003Amount - VAT: Field 003NumericGeneric Edit150 Allow NULL? 
32D375T007Amount - VAT: Field 007NumericGeneric Edit150 Allow NULL? 
33D375T011Amount - VAT: Field 011NumericGeneric Edit150 Allow NULL? 
34D375T015Amount - VAT: Field 015NumericGeneric Edit150 Allow NULL? 
35D375T019Amount - VAT: Field 019NumericGeneric Edit150 Allow NULL? 
36D375T023Amount - VAT: Field 023NumericGeneric Edit150 Allow NULL? 
37D375T004Amount - VAT: Field 004NumericGeneric Edit150 Allow NULL? 
38D375T008Amount - VAT: Field 008NumericGeneric Edit150 Allow NULL? 
39D375T012Amount - VAT: Field 012NumericGeneric Edit150 Allow NULL? 
40D375T016Amount - VAT: Field 016NumericGeneric Edit150 Allow NULL? 
41D375T020Amount - VAT: Field 020NumericGeneric Edit150 Allow NULL? 
42D375T024Amount - VAT: Field 024NumericGeneric Edit150 Allow NULL? 
43D375T052Amount - VAT: Field 052NumericGeneric Edit150 Allow NULL? 
44D375T053Amount - VAT: Field 053NumericGeneric Edit150 Allow NULL? 
45D375T054Amount - VAT: Field 054NumericGeneric Edit150 Allow NULL? 
46D375T055Amount - VAT: Field 055NumericGeneric Edit150 Allow NULL? 
47D375T056Amount - VAT: Field 056NumericGeneric Edit150 Allow NULL? 
48D375T057Amount - VAT: Field 057NumericGeneric Edit150 Allow NULL? 
49D375T058Amount - VAT: Field 058NumericGeneric Edit150 Allow NULL? 
50D375T059Amount - VAT: Field 059NumericGeneric Edit150 Allow NULL? 
51D375T060Amount - VAT: Field 060NumericGeneric Edit150 Allow NULL? 
52D375T061Amount - VAT: Field 061NumericGeneric Edit150 Allow NULL? 
53D375T062Amount - VAT: Field 062NumericGeneric Edit150 Allow NULL? 
54D375T063Amount - VAT: Field 063NumericGeneric Edit150 Allow NULL? 
55D375T064Amount - VAT: Field 064NumericGeneric Edit150 Allow NULL? 
56D375T065Amount - VAT: Field 065NumericGeneric Edit150 Allow NULL? 
57D375T066Amount - VAT: Field 066NumericGeneric Edit150 Allow NULL? 
58D375T025Amount - VAT: Field 025NumericGeneric Edit150 Allow NULL? 
59D375T026Amount - VAT: Field 026NumericGeneric Edit150 Allow NULL? 
60D375T027Amount - VAT: Field 027NumericGeneric Edit150 Allow NULL? 
61D375T028Amount - VAT: Field 028NumericGeneric Edit150 Allow NULL? 
62D375T029Amount - VAT: Field 029NumericGeneric Edit150 Allow NULL? 
63D375T030Amount - VAT: Field 030NumericGeneric Edit150 Allow NULL? 
64D375T031Amount - VAT: Field 031NumericGeneric Edit150 Allow NULL? 
65D375T032Amount - VAT: Field 032NumericGeneric Edit150 Allow NULL? 
66D375T033Amount - VAT: Field 033NumericGeneric Edit150 Allow NULL? 
67D375T034Amount - VAT: Field 034NumericGeneric Edit150 Allow NULL? 
68D375T035Amount - VAT: Field 035NumericGeneric Edit150 Allow NULL? 
69D375T036Amount - VAT: Field 036NumericGeneric Edit150 Allow NULL? 
70D375T037Amount - VAT: Field 037NumericGeneric Edit150 Allow NULL? 
71D375T038Amount - VAT: Field 038NumericGeneric Edit150 Allow NULL? 
72D375T039Amount - VAT: Field 039NumericGeneric Edit150 Allow NULL? 
73D375T078Amount - VAT: Field 078NumericGeneric Edit150 Allow NULL? 
74D375T079Amount - VAT: Field 079NumericGeneric Edit150 Allow NULL? 
75D375T080Amount - VAT: Field 080NumericGeneric Edit150 Allow NULL? 
76D375T081Amount - VAT: Field 081NumericGeneric Edit150 Allow NULL? 
77D375T040Amount - VAT: Field 040NumericGeneric Edit150 Allow NULL? 
78D375T041Amount - VAT: Field 041NumericGeneric Edit150 Allow NULL? 
79D375T042Amount - VAT: Field 042NumericGeneric Edit150 Allow NULL? 
80D375T043Amount - VAT: Field 043NumericGeneric Edit150 Allow NULL? 
81D375T044Amount - VAT: Field 044NumericGeneric Edit150 Allow NULL? 
82D375T045Amount - VAT: Field 045NumericGeneric Edit150 Allow NULL? 
83D375T046Amount - VAT: Field 046NumericGeneric Edit150 Allow NULL? 
84D375T047Amount - VAT: Field 047NumericGeneric Edit150 Allow NULL? 
85D375T048Amount - VAT: Field 048NumericGeneric Edit150 Allow NULL? 
86D375T049Amount - VAT: Field 049NumericGeneric Edit150 Allow NULL? 
87D375T050Amount - VAT: Field 050NumericGeneric Edit150 Allow NULL? 
88D375T051Amount - VAT: Field 051NumericGeneric Edit150 Allow NULL? 
89D375T067Amount - VAT: Field 067NumericGeneric Edit150 Allow NULL? 
90D375T068Amount - VAT: Field 068NumericGeneric Edit150 Allow NULL? 
91D375T069Amount - VAT: Field 069NumericGeneric Edit150 Allow NULL? 
92D375T070Amount - VAT: Field 070NumericGeneric Edit150 Allow NULL? 
93D375T071Amount - VAT: Field 071NumericGeneric Edit150 Allow NULL? 
94D375T072Amount - VAT: Field 072NumericGeneric Edit150 Allow NULL? 
95D375T073Amount - VAT: Field 073NumericGeneric Edit150 Allow NULL? 
96D375T074Amount - VAT: Field 074NumericGeneric Edit150 Allow NULL? 
97D375T075Amount - VAT: Field 075NumericGeneric Edit150 Allow NULL? 
98D375T076Amount - VAT: Field 076NumericGeneric Edit150 Allow NULL? 
99D375T101Amount - VAT: Field 101NumericGeneric Edit150 Allow NULL? 
100D375T102Amount - VAT: Field 102NumericGeneric Edit150 Allow NULL? 
101D375T103Amount - VAT: Field 103NumericGeneric Edit150 Allow NULL? 
102D375T104Amount - VAT: Field 104NumericGeneric Edit150 Allow NULL? 
103D375T105Amount - VAT: Field 105NumericGeneric Edit150 Allow NULL? 
104D375T106Amount - VAT: Field 106NumericGeneric Edit150 Allow NULL? 
105D375T107Amount - VAT: Field 107NumericGeneric Edit150 Allow NULL? 
106D375T108Amount - VAT: Field 108NumericGeneric Edit150 Allow NULL? 
107D375T109Amount - VAT: Field 109NumericGeneric Edit150 Allow NULL? 
108D375T110Amount - VAT: Field 110NumericGeneric Edit150 Allow NULL? 
109D375T111Amount - VAT: Field 111NumericGeneric Edit150 Allow NULL? 
110D375T112Amount - VAT: Field 112NumericGeneric Edit150 Allow NULL? 
111D375T113Amount - VAT: Field 113NumericGeneric Edit150 Allow NULL? 
112D375T114Amount - VAT: Field 114NumericGeneric Edit150 Allow NULL? 
113D375T115Amount - VAT: Field 115NumericGeneric Edit150 Allow NULL? 
114D375T082Amount - VAT: Field 082NumericGeneric Edit150 Allow NULL? 
115D375TGESAmount - GUI-Exempt Sales AmtNumericGeneric Edit150 Allow NULL? 
116D3URC1User Reserved CodeStringGeneric Edit30 Allow NULL? 
117D3URDTUser Reserved DateDateGeneric Edit60
118D3URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
119D3URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
120D3URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
121D3USERUser IDStringGeneric Edit100 Allow NULL? 
122D3PIDProgram IDStringGeneric Edit100 Allow NULL? 
123D3JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
124D3UPMJDate - UpdatedDateGeneric Edit60
125D3TDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP812 | 75T | F75T403 INDEXES

NumberDescription
1Idx75T403_1 (Primary/Unique)
ElementAliasDescriptionSequence
1COCompanyAscending
275TDSIGUI/VAT Declaration SiteAscending
375TYMDYear And Month Of VAT DeclarationAscending
4PSQPrimary Sequence NumberAscending
2Idx75T403_2
ElementAliasDescriptionSequence
1COCompanyAscending
275TDSIGUI/VAT Declaration SiteAscending
375TYMDYear And Month Of VAT DeclarationAscending
4PSQPrimary Sequence NumberDescending