SETIDMISC_CHARGE_CODEDefault Value: FRG
Prompt Table: CM_DST_TYPE_VW
Y/N Table Edit
Default Value: N
VCHR_FRG_PRT_VW(SQL View) |
Index Back |
|---|---|
Vchr Freight Prorated View |
| SELECT A.SETID , A.MISC_CHARGE_CODE , A.DESCR50 , A.DST_ACCT_TYPE , A.LC_ACCRUAL_FLAG , A.PRORATE FROM PS_CM_LC_COMPONENT A WHERE A.DST_ACCT_TYPE = 'FRG' AND A.PRORATE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 4 | 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
Default Value: FRG Prompt Table: CM_DST_TYPE_VW |
| 5 | LC_ACCRUAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement.
Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.
Y/N Table Edit Default Value: N |
| 6 | PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate |