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

95 COLUMNS | 7 INDEXES | Print definition?920 | 09E | F09E150 TABLE

09E: Expense Reimbursment
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F09E150CI957Credit Card Transaction Interface TableFiles09E: Expense Reimbursment
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 CICCTN, CIEMPLOYID, CICRCRDNUM, CIPMTMETH, CICTLID, CITRANSTAT, CICHRGTO, CIMCU, CISBL, CISBLT, CIEXPTYPE, CIEXPDATE, CIEXPAMT, CIBILLAMT, CIEXPCRCD, CIBILLCRCD, CICRR, CIBUSPURP, CIDESCCHG, CIREASON, CIVENDCODE, CIVENDNAME, CIVSTREET, CIVCITY, CIVSTATE, CIVZIPCODE, CIVCOUNTRY, CILOCATN, CIREFNUMB, CIREFDATE1, CITICKNUMB, CICLASSERV, CIDESTIN1, CIDESTIN2, CIDESTIN3, CIFMDATE, CITODATE, CINUMBDAYS, CITELNUMB, CITAXAMT, CITAXTYPE, CIUNITS, CIRATE1, CIORIGNUMB, CIADDLCMT, CIDESC01, CIDESC02, CIDESC03, CIDESC04, CINUMERIC1, CINUMERIC2, CINUMERIC3, CITEXT1, CITEXT2, CITEXT3, CIDATE1, CIDATE2, CIDATE3, CIEXRPTTYP, CIEXRPTNUM, CIDTECRT, CICCRPTYPE, CICCRPTNUM, CICCRPTDTE, CICCFILENO, CICCRECIPN, CIGFLAG1, CIGFLAG2, CIGAMOUNT1, CIGAMOUNT2, CIGNUMBER1, CIGNUMBER2, CIGTEXT001, CIGTEXT002, CIGDATE1, CIGDATE2, CIGCODE1, CIGCODE2, CIEFLAG1, CIEFLAG2, CIEAMOUNT1, CIEAMOUNT2, CIENUMBER1, CIENUMBER2, CIETEXT001, CIETEXT002, CIEDATE1, CIEDATE2, CIECODE1, CIECODE2, CIPID, CIUSER, CIJOBN, CIUPMT, CIUPMJ FROM F09E150

