PeopleSoft 9
Account Payables

Table Name CM_RMATCH_COST

Table Description
CM_RMATCH_COST
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT_RECV VARCHAR(5) Yes Yes
RTV_ID VARCHAR(10) Yes Yes
RTV_LN_NBR int Yes Yes
RTV_DISTRIB_NUM int Yes Yes
MISC_CHARGE_CODE VARCHAR(10) Yes No
CM_SEQ_COST decimal(15) Yes No
PROCESS_INSTANCE decimal(10) Yes No
RECEIVER_ID VARCHAR(10) No Yes
RECV_LN_NBR int No Yes
RECV_SHIP_SEQ_NBR SMALLINT No Yes
DISTRIB_LINE_NUM int No Yes
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
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_RMATCH_COST PK Yes
PSACM_RMATCH_COST IE1 No
Member(s) of "PS_CM_RMATCH_COST" Index
BUSINESS_UNIT_RECV
RTV_ID
RTV_LN_NBR
RTV_DISTRIB_NUM
MISC_CHARGE_CODE
CM_SEQ_COST
PROCESS_INSTANCE
Member(s) of "PSACM_RMATCH_COST" Index
BUSINESS_UNIT_IN
POSTED_FLAG

Published June 06, 2007