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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

197 COLUMNS | 3 INDEXES | Print definition?812 | 43 | F43121Z TABLE

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F43121ZPW1973Receiver workfileRegular Work Files43A: Purchase Order Receipt/RoutingNo
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 PWDOC, PWDOCO, PWDCTO, PWKCOO, PWSFXO, PWLNID, PWNLIN, PWJOBS, PWCTID, PWSELC, PWKCO, PWJELN, PWJEL1, PWJEL2, PWJEL3, PWJEL4, PWJEL5, PWJEL6, PWJEL7, PWJEL8, PWJEL9, PWMCU, PWLOCN, PWLOTN, PWLOTG, PWLOTP, PWLOTS, PWIVI, PWSTKT, PWLEDG, PWCLEV, PWGLC, PWRCDJ, PWDGL, PWRCD, PWSRNR, PWVEND, PWAN8, PWVRMK, PWVANI, PWPRP5, PWASID, PWCNID, PWSBL, PWSBLT, PWULOT, PWAVGC, PWSOQS, PWUOM2, PWUOM3, PWSOCN, PWUOM1, PWCNV1, PWOPST, PWRTG, PWUPIB, PWRCPT, PWPMTE, PWCONV, PWCRR, PWUOM, PWUREC, PWPRRC, PWAREC, PWAOPN, PWECST, PWCRYR, PWFRRC, PWFEC, PWFREC, PWITM, PWRPL, PWNROU, PWCRCD, PWCO, PWPTC, PWDRQJ, PWPDDJ, PWOPDJ, PWLNTY, PWAITM, PWLITM, PWCNV2, PWLIN, PWNXTR, PWWRTH, PWNXT2, PWSOPO, PWDSC1, PWLAND, PWALIN, PWCRDC, PWDSCV, PWDMBV, PWDZBA, PWCZBA, PWRCNV, PWDTAC, PWCTAC, PWTRR1, PWTRR2, PWCRCM, PWDMCT, PWDMCS, PWMODE, PWPSR, PWPSRY, PWSEQ, PWTREX, PWTEMP, PWSTPU, PWDNTY, PWDNTP, PWDETP, PWDTPU, PWAMBR, PWBUM3, PWVCF, PWSTOK, PWBUM4, PWWGTR, PWBUM5, PWSTUM, PWBUM6, PWBPFG, PWABR1, PWABT1, PWABR2, PWABT2, PWABR3, PWABT3, PWABR4, PWABT4, PWPSQ, PWSHPN, PWPEID, PWTCID, PWVR05, PWVR04, PWVR02, PWVR01, PWUPUM, PWUPQT, PWUPCN, PWUKID, PWSTAM, PWSQOR, PWSCUM, PWSCCQ, PWSCCN, PWPLT, PWPAK, PWMERL, PWMACT, PWKTLN, PWFUF6, PWFUF5, PWFUF4, PWFUF3, PWDUAL, PWCTAM, PWXDCK, PWCPNT, PWBCRC, PWUOMV, PWLOTC, PWJEL0, PWJELNNMBR, PWPOE, PWJELA, PWJELB, PWJELC, PWJELD, PWRTGO, PWPTRF, PWPMT2, PWCTSN, PWPROV, PWASN, PWPRFLG1, PWPRFLG2, PWMOADJ, PWPS09, PWQTYPY, PWWVID, PWCNTRTID, PWCNTRTDID, PWREVFLG, PWAPPFLG, PWREVAN8, PWAPPAN8, PWWOPID, PWWVTY, PWAREV, PWSRRC, PWFSRRC, PWEV01 FROM F43121Z

