PeopleSoft 9
Asset Management

Table Name PO_LINE

Table Description
PO_LINE
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
PO_ID char(10) Yes Yes
LINE_NBR int Yes No
CANCEL_STATUS char(1) No No
CHANGE_STATUS char(1) No No
ITM_SETID char(5) No No
INV_ITEM_ID char(18) No Yes
ITM_ID_VNDR char(50) No No
VNDR_CATALOG_ID char(20) No No
CATEGORY_ID char(5) No No
CHNG_ORD_SEQ smallint No No
UNIT_OF_MEASURE char(3) No No
QTY_TYPE char(1) No No
PRICE_DT_TYPE char(1) No No
MFG_ID char(50) No Yes
MFG_ITM_ID char(50) No No
CNTRCT_SETID char(5) No No
CNTRCT_ID char(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 char(25) No No
RFQ_ID char(10) No No
RFQ_LINE_NBR int No No
INSPECT_CD char(1) No No
ROUTING_ID char(10) No No
RECV_REQ char(1) No No
PRICE_CAN_CHANGE char(1) No No
WTHD_SW char(1) No No
WTHD_CD char(5) No No
CONFIG_CODE char(50) No No
CP_TEMPLATE_ID char(10) No No
DESCR254_MIXED char(254) No No
PACKING_WEIGHT decimal(15,4) No No
PACKING_VOLUME decimal(15,4) No No
UNIT_MEASURE_WT char(3) No No
UNIT_MEASURE_VOL char(3) No No
REPLEN_OPT char(2) No No
AMT_ONLY_FLG char(1) No No
PHYSICAL_NATURE char(1) No No
USER_LINE_CHAR1 char(1) No No
GPO_ID char(18) No No
GPO_CNTRCT_NBR char(25) No No
BENEFIT_ID char(10) No No
CNTRCT_CF_LOCK char(1) No No
Index
Name Type Unique Member
PS_PO_LINE PK Yes
PS0PO_LINE IE1 No
PSAPO_LINE IE2 No
PSBPO_LINE IE3 No
Member(s) of "PS_PO_LINE" Index
BUSINESS_UNIT
PO_ID
LINE_NBR
Member(s) of "PS0PO_LINE" Index
INV_ITEM_ID
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

Published December 16, 2006