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

142 COLUMNS | 15 INDEXES | Print definition?812 | 04 | F0411 TABLE

04: Accounts Payable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0411RP14215Accounts Payable LedgerTransaction Files04: Accounts PayableAS400 Coexistence Tables
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 RPKCO, RPDOC, RPDCT, RPSFX, RPSFXE, RPDCTA, RPAN8, RPPYE, RPSNTO, RPDIVJ, RPDSVJ, RPDDJ, RPDDNJ, RPDGJ, RPFY, RPCTRY, RPPN, RPCO, RPICU, RPICUT, RPDICJ, RPBALJ, RPPST, RPAG, RPAAP, RPADSC, RPADSA, RPATXA, RPATXN, RPSTAM, RPTXA1, RPEXR1, RPCRRM, RPCRCD, RPCRR, RPACR, RPFAP, RPCDS, RPCDSA, RPCTXA, RPCTXN, RPCTAM, RPGLC, RPGLBA, RPPOST, RPAM, RPAID2, RPMCU, RPOBJ, RPSUB, RPSBLT, RPSBL, RPBAID, RPPTC, RPVOD, RPOKCO, RPODCT, RPODOC, RPOSFX, RPCRC, RPVINV, RPPKCO, RPPO, RPPDCT, RPLNID, RPSFXO, RPOPSQ, RPVR01, RPUNIT, RPMCU2, RPRMK, RPRF, RPDRF, RPCTL, RPFNLP, RPU, RPUM, RPPYIN, RPTXA3, RPEXR3, RPRP1, RPRP2, RPRP3, RPAC07, RPTNN, RPDMCD, RPITM, RPHCRR, RPHDGJ, RPURC1, RPURDT, RPURAT, RPURAB, RPURRF, RPTORG, RPUSER, RPPID, RPUPMJ, RPUPMT, RPJOBN, RPTNST, RPYC01, RPYC02, RPYC03, RPYC04, RPYC05, RPYC06, RPYC07, RPYC08, RPYC09, RPYC10, RPDTXS, RPBCRC, RPATAD, RPCTAD, RPNRTA, RPFNRT, RPTAXP, RPPRGF, RPGFL5, RPGFL6, RPGAM1, RPGAM2, RPGEN4, RPGEN5, RPWTAD, RPWTAF, RPSMMF, RPPYWP, RPPWPG, RPNETTCID, RPNETDOC, RPNETRC5, RPNETST, RPCNTRTID, RPCNTRTCD, RPWVID, RPBLSCD2, RPHARPER, RPHARSFX, RPDDRL, RPSEQN FROM F0411

TOP812 | 04 | F0411 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RPKCODocument CompanyStringGeneric Edit50 Allow NULL? 
2RPDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3RPDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
4RPSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
5RPSFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
6RPDCTADocument Type - AdjustingStringUDC (00 DT)20 Allow NULL? 
7RPAN8Address NumberNumericUDC80 Allow NULL? 
8RPPYEPayee Address NumberNumericGeneric Edit80 Allow NULL? 
9RPSNTOAddress Number - ApproverNumericGeneric Edit80 Allow NULL? 
10RPDIVJDate - Invoice - JulianDateGeneric Edit60
11RPDSVJDate - Service/TaxDateGeneric Edit60
12RPDDJDate - Net DueDateGeneric Edit60
13RPDDNJDate - Discount Due - JulianDateGeneric Edit60
14RPDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
15RPFYFiscal YearNumericGeneric Edit20 Allow NULL? 
16RPCTRYCenturyNumericGeneric Edit20 Allow NULL? 
17RPPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
18RPCOCompanyStringGeneric Edit50 Allow NULL? 
19RPICUBatch NumberNumericGeneric Edit80 Allow NULL? 
20RPICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
21RPDICJDate - Batch (Julian)DateGeneric Edit60
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? 
31RPTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
32RPEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
33RPCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
34RPCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
35RPCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 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? 
43RPGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
44RPGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
45RPPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
46RPAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
47RPAID2Account IDStringGeneric Edit80 Allow NULL? 
48RPMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
49RPOBJObject AccountStringGeneric Edit60 Allow NULL? 
50RPSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
51RPSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
52RPSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
53RPBAIDBank Transit Short IDStringGeneric Edit80 Allow NULL? 
54RPPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
55RPVODVoid FlagCharacterGeneric Edit10 Allow NULL? 
56RPOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
57RPODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
58RPODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
59RPOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
60RPCRCPayment Handling CodeStringUDC (00 HC)30 Allow NULL? 
61RPVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
62RPPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
63RPPOPurchase OrderStringGeneric Edit80 Allow NULL? 
64RPPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
65RPLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
66RPSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
67RPOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
68RPVR01ReferenceStringGeneric Edit250 Allow NULL? 
69RPUNITUnitStringGeneric Edit80 Allow NULL? 
70RPMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
71RPRMKName - RemarkStringGeneric Edit300 Allow NULL? 
72RPRFFrequency - RecurringStringUDC (H00 RF)20 Allow NULL? 
73RPDRFRecurring Frequency # of PaymentsNumericGeneric Edit30 Allow NULL? 
74RPCTLControl/Statement FieldStringGeneric Edit130 Allow NULL? 
75RPFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
76RPUUnitsNumericGeneric Edit152 Allow NULL? 
77RPUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
78RPPYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
79RPTXA3Tax Rate/Area 3 - WithholdingStringGeneric Edit100 Allow NULL? 
80RPEXR3Tax Expl Code 3 - WithholdingStringUDC (00 EX)20 Allow NULL? 
81RPRP1A/R - A/P - Miscellaneous Code 1CharacterGeneric Edit10 Allow NULL? 
82RPRP2A/R - A/P - Miscellaneous Code 2CharacterGeneric Edit10 Allow NULL? 
83RPRP3A/R - A/P - Cash Rcpts/Inv Reg CodeCharacterGeneric Edit10 Allow NULL? 
84RPAC07Category Code - Address Book 07StringUDC (01 07)30 Allow NULL? 
85RPTNNFlag for 1099CharacterGeneric Edit10 Allow NULL? 
86RPDMCDDomestic Entry w/Mult Currency DistrCharacterGeneric Edit10 Allow NULL? 
87RPITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
88RPHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
89RPHDGJHistorical Date - JulianDateGeneric Edit60
90RPURC1User Reserved CodeStringGeneric Edit30 Allow NULL? 
91RPURDTUser Reserved DateDateGeneric Edit60
92RPURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
93RPURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
94RPURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
95RPTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
96RPUSERUser IDStringGeneric Edit100 Allow NULL? 
97RPPIDProgram IDStringGeneric Edit100 Allow NULL? 
98RPUPMJDate - UpdatedDateGeneric Edit60
99RPUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
100RPJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
101RPTNSTTransit Number - BankStringGeneric Edit200 Allow NULL? 
102RPYC01Category Code - A/P Ledger 01StringGeneric Edit30 Allow NULL? 
103RPYC02Category Code - A/P Ledger 02StringGeneric Edit30 Allow NULL? 
104RPYC03Category Code - A/P Ledger 03StringGeneric Edit30 Allow NULL? 
105RPYC04Category Code - A/P Ledger 04StringGeneric Edit30 Allow NULL? 
106RPYC05Category Code - A/P Ledger 05StringGeneric Edit30 Allow NULL? 
107RPYC06Category Code - A/P Ledger 06StringGeneric Edit30 Allow NULL? 
108RPYC07Category Code - A/P Ledger 07StringGeneric Edit30 Allow NULL? 
109RPYC08Category Code - A/P Ledger 08StringGeneric Edit30 Allow NULL? 
110RPYC09Category Code - A/P Ledger 09StringGeneric Edit30 Allow NULL? 
111RPYC10Category Code - A/P Ledger 10StringGeneric Edit30 Allow NULL? 
112RPDTXSDeferred Tax Status - VATCharacterGeneric Edit10 Allow NULL? 
113RPBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
114RPATADAmount - To DistributeNumericGeneric Edit152 Allow NULL? 
115RPCTADAmount - Currency To DistributeNumericGeneric Edit152 Allow NULL? 
116RPNRTANon-Recoverable Tax AmountNumericGeneric Edit152 Allow NULL? 
117RPFNRTForeign Non-Recoverable TaxNumericGeneric Edit152 Allow NULL? 
118RPTAXPPurchasing Taxable Y/NCharacterGeneric Edit10 Allow NULL? 
119RPPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
120RPGFL5Generic Flag 5CharacterGeneric Edit10 Allow NULL? 
121RPGFL6Generic Flag 6CharacterGeneric Edit10 Allow NULL? 
122RPGAM1Generic Amount 1NumericGeneric Edit152 Allow NULL? 
123RPGAM2Generic Amount 2NumericGeneric Edit152 Allow NULL? 
124RPGEN4Generic String 4StringGeneric Edit250 Allow NULL? 
125RPGEN5Generic String 5StringGeneric Edit250 Allow NULL? 
126RPWTADFuture - Withholding Tax Amount DomesticNumericGeneric Edit152 Allow NULL? 
127RPWTAFFuture - Withholding Tax Amount ForeignNumericGeneric Edit152 Allow NULL? 
128RPSMMFSummarized FlagCharacterGeneric Edit10 Allow NULL? 
129RPPYWPPay When PaidCharacterGeneric Edit10 Allow NULL? 
130RPPWPGPay When Paid Group NumberNumericGeneric Edit150 Allow NULL? 
131RPNETTCIDNetting Transaction IDNumericGeneric Edit150 Allow NULL? 
132RPNETDOCNetting Document NumberNumericGeneric Edit150 Allow NULL? 
133RPNETRC5Netting Line IDNumericGeneric Edit60 Allow NULL? 
134RPNETSTNetting Status CodeCharacterUDC (00 NS)10 Allow NULL? 
135RPCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
136RPCNTRTCDContract CodeStringGeneric Edit120 Allow NULL? 
137RPWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
138RPBLSCD2Block CodeStringGeneric Edit100 Allow NULL? 
139RPHARPERHarvest PeriodStringGeneric Edit60 Allow NULL? 
140RPHARSFXHarvest SuffixStringGeneric Edit100 Allow NULL? 
141RPDDRLDue Date RuleStringGeneric Edit50 Allow NULL? 
142RPSEQNSequence NumberNumericGeneric Edit70 Allow NULL? 

