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 |