KK_SRC_FLDS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ACCT_ENTRY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Account Entry Type
3	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
4	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	CC_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Sequence number
7	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
8	DISC_SUR_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifier
9	DISC_SUR_LVL	Number(2,0)	SMALLINT NOT NULL	Discount/Surcharge Level
10	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
11	EE_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Entry Event Sequence Number
12	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
13	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
14	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
15	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.
16	HYP_LINE_NBR	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.
17	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
18	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
19	LINE_DST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Revenue Sequence Number
20	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
21	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
22	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
23	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
24	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
25	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".
26	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
27	ORIGINAL_TRANS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Accrual Original Trans
28	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
29	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
30	HP_KK_DOC_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Commitment Control Document Line #
31	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
32	HP_KK_DOC_ID	Number(31,0)	DECIMAL(31) NOT NULL	Commitment Control Document ID
33	HP_FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year when there is more than one occurence on a record
34	HP_BUDGET_YEAR	Number(4,0)	SMALLINT NOT NULL	Budget Year for Commitment Control
35	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
36	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.
37	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.
38	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.
39	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.
40	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
41	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
42	CC_GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Group Sequency
43	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
44	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
45	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
46	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
47	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.
48	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
49	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
50	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
51	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
52	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
53	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
54	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
55	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
56	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
57	TRANS_DT	Date(10)	DATE	Transaction Date
58	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.
59	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
60	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
61	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
62	KK_TRAN_LN	Number(9,0)	DECIMAL(9) NOT NULL	Commitment Control Transaction Line number.
63	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
64	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
65	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
66	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
67	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
68	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
69	KK_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control B=Budget Check C=Budget Create D=Distributed E=Posting Error K=Post to Commitment control N=None S=Security Error
70	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
71	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
72	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
73	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
74	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
75	RUN_DT	Date(10)	DATE	Run Date
76	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
77	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
78	HYP_TRAN_ID	Character(44)	VARCHAR2(44) NOT NULL	Commitment Control Foreign Key for Transaction Identification.