CM_APRECN_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
5	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
6	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
7	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
8	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
9	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
10	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
11	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
13	APGL_RECN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Report Option D=Journal Date J=Journal ID P=Accounting Period
14	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
15	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
16	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	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.
19	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
20	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
22	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
23	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
24	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
25	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
26	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
27	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
28	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
29	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
30	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
31	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
32	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
33	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
34	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
35	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
36	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
37	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
38	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
39	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
40	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
41	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.
42	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
43	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.
44	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
45	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.
46	TRANSACTION_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Transaction Source
47	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
48	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
49	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
50	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
51	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
52	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: CM_DISTR_TYPE
53	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
54	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element Prompt Table: CM_ELEMENT
55	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
56	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal