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

135 COLUMNS | 1 INDEXES | Print definition?812 | 03B | F03B14P TABLE

03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F03B14PRZ1351Receipts Detail Purge FilePurge Files03B: Enhanced Accounts ReceivableAS400 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 RZPYID, RZRC5, RZCKNU, RZDOC, RZDCT, RZKCO, RZSFX, RZAN8, RZDCTM, RZDMTJ, RZDGJ, RZPOST, RZGLC, RZAID, RZCTRY, RZFY, RZPN, RZCO, RZICUT, RZICU, RZDICJ, RZPA8, RZRPID, RZRLIN, RZPAAP, RZADSC, RZADSA, RZAAAJ, RZECBA, RZDDA, RZBCRC, RZCRRM, RZCRCD, RZCRR, RZPFAP, RZCDS, RZCDSA, RZFCHG, RZECBF, RZFDA, RZAGL, RZAIDT, RZTCRC, RZTAAP, RZTADA, RZTAAJ, RZTCBA, RZTDA, RZACRR, RZACR1, RZACR2, RZACRM, RZAGLA, RZAIDA, RZAIDD, RZRSCO, RZAIDW, RZECBR, RZGLCC, RZAIDC, RZDDEX, RZDAID, RZTYIN, RZUTIC, RZUCTF, RZAID2, RZAM2, RZMCU, RZSBL, RZSBLT, RZPKCO, RZPO, RZPDCT, RZNUMB, RZUNIT, RZMCU2, RZRMK, RZFNLP, RZALT6, RZODOC, RZODCT, RZOKCO, RZOSFX, RZGDOC, RZGDCT, RZGKCO, RZGSFX, RZDCTG, RZDOCG, RZKCOG, RZCTL, RZSMTJ, RZVDGJ, RZVRE, RZNFVD, RZHCRR, RZISTC, RZLFCJ, RZPDLT, RZDDJ, RZDDNJ, RZIDGJ, RZDDST, RZVR01, RZRFID, RZRIDC, RZPRGF, RZGFL1, RZRNID, RZTORG, RZUSER, RZPID, RZUPMJ, RZUPMT, RZJOBN, RZURAB, RZURAT, RZURC1, RZURDT, RZURRF, RZSHPN, RZRASI, RZRAMT, RZGFL2, RZOMOD, RZDOCO, RZDCTO, RZKCOO, RZSFXO, RZLRFL, RZDRCO, RZNETTCID, RZNETDOC, RZNETRC5, RZADGJ FROM F03B14P

