EX_USB_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	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	USB_REC_ID	Character(2)	VARCHAR2(2) NOT NULL	US Bank Record ID
5	USB_ACCT_NUM	Character(16)	VARCHAR2(16) NOT NULL	Account Number
6	USB_REF_NUM	Character(23)	VARCHAR2(23) NOT NULL	US Bank reference number
7	USB_TSYS_TRAN_CD	Character(4)	VARCHAR2(4) NOT NULL	US Bank TSYS Transaction code
8	USB_TRANS_DT	Character(8)	VARCHAR2(8) NOT NULL	US Bank transaction date
9	USB_POST_DT	Character(8)	VARCHAR2(8) NOT NULL	US Bank Posting Date
10	USB_ORIG_CURR	Character(3)	VARCHAR2(3) NOT NULL	US Bank Original Currency
11	USB_ORIG_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	US Bank Original Amount
12	USB_BILL_CURR	Character(3)	VARCHAR2(3) NOT NULL	US Bank Billing Currency
13	USB_BILL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	US Bank Billing Amount
14	USB_SIC_CODE1	Character(5)	VARCHAR2(5) NOT NULL	US Bank SIC Code
15	USB_MERCH_NAME	Character(25)	VARCHAR2(25) NOT NULL	US Bank Merchant Name
16	USB_MERCH_CITY	Character(26)	VARCHAR2(26) NOT NULL	US Bank Merchant City
17	USB_MERCH_STATE	Character(3)	VARCHAR2(3) NOT NULL	US Bank Merchant State
18	USB_MERCH_CNTR_CD	Character(3)	VARCHAR2(3) NOT NULL	US Bank Merchant Country Code
19	USB_ZIP_CD	Character(9)	VARCHAR2(9) NOT NULL	US Bank zip code
20	USB_SERVC_ID	Character(6)	VARCHAR2(6) NOT NULL	US Bank Service Identifier
21	USB_EXCH_RATE	Signed Number(15,6)	DECIMAL(13,6) NOT NULL	USB source curr exchange rate
22	USB_CRDHLD_NAME	Character(25)	VARCHAR2(25) NOT NULL	US Bank Cardholder Name
23	ADVANCE_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Advance Source
24	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
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	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type
32	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
33	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes
34	EX_TYPE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expense Type Flag
35	TRANS_DT	Date(10)	DATE	Transaction Date
36	CC_POSTING_DT	Date(10)	DATE	Credit Card Posting Date
37	INVALID_EMPLID	Character(1)	VARCHAR2(1) NOT NULL	Invalid Employee
38	INVALID_EX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Invalid Expense Type
39	INVALID_MON_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Monetary Currency
40	INVALID_TXN_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Transaction Currency
41	RELOAD_TRANS_SW	Character(1)	VARCHAR2(1) NOT NULL	Reprocess Transaction
42	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
43	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
44	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor