IN_DMD_TPRC_HST (SQL Table)	Index Back
Inv Demand Transfer Prc Hist History record for IN_DEMAND_TPRC, child table of IN_DEMAND, which contains transfer price breakdown by cost element for InterUnit Transfers

IN_DMD_TPRC_HST

(SQL Table)

Inv Demand Transfer Prc Hist

History record for IN_DEMAND_TPRC, child table of IN_DEMAND, which contains transfer price breakdown by cost element for InterUnit Transfers

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

4 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
Default Value: OPR_DEF_TBL_IN.DEMAND_SOURCE

5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
Default Value: OPR_DEF_TBL_IN.SOURCE_BUS_UNIT

6 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

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

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

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

10 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

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

12 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price

13 TRANSFER_COST_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price Dest

14 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

15 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID

16 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
4	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 Default Value: OPR_DEF_TBL_IN.DEMAND_SOURCE
5	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Default Value: OPR_DEF_TBL_IN.SOURCE_BUS_UNIT
6	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
7	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
8	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
11	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
12	TRANSFER_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price
13	TRANSFER_COST_DEST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price Dest
14	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
15	INTERUNIT_ID	Character(10)	VARCHAR2(10) NOT NULL	InterUnit Order ID
16	INTERUNIT_LINE	Number(5,0)	INTEGER NOT NULL	InterUnit Order Line