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

38 COLUMNS | 2 INDEXES | Print definition?910 | 75I | F75I008 TABLE

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F75I008PO382Purchase Order Receiver Tag File - IND - 43Files75I: 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 POMATC, POKCOO, PODOCO, PODCTO, POSFXO, POLNID, PONLIN, PODOC, PODCT, POKCO, POPCST, POI75ASVA, POI75TXRG, POI75TXTY, POYEXU, POI75RTSU, POI75RTEU, POI75ITTY, POI75RECU, POI75DEDT, POI75CHEX, POI75CHCD, POI75PRFL, POI75CUHO, POI75ORMA, POI75ORIN, POI75ORID, POI75ORAD, POI75ORTD, POI75ORQR, POI75ORUM, POI75ORDR, POI75ORCH, POUSER, POPID, POJOBN, POUPMJ, POUPMT FROM F75I008

TOP910 | 75I | F75I008 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1POMATCType - Match Record TypeCharacterGeneric Edit10 Allow NULL? 
2POKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
3PODOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
4PODCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
5POSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
6POLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
7PONLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
8PODOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
9PODCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
10POKCODocument CompanyStringGeneric Edit50 Allow NULL? 
11POPCSTPercent - Cost Add-OnNumericGeneric Edit157 Allow NULL? 
12POI75ASVAAssessable ValueNumericGeneric Edit152 Allow NULL? 
13POI75TXRGTax RegimeStringUDC (75I GR)50 Allow NULL? 
14POI75TXTYTax TypeStringUDC (75I GT)50 Allow NULL? 
15POYEXUExcise UnitNumericGeneric Edit80 Allow NULL? 
16POI75RTSURegistration Type - SupplierStringUDC (75I RT)30 Allow NULL? 
17POI75RTEURegistration Type - Excise UnitStringUDC (75I RT)30 Allow NULL? 
18POI75ITTYItem TypeStringGeneric Edit60 Allow NULL? 
19POI75RECURecoverableCharacterUDC (75I RF)10 Allow NULL? 
20POI75DEDTDeferred DateDateGeneric Edit60
21POI75CHEXChapter Number ExciseStringGeneric Edit200 Allow NULL? 
22POI75CHCDChapter Number Custom DutyStringGeneric Edit200 Allow NULL? 
23POI75PRFLProcessed FlagCharacterUDC (75I PF)10 Allow NULL? 
24POI75CUHOCustoms HouseStringGeneric Edit400 Allow NULL? 
25POI75ORMAOriginal Manufacturer or ImporterNumericGeneric Edit80 Allow NULL? 
26POI75ORINOriginal Invoice NumberStringGeneric Edit250 Allow NULL? 
27POI75ORIDOriginal Invoice DateDateGeneric Edit60
28POI75ORADOriginal Unit Amount of DutyNumericGeneric Edit154 Allow NULL? 
29POI75ORTDOriginal Total DutyNumericGeneric Edit152 Allow NULL? 
30POI75ORQROriginal Quantity ReceivedNumericGeneric Edit152 Allow NULL? 
31POI75ORUMOriginal Unit of measureStringUDC (00 UM)20 Allow NULL? 
32POI75ORDROriginal Duty Rate %NumericGeneric Edit157 Allow NULL? 
33POI75ORCHOriginal Customs HouseStringGeneric Edit400 Allow NULL? 
34POUSERUser IDStringGeneric Edit100 Allow NULL? 
35POPIDProgram IDStringGeneric Edit100 Allow NULL? 
36POJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
37POUPMJDate - UpdatedDateGeneric Edit60
38POUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP910 | 75I | F75I008 INDEXES

NumberDescription
1Order Number Order Type + (Primary/Unique)
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
7NLINNumber of LinesAscending
8DOCDocument (Voucher Invoice etc.)Ascending
2Receipt Doc Receipt Typ +
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending