ORD_SCH_DST (SQL Table)	Index Back
Order Schedule Distributions This record is the child of ORD_SCHEDULE. It holds the revenue,discount and surcharge Distribution ID's and percents.

ORD_SCH_DST

(SQL Table)

Order Schedule Distributions

This record is the child of ORD_SCHEDULE. It holds the revenue,discount and surcharge Distribution ID's and percents.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
Default Value: 1

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

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

6 DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Revenue Dist Code
Prompt Table: DSTCD_REV_OM_VW

7 DST_PCT_REV Signed Number(7,2) DECIMAL(5,2) NOT NULL Revenue Dist Percentage

8 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code
Prompt Table: DSTCD_DIS_OM_VW

9 DST_PCT_DIS Signed Number(7,2) DECIMAL(5,2) NOT NULL Discount Dist Percentage

10 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code
Prompt Table: DSTCD_SUR_OM_VW

11 DST_PCT_SUR Signed Number(7,2) DECIMAL(5,2) NOT NULL Surcharge Dist Percentage

12 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

13 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.

14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line Default Value: 1
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
6	DST_ID_REV	Character(10)	VARCHAR2(10) NOT NULL	Revenue Dist Code Prompt Table: DSTCD_REV_OM_VW
7	DST_PCT_REV	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Revenue Dist Percentage
8	DST_ID_DIS	Character(10)	VARCHAR2(10) NOT NULL	Discount Distribution Code Prompt Table: DSTCD_DIS_OM_VW
9	DST_PCT_DIS	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Discount Dist Percentage
10	DST_ID_SUR	Character(10)	VARCHAR2(10) NOT NULL	Surcharge Distribution Code Prompt Table: DSTCD_SUR_OM_VW
11	DST_PCT_SUR	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Surcharge Dist Percentage
12	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
13	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.
14	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID