SETIDLC_TEMPLATE_IDMISC_CHARGE_CODEFL=Flat Amt
FR=Free
FRT=Freight
STX=Sales Tax
UNT=Unit Amt
UTX=Use Tax
VAL=% Value
VAT=VAT
VOL=Volume
WT=Weight
MAT=Matl Value
QTY=Quantity
VOL=Volume
WT=Weight
CM_LC_COMP_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.LC_TEMPLATE_ID , A.MISC_CHARGE_CODE , B.DESCR50 , B.LC_COMP_FLAG , B.DST_ACCT_TYPE , B.PRORATE , B.LC_GROUP_ID , B.COST_ELEMENT , B.LC_ACCRUAL_FLAG , B.LC_COMP_CALC , B.LC_COMP_ALLOC , B.LC_COMP_ON_PO , B.QTY_RECV_TOL_PCT , B.PCT_EXT_AMT_TOL , B.LC_RTV_CREDIT FROM PS_CM_LC_TEMP_COMP A , PS_CM_LC_COMPONENT B WHERE A.SETID = B.SETID AND A.MISC_CHARGE_CODE = B.MISC_CHARGE_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LC_TEMPLATE_ID |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 3 | MISC_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 6 | 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 |
| 7 | PRORATE | Character(1) | VARCHAR2(1) NOT NULL | 05/19/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 8 | LC_GROUP_ID | Character(7) | VARCHAR2(7) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. |
| 9 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 10 | 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. |
| 11 | LC_COMP_CALC | Character(3) | VARCHAR2(3) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
FL=Flat Amt FR=Free FRT=Freight STX=Sales Tax UNT=Unit Amt UTX=Use Tax VAL=% Value VAT=VAT VOL=Volume WT=Weight |
| 12 | LC_COMP_ALLOC | Character(3) | VARCHAR2(3) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value QTY=Quantity VOL=Volume WT=Weight |
| 13 | LC_COMP_ON_PO | 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 included on the Purchase order to the merchandise supplier |
| 14 | QTY_RECV_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Qty Rcvd Tolerance % |
| 15 | PCT_EXT_AMT_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | 03/05/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. |
| 16 | LC_RTV_CREDIT | Character(1) | VARCHAR2(1) NOT NULL | Return to Vendor for Credit |