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

81 COLUMNS | 1 INDEXES | Print definition?920 | 40 | F40UI74 TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40UI74AW811Price Adjustment History Work FileRegular Work Files45: Advanced PricingBusiness 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 AWCTID, AWJOBS, AWPEID, AWTCID, AWXLIN, AWAREV, AWDOCO, AWDCTO, AWKCOO, AWSFXO, AWLNID, AWAKID, AWSRCFD, AWOSEQ, AWSUBSEQ, AWTIER, AWASN, AWAST, AWITM, AWAN8, AWCRCD, AWUOM, AWMNQ, AWLEDG, AWFRMN, AWBSCD, AWFVTR, AWABAS, AWUPRC, AWFUP, AWGLC, AWARSN, AWACNT, AWSBIF, AWMDED, AWPROV, AWATID, AWLITM, AWAITM, AWDSC1, AWLNTY, AWUORG, AWFGY, AWORPR, AWSO08, AWRPRC, AWOLVL, AWCATLG, AWIGID, AWCGID, AWOGID, AWANPS, AWBSDVAL, AWSRFLAG, AWADJCAL, AWNBRORD, AWUOMVID, AWACCAN8, AWBNAD, AWADJGRP, AWMEADJ, AWADJSTS, AWADJREF, AWFVUM, AWPDCL, AWCFGID, AWCFGCID, AWAPRP1, AWAPRP2, AWAPRP3, AWAPRP4, AWAPRP5, AWAPRP6, AWNDPI, AWPMTN, AWRULENAME, AWPA04, AWADJQTY, AWQTYPY, AWSTPRCF, AWTSTRSNM FROM F40UI74

TOP920 | 40 | F40UI74 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1AWCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2AWJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3AWPEIDProcess IDNumericGeneric Edit150 Allow NULL? 
4AWTCIDTransaction IDNumericGeneric Edit150 Allow NULL? 
5AWXLINLine NumberNumericGeneric Edit63 Allow NULL? 
6AWAREVAdjustment Revision LevelNumericGeneric Edit30 Allow NULL? 
7AWDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
8AWDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
9AWKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
10AWSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
11AWLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
12AWAKIDPrice History Alternate KeyNumericGeneric Edit150 Allow NULL? 
13AWSRCFDPrice History Alternate Key SourceStringUDC (45 SF)20 Allow NULL? 
14AWOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
15AWSUBSEQSub-Sequence NumberNumericGeneric Edit40 Allow NULL? 
16AWTIERTierNumericGeneric Edit20 Allow NULL? 
17AWASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
18AWASTPrice Adjustment NameStringUDC (40 TY)80 Allow NULL? 
19AWITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
20AWAN8Address NumberNumericGeneric Edit80 Allow NULL? 
21AWCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
22AWUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
23AWMNQQuantity - FromNumericGeneric Edit150 Allow NULL? 
24AWLEDGCost MethodStringUDC (40 CM)20 Allow NULL? 
25AWFRMNPrice Formula NameStringUDC (40 FM)100 Allow NULL? 
26AWBSCDBasis CodeCharacterUDC (40 BC)10 Allow NULL? 
27AWFVTRFactor ValueNumericGeneric Edit154 Allow NULL? 
28AWABASOverride Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
29AWUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
30AWFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
31AWGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
32AWARSNAdjustment Reason CodeStringUDC (40 AR)30 Allow NULL? 
33AWACNTAdjustment Control CodeCharacterUDC (40 CO)10 Allow NULL? 
34AWSBIFSubledger InformationCharacterUDC (40 SI)10 Allow NULL? 
35AWMDEDManual Addition/Change (Y/N)CharacterGeneric Edit10 Allow NULL? 
36AWPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
37AWATIDPrice Adjustment Key IDNumericGeneric Edit80 Allow NULL? 
38AWLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
39AWAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
40AWDSC1DescriptionStringGeneric Edit300 Allow NULL? 
41AWLNTYLine TypeStringGeneric Edit20 Allow NULL? 
42AWUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
43AWFGYFree Goods (Y/N)CharacterGeneric Edit10 Allow NULL? 
44AWORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
45AWSO08Price Adjustment Line IndicatorCharacterGeneric Edit10 Allow NULL? 
46AWRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
47AWOLVLAdjustment LevelCharacterUDC (40 AL)10 Allow NULL? 
48AWCATLGFree Good Catalog NameStringUDC (45 FG)100 Allow NULL? 
49AWIGIDItem Group Key IDNumericGeneric Edit80 Allow NULL? 
50AWCGIDCustomer Group Key IDNumericGeneric Edit80 Allow NULL? 
51AWOGIDOrder Group Key IDNumericGeneric Edit80 Allow NULL? 
52AWANPSAddress Number Price AdjustmentsNumericGeneric Edit80 Allow NULL? 
53AWBSDVALBased on ValueNumericGeneric Edit154 Allow NULL? 
54AWSRFLAGSliding Rate FlagCharacterGeneric Edit10 Allow NULL? 
55AWADJCALAdjustment CalculationStringGeneric Edit800 Allow NULL? 
56AWNBRORDNumber of OrdersNumericGeneric Edit150 Allow NULL? 
57AWUOMVIDUnit of Measure - Volume IncentivesStringUDC (00 UM)20 Allow NULL? 
58AWACCAN8Accumulate at AddressNumericGeneric Edit80 Allow NULL? 
59AWBNADBeneficiary AddressNumericGeneric Edit80 Allow NULL? 
60AWADJGRPMutually Exclusive Adjustment GroupStringUDC (45 AG)100 Allow NULL? 
61AWMEADJMutually Exclusive AdjustmentCharacterGeneric Edit10 Allow NULL? 
62AWADJSTSAdjustment StatusCharacterUDC (45 ST)10 Allow NULL? 
63AWADJREFCharge ReferenceStringGeneric Edit150 Allow NULL? 
64AWFVUMFactor Value Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
65AWPDCLPromotion Display ControlCharacterCheck Box10 Allow NULL? 
66AWCFGIDConfiguration ID NumberNumericGeneric Edit150 Allow NULL? 
67AWCFGCIDComponent ID NumberNumericGeneric Edit150 Allow NULL? 
68AWAPRP1Pricing Reporting Code 1StringUDC (45 P1)30 Allow NULL? 
69AWAPRP2Pricing Reporting Code 2StringUDC (45 P2)30 Allow NULL? 
70AWAPRP3Pricing Reporting Code 3StringUDC (45 P3)30 Allow NULL? 
71AWAPRP4Pricing Reporting Code 4StringUDC (45 P4)60 Allow NULL? 
72AWAPRP5Pricing Reporting Code 5StringUDC (45 P5)60 Allow NULL? 
73AWAPRP6Pricing Reporting Code 6StringUDC (45 P6)60 Allow NULL? 
74AWNDPINet Down PriceCharacterGeneric Edit10 Allow NULL? 
75AWPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
76AWRULENAMERounding Rule NameStringGeneric Edit100 Allow NULL? 
77AWPA04Target ApplicationCharacterUDC (40 TA)10 Allow NULL? 
78AWADJQTYAdjust Quantity To PayCharacterGeneric Edit10 Allow NULL? 
79AWQTYPYQuantity To PayNumericGeneric Edit150 Allow NULL? 
80AWSTPRCFNew Base Price FlagCharacterGeneric Edit10 Allow NULL? 
81AWTSTRSNMTest Result NameStringGeneric Edit300 Allow NULL? 

TOP920 | 40 | F40UI74 INDEXES

NumberDescription
1Computer ID Job Number +A (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2PEIDProcess IDAscending
3JOBSJob NumberAscending
4TCIDTransaction IDAscending
5XLINLine NumberAscending
6DOCODocument (Order No Invoice etc.)Ascending
7DCTOOrder TypeAscending
8KCOOOrder Company (Order Number)Ascending
9SFXOOrder SuffixAscending
10LNIDLine NumberAscending
11AREVAdjustment Revision LevelAscending
12AKIDPrice History Alternate KeyAscending
13SRCFDPrice History Alternate Key SourceAscending
14OSEQSequence NumberAscending
15SUBSEQSub-Sequence NumberAscending
16TIERTierAscending