KK_SOURCE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
5	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
6	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
7	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
8	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
9	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
10	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
11	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
12	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
13	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
14	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
15	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
16	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
17	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
18	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
19	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
20	CC_GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Group Sequency
21	CC_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Sequence number
22	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
23	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
24	ACCT_ENTRY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Account Entry Type
25	DISC_SUR_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifier
26	DISC_SUR_LVL	Number(2,0)	SMALLINT NOT NULL	Discount/Surcharge Level
27	LINE_DST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Revenue Sequence Number
28	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
29	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
30	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
31	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
32	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
33	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
34	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
35	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
36	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
37	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
38	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
39	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
40	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
41	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
42	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
43	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
44	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
45	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
46	TRANS_DT	Date(10)	DATE	Transaction Date
47	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.
48	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
49	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
50	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
51	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
52	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
53	KK_TRAN_LN	Number(9,0)	DECIMAL(9) NOT NULL	Commitment Control Transaction Line number.
54	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
55	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization