PeopleSoft 9
Account Payables

Table Name CM_MATCHED_COST

Table Description
CM_MATCHED_COST
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT_RECV VARCHAR(5) Yes Yes
RECEIVER_ID VARCHAR(10) Yes Yes
RECV_LN_NBR int Yes Yes
RECV_SHIP_SEQ_NBR SMALLINT Yes Yes
DISTRIB_LINE_NUM int Yes Yes
MISC_CHARGE_CODE VARCHAR(10) Yes Yes
CM_SEQ_COST DECIMAL(15) Yes No
BUSINESS_UNIT_IN VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
COST_ELEMENT VARCHAR(4) No No
CM_UNIT_COST_PO DECIMAL(30,15) No No
CM_UNIT_COST_POVO DECIMAL(30,15) No No
CM_UNIT_COST_VO DECIMAL(30,15) No No
PROCESS_INSTANCE DECIMAL(10) No No
POSTED_FLAG VARCHAR(1) No No
EFF_STATUS VARCHAR(1) No No
CM_DTTM_IN_EFFECT PSDATETIME No No
CM_DTTM_STAMP PSDATETIME No No
Index
Name Type Unique Member
PS_CM_MATCHED_COST PK Yes
Member(s) of "PS_CM_MATCHED_COST" Index
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR
DISTRIB_LINE_NUM
MISC_CHARGE_CODE
CM_SEQ_COST

Published June 06, 2007