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

63 COLUMNS | 3 INDEXES | Print definition?920 | 75I | F75I101 TABLE

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75I101QB633TDS Certificate Work MaintenanceFiles75I: India
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 QBCO, QBDCT, QBKCO, QBDOC, QBSFX, QBAN8, QBTAXC, QBPYE, QBDGJ, QBVINV, QBI75ORST, QBAG, QBAA, QBYTXB, QBYTXS, QBYTYP, QBI75WCTY, QBYERT, QBI75TDSR, QBI75TSUR, QBYGRP, QBADT, QBADTJ, QBCPDT, QBBAN8, QBYGCA, QBYSNM, QBYAOC, QBYDSD, QBYDFD, QBYJIF, QBIRSO, QBFADT, QBATTL, QBUSER, QBPID, QBJOBN, QBUPMJ, QBUPMT, QBTORG, QBCHGF, QBI75CERA, QBI75CEAM, QBI75PRSU, QBAPAOW, QBCKCS, QBAAMF, QBSFXE, QBPST, QBPYST, QBGLC, QBTAWH, QBSFXM, QBSFXO, QBACR, QBACRF, QBDDJ, QBFY, QBCTRY, QBI75CHNO, QBI75CHDT, QBI75CENO, QBI75PRTD FROM F75I101

TOP920 | 75I | F75I101 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1QBCOCompanyStringGeneric Edit50 Allow NULL? 
2QBDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
3QBKCODocument CompanyStringGeneric Edit50 Allow NULL? 
4QBDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
5QBSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
6QBAN8Address NumberNumericGeneric Edit80 Allow NULL? 
7QBTAXCPerson/Corporation CodeCharacterUDC (H00 TA)10 Allow NULL? 
8QBPYEPayee Address NumberNumericGeneric Edit80 Allow NULL? 
9QBDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
10QBVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
11QBI75ORSTOrigin StateStringUDC (00 S)30 Allow NULL? 
12QBAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
13QBAAAmountNumericGeneric Edit152 Allow NULL? 
14QBYTXBTDS AmountNumericGeneric Edit152 Allow NULL? 
15QBYTXSTDS SurchargeNumericGeneric Edit152 Allow NULL? 
16QBYTYPTDS TypeCharacterUDC (75I TY)10 Allow NULL? 
17QBI75WCTYWork Contract Tax TypeCharacterUDC (75I TY)10 Allow NULL? 
18QBYERTRate Effective %NumericGeneric Edit52 Allow NULL? 
19QBI75TDSRTDS RateNumericGeneric Edit52 Allow NULL? 
20QBI75TSURSurcharge RateNumericGeneric Edit52 Allow NULL? 
21QBYGRPTDS GroupCharacterUDC (75I TG)10 Allow NULL? 
22QBADTDate - AdjustmentDateGeneric Edit60
23QBADTJDate - AppliedDateGeneric Edit60
24QBCPDTDate - Current PositionDateGeneric Edit60
25QBBAN8Address Number - BeneficiaryNumericGeneric Edit80 Allow NULL? 
26QBYGCAGross Contract AmountNumericGeneric Edit152 Allow NULL? 
27QBYSNMReceipt NumberStringGeneric Edit400 Allow NULL? 
28QBYAOCAssessing Certificate NumberStringGeneric Edit400 Allow NULL? 
29QBYDSDDate Submit NIL DeclarationDateGeneric Edit60
30QBYDFDDate Foward Declaration to CommisionDateGeneric Edit60
31QBYJIFJDS/TDS Interface FlagCharacterGeneric Edit10 Allow NULL? 
32QBIRSOTaxable Amount Subject to W/TNumericGeneric Edit152 Allow NULL? 
33QBFADTAmount - Additional Federal TaxNumericGeneric Edit92 Allow NULL? 
34QBATTLProfessional TitleStringGeneric Edit400 Allow NULL? 
35QBUSERUser IDStringGeneric Edit100 Allow NULL? 
36QBPIDProgram IDStringGeneric Edit100 Allow NULL? 
37QBJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
38QBUPMJDate - UpdatedDateGeneric Edit60
39QBUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
40QBTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
41QBCHGFChange FlagCharacterGeneric Edit10 Allow NULL? 
42QBI75CERACess RateNumericGeneric Edit152 Allow NULL? 
43QBI75CEAMCess AmountNumericGeneric Edit152 Allow NULL? 
44QBI75PRSUProcessing Surchange FlagCharacterGeneric Edit10 Allow NULL? 
45QBAPAOWPaid - Unit CostStringGeneric Edit150 Allow NULL? 
46QBCKCSSpending Account Claim NumberStringGeneric Edit150 Allow NULL? 
47QBAAMFAutomatic Acct Instructions Merge FlagCharacterGeneric Edit10 Allow NULL? 
48QBSFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
49QBPSTPay Status CodeCharacterUDC (00 PS)10 Allow NULL? 
50QBPYSTPay Status CodeCharacterUDC10 Allow NULL? 
51QBGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
52QBTAWHTax Authority for A/P WithholdingNumericGeneric Edit80 Allow NULL? 
53QBSFXMDocument Pay Item - Matching(Pmt/Item)StringGeneric Edit30 Allow NULL? 
54QBSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
55QBACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
56QBACRFAmount - Currency - Offset Accting DistrNumericGeneric Edit152 Allow NULL? 
57QBDDJDate - Net DueDateGeneric Edit60
58QBFYFiscal YearNumericGeneric Edit20 Allow NULL? 
59QBCTRYCenturyNumericGeneric Edit20 Allow NULL? 
60QBI75CHNOChallan NoStringGeneric Edit600 Allow NULL? 
61QBI75CHDTChallan DateDateGeneric Edit60
62QBI75CENOCertificate NumberNumericGeneric Edit80 Allow NULL? 
63QBI75PRTDProcessing TDS FlagCharacterGeneric Edit10 Allow NULL? 

TOP920 | 75I | F75I101 INDEXES

NumberDescription
1Co+DocCo+DocTyp+DocNo+DocPayIt (Primary/Unique)
ElementAliasDescriptionSequence
1COCompanyAscending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4DOCDocument (Voucher Invoice etc.)Ascending
5SFXDocument Pay ItemAscending
2Co+DCo+DTyp+DNo+CPayIt+Flag
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2YTYPTDS TypeAscending
3FYFiscal YearAscending
4CTRYCenturyAscending
5I75WCTYWork Contract Tax TypeAscending
3kco+dct+doc
ElementAliasDescriptionSequence
1KCODocument CompanyAscending
2DCTDocument TypeAscending
3DOCDocument (Voucher Invoice etc.)Ascending