JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

157 COLUMNS | 24 INDEXES | Print definition?910 | 03B | F03B11 TABLE

03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F03B11RP15724Customer LedgerTransaction Files03B: Enhanced Accounts ReceivableBusiness 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 RPDOC, RPDCT, RPKCO, RPSFX, RPAN8, RPDGJ, RPDIVJ, RPICUT, RPICU, RPDICJ, RPFY, RPCTRY, RPPN, RPCO, RPGLC, RPAID, RPPA8, RPAN8J, RPPYR, RPPOST, RPISTR, RPBALJ, RPPST, RPAG, RPAAP, RPADSC, RPADSA, RPATXA, RPATXN, RPSTAM, RPBCRC, RPCRRM, RPCRCD, RPCRR, RPDMCD, RPACR, RPFAP, RPCDS, RPCDSA, RPCTXA, RPCTXN, RPCTAM, RPTXA1, RPEXR1, RPDSVJ, RPGLBA, RPAM, RPAID2, RPAM2, RPMCU, RPOBJ, RPSUB, RPSBLT, RPSBL, RPPTC, RPDDJ, RPDDNJ, RPRDDJ, RPRDSJ, RPLFCJ, RPSMTJ, RPNBRR, RPRDRL, RPRMDS, RPCOLL, RPCORC, RPAFC, RPDNLT, RPRSCO, RPODOC, RPODCT, RPOKCO, RPOSFX, RPVINV, RPPO, RPPDCT, RPPKCO, RPDCTO, RPLNID, RPSDOC, RPSDCT, RPSKCO, RPSFXO, RPVLDT, RPCMC1, RPVR01, RPUNIT, RPMCU2, RPRMK, RPALPH, RPRF, RPDRF, RPCTL, RPFNLP, RPITM, RPU, RPUM, RPALT6, RPRYIN, RPVDGJ, RPVOD, RPRP1, RPRP2, RPRP3, RPAR01, RPAR02, RPAR03, RPAR04, RPAR05, RPAR06, RPAR07, RPAR08, RPAR09, RPAR10, RPISTC, RPPYID, RPURC1, RPURDT, RPURAT, RPURAB, RPURRF, RPRNID, RPPPDI, RPTORG, RPUSER, RPJCL, RPPID, RPUPMJ, RPUPMT, RPDDEX, RPJOBN, RPHCRR, RPHDGJ, RPSHPN, RPDTXS, RPOMOD, RPCLMG, RPCMGR, RPATAD, RPCTAD, RPNRTA, RPFNRT, RPPRGF, RPGFL1, RPGFL2, RPDOCO, RPKCOO, RPSOTF, RPDTPB, RPERDJ, RPPWPG, RPNETTCID, RPNETDOC, RPNETRC5, RPNETST, RPAJCL, RPRMR1 FROM F03B11

TOP910 | 03B | F03B11 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RPDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2RPDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
3RPKCODocument CompanyStringGeneric Edit50 Allow NULL? 
4RPSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
5RPAN8Address NumberNumericUDC80 Allow NULL? 
6RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
7RPDIVJDate - Invoice - JulianDateGeneric Edit60
8RPICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
9RPICUBatch NumberNumericGeneric Edit80 Allow NULL? 
10RPDICJDate - Batch (Julian)DateGeneric Edit60
11RPFYFiscal YearNumericGeneric Edit20 Allow NULL? 
12RPCTRYCenturyNumericGeneric Edit20 Allow NULL? 
13RPPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
14RPCOCompanyStringGeneric Edit50 Allow NULL? 
15RPGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
16RPAIDAccount IDStringGeneric Edit80 Allow NULL? 
17RPPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
18RPAN8JAddress Number - Alternate PayeeNumericGeneric Edit80 Allow NULL? 
19RPPYRPayor Address NumberNumericGeneric Edit80 Allow NULL? 
20RPPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
21RPISTRA/R Post StatusCharacterGeneric Edit10 Allow NULL? 
22RPBALJBalanced - Journal EntriesCharacterUDC (H00 BB)10 Allow NULL? 
23RPPSTPay Status CodeCharacterUDC (00 PS)10 Allow NULL? 
24RPAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
25RPAAPAmount OpenNumericGeneric Edit152 Allow NULL? 
26RPADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
27RPADSADiscount TakenNumericGeneric Edit152 Allow NULL? 
28RPATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
29RPATXNAmount - Non-TaxableNumericGeneric Edit152 Allow NULL? 
30RPSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
31RPBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
32RPCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
33RPCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
34RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
35RPDMCDDomestic Entry w/Mult Currency DistrCharacterGeneric Edit10 Allow NULL? 
36RPACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
37RPFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
38RPCDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
39RPCDSAAmount - Foreign Discount TakenNumericGeneric Edit152 Allow NULL? 
40RPCTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
41RPCTXNAmount - Foreign Non-TaxableNumericGeneric Edit152 Allow NULL? 
42RPCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
43RPTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
44RPEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
45RPDSVJDate - Service/TaxDateGeneric Edit60
46RPGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
47RPAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
48RPAID2Account IDStringGeneric Edit80 Allow NULL? 
49RPAM2Account Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
50RPMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
51RPOBJObject AccountStringGeneric Edit60 Allow NULL? 
52RPSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
53RPSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
54RPSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
55RPPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
56RPDDJDate - Net DueDateGeneric Edit60
57RPDDNJDate - Discount Due - JulianDateGeneric Edit60
58RPRDDJDate of Last Sent ReminderDateGeneric Edit60
59RPRDSJDate - Reminder Stop Until DateDateGeneric Edit60
60RPLFCJDate - Last Fee Calculated (Julian)DateGeneric Edit60
61RPSMTJDate - StatementDateGeneric Edit60
62RPNBRRReminders - Number of Reminders to SendCharacterUDC (H00 NB)10 Allow NULL? 
63RPRDRLLevel of Last Sent ReminderCharacterUDC10 Allow NULL? 
64RPRMDSNumber of Sent Reminders - TotalNumericGeneric Edit30 Allow NULL? 
65RPCOLLCollection Report (Y/N)CharacterUDC (H00 CO)10 Allow NULL? 
66RPCORCCollection Reason CodeStringUDC (03B CL)20 Allow NULL? 
67RPAFCApply Finance Charges - Y/NCharacterUDC (H00 AF)10 Allow NULL? 
68RPDNLTDelinquency Notice (Y/N)CharacterGeneric Edit10 Allow NULL? 
69RPRSCOWrite-Off Reason CodeStringUDC (03B RC)20 Allow NULL? 
70RPODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
71RPODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
72RPOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
73RPOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
74RPVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
75RPPOPurchase OrderStringGeneric Edit80 Allow NULL? 
76RPPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
77RPPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
78RPDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
79RPLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
80RPSDOCSales Document NumberNumericGeneric Edit80 Allow NULL? 
81RPSDCTSales Document TypeStringUDC (00 DT)20 Allow NULL? 
82RPSKCODocument Company (Sales Order)StringGeneric Edit50 Allow NULL? 
83RPSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
84RPVLDTDate - Cleared/ValueDateGeneric Edit60
85RPCMC1Commission Code 1NumericGeneric Edit80 Allow NULL? 
86RPVR01ReferenceStringGeneric Edit250 Allow NULL? 
87RPUNITUnitStringGeneric Edit80 Allow NULL? 
88RPMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
89RPRMKName - RemarkStringGeneric Edit300 Allow NULL? 
90RPALPHName - AlphaStringGeneric Edit400 Allow NULL? 
91RPRFFrequency - RecurringStringUDC (H00 RF)20 Allow NULL? 
92RPDRFRecurring Frequency # of PaymentsNumericGeneric Edit30 Allow NULL? 
93RPCTLControl/Statement FieldStringGeneric Edit130 Allow NULL? 
94RPFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
95RPITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
96RPUUnitsNumericGeneric Edit152 Allow NULL? 
97RPUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
98RPALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
99RPRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
100RPVDGJVoid Date - For G/L - JulianDateGeneric Edit60
101RPVODVoid FlagCharacterGeneric Edit10 Allow NULL? 
102RPRP1A/R - A/P - Miscellaneous Code 1CharacterGeneric Edit10 Allow NULL? 
103RPRP2A/R - A/P - Miscellaneous Code 2CharacterGeneric Edit10 Allow NULL? 
104RPRP3A/R - A/P - Cash Rcpts/Inv Reg CodeCharacterGeneric Edit10 Allow NULL? 
105RPAR01A/R Reporting Code 1StringUDC (01 01)30 Allow NULL? 
106RPAR02A/R Reporting Code 2StringUDC (01 02)30 Allow NULL? 
107RPAR03A/R Reporting Code 3StringUDC (01 03)30 Allow NULL? 
108RPAR04A/R Reporting Code 4StringUDC (01 04)30 Allow NULL? 
109RPAR05A/R Reporting Code 5StringUDC (01 05)30 Allow NULL? 
110RPAR06A/R Reporting Code 6StringUDC (01 06)30 Allow NULL? 
111RPAR07A/R Reporting Code 7StringUDC (01 07)30 Allow NULL? 
112RPAR08A/R Reporting Code 8StringUDC (01 08)30 Allow NULL? 
113RPAR09A/R Reporting Code 9StringUDC (01 09)30 Allow NULL? 
114RPAR10A/R Reporting Code 10StringUDC (01 10)30 Allow NULL? 
115RPISTCA/R Post to Cash ManagementCharacterGeneric Edit10 Allow NULL? 
116RPPYIDPayment ID (Internal)NumericGeneric Edit150 Allow NULL? 
117RPURC1User Reserved CodeStringGeneric Edit30 Allow NULL? 
118RPURDTUser Reserved DateDateGeneric Edit60
119RPURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
120RPURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
121RPURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
122RPRNIDBatch Run ID (Internal)NumericGeneric Edit30 Allow NULL? 
123RPPPDIDate - Invoice PrintedDateGeneric Edit60
124RPTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
125RPUSERUser IDStringGeneric Edit100 Allow NULL? 
126RPJCLDate Invoice ClosedDateGeneric Edit60
127RPPIDProgram IDStringGeneric Edit100 Allow NULL? 
128RPUPMJDate - UpdatedDateGeneric Edit60
129RPUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
130RPDDEXDeduction Reason CodeStringUDC (03B CR)20 Allow NULL? 
131RPJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
132RPHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
133RPHDGJHistorical Date - JulianDateGeneric Edit60
134RPSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
135RPDTXSDeferred Tax Status - VATCharacterGeneric Edit10 Allow NULL? 
136RPOMODOriginating SystemCharacterUDC (03B OS)10 Allow NULL? 
137RPCLMGCollection ManagerStringGeneric Edit (01 CM)100 Allow NULL? 
138RPCMGRCredit ManagerStringUDC (01 CR)100 Allow NULL? 
139RPATADAmount - To DistributeNumericGeneric Edit152 Allow NULL? 
140RPCTADAmount - Currency To DistributeNumericGeneric Edit152 Allow NULL? 
141RPNRTANon-Recoverable Tax AmountNumericGeneric Edit152 Allow NULL? 
142RPFNRTForeign Non-Recoverable TaxNumericGeneric Edit152 Allow NULL? 
143RPPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
144RPGFL1Generic Flag 1CharacterGeneric Edit10 Allow NULL? 
145RPGFL2Generic Flag 2CharacterGeneric Edit10 Allow NULL? 
146RPDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
147RPKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
148RPSOTFSales Order Tax FlagCharacterGeneric Edit10 Allow NULL? 
149RPDTPBNotification Payment DateDateGeneric Edit60
150RPERDJDate - For Exchange Rate - JulianDateGeneric Edit60
151RPPWPGPay When Paid Group NumberNumericGeneric Edit150 Allow NULL? 
152RPNETTCIDNetting Transaction IDNumericGeneric Edit150 Allow NULL? 
153RPNETDOCNetting Document NumberNumericGeneric Edit150 Allow NULL? 
154RPNETRC5Netting Line IDNumericGeneric Edit60 Allow NULL? 
155RPNETSTNetting Status CodeCharacterUDC (00 NS)10 Allow NULL? 
156RPAJCLActual Date Invoice ClosedDateGeneric Edit60
157RPRMR1Generic AR Receipt Matching Reference1StringGeneric Edit500 Allow NULL? 

TOP910 | 03B | F03B11 INDEXES

NumberDescription
1Doc Number Doc Type +A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4SFXDocument Pay ItemAscending
3Address Number Due Date +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DDJDate - Net DueAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4DCTDocument TypeAscending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
4Batch Type Number +A
ElementAliasDescriptionSequence
1ICUTBatch TypeAscending
2ICUBatch NumberAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4DCTDocument TypeAscending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
7COCompanyAscending
8GLCG/L OffsetAscending
5Batch Type Number +B
ElementAliasDescriptionSequence
1ICUTBatch TypeAscending
2ICUBatch NumberAscending
3COCompanyAscending
4GLCG/L OffsetAscending
5PNPeriod Number - General LedgerAscending
6FYFiscal YearAscending
7CTRYCenturyAscending
6Batch Type Number Post
ElementAliasDescriptionSequence
1ICUTBatch TypeAscending
2ICUBatch NumberAscending
3POSTG/L Posted CodeAscending
7Address Number Company
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2KCODocument CompanyAscending
9PaymentID DocType Doc KCO SFX
ElementAliasDescriptionSequence
1PYIDPayment ID (Internal)Ascending
2DCTDocument TypeAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4KCODocument CompanyAscending
5SFXDocument Pay ItemAscending
10StamentNo AddressNumber
ElementAliasDescriptionSequence
1CTLControl/Statement FieldAscending
2AN8Address NumberAscending
11Payor Number Due Date +
ElementAliasDescriptionSequence
1PYRPayor Address NumberAscending
2DDJDate - Net DueAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4DCTDocument TypeAscending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
12Doc Number Doc Type +B
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4SFXDocument Pay ItemDescending
13Document Type Doc Number +
ElementAliasDescriptionSequence
1DCTDocument TypeAscending
2DOCDocument (Voucher Invoice etc.)Ascending
3KCODocument CompanyAscending
4SFXDocument Pay ItemAscending
14Company PayorAddressNumber +
ElementAliasDescriptionSequence
1COCompanyAscending
2PYRPayor Address NumberAscending
3AN8Address NumberAscending
4CRCDCurrency Code - FromAscending
5DGJDate - For G/L (and Voucher) - JulianAscending
6DOCDocument (Voucher Invoice etc.)Ascending
7DCTDocument TypeAscending
8KCODocument CompanyAscending
15PurchaseOrder GLClass +
ElementAliasDescriptionSequence
1POPurchase OrderAscending
2GLCG/L OffsetAscending
3DGJDate - For G/L (and Voucher) - JulianAscending
16PurchaseOrder InvoiceDate
ElementAliasDescriptionSequence
1POPurchase OrderAscending
2DIVJDate - Invoice - JulianAscending
17AddressNumber DocumentType +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DCTDocument TypeAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4KCODocument CompanyAscending
5SFXDocument Pay ItemAscending
18AddressNumber GLDate +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DGJDate - For G/L (and Voucher) - JulianAscending
3DCTDocument TypeAscending
4DOCDocument (Voucher Invoice etc.)Ascending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
19AddressNumber LineNumber +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2LNIDLine NumberAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4DDJDate - Net DueAscending
5POPurchase OrderAscending
20DocNumber DocType DocCompany
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
21AddressNum(AN8) Company(CO)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2COCompanyAscending
22PuchaseOrder PO Type +
ElementAliasDescriptionSequence
1POPurchase OrderAscending
2PDCTDocument Type - Purchase OrderAscending
3PKCODocument Company (Purchase Order)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
23AddressNumber Company +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2COCompanyAscending
3DGJDate - For G/L (and Voucher) - JulianAscending
4VDGJVoid Date - For G/L - JulianAscending
24PayWhenPaidGroupNumber +
ElementAliasDescriptionSequence
1PWPGPay When Paid Group NumberAscending
2AN8Address NumberAscending
3COCompanyAscending
25NetTransID NetDocNum +A
ElementAliasDescriptionSequence
1NETTCIDNetting Transaction IDAscending
2NETDOCNetting Document NumberAscending
3NETRC5Netting Line IDAscending
26NetTransID NetDocNum +B
ElementAliasDescriptionSequence
1NETTCIDNetting Transaction IDAscending
2NETDOCNetting Document NumberAscending
3NETRC5Netting Line IDAscending
4VODVoid FlagAscending