PeopleSoft 9
Asset Management

Table Name PO_VAL_ADJ

Table Description
PO_VAL_ADJ
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
PO_ID char(10) Yes Yes
LINE_NBR int Yes Yes
SCHED_NBR smallint Yes Yes
ADJ_IMPACT_TYPE char(1) Yes No
ADJ_NBR smallint Yes No
ADJ_TYPE char(4) No No
BASE_PRICE_TYPE char(1) No No
ADJ_TBL_UOM_FLG char(1) No No
ADJ_TBL_SHIPTO_FLG char(1) No No
QTY_MIN decimal(15,4) No No
QTY_PO decimal(15,4) No No
TAX_CD char(8) No No
ADJ_TYPE_OTHER char(50) No No
ADJ_METH char(1) No No
CURRENCY_CD char(3) No No
ADJ_AMT decimal(15,5) No No
CURRENCY_CD_BASE char(3) No No
ADJ_AMT_BSE decimal(15,5) No No
ADJ_PCT decimal(9,4) No No
ADJ_PCT_TYPE char(3) No No
APPLY_ADJ char(1) No No
NOT_APPLY_REASON char(50) No No
MISC_CHARGE_CODE char(10) No Yes
DST_ACCT_TYPE char(4) No No
X_VENDOR_SETID char(5) No No
X_VENDOR_ID char(10) No No
X_VNDR_LOC char(10) No No
LC_COMP_FLAG char(1) No No
LC_ACCRUAL_FLAG char(1) No No
LC_COMP_CALC char(3) No No
LC_COMP_ALLOC char(3) No No
LC_COMP_ON_PO char(1) No No
UNIT_PRICE decimal(15,5) No No
FLAT_AMOUNT decimal(26,3) No No
PCT_VALUE decimal(7,2) No No
UNIT_OF_MEASURE char(3) No No
MISC_CHARGE_ORIGN char(1) No No
UNIT_PRICE_LC decimal(15,5) No No
SALETX_PRORATE_FLG char(1) No No
USETAX_PRORATE_FLG char(1) No No
VAT_NRCVR_PRO_FLG char(1) No No
VAT_PRORATE_FLG char(1) No No
FRGHT_PRORATE_FLG char(1) No No
MISC_PRORATE_FLG char(1) No No
ACTUAL_CHRG_FLG char(1) No No
LC_RTV_CREDIT char(1) No No
RATE_DATE PSDATE No No
RT_TYPE char(5) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
Index
Name Type Unique Member
PS_PO_VAL_ADJ PK Yes
Member(s) of "PS_PO_VAL_ADJ" Index
BUSINESS_UNIT
PO_ID
LINE_NBR
SCHED_NBR
ADJ_IMPACT_TYPE
ADJ_NBR

Published December 16, 2006