DP_DMDHISTORY (SQL Table)	Index Back
demand planning - data history demand data history table- currently contains 147 fields

DP_DMDHISTORY

(SQL Table)

demand planning - data history

demand data history table- currently contains 147 fields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_DDH_ID Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)

2 DP_DDH_ID_LINK Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)

3 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

4 DP_UPDATE_DMDTYPE Character(2) VARCHAR2(2) NOT NULL DP_UPDATE_DMDTYPE
BI=Billing
IN=Material Stock Requests
OM=Order Management
PL=Planning Requests
PR=Purchasing Requests
RT=Material Returns
SO=Shipped Orders

5 DP_TRANSOURCE Number(1,0) SMALLINT NOT NULL DP_TRANSOURCE

6 DP_DEMANDTYPE Number(1,0) SMALLINT NOT NULL DP_DEMANDTYPE

7 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

8 DP_SOURCESTATUS Signed Number(3,0) DECIMAL(2) NOT NULL DP_SOURCESTATUS

9 DP_UPDATESTATUS Signed Number(2,0) DECIMAL(1) NOT NULL 0 = Not processed 1 = Processed 2 = Partially Processed -1 = Errored

10 DP_DATESTAMP DateTime(26) TIMESTAMP DP_DATESTAMP

11 DP_DEMANDDATE Date(10) DATE DP_DEMANDDATE

12 DP_DEMANDQTY Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDQTY

13 DP_UPD_DATESTAMP Date(10) DATE DP_UPD_DATESTAMP

14 DP_PERIOD Number(3,0) SMALLINT NOT NULL DP_PERIOD

15 DP_YEAR Number(4,0) SMALLINT NOT NULL DP_YEAR

16 DP_UPDATE_NO Number(3,0) SMALLINT NOT NULL DP_UPDATE_NO

17 DP_DDHUPD_GROUP Character(36) VARCHAR2(36) NOT NULL DP_DDHUPD_GROUP

18 SETID Character(5) VARCHAR2(5) NOT NULL SetID

19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

20 DP_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.

21 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

22 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:

23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

24 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
Default Value: 1

25 DP_DEMANDVALUE Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDVALUE

26 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

27 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

28 INVOICE_DT Date(10) DATE Invoice Date

29 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence

30 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

31 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

32 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

33 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

34 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

35 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

36 SHIP_DATE Date(10) DATE Item Shipping Date

37 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time

38 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled

39 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

40 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

41 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

42 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning

43 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

44 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

45 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

46 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

47 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

48 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer

49 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A

50 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B

51 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C

52 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D

53 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field

54 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B

55 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C

56 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D

57 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2

58 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A

59 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B

60 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C

61 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D

62 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4

63 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6

64 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8

65 CUST_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 A

66 CUST_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 B

67 CUST_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 C

68 CUST_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 D

69 CUST_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 A

70 CUST_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 B

71 CUST_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 C

72 CUST_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 D

73 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

74 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

75 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

76 CUST_CHANNEL Character(15) VARCHAR2(15) NOT NULL Customer Channel

77 CLASSIFICATION Character(10) VARCHAR2(10) NOT NULL Classification

78 PM_DIVISION Character(15) VARCHAR2(15) NOT NULL Division

79 PM_REGION Character(10) VARCHAR2(10) NOT NULL Region

80 PM_TERRITORY Character(15) VARCHAR2(15) NOT NULL Territory

81 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

82 MITBL_DESCR Character(30) VARCHAR2(30) NOT NULL Description

83 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

84 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

85 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type

86 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color

87 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID

88 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10

89 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10

90 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10

91 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10

92 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1

93 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1

94 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1

95 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1

96 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2

97 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30

98 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30

99 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30

100 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30

101 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4

102 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6

103 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8

104 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3

105 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3

106 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3

107 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3

108 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0

109 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0

110 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0

111 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0

112 FORECAST_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Demand Planning Item

113 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type
Prompt Table: DP_UTILIZ_CD_VW

114 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count
Prompt Table: DP_UTILIZ_GP_VW

115 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand

116 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category

117 PRDITM_DESCR Character(30) VARCHAR2(30) NOT NULL Description

118 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Product Char1 A

119 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Product Char1 B

120 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Product Char1 C

121 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Product Char1 D

122 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Product Char 10 A

123 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Product Char 10 B

124 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Product Char 10 C

125 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Product Char 10 D

126 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Product Char 2

127 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Product Char 30 A

128 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Product Char 30 B

129 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Product Char 30 C

130 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Product Char 30 D

131 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Product Char 8

132 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Product Char 6

133 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Product Char 8

134 PROD_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 A

135 PROD_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 B

136 PROD_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 C

137 PROD_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Product Nbr 12.3 D

138 PROD_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 A

