PeopleSoft 9
Account Payables

Table Name RTV_HDR

Table Description
RTV_HDR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
RTV_ID VARCHAR(10) Yes No
ACTIVITY_DATE PSDATE No No
ADDRESS_SEQ_NUM INT No No
BILL_OF_LADING VARCHAR(30) No No
BUYER_ID VARCHAR(30) No No
CARRIER_ID VARCHAR(10) No No
CNTCT_SEQ_NUM INT No No
DISPATCH_FLAG VARCHAR(1) No No
ENTERED_BY VARCHAR(30) No No
ENTERED_DT PSDATE No No
FREIGHT_TERMS VARCHAR(10) No No
IN_PROCESS_FLG VARCHAR(1) No No
MODIFIED_DT PSDATE No No
OPRID_MODIFIED_BY VARCHAR(30) No No
PROCESS_INSTANCE decimal(10) No No
RETURN_SETID VARCHAR(5) No No
RETURN_VENDOR VARCHAR(10) No No
RTV_ADJ_FEES VARCHAR(1) No No
RTV_ADJ_FLG VARCHAR(1) No No
RTV_ADJ_SOURCE VARCHAR(1) No No
RTV_DEBIT_MEMO VARCHAR(1) No No
RTV_DISPATCH_METH VARCHAR(3) No No
RTV_NOTIFY_METH VARCHAR(3) No No
RTV_STATUS VARCHAR(1) No No
SHIP_TYPE_ID VARCHAR(10) No No
VCHR_ADJ_STATUS VARCHAR(1) No No
VENDOR_ID VARCHAR(10) No No
VENDOR_SETID VARCHAR(5) No No
VNDR_LOC VARCHAR(10) No No
USER_HDR_CHAR1 VARCHAR(1) No No
Index
Name Type Unique Member
PS_RTV_HDR PK Yes
PS0RTV_HDR IE7 No
PS1RTV_HDR IE8 No
Member(s) of "PS_RTV_HDR" Index
BUSINESS_UNIT
RTV_ID
Member(s) of "PS0RTV_HDR" Index
BUYER_ID
BUSINESS_UNIT
RTV_ID
Member(s) of "PS1RTV_HDR" Index
VENDOR_ID
BUSINESS_UNIT
RTV_ID

Published June 06, 2007