| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PROCESSING_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUIN_NONVW
|
| 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 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 0
|
| 12 |
ITEM_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Description
|
| 13 |
ITM_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Description
|
| 14 |
RELEASE_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
08/2004 rcw: Order Release Instance
|
| 15 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 16 |
PICKLIST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
Pick List Sorting Line Number
|
| 17 |
PICK_RELEASE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Release ID
|
| 18 |
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
|
| 19 |
EXT_REF_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
External Reference Number
|
| 20 |
EXT_REF_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
External Reference Line Number
|
| 21 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 22 |
IN_PRIOR_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Inventory Fulfillment State at the time the demand line was cancelled
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Picking Confirmed
60=Shipped
70=Depleted
90=Canceled
|
| 23 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 24 |
GRP_SEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence used to uniquely identify a row in the Fulfillment Group stage table.
|
| 25 |
DTL_SEQ_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence used to uniquely identify a row in the Fulfillment Details stage table.
|
| 26 |
PASS_THROUGH_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line
|
| 27 |
COMMIT_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be committed to the database as one unit of work that may be smaller than the processing group. Commit Group will always be contained within a Processing Group. When processing, if Pass-through Level is greater than the specified Commit Level, the Commit Group will be expanded to include all data at the Pass-through Level.
|
| 28 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
|
| 29 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
|
| 30 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
|
| 31 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
|
| 32 |
RESERVED_CRIT_MET |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
Default Value: N
|
| 33 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 34 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 35 |
QTY_BACKORDER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Qty
|
| 36 |
QTY_BACKORDER_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Base Qty
|
| 37 |
QTY_CNCL_BKORD |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Cancel Backorder Qty
|
| 38 |
QTY_CNCL_BKORD_BSE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Cancel Backorder Base Qty
|
| 39 |
QTY_PEGGED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
06/16/04 EGS: Created.
|
| 40 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
|
| 41 |
QTY_PICK_OVRIDE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
|
| 42 |
QTY_PICK_OVR_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
|
| 43 |
QTY_PROMISED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Promised Base
|
| 44 |
QTY_PROMISED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Promised
|
| 45 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 46 |
QTY_REQUESTED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Base
|
| 47 |
QTY_RESERVED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Reserved Base
|
| 48 |
QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Ship Base
|
| 49 |
QTY_TO_RELEASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to determine how much Qty needs to be Allocated at the Physical Inventory level.
|
| 50 |
QTY_TO_REL_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to determine how much Qty needs to be Allocated at the Physical Inventory level - Base
|
| 51 |
QTY_PICKED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Picked
|
| 52 |
QTY_PICK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Pick Base
|
| 53 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
|
| 54 |
QTY_DPI_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Field used to determine how much Qty needs to be Allocated at the Physical Inventory level - Base
|
| 55 |
LAST_QTY_SHIP |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Last Shipped
|
| 56 |
LAST_QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.
|
| 57 |
IN_WORK_QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Working quanitity (in Base UOM)
|
| 58 |
IN_WORK_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Working quantity
|
| 59 |
PCK_QTY_ORDUOM |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Ordered In Order UOM
|
| 60 |
PCK_QTY_STD |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Ordered In Std UOM
|
| 61 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
INV_ORDR_UOM_VW
|
| 62 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 63 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 64 |
QTY_PREC_STD |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal Number
W=Whole Number
|
| 65 |
ROUND_RULE_STD |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
N=Natural Round
U=Round Up
|
| 66 |
CONVERSION_RATE1 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Req UOM conversion rate
|
| 67 |
QTY_PREC_ORDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal Number
W=Whole Number
|
| 68 |
ROUND_RULE_ORDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
N=Natural Round
U=Round Up
|
| 69 |
ALLOCATION_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation is complete
N=Incomplete
Y=Complete
Y/N Table Edit
Default Value: N
|
| 70 |
ALLOW_OVERPICK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit
Default Value: N
|
| 71 |
ALLOW_SUB_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether item substitutions are allowed on the order schedule.
Y/N Table Edit
Default Value: N
|
| 72 |
AUTO_PICK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit
Default Value: N
|
| 73 |
CFG_CODE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both
N=No
Y=Yes
|
| 74 |
CONFIRMED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm
|
| 75 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 76 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 77 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 78 |
FULFILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pick
Y/N Table Edit
Default Value: N
|
| 79 |
HARD_ALLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hard Allocate
Y/N Table Edit
Default Value: N
|
| 80 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: N
|
| 81 |
HOLD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold From Further Processing
Y/N Table Edit
Default Value: Y
|
| 82 |
IN_PICKPLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Plan
Y/N Table Edit
Default Value: N
|
| 83 |
CARTON_LABELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Carton Labels
Y/N Table Edit
Default Value: N
|
| 84 |
EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit
Default Value: N
|
| 85 |
USG_LABEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Item Usage Labels
Y/N Table Edit
Default Value: N
|
| 86 |
SEL_ORD_REL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
11/99 Created for outbound messaging.
Y/N Table Edit
Default Value: N
|
| 87 |
IN_FPB_OK |
Character(1) |
VARCHAR2(1) NOT NULL |
Fixed Picking Bin OK
Y/N Table Edit
Default Value: Y
|
| 88 |
IN_ORD_QTY_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Qty Changed (UOM Conv)
Y/N Table Edit
Default Value: N
|
| 89 |
IN_ORD_REL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by Order Release Run Control
1=Create Allocations
2=Make Suggestions
3=Release Only
4=Create Pre-Allocations
5=Deallocation
6=Cancel Allocations
7=Return to Unfulfilled
8=Return to Releasable
9=Regenerate Output
A=Return to Released
B=Return to Confirmed
S=Select an Action
Default Value: 1
|
| 90 |
IN_QTY_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Found
Y/N Table Edit
Default Value: Y
|
| 91 |
IN_RUN_LIKE_PULL |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Like Pull
Y/N Table Edit
Default Value: N
|
| 92 |
IN_SUB_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Substitute Found
Y/N Table Edit
Default Value: N
|
| 93 |
IN_UOM_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
UOM Error
1=OrdQty: Round Down to 0
2=OrdQty: Input Mod-Auto<>1
3=OrdQty:Truncate to 0
4=OrdQty: Input Modified - Error
5=Pick Location UOM Error
6=Substitute UOM Error
N=No UOM Errors
Default Value: N
|
| 94 |
IN_ZERO_PICKED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Picked
|
| 95 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 96 |
LOT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Lot Allocation
Y/N Table Edit
Default Value: N
|
| 97 |
LOT_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Control
N=N
Y=Y
|
| 98 |
PICKLIST_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Picklist Printed
Y/N Table Edit
Default Value: N
|
| 99 |
QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Bid factor Flag
Y/N Table Edit
Default Value: N
|
| 100 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 101 |
RESERVE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Reservation Status
10=Pending
11=Unreserved
12=Shortage, Rules Not Met
15=Reserved, Rules Not Met
21=Shortage, Line Rule Met
22=Reserved, Line Rule Met
31=Shortage, All Rules Met
32=Reserved, All Rules Met
40=Reserve Run
99=Invalid
|
| 102 |
RESERVED_DTTM |
DateTime(26) |
TIMESTAMP |
Reserved Date/Time
|
| 103 |
SERIAL_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial Control
N=N
Y=Y
|
| 104 |
SHIP_SERIAL_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Serial Control
|
| 105 |
DEMAND_DATE |
Date(10) |
DATE |
Demand Date
|
| 106 |
PICK_DTTM |
DateTime(26) |
TIMESTAMP |
Picked Date/Time
|
| 107 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 108 |
SHIP_EARLY_DTTM |
DateTime(26) |
TIMESTAMP |
Earliest Ship Date/Time
|
| 109 |
SHIP_LATE_DTTM |
DateTime(26) |
TIMESTAMP |
Latest Ship Date/Time
|
| 110 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 111 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 112 |
ORIG_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Used to identify the original item ordered, in case an item substitution has taken place.
|
| 113 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 114 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 115 |
KIT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Kit Line Number
|
| 116 |
QTY_PER |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Quantity
|
| 117 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 118 |
OPTIONAL_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Ship Without
|
| 119 |
DP_KIT_PARENT_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Demand Planning Kit Parent Qty
|
| 120 |
DP_KIT_PARENT_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP Kit Parent Unit of Measure
|
| 121 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 122 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 123 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 124 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_SBU_VW
|
| 125 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 126 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 127 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 128 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 129 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 130 |
SHIP_CUST_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 131 |
SHIP_CUST_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name 2
|
| 132 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 133 |
ADDR_OVRD_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
|
| 134 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
|
| 135 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 136 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 137 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_HDR_INV
|
| 138 |
SHIP_LINE_NO |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Ship Line No
|
| 139 |
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.
|
| 140 |
ROUTE_STOP_NBR |
Number(5,0) |
INTEGER NOT NULL |
An identifier used to sequence customer addresses/location for a given route.
|
| 141 |
PACKAGING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packaging Code
Prompt Table:
PACKAGNG_CD_INV
|
| 142 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 143 |
SHIP_ID_EST |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Ship ID
|
| 144 |
MAX_PICK_TOLERANCE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Used to indicate the allowable percentage of overshipment for a customer or business unit.
|
| 145 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
REASON_SHIP_VW
|
| 146 |
TRANSFER_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
Default Value: 0
|
| 147 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
|
| 148 |
TMS_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TMS Process Flag
Default Value: N
|
| 149 |
TMS_EXT_REF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
TMS Reference ID
|
| 150 |
TMS_EXT_REF_LN_NBR |
Number(7,0) |
INTEGER NOT NULL |
TMS Line Number
|
| 151 |
TMS_LOAD_STP_NBR |
Number(5,0) |
INTEGER NOT NULL |
Load Stop Number
|
| 152 |
SETID_INV_ITEM |
Character(5) |
VARCHAR2(5) NOT NULL |
Inv Items SETID
|
| 153 |
MSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
|
| 154 |
MSGNUM |
Number(5,0) |
INTEGER NOT NULL |
Message Number
|
| 155 |
PROMISE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Promise Option
2=Perform ATP Reservations
|
| 156 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 157 |
ATP_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field determines the window in which an order line can be ATP-reserved. If the scheduled shipment date is within today + ATP lead days, then the order line may be ATP-reserved; if the scheduled shipment date is outside this window, the order line cannot be ATP-reserved.
|
| 158 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
|
| 159 |
CONTAINER_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Picking from Containers
|
| 160 |
CROSS_DOCK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Dock Flag
A=All receipts
N=No cross docking
P=Pegged receipts, only
Y=Non-pegged receipts, only
|
| 161 |
DFLT_SHP_LOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Ship Location Option
1=Default Ship Staging Location
2=Default Cross Docking Location
3=Default Putaway Location
4=Default Inspection Location
5=Default Fixed Picking Bin Loc
6=Manually Entered Location
7=Default Pegging Location
|
| 162 |
FPB_WORKFLOW_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fixed Pick Workflow
|
| 163 |
FPB_ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Fixed Picking Bin Role Name
|
| 164 |
FPB_RTE_CNTL_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Route Control Type
|
| 165 |
FPB_RTE_FROM_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Value
|
| 166 |
FPB_RTE_TO_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Value
|
| 167 |
IN_PRINT_PICK_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Pick Quantity option
0=Print Pick Quantity Only
1=Print All Quantity Fields
|
| 168 |
IN_PICK_QTY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Quantity Option
0=Use Available Balance
1=Use Planned Pick Quantity
|
| 169 |
IN_SHRTG_RLS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicating whether a demand line should be released (e.g. placed on a pick plan) as a shortage.
0=Release Shortage
1=Use Partial Quantity Logic
2=Do Not Release Shortage
|
| 170 |
LOC_TRANS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Location Detail
|
| 171 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
|
| 172 |
PICKING_DT_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Date Option
01=Earliest Expiration Dt (FEFO)
02=Earliest Available Lot (FIFO)
03=Earliest Staged Date (FIFO)
04=Latest Staged Date (LIFO)
|
| 173 |
PICKING_NOTES |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Notes
00=None
01=Largest Batch First
02=Smallest Batch First
03=Broken Pallet First
|
| 174 |
PICKING_PLAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Picking Plan
01=Fixed Pick Location
03=Default Putaway Location
05=Default Shipment Location
08=Container Option
09=Pick by Date
10=All Available Locations
|
| 175 |
PICKING_TIEBREAKER |
Character(2) |
VARCHAR2(2) NOT NULL |
Picking Location Tiebreaker
01=Fewest Locations
02=Pick To Clear
|
| 176 |
PICK_PLAN_BY_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Unit of Measure
|
| 177 |
PRINT_ITEM_SUBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Substitutes
N=No
Y=Yes
|
| 178 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 179 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 180 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 181 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 182 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 183 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
|
| 184 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
|
| 185 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
|
| 186 |
IN_ALLOW_SPLIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Split
Y/N Table Edit
Default Value: N
|
| 187 |
PRINT_SUB_ITM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print option used to print item substitute.
0=Print All The Time
1=Print At Zero
2=Print At Partial
Default Value: 1
|
| 188 |
SETDEFAULT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to set default values ot user options.
Y/N Table Edit
Default Value: Y
|
| 189 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
|
| 190 |
DESCR60_2 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 191 |
STAGED_DATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON
|
| 192 |
UNDO_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Undo Action
|
| 193 |
IN_ALLOC_ERROR |
Character(3) |
VARCHAR2(3) NOT NULL |
Allocation Error Message
000=No Errors Found
001=Quantity Shortage - BU Level
002=Quantity Shortage - Loc Level
010=No Fixed Picking Bin
011=Fixed Picking - Not enough
012=Fixed Picking - none available
100=UOM Error encountered
101=UOM Error - Reservations
105=Pick Location UOM Error
106=Substitute UOM Error
999=Skip Row
Default Value: 000
|
| 194 |
SUB_ITM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
11/30/99 RML Added label "Substitute"
|
| 195 |
PUB_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 196 |
PARTIAL_ORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No
Y=Yes
|
| 197 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 198 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 199 |
MAX_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Sequence Number
|
| 200 |
ORIG_QTY_ALLC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Original Qty Allocated Base
|
| 201 |
ORIG_QTY_ALLOC |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Original Qty Allocated
|
| 202 |
SHIP_PRIOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
|
| 203 |
IN_RLS_SHRTG |
Character(1) |
VARCHAR2(1) NOT NULL |
Release Shortage
Y/N Table Edit
Default Value: Y
|
| 204 |
IN_ALLOC_RESERV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Only Reserved
Y/N Table Edit
Default Value: N
|
| 205 |
WO_RESERVE_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Reservation rule
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Batch Reserve Only
Default Value: 2
|
| 206 |
ROWCOUNT1 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Row Count
|
| 207 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 208 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 209 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 210 |
RTV_DISTRIB_NUM |
Number(5,0) |
INTEGER NOT NULL |
RTV Distribution Number
|
| 211 |
IN_DEFER_DEPLETION |
Character(1) |
VARCHAR2(1) NOT NULL |
Defer Depletions
|
| 212 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|