CM_ACCT_LIB_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
6	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success
7	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
10	AS_OF_DATE	Date(10)	DATE	As of Date
11	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
12	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
13	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
14	DTTM_STAMP_SEC	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.
15	MULTICURRENCY	Character(1)	VARCHAR2(1) NOT NULL	Multi-Currency
16	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
17	CM_GROUP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Group SetID
18	SOURCE_BU_SETID	Character(5)	VARCHAR2(5) NOT NULL	Source BU/SETID
19	SETID_MST_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Master Item SETID
20	LOC_ACCTG_REQ	Character(1)	VARCHAR2(1) NOT NULL	Location Accounting Required
21	MG	Character(1)	VARCHAR2(1) NOT NULL	Manufacturing
22	COMMITMENT_CNTL_IN	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control on IN
23	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
24	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
25	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
26	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
27	CUR_RT_TYPE_DFLT	Character(5)	VARCHAR2(5) NOT NULL	Exchange Rate Type Default
28	RECNAME1	Character(15)	VARCHAR2(15) NOT NULL	Record Name 1
29	TEMP_VALUE	Character(18)	VARCHAR2(18) NOT NULL	Temporary Query Value
30	SETCNTRLVALUE_NEW	Character(20)	VARCHAR2(20) NOT NULL	New User Key value for TREE_CHANGE PubSub message
31	ALTACCT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Enable Alternate Account
32	COMMITMENT_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Enable Commitment Control
33	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
34	RECNAME_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Source Recname
35	RECNAME_TRANS	Character(18)	VARCHAR2(18) NOT NULL	Selected Transactions
36	RECNAME_UPDATE	Character(15)	VARCHAR2(15) NOT NULL	Record to Update
37	CM_DR_LOC_ACCT_OFF	Character(18)	VARCHAR2(18) NOT NULL	CM Dr Definition; Loc Acct Off
38	CM_DR_LOC_ACCT_ON	Character(18)	VARCHAR2(18) NOT NULL	CM Dr Definition; Loc Acct On
39	CM_CR_LOC_ACCT_OFF	Character(18)	VARCHAR2(18) NOT NULL	CM Cr Definition; Loc Acct Off
40	CM_CR_LOC_ACCT_ON	Character(18)	VARCHAR2(18) NOT NULL	CM Cr Definition; Loc Acct On
41	ADJUST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Type 0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV
42	CM_PRIME_TRAN	Character(1)	VARCHAR2(1) NOT NULL	Primary Transaction for Group
43	CM_COST_PROC_GROUP	Character(18)	VARCHAR2(18) NOT NULL	Cost Flow Record
44	CM_SOURCE_RECORD	Character(18)	VARCHAR2(18) NOT NULL	CM Transaction Source Record
45	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
46	CM_RECNAME_UPDATE	Character(15)	VARCHAR2(15) NOT NULL	Record to Update
47	CM_CF_OVRRID_DR_CR	Character(2)	VARCHAR2(2) NOT NULL	CM Override DR or CR CR=Credit DR=Debit
48	CM_RULE_GROUP	Character(3)	VARCHAR2(3) NOT NULL	Accounting Rule Group
49	CONS_RULE_GROUP	Character(3)	VARCHAR2(3) NOT NULL	Consignment Rule Group
50	CM_EXTEND_COST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Extend Cost?
51	CM_MFG_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mfg only transaction?
52	COUNTER1	Number(16,2)	DECIMAL(15,2) NOT NULL	Counter 1
53	SELECT_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Select Clause
54	SELECT_CLAUSE2	Character(254)	VARCHAR2(254) NOT NULL	Select Clause 2
55	FROM_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	From Clause
56	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
57	CM_CR_ACCT_TBL	Character(18)	VARCHAR2(18) NOT NULL	CR Account
58	CM_DR_ACCT_TBL	Character(18)	VARCHAR2(18) NOT NULL	Debit Account
59	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
60	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
61	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
62	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
63	RULE_ORDER	Number(3,0)	SMALLINT NOT NULL	Rule Order
64	CM_SQL_EXPLODE	Character(18)	VARCHAR2(18) NOT NULL	Explode Table
65	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
66	POST_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Posting Option
67	CM_RULE	Number(2,0)	SMALLINT NOT NULL	Accounting Rule Number
68	DEBIT_CREDIT	Character(2)	VARCHAR2(2) NOT NULL	Debit / Credit Indicator CR=Credit DR=Debit
69	CM_DR_TMP	Character(18)	VARCHAR2(18) NOT NULL	Debit Temp Table
70	CM_CR_TMP	Character(18)	VARCHAR2(18) NOT NULL	Credit Temp Table
71	MAX_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Maximum Sequence Number
72	IU_ANCHOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
73	CM_IU_ANCHOR	Character(2)	VARCHAR2(2) NOT NULL	GMG added 8/2001. Defines if the Inter/Intra Unit anchor row will be the DR or the CR.
74	CM_IU_STATUS	Character(1)	VARCHAR2(1) NOT NULL	IntraUnit Status B=Balanced E=Error H=Hold for other BU's affiliates I=Ignore N=Not Balanced P=In Process S=Staged X=Balancing Not Required
75	IU_SYS_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
76	GEN_BAL_ENTRIES	Character(1)	VARCHAR2(1) NOT NULL	IntraUnit Balancing Entries
77	IU_LEGAL_ENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Legal Entity for InterUnit
78	IU_METHOD	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Method D=Direct I=Indirect P=Pairs
79	IU_ENTRY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Entry Type AEAP=IntraEntity Accrued Payable AECG=IntraEntity Cost of Goods AECS=IntraEntity Customer Shipments AEEX=IntraEntity Expense AEPY=IntraEntity Payable AERC=IntraEntity Receivable AERV=IntraEntity Revenue AETR=IntraEntity In Transit AUEX=IntraUnit Expense AUPY=IntraUnit Payable AURC=IntraUnit Receivable AURV=IntraUnit Revenue AUTR=IntraUnit In Transit IEAP=InterEntity Accrued Payable IECG=InterEntity Cost of Goods IECS=InterEntity Customer Shipments IEEX=InterEntity Expense IEPY=InterEntity Payable IERC=InterEntity Receivable IERV=InterEntity Revenue IETR=InterEntity In Transit IUAP=InterUnit Accrued Payable IUCG=InterUnit Cost of Goods IUCS=InterUnit Customer Shipments IUEX=InterUnit Expense IUPY=InterUnit Payable IURC=InterUnit Receivable IURV=InterUnit Revenue IUTR=InterUnit In Transit
80	IUNIT_VALUES	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Transaction Options 1=Use GL BU Settings Only 2=Use IN BU Settings Only 3=Use Both
81	CM_ERROR_CODE	Character(4)	VARCHAR2(4) NOT NULL	Account Line Creation Error INTR=No InterUnit Rules PROD=No Production Area Rule RULE=No Account Distribution Rule STOR=No Storage Area Rule
82	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
83	CM_DR_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Debit Rows
84	CM_CR_ROWS	Number(15,0)	DECIMAL(15) NOT NULL	Credit Rows
85	CM_RULENUM	Number(3,0)	SMALLINT NOT NULL	Rule Number
86	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
87	CM_UPDATE_STATS	Character(1)	VARCHAR2(1) NOT NULL	Generate Table Statistics
88	CM_UPDATE_STATS_DE	Character(1)	VARCHAR2(1) NOT NULL	11/01 mxs
89	CM_PARALLEL_OK	Character(1)	VARCHAR2(1) NOT NULL	CM_PARALLEL_OK
90	CE_ITEMCVAR_PSB	Character(1)	VARCHAR2(1) NOT NULL	Item Variance Table Default Value: Y
91	CM_COST_ADJB	Character(1)	VARCHAR2(1) NOT NULL	Cost Adjustment Table Default Value: Y
92	CM_CST_NSSHIPB	Character(1)	VARCHAR2(1) NOT NULL	Ship Table Default Value: Y
93	SF_EARNCONCOSTB	Character(1)	VARCHAR2(1) NOT NULL	Earned Cost Table Default Value: Y
94	SF_SCRAPCOSTB	Character(1)	VARCHAR2(1) NOT NULL	Scrap Cost Table Default Value: Y
95	SF_VARIANCESB	Character(1)	VARCHAR2(1) NOT NULL	Variance Table Default Value: Y
96	AFFILIATE_USE	Character(1)	VARCHAR2(1) NOT NULL	Use Affiliate
97	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
98	IU_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
99	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
100	WHERE_CLAUSE6	Character(254)	VARCHAR2(254) NOT NULL	Where Clause