PeopleSoft 9
Account Payables

Table Name VCHR_BLD_RECV

Table Description
VCHR_BLD_RECV
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VCHR_BLD_CODE VARCHAR(6) Yes Yes
LINE_NBR INT Yes No
SEQ_NUM SMALLINT No No
VENDOR_FLG VARCHAR(1) No No
RECV_DOC_REF_OPT VARCHAR(1) No No
RECV_LINE_OPT VARCHAR(1) No No
ITEM_OPT VARCHAR(1) No No
PO_LINE_OPT VARCHAR(1) No No
RECV_QTY_OPT VARCHAR(1) No No
QTY_TOL_OPT VARCHAR(1) No No
USER_BLD_OPT VARCHAR(1) No No
USER_BLD_CLAUSE VARCHAR(254) No No
BLD_CLAUSE1 VARCHAR(254) No No
BLD_CLAUSE2 VARCHAR(254) No No
BLD_CLAUSE3 VARCHAR(254) No No
BLD_CLAUSE4 VARCHAR(254) No No
FRM_CLAUSE1 VARCHAR(254) No No
BLD_CLAUSE_PB VARCHAR(1) No No
USER_CLAUSE_PB VARCHAR(5) No No
BLD_CLAUSE_LONG VARCHAR(1024) No No
Index
Name Type Unique Member
PS_VCHR_BLD_RECV PK Yes
Member(s) of "PS_VCHR_BLD_RECV" Index
SETID
VCHR_BLD_CODE
LINE_NBR

Published June 06, 2007