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 |