PeopleSoft 9
Asset Management

Table Name RECV_HDR

Table Description
RECV_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes No
RECEIVER_ID char(10) Yes No
BILL_OF_LADING char(30) No No
CARRIER_ID char(10) No No
CONTAINER_ID char(10) No No
COUNTRY_SHIP_FROM char(3) No No
DFLT_PACKSLIP_NO char(22) No No
DRIVER_ID char(10) No No
EIP_CTL_ID char(25) No No
ERS_FLAG char(1) No No
ERS_INV_DT_OPT char(1) No No
ERS_INV_STATUS char(1) No No
FREIGHT_TERMS char(10) No No
HOLD_ASSET char(1) No No
HOLD_INVENTORY char(1) No No
IN_PROCESS_FLG char(1) No No
INTFC_ASSET char(1) No No
INTFC_INVENTORY char(1) No No
INTFC_MG char(1) No No
INVOICE_ID char(30) No No
MATCH_CNTRL_ID char(10) No No
MATCH_PROCESS_FLG char(1) No No
MATCH_STATUS_RECV char(1) No No
NUM_OF_CARTONS decimal(11) No No
OPRID char(30) No No
ORIGIN char(3) No No
PALLETS_RECV int No No
PALLETS_RTN int No No
PO_RECEIPT_FLG char(1) No No
PORT_OF_UNLOADING char(10) No No
PRO_NUMBER char(30) No No
PROCESS_INSTANCE decimal(10) No No
SUBCONTRACT_COMP CHAR(1) No No
RECEIPT_DT PSDATE No No
RECEIPT_TM PSTIME No No
RECV_SOURCE char(1) No No
RECV_STATUS char(1) No No
SETID char(5) No Yes
SHIP_DATE PSDATE No No
SHIP_FROM_LOC char(10) No No
SHIPMENT_NO char(30) No No
SHIPTO_ID char(10) No No
VEHICLE_ID char(10) No No
VENDOR_ID char(10) No Yes
VENDOR_SETID char(5) No No
VNDR_LOC char(10) No No
POST_STATUS_RECV char(1) No No
OPRID_MODIFIED_BY char(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
USER_HDR_CHAR1 char(1) No No
Index
Name Type Unique Member
PS_RECV_HDR PK Yes
PS0RECV_HDR IE1 No
PS1RECV_HDR IE2 No
PSARECV_HDR IE3 No
PSBRECV_HDR IE4 No
PSCRECV_HDR IE5 No
PSDRECV_HDR IE6 No
Member(s) of "PS_RECV_HDR" Index
BUSINESS_UNIT
RECEIVER_ID
Member(s) of "PS0RECV_HDR" Index
SHIPTO_ID
BUSINESS_UNIT
RECEIVER_ID
Member(s) of "PS1RECV_HDR" Index
VENDOR_ID
BUSINESS_UNIT
RECEIVER_ID
Member(s) of "PSARECV_HDR" Index
PROCESS_INSTANCE
BUSINESS_UNIT
Member(s) of "PSBRECV_HDR" Index
BUSINESS_UNIT
MATCH_STATUS_RECV
RECEIVER_ID
Member(s) of "PSCRECV_HDR" Index
BUSINESS_UNIT
RECV_STATUS
MATCH_PROCESS_FLG
ERS_INV_STATUS
Member(s) of "PSDRECV_HDR" Index
RECEIPT_DT
BUSINESS_UNIT

Published December 16, 2006