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 |