	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

95 COLUMNS | 7 INDEXES | 920 | 09E | F09E150 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09E: Expense Reimbursment
1	920	F09E150	CI	95	7	Credit Card Transaction Interface Table	Files	09E: 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

TOP 920 | 09E | F09E150 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CICCTN	Credit Card Transaction Number	String	Generic Edit	20	0	Allow NULL?
2	CIEMPLOYID	Employee ID	Numeric	Generic Edit	8	0	Allow NULL?
3	CICRCRDNUM	Credit Card Number	String	Generic Edit	25	0	Allow NULL?
4	CIPMTMETH	Payment Method	String	UDC (09E PM)	3	0	Allow NULL?
5	CICTLID	Control ID	String	Generic Edit	30	0	Allow NULL?
6	CITRANSTAT	Credit Card Transaction Status	String	UDC (09E CS)	2	0	Allow NULL?
7	CICHRGTO	Charge To	String	UDC (09E CT)	30	0	Allow NULL?
8	CIMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
9	CISBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
10	CISBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
11	CIEXPTYPE	Expense Category	String	UDC (09E EC)	4	0	Allow NULL?
12	CIEXPDATE	Expense Date	Date	Generic Edit	6	0
13	CIEXPAMT	Expense Amount	Numeric	Generic Edit	15	2	Allow NULL?
14	CIBILLAMT	Billed Amount	Numeric	Generic Edit	15	2	Allow NULL?
15	CIEXPCRCD	Expense Currency Code	String	Generic Edit	3	0	Allow NULL?
16	CIBILLCRCD	Billed Currency Code	String	Generic Edit	3	0	Allow NULL?
17	CICRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
18	CIBUSPURP	Business Purpose	String	Generic Edit	40	0	Allow NULL?
19	CIDESCCHG	Description of Charge	String	Generic Edit	45	0	Allow NULL?
20	CIREASON	Reason Code	String	Generic Edit	10	0	Allow NULL?
21	CIVENDCODE	Vendor Code	String	Generic Edit	8	0	Allow NULL?
22	CIVENDNAME	Vendor Name	String	Generic Edit	35	0	Allow NULL?
23	CIVSTREET	Vendor Street or Address1	String	Generic Edit	40	0	Allow NULL?
24	CIVCITY	Vendor City	String	Generic Edit	30	0	Allow NULL?
25	CIVSTATE	Vendor State	String	Generic Edit	20	0	Allow NULL?
26	CIVZIPCODE	Vendor Zip Code	String	Generic Edit	12	0	Allow NULL?
27	CIVCOUNTRY	Vendor Country	String	Generic Edit	30	0	Allow NULL?
28	CILOCATN	Location	String	UDC (09E EL)	10	0	Allow NULL?
29	CIREFNUMB	Reference Number	String	Generic Edit	20	0	Allow NULL?
30	CIREFDATE1	Reference Date	Date	Generic Edit	6	0
31	CITICKNUMB	Ticket Number	String	Generic Edit	15	0	Allow NULL?
32	CICLASSERV	Class of Service	String	Generic Edit	15	0	Allow NULL?
33	CIDESTIN1	First Destination	String	Generic Edit	20	0	Allow NULL?
34	CIDESTIN2	Second Destination	String	Generic Edit	20	0	Allow NULL?
35	CIDESTIN3	Third Destination	String	Generic Edit	20	0	Allow NULL?
36	CIFMDATE	From Date	Date	Generic Edit	6	0
37	CITODATE	To Date	Date	Generic Edit	6	0
38	CINUMBDAYS	Number of Days	Numeric	Generic Edit	3	0	Allow NULL?
39	CITELNUMB	Telephone Number Called	String	Generic Edit	20	0	Allow NULL?
40	CITAXAMT	Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
41	CITAXTYPE	Tax Type	String	Generic Edit	15	0	Allow NULL?
42	CIUNITS	Units	Numeric	Generic Edit	6	2	Allow NULL?
43	CIRATE1	Rate	Numeric	Generic Edit	15	3	Allow NULL?
44	CIORIGNUMB	Originating Number	String	Generic Edit	20	0	Allow NULL?
45	CIADDLCMT	Additional Comments	String	Generic Edit	60	0	Allow NULL?
46	CIDESC01	Description 1	String	Generic Edit	45	0	Allow NULL?
47	CIDESC02	Description 2	String	Generic Edit	45	0	Allow NULL?
48	CIDESC03	Description 3	String	Generic Edit	45	0	Allow NULL?
49	CIDESC04	Description 4	String	Generic Edit	45	0	Allow NULL?
50	CINUMERIC1	Numeric 01	Numeric	Generic Edit	15	2	Allow NULL?
51	CINUMERIC2	Numeric 02	Numeric	Generic Edit	15	2	Allow NULL?
52	CINUMERIC3	Numeric 03	Numeric	Generic Edit	15	2	Allow NULL?
53	CITEXT1	Text Field	String	Generic Edit	40	0	Allow NULL?
54	CITEXT2	Text Field	String	Generic Edit	40	0	Allow NULL?
55	CITEXT3	Text Field	String	Generic Edit	40	0	Allow NULL?
56	CIDATE1	Date Field	Date	Generic Edit	6	0
57	CIDATE2	Date Field	Date	Generic Edit	6	0
58	CIDATE3	Date Field	Date	Generic Edit	6	0
59	CIEXRPTTYP	Expense Report Type	Character	UDC (09E RT)	1	0	Allow NULL?
60	CIEXRPTNUM	Expense Report Number	String	Generic Edit	10	0	Allow NULL?
61	CIDTECRT	Date Created	Date	Generic Edit	6	0
62	CICCRPTYPE	Credit Card Co Report Type	String	Generic Edit	25	0	Allow NULL?
63	CICCRPTNUM	Credit Card Co Report Number	String	Generic Edit	25	0	Allow NULL?
64	CICCRPTDTE	Credit Card Co Report Date	Date	Generic Edit	6	0
65	CICCFILENO	Credit Card Co File Number	String	Generic Edit	15	0	Allow NULL?
66	CICCRECIPN	Credit Card Co Recipient	String	Generic Edit	15	0	Allow NULL?
67	CIGFLAG1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
68	CIGFLAG2	Generic Flag 2	Character	Generic Edit	1	0	Allow NULL?
69	CIGAMOUNT1	Generic Amount 1	Numeric	Generic Edit	15	2	Allow NULL?
70	CIGAMOUNT2	Generic Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
71	CIGNUMBER1	Generic Number 1	Numeric	Generic Edit	8	0	Allow NULL?
72	CIGNUMBER2	Generic Number 2	Numeric	Generic Edit	10	0	Allow NULL?
73	CIGTEXT001	Generic String 1	String	Generic Edit	40	0	Allow NULL?
74	CIGTEXT002	Generic String 2	String	Generic Edit	40	0	Allow NULL?
75	CIGDATE1	Generic Date 1	Date	Generic Edit	6	0
76	CIGDATE2	Generic Date 2	Date	Generic Edit	6	0
77	CIGCODE1	Generic Code 1	String	Generic Edit	5	0	Allow NULL?
78	CIGCODE2	Generic Code 2	String	Generic Edit	10	0	Allow NULL?
79	CIEFLAG1	EMS Flag 1 Future Use	Character	Generic Edit	1	0	Allow NULL?
80	CIEFLAG2	EMS Flag 2 Future Use	Character	Generic Edit	1	0	Allow NULL?
81	CIEAMOUNT1	EMS Amount 1 Future Use	Numeric	Generic Edit	15	2	Allow NULL?
82	CIEAMOUNT2	EMS Amount 2 Future Use	Numeric	Generic Edit	15	2	Allow NULL?
83	CIENUMBER1	Expense Report Employee ID	Numeric	Generic Edit	8	0	Allow NULL?
84	CIENUMBER2	EMS Number 2 Future Use	Numeric	Generic Edit	10	0	Allow NULL?
85	CIETEXT001	Expense Report Workstation ID	String	Generic Edit	40	0	Allow NULL?
86	CIETEXT002	EMS String 2 Future Use	String	Generic Edit	40	0	Allow NULL?
87	CIEDATE1	EMS Date 1 Future Use	Date	Generic Edit	6	0
88	CIEDATE2	EMS Date 2 Future Use	Date	Generic Edit	6	0
89	CIECODE1	EMS Code 1 Future Use	String	Generic Edit	5	0	Allow NULL?
90	CIECODE2	EMS Code 2 Future Use	String	Generic Edit	10	0	Allow NULL?
91	CIPID	Program ID	String	Generic Edit	10	0	Allow NULL?
92	CIUSER	User ID	String	Generic Edit	10	0	Allow NULL?
93	CIJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
94	CIUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
95	CIUPMJ	Date - Updated	Date	Generic Edit	6	0

