SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
FRGHT_CHARGE_CODEDefault Value: MISC
Prompt Table: CM_DST_TYPE_VW
Y/N Table Edit
Default Value: N
BU_FRG_LC_CMPVW(SQL View) |
Index Back |
|---|---|
LC Components & Misc Charges10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| SELECT SETID , MISC_CHARGE_CODE , DESCR50 , DST_ACCT_TYPE , LC_ACCRUAL_FLAG , PRORATE FROM PS_CM_LC_COMPONENT WHERE DST_ACCT_TYPE = 'FRG' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | FRGHT_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: MISC 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 |