DST_ACCT_TYPEDST_MSC_TYPE_VW(SQL View) |
Index Back |
|---|---|
Freight Dst Type Prompt VWPrompt Against DST_ACCT_TYPE field for freight translate value |
| SELECT fieldvalue , xlatlongname FROM PSXLATITEM WHERE FIELDNAME = 'DST_ACCT_TYPE' AND FIELDVALUE IN ('FRG','MISC','STX','UTX','VIN') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |