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 |