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 |