CM_PERPWO_COST

(SQL Table)

# 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_DT_TIMESTAMP_P DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0:

4 CM_SEQ_NBR_P Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:

5 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:

6 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity

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

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
Y/N Table Edit
Default Value: N

#	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_DT_TIMESTAMP_P	DateTime(26)	TIMESTAMP	07/99 GMG CN800-9.0:
4	CM_SEQ_NBR_P	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
5	CM_UNIT_COST	Signed Number(27,15)	DECIMAL(25,15) NOT NULL	07/99 GMG CN800-9.0:
6	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
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 Y/N Table Edit Default Value: N