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

97 COLUMNS | 1 INDEXES | Print definition?920 | 13C | F1310Z1 TABLE

13C: Condition-Base Maintenance
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F1310Z1CB971Unedited Condition-Based AlertsFiles13C: Condition-Base Maintenance
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 CBEDUS, CBEDBT, CBEDTN, CBEDLN, CBEDCT, CBTYTN, CBEDFT, CBEDDT, CBDRIN, CBEDDL, CBEDSP, CBPNID, CBTNAC, CBUKID, CBNUMB, CBAPID, CBASID, CBPRODM, CBMELC, CBAN8, CBLANO, CBLOC, CBEQST, CBTYRP, CBSRVT, CBDOCO, CBDL01, CBEVTDT, CBEVTTM, CBEVTUTC, CBTIMEZONES, CBDSAVNAME, CBQTST, CBQSPC, CBDSC1, CBQVAL, CBQPF, CBTOVR, CBANO, CBPDFL, CBDQLT, CBPNST, CBPMUKID, CBWONA, CBSNDN, CBNOTR, CBNSTT, CBASTC, CBSNDV, CBINVR, CBISTT, CBIVCP, CBISSUE, CBSEST, CBSCHSTTIME, CBVR01, CBVR02, CBWHO2, CBAR1, CBPHN1, CBADD1, CBADD2, CBADD3, CBADD4, CBCTY1, CBADDS, CBADDZ, CBCOUN, CBCTR, CBURAB, CBURAT, CBURCD, CBURDT, CBURRF, CBCBURCH1, CBCBURCH2, CBCBURDT1, CBCBURDT2, CBCBURMN1, CBCBURMN2, CBCBURAB1, CBCBURAB2, CBCBURST1, CBCBURST2, CBCBURST3, CBCBURST4, CBCBURST5, CBCBURST6, CBCBURST7, CBCBURST8, CBCBURST9, CBCBURST0, CBUSER, CBPID, CBMKEY, CBUPMJ, CBUPMT FROM F1310Z1

TOP920 | 13C | F1310Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CBEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2CBEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3CBEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4CBEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5CBEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6CBTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7CBEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8CBEDDTEDI - Transmission DateDateGeneric Edit60
9CBDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10CBEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11CBEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12CBPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13CBTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14CBUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
15CBNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
16CBAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
17CBASIDSerial NumberStringGeneric Edit250 Allow NULL? 
18CBPRODMProduct ModelStringUDC (17 PM)80 Allow NULL? 
19CBMELCMeasurement LocationStringUDC (13 LC)100 Allow NULL? 
20CBAN8Address NumberNumericGeneric Edit80 Allow NULL? 
21CBLANOAddress Number - Lessor/Rentor/MortgagorNumericGeneric Edit80 Allow NULL? 
22CBLOCBusiness Unit - LocationStringGeneric Edit120 Allow NULL? 
23CBEQSTEquipment StatusStringUDC (12 ES)20 Allow NULL? 
24CBTYRPAutomated Response TypeCharacterUDC (13 AR)10 Allow NULL? 
25CBSRVTService TypeStringUDC (12 ST)80 Allow NULL? 
26CBDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
27CBDL01DescriptionStringGeneric Edit300 Allow NULL? 
28CBEVTDTEvent DateDateGeneric Edit60
29CBEVTTMEvent TimeNumericGeneric Edit60 Allow NULL? 
30CBEVTUTCEvent Time UTCNumericGeneric Edit150 Allow NULL? 
31CBTIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
32CBDSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 
33CBQTSTTest IDStringGeneric Edit250 Allow NULL? 
34CBQSPCSpecificationStringGeneric Edit250 Allow NULL? 
35CBDSC1DescriptionStringGeneric Edit300 Allow NULL? 
36CBQVALTest ValueStringGeneric Edit150 Allow NULL? 
37CBQPFPass/Fail (P/F)CharacterGeneric Edit10 Allow NULL? 
38CBTOVRTest override flagCharacterGeneric Edit10 Allow NULL? 
39CBANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
40CBPDFLAlert LevelCharacterUDC (13 AL)10 Allow NULL? 
41CBDQLTData QualityCharacterUDC (13 DQ)10 Allow NULL? 
42CBPNSTDate - Planned Start (Julian)DateGeneric Edit60
43CBPMUKIDPM Unique IDNumericGeneric Edit150 Allow NULL? 
44CBWONAWork Order Number AssignedNumericGeneric Edit80 Allow NULL? 
45CBSNDNSend Notification MessageCharacterGeneric Edit10 Allow NULL? 
46CBNOTRNotification RecipientNumericGeneric Edit80 Allow NULL? 
47CBNSTTNotification Structure TypeStringUDC (01 TS)30 Allow NULL? 
48CBASTCAlert StatusCharacterUDC (13 AS)10 Allow NULL? 
49CBSNDVInvestigation Message SentCharacterGeneric Edit10 Allow NULL? 
50CBINVRInvestigation RecipientNumericGeneric Edit80 Allow NULL? 
51CBISTTInvestigation Structure TypeStringUDC (01 TS)30 Allow NULL? 
52CBIVCPInvestigation CompletedCharacterGeneric Edit10 Allow NULL? 
53CBISSUEProblem DescriptionStringGeneric Edit800 Allow NULL? 
54CBSESTTime - Scheduled Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
55CBSCHSTTIMEScheduled Start ANSI C UTC TimeNumericGeneric Edit150 Allow NULL? 
56CBVR01ReferenceStringGeneric Edit250 Allow NULL? 
57CBVR02Reference 2StringGeneric Edit250 Allow NULL? 
58CBWHO2Contact Name 2StringGeneric Edit400 Allow NULL? 
59CBAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
60CBPHN1Phone NumberStringGeneric Edit200 Allow NULL? 
61CBADD1Address Line 1StringGeneric Edit400 Allow NULL? 
62CBADD2Address Line 2StringGeneric Edit400 Allow NULL? 
63CBADD3Address Line 3StringGeneric Edit400 Allow NULL? 
64CBADD4Address Line 4StringGeneric Edit400 Allow NULL? 
65CBCTY1CityStringGeneric Edit250 Allow NULL? 
66CBADDSStateStringUDC (00 S)30 Allow NULL? 
67CBADDZPostal CodeStringGeneric Edit120 Allow NULL? 
68CBCOUNCountyStringUDC (00 CT)250 Allow NULL? 
69CBCTRCountryStringUDC (00 CN)30 Allow NULL? 
70CBURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
71CBURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
72CBURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
73CBURDTUser Reserved DateDateGeneric Edit60
74CBURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
75CBCBURCH1User Reserved Char 01CharacterGeneric Edit10 Allow NULL? 
76CBCBURCH2User Reserved Char 02CharacterGeneric Edit10 Allow NULL? 
77CBCBURDT1User Reserved Date 01DateGeneric Edit60
78CBCBURDT2User Reserved Date 02DateGeneric Edit60
79CBCBURMN1User Reserved Numeric 01NumericGeneric Edit154 Allow NULL? 
80CBCBURMN2User Reserved Numeric 02NumericGeneric Edit154 Allow NULL? 
81CBCBURAB1User Reserved Number 01NumericGeneric Edit80 Allow NULL? 
82CBCBURAB2User Reserved Number 02NumericGeneric Edit80 Allow NULL? 
83CBCBURST1User Reserved String 01StringGeneric Edit50 Allow NULL? 
84CBCBURST2User Reserved String 02StringGeneric Edit50 Allow NULL? 
85CBCBURST3User Reserved String 03StringGeneric Edit150 Allow NULL? 
86CBCBURST4User Reserved String 04StringGeneric Edit150 Allow NULL? 
87CBCBURST5User Reserved String 05StringGeneric Edit300 Allow NULL? 
88CBCBURST6User Reserved String 06StringGeneric Edit300 Allow NULL? 
89CBCBURST7User Reserved String 07StringGeneric Edit300 Allow NULL? 
90CBCBURST8User Reserved String 08StringGeneric Edit800 Allow NULL? 
91CBCBURST9User Reserved String 09StringGeneric Edit800 Allow NULL? 
92CBCBURST0User Reserved String 10StringGeneric Edit800 Allow NULL? 
93CBUSERUser IDStringGeneric Edit100 Allow NULL? 
94CBPIDProgram IDStringGeneric Edit100 Allow NULL? 
95CBMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
96CBUPMJDate - UpdatedDateGeneric Edit60
97CBUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 13C | F1310Z1 INDEXES

NumberDescription
1User ID Batch Transaction +A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending