ORD_HDR_COMM (SQL Table)	Index Back
Team Members on S.O. Header This record hold the team members and their associated commission percentage when commissions are defined at the order or quotation header level.

ORD_HDR_COMM

(SQL Table)

Team Members on S.O. Header

This record hold the team members and their associated commission percentage when commissions are defined at the order or quotation header level.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: ORD_HEADER.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_OM

2 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
Default Value: ORD_HEADER.ORDER_NO

3 SUPPORT_TEAM_MBR Character(8) VARCHAR2(8) NOT NULL Team Member
Prompt Table: MEMBER_ACTIV_VW

4 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

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

6 GET_COMM_PCT Character(1) VARCHAR2(1) NOT NULL Get Schedule %
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: ORD_HEADER.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_OM
2	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 Default Value: ORD_HEADER.ORDER_NO
3	SUPPORT_TEAM_MBR	Character(8)	VARCHAR2(8) NOT NULL	Team Member Prompt Table: MEMBER_ACTIV_VW
4	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
5	COMM_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Commission %
6	GET_COMM_PCT	Character(1)	VARCHAR2(1) NOT NULL	Get Schedule % Y/N Table Edit Default Value: N