TOP812 | 03B | F03B14P COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RZPYIDPayment ID (Internal)NumericGeneric Edit150 Allow NULL? 
2RZRC5File Line Identifier 5.0NumericGeneric Edit50 Allow NULL? 
3RZCKNUReceipt NumberStringGeneric Edit250 Allow NULL? 
4RZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
5RZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
6RZKCODocument CompanyStringGeneric Edit50 Allow NULL? 
7RZSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
8RZAN8Address NumberNumericUDC80 Allow NULL? 
9RZDCTMDocument Type - MatchingStringUDC (00 DT)20 Allow NULL? 
10RZDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
11RZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
12RZPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
13RZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
14RZAIDAccount IDStringGeneric Edit80 Allow NULL? 
15RZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
16RZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
17RZPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
18RZCOCompanyStringGeneric Edit50 Allow NULL? 
19RZICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
20RZICUBatch NumberNumericGeneric Edit80 Allow NULL? 
21RZDICJDate - Batch (Julian)DateGeneric Edit60
22RZPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
23RZRPIDRelated Payment IDNumericGeneric Edit150 Allow NULL? 
24RZRLINRelated Payment Line IDNumericGeneric Edit50 Allow NULL? 
25RZPAAPPayment AmountNumericGeneric Edit152 Allow NULL? 
26RZADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
27RZADSADiscount TakenNumericGeneric Edit152 Allow NULL? 
28RZAAAJAmount - Write OffNumericGeneric Edit152 Allow NULL? 
29RZECBAAmount - ChargebackNumericGeneric Edit152 Allow NULL? 
30RZDDAAmount - DeductionNumericGeneric Edit152 Allow NULL? 
31RZBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
32RZCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
33RZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
34RZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
35RZPFAPPayment Amount - ForeignNumericGeneric Edit152 Allow NULL? 
36RZCDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
37RZCDSAAmount - Foreign Discount TakenNumericGeneric Edit152 Allow NULL? 
38RZFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
39RZECBFAmount - Foreign ChargebackNumericGeneric Edit152 Allow NULL? 
40RZFDAAmount - Foreign DeductionNumericGeneric Edit152 Allow NULL? 
41RZAGLAmount Gain/LossNumericGeneric Edit152 Allow NULL? 
42RZAIDTGain/Loss Account IDStringGeneric Edit80 Allow NULL? 
43RZTCRCTransaction Currency CodeStringGeneric Edit30 Allow NULL? 
44RZTAAPTransaction Payment AmountNumericGeneric Edit152 Allow NULL? 
45RZTADATransaction Discount AmountNumericGeneric Edit152 Allow NULL? 
46RZTAAJTransaction Write Off AmountNumericGeneric Edit152 Allow NULL? 
47RZTCBATransaction Charge Back AmountNumericGeneric Edit152 Allow NULL? 
48RZTDATransaction Deduction AmountNumericGeneric Edit152 Allow NULL? 
49RZACRRAlternate Currency Exchange RateNumericGeneric Edit150 Allow NULL? 
50RZACR1Alternate Currency Rate 1NumericGeneric Edit150 Allow NULL? 
51RZACR2Alternate Currency Rate 2NumericGeneric Edit150 Allow NULL? 
52RZACRMAlt Currency Conversion Y/ZCharacterGeneric Edit10 Allow NULL? 
53RZAGLAAlternate Currency Gain/LossNumericGeneric Edit152 Allow NULL? 
54RZAIDAAlt Curr Gain/Loss Account IDStringGeneric Edit80 Allow NULL? 
55RZAIDDDiscount Account IDStringGeneric Edit80 Allow NULL? 
56RZRSCOWrite-Off Reason CodeStringUDC (03B RC)20 Allow NULL? 
57RZAIDWWrite-Off Account IDStringGeneric Edit80 Allow NULL? 
58RZECBRChargeback Reason CodeStringUDC (03B CB)20 Allow NULL? 
59RZGLCCG/L Offset ChargebacksStringGeneric Edit40 Allow NULL? 
60RZAIDCChargeback Account IDStringGeneric Edit80 Allow NULL? 
61RZDDEXDeduction Reason CodeStringUDC (03B CR)20 Allow NULL? 
62RZDAIDDeduction Account IDStringGeneric Edit80 Allow NULL? 
63RZTYINReceipt Type CodeCharacterUDC (03B TI)10 Allow NULL? 
64RZUTICUser Type Input CodeStringUDC (03B RE)20 Allow NULL? 
65RZUCTFUnapplied Cash TransferCharacterGeneric Edit10 Allow NULL? 
66RZAID2Account IDStringGeneric Edit80 Allow NULL? 
67RZAM2Account Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
68RZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
69RZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
70RZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
71RZPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
72RZPOPurchase OrderStringGeneric Edit80 Allow NULL? 
73RZPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
74RZNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
75RZUNITUnitStringGeneric Edit80 Allow NULL? 
76RZMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
77RZRMKName - RemarkStringGeneric Edit300 Allow NULL? 
78RZFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
79RZALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
80RZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
81RZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
82RZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
83RZOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
84RZGDOCDeduction Document NumberNumericGeneric Edit80 Allow NULL? 
85RZGDCTDeduction Document TypeStringUDC (00 DT)20 Allow NULL? 
86RZGKCODeduction Document CompanyStringGeneric Edit50 Allow NULL? 
87RZGSFXDeduction Document Pay ItemStringGeneric Edit30 Allow NULL? 
88RZDCTGDocument Type - JEStringUDC (00 DT)20 Allow NULL? 
89RZDOCGDocument Number - JENumericGeneric Edit80 Allow NULL? 
90RZKCOGDocument Company - JEStringGeneric Edit50 Allow NULL? 
91RZCTLControl/Statement FieldStringGeneric Edit130 Allow NULL? 
92RZSMTJDate - StatementDateGeneric Edit60
93RZVDGJVoid Date - For G/L - JulianDateGeneric Edit60
94RZVREVoid Reason CodeStringUDC (03B VR)30 Allow NULL? 
95RZNFVDReceipt NSF/Void CodeCharacterGeneric Edit10 Allow NULL? 
96RZHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
97RZISTCA/R Post to Cash ManagementCharacterGeneric Edit10 Allow NULL? 
98RZLFCJDate - Last Fee Calculated (Julian)DateGeneric Edit60
99RZPDLTPartial PaymentCharacterUDC (03B PL)10 Allow NULL? 
100RZDDJDate - Net DueDateGeneric Edit60
101RZDDNJDate - Discount Due - JulianDateGeneric Edit60
102RZIDGJDate - Invoice Journal Date - JulianDateGeneric Edit60
103RZDDSTDraft StatusCharacterUDC (03B DS)10 Allow NULL? 
104RZVR01ReferenceStringGeneric Edit250 Allow NULL? 
105RZRFIDReference ID (Internal)NumericGeneric Edit150 Allow NULL? 
106RZRIDCReference ID CodeCharacterGeneric Edit10 Allow NULL? 
107RZPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
108RZGFL1Generic Flag 1CharacterGeneric Edit10 Allow NULL? 
109RZRNIDBatch Run ID (Internal)NumericGeneric Edit30 Allow NULL? 
110RZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
111RZUSERUser IDStringGeneric Edit100 Allow NULL? 
112RZPIDProgram IDStringGeneric Edit100 Allow NULL? 
113RZUPMJDate - UpdatedDateGeneric Edit60
114RZUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
115RZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
116RZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
117RZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
118RZURC1User Reserved CodeStringGeneric Edit30 Allow NULL? 
119RZURDTUser Reserved DateDateGeneric Edit60
120RZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
121RZSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
122RZRASIRounding Account Short IDStringGeneric Edit80 Allow NULL? 
123RZRAMTRounding AmountNumericGeneric Edit152 Allow NULL? 
124RZGFL2Generic Flag 2CharacterGeneric Edit10 Allow NULL? 
125RZOMODOriginating SystemCharacterUDC (03B OS)10 Allow NULL? 
126RZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
127RZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
128RZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
129RZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
130RZLRFLLocalization Reserved FlagCharacterGeneric Edit10 Allow NULL? 
131RZDRCODiscount Reason CodeStringUDC (00 DE)30 Allow NULL? 
132RZNETTCIDNetting Transaction IDNumericGeneric Edit150 Allow NULL? 
133RZNETDOCNetting Document NumberNumericGeneric Edit150 Allow NULL? 
134RZNETRC5Netting Line IDNumericGeneric Edit60 Allow NULL? 
135RZADGJActual Receipt DateDateGeneric Edit60

TOP812 | 03B | F03B14P INDEXES

NumberDescription
1Payment ID File ID (Primary/Unique)
ElementAliasDescriptionSequence
1PYIDPayment ID (Internal)Ascending
2RC5File Line Identifier 5.0Ascending