RECV_VCHR_MTCH(SQL Table) |
Index Back |
|---|---|
Receivers Matched to a Voucher |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Receiver number | |
| 3 | Number(5,0) | INTEGER NOT NULL | Receipt Line | |
| 4 | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence | |
| 5 | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit | |
| 6 | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID | |
| 7 | Number(5,0) | INTEGER NOT NULL | Voucher Line Number | |
| 8 | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit | |
| 9 | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order | |
| 10 | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] | |
| 11 | Number(3,0) | SMALLINT NOT NULL | Schedule Number | |
| 12 | UOM_VCHR | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure Voucher |
| 13 | UOM_PO | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure PO |
| 14 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 15 | TXN_CURRENCY_PO | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 16 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 17 | QTY_VCHR_CNVT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Voucher Qty Converted |
| 18 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 19 | UNIT_PRICE_CNVT | Number(16,5) | DECIMAL(15,5) NOT NULL | Unit Price Converted |
| 20 | MERCH_AMT_VCHR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Voucher Merchandise Amount |
| 21 | MERCH_AMT_VCHR_B | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Voucher Merchandise Amt base |
| 22 | QTY_RECV_APPLIED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Receiver line ship quantity applied to voucher line in PO unit of measure |
| 23 | MERCH_AMT_RECVAPPL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Receiver line ship merchandise amt applied to voucher line in PO currency |
| 24 | QTY_SH_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accept QTY in Supplier UOM |
| 25 | MERCH_AMT_RECV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amount Received |
| 26 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 27 | 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. |
| 28 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 29 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 30 | LC_EXTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
Default Value: N |