PeopleSoft 9
Account Payables

Table Name RECV_LN_SHIP_VC

Table Description
RECV_LN_SHIP_VC
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
MISC_CHARGE_CODE VARCHAR(10) Yes Yes
BUSINESS_UNIT_AP VARCHAR(5) Yes No
VOUCHER_ID VARCHAR(8) Yes No
VOUCHER_LINE_NUM int Yes No
CURRENCY_CD VARCHAR(3) No No
MISC_CHG_AMT decimal(26,3) No No
UOM_VCHR VARCHAR(3) No No
QTY_VCHR decimal(15,4) No No
QTY_VCHR_CNVT decimal(15,4) No No
CURRENCY_CD_PO VARCHAR(3) No No
MISC_CHG_AMT_CNVT decimal(26,3) No No
RATE_TYPE VARCHAR(2) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
Index
Name Type Unique Member
PS_RECV_LN_SHIP_VC PK Yes
Member(s) of "PS_RECV_LN_SHIP_VC" Index
BUSINESS_UNIT
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR
MISC_CHARGE_CODE
BUSINESS_UNIT_AP
VOUCHER_ID
VOUCHER_LINE_NUM

Published June 06, 2007