| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 2 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 3 |
HIST_DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date/Time Purged
|
| 4 |
GRP_SEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence used to uniquely identify a row in the Fulfillment Group stage table.
|
| 5 |
BCT_DET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
Default Value: 0
|
| 6 |
EIP_TRANS_SRC_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Source Transaction Sequence
|
| 7 |
DEVICE_DTTIME |
DateTime(26) |
TIMESTAMP |
Device Date Time
Default Value: %DateTime
|
| 8 |
SELECT_UNFULFILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit
Default Value: N
|
| 9 |
SELECT_RELEASABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit
Default Value: N
|
| 10 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
|
| 11 |
SELECT_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit
Default Value: N
|
| 12 |
SL_DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand
|
| 13 |
SL_SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Business Unit selection
|
| 14 |
SL_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
|
| 15 |
TO_ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Number selection
|
| 16 |
SL_ORDER_INT_LINE |
Number(5,0) |
INTEGER NOT NULL |
Order Line selection
|
| 17 |
TO_ORDER_INT_LINE |
Number(5,0) |
INTEGER NOT NULL |
Order Line selection
|
| 18 |
SL_SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
05/07/04 PWF Added field for new 8.9 data model changes
|
| 19 |
TO_SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
05/07/04 PWF Added field for 8.9 data model changes
|
| 20 |
SL_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item selection
Prompt Table:
MST_ITM_PRPT_VW
|
| 21 |
SL_DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line Number selection
|
| 22 |
SL_SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer selection
|
| 23 |
SL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID selection
Prompt Table:
DMND_CUST_ID_VW
|
| 24 |
SL_ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number selection
|
| 25 |
SL_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location selection
|
| 26 |
SL_LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load selection
Prompt Table:
SHIP_PRMPT13_VW
|
| 27 |
SL_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
|
| 28 |
TO_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
|
| 29 |
SL_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
|
| 30 |
TO_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
|
| 31 |
SL_ROUTE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route selection
|
| 32 |
SL_WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route Group selection
|
| 33 |
TO_WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Route Group selection
|
| 34 |
SL_PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product selection
|
| 35 |
SL_DEMAND_DATE |
Date(10) |
DATE |
Demand Date selection
|
| 36 |
TO_DEMAND_DATE |
Date(10) |
DATE |
Demand Date selection
|
| 37 |
SL_SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date selection
|
| 38 |
SL_SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time
|
| 39 |
TO_SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date selection
|
| 40 |
TO_SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time selection
|
| 41 |
SL_SHIP_EARLY_DATE |
Date(10) |
DATE |
Ship Early Date selection
|
| 42 |
SL_SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Ship Early Time selection
|
| 43 |
TO_SHIP_EARLY_DATE |
Date(10) |
DATE |
Ship Early Date selection
|
| 44 |
TO_SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Ship Early Time selection
|
| 45 |
SL_SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship ID Selection
|
| 46 |
SL_CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer Purchase Order selection
|
| 47 |
SL_CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract ID selection
|
| 48 |
SL_PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID selection
|
| 49 |
TO_PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID selection
|
| 50 |
SL_PICKLIST_LINE |
Number(7,0) |
INTEGER NOT NULL |
Pick List Line Number selection
|
| 51 |
TO_PICKLIST_LINE |
Number(7,0) |
INTEGER NOT NULL |
Pick List Line Number selection
|
| 52 |
SL_SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Ship Container selection
|
| 53 |
SL_TMS_EXT_REF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Transportation Management System (TMS) Reference ID selection
|
| 54 |
SL_TMS_EXT_REF_LN |
Number(7,0) |
INTEGER NOT NULL |
Transportation Management System (TMS) Reference Line
|
| 55 |
SL_EXT_REF_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
External Reference Number selection
|
| 56 |
SL_EXT_REF_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
External Reference Line selection
|
| 57 |
SL_PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 58 |
TO_PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 59 |
SL_PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 60 |
SL_DELIVERY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
From Delivery ID
|
| 61 |
TO_DELIVERY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
To Delivery ID
|
| 62 |
AUTO_PICK_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 63 |
AUTO_SHIP_SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
Default Value: 0
|
| 64 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_HDR_INV_VW
|
| 65 |
SHIP_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Id should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 66 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
SHIP_PRMPT9_VW
|
| 67 |
CARRIER_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Carrier ID should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 68 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 69 |
SHIP_TYPE_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Via should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 70 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 71 |
SHIP_DATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Date should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 72 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 73 |
SHIP_TIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Ship Time should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 74 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 75 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 76 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 77 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 78 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 79 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Prompt Table:
SHIP_PRMPT11_VW
|
| 80 |
BILL_OF_LADING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Bill of Lading should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 81 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 82 |
PRO_NUMBER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Pro Number should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 83 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 84 |
FREIGHT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Freight Amount should be overridden with a blank (zero) value
Y/N Table Edit
Default Value: N
|
| 85 |
FREIGHT_CALC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Calculate Flag
|
| 86 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 87 |
FREIGHT_TERMS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Freight Terms should be overridden with a blank value
Y/N Table Edit
Default Value: N
|
| 88 |
LEAD_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Lead Days for Calendar
|
| 89 |
USE_LEAD_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Lead Days
1=Use Fulfillment Lead Days
2=Override Fulfillment Lead Days
3=Ignore Lead Days
Default Value: 1
|
| 90 |
TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracking Number
|
| 91 |
TRACKING_NBR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Tracking Number
|
| 92 |
SHORT_SHIP_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Short Shipment Option
01=Scrap the Undershipment
02=Return to Location Picked From
|
| 93 |
SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
|
| 94 |
COMPLETE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location
1=Pick Line Complete
2=Pick Batch Complete
3=Pick Line as Planned
4=Pick Batch as Planned
5=Process Location - Incomplete
6=Complete Pick - Zero Quantity
7=Complete Pick - Leave Alone
8=Complete Pick - Dft Ship Loc
A=Use Defaults
B=No Action
|
| 95 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 96 |
IN_FRT_P_BILFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit Billable Freight
|
| 97 |
IN_FRT_P_CMPFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Complete
|
| 98 |
IN_FRT_P_MANFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
External Manifest
|
| 99 |
FRT_TYPE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Type Code
|