CM_CST_IBUAA_VW (SQL View)	Index Back
Costed IBU Xfer Inc Adj View 08/05/99 ebn CN#CM800-9.0 View used to update CM_INTRANSIT when generating IBU adjustment accounting entries for the ownership business unit.

CM_CST_IBUAA_VW

(SQL View)

Costed IBU Xfer Inc Adj View

08/05/99 ebn CN#CM800-9.0 View used to update CM_INTRANSIT when generating IBU adjustment accounting entries for the ownership business unit.

SELECT business_unit , inv_item_id , cm_book , transaction_group , dt_timestamp , seq_nbr , ownership_bu , posted_flag , process_instance , process_flag , 'I' FROM PS_CM_INTRANS_BOOK WHERE posted_flag = 'N' AND transaction_group = '042' AND cm_cost_proc_group = 'IBUADJI' AND cm_cost_mode = 'L'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

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

5 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

7 OWNERSHIP_BU Character(5) VARCHAR2(5) NOT NULL Business Unit Owning Inventory

8 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

10 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

11 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
4	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
5	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	OWNERSHIP_BU	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Owning Inventory
8	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
10	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
11	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