PeopleSoft 9
Account Payables

Table Name RTV_LN

Table Description
RTV_LN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
RTV_ID VARCHAR(10) Yes Yes
RTV_LN_NBR int Yes No
ACTUAL_COST decimal(14,4) No No
ASSET_FLG VARCHAR(1) 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_RECV VARCHAR(5) No No
CARRIER_ID VARCHAR(10) No No
CONVERSION_RATE decimal(15,8) No No
CURRENCY_CD VARCHAR(3) No No
CURRENCY_CD_BASE VARCHAR(3) No No
DESCR254_MIXED VARCHAR(254) No No
DISPOSITION_TYPE VARCHAR(1) No No
DISTRIB_MTHD_FLG VARCHAR(1) No No
INV_FLG VARCHAR(1) No No
INV_ITEM_ID VARCHAR(18) No No
IST_TXN_FLG VARCHAR(1) No No
ITM_SETID VARCHAR(5) No No
LINE_NBR int No No
LOT_CONTROL VARCHAR(1) No No
MATCH_STATUS VARCHAR(1) No No
OP_SEQUENCE SMALLINT No No
PO_ID VARCHAR(10) No No
PO_STATUS VARCHAR(2) No No
PRICE_PO decimal(15,5) No No
PRICE_PO_BSE decimal(15,5) No No
PRODUCTION_ID VARCHAR(10) No No
QTY_LN_RETRN_SUOM decimal(15,4) No No
QTY_LN_RETRN_VUOM decimal(15,4) No No
QTY_LN_SHIP_SUOM decimal(15,4) No No
QTY_LN_SHIP_VUOM decimal(15,4) No No
QTY_PO_INTFC decimal(15,4) No No
QTY_RECV_INTFC decimal(15,4) No No
RATE_DATE PSDATE No No
RATE_DIV decimal(15,8) No No
RATE_MULT decimal(15,8) No No
RT_TYPE VARCHAR(5) No No
RECEIVER_ID VARCHAR(10) No No
RECV_LN_NBR int No No
RECV_SHIP_SEQ_NBR SMALLINT No No
RECV_REQ VARCHAR(1) No No
RETURN_ACTION VARCHAR(1) No No
RETURN_REASON VARCHAR(10) No No
REVISION VARCHAR(4) No No
RMA_ID VARCHAR(10) No No
RMA_LINE_NBR int No No
RTV_LN_STATUS VARCHAR(1) No No
SCHED_NBR SMALLINT No No
SERIAL_CONTROL VARCHAR(1) No No
SHIP_TYPE_ID VARCHAR(10) No No
SOURCE_MATCH_FLAG VARCHAR(1) No No
UNIT_MEASURE_STD VARCHAR(3) No No
UNIT_MEASURE_VNDR VARCHAR(3) No No
VNDR_RTV_ACTION VARCHAR(1) No No
USER_LINE_CHAR1 VARCHAR(1) No No
USER_SCHED_CHAR1 VARCHAR(1) No No
Index
Name Type Unique Member
PS_RTV_LN PK Yes
Member(s) of "PS_RTV_LN" Index
BUSINESS_UNIT
RTV_ID
RTV_LN_NBR

Published June 06, 2007