PeopleSoft 9
Asset Management

Table Name RECV_LN_ASSET

Table Description
RECV_LN_ASSET
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
RECEIVER_ID char(10) Yes Yes
RECV_LN_NBR int Yes Yes
RECV_SHIP_SEQ_NBR smallint Yes Yes
DISTRIB_LINE_NUM int Yes Yes
DISTRIB_SEQ_NUM int Yes No
ACTUAL_COST decimal(14,4) No No
ASSET_ID char(12) No No
AUTO_BIN2BIN char(1) No No
BUSINESS_UNIT_AM char(5) No No
BUSINESS_UNIT_IN char(5) No No
CONTAINER_ID char(10) No No
COST decimal(26,3) No No
CURRENCY_CD char(3) No No
CUSTODIAN char(30) No No
DESCR char(30) No No
DTTM_STAMP PSDATETIME No No
EXPIRATION_DATE PSDATE No No
FINANCIAL_ASSET_SW char(1) No No
FROM_STOR_AREA char(5) No No
FROM_STOR_LEV1 char(4) No No
FROM_STOR_LEV2 char(4) No No
FROM_STOR_LEV3 char(4) No No
FROM_STOR_LEV4 char(4) No No
INV_ITEM_ID char(18) No No
ITM_SETID char(5) No No
LOCATION char(10) No No
LOT_ID char(15) No No
MANUFACTURER char(30) No No
MFG_ID char(50) No No
MODEL char(30) No No
PRE_INTFC_ID int No No
PRE_INTFC_LINE_NUM int No No
PRICE_PO_BSE decimal(15,5) No No
PROCESS_INSTANCE decimal(10) No No
PROFILE_ID char(10) No No
QTY_MOVED_ASSET decimal(15,4) No No
QTY_MOVED_INV decimal(15,4) No No
QUANTITY decimal(15,4) No No
RECV_AM_STATUS char(1) No No
SERIAL_ID char(20) No No
SF_KANBAN_ID char(15) No No
STORAGE_AREA char(5) No No
STORAGE_CODE char(4) No No
STOR_LEVEL_1 char(4) No No
STOR_LEVEL_2 char(4) No No
STOR_LEVEL_3 char(4) No No
STOR_LEVEL_4 char(4) No No
TAG_NUMBER char(12) No No
VENDOR_ID char(10) No No
VENDOR_LOT_ID char(15) No No
VIN char(18) No No
USER_RECV_CHAR1 char(1) No No
Index
Name Type Unique Member
PS_RECV_LN_ASSET PK Yes
PSARECV_LN_ASSET IE1 No
Member(s) of "PS_RECV_LN_ASSET" Index
BUSINESS_UNIT
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR
DISTRIB_LINE_NUM
DISTRIB_SEQ_NUM
Member(s) of "PSARECV_LN_ASSET" Index
INV_ITEM_ID
BUSINESS_UNIT_IN
BUSINESS_UNIT
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR

Published December 16, 2006