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 |