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 |