OEB_ICX_CAT_ITEM_PRICES

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 RT_ITEM_ID BIGINT 8
2 PRICE_TYPE CHARACTER VARYING(20) 20
3 ACTIVE_FLAG CHARACTER VARYING(1) 1
4 OBJECT_VERSION_NUMBER BIGINT 8
5 ASL_ID BIGINT 8
6 SUPPLIER_SITE_ID BIGINT 8
7 CONTRACT_ID BIGINT 8
8 CONTRACT_LINE_ID BIGINT 8
9 TEMPLATE_ID CHARACTER VARYING(25) 25
10 TEMPLATE_LINE_ID BIGINT 8
11 INVENTORY_ITEM_ID BIGINT 8
12 MTL_CATEGORY_ID BIGINT 8
13 ORG_ID BIGINT 8
14 SEARCH_TYPE CHARACTER VARYING(8) 8
15 UNIT_PRICE NUMERIC(18,2) 19
16 CURRENCY CHARACTER VARYING(15) 15
17 UNIT_OF_MEASURE CHARACTER VARYING(3) 3
18 FUNCTIONAL_PRICE NUMERIC(18,2) 19
19 SUPPLIER_SITE_CODE CHARACTER VARYING(100) 100
20 CONTRACT_NUM CHARACTER VARYING(20) 20
21 CONTRACT_LINE_NUM BIGINT 8
22 PRICE_LIST_ID BIGINT 8
23 SUPPLIER_NUMBER CHARACTER VARYING(30) 30
24 SUPPLIER_CONTACT_ID BIGINT 8
25 ITEM_REVISION CHARACTER VARYING(3) 3
26 LINE_TYPE_ID BIGINT 8
27 BUYER_ID BIGINT 8
28 RATE_TYPE CHARACTER VARYING(30) 30
29 RATE_DATE TIMESTAMP 8
30 RATE NUMERIC(18,2) 19
31 LOCAL_RT_ITEM_ID BIGINT 8
32 LAST_UPDATE_LOGIN BIGINT 8
33 LAST_UPDATED_BY BIGINT 8
34 LAST_UPDATE_DATE TIMESTAMP 8
35 CREATED_BY BIGINT 8
36 CREATION_DATE TIMESTAMP 8
37 REQUEST_ID BIGINT 8
38 PROGRAM_APPLICATION_ID BIGINT 8
39 PROGRAM_ID BIGINT 8
40 PROGRAM_UPDATE_DATE TIMESTAMP 8
41 SUGGESTED_QUANTITY NUMERIC(18,2) 19
42 ALLOW_PRICE_OVERRIDE_FLAG CHARACTER VARYING(1) 1
43 NOT_TO_EXCEED_PRICE NUMERIC(18,2) 19
44 VALUE_BASIS CHARACTER VARYING(25) 25
45 PURCHASE_BASIS CHARACTER VARYING(30) 30
46 NEGOTIATED_BY_PREPARER_FLAG CHARACTER VARYING(1) 1
47 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
48 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
49 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
50 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8