BUSINESS_UNITRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRMISC_CHARGE_CODEBUSINESS_UNIT_APVOUCHER_IDVOUCHER_LINE_NUMHR=Hourly
UN=Per Unit
RECV_LN_SHIP_VC(SQL Table) |
Index Back |
|---|---|
Rct Landed Cost Voucher Detail02/28/99 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 | MISC_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 6 | BUSINESS_UNIT_AP |
Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 7 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 8 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | 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 |
| 11 | UOM_VCHR | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure Voucher |
| 12 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 13 | QTY_VCHR_CNVT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Voucher Qty Converted |
| 14 | CURRENCY_CD_PO | Character(3) | VARCHAR2(3) NOT NULL | Currency Code Purchase Order |
| 15 | MISC_CHG_AMT_CNVT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | 11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement |
| 16 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit |
| 17 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 18 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |