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

61 COLUMNS | 4 INDEXES | Print definition?920 | 04 | F04572 TABLE

04: Accounts Payable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F04572KK614A/P Payment Processing - SummaryWork Files04: Accounts PayableBusiness 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 KKHDC, KKCKC, KKPSEL, KKPGMP, KKCHKQ, KKGLBA, KKCRCD, KKPST, KKDOCM, KKDCTM, KKPSTT, KKPYE, KKALPP, KKAN8, KKALPH, KKCRC, KKATT, KKSTUB, KKDETL, KKCO, KKTNST, KKCBNK, KKCHKD, KKDL01, KKADSA, KKPAAP, KKDGJ, KKPYTY, KKVLDT, KKBPDJ, KKBXDJ, KKAC01, KKAC02, KKAC03, KKAC04, KKAC05, KKRMK, KKPO, KKPDCT, KKPKCO, KKMCU, KKPID, KKUSER, KKUPMJ, KKUPMT, KKCRR, KKPVN, KKEFTJ, KKFILE, KKMID, KKPTYF, KKPYIN, KKEDTY, KKEDSQ, KKEKCO, KKEDOC, KKEDCT, KKJOBN, KKGFL3, KKGFL4, KKCRRM FROM F04572

TOP920 | 04 | F04572 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1KKHDCPayment Group Control Nbr - A/P ChecksNumericGeneric Edit80 Allow NULL? 
2KKCKCCheck Control Number - A/P ChecksNumericGeneric Edit80 Allow NULL? 
3KKPSELA/P Check Print Selection NumberNumericGeneric Edit80 Allow NULL? 
4KKPGMPA/P Payment Processing - Print ProgramStringUDC (04 PP)100 Allow NULL? 
5KKCHKQPayment Print QueueStringGeneric Edit100 Allow NULL? 
6KKGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
7KKCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
8KKPSTPay Status CodeCharacterUDC (00 PS)10 Allow NULL? 
9KKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80 Allow NULL? 
10KKDCTMDocument Type - MatchingStringUDC (00 DT)20 Allow NULL? 
11KKPSTTA/P Payment StatusCharacterGeneric Edit10 Allow NULL? 
12KKPYEPayee Address NumberNumericGeneric Edit80 Allow NULL? 
13KKALPPPayee Name - AlphaStringGeneric Edit400 Allow NULL? 
14KKAN8Address NumberNumericGeneric Edit80 Allow NULL? 
15KKALPHName - AlphaStringGeneric Edit400 Allow NULL? 
16KKCRCPayment Handling CodeStringUDC (00 HC)30 Allow NULL? 
17KKATTPrint AttachmentsCharacterGeneric Edit10 Allow NULL? 
18KKSTUBStub total - A/P Checkwriter Work fileNumericGeneric Edit20 Allow NULL? 
19KKDETLDetail lines for A/P PaymentsNumericGeneric Edit60 Allow NULL? 
20KKCOCompanyStringGeneric Edit50 Allow NULL? 
21KKTNSTTransit Number - BankStringGeneric Edit200 Allow NULL? 
22KKCBNKBank Account Number - CustomerStringGeneric Edit200 Allow NULL? 
23KKCHKDBank Account - Control DigitStringGeneric Edit20 Allow NULL? 
24KKDL01DescriptionStringGeneric Edit300 Allow NULL? 
25KKADSADiscount TakenNumericGeneric Edit152 Allow NULL? 
26KKPAAPPayment AmountNumericGeneric Edit152 Allow NULL? 
27KKDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
28KKPYTYA/P Payment TypeCharacterGeneric Edit10 Allow NULL? 
29KKVLDTDate - Cleared/ValueDateGeneric Edit60
30KKBPDJDate - BACS Processing Date - JulianDateGeneric Edit60
31KKBXDJDate - BACS Expiration Date - JulianDateGeneric Edit60
32KKAC01Category Code - Address Book 01StringUDC (01 01)30 Allow NULL? 
33KKAC02Category Code - Address Book 02StringUDC (01 02)30 Allow NULL? 
34KKAC03Category Code - Address Book 03StringUDC (01 03)30 Allow NULL? 
35KKAC04Category Code - Address Book 04StringUDC (01 04)30 Allow NULL? 
36KKAC05Category Code - Address Book 05StringUDC (01 05)30 Allow NULL? 
37KKRMKName - RemarkStringGeneric Edit300 Allow NULL? 
38KKPOPurchase OrderStringGeneric Edit80 Allow NULL? 
39KKPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
40KKPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
41KKMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
42KKPIDProgram IDStringGeneric Edit100 Allow NULL? 
43KKUSERUser IDStringGeneric Edit100 Allow NULL? 
44KKUPMJDate - UpdatedDateGeneric Edit60
45KKUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
46KKCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
47KKPVNPayment Print Program VersionStringGeneric Edit100 Allow NULL? 
48KKEFTJDate - EffectiveDateGeneric Edit60
49KKFILEFile NameStringGeneric Edit100 Allow NULL? 
50KKMIDMember IDStringGeneric Edit100 Allow NULL? 
51KKPTYFPayment Type FlagCharacterGeneric Edit10 Allow NULL? 
52KKPYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
53KKEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
54KKEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
55KKEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
56KKEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
57KKEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
58KKJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
59KKGFL3Generic Flag 3CharacterGeneric Edit10 Allow NULL? 
60KKGFL4Generic Flag 4CharacterGeneric Edit10 Allow NULL? 
61KKCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 

TOP920 | 04 | F04572 INDEXES

NumberDescription
1PCG Number Payment Number (Primary/Unique)
ElementAliasDescriptionSequence
1HDCPayment Group Control Nbr - A/P ChecksAscending
2CKCCheck Control Number - A/P ChecksAscending
2Print Selection Bank Acc +
ElementAliasDescriptionSequence
1PSELA/P Check Print Selection NumberAscending
2PSTPay Status CodeAscending
3GLBAG/L Bank AccountAscending
4DOCMDocument - Matching(Payment or Item)Ascending
3PCG NUmber Pay Status
ElementAliasDescriptionSequence
1HDCPayment Group Control Nbr - A/P ChecksAscending
2PSTPay Status CodeAscending
4PCG Number Pay Number Descend
ElementAliasDescriptionSequence
1HDCPayment Group Control Nbr - A/P ChecksAscending
2CKCCheck Control Number - A/P ChecksDescending