SETIDVENDOR_IDVNDR_LOCMISC_CHARGE_CODERETURN_REASONCR=Credit
DB=Debit
Y/N Table Edit
Y/N Table Edit
RTV_VND_FEE_VW(SQL View) |
Index Back |
|---|---|
RTV Default Supplier Fees View |
| SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.MISC_CHARGE_CODE , A.RETURN_REASON , A.FEE_ACTION , A.FEE_PERCENT , B.COST_ELEMENT , B.DST_ACCT_TYPE , B.LC_ACCRUAL_FLAG , B.LC_COMP_FLAG FROM PS_VNDR_RTV_FEE 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 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | MISC_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 5 | RETURN_REASON |
Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 6 | FEE_ACTION | Character(2) | VARCHAR2(2) NOT NULL |
Fee Action
CR=Credit DB=Debit |
| 7 | FEE_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | Fee Percent |
| 8 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 9 | 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 |
| 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.
Y/N Table Edit |
| 11 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Y/N Table Edit |