PeopleSoft 9
Account Payables

Table Name RECV_LN_SHIP

Table Description
RECV_LN_SHIP
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
RECEIVER_ID VARCHAR(10) Yes Yes
RECV_LN_NBR int Yes Yes
RECV_SHIP_SEQ_NBR SMALLINT Yes Yes
AMT_ONLY_FLG VARCHAR(1) No No
ASN_SEQ_NBR int No No
BILL_OF_LADING VARCHAR(30) No No
BUSINESS_UNIT_IN VARCHAR(5) No No
BUSINESS_UNIT_PO VARCHAR(5) No No
BUSINESS_UNIT_FROM VARCHAR(5) No No
BILL_OF_ENTRY VARCHAR(10) No No
BOE_LINE_NBR int No No
BOE_TYPE VARCHAR(1) No No
CATEGORY_ID VARCHAR(5) No No
CONFIG_CODE VARCHAR(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 VARCHAR(3) No No
CURRENCY_CD VARCHAR(3) No No
CURRENCY_CD_BASE VARCHAR(3) No No
DESCR254_MIXED VARCHAR(254) No No
DEVICE_TRACKING VARCHAR(1) No No
DISTRIB_MTHD_FLG VARCHAR(1) No No
DUE_DT PSDATE No No
DUE_TIME PSTIME No No
EIP_CTL_ID VARCHAR(25) No No
ERS_INV_SEQ SMALLINT No No
ERS_STATUS VARCHAR(1) No No
INSPECT_CD VARCHAR(1) No No
INSPECT_DTTM PSDATETIME No No
INSPECT_STATUS VARCHAR(1) No No
INV_ITEM_ID VARCHAR(18) No No
INVOICE_ID VARCHAR(30) No No
IST_DISTRIB_STATUS VARCHAR(1) No No
ITM_ID_VNDR VARCHAR(50) No No
ITM_SETID VARCHAR(5) No No
LINE_NBR int No No
LOT_CONTROL VARCHAR(1) No No
LOT_STATUS VARCHAR(1) No No
MATCH_LINE_FLG VARCHAR(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 VARCHAR(50) No No
MFG_ITM_ID VARCHAR(50) No No
MOVE_STAT_AM VARCHAR(1) No No
MOVE_STAT_INV VARCHAR(1) No No
MOVE_STAT_MFG VARCHAR(1) No No
OP_SEQUENCE SMALLINT No No
OPRID VARCHAR(30) No No
PACKSLIP_NO VARCHAR(22) No No
PO_ID VARCHAR(10) No No
PO_TYPE VARCHAR(4) No No
PRICE_PO decimal(15,5) No No
PRICE_PO_BSE decimal(15,5) No No
PRO_NUMBER VARCHAR(30) No No
PROCESS_COMPLETE VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
PRODUCTION_ID VARCHAR(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 VARCHAR(1) No No
REJECT_REASON VARCHAR(10) No No
REVISION VARCHAR(4) No No
RMA_ID VARCHAR(10) No No
RMA_LINE_NBR int No No
RECEIPT_ALLOC_TYPE VARCHAR(1) No No
RECEIPT_DTTM PSDATETIME No No
RECEIPT_UM VARCHAR(3) No No
RECEIVE_UOM VARCHAR(3) No No
RECV_LN_MATCH_OPT VARCHAR(1) No No
RECV_SHIP_STATUS VARCHAR(1) No No
RECV_STOCK_UOM VARCHAR(3) No No
REPLACEMENT_FLG VARCHAR(2) No No
SCHED_NBR SMALLINT No No
SERIAL_CONTROL VARCHAR(1) No No
SERIAL_STATUS VARCHAR(1) No No
SHIP_DATE_STATUS VARCHAR(1) No No
SHIP_QTY_STATUS VARCHAR(1) No No
SHIPTO_ID VARCHAR(10) No No
UNIT_MEASURE_STD VARCHAR(3) No No
USER_LINE_CHAR1 VARCHAR(1) No No
USER_SCHED_CHAR1 VARCHAR(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 June 06, 2007