| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
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: IN
|
| 3 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Default Value: ISSUE_HDR4_VW.BUSINESS_UNIT
Prompt Table:
SP_BU_FS_NONVW
|
| 4 |
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: NEXT
Prompt Table:
DM_ISS_AN_VW
|
| 5 |
REQUEST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Type
E=External Order
I=Internal Issue
U=InterUnit Transfer
V=Supplier Returns
Default Value: I
|
| 6 |
INTERNAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal Order
Y/N Table Edit
Default Value: Y
|
| 7 |
FULFILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pick
Y/N Table Edit
Default Value: N
|