BUSINESS_UNITRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRDST_ACCT_TYPEEXD_VND_INV_LCV(SQL View) |
Index Back |
|---|---|
Receipt Landed Cost Detail11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement |
| SELECT L.BUSINESS_UNIT , L.RECEIVER_ID , L.RECV_LN_NBR , L.RECV_SHIP_SEQ_NBR , L.DST_ACCT_TYPE , L.BUSINESS_UNIT_IN , L.CURRENCY_CD , SUM(L.MISC_CHG_AMT) , L.CURRENCY_CD_BASE , SUM(L.MISC_CHG_AMT_BSE) FROM PS_RECV_LN_DIST_LC L GROUP BY L.BUSINESS_UNIT , L.RECEIVER_ID , L.RECV_LN_NBR , L.RECV_SHIP_SEQ_NBR , L.DST_ACCT_TYPE , L.BUSINESS_UNIT_IN , L.CURRENCY_CD , L.CURRENCY_CD_BASE |
| # | 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 | 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 |
| 6 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | 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 |
| 9 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 10 | 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 |