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

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

163 COLUMNS | 12 INDEXES | Print definition?920 | 43 | F43121 TABLE

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F43121PR16312Purchase Order Receiver FileTransaction Files43A: Purchase Order Receipt/RoutingBusiness 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 PRMATC, PRAN8, PRKCOO, PRDOCO, PRDCTO, PRSFXO, PRLNID, PRNLIN, PRALIN, PRRTBY, PRDMCT, PRDMCS, PRBALU, PRITM, PRLITM, PRAITM, PRIMCU, PRLOCN, PRLOTN, PRLOTG, PRLOTP, PRVRMK, PRCNID, PRNXTR, PRLTTR, PRTRDJ, PRRCDJ, PRDRQJ, PRPDDJ, PROPDJ, PRRCD, PRVINV, PRPTC, PRPST, PRLAND, PRPRP5, PRLVLA, PRILOG, PRDLOG, PRRTGC, PRRCPF, PRAVCH, PRLNTY, PRGLC, PRMCU, PRCO, PRAID, PRANI, PROMCU, PROBJ, PRSUB, PRASID, PRSBL, PRSBLT, PRKCO, PRDOC, PRDCT, PRSFX, PRDGL, PRJELN, PRVANI, PRTX, PREXR1, PRTXA1, PRUOM, PRUORG, PRUPTD, PRUOPN, PRUREC, PRUCLO, PRQTYS, PRQTYR, PRQTYW, PRQTYC, PRQTYJ, PRQTYA, PRUOM3, PRPRRC, PRECST, PRAPTD, PRAOPN, PRAREC, PRACLO, PRAVCO, PRVARC, PRCRCD, PRCRR, PRFRRC, PRFEC, PRFAP, PRFAPT, PRFREC, PRFCLO, PRURCD, PRURDT, PRURAT, PRURAB, PRURRF, PRTORG, PRUSER, PRPID, PRJOBN, PRTERM, PRUPMJ, PRTDAY, PRBCRC, PRSTAM, PRCTAM, PRMACT, PRPLT, PRPAK, PRSCCN, PRSCCQ, PRSCUM, PRUPCN, PRUPQT, PRUPUM, PRSHPN, PRVR01, PRVR02, PRFUF3, PRFUF4, PRFUF5, PRFUF6, PRMERL, PRKTLN, PRCPNT, PRVR04, PRVR05, PRUKID, PRUOM2, PRDUAL, PRSQOR, PRXDCK, PRPOE, PRVR03, PRLDNM, PRCTSN, PRPROV, PRASN, PRPRFLG1, PRPRFLG2, PRMOADJ, PRPS09, PRQTYPY, PRWVID, PRCNTRTID, PRCNTRTDID, PRREVFLG, PRAPPFLG, PRREVAN8, PRAPPAN8, PRWOPID, PRWVTY, PRJBCD, PRSRQTY, PRSRUOM, PRNBRU, PRNEWR, PRSRRC, PRFSRRC, PRPMPN, PRPNS FROM F43121

TOP920 | 43 | F43121 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PRMATCType - Match Record TypeCharacterGeneric Edit10 Allow NULL? 
2PRAN8Address NumberNumericGeneric Edit80 Allow NULL? 
3PRKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4PRDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
5PRDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
6PRSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
7PRLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
8PRNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
9PRALINLine - AssociatedNumericGeneric Edit50 Allow NULL? 
10PRRTBYWritten By ProgramStringGeneric Edit20 Allow NULL? 
11PRDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
12PRDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
13PRBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
14PRITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
15PRLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
16PRAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
17PRIMCUItem Business UnitStringGeneric Edit120 Allow NULL? 
18PRLOCNLocationStringGeneric Edit200 Allow NULL? 
19PRLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
20PRLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
21PRLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
22PRVRMKSupplier RemarkStringGeneric Edit300 Allow NULL? 
23PRCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
24PRNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
25PRLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
26PRTRDJDate - Order/TransactionDateGeneric Edit60
27PRRCDJDate - ReceivedDateGeneric Edit60
28PRDRQJDate - RequestedDateGeneric Edit60
29PRPDDJDate - Scheduled PickDateGeneric Edit60
30PROPDJDate - Original Promised DeliveryDateGeneric Edit60
31PRRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
32PRVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
33PRPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
34PRPSTPay Status CodeCharacterUDC (00 PS)10 Allow NULL? 
35PRLANDCode - Landed CostCharacterGeneric Edit10 Allow NULL? 
36PRPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
37PRLVLALevel CostStringUDC (40 CA)30 Allow NULL? 
38PRILOGCode - Invoice LoggingCharacterGeneric Edit10 Allow NULL? 
39PRDLOGFinal Receipt Flag (Y or BLANK)CharacterGeneric Edit10 Allow NULL? 
40PRRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
41PRRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
42PRAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
43PRLNTYLine TypeStringGeneric Edit20 Allow NULL? 
44PRGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
45PRMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
46PRCOCompanyStringGeneric Edit50 Allow NULL? 
47PRAIDAccount IDStringGeneric Edit80 Allow NULL? 
48PRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
49PROMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
50PROBJObject AccountStringGeneric Edit60 Allow NULL? 
51PRSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
52PRASIDSerial NumberStringGeneric Edit250 Allow NULL? 
53PRSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
54PRSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
55PRKCODocument CompanyStringGeneric Edit50 Allow NULL? 
56PRDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
57PRDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
58PRSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
59PRDGLDate - For G/L (and Voucher)DateGeneric Edit60
60PRJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
61PRVANIAccount Number - Received Not VoucheredStringGeneric Edit290 Allow NULL? 
62PRTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
63PREXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
64PRTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
65PRUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
66PRUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
67PRUPTDUnits - Paid to DateNumericGeneric Edit150 Allow NULL? 
68PRUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
69PRURECUnits - ReceivedNumericGeneric Edit150 Allow NULL? 
70PRUCLOUnits - ClosedNumericGeneric Edit150 Allow NULL? 
71PRQTYSUnits - StockedNumericGeneric Edit150 Allow NULL? 
72PRQTYRUnits - ReturnedNumericGeneric Edit150 Allow NULL? 
73PRQTYWUnits - ReworkedNumericGeneric Edit150 Allow NULL? 
74PRQTYCUnits - ScrappedNumericGeneric Edit150 Allow NULL? 
75PRQTYJUnits - RejectedNumericGeneric Edit150 Allow NULL? 
76PRQTYAUnits - AdjustedNumericGeneric Edit150 Allow NULL? 
77PRUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
78PRPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
79PRECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
80PRAPTDAmount - Paid to DateNumericGeneric Edit152 Allow NULL? 
81PRAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
82PRARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
83PRACLOAmount - ClosedNumericGeneric Edit152 Allow NULL? 
84PRAVCOAmount - Average Cost DifferenceNumericGeneric Edit152 Allow NULL? 
85PRVARCAmount - Cost VarianceNumericGeneric Edit152 Allow NULL? 
86PRCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
87PRCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
88PRFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
89PRFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
90PRFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
91PRFAPTAmount - Foreign Amount Paid to DateNumericGeneric Edit152 Allow NULL? 
92PRFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
93PRFCLOAmount - Foreign ClosedNumericGeneric Edit152 Allow NULL? 
94PRURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
95PRURDTUser Reserved DateDateGeneric Edit60
96PRURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
97PRURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
98PRURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
99PRTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
100PRUSERUser IDStringGeneric Edit100 Allow NULL? 
101PRPIDProgram IDStringGeneric Edit100 Allow NULL? 
102PRJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
103PRTERMterminal identificationStringGeneric Edit100 Allow NULL? 
104PRUPMJDate - UpdatedDateGeneric Edit60
105PRTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
106PRBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
107PRSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
108PRCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
109PRMACTMultiple AccountsCharacterUDC (40 MU)10 Allow NULL? 
110PRPLTSSCC Number - Tare LevelStringGeneric Edit180 Allow NULL? 
111PRPAKSSCC Number - Pack LevelStringGeneric Edit180 Allow NULL? 
112PRSCCNSCC NumberStringGeneric Edit140 Allow NULL? 
113PRSCCQSCC QuantityNumericGeneric Edit150 Allow NULL? 
114PRSCUMSCC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
115PRUPCNUPC NumberStringGeneric Edit130 Allow NULL? 
116PRUPQTUPC QuantityNumericGeneric Edit150 Allow NULL? 
117PRUPUMUPC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
118PRSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
119PRVR01ReferenceStringGeneric Edit250 Allow NULL? 
120PRVR02Reference 2StringGeneric Edit250 Allow NULL? 
121PRFUF3Future UseStringGeneric Edit10 Allow NULL? 
122PRFUF4Future UseStringGeneric Edit10 Allow NULL? 
123PRFUF5Future UseStringGeneric Edit10 Allow NULL? 
124PRFUF6Future UseStringGeneric Edit10 Allow NULL? 
125PRMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
126PRKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
127PRCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
128PRVR04Outside Reference 1StringGeneric Edit250 Allow NULL? 
129PRVR05Outside Reference 2StringGeneric Edit250 Allow NULL? 
130PRUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
131PRUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
132PRDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
133PRSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
134PRXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
135PRPOEPort of Entry or ExitStringUDC (40 PE)60 Allow NULL? 
136PRVR03ReferenceStringGeneric Edit250 Allow NULL? 
137PRLDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
138PRCTSNContainer Serial NumberStringGeneric Edit400 Allow NULL? 
139PRPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
140PRASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
141PRPRFLG1Pricing Control 01CharacterUDC (45 PC)10 Allow NULL? 
142PRPRFLG2Pricing Control 02CharacterUDC (45 PF)10 Allow NULL? 
143PRMOADJManual Override Adjustment FlagCharacterCheck Box10 Allow NULL? 
144PRPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
145PRQTYPYQuantity To PayNumericGeneric Edit150 Allow NULL? 
146PRWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
147PRCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
148PRCNTRTDIDContract Detail IDNumericGeneric Edit150 Allow NULL? 
149PRREVFLGReviewed FlagCharacterGeneric Edit10 Allow NULL? 
150PRAPPFLGApproved FlagCharacterGeneric Edit10 Allow NULL? 
151PRREVAN8Reviewed By Address NumberNumericGeneric Edit80 Allow NULL? 
152PRAPPAN8Approved By Address NumberNumericGeneric Edit80 Allow NULL? 
153PRWOPIDOperation IDIntegerGeneric Edit110 Allow NULL? 
154PRWVTYVessel ClassCharacterGeneric Edit10 Allow NULL? 
155PRJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
156PRSRQTYService QuantityNumericGeneric Edit154 Allow NULL? 
157PRSRUOMService Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
158PRNBRUNon-Billable Retainage UsedCharacterGeneric Edit10 Allow NULL? 
159PRNEWRExpense At VoucherCharacterGeneric Edit10 Allow NULL? 
160PRSRRCAmount - Secondary Unit CostNumericGeneric Edit154 Allow NULL? 
161PRFSRRCAmount - Foreign Secondary Unit CostNumericGeneric Edit154 Allow NULL? 
162PRPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
163PRPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP920 | 43 | F43121 INDEXES