TOP 920 | 09E | F09E150 INDEXES

Number

Description

CCTransactionNumber (Primary/Unique)

Element	Alias	Description	Sequence
1	CCTN	Credit Card Transaction Number	Ascending

DateA Pmt Empl CC Status Catg+

Element	Alias	Description	Sequence
1	EXPDATE	Expense Date	Ascending
2	PMTMETH	Payment Method	Ascending
3	EMPLOYID	Employee ID	Ascending
4	CRCRDNUM	Credit Card Number	Ascending
5	TRANSTAT	Credit Card Transaction Status	Ascending
6	EXPTYPE	Expense Category	Ascending
7	BILLCRCD	Billed Currency Code	Ascending
8	EXPCRCD	Expense Currency Code	Ascending
9	VENDNAME	Vendor Name	Ascending

DateD Pmt Empl CC Status Catg+

Element	Alias	Description	Sequence
1	EXPDATE	Expense Date	Descending
2	PMTMETH	Payment Method	Ascending
3	EMPLOYID	Employee ID	Ascending
4	CRCRDNUM	Credit Card Number	Ascending
5	TRANSTAT	Credit Card Transaction Status	Ascending
6	EXPTYPE	Expense Category	Ascending
7	BILLCRCD	Billed Currency Code	Ascending
8	EXPCRCD	Expense Currency Code	Ascending
9	VENDNAME	Vendor Name	Ascending

Empl Pmt

Element	Alias	Description	Sequence
1	EMPLOYID	Employee ID	Ascending
2	PMTMETH	Payment Method	Ascending
3	EXPCRCD	Expense Currency Code	Ascending

Empl CC

Element	Alias	Description	Sequence
1	EMPLOYID	Employee ID	Ascending
2	CRCRDNUM	Credit Card Number	Ascending

ExpRptDate ExpRptType ExpRptNo

Element	Alias	Description	Sequence
1	DTECRT	Date Created	Ascending
2	EXRPTTYP	Expense Report Type	Ascending
3	EXRPTNUM	Expense Report Number	Ascending

Stat Dte Empl Pmt CC Cat CCTN+

Element	Alias	Description	Sequence
1	TRANSTAT	Credit Card Transaction Status	Ascending
2	EXPDATE	Expense Date	Ascending
3	EMPLOYID	Employee ID	Ascending
4	PMTMETH	Payment Method	Ascending
5	CRCRDNUM	Credit Card Number	Ascending
6	EXPTYPE	Expense Category	Ascending
7	CCTN	Credit Card Transaction Number	Ascending
8	DTECRT	Date Created	Ascending
9	EXRPTTYP	Expense Report Type	Ascending
10	EXRPTNUM	Expense Report Number	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

95 COLUMNS | 7 INDEXES | 920 | 09E | F09E150 TABLE

TOP 920 | 09E | F09E150 COLUMNS

TOP 920 | 09E | F09E150 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

95 COLUMNS | 7 INDEXES | 920 | 09E | F09E150 TABLE

TOP920 | 09E | F09E150 COLUMNS

TOP920 | 09E | F09E150 INDEXES

TOP 920 | 09E | F09E150 COLUMNS

TOP 920 | 09E | F09E150 INDEXES