PeopleSoft 9
Account Payables

Table Name PURCH_ITEM_ATTR

Table Description
PURCH_ITEM_ATTR
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
INV_ITEM_ID VARCHAR(18) Yes No
DESCR VARCHAR(30) No No
PRIMARY_BUYER VARCHAR(30) No No
PO_AVAIL_DT PSDATE No No
PO_UNAVAIL_DT PSDATE No No
DESCRSHORT VARCHAR(10) No No
ACCOUNT VARCHAR(10) No No
ALTACCT VARCHAR(10) No No
DEPTID VARCHAR(10) No No
OPERATING_UNIT VARCHAR(8) No No
PRODUCT VARCHAR(6) No No
FUND_CODE VARCHAR(5) No No
CLASS_FLD VARCHAR(5) No No
PROGRAM_CODE VARCHAR(5) No No
BUDGET_REF VARCHAR(8) No No
AFFILIATE VARCHAR(5) No No
AFFILIATE_INTRA1 VARCHAR(10) No No
AFFILIATE_INTRA2 VARCHAR(10) No No
CHARTFIELD1 VARCHAR(10) No No
CHARTFIELD2 VARCHAR(10) No No
CHARTFIELD3 VARCHAR(10) No No
PROJECT_ID VARCHAR(15) No No
PRICE_LIST decimal(15,5) No No
TAXABLE_CD VARCHAR(1) No No
AUTO_SOURCE VARCHAR(1) No No
STD_LEAD SMALLINT No No
UNIT_PRC_TOL decimal(13,5) No No
EXT_PRC_TOL decimal(13,5) No No
PCT_UNIT_PRC_TOL decimal(5,2) No No
PCT_EXT_PRC_TOL decimal(5,2) No No
INSPECT_CD VARCHAR(1) No No
INSPECT_UOM_TYPE VARCHAR(1) No No
ROUTING_ID VARCHAR(10) No No
RECV_REQ VARCHAR(1) No No
QTY_RECV_TOL_PCT decimal(5,2) No No
RJCT_OVER_TOL_FLAG VARCHAR(1) No No
RFQ_REQ_FLAG VARCHAR(1) No No
REJECT_DAYS SMALLINT No No
MODEL VARCHAR(30) No No
ACCEPT_ALL_VENDOR VARCHAR(1) No No
ACCEPT_ALL_SHIPTO VARCHAR(1) No No
CONTRACT_REQ VARCHAR(1) No No
DESCR254_MIXED VARCHAR(254) No No
FILENAME VARCHAR(80) No No
FILE_EXTENSION VARCHAR(4) No No
RECV_PARTIAL_FLG VARCHAR(1) No No
CURRENCY_CD VARCHAR(3) No No
PCT_UNDER_QTY SMALLINT No No
STOCKLESS_FLG VARCHAR(1) No No
INSPECT_SAMPLE_PER decimal(5,2) No No
VAT_SVC_PERFRM_FLG VARCHAR(1) No No
LAST_PO_PRICE_PAID decimal(15,5) No No
SRC_METHOD VARCHAR(1) No No
LEAD_TIME_IMP decimal(5,2) No No
PRICE_IMP decimal(5,2) No No
SHIPTO_PR_IMP decimal(5,2) No No
VNDR_PR_IMP decimal(5,2) No No
USE_CAT_SRC_CNTL VARCHAR(1) No No
UNIT_PRC_TOL_L decimal(13,5) No No
PCT_UNIT_PRC_TOL_L decimal(5,2) No No
EXT_PRC_TOL_L decimal(13,5) No No
PCT_EXT_PRC_TOL_L decimal(5,2) No No
PACKING_VOLUME decimal(15,4) No No
PACKING_WEIGHT decimal(15,4) No No
UNIT_MEASURE_VOL VARCHAR(3) No No
UNIT_MEASURE_WT VARCHAR(3) No No
SHIP_LATE_DAYS SMALLINT No No
SHIP_TYPE_ID VARCHAR(10) No No
KB_PAST_DUE_PO VARCHAR(1) No No
KB_OVR_RECV_TOL decimal(5,2) No No
ULTIMATE_USE_CD VARCHAR(8) No No
WF_PCT_PRC_TOL_OVR decimal(5,2) No No
WF_PCT_PRC_TOL_UND decimal(5,2) No No
WF_PRC_TOL_OVR decimal(13,5) No No
WF_PRC_TOL_UND decimal(13,5) No No
AVAIL_ALL_RGNS VARCHAR(1) No No
OPRID_MODIFIED_BY VARCHAR(30) No No
LAST_DTTM_UPDATE PSDATETIME No No
Index
Name Type Unique Member
PS_PURCH_ITEM_ATTR PK Yes
PS1PURCH_ITEM_ATTR IE10 No
PS0PURCH_ITEM_ATTR IE9 No
Member(s) of "PS_PURCH_ITEM_ATTR" Index
SETID
INV_ITEM_ID
Member(s) of "PS1PURCH_ITEM_ATTR" Index
PRIMARY_BUYER
SETID
INV_ITEM_ID
Member(s) of "PS0PURCH_ITEM_ATTR" Index
DESCR
SETID
INV_ITEM_ID

Published June 06, 2007