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 |