PeopleSoft 9
Account Payables

Table Name RECV_HDR

Table Description
RECV_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
RECEIVER_ID VARCHAR(10) Yes No
BILL_OF_LADING VARCHAR(30) No No
CARRIER_ID VARCHAR(10) No No
CONTAINER_ID VARCHAR(10) No No
COUNTRY_SHIP_FROM VARCHAR(3) No No
DFLT_PACKSLIP_NO VARCHAR(22) No No
DRIVER_ID VARCHAR(10) No No
EIP_CTL_ID VARCHAR(25) No No
ERS_FLAG VARCHAR(1) No No
ERS_INV_DT_OPT VARCHAR(1) No No
ERS_INV_STATUS VARCHAR(1) No No
FREIGHT_TERMS VARCHAR(10) No No
HOLD_ASSET VARCHAR(1) No No
HOLD_INVENTORY VARCHAR(1) No No
IN_PROCESS_FLG VARCHAR(1) No No
INTFC_ASSET VARCHAR(1) No No
INTFC_INVENTORY VARCHAR(1) No No
INTFC_MG VARCHAR(1) No No
INVOICE_ID VARCHAR(30) No No
MATCH_CNTRL_ID VARCHAR(10) No No
MATCH_PROCESS_FLG VARCHAR(1) No No
MATCH_STATUS_RECV VARCHAR(1) No No
NUM_OF_CARTONS decimal(11) No No
OPRID VARCHAR(30) No No
ORIGIN VARCHAR(3) No No
PALLETS_RECV int No No
PALLETS_RTN int No No
PO_RECEIPT_FLG VARCHAR(1) No No
PORT_OF_UNLOADING VARCHAR(10) No No
PRO_NUMBER VARCHAR(30) No No
PROCESS_INSTANCE decimal(10) No No
SUBCONTRACT_COMP VARCHAR(1) No No
RECEIPT_DT PSDATE No No
RECEIPT_TM PSTIME No No
RECV_SOURCE VARCHAR(1) No No
RECV_STATUS VARCHAR(1) No No
SETID VARCHAR(5) No Yes
SHIP_DATE PSDATE No No
SHIP_FROM_LOC VARCHAR(10) No No
SHIPMENT_NO VARCHAR(30) No No
SHIPTO_ID VARCHAR(10) No No
VEHICLE_ID VARCHAR(10) No No
VENDOR_ID VARCHAR(10) No Yes
VENDOR_SETID VARCHAR(5) No No
VNDR_LOC VARCHAR(10) No Yes
POST_STATUS_RECV VARCHAR(1) No No
OPRID_MODIFIED_BY VARCHAR(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
USER_HDR_CHAR1 VARCHAR(1) No No
Index
Name Type Unique Member
PS_RECV_HDR PK Yes
PS0RECV_HDR IE21 No
PS1RECV_HDR IE22 No
PSARECV_HDR IE23 No
PSBRECV_HDR IE24 No
PSCRECV_HDR IE25 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 June 06, 2007