TOP812 | 04 | F0411 INDEXES

NumberDescription
1Document Type + A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4SFXDocument Pay ItemAscending
5SFXEPay Item Extension NumberAscending
2Document Type + B
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
3Batch Type Number + A
ElementAliasDescriptionSequence
1ICUTBatch TypeAscending
2ICUBatch NumberAscending
3KCODocument CompanyAscending
4DCTDocument TypeAscending
5DOCDocument (Voucher Invoice etc.)Ascending
6COCompanyAscending
7GLCG/L OffsetAscending
4Batch Type Number + B
ElementAliasDescriptionSequence
1ICUTBatch TypeAscending
2ICUBatch NumberAscending
3COCompanyAscending
4GLCG/L OffsetAscending
5PNPeriod Number - General LedgerAscending
6FYFiscal YearAscending
7CTRYCenturyAscending
5Batch Type Number +C
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2ICUTBatch TypeAscending
3POSTG/L Posted CodeAscending
6Supplier Invoice Number +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2VINVSupplier Invoice NumberAscending
3DIVJDate - Invoice - JulianDescending
7Address Number Due Date +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DDJDate - Net DueAscending
3DCTDocument TypeAscending
4DOCDocument (Voucher Invoice etc.)Ascending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
7SFXEPay Item Extension NumberAscending
8Address Num Doc Type +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DCTDocument TypeAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4KCODocument CompanyAscending
5SFXDocument Pay ItemAscending
6SFXEPay Item Extension NumberAscending
9Address Num PO +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2POPurchase OrderAscending
3PDCTDocument Type - Purchase OrderAscending
4PKCODocument Company (Purchase Order)Ascending
5DOCDocument (Voucher Invoice etc.)Ascending
6DCTDocument TypeAscending
7KCODocument CompanyAscending
10Sent to Suplier +A
ElementAliasDescriptionSequence
1SNTOAddress Number - ApproverAscending
2AN8Address NumberAscending
3DDJDate - Net DueDescending
11PayeeNumber Doc Type +A
ElementAliasDescriptionSequence
1PYEPayee Address NumberAscending
2DCTDocument TypeAscending
3DOCDocument (Voucher Invoice etc.)Ascending
4KCODocument CompanyAscending
5SFXDocument Pay ItemAscending
6SFXEPay Item Extension NumberAscending
12PWP No Address Num +A
ElementAliasDescriptionSequence
1PWPGPay When Paid Group NumberAscending
2AN8Address NumberAscending
3PSTPay Status CodeAscending
13NetTId NetDoc +A
ElementAliasDescriptionSequence
1NETTCIDNetting Transaction IDAscending
2NETDOCNetting Document NumberAscending
3NETRC5Netting Line IDAscending
14NetTId NetDoc +B
ElementAliasDescriptionSequence
1NETTCIDNetting Transaction IDAscending
2NETDOCNetting Document NumberAscending
3NETRC5Netting Line IDAscending
4VODVoid FlagAscending
15Contract Harvest +A
ElementAliasDescriptionSequence
1CNTRTIDContract IDAscending
2WVIDVessel IDAscending
3PYEPayee Address NumberAscending
4SEQNSequence NumberAscending
5RP1A/R - A/P - Miscellaneous Code 1Ascending