CM_RMATCH_COST

(SQL Table)
Index Back

RTV Matched Costs

01/2000 GMG CN800-9.0; Returns to Vendor. This record holds the actual cost credits given and fees paid for Return To Vendor (Supplier) transactions. Rows here are from AP matching of Vendor Invoices.

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