MISC_CHARGE_SETIDMISC_CHARGE_CODEPO_LC_COMP_VW1(SQL View) |
Index Back |
|---|---|
Freight and Misc Charges View |
| SELECT SETID, MISC_CHARGE_CODE, DESCR50 FROM PS_CM_LC_COMPONENT WHERE DST_ACCT_TYPE IN ('FRG','MISC') |
| # | 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 |