EX_KR1024_1_TAO

(SQL Table)
Index Back

Amex KR-1024 Temp Table

Temp Table for AMEX KR_1024 format.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
3 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
4 TRANS_DT Date(10) DATE Transaction Date
5 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
6 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
7 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
11 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
12 CORP_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL Corporate Number
13 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
14 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
15 SUPPLIER_NBR Character(11) VARCHAR2(11) NOT NULL Supplier Reference Nbr
16 DESCR_LN1 Character(50) VARCHAR2(50) NOT NULL Description Line 1
17 DESCR_LN2 Character(50) VARCHAR2(50) NOT NULL Description Line 2
18 DESCR_LN3 Character(50) VARCHAR2(50) NOT NULL Description Line 3
19 DESCR_LN4 Character(50) VARCHAR2(50) NOT NULL Description Line 4
20 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance