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
4F4311PDPurchase Order Detail File
5F4211SDSales 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

130 COLUMNS | 2 INDEXES | Print definition?920 | 31B | F31B75 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B75OC1302Operation ConfigurationFiles31B: Blend Management
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 OCWCFGID, OCWCOPCD, OCWCDL01, OCWBOPID, OCWBOPCD, OCWHAR, OCWMVOPF, OCWFVTY, OCWTVTY, OCWBEXTF, OCINSTMET, OCDISTMET, OCWPSD, OCWPAD, OCWSBDV, OCWOPTTL, OCWVCH, OCWVTCH, OCWFRMAT, OCFMTUOM, OCWTRMAT, OCTMTUOM, OCWFAWS, OCWTAWS, OCWDBMET, OCWTBMET, OCWFINA1, OCWFINA2, OCWFINA3, OCWFINA4, OCWFINA5, OCWFINA6, OCWFINA7, OCWFINA8, OCWFINA9, OCWFINA10, OCWFINA11, OCWFINA12, OCWTINA1, OCWTINA2, OCWTINA3, OCWTINA4, OCWTINA5, OCWTINA6, OCWTINA7, OCWTINA8, OCWTINA9, OCWTINA10, OCWTINA11, OCWTINA12, OCWPOPGL, OCWAOPGL, OCWTLCAM, OCWCOC01, OCWCOC02, OCWCOC03, OCWCOC04, OCWCOC05, OCWLVAL, OCWSVAL, OCMTVAL, OCEQVAL, OCVTVAL, OCWEURF, OCWOWNF, OCWMTTYF, OCWWISTF, OCWBIDF, OCWSTYF, OCWVSTYF, OCWLOTCF, OCWLOTAF, OCWCOMPF, OCWACADF, OCBOSNR, OCSTSPTM, OCWQTYTHD, OCWRLOPF, OCQSPC, OCQTST, OCDCT, OCURCD, OCURDT, OCURAT, OCURAB, OCURRF, OCWNUM, OCWMDT, OCWAB, OCWCD, OCWRF, OCUSER, OCPID, OCJOBN, OCUPMJ, OCTDAY, OCWCG, OCWSGLF, OCWOGLF, OCWAOTC, OCWSCOST, OCWOCOST, OCWLNB, OCWLNA, OCWLNS, OCWLNO, OCINSZERO1, OCINSZERO2, OCINSZERO3, OCINSZERO4, OCTASKTYPE, OCWFRTFLG, OCFVBTUSE, OCTVBTUSE, OCFCNTTYP, OCTCNTTYP, OCVALHAR, OCVALPRR, OCVALREN, OCVALSUB, OCWHRSF, OCWEQPF, OCWCONF, OCPRMSNTYP, OCWCF, OCTINSZRO1, OCTINSZRO2, OCTINSZRO3, OCTINSZRO4, OCPRCPTF FROM F31B75

TOP920 | 31B | F31B75 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OCWCFGIDConfigured Operation IDIntegerGeneric Edit110 Allow NULL? 
2OCWCOPCDConfigured Operation Short CodeStringGeneric Edit100 Allow NULL? 
3OCWCDL01Configured Operation DescriptionStringGeneric Edit300 Allow NULL? 
4OCWBOPIDBase Operation IDIntegerGeneric Edit110 Allow NULL? 
5OCWBOPCDBase Operation Short CodeStringGeneric Edit100 Allow NULL? 
6OCWHARHarvest Operation FlagCharacterGeneric Edit10 Allow NULL? 
7OCWMVOPFMovement Operation Flag - Future UseCharacterGeneric Edit10 Allow NULL? 
8OCWFVTYFrom Vessel ClassCharacterUDC (31B CV)10 Allow NULL? 
9OCWTVTYTo Vessel ClassCharacterUDC (31B CV)10 Allow NULL? 
10OCWBEXTFBlock Extraction FlagCharacterGeneric Edit10 Allow NULL? 
11OCINSTMETInstruction MethodCharacterUDC (31B VI)10 Allow NULL? 
12OCDISTMETDistribution MethodCharacterUDC (31B DM)10 Allow NULL? 
13OCWPSDPerform Survey MeasureCharacterUDC (31B OS)10 Allow NULL? 
14OCWPADPerform After MeasureCharacterUDC (31B AM)10 Allow NULL? 
15OCWSBDVShow Planned MeasuresCharacterGeneric Edit10 Allow NULL? 
16OCWOPTTLOperation Form TitleStringGeneric Edit500 Allow NULL? 
17OCWVCHVessel Column Heading - Future UseStringGeneric Edit200 Allow NULL? 
18OCWVTCHVessel Type Column Heading - Future UseStringGeneric Edit200 Allow NULL? 
19OCWFRMATFrom After Material Type CodeStringGeneric Edit40 Allow NULL? 
20OCFMTUOMFrom Material Type UOMStringUDC (31B MU)20 Allow NULL? 
21OCWTRMATTo After Material Type CodeStringGeneric Edit40 Allow NULL? 
22OCTMTUOMTo Material Type UOMStringUDC (31B MU)20 Allow NULL? 
23OCWFAWSFrom After Wine Status Short CodeStringGeneric Edit60 Allow NULL? 
24OCWTAWSTo After Wine Status Short CodeStringGeneric Edit60 Allow NULL? 
25OCWDBMETDefault BlendID MethodStringUDC (31B DB)100 Allow NULL? 
26OCWTBMETDefault BlendID Method ToStringUDC (31B TB)100 Allow NULL? 
27OCWFINA1From Lot Instructed Attribute 1NumericGeneric Edit154 Allow NULL? 
28OCWFINA2From Lot Instructed Attribute 2NumericGeneric Edit154 Allow NULL? 
29OCWFINA3From Lot Instructed Attribute 3NumericGeneric Edit154 Allow NULL? 
30OCWFINA4From Lot Instructed Attribute 4NumericGeneric Edit154 Allow NULL? 
31OCWFINA5From Lot Instructed Attribute 5StringGeneric Edit200 Allow NULL? 
32OCWFINA6From Lot Instructed Attribute 6StringGeneric Edit200 Allow NULL? 
33OCWFINA7From Lot Instructed Attribute 7StringGeneric Edit200 Allow NULL? 
34OCWFINA8From Lot Instructed Attribute 8StringGeneric Edit200 Allow NULL? 
35OCWFINA9From Lot Instructed Attribute 9DateGeneric Edit60
36OCWFINA10From Lot Instructed Attribute 10DateGeneric Edit60
37OCWFINA11From Lot Instructed Attribute 11DateGeneric Edit60
38OCWFINA12From Lot Instructed Attribute 12DateGeneric Edit60
39OCWTINA1To Lot Instructed Attribute 1NumericGeneric Edit154 Allow NULL? 
40OCWTINA2To Lot Instructed Attribute 2NumericGeneric Edit154 Allow NULL? 
41OCWTINA3To Lot Instructed Attribute 3NumericGeneric Edit154 Allow NULL? 
42OCWTINA4To Lot Instructed Attribute 4NumericGeneric Edit154 Allow NULL? 
43OCWTINA5To Lot Instructed Attribute 5StringGeneric Edit200 Allow NULL? 
44OCWTINA6To Lot Instructed Attribute 6StringGeneric Edit200 Allow NULL? 
45OCWTINA7To Lot Instructed Attribute 7StringGeneric Edit200 Allow NULL? 
46OCWTINA8To Lot Instructed Attribute 8StringGeneric Edit200 Allow NULL? 
47OCWTINA9To Lot Instructed Attribute 9DateGeneric Edit60
48OCWTINA10To Lot Instructed Attribute 10DateGeneric Edit60
49OCWTINA11To Lot Instructed Attribute 11DateGeneric Edit60
50OCWTINA12To Lot Instructed Attribute 12DateGeneric Edit60
51OCWPOPGLPlanned Operation Gains/Loss - PercentNumericGeneric Edit154 Allow NULL? 
52OCWAOPGLAllowed Operation Gains/Loss - PercentNumericGeneric Edit154 Allow NULL? 
53OCWTLCAMTopping Loss Calculation MethodStringUDC (31B LM)100 Allow NULL? 
54OCWCOC01Configured Operation Category Code1StringUDC (31B B1)100 Allow NULL? 
55OCWCOC02Configured Operation Category Code2StringUDC (31B B2)100 Allow NULL? 
56OCWCOC03Configured Operation Category Code3StringUDC (31B B3)100 Allow NULL? 
57OCWCOC04Configured Operation Category Code4StringUDC (31B B4)100 Allow NULL? 
58OCWCOC05Configured Operation Category Code5StringUDC (31B B5)100 Allow NULL? 
59OCWLVALWinery List Valid Invalid FlagCharacterUDC (31B TF)10 Allow NULL? 
60OCWSVALWine Status Valid Invalid FlagCharacterUDC (31B TF)10 Allow NULL? 
61OCMTVALMaterial Type Valid Invalid FlagCharacterUDC (31B TF)10 Allow NULL? 
62OCEQVALEquipment Type Valid Invalid FlagCharacterUDC (31B TF)10 Allow NULL? 
63OCVTVALVessel Type Valid Invalid FlagCharacterUDC (31B TF)10 Allow NULL? 
64OCWEURFEUR Control FlagCharacterGeneric Edit10 Allow NULL? 
65OCWOWNFOwnership Control FlagCharacterGeneric Edit10 Allow NULL? 
66OCWMTTYFMaterial Type Control FlagCharacterGeneric Edit10 Allow NULL? 
67OCWWISTFWine Status Control FlagCharacterGeneric Edit10 Allow NULL? 
68OCWBIDFBlend ID Control FlagCharacterGeneric Edit10 Allow NULL? 
69OCWSTYFStyle Control FlagCharacterGeneric Edit10 Allow NULL? 
70OCWVSTYFVessel Style Control FlagCharacterGeneric Edit10 Allow NULL? 
71OCWLOTCFLot Comments Control FlagCharacterGeneric Edit10 Allow NULL? 
72OCWLOTAFInst Sum. Lot Attributes Control FlagCharacterGeneric Edit10 Allow NULL? 
73OCWCOMPFComposition Control FlagCharacterGeneric Edit10 Allow NULL? 
74OCWACADFAccumulated Additives Control FlagCharacterGeneric Edit10 Allow NULL? 
75OCBOSNRBond Serial Number RequiredCharacterUDC (31B BN)10 Allow NULL? 
76OCSTSPTMStart Stop TimerCharacterUDC (31B TR)10 Allow NULL? 
77OCWQTYTHDSignificant Change Quantity ThresholdNumericGeneric Edit154 Allow NULL? 
78OCWRLOPFRelated Operation FlagCharacterGeneric Edit10 Allow NULL? 
79OCQSPCSpecificationStringGeneric Edit250 Allow NULL? 
80OCQTSTTest IDStringGeneric Edit250 Allow NULL? 
81OCDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
82OCURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
83OCURDTUser Reserved DateDateGeneric Edit60
84OCURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
85OCURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
86OCURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
87OCWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
88OCWMDTBlend Mgmt DateDateGeneric Edit60
89OCWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
90OCWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
91OCWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 
92OCUSERUser IDStringGeneric Edit100 Allow NULL? 
93OCPIDProgram IDStringGeneric Edit100 Allow NULL? 
94OCJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
95OCUPMJDate - UpdatedDateGeneric Edit60
96OCTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
97OCWCGCost GroupStringGeneric Edit120 Allow NULL? 
98OCWSGLFSurvey Gain Loss FlagCharacterGeneric Edit10 Allow NULL? 
99OCWOGLFOperation Gain Loss FlagCharacterGeneric Edit10 Allow NULL? 
100OCWAOTCApply Periodic CostCharacterGeneric Edit10 Allow NULL? 
101OCWSCOSTSurvey Cost ComponentStringGeneric Edit120 Allow NULL? 
102OCWOCOSTOperation Cost ComponentStringGeneric Edit120 Allow NULL? 
103OCWLNBBefore Line NumberNumericGeneric Edit40 Allow NULL? 
104OCWLNAAfter Line NumberNumericGeneric Edit40 Allow NULL? 
105OCWLNSSurvey G/L Line NumberNumericGeneric Edit40 Allow NULL? 
106OCWLNOOperation G/L Line NumberNumericGeneric Edit40 Allow NULL? 
107OCINSZERO1From Instruct Zero 1CharacterGeneric Edit10 Allow NULL? 
108OCINSZERO2From Instruct Zero 2CharacterGeneric Edit10 Allow NULL? 
109OCINSZERO3From Instruct Zero 3CharacterGeneric Edit10 Allow NULL? 
110OCINSZERO4From Instruct Zero 4CharacterGeneric Edit10 Allow NULL? 
111OCTASKTYPETask TypeStringUDC (H90 TT)20 Allow NULL? 
112OCWFRTFLGFortification FlagCharacterGeneric Edit10 Allow NULL? 
113OCFVBTUSEFrom VBT UseCharacterUDC (31B UV)10 Allow NULL? 
114OCTVBTUSETo VBT UseCharacterUDC (31B UV)10 Allow NULL? 
115OCFCNTTYPFrom Container TypeStringUDC (31B BT)40 Allow NULL? 
116OCTCNTTYPTo Container TypeStringUDC (31B BT)40 Allow NULL? 
117OCVALHARValidate Harvest Activity WithholdingCharacterGeneric Edit10 Allow NULL? 
118OCVALPRRValidate Prior Activity WithholdingCharacterGeneric Edit10 Allow NULL? 
119OCVALRENValidate ReEntry With-holding PeriodCharacterGeneric Edit10 Allow NULL? 
120OCVALSUBValidate Subsequent Activity WithholdingCharacterGeneric Edit10 Allow NULL? 
121OCWHRSFHuman Resource Details Control FlagCharacterGeneric Edit10 Allow NULL? 
122OCWEQPFEquipment Control FlagCharacterGeneric Edit10 Allow NULL? 
123OCWCONFConsumables Control FlagCharacterGeneric Edit10 Allow NULL? 
124OCPRMSNTYPPermission TypeStringUDC (H95 PT)40 Allow NULL? 
125OCWCFCost Change Control FlagCharacterGeneric Edit10 Allow NULL? 
126OCTINSZRO1To Instruct Zero 1CharacterGeneric Edit10 Allow NULL? 
127OCTINSZRO2To Instruct Zero 2CharacterGeneric Edit10 Allow NULL? 
128OCTINSZRO3To Instruct Zero 3CharacterGeneric Edit10 Allow NULL? 
129OCTINSZRO4To Instruct Zero 4CharacterGeneric Edit10 Allow NULL? 
130OCPRCPTFPartial Receipts Control FlagCharacterGeneric Edit10 Allow NULL? 

TOP920 | 31B | F31B75 INDEXES

NumberDescription
1Configured OperationID (Primary/Unique)
ElementAliasDescriptionSequence
1WCFGIDConfigured Operation IDAscending
2ConfiguredOprShotCode
ElementAliasDescriptionSequence
1WCOPCDConfigured Operation Short CodeAscending