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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail 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

37 COLUMNS | 1 INDEXES | Print definition?910 | 75I | F75I210 TABLE

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F75I210CS371Tax Registration Details - IND - 00Files75I: India
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 CSAN8, CSADD1, CSADD2, CSADD3, CSADD4, CSADD5, CSADD6, CSI75CERC, CSI75RETY, CSPCAC, CSI75ECCN, CSI75ZONE, CSI75REGN, CSI75CIRC, CSI75COTR, CSI75RNGE, CSD01, CSD02, CSD03, CSD04, CSD05, CSD06, CSI75WCT, CSI75TIN, CSI75SERT, CSI75CST, CSI75LST, CSI75DVSN, CSUSER, CSJOBN, CSPID, CSUPMJ, CSUPMT, CSI75ORAC, CSI75AUTH, CSI75DSGN, CSI75EIC FROM F75I210

TOP910 | 75I | F75I210 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CSAN8Address NumberNumericUDC80 Allow NULL? 
2CSADD1Address Line 1StringGeneric Edit400 Allow NULL? 
3CSADD2Address Line 2StringGeneric Edit400 Allow NULL? 
4CSADD3Address Line 3StringGeneric Edit400 Allow NULL? 
5CSADD4Address Line 4StringGeneric Edit400 Allow NULL? 
6CSADD5Address Line 5StringGeneric Edit400 Allow NULL? 
7CSADD6Address Line 6StringGeneric Edit400 Allow NULL? 
8CSI75CERCCERC NumberStringGeneric Edit150 Allow NULL? 
9CSI75RETYRegistration TypeStringGeneric Edit30 Allow NULL? 
10CSPCACAuthorization CodeStringGeneric Edit100 Allow NULL? 
11CSI75ECCNExcise Control Code NumberStringGeneric Edit150 Allow NULL? 
12CSI75ZONEZoneStringGeneric Edit400 Allow NULL? 
13CSI75REGNRegionStringGeneric Edit400 Allow NULL? 
14CSI75CIRCCircleStringGeneric Edit400 Allow NULL? 
15CSI75COTRCollectorateStringGeneric Edit400 Allow NULL? 
16CSI75RNGERangeStringGeneric Edit400 Allow NULL? 
17CSD01Date - End of Period 01DateGeneric Edit60
18CSD02Date - End of Period 02DateGeneric Edit60
19CSD03Date - End of Period 03DateGeneric Edit60
20CSD04Date - End of Period 04DateGeneric Edit60
21CSD05Date - End of Period 05DateGeneric Edit60
22CSD06Date - End of Period 06DateGeneric Edit60
23CSI75WCTWCT Registration NumberStringGeneric Edit400 Allow NULL? 
24CSI75TINTax Identification NumberStringGeneric Edit400 Allow NULL? 
25CSI75SERTService Tax Registration NumberStringGeneric Edit150 Allow NULL? 
26CSI75CSTCST Registration NumberStringGeneric Edit400 Allow NULL? 
27CSI75LSTLST Registration NumberStringGeneric Edit400 Allow NULL? 
28CSI75DVSNDivisionStringGeneric Edit400 Allow NULL? 
29CSUSERUser IDStringGeneric Edit100 Allow NULL? 
30CSJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
31CSPIDProgram IDStringGeneric Edit100 Allow NULL? 
32CSUPMJDate - UpdatedDateGeneric Edit60
33CSUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
34CSI75ORACOrganization Account Current NumberStringGeneric Edit400 Allow NULL? 
35CSI75AUTHName of the Tax Authority OfficerStringGeneric Edit400 Allow NULL? 
36CSI75DSGNDesignation of the Tax Authority OfficerStringGeneric Edit400 Allow NULL? 
37CSI75EIC Export Import Control CodeStringGeneric Edit400 Allow NULL? 

TOP910 | 75I | F75I210 INDEXES

NumberDescription
1AN8 (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending