EX_AIR_TKT_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CC_TRXID	Number(18,0)	DECIMAL(18) NOT NULL	Used for the SABRE/BTS Data Feed/Import. Unique number generated by SABRE BTS. Links rows to the Outbound Trip Data Table.
2	CC_ACCT_NUM	Character(20)	VARCHAR2(20) NOT NULL	Cardmember Number
3	TRAN_REF_NUM	Character(23)	VARCHAR2(23) NOT NULL	Merchant Assigned Reference Number
4	TRAN_DATE	Character(10)	VARCHAR2(10) NOT NULL	Transaction Date
5	POST_DATE	Character(10)	VARCHAR2(10) NOT NULL	Post Date
6	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
7	MERCHANT_NAME	Character(25)	VARCHAR2(25) NOT NULL	Credit Card Merchant Name
8	MERCHANT_CITY	Character(26)	VARCHAR2(26) NOT NULL	City
9	MERCHANT_STATE	Character(3)	VARCHAR2(3) NOT NULL	State
10	MERCHANT_COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
11	MERCHANT_ZIP	Character(10)	VARCHAR2(10) NOT NULL	Postal Code
12	SOURCE_CURR_CODE	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
13	SOURCE_CURR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
14	BILLING_CURR_CODE	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	BILLING_CURR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount
16	CARD_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Credit Card Transaction Code
17	VENDOR_CODE	Character(6)	VARCHAR2(6) NOT NULL	Vendor Code from Credit Card Feed
18	VENDOR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Vendor Type ADV=Ads CNS=Consultant CNT=Contractor ENT=Entertain FRG=Foreign GVT=Government MNR=Minority PR=PR TRD=Tradesman TRN=Transport TRV=Travel
19	EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	EmplID