CM_MATCHED_COST (SQL Table)	Index Back
AP Matched Costs 04/99 GMG CN800-9.0; Created to hold the the result of AP matching, and the amount paid in terms of the PO's exchange (PPV) rate and in terms of the vouchers exchange rate (for ERV).

CM_MATCHED_COST

(SQL Table)

AP Matched Costs

04/99 GMG CN800-9.0; Created to hold the the result of AP matching, and the amount paid in terms of the PO's exchange (PPV) rate and in terms of the vouchers exchange rate (for ERV).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

6 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

7 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.

8 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

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

10 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

11 CM_UNIT_COST_PO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:

12 CM_UNIT_COST_POVO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:

13 CM_UNIT_COST_VO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:

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

15 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

16 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

17 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp

18 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
4	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
6	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
7	CM_SEQ_COST	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number. Incremented each time the actual cost is updated.
8	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
11	CM_UNIT_COST_PO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
12	CM_UNIT_COST_POVO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
13	CM_UNIT_COST_VO	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	07/99 GMG CN800-9.0:
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	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
16	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
17	CM_DTTM_IN_EFFECT	DateTime(26)	TIMESTAMP	Date Timestamp
18	CM_DTTM_STAMP	DateTime(26)	TIMESTAMP	Date Timestamp