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

45 COLUMNS | 2 INDEXES | Print definition?920 | 45 | F45715 TABLE

45: Advanced Pricing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F45715AB452Adjustment BalancesBalance Files45: Advanced PricingBusiness Data
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 ABAST, ABAGTY, ABANS8, ABMCU, ABAN8, ABITM, ABIGID, ABCGID, ABASAI, ABEFTJ, ABEXDJ, ABAGSP, ABAGIN, ABCATN, ABRPER, ABSCLM, ABCLMD, ABCCF3, ABBDCS, ABBDCL, ABFRMN, ABFVMD, ABPUFR, ABMQYQ, ABMAQY, ABQYOA, ABQYAP, ABQYCL, ABUOM, ABBC01, ABBC02, ABBC03, ABBC04, ABBC05, ABURCD, ABURDT, ABURAT, ABURAB, ABURRF, ABUSER, ABPID, ABJOBN, ABUPMJ, ABTDAY, ABAGNB FROM F45715

TOP920 | 45 | F45715 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ABASTPrice Adjustment NameStringUDC (40 TY)80 Allow NULL? 
2ABAGTYAgreementTypeStringUDC (45 AT)20 Allow NULL? 
3ABANS8Address NumberNumericGeneric Edit80 Allow NULL? 
4ABMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5ABAN8Address NumberNumericGeneric Edit80 Allow NULL? 
6ABITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
7ABIGIDItem Group Key IDNumericGeneric Edit80 Allow NULL? 
8ABCGIDCustomer Group Key IDNumericGeneric Edit80 Allow NULL? 
9ABASAIActive/InactiveCharacterGeneric Edit10 Allow NULL? 
10ABEFTJDate - EffectiveDateGeneric Edit60
11ABEXDJDate - ExpiredDateGeneric Edit60
12ABAGSPAgreement NumberStringGeneric Edit80 Allow NULL? 
13ABAGINAgreement Number - InternalNumericGeneric Edit80 Allow NULL? 
14ABCATNCatalogStringUDC (40 CN)80 Allow NULL? 
15ABRPERPerson ResponsibleNumericGeneric Edit80 Allow NULL? 
16ABSCLMAddress Number - Send Claim ToNumericGeneric Edit80 Allow NULL? 
17ABCLMDClaim MethodCharacterUDC (45 CM)10 Allow NULL? 
18ABCCF3Currency Code - From 3StringGeneric Edit30 Allow NULL? 
19ABBDCSAmount - Based On CostNumericGeneric Edit154 Allow NULL? 
20ABBDCLBased On Cost Lock FlagCharacterGeneric Edit10 Allow NULL? 
21ABFRMNPrice Formula NameStringUDC (40 FM)100 Allow NULL? 
22ABFVMDFactor Value MethodCharacterUDC (40 BC)10 Allow NULL? 
23ABPUFRPer Unit FactorCharacterGeneric Edit10 Allow NULL? 
24ABMQYQUnits - Minimum Quantity to QualifyNumericGeneric Edit150 Allow NULL? 
25ABMAQYUnits - Maximum Authorized QuantityNumericGeneric Edit150 Allow NULL? 
26ABQYOAUnits - Quantity Open/AvailableNumericGeneric Edit150 Allow NULL? 
27ABQYAPUnits - Quantity AppliedNumericGeneric Edit150 Allow NULL? 
28ABQYCLUnits - Claimed QuantityNumericGeneric Edit150 Allow NULL? 
29ABUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
30ABBC01Ship And Debit Cost IndicatorStringGeneric Edit30 Allow NULL? 
31ABBC02Adjustment Balances 02StringGeneric Edit30 Allow NULL? 
32ABBC03Adjustment Balances 03StringGeneric Edit30 Allow NULL? 
33ABBC04Adjustment Balances 04StringGeneric Edit30 Allow NULL? 
34ABBC05Adjustment Balances 05StringGeneric Edit30 Allow NULL? 
35ABURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
36ABURDTUser Reserved DateDateGeneric Edit60
37ABURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
38ABURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
39ABURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
40ABUSERUser IDStringGeneric Edit100 Allow NULL? 
41ABPIDProgram IDStringGeneric Edit100 Allow NULL? 
42ABJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
43ABUPMJDate - UpdatedDateGeneric Edit60
44ABTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
45ABAGNBAgreement Number - SupplierStringGeneric Edit300 Allow NULL? 

TOP920 | 45 | F45715 INDEXES

NumberDescription
1Adj. Name Type AN8 MCU etc (Primary/Unique)
ElementAliasDescriptionSequence
1ASTPrice Adjustment NameAscending
2AGTYAgreementTypeAscending
3ANS8Address NumberAscending
4MCUBusiness UnitAscending
5AN8Address NumberAscending
6ITMItem Number - ShortAscending
7IGIDItem Group Key IDAscending
8CGIDCustomer Group Key IDAscending
2Adj. Name Type
ElementAliasDescriptionSequence
1ASTPrice Adjustment NameAscending
2AGTYAgreementTypeAscending