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

33 columns | Print definition?920 | B76BLCK

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP76B: Brazil
1F76B050Address Book - SPED Project - WF - BRA - 76B3WAB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
2F76B051Item number - SPED Project - WF - BRA - 76B3WIB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
3F76B0511Electronic Reporting Process Detail2PDB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
4F76B0512Electronic Reporting - Tag File2PDB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
5F76B052Unit of measure - SPED Fiscal Brazilian WF - BRA - 76B3WUB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
6F76B0524Unit of Measure Brazilian Work File2ABB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
7F76B0526Chart of Account Brazilian Workfile.3AMB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
8F76B053Transaction Nature - SPED Fiscal Brazilian WF - BRA - 76B3WTB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
9F76B0530Electronic Reporting Header Blocks - BR -3HBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
10F76B0531Electronic Reporting Detail Blocks - BR -2DBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
11F76B054Messages Information - SPED Fiscal Brazilian WF - BRA - 76B3WMB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
12F76B055Cost Center - SPED Fiscal Brazilian WF - BRA - 76B3WCB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
13F76B056Account - SPED Fiscal Brazilian WF - BRA - 76B3WTB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
14F76B057Administrative Process - SPED Project - WF - BRA - 76B3WDB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
15F76B058Judicial Process- SPED Project - WF - BRA - 76B3WJB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
16F76B0730Ato Cotepe Header Blocks Template - BR - 002HBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
17F76B0731Ato Cotepe Detail Blocks Template - BR - 002DBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
18F76B0741Ato Cotepe Process Header Blocks - BR - 002PBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
19F76B0742Ato Cotepe Process Detail Blocks - BR - 002PDB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
20F76B0780COTEPE Rules Table Control2RTB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
21F76B0800Address Book - SPED Fiscal Brazilian Workfile3ABB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
22F76B0801Item number - SPED Fiscal Brazilian Workfile3IMB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
23F76B0802Unit of measure - SPED Fiscal Brazilian Workfile3UMB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
24F76B0803UM Conversions - SPED Fiscal Brazilian Workfile3FCB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
25F76B0804Asset number - SPED Fiscal Brazilian Workfile3ANB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
26F76B0805Transaction nature - SPED Fiscal Brazilian Workfile3TNB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
27F76B0806Messages information - SPED Fiscal Brazilian Workfile3MIB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
28F76B0807Cost Center - SPED Fiscal Brazilian Workfile3CCB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
29F76B0808State - SPED Fiscal Brazilian Workfile3STB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
30F76B941SPED Job Header Blocks - BR - 092HBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
31F76B942SPED Job Detail Blocks-UBE - BR - 092DBB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
32F76B943SPED Job Output Detail - BR - 092ODB76BLCKElectronic Reporting BlockCharacterGeneric Edit10
33F76BUI80COTEPE Rules Table Control Work File2CRB76BLCKElectronic Reporting BlockCharacterGeneric Edit10