NumberDescription
1Order Number Order Type + (Primary/Unique)
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
7NLINNumber of LinesAscending
8DOCDocument (Voucher Invoice etc.)Ascending
2Document OrderType +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
3Receipt Doc Receipt Typ +
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4MatchType ShortItem +
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2ITMItem Number - ShortAscending
3MCUBusiness UnitAscending
4PDDJDate - Scheduled PickAscending
5MatchType Address +
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2AN8Address NumberAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6SFXOOrder SuffixAscending
7MCUBusiness UnitAscending
8LNIDLine NumberAscending
9NLINNumber of LinesAscending
6MatchType Order +
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6MCUBusiness UnitAscending
7LNIDLine NumberAscending
8NLINNumber of LinesAscending
9DOCDocument (Voucher Invoice etc.)Ascending
7MatchType Order Number +
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
6LNIDLine NumberAscending
8Invoice No Receipt Type +
ElementAliasDescriptionSequence
1VINVSupplier Invoice NumberAscending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
9SHPN MATC DOCO DCTO KCOO SFXO+
ElementAliasDescriptionSequence
1SHPNShipment NumberAscending
2MATCType - Match Record TypeAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6SFXOOrder SuffixAscending
7LNIDLine NumberAscending
8NLINNumber of LinesAscending
9DOCDocument (Voucher Invoice etc.)Ascending
10MatchType RecDoc RecDocType +
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCDocument (Voucher Invoice etc.)Ascending
3DCTDocument TypeAscending
4KCODocument CompanyAscending
11OperationID VesselClass
ElementAliasDescriptionSequence
1WOPIDOperation IDAscending
2WVTYVessel ClassAscending
12Order Number No NLIN
ElementAliasDescriptionSequence
1MATCType - Match Record TypeAscending
2DOCDocument (Voucher Invoice etc.)Ascending
3KCODocument CompanyAscending
4DCTDocument TypeAscending
5SFXDocument Pay ItemAscending