TOP920 | 09E | F09E150 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CICCTNCredit Card Transaction NumberStringGeneric Edit200 Allow NULL? 
2CIEMPLOYIDEmployee IDNumericGeneric Edit80 Allow NULL? 
3CICRCRDNUMCredit Card NumberStringGeneric Edit250 Allow NULL? 
4CIPMTMETHPayment MethodStringUDC (09E PM)30 Allow NULL? 
5CICTLIDControl IDStringGeneric Edit300 Allow NULL? 
6CITRANSTATCredit Card Transaction StatusStringUDC (09E CS)20 Allow NULL? 
7CICHRGTOCharge ToStringUDC (09E CT)300 Allow NULL? 
8CIMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
9CISBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
10CISBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
11CIEXPTYPEExpense CategoryStringUDC (09E EC)40 Allow NULL? 
12CIEXPDATEExpense DateDateGeneric Edit60
13CIEXPAMTExpense AmountNumericGeneric Edit152 Allow NULL? 
14CIBILLAMTBilled AmountNumericGeneric Edit152 Allow NULL? 
15CIEXPCRCDExpense Currency CodeStringGeneric Edit30 Allow NULL? 
16CIBILLCRCDBilled Currency CodeStringGeneric Edit30 Allow NULL? 
17CICRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
18CIBUSPURPBusiness PurposeStringGeneric Edit400 Allow NULL? 
19CIDESCCHGDescription of ChargeStringGeneric Edit450 Allow NULL? 
20CIREASONReason CodeStringGeneric Edit100 Allow NULL? 
21CIVENDCODEVendor CodeStringGeneric Edit80 Allow NULL? 
22CIVENDNAMEVendor NameStringGeneric Edit350 Allow NULL? 
23CIVSTREETVendor Street or Address1StringGeneric Edit400 Allow NULL? 
24CIVCITYVendor CityStringGeneric Edit300 Allow NULL? 
25CIVSTATEVendor StateStringGeneric Edit200 Allow NULL? 
26CIVZIPCODEVendor Zip CodeStringGeneric Edit120 Allow NULL? 
27CIVCOUNTRYVendor CountryStringGeneric Edit300 Allow NULL? 
28CILOCATNLocationStringUDC (09E EL)100 Allow NULL? 
29CIREFNUMBReference NumberStringGeneric Edit200 Allow NULL? 
30CIREFDATE1Reference DateDateGeneric Edit60
31CITICKNUMBTicket NumberStringGeneric Edit150 Allow NULL? 
32CICLASSERVClass of ServiceStringGeneric Edit150 Allow NULL? 
33CIDESTIN1First DestinationStringGeneric Edit200 Allow NULL? 
34CIDESTIN2Second DestinationStringGeneric Edit200 Allow NULL? 
35CIDESTIN3Third DestinationStringGeneric Edit200 Allow NULL? 
36CIFMDATEFrom DateDateGeneric Edit60
37CITODATETo DateDateGeneric Edit60
38CINUMBDAYSNumber of DaysNumericGeneric Edit30 Allow NULL? 
39CITELNUMBTelephone Number CalledStringGeneric Edit200 Allow NULL? 
40CITAXAMTTax AmountNumericGeneric Edit152 Allow NULL? 
41CITAXTYPETax TypeStringGeneric Edit150 Allow NULL? 
42CIUNITSUnitsNumericGeneric Edit62 Allow NULL? 
43CIRATE1RateNumericGeneric Edit153 Allow NULL? 
44CIORIGNUMBOriginating NumberStringGeneric Edit200 Allow NULL? 
45CIADDLCMTAdditional CommentsStringGeneric Edit600 Allow NULL? 
46CIDESC01Description 1StringGeneric Edit450 Allow NULL? 
47CIDESC02Description 2StringGeneric Edit450 Allow NULL? 
48CIDESC03Description 3StringGeneric Edit450 Allow NULL? 
49CIDESC04Description 4StringGeneric Edit450 Allow NULL? 
50CINUMERIC1Numeric 01NumericGeneric Edit152 Allow NULL? 
51CINUMERIC2Numeric 02NumericGeneric Edit152 Allow NULL? 
52CINUMERIC3Numeric 03NumericGeneric Edit152 Allow NULL? 
53CITEXT1Text FieldStringGeneric Edit400 Allow NULL? 
54CITEXT2Text FieldStringGeneric Edit400 Allow NULL? 
55CITEXT3Text FieldStringGeneric Edit400 Allow NULL? 
56CIDATE1Date FieldDateGeneric Edit60
57CIDATE2Date FieldDateGeneric Edit60
58CIDATE3Date FieldDateGeneric Edit60
59CIEXRPTTYPExpense Report TypeCharacterUDC (09E RT)10 Allow NULL? 
60CIEXRPTNUMExpense Report NumberStringGeneric Edit100 Allow NULL? 
61CIDTECRTDate CreatedDateGeneric Edit60
62CICCRPTYPECredit Card Co Report TypeStringGeneric Edit250 Allow NULL? 
63CICCRPTNUMCredit Card Co Report NumberStringGeneric Edit250 Allow NULL? 
64CICCRPTDTECredit Card Co Report DateDateGeneric Edit60
65CICCFILENOCredit Card Co File NumberStringGeneric Edit150 Allow NULL? 
66CICCRECIPNCredit Card Co RecipientStringGeneric Edit150 Allow NULL? 
67CIGFLAG1Generic Flag 1CharacterGeneric Edit10 Allow NULL? 
68CIGFLAG2Generic Flag 2CharacterGeneric Edit10 Allow NULL? 
69CIGAMOUNT1Generic Amount 1NumericGeneric Edit152 Allow NULL? 
70CIGAMOUNT2Generic Amount 2NumericGeneric Edit152 Allow NULL? 
71CIGNUMBER1Generic Number 1NumericGeneric Edit80 Allow NULL? 
72CIGNUMBER2Generic Number 2NumericGeneric Edit100 Allow NULL? 
73CIGTEXT001Generic String 1StringGeneric Edit400 Allow NULL? 
74CIGTEXT002Generic String 2StringGeneric Edit400 Allow NULL? 
75CIGDATE1Generic Date 1DateGeneric Edit60
76CIGDATE2Generic Date 2DateGeneric Edit60
77CIGCODE1Generic Code 1StringGeneric Edit50 Allow NULL? 
78CIGCODE2Generic Code 2StringGeneric Edit100 Allow NULL? 
79CIEFLAG1EMS Flag 1 Future UseCharacterGeneric Edit10 Allow NULL? 
80CIEFLAG2EMS Flag 2 Future UseCharacterGeneric Edit10 Allow NULL? 
81CIEAMOUNT1EMS Amount 1 Future UseNumericGeneric Edit152 Allow NULL? 
82CIEAMOUNT2EMS Amount 2 Future UseNumericGeneric Edit152 Allow NULL? 
83CIENUMBER1Expense Report Employee IDNumericGeneric Edit80 Allow NULL? 
84CIENUMBER2EMS Number 2 Future UseNumericGeneric Edit100 Allow NULL? 
85CIETEXT001Expense Report Workstation IDStringGeneric Edit400 Allow NULL? 
86CIETEXT002EMS String 2 Future UseStringGeneric Edit400 Allow NULL? 
87CIEDATE1EMS Date 1 Future UseDateGeneric Edit60
88CIEDATE2EMS Date 2 Future UseDateGeneric Edit60
89CIECODE1EMS Code 1 Future UseStringGeneric Edit50 Allow NULL? 
90CIECODE2EMS Code 2 Future UseStringGeneric Edit100 Allow NULL? 
91CIPIDProgram IDStringGeneric Edit100 Allow NULL? 
92CIUSERUser IDStringGeneric Edit100 Allow NULL? 
93CIJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
94CIUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
95CIUPMJDate - UpdatedDateGeneric Edit60

TOP920 | 09E | F09E150 INDEXES

NumberDescription
1CCTransactionNumber (Primary/Unique)
ElementAliasDescriptionSequence
1CCTNCredit Card Transaction NumberAscending
2DateA Pmt Empl CC Status Catg+
ElementAliasDescriptionSequence
1EXPDATEExpense DateAscending
2PMTMETHPayment MethodAscending
3EMPLOYIDEmployee IDAscending
4CRCRDNUMCredit Card NumberAscending
5TRANSTATCredit Card Transaction StatusAscending
6EXPTYPEExpense CategoryAscending
7BILLCRCDBilled Currency CodeAscending
8EXPCRCDExpense Currency CodeAscending
9VENDNAMEVendor NameAscending
3DateD Pmt Empl CC Status Catg+
ElementAliasDescriptionSequence
1EXPDATEExpense DateDescending
2PMTMETHPayment MethodAscending
3EMPLOYIDEmployee IDAscending
4CRCRDNUMCredit Card NumberAscending
5TRANSTATCredit Card Transaction StatusAscending
6EXPTYPEExpense CategoryAscending
7BILLCRCDBilled Currency CodeAscending
8EXPCRCDExpense Currency CodeAscending
9VENDNAMEVendor NameAscending
4Empl Pmt
ElementAliasDescriptionSequence
1EMPLOYIDEmployee IDAscending
2PMTMETHPayment MethodAscending
3EXPCRCDExpense Currency CodeAscending
5Empl CC
ElementAliasDescriptionSequence
1EMPLOYIDEmployee IDAscending
2CRCRDNUMCredit Card NumberAscending
6ExpRptDate ExpRptType ExpRptNo
ElementAliasDescriptionSequence
1DTECRTDate CreatedAscending
2EXRPTTYPExpense Report TypeAscending
3EXRPTNUMExpense Report NumberAscending
7Stat Dte Empl Pmt CC Cat CCTN+
ElementAliasDescriptionSequence
1TRANSTATCredit Card Transaction StatusAscending
2EXPDATEExpense DateAscending
3EMPLOYIDEmployee IDAscending
4PMTMETHPayment MethodAscending
5CRCRDNUMCredit Card NumberAscending
6EXPTYPEExpense CategoryAscending
7CCTNCredit Card Transaction NumberAscending
8DTECRTDate CreatedAscending
9EXRPTTYPExpense Report TypeAscending
10EXRPTNUMExpense Report NumberAscending