PeopleSoft 9
Account Payables

Table Name REQ_LINE

Table Description
REQ_LINE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
REQ_ID VARCHAR(10) Yes Yes
LINE_NBR int Yes No
IN_PROCESS_FLG VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
QTY_REQ decimal(15,4) No No
ITM_SETID VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
VENDOR_SETID VARCHAR(5) No No
VENDOR_ID VARCHAR(10) No No
ITM_ID_VNDR VARCHAR(50) No No
VNDR_CATALOG_ID VARCHAR(20) No No
BUYER_ID VARCHAR(30) No No
CATEGORY_ID VARCHAR(5) No No
UNIT_OF_MEASURE VARCHAR(3) No No
MFG_ID VARCHAR(50) No No
PRICE_REQ decimal(15,5) No No
MERCHANDISE_AMT decimal(26,3) No No
INSPECT_CD VARCHAR(1) No No
SYSTEM_SOURCE VARCHAR(3) No No
SOURCE_STATUS VARCHAR(1) No No
SOURCE_DATE PSDATE No No
CURRENCY_CD VARCHAR(3) No No
PCT_UNIT_PRC_TOL decimal(5,2) No No
PCT_UNIT_PRC_TOL_L decimal(5,2) No No
UNIT_PRC_TOL decimal(13,5) No No
UNIT_PRC_TOL_L decimal(13,5) No No
INVENTORY_SRC_FLG VARCHAR(1) No No
OVERRIDE_SUGG_VNDR VARCHAR(1) No No
CONSOLIDATE_FLG VARCHAR(1) No No
ROUTING_ID VARCHAR(10) No No
RFQ_IND VARCHAR(1) No No
CURRENCY_CD_BASE VARCHAR(3) No No
UNIT_MEASURE_STD VARCHAR(3) No No
MERCH_AMT_BSE decimal(26,3) No No
QTY_REQ_STD decimal(15,4) No No
PRICE_REQ_BSE decimal(15,5) No No
UNIT_PRC_TOL_BSE decimal(13,5) No No
UNIT_PRC_TOL_BSE_L decimal(13,5) No No
DESCR254_MIXED VARCHAR(254) No No
BUSINESS_UNIT_CP VARCHAR(5) No No
CONFIG_CODE VARCHAR(50) No No
CP_TEMPLATE_ID VARCHAR(10) No No
BUSINESS_UNIT_IN VARCHAR(5) No No
ZERO_PRICE_IND VARCHAR(1) No No
VNDR_LOC VARCHAR(10) No No
PRICE_SETID VARCHAR(5) No No
PRICE_VENDOR VARCHAR(10) No No
PRICE_LOC VARCHAR(10) No No
MFG_ITM_ID VARCHAR(50) No No
CALC_PRICE_FLG VARCHAR(1) No No
REPLEN_OPT VARCHAR(2) No No
PHYSICAL_NATURE VARCHAR(1) No No
VAT_SVC_PERFRM_FLG VARCHAR(1) No No
USER_LINE_CHAR1 VARCHAR(1) No No
GPO_ID VARCHAR(18) No No
GPO_CNTRCT_NBR VARCHAR(25) No No
CHANGE_STATUS VARCHAR(1) No No
CHNG_ORD_SEQ SMALLINT No No
CURR_STATUS VARCHAR(1) No No
CC_USE_FLAG VARCHAR(1) No No
AMT_ONLY_FLG VARCHAR(1) No No
Index
Name Type Unique Member
PS_REQ_LINE PK Yes
PS0REQ_LINE IE16 No
PS1REQ_LINE IE17 No
PSAREQ_LINE IE18 No
PSBREQ_LINE IE19 No
PSCREQ_LINE IE20 No
Member(s) of "PS_REQ_LINE" Index
BUSINESS_UNIT
REQ_ID
LINE_NBR
Member(s) of "PS0REQ_LINE" Index
VENDOR_ID
BUSINESS_UNIT
REQ_ID
LINE_NBR
Member(s) of "PS1REQ_LINE" Index
BUYER_ID
BUSINESS_UNIT
REQ_ID
LINE_NBR
Member(s) of "PSAREQ_LINE" Index
SOURCE_STATUS
Member(s) of "PSBREQ_LINE" Index
PROCESS_INSTANCE
Member(s) of "PSCREQ_LINE" Index
INV_ITEM_ID
BUSINESS_UNIT_IN
BUSINESS_UNIT
REQ_ID
LINE_NBR

Published June 06, 2007