139 PROD_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 B

140 PROD_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 C

141 PROD_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Prod Field Nbr 15 D

142 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group

143 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
Default Value: N

144 DP_UOMGROUP Character(10) VARCHAR2(10) NOT NULL DP_UOMGROUP
Prompt Table: DP_UOMGROUPS_VW

145 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

146 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

147 FORECASTER Character(20) VARCHAR2(20) NOT NULL Forecaster

148 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

149 DP_ERRORCOMMENTS Character(254) VARCHAR2(254) NOT NULL DP_ERRORCOMMENTS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_DDH_ID	Character(30)	VARCHAR2(30) NOT NULL	Demand data history table - row ID (key)
2	DP_DDH_ID_LINK	Character(30)	VARCHAR2(30) NOT NULL	Demand data history table - row ID (key)
3	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
4	DP_UPDATE_DMDTYPE	Character(2)	VARCHAR2(2) NOT NULL	DP_UPDATE_DMDTYPE BI=Billing IN=Material Stock Requests OM=Order Management PL=Planning Requests PR=Purchasing Requests RT=Material Returns SO=Shipped Orders
5	DP_TRANSOURCE	Number(1,0)	SMALLINT NOT NULL	DP_TRANSOURCE
6	DP_DEMANDTYPE	Number(1,0)	SMALLINT NOT NULL	DP_DEMANDTYPE
7	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
8	DP_SOURCESTATUS	Signed Number(3,0)	DECIMAL(2) NOT NULL	DP_SOURCESTATUS
9	DP_UPDATESTATUS	Signed Number(2,0)	DECIMAL(1) NOT NULL	0 = Not processed 1 = Processed 2 = Partially Processed -1 = Errored
10	DP_DATESTAMP	DateTime(26)	TIMESTAMP	DP_DATESTAMP
11	DP_DEMANDDATE	Date(10)	DATE	DP_DEMANDDATE
12	DP_DEMANDQTY	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	DP_DEMANDQTY
13	DP_UPD_DATESTAMP	Date(10)	DATE	DP_UPD_DATESTAMP
14	DP_PERIOD	Number(3,0)	SMALLINT NOT NULL	DP_PERIOD
15	DP_YEAR	Number(4,0)	SMALLINT NOT NULL	DP_YEAR
16	DP_UPDATE_NO	Number(3,0)	SMALLINT NOT NULL	DP_UPDATE_NO
17	DP_DDHUPD_GROUP	Character(36)	VARCHAR2(36) NOT NULL	DP_DDHUPD_GROUP
18	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
19	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
20	DP_SEQNUMBER	Number(10,0)	DECIMAL(10) NOT NULL	MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
21	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
22	CM_UNIT_COST	Signed Number(27,15)	DECIMAL(25,15) NOT NULL	07/99 GMG CN800-9.0:
23	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No Default Value: 1
25	DP_DEMANDVALUE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	DP_DEMANDVALUE
26	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
27	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
28	INVOICE_DT	Date(10)	DATE	Invoice Date
29	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
30	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
31	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
32	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
33	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
34	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
35	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
36	SHIP_DATE	Date(10)	DATE	Item Shipping Date
37	SHIP_DTTM	DateTime(26)	TIMESTAMP	Ship Date/Time
38	IN_FULFILL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled
39	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
40	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
41	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
42	SOURCE_CODE	Character(2)	VARCHAR2(2) NOT NULL	8/5/97 lee - inactivated source code 4 - service 1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning
43	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
44	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
45	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
46	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
47	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
48	CORPORATE_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Corporate Customer
49	CUST_FIELD_C10_A	Character(10)	VARCHAR2(10) NOT NULL	Customer Char 10 A
50	CUST_FIELD_C10_B	Character(10)	VARCHAR2(10) NOT NULL	Customer Char 10 B
51	CUST_FIELD_C10_C	Character(10)	VARCHAR2(10) NOT NULL	Customer Char 10 C
52	CUST_FIELD_C10_D	Character(10)	VARCHAR2(10) NOT NULL	Customer Char 10 D
53	CUST_FIELD_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Field
54	CUST_FIELD_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Customer Char1 B
55	CUST_FIELD_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Customer Char1 C
56	CUST_FIELD_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Customer Char1 D
57	CUST_FIELD_C2	Character(2)	VARCHAR2(2) NOT NULL	Customer Char 2
58	CUST_FIELD_C30_A	Character(30)	VARCHAR2(30) NOT NULL	Customer Char 30 A
59	CUST_FIELD_C30_B	Character(30)	VARCHAR2(30) NOT NULL	Customer Char 30 B
60	CUST_FIELD_C30_C	Character(30)	VARCHAR2(30) NOT NULL	Customer Char 30 C
61	CUST_FIELD_C30_D	Character(30)	VARCHAR2(30) NOT NULL	Customer Char 30 D
62	CUST_FIELD_C4	Character(4)	VARCHAR2(4) NOT NULL	Customer Char 4
63	CUST_FIELD_C6	Character(6)	VARCHAR2(6) NOT NULL	Customer Char 6
64	CUST_FIELD_C8	Character(8)	VARCHAR2(8) NOT NULL	Customer Char 8
65	CUST_FIELD_N12_A	Number(16,3)	DECIMAL(15,3) NOT NULL	Customer Nbr 12.3 A
66	CUST_FIELD_N12_B	Number(16,3)	DECIMAL(15,3) NOT NULL	Customer Nbr 12.3 B
67	CUST_FIELD_N12_C	Number(16,3)	DECIMAL(15,3) NOT NULL	Customer Nbr 12.3 C
68	CUST_FIELD_N12_D	Number(16,3)	DECIMAL(15,3) NOT NULL	Customer Nbr 12.3 D
69	CUST_FIELD_N15_A	Number(15,0)	DECIMAL(15) NOT NULL	Cust Field Nbr 15 A
70	CUST_FIELD_N15_B	Number(15,0)	DECIMAL(15) NOT NULL	Cust Field Nbr 15 B
71	CUST_FIELD_N15_C	Number(15,0)	DECIMAL(15) NOT NULL	Cust Field Nbr 15 C
72	CUST_FIELD_N15_D	Number(15,0)	DECIMAL(15) NOT NULL	Cust Field Nbr 15 D
73	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
74	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
75	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
76	CUST_CHANNEL	Character(15)	VARCHAR2(15) NOT NULL	Customer Channel
77	CLASSIFICATION	Character(10)	VARCHAR2(10) NOT NULL	Classification
78	PM_DIVISION	Character(15)	VARCHAR2(15) NOT NULL	Division
79	PM_REGION	Character(10)	VARCHAR2(10) NOT NULL	Region
80	PM_TERRITORY	Character(15)	VARCHAR2(15) NOT NULL	Territory
81	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
82	MITBL_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
83	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
84	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family
85	INV_ITEM_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Item Type
86	INV_ITEM_COLOR	Character(10)	VARCHAR2(10) NOT NULL	Item Color
87	UPC_ID	Character(18)	VARCHAR2(18) NOT NULL	Uniform Product Code ID
88	ITEM_FIELD_C10_A	Character(10)	VARCHAR2(10) NOT NULL	User-defined item field - Character 10
89	ITEM_FIELD_C10_B	Character(10)	VARCHAR2(10) NOT NULL	User-defined item field - Character 10
90	ITEM_FIELD_C10_C	Character(10)	VARCHAR2(10) NOT NULL	User-defined item field - Character 10
91	ITEM_FIELD_C10_D	Character(10)	VARCHAR2(10) NOT NULL	User-defined item field - Character 10
92	ITEM_FIELD_C1_A	Character(1)	VARCHAR2(1) NOT NULL	User-defined item field - Character 1
93	ITEM_FIELD_C1_B	Character(1)	VARCHAR2(1) NOT NULL	User-defined item field - Character 1
94	ITEM_FIELD_C1_C	Character(1)	VARCHAR2(1) NOT NULL	User-defined item field - Character 1
95	ITEM_FIELD_C1_D	Character(1)	VARCHAR2(1) NOT NULL	User-defined item field - Character 1
96	ITEM_FIELD_C2	Character(2)	VARCHAR2(2) NOT NULL	User-defined item field - Character 2
97	ITEM_FIELD_C30_A	Character(30)	VARCHAR2(30) NOT NULL	User-defined item field - Character 30
98	ITEM_FIELD_C30_B	Character(30)	VARCHAR2(30) NOT NULL	User-defined item field - Character 30
99	ITEM_FIELD_C30_C	Character(30)	VARCHAR2(30) NOT NULL	User-defined item field - Character 30
100	ITEM_FIELD_C30_D	Character(30)	VARCHAR2(30) NOT NULL	User-defined item field - Character 30
101	ITEM_FIELD_C4	Character(4)	VARCHAR2(4) NOT NULL	User-defined item field - Character 4
102	ITEM_FIELD_C6	Character(6)	VARCHAR2(6) NOT NULL	User-defined item field - Character 6
103	ITEM_FIELD_C8	Character(8)	VARCHAR2(8) NOT NULL	User-defined item field - Character 8
104	ITEM_FIELD_N12_A	Number(16,3)	DECIMAL(15,3) NOT NULL	User-defined item field - Unsigned Decimal 12.3
105	ITEM_FIELD_N12_B	Number(16,3)	DECIMAL(15,3) NOT NULL	User-defined item field - Unsigned Decimal 12.3
106	ITEM_FIELD_N12_C	Number(16,3)	DECIMAL(15,3) NOT NULL	User-defined item field - Unsigned Decimal 12.3
107	ITEM_FIELD_N12_D	Number(16,3)	DECIMAL(15,3) NOT NULL	User-defined item field - Unsigned Decimal 12.3
108	ITEM_FIELD_N15_A	Number(15,0)	DECIMAL(15) NOT NULL	User-defined item field - Unsigned Decimal 15.0
109	ITEM_FIELD_N15_B	Number(15,0)	DECIMAL(15) NOT NULL	User-defined item field - Unsigned Decimal 15.0
110	ITEM_FIELD_N15_C	Number(15,0)	DECIMAL(15) NOT NULL	User-defined item field - Unsigned Decimal 15.0
111	ITEM_FIELD_N15_D	Number(15,0)	DECIMAL(15) NOT NULL	User-defined item field - Unsigned Decimal 15.0
112	FORECAST_ITEM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Demand Planning Item
113	UTILIZ_CD	Character(4)	VARCHAR2(4) NOT NULL	Utilization Type Prompt Table: DP_UTILIZ_CD_VW
114	UTILIZ_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Utilization Group CYCL=Cycle Count Prompt Table: DP_UTILIZ_GP_VW
115	PROD_BRAND	Character(15)	VARCHAR2(15) NOT NULL	Product Brand
116	PROD_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	Product Category
117	PRDITM_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
118	PROD_FIELD_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Product Char1 A
119	PROD_FIELD_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Product Char1 B
120	PROD_FIELD_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Product Char1 C
121	PROD_FIELD_C1_D	Character(1)	VARCHAR2(1) NOT NULL	Product Char1 D
122	PROD_FIELD_C10_A	Character(10)	VARCHAR2(10) NOT NULL	Product Char 10 A
123	PROD_FIELD_C10_B	Character(10)	VARCHAR2(10) NOT NULL	Product Char 10 B
124	PROD_FIELD_C10_C	Character(10)	VARCHAR2(10) NOT NULL	Product Char 10 C
125	PROD_FIELD_C10_D	Character(10)	VARCHAR2(10) NOT NULL	Product Char 10 D
126	PROD_FIELD_C2	Character(2)	VARCHAR2(2) NOT NULL	Product Char 2
127	PROD_FIELD_C30_A	Character(30)	VARCHAR2(30) NOT NULL	Product Char 30 A
128	PROD_FIELD_C30_B	Character(30)	VARCHAR2(30) NOT NULL	Product Char 30 B
129	PROD_FIELD_C30_C	Character(30)	VARCHAR2(30) NOT NULL	Product Char 30 C
130	PROD_FIELD_C30_D	Character(30)	VARCHAR2(30) NOT NULL	Product Char 30 D
131	PROD_FIELD_C4	Character(4)	VARCHAR2(4) NOT NULL	Product Char 8
132	PROD_FIELD_C6	Character(6)	VARCHAR2(6) NOT NULL	Product Char 6
133	PROD_FIELD_C8	Character(8)	VARCHAR2(8) NOT NULL	Product Char 8
134	PROD_FIELD_N12_A	Number(16,3)	DECIMAL(15,3) NOT NULL	Product Nbr 12.3 A
135	PROD_FIELD_N12_B	Number(16,3)	DECIMAL(15,3) NOT NULL	Product Nbr 12.3 B
136	PROD_FIELD_N12_C	Number(16,3)	DECIMAL(15,3) NOT NULL	Product Nbr 12.3 C
137	PROD_FIELD_N12_D	Number(16,3)	DECIMAL(15,3) NOT NULL	Product Nbr 12.3 D
138	PROD_FIELD_N15_A	Number(15,0)	DECIMAL(15) NOT NULL	Prod Field Nbr 15 A
139	PROD_FIELD_N15_B	Number(15,0)	DECIMAL(15) NOT NULL	Prod Field Nbr 15 B
140	PROD_FIELD_N15_C	Number(15,0)	DECIMAL(15) NOT NULL	Prod Field Nbr 15 C
141	PROD_FIELD_N15_D	Number(15,0)	DECIMAL(15) NOT NULL	Prod Field Nbr 15 D
142	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
143	PRODUCT_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Kit Default Value: N
144	DP_UOMGROUP	Character(10)	VARCHAR2(10) NOT NULL	DP_UOMGROUP Prompt Table: DP_UOMGROUPS_VW
145	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
146	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
147	FORECASTER	Character(20)	VARCHAR2(20) NOT NULL	Forecaster
148	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
149	DP_ERRORCOMMENTS	Character(254)	VARCHAR2(254) NOT NULL	DP_ERRORCOMMENTS