CM_ACCTG_IU_VW

(SQL View)

SELECT DISTINCT BUSINESS_UNIT , TRANSACTION_GROUP , ACCOUNTING_DT , ACCTG_LINE_NO , CM_IU_STATUS FROM PS_CM_ACCTG_IU_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

2 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

3 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple

4 ACCTG_LINE_NO Number(15,0) DECIMAL(15) NOT NULL Accounting Line Number

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
2	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
3	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
4	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
5	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