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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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

83 COLUMNS | 1 INDEXES | Print definition?812 | 47 | F470472 TABLE

47: Electronic Commerce
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F470472S6831EDI Invoice Expanded Detail (Sales)Files42: 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 S6EDTY, S6EDSQ, S6EKCO, S6EDOC, S6EDCT, S6EDLN, S6EDSP, S6EDBT, S6SHAN, S6ALPH, S6CARS, S6SHPN, S6DEID, S6CIRV, S6CITM, S6SCAC, S6ORIG, S6DLDT, S6DLTM, S6NPCS, S6CBNK, S6ETRSC, S6ETRC, S6AETC, S6DKID, S6RFQ1, S6RFQ2, S6RFQ3, S6RFQ4, S6RFQ5, S6RF1, S6RF2, S6RF3, S6RF4, S6RF5, S6PRTY1, S6PRTY2, S6PRTY3, S6PRTY4, S6PRTY5, S6PRNA1, S6PRNA2, S6PRNA3, S6PRNA4, S6PRNA5, S6IDTYP1, S6IDTYP2, S6IDTYP3, S6IDTYP4, S6IDTYP5, S6IDNUM1, S6IDNUM2, S6IDNUM3, S6IDNUM4, S6IDNUM5, S6RFTY1, S6RFTY2, S6RFTY3, S6RFTY4, S6RFTY5, S6RFNUM1, S6RFNUM2, S6RFNUM3, S6RFNUM4, S6RFNUM5, S6FUT1, S6FUT2, S6FUT4, S6FUT5, S6X1, S6X2, S6D1FU, S6D2FU, S6TORG, S6USER, S6PID, S6JOBN, S6UPMJ, S6UPMT, S6JOBSQ, S6PSJOBNO, S6CARDNO, S6CIRVQ FROM F470472

TOP812 | 47 | F470472 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1S6EDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
2S6EDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
3S6EKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
4S6EDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
5S6EDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6S6EDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
7S6EDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
8S6EDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
9S6SHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
10S6ALPHName - AlphaStringGeneric Edit400 Allow NULL? 
11S6CARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
12S6SHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
13S6DEIDDemand Unique Key IDNumericGeneric Edit150 Allow NULL? 
14S6CIRVItem Revision Level - Customer/SupplierStringGeneric Edit200 Allow NULL? 
15S6CITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
16S6SCACStandard Carrier Alpha CodeStringGeneric Edit40 Allow NULL? 
17S6ORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
18S6DLDTDelivery DateDateGeneric Edit60
19S6DLTMTime - DeliveryNumericGeneric Edit60 Allow NULL? 
20S6NPCSNumber of PiecesNumericGeneric Edit50 Allow NULL? 
21S6CBNKBank Account Number - CustomerStringGeneric Edit200 Allow NULL? 
22S6ETRSCExcess Reason CodeStringUDC (49 ES)30 Allow NULL? 
23S6ETRCExcess ResponsibilityStringUDC (49 EC)30 Allow NULL? 
24S6AETCAuthorization CodeStringGeneric Edit100 Allow NULL? 
25S6DKIDDock IDStringGeneric Edit200 Allow NULL? 
26S6RFQ1Reference Number Qualifier 1StringUDC (41 X6)20 Allow NULL? 
27S6RFQ2Reference Number Qualifier 2StringUDC (41 X6)20 Allow NULL? 
28S6RFQ3Reference Number Qualifier 3StringUDC (41 X6)20 Allow NULL? 
29S6RFQ4Reference Number Qualifier 4StringUDC (41 X6)20 Allow NULL? 
30S6RFQ5Reference Number Qualifier 5StringUDC (41 X6)20 Allow NULL? 
31S6RF1Reference Number 1StringGeneric Edit300 Allow NULL? 
32S6RF2Reference Number 2StringGeneric Edit300 Allow NULL? 
33S6RF3Reference Number 3StringGeneric Edit300 Allow NULL? 
34S6RF4Reference Number 4StringGeneric Edit300 Allow NULL? 
35S6RF5Reference Number 5StringGeneric Edit300 Allow NULL? 
36S6PRTY1Party Type-1StringUDC (40R ST)20 Allow NULL? 
37S6PRTY2Party Type-2StringUDC (40R ST)20 Allow NULL? 
38S6PRTY3Party Type-3StringUDC (40R ST)20 Allow NULL? 
39S6PRTY4Party Type-4StringUDC (40R ST)20 Allow NULL? 
40S6PRTY5Party Type-5StringUDC (40R ST)20 Allow NULL? 
41S6PRNA1Party Name 1StringGeneric Edit350 Allow NULL? 
42S6PRNA2Party Name 2StringGeneric Edit350 Allow NULL? 
43S6PRNA3Party Name 3StringGeneric Edit350 Allow NULL? 
44S6PRNA4Party Name 4StringGeneric Edit350 Allow NULL? 
45S6PRNA5Party Name 5StringGeneric Edit350 Allow NULL? 
46S6IDTYP1ID Type-1StringUDC (40R ID)20 Allow NULL? 
47S6IDTYP2ID Type-2StringUDC (40R ID)20 Allow NULL? 
48S6IDTYP3ID Type-3StringUDC (40R ID)20 Allow NULL? 
49S6IDTYP4ID Type-4StringUDC (40R ID)20 Allow NULL? 
50S6IDTYP5ID Type-5StringUDC (40R ID)20 Allow NULL? 
51S6IDNUM1ID Number 1StringGeneric Edit200 Allow NULL? 
52S6IDNUM2ID Number 2StringGeneric Edit200 Allow NULL? 
53S6IDNUM3ID Number 3StringGeneric Edit200 Allow NULL? 
54S6IDNUM4ID Number 4StringGeneric Edit200 Allow NULL? 
55S6IDNUM5ID Number 5StringGeneric Edit200 Allow NULL? 
56S6RFTY1Reference Type-1StringUDC (40R QF)30 Allow NULL? 
57S6RFTY2Reference Type-2StringUDC (40R QF)30 Allow NULL? 
58S6RFTY3Reference Type-3StringUDC (40R QF)30 Allow NULL? 
59S6RFTY4Reference Type-4StringUDC (40R QF)30 Allow NULL? 
60S6RFTY5Reference Type-5StringUDC (40R QF)30 Allow NULL? 
61S6RFNUM1Reference Number 1StringGeneric Edit300 Allow NULL? 
62S6RFNUM2Reference Number 2StringGeneric Edit300 Allow NULL? 
63S6RFNUM3Reference Number 3StringGeneric Edit300 Allow NULL? 
64S6RFNUM4Reference Number 4StringGeneric Edit300 Allow NULL? 
65S6RFNUM5Reference Number 5StringGeneric Edit300 Allow NULL? 
66S6FUT1Future Use 1NumericGeneric Edit152 Allow NULL? 
67S6FUT2Future Use 2NumericGeneric Edit152 Allow NULL? 
68S6FUT4Future Use 4 - ReferenceStringGeneric Edit250 Allow NULL? 
69S6FUT5Future Use 5 - ReferenceStringGeneric Edit250 Allow NULL? 
70S6X1For Future Use - Flag 1CharacterGeneric Edit10 Allow NULL? 
71S6X2For Future Use - Flag 2CharacterGeneric Edit10 Allow NULL? 
72S6D1FUFuture Use - Date 1DateGeneric Edit60
73S6D2FUFuture Use - Date 2DateGeneric Edit60
74S6TORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
75S6USERUser IDStringGeneric Edit100 Allow NULL? 
76S6PIDProgram IDStringGeneric Edit100 Allow NULL? 
77S6JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
78S6UPMJDate - UpdatedDateGeneric Edit60
79S6UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
80S6JOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
81S6PSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
82S6CARDNOCard NumberStringUDC (40R CD)40 Allow NULL? 
83S6CIRVQItem Revision Level QualifierStringUDC (40R IQ)20 Allow NULL? 

TOP812 | 47 | F470472 INDEXES

NumberDescription
1CompanyKeyEDIOrder EDIDocu + (Primary/Unique)
ElementAliasDescriptionSequence
1EKCOCompany - Key (EDI - Document Key Co)Ascending
2EDOCEDI - Document NumberAscending
3EDCTEDI - Document TypeAscending
4EDLNEDI - Line NumberAscending