BUSINESS_UNITRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRDISTRIB_LINE_NUMDST_ACCT_TYPERECV_DIST_LC_VW(SQL View) |
Index Back |
|---|---|
Receipt Landed Cost Dtl ViewSums the amounts for all misc_charge_codes for the same dst_acct_type for use in receipt accrual processing. |
| SELECT BUSINESS_UNIT , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , DISTRIB_LINE_NUM , DST_ACCT_TYPE , BUSINESS_UNIT_GL , CURRENCY_CD , SUM(MISC_CHG_AMT) , CURRENCY_CD_BASE , SUM(MISC_CHG_AMT_BSE) , RT_TYPE , RATE_DIV , RATE_MULT FROM PS_RECV_LN_DIST_LC WHERE (BUSINESS_UNIT_IN = ' ' OR EXISTS ( SELECT 'X' FROM PS_BUS_UNIT_TBL_PM PM WHERE PM.BUSINESS_UNIT = BUSINESS_UNIT AND PM.ACCRUE_FEDERAL = 'Y')) AND LC_ACCRUAL_FLAG = 'Y' AND LC_COMP_FLAG = 'Y' AND LC_COMP_ON_PO = 'Y' GROUP BY BUSINESS_UNIT , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , DISTRIB_LINE_NUM , DST_ACCT_TYPE , BUSINESS_UNIT_GL , CURRENCY_CD , CURRENCY_CD_BASE , RT_TYPE , RATE_DIV , RATE_MULT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 5 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 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 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | MISC_CHG_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement |
| 10 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 11 | MISC_CHG_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement |
| 12 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 13 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 14 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |