PROD_ITEM (SQL Table)	Index Back
OM Product Item This record holds all the Product attributes for an Order Management Product. Added product type for PDM enhancement.

PROD_ITEM

(SQL Table)

OM Product Item

This record holds all the Product attributes for an Order Management Product. Added product type for PDM enhancement.

Related Language Record: PROD_ITEM_LNG

Parent Record Of PRODEXDESCR_LNG PROD_ATTR PROD_ATTR_LNG PROD_EXT_DESCR RBT_PROD_BUSPRJ RC_PROBTYPE_SS RC_PROBTYPE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Default Value: NEXT

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 PROD_TYPE Character(4) VARCHAR2(4) NOT NULL A new field has been introduced as Product Type to distingush the product types like, Physical Products and Service Products. It is used for PDM enhancement.
AGR=Service Agreement
CMT=Commitment Product
ENG=Engagement Service
PHY=Standard Product
PKG=Package Product
SUB=Subscription Product
SVC=Service Product

5 MODEL_NBR Character(18) VARCHAR2(18) NOT NULL Model number field to store model number value.

6 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number

7 TAX_PRODUCT_NBR Character(18) VARCHAR2(18) NOT NULL Tax Product Number

8 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service

9 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None

10 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit Flag
Y/N Table Edit
Default Value: N

11 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: PROD_ITEMMST_VW

13 SERVICE Character(1) VARCHAR2(1) NOT NULL Service Flag
Y/N Table Edit
Default Value: N

14 AGREEMENT_SETID Character(5) VARCHAR2(5) NOT NULL AGREEMENT_SETID field is added to the PROD_ITEM record. This is because we may select a template from a different SETID than the product definition

15 ENGAGEMENT Character(1) VARCHAR2(1) NOT NULL Engagement
Y/N Table Edit
Default Value: N

16 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
Y/N Table Edit
Default Value: N

17 COMM_FLAG Character(1) VARCHAR2(1) NOT NULL Commissionable
Y/N Table Edit
Default Value: N

18 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %

19 UPPER_MARGIN_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Upper Margin Amt

20 LOWER_MARGIN_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Lower Margin Amt

21 UPPER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Upper Margin %

22 LOWER_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Lower Margin %

23 HOLD_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Hold Update Switch
Y/N Table Edit
Default Value: N

24 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

25 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project ID

26 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Used in Contracts Integration, Activity Identifier

27 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

28 DURATION_FREQ Character(1) VARCHAR2(1) NOT NULL Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
D=Days
M=Months
Q=Quarters
W=Weeks
Y=Years

29 DURATION Number(5,0) INTEGER NOT NULL Field for IBM development. Lead Time used in SM

30 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Exprt License Required
NO=No
YES=Yes
Y/N Table Edit
Default Value: N

31 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned
Y/N Table Edit
Default Value: Y

32 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

33 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit Package
M=Multilevel Bundle Component
N=Lightly Configured
Y=Schema Enabled
Default Value: N

34 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configurator Code Generation
Y/N Table Edit
Default Value: N

35 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
Prompt Table: CP_TEMP_HDR_VW

36 CP_TREE_DIST Character(18) VARCHAR2(18) NOT NULL Distribution Model Field
Prompt Table: %EDITTABLE

37 PRICE_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Price Kit Flag
C=at Component Level
T=at Top Level

38 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand
Prompt Table: PROD_BRAND_TBL

39 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
Prompt Table: PROD_CATGRY_TBL

40 INSTALLED_PROD Character(1) VARCHAR2(1) NOT NULL Indicates that the product will be tracked as an installed product.
Y/N Table Edit
Default Value: N

41 ORDERABLE Character(1) VARCHAR2(1) NOT NULL Orderable By
A=All
B=Business
C=Consumer
N=None
Default Value: A

42 PROD_REGION_FLAG Character(1) VARCHAR2(1) NOT NULL Product Region Flag for PROD_ITEM
A=All Regions
E=All except Regions below
I=Only in Regions below
Default Value: A

43 SITE_REQUIRED Character(1) VARCHAR2(1) NOT NULL Site Required...
N=No
Y=Yes
Y/N Table Edit
Default Value: N

44 SO_REQUIRED Character(1) VARCHAR2(1) NOT NULL This field is used to specify whether or not a service order is required.
Y/N Table Edit
Default Value: N

45 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
Prompt Table: RF_SERV_IPRD_VW

46 INST_PRD_ASN_IFLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not an installed product can be created from a shipping notification (ASN).
Y/N Table Edit
Default Value: N

47 INST_PRD_ASN_ISTAT Character(3) VARCHAR2(3) NOT NULL Default installed product status when creating a new installed product from an ASN.
INS=Installed
PND=Pending
SHP=Shipped
Prompt Table: RF_ISTATXLAT_VW
Set Control Field: SETID

48 INST_PRD_ASN_UFLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not an installed product can be updated from a shipping notification (ASN).
Y/N Table Edit
Default Value: N

49 INST_PRD_ASN_USTAT Character(3) VARCHAR2(3) NOT NULL Default installed product status when updating an existing installed product from an ASN (shipping notification).
INS=Installed
PND=Pending
SHP=Shipped
Prompt Table: RF_ISTATXLAT_VW
Set Control Field: SETID

50 INST_PRD_MTL_IFLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not an installed product can be created from Material Management, which can only be created from a service order.
Y/N Table Edit
Default Value: N

51 INST_PRD_MTL_ISTAT Character(3) VARCHAR2(3) NOT NULL Default installed product status when creating a new installed product from Manage Material (Service Order).
INS=Installed
PND=Pending
SHP=Shipped
Prompt Table: RF_ISTATXLAT_VW
Set Control Field: SETID

52 INST_PRD_MTL_UFLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not an installed product can updated from Material Management, which can only be created from a service order.
Y/N Table Edit
Default Value: N

53 INST_PRD_MTL_USTAT Character(3) VARCHAR2(3) NOT NULL Default installed product status when updating an existing installed product from Manage Material (Service Order).
INS=Installed
PND=Pending
SHP=Shipped
Prompt Table: RF_ISTATXLAT_VW
Set Control Field: SETID

54 INST_PRD_ORD_IFLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not an installed product can be inserted from Order Capture.
Y/N Table Edit
Default Value: N

55 INST_PRD_ORD_ISTAT Character(3) VARCHAR2(3) NOT NULL Default installed product status when creating a new installed product from Order Capture.
INS=Installed
PND=Pending
SHP=Shipped
Prompt Table: RF_ISTATXLAT_VW
Set Control Field: SETID

56 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Generic Product Field

57 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Generic Product Field

58 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Generic Product Field

59 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Generic Product Field

60 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Generic Product Field

61 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Generic Product Field

62 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Generic Product Field

63 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Generic Product Field

64 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Generic Product Field

65 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Generic Product Field

66 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Generic Product Field

67 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Generic Product Field

68 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Generic Product Field

69 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Generic Product Field

70 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Generic Product Field

71 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Generic Product Field

72 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field

73 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field

74 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field

75 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Generic Product Field

76 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Generic Product Field

77 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Generic Product Field

78 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Generic Product Field

79 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Generic Product Field

80 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

81 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

82 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.

83 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
Prompt Table: RF_AG_ROTMPL_VW

84 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
Prompt Table: RF_TAX_GROUP_VW

85 PRODUCT_USE Character(1) VARCHAR2(1) NOT NULL Field for distinguishing which products can use a product definition - used as part of the PRODUCT_SYNC.
1=General Use Excluding Contract
2=Contracts Only
3=General Use

86 RO_ATTR_EXIST Character(4) VARCHAR2(4) NOT NULL Order Capture Attributes exist
ALL=Always has Attributes
NONE=Never has Attributes
SOME=Conditionally has Attributes

87 LEADTIME Number(5,0) INTEGER NOT NULL Lead Time for the Product Data Model to indicate time necessary to install or deliver a the product to a customer.
Default Value: 0

88 PROD_DIS_RES_OPT Character(4) VARCHAR2(4) NOT NULL Field to determine how to handle external systems with a temporary service
CHST=Change Service Status
EXTN=Wait for External Notification
ORDR=Create Order for Change
Default Value: ORDR

89 PROD_TEMP_SERV Character(1) VARCHAR2(1) NOT NULL Field to allow temporary installation of a service
Y/N Table Edit
Default Value: N

90 URL_1 Character(254) VARCHAR2(254) NOT NULL URL #1

91 URL_2 Character(254) VARCHAR2(254) NOT NULL URL #2

92 MARKET Character(3) VARCHAR2(3) NOT NULL Market

93 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

94 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

95 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

96 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

97 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

