MISC_CHARGE_SETIDMISC_CHARGE_CODEPO_LC_COMP_VW2(SQL View) |
Index Back |
|---|---|
Freight and Misc Charges Vw 2/* Res 306046 jdev - This view excludes charges with calc methods of FRT, STX, UTX, or VAT (system calculated) */ |
| SELECT SETID , MISC_CHARGE_CODE , DESCR50 FROM PS_CM_LC_COMPONENT WHERE DST_ACCT_TYPE IN ('FRG','MISC') AND LC_COMP_CALC NOT IN ('FRT','STX','UTX','VAT') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MISC_CHARGE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | MISC_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |