| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 3 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 4 |
TRANSACTION_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
|
| 5 |
LAST_DTTIME |
DateTime(26) |
TIMESTAMP NOT NULL |
Last Date Time
Default Value: %Datetime
|
| 6 |
BCT_DET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
Default Value: 0
|
| 7 |
BCT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the source where the transaction was created
1=Msg Agent
2=Page
3=Batch
4=Auto Gen
5=Message
|
| 8 |
STAGED_DATE |
Date(10) |
DATE |
Staged Date
Prompt Table:
STAGED_DT2IN_VW
|
| 9 |
INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
Prompt Table:
LOT_CONTROL_INV
|
| 10 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
MST_ITM_PRPT_VW
|
| 11 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 12 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 13 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 14 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 15 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 16 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
|
| 17 |
CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
Prompt Table:
CNTR_ID_INV
|
| 18 |
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_STCK_UOM_VW
|
| 19 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 20 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 21 |
TO_CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
|
| 22 |
TO_STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 23 |
TO_STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
|
| 24 |
TO_STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
|
| 25 |
TO_STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
|
| 26 |
TO_STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
|
| 27 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 28 |
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
|
| 29 |
PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Production ID
|
| 30 |
PRDN_AREA_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Production Area
|
| 31 |
COMPL_OP_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Completion Operation Sequence
|
| 32 |
UPDATE_OP_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Back Thru Operation
|
| 33 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 34 |
PICKLIST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
Pick List Sorting Line Number
|
| 35 |
COMPONENT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
|
| 36 |
COMPL_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Completed Qty
|
| 37 |
SCRAPPED_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Scrapped Qty
|
| 38 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 39 |
PERCENT_COMP |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Scrap Prdn Pct
|
| 40 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 41 |
TO_PRODUCTION_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
To Production ID
|
| 42 |
PTWY_PLAN_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Putaway Plan ID
|
| 43 |
PTWYPLAN_LN_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Putaway Line Number
|
| 44 |
SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
|
| 45 |
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
|
| 46 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 47 |
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
|
| 48 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 49 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 50 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 51 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 52 |
OP_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Operation Sequence
|
| 53 |
PEND_CONSUME_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
|
| 54 |
PEND_LOSS_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
|
| 55 |
REVISION |
Character(4) |
VARCHAR2(4) NOT NULL |
01/27/2000 RML Added "As of" label
|
| 56 |
DEVICE_DTTIME |
DateTime(26) |
TIMESTAMP |
Device Date Time
|
| 57 |
UOM_ORIG |
Character(3) |
VARCHAR2(3) NOT NULL |
Original Unit of Measure
|
| 58 |
ORIG_CONSUMED_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Original Consumed Quantity
|
| 59 |
ORIG_COMP_LOSS_QTY |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
Original Component Loss Qty
|
| 60 |
YIELD_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
|
| 61 |
SHIPTO_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
ShipTo SetID
|
| 62 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 63 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 64 |
SHIPMENT_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Shipment Number
|
| 65 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 66 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 67 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 68 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 69 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 70 |
END_TRANS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
End of Transaction Flag
|
| 71 |
ADJUST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
|
| 72 |
DOCUMENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Document
|
| 73 |
EIP_TRANS_SRC_SEQ |
Number(15,0) |
DECIMAL(15) NOT NULL |
Source Transaction Sequence
|
| 74 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 75 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
|
| 76 |
INTERUNIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Order ID
|
| 77 |
INTERUNIT_LINE |
Number(5,0) |
INTEGER NOT NULL |
InterUnit Order Line
|
| 78 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 79 |
UNIT_MEASURE_COUNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure
|
| 80 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 81 |
SHIP_LINE_NO |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Ship Line No
|
| 82 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 83 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 84 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 85 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 86 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 87 |
TRACKING_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tracking Number
|
| 88 |
SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Shippable
|
| 89 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
|
| 90 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
|
| 91 |
SF_BOM_RTG_EFFDT |
Date(10) |
DATE |
12/28/98,eyz, CN#EN800-4.0, new this as a workfield in Completions for the Recipe Management feature.
|
| 92 |
MG_OUTPUT_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
NAS 022399 (CN# EN800-6.0) Field required for Message Agent definition of Multiple Outputs Completion.
|
| 93 |
MG_OUTPUT_ITEM |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
|
| 94 |
MG_OUTPUT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
|
| 95 |
MG_NEW_OUTPUT_QTY |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item quantity on a Bill of Materials. This value is assumed to be in the UOM of the output item it's associated to.
|
| 96 |
MG_OUTPUT_RES_PCT |
Number(3,0) |
SMALLINT NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item's resource allocation percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the inputs (components) on the BOM are used to produce the output (co-product).
|
| 97 |
MG_OUTPUT_COMPL |
Signed Number(13,4) |
DECIMAL(11,4) NOT NULL |
990105 nas (CN# EN800-6.0) This field will contain the user inputted quantity completed of a specific output within completion process.
|
| 98 |
BOM_QTY |
Number(7,0) |
INTEGER NOT NULL |
06/02/00 LAJ (8.0)
Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard.
|
| 99 |
MG_UNPLAN_OUTPUT |
Character(1) |
VARCHAR2(1) NOT NULL |
01/19/99 nas (CN#800-6.0) Created new field.
|
| 100 |
MG_TRANS_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
01/19/99 NAS (CN#800-6.0) Created new field
|
| 101 |
MG_OUTPUT_QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
01/28/98 (CN#EN800-6.0) LAJ...Created
Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly
ORD=Order
|
| 102 |
MG_RELATED_TRANS |
Character(25) |
VARCHAR2(25) NOT NULL |
Related Transaction Control Id
|
| 103 |
CREW_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Crew Reporting
|
| 104 |
MACH_RPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Machine Reporting
|
| 105 |
CREWSIZE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Crew Size
|
| 106 |
MACH_RESOURCES |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Machine Resources
|
| 107 |
LAB_SETUP |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Setup
|
| 108 |
LAB_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Run
|
| 109 |
LAB_FIXED_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Fixed Run
|
| 110 |
LAB_POSTPROD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Labor Post Production
|
| 111 |
MACH_SETUP |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Setup
|
| 112 |
MACH_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Run
|
| 113 |
MACH_FIXED_RUN |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Fixed Run
|
| 114 |
MACH_POSTPROD |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
Machine Post Production
|
| 115 |
WORK_CENTER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Center
|
| 116 |
SF_ENTRY_DATE |
Date(10) |
DATE |
Entry Date
|
| 117 |
MG_ORIG_COMP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
original component ID
|
| 118 |
MG_ORIG_QTY_PER |
Number(16,10) |
DECIMAL(15,10) NOT NULL |
original qty per
|
| 119 |
PARENT_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Item ID
|
| 120 |
SUB_ITM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
11/30/99 RML Added label "Substitute"
|
| 121 |
VENDOR_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Vendor Lot
|
| 122 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 123 |
MG_ISSUE_COMP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
NAS - 09-27-99 Created - Will be used to determine if the program must issue components a standard or will we be expecting component consuption transactions from user/external source.
N=Use comp.issue trans. provided
Y=Program Generate Issue Trans.
Y/N Table Edit
Default Value: Y
|
| 124 |
INV_CART_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Par Location ID
|
| 125 |
COMPARTMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Compartment
|
| 126 |
COUNT_ORDER |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Par Location Count Order
|
| 127 |
CART_COUNT_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Par Location Count Quantity
|
| 128 |
QTY_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Qty Option
01=Count Qty
02=Request Qty
|
| 129 |
SUFFICIENT_STOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Sufficient Stock
N=NOT SUFFICIENT STOCK
Y=SUFFICIENT STOCK
|
| 130 |
IU_REC_ID_GRP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Receipt Identification Group Flag
0 = Group by Receiving Business Unit, Receiver ID. (Default)
1 = Group by Receiving Business Unit, Source Business Unit (origination), Interunit ID, Dest Inventory Business Unit.
2 = Receiving Business Unit, Carrier, Bill of Lading
0=Receiver ID
1=Source BU,InterUnit ID,Dest BU
2=Carrier, Bill of Lading
Default Value: 0
|
| 131 |
IU_REC_SEL_GRP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Interunit Receipt Selection Group Flag
0 = Source Business Unit, Interunit ID, Destination Inventory Business Unit (Default)
1 = Source Business Unit, Shipping Container
0=Source BU, IU ID, Dest BU
1=Source BU, Shipping Container
Default Value: 0
|
| 132 |
SPEEDTYPE_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedType Key
|
| 133 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 134 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 135 |
RTV_DISTRIB_NUM |
Number(5,0) |
INTEGER NOT NULL |
RTV Distribution Number
|
| 136 |
SYNCH_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required
1=Synchronize a Business Unit
2=Synchronize an Item
3=Synchronize a Storage Location
4=Synchronize a Lot ID
5=Synchronize Item at a Stor Loc
Default Value: 0
|
| 137 |
COUNTING_EVENT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Counting Event ID
|
| 138 |
PORT_OF_UNLOADING |
Character(10) |
VARCHAR2(10) NOT NULL |
Port Of Unloading
Prompt Table:
PORT_AIRPRT_VW3
|
| 139 |
IST_RETURN_FLG_IUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat InterUnit Returns
Y/N Table Edit
Default Value: N
|
| 140 |
REPLACEMENT_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
Default Value: NA
|
| 141 |
PARENT_SHIP_CNTR |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Shipping Container ID
|
| 142 |
SF_KANBAN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Kanban ID
|
| 143 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 144 |
FREIGHT_CURRNCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 145 |
GROSS_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 146 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
|
| 147 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 148 |
LOCATION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Location ID
|
| 149 |
VMI_OM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
OM Business Unit Related to VMI
|
| 150 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 151 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 152 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
|
| 153 |
PICK_BATCH_FROM |
Number(10,0) |
DECIMAL(10) NOT NULL |
From Pick Batch ID
|
| 154 |
PICK_BATCH_TO |
Number(10,0) |
DECIMAL(10) NOT NULL |
To Pick Batch ID
|
| 155 |
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.
|
| 156 |
WAVE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
A unique identifier used to group together one or more delivery route codes.
|
| 157 |
TO_BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 158 |
TO_CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier selection
|
| 159 |
TO_FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 160 |
TO_PRO_NUMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Pro Number
|
| 161 |
TO_SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via selection
|
| 162 |
DO_NOT_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Not Ship
N=Ship
Y=Do Not Ship
|
| 163 |
UNIT_MEASURE_SHIP |
Character(3) |
VARCHAR2(3) NOT NULL |
Shipment Unit of Measure
|
| 164 |
SHORT_SHIP_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Short Shipment Option
01=Scrap the Undershipment
02=Return to Location Picked From
|
| 165 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
|
| 166 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 167 |
LOG_ERROR_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Log Errors Option
BT=Transaction Error Log
ML=Message Log
Default Value: BT
|
| 168 |
UNIT_MEASURE_PICK |
Character(3) |
VARCHAR2(3) NOT NULL |
Phys Location Unit of Measure
|
| 169 |
COMP_SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 170 |
COMP_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Component Lot ID
|
| 171 |
NEW_SERIAL |
Character(20) |
VARCHAR2(20) NOT NULL |
New Serial ID
mmt 09/18/03 Adding label for use on mult out compl wedge
|
| 172 |
MG_SHIFT |
Number(2,0) |
SMALLINT NOT NULL |
MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift.
07/23/98 TKI CN#MG800-5.0
Created to replace SHIFT for the database reconcilation project (8.0)
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
|
| 173 |
TMS_EXT_REF_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
TMS Reference ID
|
| 174 |
TMS_EXT_REF_LN_NBR |
Number(7,0) |
INTEGER NOT NULL |
TMS Line Number
|
| 175 |
SHIP_EARLY_DATE |
Date(10) |
DATE |
Earliest Ship Date
|
| 176 |
SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Earliest Ship Time
|
| 177 |
SCHED_DATE |
Date(10) |
DATE |
Schedule Date
|
| 178 |
SCHED_TIME |
Time(15) |
TIMESTAMP |
Schedule Time
|
| 179 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 180 |
UPLOAD_PICKED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Upload After Picking
|
| 181 |
TMS_LOAD_STP_NBR |
Number(5,0) |
INTEGER NOT NULL |
Load Stop Number
|
| 182 |
INCL_LL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Line Level
Default Value: N
|
| 183 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 184 |
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
|
| 185 |
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
|
| 186 |
AUTO_RELEASE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Auto Release Option
00=No Auto-Processing
10=Use Auto-Processing Default
20=Advance to Reserved
30=Advance to Releasable
40=Advance to Released
50=Advance to Confirmed
60=Advance to Shipped
70=Advance to Depleted
Default Value: 00
|
| 187 |
LEAD_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Lead Days for Calendar
|
| 188 |
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
|
| 189 |
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
|
| 190 |
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
|
| 191 |
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
|
| 192 |
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
|
| 193 |
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
|
| 194 |
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
|
| 195 |
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
|
| 196 |
TRACKING_NBR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Tracking Number
|
| 197 |
FREIGHT_CALC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Calculate Flag
|
| 198 |
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
|
| 199 |
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
|
| 200 |
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
|
| 201 |
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
|
| 202 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit
Default Value: N
|
| 203 |
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
|
| 204 |
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
|
| 205 |
IN_DFR_DPL_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
used to override the defer depletions field on in_demand
1=Override to Yes
2=Override to No
|
| 206 |
RSV_AUTO_REL_OPT |
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"
|
| 207 |
RLS_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 208 |
CREW_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Crew Name
|
| 209 |
MACHINE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Machine Code
|
| 210 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 211 |
INCLUDE_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Pre-Relsd Allocations
Y/N Table Edit
|
| 212 |
INCLUDE_RELSD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Released Allocations
Y/N Table Edit
|
| 213 |
IN_CREATE_DMD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Demand
Y/N Table Edit
Default Value: N
|
| 214 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 215 |
IN_FRT_P_BILFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit Billable Freight
|
| 216 |
IN_FRT_P_CMPFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Complete
|
| 217 |
IN_FRT_P_MANFRT |
Character(1) |
VARCHAR2(1) NOT NULL |
External Manifest
|
| 218 |
IN_BEST_WAY_BTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Best Way Freight Option
10=Least Cost
20=By Commit Date
Default Value: 10
|
| 219 |
IN_FRT_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Options
10=Shop For Rates
20=Best Way
30=Use Specified Carrier
40=Carrier with Best Way
Default Value: 30
|
| 220 |
ALLOCATE_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Allocation Source - Why was the allocation created
LT=Lot Allocation
PR=Pre-allocation
SA=Standard Allocation
|
| 221 |
FRT_TYPE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Type Code
|
| 222 |
DEL_VALIDATE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Delivery validation option
10=Validate Only
20=Validate/Assign to New
30=Validate/Auto Assign Open
40=Validate/Auto Assign All
50=Reassign/Consolidate
60=Do Not Validate
Default Value: 60
|
| 223 |
RUN_FREIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Freight
|
| 224 |
AMOUNT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
10/29/08 EGS: Created
1=Override
2=Increment
|
| 225 |
RESEND_FRT_RQST |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Y/N Table Edit
Default Value: N
|
| 226 |
RESEND_FRT_RECV |
Character(1) |
VARCHAR2(1) NOT NULL |
02/02/09 EGS: Created
Y/N Table Edit
Default Value: N
|
| 227 |
RESPONSE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Response Status Code
|
| 228 |
RESPONSE_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Response Status Description
|
| 229 |
ERROR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Error Code
|
| 230 |
ERRORMSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Error Message field
|
| 231 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 232 |
MANIFEST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Manifest
|
| 233 |
FRT_ROLLUP_IND_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates to batch run how the freight will be rolled up.
1=Delivery Freight
2=Rollup Packages/Containers
3=Default from Delivery
|
| 234 |
FRT_REF_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Freight Reference Number
|
| 235 |
FRT_SRVC_DEFN |
Character(50) |
VARCHAR2(50) NOT NULL |
Freight Service Definition
|
| 236 |
SERVICE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Description
|
| 237 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 238 |
FREIGHT_AMT_TOT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 239 |
TOTAL_NBR_PIECES |
Number(6,0) |
INTEGER NOT NULL |
Total Number of Pieces
|
| 240 |
EXT_SHIP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
External Shipment Identifier
|
| 241 |
EXT_PKG_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
External Packaging ID
|
| 242 |
IN_PACKAGE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Package ID
|
| 243 |
CONTAINER_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Container Type
|
| 244 |
SHIPPING_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 245 |
SHIPPING_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Volume
|
| 246 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
|
| 247 |
SHIP_LENGTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Ship Length
|
| 248 |
SHIP_WIDTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Ship Width
|
| 249 |
SHIP_HEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Ship Height
|
| 250 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
|
| 251 |
SERVICE_OPTION |
Character(60) |
VARCHAR2(60) NOT NULL |
Service Option
|
| 252 |
FRT_RPT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Report type
1=Label
2=Report
|
| 253 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 254 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 255 |
PARENT_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Parent Sequence Number
|