EX_DC_STG_ERR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DC_TRANS_NUM	Character(17)	VARCHAR2(17) NOT NULL	Diners Club Transaction Number
3	DC_ACCT_NUM	Character(19)	VARCHAR2(19) NOT NULL	Account Number
4	DC_CRDHLDR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Card Holder Name
5	TRANS_DT	Date(10)	DATE	Transaction Date
6	DC_TRANS_AMOUNT	Signed Number(17,3)	DECIMAL(15,3) NOT NULL	Diners Club Transaction Amount
7	DC_DRCR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Diners Clib Debit/Credit Flag
8	DC_CURR_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Diners Club Currency Cd Descr
9	DC_ISO_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Diners Club ISO Currency Code
10	DC_CHARGE_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Diners Club Charge type
11	DC_EST_CTY_TWN	Character(26)	VARCHAR2(26) NOT NULL	DC Establishment City/Town
12	DC_EST_STATE	Character(20)	VARCHAR2(20) NOT NULL	DinersClub Establishment State
13	DC_EST_COUNTRY	Character(30)	VARCHAR2(30) NOT NULL	DinersClub Establishment Country
14	DC_SIC_CODE	Character(4)	VARCHAR2(4) NOT NULL	Standard Industry Code
15	DC_SIC_CODE1	Character(5)	VARCHAR2(5) NOT NULL	Standard Industry Code
16	DC_ORIG_TRANS_AMT	Signed Number(17,3)	DECIMAL(15,3) NOT NULL	DinersClub orig trans amount
17	DC_ORIG_CURR	Character(20)	VARCHAR2(20) NOT NULL	DC Original Currency descr
18	DC_ISO_CUR_CD2	Character(3)	VARCHAR2(3) NOT NULL	Diners Club iso currency code
19	DC_REF_NUM	Character(12)	VARCHAR2(12) NOT NULL	Diners Club Reference number
20	DC_MERCH_CODE	Character(30)	VARCHAR2(30) NOT NULL	Diners CLub Merchant Code
21	ADVANCE_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Advance Source
22	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
23	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights
24	CUR_EXCHNG_RT	Number(16,8)	DECIMAL(15,8) NOT NULL	Currency Exchange Rate
25	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
26	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
27	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
28	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
29	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
30	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
31	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes
32	EX_TYPE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expense Type Flag
33	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type
34	EX_TRANS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Expenses Transaction Type, used to categorize external data that is loaded into the expense product, for example corporate card expenses/credits, ATM advances and travel bookings. ALL=All Transaction Types ATMA=ATM Advance CCCR=Credit CCEX=Expense TRBK=Travel Reservation
35	INVALID_EMPLID	Character(1)	VARCHAR2(1) NOT NULL	Invalid Employee
36	INVALID_EX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Invalid Expense Type
37	INVALID_MON_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Monetary Currency
38	INVALID_TXN_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Transaction Currency
39	RELOAD_TRANS_SW	Character(1)	VARCHAR2(1) NOT NULL	Reprocess Transaction
40	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
41	CC_POSTING_DT	Date(10)	DATE	Credit Card Posting Date
42	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
43	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor