PRCR_UPD_TMPC

(SQL Table)
Index Back

Prcr upd tmp for rec counting

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 PRCR_YEAR Number(4,0) SMALLINT NOT NULL Procurement Year
3 PRCR_PERIOD Number(3,0) SMALLINT NOT NULL Procurement Period
4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
10 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
11 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
14 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
16 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
17 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
18 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
19 NUM_OF_ORDERS Number(7,0) INTEGER NOT NULL Number of Orders