BUSINESS_UNITRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRDISTRIB_LINE_NUMMISC_CHARGE_CODEDST_ACCT_TYPEY/N Table Edit
Default Value: 0
RECV_LN_DIST_LC(SQL Table) |
Index Back |
|---|---|
Receipt Landed Cost Detail11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement |
| # | 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 | MISC_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 7 | 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 |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 9 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 10 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 11 | 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 |
| 12 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 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 | LC_RTV_CREDIT | Character(1) | VARCHAR2(1) NOT NULL | Return to Vendor for Credit |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | 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 |
| 17 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 18 | 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 |
| 19 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |
| 20 | 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. |
| 21 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 22 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 23 | CM_UNIT_COST_RECV | Signed Number(27,15) | DECIMAL(25,15) NOT NULL | Unit Cost |
| 24 | MISC_AMT_CALC_BSE | Signed Number(31,6) | DECIMAL(29,6) NOT NULL |
Base Charge for Calculation
Default Value: 0 |