98 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Default Value: NEXT
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	PROD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	A new field has been introduced as Product Type to distingush the product types like, Physical Products and Service Products. It is used for PDM enhancement. AGR=Service Agreement CMT=Commitment Product ENG=Engagement Service PHY=Standard Product PKG=Package Product SUB=Subscription Product SVC=Service Product
5	MODEL_NBR	Character(18)	VARCHAR2(18) NOT NULL	Model number field to store model number value.
6	CATALOG_NBR	Character(18)	VARCHAR2(18) NOT NULL	Catalog Number
7	TAX_PRODUCT_NBR	Character(18)	VARCHAR2(18) NOT NULL	Tax Product Number
8	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service
9	TAX_TRANS_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Sub Type 1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None
10	PRODUCT_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Kit Flag Y/N Table Edit Default Value: N
11	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
12	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: PROD_ITEMMST_VW
13	SERVICE	Character(1)	VARCHAR2(1) NOT NULL	Service Flag Y/N Table Edit Default Value: N
14	AGREEMENT_SETID	Character(5)	VARCHAR2(5) NOT NULL	AGREEMENT_SETID field is added to the PROD_ITEM record. This is because we may select a template from a different SETID than the product definition
15	ENGAGEMENT	Character(1)	VARCHAR2(1) NOT NULL	Engagement Y/N Table Edit Default Value: N
16	DROP_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Drop Ship Y/N Table Edit Default Value: N
17	COMM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commissionable Y/N Table Edit Default Value: N
18	COMM_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Commission %
19	UPPER_MARGIN_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Upper Margin Amt
20	LOWER_MARGIN_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Lower Margin Amt
21	UPPER_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Upper Margin %
22	LOWER_MARGIN_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Lower Margin %
23	HOLD_UPDATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Hold Update Switch Y/N Table Edit Default Value: N
24	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
25	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project ID
26	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Used in Contracts Integration, Activity Identifier
27	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
28	DURATION_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months. D=Days M=Months Q=Quarters W=Weeks Y=Years
29	DURATION	Number(5,0)	INTEGER NOT NULL	Field for IBM development. Lead Time used in SM
30	EXPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Exprt License Required NO=No YES=Yes Y/N Table Edit Default Value: N
31	RETURN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be returned Y/N Table Edit Default Value: Y
32	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
33	CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Configured Kit Package M=Multilevel Bundle Component N=Lightly Configured Y=Schema Enabled Default Value: N
34	CFG_CODE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Configurator Code Generation Y/N Table Edit Default Value: N
35	CP_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID Field Prompt Table: CP_TEMP_HDR_VW
36	CP_TREE_DIST	Character(18)	VARCHAR2(18) NOT NULL	Distribution Model Field Prompt Table: %EDITTABLE
37	PRICE_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Price Kit Flag C=at Component Level T=at Top Level
38	PROD_BRAND	Character(15)	VARCHAR2(15) NOT NULL	Product Brand Prompt Table: PROD_BRAND_TBL
39	PROD_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	Product Category Prompt Table: PROD_CATGRY_TBL
40	INSTALLED_PROD	Character(1)	VARCHAR2(1) NOT NULL	Indicates that the product will be tracked as an installed product. Y/N Table Edit Default Value: N
41	ORDERABLE	Character(1)	VARCHAR2(1) NOT NULL	Orderable By A=All B=Business C=Consumer N=None Default Value: A
42	PROD_REGION_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Region Flag for PROD_ITEM A=All Regions E=All except Regions below I=Only in Regions below Default Value: A
43	SITE_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Site Required... N=No Y=Yes Y/N Table Edit Default Value: N
44	SO_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	This field is used to specify whether or not a service order is required. Y/N Table Edit Default Value: N
45	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID Prompt Table: RF_SERV_IPRD_VW
46	INST_PRD_ASN_IFLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not an installed product can be created from a shipping notification (ASN). Y/N Table Edit Default Value: N
47	INST_PRD_ASN_ISTAT	Character(3)	VARCHAR2(3) NOT NULL	Default installed product status when creating a new installed product from an ASN. INS=Installed PND=Pending SHP=Shipped Prompt Table: RF_ISTATXLAT_VW Set Control Field: SETID
48	INST_PRD_ASN_UFLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not an installed product can be updated from a shipping notification (ASN). Y/N Table Edit Default Value: N
49	INST_PRD_ASN_USTAT	Character(3)	VARCHAR2(3) NOT NULL	Default installed product status when updating an existing installed product from an ASN (shipping notification). INS=Installed PND=Pending SHP=Shipped Prompt Table: RF_ISTATXLAT_VW Set Control Field: SETID
50	INST_PRD_MTL_IFLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not an installed product can be created from Material Management, which can only be created from a service order. Y/N Table Edit Default Value: N
51	INST_PRD_MTL_ISTAT	Character(3)	VARCHAR2(3) NOT NULL	Default installed product status when creating a new installed product from Manage Material (Service Order). INS=Installed PND=Pending SHP=Shipped Prompt Table: RF_ISTATXLAT_VW Set Control Field: SETID
52	INST_PRD_MTL_UFLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not an installed product can updated from Material Management, which can only be created from a service order. Y/N Table Edit Default Value: N
53	INST_PRD_MTL_USTAT	Character(3)	VARCHAR2(3) NOT NULL	Default installed product status when updating an existing installed product from Manage Material (Service Order). INS=Installed PND=Pending SHP=Shipped Prompt Table: RF_ISTATXLAT_VW Set Control Field: SETID
54	INST_PRD_ORD_IFLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not an installed product can be inserted from Order Capture. Y/N Table Edit Default Value: N
55	INST_PRD_ORD_ISTAT	Character(3)	VARCHAR2(3) NOT NULL	Default installed product status when creating a new installed product from Order Capture. INS=Installed PND=Pending SHP=Shipped Prompt Table: RF_ISTATXLAT_VW Set Control Field: SETID
56	PROD_FIELD_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Generic Product Field
57	PROD_FIELD_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Generic Product Field
58	PROD_FIELD_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Generic Product Field
59	PROD_FIELD_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Generic Product Field
60	PROD_FIELD_C10_A	Character(10)	VARCHAR2(10) NOT NULL	Generic Product Field
61	PROD_FIELD_C10_B	Character(10)	VARCHAR2(10) NOT NULL	Generic Product Field
62	PROD_FIELD_C10_C	Character(10)	VARCHAR2(10) NOT NULL	Generic Product Field
63	PROD_FIELD_C10_D	Character(10)	VARCHAR2(10) NOT NULL	Generic Product Field
64	PROD_FIELD_C2	Character(2)	VARCHAR2(2) NOT NULL	Generic Product Field
65	PROD_FIELD_C30_A	Character(30)	VARCHAR2(30) NOT NULL	Generic Product Field
66	PROD_FIELD_C30_B	Character(30)	VARCHAR2(30) NOT NULL	Generic Product Field
67	PROD_FIELD_C30_C	Character(30)	VARCHAR2(30) NOT NULL	Generic Product Field
68	PROD_FIELD_C30_D	Character(30)	VARCHAR2(30) NOT NULL	Generic Product Field
69	PROD_FIELD_C4	Character(4)	VARCHAR2(4) NOT NULL	Generic Product Field
70	PROD_FIELD_C6	Character(6)	VARCHAR2(6) NOT NULL	Generic Product Field
71	PROD_FIELD_C8	Character(8)	VARCHAR2(8) NOT NULL	Generic Product Field
72	PROD_FIELD_N12_A	Number(16,3)	DECIMAL(15,3) NOT NULL	Generic Product Field
73	PROD_FIELD_N12_B	Number(16,3)	DECIMAL(15,3) NOT NULL	Generic Product Field
74	PROD_FIELD_N12_C	Number(16,3)	DECIMAL(15,3) NOT NULL	Generic Product Field
75	PROD_FIELD_N12_D	Number(16,3)	DECIMAL(15,3) NOT NULL	Generic Product Field
76	PROD_FIELD_N15_A	Number(15,0)	DECIMAL(15) NOT NULL	Generic Product Field
77	PROD_FIELD_N15_B	Number(15,0)	DECIMAL(15) NOT NULL	Generic Product Field
78	PROD_FIELD_N15_C	Number(15,0)	DECIMAL(15) NOT NULL	Generic Product Field
79	PROD_FIELD_N15_D	Number(15,0)	DECIMAL(15) NOT NULL	Generic Product Field
80	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
81	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
82	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field determines the last user or operator that last changed this item.
83	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement Prompt Table: RF_AG_ROTMPL_VW
84	TAX_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months. Prompt Table: RF_TAX_GROUP_VW
85	PRODUCT_USE	Character(1)	VARCHAR2(1) NOT NULL	Field for distinguishing which products can use a product definition - used as part of the PRODUCT_SYNC. 1=General Use Excluding Contract 2=Contracts Only 3=General Use
86	RO_ATTR_EXIST	Character(4)	VARCHAR2(4) NOT NULL	Order Capture Attributes exist ALL=Always has Attributes NONE=Never has Attributes SOME=Conditionally has Attributes
87	LEADTIME	Number(5,0)	INTEGER NOT NULL	Lead Time for the Product Data Model to indicate time necessary to install or deliver a the product to a customer. Default Value: 0
88	PROD_DIS_RES_OPT	Character(4)	VARCHAR2(4) NOT NULL	Field to determine how to handle external systems with a temporary service CHST=Change Service Status EXTN=Wait for External Notification ORDR=Create Order for Change Default Value: ORDR
89	PROD_TEMP_SERV	Character(1)	VARCHAR2(1) NOT NULL	Field to allow temporary installation of a service Y/N Table Edit Default Value: N
90	URL_1	Character(254)	VARCHAR2(254) NOT NULL	URL #1
91	URL_2	Character(254)	VARCHAR2(254) NOT NULL	URL #2
92	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
93	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
94	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
95	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
96	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
97	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
98	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time