CC_TRANDST_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
4	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
5	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
7	TRANS_DT	Date(10)	DATE	Transaction Date
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
9	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
11	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
12	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
13	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
14	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
15	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
16	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
17	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
18	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
19	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
20	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
21	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
22	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
23	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
24	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
25	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
26	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
27	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
28	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
29	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
30	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
31	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
32	CHARTFIELD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Status R=Recycled V=Valid
33	CC_POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Post and Payment Status 0=Not Processed 1=Initial Posted 2=Payment Created 3=Payment Posted 4=Final Posted 5=PO Posted 6=Voucher Build Error
34	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
35	DISTRIB_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Distribution Percentage
36	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
37	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
38	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
39	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
40	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
41	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
42	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
43	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
44	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
45	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
46	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
47	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
48	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
49	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
50	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
51	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
52	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
53	CAP_NUM	Character(15)	VARCHAR2(15) NOT NULL	Capital Acquisition Plan #
54	CAP_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	CAP Sequence
55	FINANCIAL_ASSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Capitalized Asset N=Non Cap Y=Capitalize
56	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
57	SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Sales Tax Amount
58	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
59	USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Use Tax Amount
60	SALETX_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Paid Amount
61	SALETX_PAID_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Paid Base Amount
62	USETAX_PAID	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use Tax Paid Amount
63	USETAX_PAID_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use Tax Paid Base Amount
64	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.
65	MONETARY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base
66	BUDGET_DT	Date(10)	DATE	Budget Date
67	BUDGET_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	-> SL - 15-AUG-2002 MISC_CRITERIA label has been added <- B=Bypass E=Error N=Not Chk'd V=Valid W=Warning
68	KK_CLOSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Close Flag
69	PROCARD_PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Procard Payment ID
70	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
71	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
72	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
73	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
74	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
75	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
76	PO_DIST_LINE_NUM	Number(5,0)	INTEGER NOT NULL	PO Distribution Line Number
77	USER_DIST_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
78	CUSTOM_C100_D1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
79	CUSTOM_C100_D2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
80	CUSTOM_C100_D3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
81	CUSTOM_C100_D4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
82	CUSTOM_DATE_D	Date(10)	DATE	Custom Date
83	CUSTOM_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
84	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code