ADJ_TYPEBAS=Base
CNT=Contract
FRT=Freight
OTH=Other
TAX=Tax
TBL=Table
PO_ADJ_TYPE_VW(SQL View) |
Index Back |
|---|---|
Value Adjust Prompt View |
| SELECT fieldvalue , xlatlongname FROM PSXLATITEM 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 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |