PeopleSoft 9
Account Payables

Table Name PO_LINE

Table Description
PO_LINE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
PO_ID VARCHAR(10) Yes Yes
LINE_NBR int Yes No
CANCEL_STATUS VARCHAR(1) No No
CHANGE_STATUS VARCHAR(1) No No
ITM_SETID VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
ITM_ID_VNDR VARCHAR(50) No No
VNDR_CATALOG_ID VARCHAR(20) No No
CATEGORY_ID VARCHAR(5) No No
CHNG_ORD_SEQ SMALLINT No No
UNIT_OF_MEASURE VARCHAR(3) No No
QTY_TYPE VARCHAR(1) No No
PRICE_DT_TYPE VARCHAR(1) No No
MFG_ID VARCHAR(50) No No
MFG_ITM_ID VARCHAR(50) No No
CNTRCT_SETID VARCHAR(5) No No
CNTRCT_ID VARCHAR(25) No No
CNTRCT_LINE_NBR int No No
RELEASE_NBR int No No
MILESTONE_NBR int No No
CNTRCT_RATE_MULT decimal(15,8) No No
CNTRCT_RATE_DIV decimal(15,8) No No
VRBT_ID VARCHAR(25) No No
RFQ_ID VARCHAR(10) No No
RFQ_LINE_NBR int No No
INSPECT_CD VARCHAR(1) No No
ROUTING_ID VARCHAR(10) No No
RECV_REQ VARCHAR(1) No No
PRICE_CAN_CHANGE VARCHAR(1) No No
WTHD_SW VARCHAR(1) No No
WTHD_CD VARCHAR(5) No No
CONFIG_CODE VARCHAR(50) No No
CP_TEMPLATE_ID VARCHAR(10) No No
DESCR254_MIXED VARCHAR(254) No No
PACKING_WEIGHT decimal(15,4) No No
PACKING_VOLUME decimal(15,4) No No
UNIT_MEASURE_WT VARCHAR(3) No No
UNIT_MEASURE_VOL VARCHAR(3) No No
REPLEN_OPT VARCHAR(2) No No
AMT_ONLY_FLG VARCHAR(1) No No
PHYSICAL_NATURE VARCHAR(1) No No
USER_LINE_CHAR1 VARCHAR(1) No No
GPO_ID VARCHAR(18) No No
GPO_CNTRCT_NBR VARCHAR(25) No No
BENEFIT_ID VARCHAR(10) No No
CNTRCT_CF_LOCK VARCHAR(1) No No
Index
Name Type Unique Member
PS_PO_LINE PK Yes
PSAPO_LINE IE10 No
PSBPO_LINE IE3 No
PS0PO_LINE IE9 No
Member(s) of "PS_PO_LINE" Index
BUSINESS_UNIT
PO_ID
LINE_NBR
Member(s) of "PSAPO_LINE" Index
CANCEL_STATUS
BUSINESS_UNIT
PO_ID
Member(s) of "PSBPO_LINE" Index
CNTRCT_SETID
CNTRCT_ID
Member(s) of "PS0PO_LINE" Index
INV_ITEM_ID
BUSINESS_UNIT
PO_ID
LINE_NBR

Published June 06, 2007