IN_BOL_DMD_TMP

(SQL Table)
Index Back

Demand temp

Dedicated temp table containing demand inf_inv, demand inv, ship inf_inv data. Used to hold demand lines for the current processing group.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

3 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
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
5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

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

Prompt Table: BU_ITM_INV_VW2

10 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
11 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV

12 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

13 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

Prompt Table: ROUTE_INV_VW

14 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_SBU_VW

16 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
17 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
18 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

20 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
21 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
22 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
23 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
24 CITY Character(30) VARCHAR2(30) NOT NULL City
25 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
26 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
27 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
28 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
29 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
30 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
31 COUNTY Character(30) VARCHAR2(30) NOT NULL County
32 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

33 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
34 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
35 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

36 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

37 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
38 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
39 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
40 ERROR_FLG Character(1) VARCHAR2(1) NOT NULL Error Flag
41 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp