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

83 COLUMNS | 4 INDEXES | Print definition?920 | 13C | F1310 TABLE

13C: Condition-Base Maintenance
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F1310CA834Condition-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 CAUKID, CANUMB, CAAPID, CAASID, CAMELC, CAAN8, CALANO, CALOC, CAEQST, CATYRP, CASRVT, CADOCO, CADL01, CAEVTDT, CAEVTTM, CAEVTUTC, CATIMEZONES, CADSAVNAME, CAQTST, CAQSPC, CADSC1, CAQVAL, CAQPF, CATOVR, CAANO, CAPDFL, CADQLT, CAPNST, CAPMUKID, CAWONA, CASNDN, CANOTR, CANSTT, CAASTC, CASNDV, CAINVR, CAISTT, CAIVCP, CAISSUE, CASEST, CASCHSTTIME, CAVR01, CAVR02, CAWHO2, CAAR1, CAPHN1, CAADD1, CAADD2, CAADD3, CAADD4, CACTY1, CAADDS, CAADDZ, CACOUN, CACTR, CAURAB, CAURAT, CAURCD, CAURDT, CAURRF, CACBURCH1, CACBURCH2, CACBURDT1, CACBURDT2, CACBURMN1, CACBURMN2, CACBURAB1, CACBURAB2, CACBURST1, CACBURST2, CACBURST3, CACBURST4, CACBURST5, CACBURST6, CACBURST7, CACBURST8, CACBURST9, CACBURST0, CAUSER, CAPID, CAMKEY, CAUPMJ, CAUPMT FROM F1310

TOP920 | 13C | F1310 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CAUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2CANUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
3CAAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
4CAASIDSerial NumberStringGeneric Edit250 Allow NULL? 
5CAMELCMeasurement LocationStringUDC (13 LC)100 Allow NULL? 
6CAAN8Address NumberNumericGeneric Edit80 Allow NULL? 
7CALANOAddress Number - Lessor/Rentor/MortgagorNumericGeneric Edit80 Allow NULL? 
8CALOCBusiness Unit - LocationStringGeneric Edit120 Allow NULL? 
9CAEQSTEquipment StatusStringUDC (12 ES)20 Allow NULL? 
10CATYRPAutomated Response TypeCharacterUDC (13 AR)10 Allow NULL? 
11CASRVTService TypeStringUDC (12 ST)80 Allow NULL? 
12CADOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
13CADL01DescriptionStringGeneric Edit300 Allow NULL? 
14CAEVTDTEvent DateDateGeneric Edit60
15CAEVTTMEvent TimeNumericGeneric Edit60 Allow NULL? 
16CAEVTUTCEvent Time UTCNumericGeneric Edit150 Allow NULL? 
17CATIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
18CADSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 
19CAQTSTTest IDStringGeneric Edit250 Allow NULL? 
20CAQSPCSpecificationStringGeneric Edit250 Allow NULL? 
21CADSC1DescriptionStringGeneric Edit300 Allow NULL? 
22CAQVALTest ValueStringGeneric Edit150 Allow NULL? 
23CAQPFPass/Fail (P/F)CharacterGeneric Edit10 Allow NULL? 
24CATOVRTest override flagCharacterGeneric Edit10 Allow NULL? 
25CAANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
26CAPDFLAlert LevelCharacterUDC (13 AL)10 Allow NULL? 
27CADQLTData QualityCharacterUDC (13 DQ)10 Allow NULL? 
28CAPNSTDate - Planned Start (Julian)DateGeneric Edit60
29CAPMUKIDPM Unique IDNumericGeneric Edit150 Allow NULL? 
30CAWONAWork Order Number AssignedNumericGeneric Edit80 Allow NULL? 
31CASNDNSend Notification MessageCharacterGeneric Edit10 Allow NULL? 
32CANOTRNotification RecipientNumericGeneric Edit80 Allow NULL? 
33CANSTTNotification Structure TypeStringUDC (01 TS)30 Allow NULL? 
34CAASTCAlert StatusCharacterUDC (13 AS)10 Allow NULL? 
35CASNDVInvestigation Message SentCharacterGeneric Edit10 Allow NULL? 
36CAINVRInvestigation RecipientNumericGeneric Edit80 Allow NULL? 
37CAISTTInvestigation Structure TypeStringUDC (01 TS)30 Allow NULL? 
38CAIVCPInvestigation CompletedCharacterGeneric Edit10 Allow NULL? 
39CAISSUEProblem DescriptionStringGeneric Edit800 Allow NULL? 
40CASESTTime - Scheduled Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
41CASCHSTTIMEScheduled Start ANSI C UTC TimeNumericGeneric Edit150 Allow NULL? 
42CAVR01ReferenceStringGeneric Edit250 Allow NULL? 
43CAVR02Reference 2StringGeneric Edit250 Allow NULL? 
44CAWHO2Contact Name 2StringGeneric Edit400 Allow NULL? 
45CAAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
46CAPHN1Phone NumberStringGeneric Edit200 Allow NULL? 
47CAADD1Address Line 1StringGeneric Edit400 Allow NULL? 
48CAADD2Address Line 2StringGeneric Edit400 Allow NULL? 
49CAADD3Address Line 3StringGeneric Edit400 Allow NULL? 
50CAADD4Address Line 4StringGeneric Edit400 Allow NULL? 
51CACTY1CityStringGeneric Edit250 Allow NULL? 
52CAADDSStateStringUDC (00 S)30 Allow NULL? 
53CAADDZPostal CodeStringGeneric Edit120 Allow NULL? 
54CACOUNCountyStringUDC (00 CT)250 Allow NULL? 
55CACTRCountryStringUDC (00 CN)30 Allow NULL? 
56CAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
57CAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
58CAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
59CAURDTUser Reserved DateDateGeneric Edit60
60CAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
61CACBURCH1User Reserved Char 01CharacterGeneric Edit10 Allow NULL? 
62CACBURCH2User Reserved Char 02CharacterGeneric Edit10 Allow NULL? 
63CACBURDT1User Reserved Date 01DateGeneric Edit60
64CACBURDT2User Reserved Date 02DateGeneric Edit60
65CACBURMN1User Reserved Numeric 01NumericGeneric Edit154 Allow NULL? 
66CACBURMN2User Reserved Numeric 02NumericGeneric Edit154 Allow NULL? 
67CACBURAB1User Reserved Number 01NumericGeneric Edit80 Allow NULL? 
68CACBURAB2User Reserved Number 02NumericGeneric Edit80 Allow NULL? 
69CACBURST1User Reserved String 01StringGeneric Edit50 Allow NULL? 
70CACBURST2User Reserved String 02StringGeneric Edit50 Allow NULL? 
71CACBURST3User Reserved String 03StringGeneric Edit150 Allow NULL? 
72CACBURST4User Reserved String 04StringGeneric Edit150 Allow NULL? 
73CACBURST5User Reserved String 05StringGeneric Edit300 Allow NULL? 
74CACBURST6User Reserved String 06StringGeneric Edit300 Allow NULL? 
75CACBURST7User Reserved String 07StringGeneric Edit300 Allow NULL? 
76CACBURST8User Reserved String 08StringGeneric Edit800 Allow NULL? 
77CACBURST9User Reserved String 09StringGeneric Edit800 Allow NULL? 
78CACBURST0User Reserved String 10StringGeneric Edit800 Allow NULL? 
79CAUSERUser IDStringGeneric Edit100 Allow NULL? 
80CAPIDProgram IDStringGeneric Edit100 Allow NULL? 
81CAMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
82CAUPMJDate - UpdatedDateGeneric Edit60
83CAUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 13C | F1310 INDEXES

NumberDescription
1Unique ID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2PM Unique ID
ElementAliasDescriptionSequence
1PMUKIDPM Unique IDAscending
3Asset Number
ElementAliasDescriptionSequence
1NUMBAsset Item NumberAscending
4Assigned Work Order
ElementAliasDescriptionSequence
1WONAWork Order Number AssignedAscending