CM_APRECN_TBL

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