ADJ_TYPEBAS=Base
CNT=Contract
FRT=Freight
OTH=Other
TAX=Tax
TBL=Table
LANGUAGE_CDPO_ADJTYPE_VWLN(SQL View) |
Index Back |
|---|---|
Value Adjust Prompt View |
| SELECT fieldvalue , language_cd , xlatlongname FROM PSXLATITEMLANG WHERE FIELDNAME = 'ADJ_TYPE' AND FIELDVALUE = 'OTH' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ADJ_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Adjustment Type
BAS=Base CNT=Contract FRT=Freight OTH=Other TAX=Tax TBL=Table |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |