PeopleSoft 9
Asset Management

Table Name RECV_LN_SHIP

Table Description
RECV_LN_SHIP
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
RECEIVER_ID char(10) Yes Yes
RECV_LN_NBR int Yes No
RECV_SHIP_SEQ_NBR smallint Yes No
AMT_ONLY_FLG char(1) No No
ASN_SEQ_NBR int No No
BILL_OF_LADING char(30) No No
BUSINESS_UNIT_IN char(5) No No
BUSINESS_UNIT_PO char(5) No No
BUSINESS_UNIT_FROM char(5) No No
BILL_OF_ENTRY char(10) No No
BOE_LINE_NBR int No No
BOE_TYPE char(1) No No
CATEGORY_ID char(5) No No
CONFIG_CODE char(50) No No
CONVERSION_RATE decimal(15,8) No No
CONVERT_TO_STK decimal(15,8) No No
CONVERT_TO_PO decimal(15,8) No No
CONVERT_STK_TO_STD decimal(15,8) No No
COUNTRY_IST_ORIGIN char(3) No No
CURRENCY_CD char(3) No No
CURRENCY_CD_BASE char(3) No No
DESCR254_MIXED char(254) No No
DEVICE_TRACKING char(1) No No
DISTRIB_MTHD_FLG char(1) No No
DUE_DT PSDATE No No
DUE_TIME PSTIME No No
EIP_CTL_ID char(25) No No
ERS_INV_SEQ smallint No No
ERS_STATUS char(1) No No
INSPECT_CD char(1) No No
INSPECT_DTTM PSDATETIME No No
INSPECT_STATUS char(1) No No
INV_ITEM_ID char(18) No No
INVOICE_ID char(30) No No
IST_DISTRIB_STATUS char(1) No No
ITM_ID_VNDR char(50) No No
ITM_SETID char(5) No No
LINE_NBR int No No
LOT_CONTROL char(1) No No
LOT_STATUS char(1) No No
MATCH_LINE_FLG char(1) No No
MATCH_STATUS_LC smallint No No
MERCH_AMT_BSE decimal(26,3) No No
MERCH_AMT_PO_BSE decimal(26,3) No No
MERCHANDISE_AMT decimal(26,3) No No
MERCHANDISE_AMT_PO decimal(26,3) No No
MFG_ID char(50) No No
MFG_ITM_ID char(50) No No
MOVE_STAT_AM char(1) No No
MOVE_STAT_INV char(1) No No
MOVE_STAT_MFG char(1) No No
OP_SEQUENCE smallint No No
OPRID char(30) No No
PACKSLIP_NO char(22) No No
PO_ID char(10) No No
PO_TYPE char(4) No No
PRICE_PO decimal(15,5) No No
PRICE_PO_BSE decimal(15,5) No No
PRO_NUMBER char(30) No No
PROCESS_COMPLETE char(1) No No
PROCESS_INSTANCE decimal(10) No No
PRODUCTION_ID char(10) No No
QTY_LN_ASSET_SUOM decimal(15,4) No No
QTY_LN_INV_SUOM decimal(15,4) No No
QTY_SH_ACCPT decimal(15,4) No No
QTY_SH_ACCPT_SUOM decimal(15,4) No No
QTY_SH_ACCPT_VUOM decimal(15,4) No No
QTY_SH_INSPD decimal(15,4) No No
QTY_SH_INSPD_SUOM decimal(15,4) No No
QTY_SH_INSPD_VUOM decimal(15,4) No No
QTY_SH_NETRCV_VUOM decimal(15,4) No No
QTY_SH_RECVD decimal(15,4) No No
QTY_SH_RECVD_SUOM decimal(15,4) No No
QTY_SH_RECVD_VUOM decimal(15,4) No No
QTY_SH_REJCT decimal(15,4) No No
QTY_SH_REJCT_SUOM decimal(15,4) No No
QTY_SH_REJCT_VUOM decimal(15,4) No No
QTY_SH_RTN decimal(15,4) No No
QTY_SH_RTN_SUOM decimal(15,4) No No
QTY_SH_RTN_VUOM decimal(15,4) No No
REJECT_ACTION char(1) No No
REJECT_REASON char(10) No No
REVISION char(4) No No
RMA_ID char(10) No No
RMA_LINE_NBR int No No
RECEIPT_ALLOC_TYPE char(1) No No
RECEIPT_DTTM PSDATETIME No No
RECEIPT_UM char(3) No No
RECEIVE_UOM char(3) No No
RECV_LN_MATCH_OPT char(1) No No
RECV_SHIP_STATUS char(1) No No
RECV_STOCK_UOM char(3) No No
REPLACEMENT_FLG char(2) No No
SCHED_NBR smallint No No
SERIAL_CONTROL char(1) No No
SERIAL_STATUS char(1) No No
SHIP_DATE_STATUS char(1) No No
SHIP_QTY_STATUS char(1) No No
SHIPTO_ID char(10) No No
UNIT_MEASURE_STD char(3) No No
USER_LINE_CHAR1 char(1) No No
USER_SCHED_CHAR1 char(1) No No
Index
Name Type Unique Member
PS_RECV_LN_SHIP PK Yes
PS0RECV_LN_SHIP IE1 No
PSARECV_LN_SHIP IE1 No
PSCRECV_LN_SHIP IE2 No
Member(s) of "PS_RECV_LN_SHIP" Index
BUSINESS_UNIT
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR
Member(s) of "PS0RECV_LN_SHIP" Index
CATEGORY_ID
BUSINESS_UNIT
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR
Member(s) of "PSARECV_LN_SHIP" Index
BUSINESS_UNIT_PO
PO_ID
LINE_NBR
SCHED_NBR
Member(s) of "PSCRECV_LN_SHIP" Index
PO_ID
BUSINESS_UNIT_IN
BUSINESS_UNIT
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR

Published December 16, 2006