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 | 17 INDEXES | Print definition?920 | 03B | F03B14 TABLE

03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F03B14RZ13517Receipts DetailTransaction 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 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, RZOMOD, RZDOCO, RZRASI, RZSFXO, RZKCOO, RZDCTO, RZRAMT, RZLRFL, RZGFL2, RZDRCO, RZNETTCID, RZNETDOC, RZNETRC5, RZADGJ FROM F03B14

TOP920 | 03B | F03B14 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 NumberNumericGeneric Edit80 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? 
122RZOMODOriginating SystemCharacterUDC (03B OS)10 Allow NULL? 
123RZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
124RZRASIRounding Account Short IDStringGeneric Edit80 Allow NULL? 
125RZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
126RZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
127RZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
128RZRAMTRounding AmountNumericGeneric Edit152 Allow NULL? 
129RZLRFLLocalization Reserved FlagCharacterGeneric Edit10 Allow NULL? 
130RZGFL2Generic Flag 2CharacterGeneric 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

TOP920 | 03B | F03B14 INDEXES

NumberDescription
1Payment ID File Line ID (Primary/Unique)
ElementAliasDescriptionSequence
1PYIDPayment ID (Internal)Ascending
2RC5File Line Identifier 5.0Ascending
2Payment ID Post
ElementAliasDescriptionSequence
1PYIDPayment ID (Internal)Ascending
2POSTG/L Posted CodeAscending
3Doc Dct Kco Sfx Pyid Rc5
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4SFXDocument Pay ItemAscending
5PYIDPayment ID (Internal)Ascending
6RC5File Line Identifier 5.0Ascending
4ICU ICUT POST RPID RLIN
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2ICUTBatch TypeAscending
3POSTG/L Posted CodeAscending
4RPIDRelated Payment IDAscending
5RLINRelated Payment Line IDAscending
5Address Company
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2COCompanyAscending
6Doc Dct Kco Sfx Tcrc +A
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4SFXDocument Pay ItemAscending
5TCRCTransaction Currency CodeAscending
6PYIDPayment ID (Internal)Ascending
7RC5File Line Identifier 5.0Ascending
7Payment ID File Line ID Desc
ElementAliasDescriptionSequence
1PYIDPayment ID (Internal)Ascending
2RC5File Line Identifier 5.0Descending
8Purchase Order G/L Offset +
ElementAliasDescriptionSequence
1POPurchase OrderAscending
2GLCG/L OffsetAscending
3DGJDate - For G/L (and Voucher) - JulianAscending
9Address Number Receipt +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2CKNUReceipt NumberAscending
3DCTDocument TypeAscending
4DOCDocument (Voucher Invoice etc.)Ascending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
10Address Number G/L Date +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DGJDate - For G/L (and Voucher) - JulianAscending
3DCTDocument TypeAscending
4DOCDocument (Voucher Invoice etc.)Ascending
5KCODocument CompanyAscending
6SFXDocument Pay ItemAscending
11G/L Date Company
ElementAliasDescriptionSequence
1DGJDate - For G/L (and Voucher) - JulianAscending
2COCompanyAscending
12AddressNumber Company +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2COCompanyAscending
3DGJDate - For G/L (and Voucher) - JulianAscending
4DICJDate - Batch (Julian)Ascending
5RC5File Line Identifier 5.0Ascending
13CTL CRCD PYID
ElementAliasDescriptionSequence
1CTLControl/Statement FieldAscending
2CRCDCurrency Code - FromAscending
3PYIDPayment ID (Internal)Ascending
14NetTransID NetDocNum +A
ElementAliasDescriptionSequence
1NETTCIDNetting Transaction IDAscending
2NETDOCNetting Document NumberAscending
3NETRC5Netting Line IDAscending
15NetTransID NetDocNum +B
ElementAliasDescriptionSequence
1NETTCIDNetting Transaction IDAscending
2NETDOCNetting Document NumberAscending
3NETRC5Netting Line IDAscending
4VREVoid Reason CodeAscending
16GDOC GDCT GKCO GSFX
ElementAliasDescriptionSequence
1GDOCDeduction Document NumberAscending
2GDCTDeduction Document TypeAscending
3GKCODeduction Document CompanyAscending
4GSFXDeduction Document Pay ItemAscending
17DOCG ICUT ICU
ElementAliasDescriptionSequence
1DOCGDocument Number - JEAscending
2ICUTBatch TypeAscending
3ICUBatch NumberAscending
4SFXDocument Pay ItemAscending
5RC5File Line Identifier 5.0Ascending
6VDGJVoid Date - For G/L - JulianAscending