TOP812 | 43 | F43121Z COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PWDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2PWDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3PWDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4PWKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
5PWSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
6PWLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
7PWNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
8PWJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
9PWCTIDComputer IDStringGeneric Edit150 Allow NULL? 
10PWSELCSelection ExitsCharacterGeneric Edit10 Allow NULL? 
11PWKCODocument CompanyStringGeneric Edit50 Allow NULL? 
12PWJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
13PWJEL1Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
14PWJEL2Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
15PWJEL3Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
16PWJEL4Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
17PWJEL5Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
18PWJEL6Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
19PWJEL7Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
20PWJEL8Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
21PWJEL9Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
22PWMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
23PWLOCNLocationStringGeneric Edit200 Allow NULL? 
24PWLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
25PWLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
26PWLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
27PWLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
28PWIVIInventory Interface Y/N - DistributionCharacterUDC (H40 IV)10 Allow NULL? 
29PWSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
30PWLEDGCost MethodStringUDC (40 CM)20 Allow NULL? 
31PWCLEVLevel - Inventory CostCharacterUDC (H40 CL)10 Allow NULL? 
32PWGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
33PWRCDJDate - ReceivedDateGeneric Edit60
34PWDGLDate - For G/L (and Voucher)DateGeneric Edit60
35PWRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
36PWSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
37PWVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
38PWAN8Address NumberNumericUDC80 Allow NULL? 
39PWVRMKSupplier RemarkStringGeneric Edit300 Allow NULL? 
40PWVANIAccount Number - Received Not VoucheredStringGeneric Edit290 Allow NULL? 
41PWPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
42PWASIDSerial NumberStringGeneric Edit250 Allow NULL? 
43PWCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
44PWSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
45PWSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
46PWULOTAllow Duplicate LotsCharacterUDC (40 DU)10 Allow NULL? 
47PWAVGCUpdate Average Cost On-LineCharacterGeneric Edit10 Allow NULL? 
48PWSOQSQuantity ShippedNumericGeneric Edit152 Allow NULL? 
49PWUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
50PWUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
51PWSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
52PWUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
53PWCNV1Conversion Factor - Secondary to PrimaryNumericGeneric Edit157 Allow NULL? 
54PWOPSTOperation Status Code W.O.StringUDC (31 OS)20 Allow NULL? 
55PWRTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
56PWUPIBUpdate Item Location QuantityStringGeneric Edit40 Allow NULL? 
57PWRCPTReceipt Acknowledgement (Y/N)CharacterGeneric Edit10 Allow NULL? 
58PWPMTEPayment Eligible (Y/N)CharacterGeneric Edit10 Allow NULL? 
59PWCONVConversion FactorNumericGeneric Edit157 Allow NULL? 
60PWCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
61PWUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
62PWURECUnits - ReceivedNumericGeneric Edit152 Allow NULL? 
63PWPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
64PWARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
65PWAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
66PWECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
67PWCRYRCurrency Conversion Y/N/ZCharacterUDC (H00 CR)10 Allow NULL? 
68PWFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
69PWFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
70PWFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
71PWITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
72PWRPLReplacement (Y/N)CharacterUDC (43 RP)10 Allow NULL? 
73PWNROURoute - Normal Route CodeStringUDC (43 RC)40 Allow NULL? 
74PWCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
75PWCOCompanyStringGeneric Edit50 Allow NULL? 
76PWPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
77PWDRQJDate - RequestedDateGeneric Edit60
78PWPDDJDate - Scheduled PickDateGeneric Edit60
79PWOPDJDate - Original Promised DeliveryDateGeneric Edit60
80PWLNTYLine TypeStringGeneric Edit20 Allow NULL? 
81PWAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
82PWLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
83PWCNV2Conversion Factor - Purchasing to PrimarNumericGeneric Edit157 Allow NULL? 
84PWLINLine Number - GeneralNumericGeneric Edit72 Allow NULL? 
85PWNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
86PWWRTHFlag - Write Ledger Record (Y/N)CharacterGeneric Edit10 Allow NULL? 
87PWNXT2Status Code - NextStringUDC (40 AT)30 Allow NULL? 
88PWSOPOFlag - Sales/PurchasingCharacterGeneric Edit10 Allow NULL? 
89PWDSC1DescriptionStringGeneric Edit300 Allow NULL? 
90PWLANDCode - Landed CostCharacterGeneric Edit10 Allow NULL? 
91PWALINLine - AssociatedNumericGeneric Edit50 Allow NULL? 
92PWCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
93PWDSCVFlag - Debit Standard Cost VarianceCharacterGeneric Edit10 Allow NULL? 
94PWDMBVFlag - Debit Material Burden VarianceCharacterGeneric Edit10 Allow NULL? 
95PWDZBAFlag - Debit Zero Balance AdjustmentCharacterGeneric Edit10 Allow NULL? 
96PWCZBAFlag - Credit Zero Balance AdjustmentCharacterGeneric Edit10 Allow NULL? 
97PWRCNVFlag - Received Not VoucheredCharacterGeneric Edit10 Allow NULL? 
98PWDTACFlag - Debit Tax AccrualCharacterGeneric Edit10 Allow NULL? 
99PWCTACFlag - Credit Tax AccrualCharacterGeneric Edit10 Allow NULL? 
100PWTRR1Triangulation Rate - From CurrencyNumericGeneric Edit150 Allow NULL? 
101PWTRR2Triangulation Rate - To CurrencyNumericGeneric Edit150 Allow NULL? 
102PWCRCMCurrency Conversion Y/ZCharacterGeneric Edit10 Allow NULL? 
103PWDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
104PWDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
105PWMODEMode - ProcessingCharacterGeneric Edit10 Allow NULL? 
106PWPSRSourceStringGeneric Edit120 Allow NULL? 
107PWPSRYSource TypeStringUDC (38 DY)20 Allow NULL? 
108PWSEQSequence NumberNumericGeneric Edit60 Allow NULL? 
109PWTREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
110PWTEMPTemperatureNumericGeneric Edit72 Allow NULL? 
111PWSTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
112PWDNTYDensityNumericGeneric Edit72 Allow NULL? 
113PWDNTPDensity Type - At Standard TemperatureCharacterUDC (41B DT)10 Allow NULL? 
114PWDETPDensity TemperatureNumericGeneric Edit72 Allow NULL? 
115PWDTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
116PWAMBRVolume - AmbientNumericGeneric Edit152 Allow NULL? 
117PWBUM3Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
118PWVCFVolume Correction FactorNumericGeneric Edit74 Allow NULL? 
119PWSTOKVolume - StandardNumericGeneric Edit152 Allow NULL? 
120PWBUM4Unit of Measure 4StringUDC (00 UM)20 Allow NULL? 
121PWWGTRWeight ResultNumericGeneric Edit152 Allow NULL? 
122PWBUM5Unit of Measure 5StringUDC (00 UM)20 Allow NULL? 
123PWSTUMQuantity - Primary Stock Accounting UnitNumericGeneric Edit152 Allow NULL? 
124PWBUM6Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
125PWBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
126PWABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
127PWABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
128PWABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
129PWABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
130PWABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
131PWABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
132PWABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
133PWABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
134PWPSQPrimary Sequence NumberNumericGeneric Edit62 Allow NULL? 
135PWSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
136PWPEIDProcess IDNumericGeneric Edit150 Allow NULL? 
137PWTCIDTransaction IDNumericGeneric Edit150 Allow NULL? 
138PWVR05Outside Reference 2StringGeneric Edit250 Allow NULL? 
139PWVR04Outside Reference 1StringGeneric Edit250 Allow NULL? 
140PWVR02Reference 2StringGeneric Edit250 Allow NULL? 
141PWVR01ReferenceStringGeneric Edit250 Allow NULL? 
142PWUPUMUPC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
143PWUPQTUPC QuantityNumericGeneric Edit152 Allow NULL? 
144PWUPCNUPC NumberStringGeneric Edit130 Allow NULL? 
145PWUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
146PWSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
147PWSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
148PWSCUMSCC Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
149PWSCCQSCC QuantityNumericGeneric Edit152 Allow NULL? 
150PWSCCNSCC NumberStringGeneric Edit140 Allow NULL? 
151PWPLTSSCC Number - Tare LevelStringGeneric Edit180 Allow NULL? 
152PWPAKSSCC Number - Pack LevelStringGeneric Edit180 Allow NULL? 
153PWMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
154PWMACTMultiple AccountsCharacterUDC (40 MU)10 Allow NULL? 
155PWKTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
156PWFUF6Future UseStringGeneric Edit10 Allow NULL? 
157PWFUF5Future UseStringGeneric Edit10 Allow NULL? 
158PWFUF4Future UseStringGeneric Edit10 Allow NULL? 
159PWFUF3Future UseStringGeneric Edit10 Allow NULL? 
160PWDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
161PWCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
162PWXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
163PWCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
164PWBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
165PWUOMVUnit of Measure as VariableStringUDC (00 UM)20 Allow NULL? 
166PWLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
167PWJEL0Journal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
168PWJELNNMBRJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
169PWPOEPort of Entry or ExitStringUDC (40 PE)60 Allow NULL? 
170PWJELAJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
171PWJELBJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
172PWJELCJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
173PWJELDJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
174PWRTGOFlag - Routing OperationsCharacterGeneric Edit10 Allow NULL? 
175PWPTRFFlag - Prior To Recept Compl LiabCharacterGeneric Edit10 Allow NULL? 
176PWPMT2F43092 To Step Payment EligibleCharacterGeneric Edit10 Allow NULL? 
177PWCTSNContainer Serial NumberStringGeneric Edit400 Allow NULL? 
178PWPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
179PWASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
180PWPRFLG1Pricing Control 01CharacterUDC (45 PC)10 Allow NULL? 
181PWPRFLG2Pricing Control 02CharacterUDC (45 PF)10 Allow NULL? 
182PWMOADJManual Override Adjustment FlagCharacterCheck Box10 Allow NULL? 
183PWPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
184PWQTYPYQuantity To PayNumericGeneric Edit150 Allow NULL? 
185PWWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
186PWCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
187PWCNTRTDIDContract Detail IDNumericGeneric Edit150 Allow NULL? 
188PWREVFLGReviewed FlagCharacterGeneric Edit10 Allow NULL? 
189PWAPPFLGApproved FlagCharacterGeneric Edit10 Allow NULL? 
190PWREVAN8Reviewed By Address NumberNumericGeneric Edit80 Allow NULL? 
191PWAPPAN8Approved By Address NumberNumericGeneric Edit80 Allow NULL? 
192PWWOPIDOperation IDIntegerGeneric Edit110 Allow NULL? 
193PWWVTYVessel ClassCharacterGeneric Edit10 Allow NULL? 
194PWAREVAdjustment Revision LevelNumericGeneric Edit30 Allow NULL? 
195PWSRRCAmount - Secondary Unit CostNumericGeneric Edit154 Allow NULL? 
196PWFSRRCAmount - Foreign Secondary Unit CostNumericGeneric Edit154 Allow NULL? 
197PWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 

TOP812 | 43 | F43121Z INDEXES

NumberDescription
2Computer ID Job Number +A
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3LNIDLine NumberAscending
4NLINNumber of LinesAscending
3ComputerID Job Number +B (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2JOBSJob NumberAscending
3DOCODocument (Order No Invoice etc.)Ascending
4DCTOOrder TypeAscending
5KCOOOrder Company (Order Number)Ascending
6SFXOOrder SuffixAscending
7LNIDLine NumberAscending
8NLINNumber of LinesAscending
4DOCO DCTO KCOO SFXO LNID
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending