| # |
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 |
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
|
| 4 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 5 |
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
|
| 6 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 7 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 8 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 9 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 10 |
SHIP_CNTR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Shipping Container ID
|
| 11 |
CHILD_SHIP_CNTR |
Character(20) |
VARCHAR2(20) NOT NULL |
Child Shipping Container ID
|
| 12 |
SETID_INV_ITEM |
Character(5) |
VARCHAR2(5) NOT NULL |
Inv Items SETID
|
| 13 |
SETID_CUST_SHIPTO |
Character(5) |
VARCHAR2(5) NOT NULL |
Shipto Cust SetID
|
| 14 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 15 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
|
| 16 |
DOC_REFNUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Counter sale document reference number
|
| 17 |
FREIGHT_BILL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Bill Type
OE=Order Entry
SH=Shipping
|
| 18 |
HARMONIZED_CD |
Character(14) |
VARCHAR2(14) NOT NULL |
Harmonized Code
|
| 19 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 20 |
SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date
|
| 21 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 22 |
DELIVERY_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Error
|
| 23 |
DELIVERY_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Delivery Status
00=Pending for Demand
10=Pending for Quote
20=Open
60=Closed for Shipment
70=Delivery Completed
90=Canceled
99=Unassigned
|
| 24 |
DELIVERY_KEY |
Character(40) |
VARCHAR2(40) NOT NULL |
Delivery Key
|
| 25 |
DELIVERY_KEY_LONG |
Character(254) |
VARCHAR2(254) NOT NULL |
|
| 26 |
DELIVERY_ID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 27 |
BILL_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates a sales order is to be billed only, and not fulfilled through Inventory.
|
| 28 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
|
| 29 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
|
| 30 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 31 |
FREIGHT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Error
|
| 32 |
FRT_CHRG_OPEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight can be modified
|
| 33 |
FRT_CHRG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Charge Override
|
| 34 |
FRT_COMMIT_BILLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Committed for Billing
|
| 35 |
FRT_RATE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Rate Status
00=None
10=Requested
20=Received
|
| 36 |
MANIFEST_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Manifest Status
00=None
10=Requested
20=Received
|
| 37 |
DELIV_TOTWK_QTY |
Number(20,4) |
DECIMAL(19,4) NOT NULL |
Delivery Working Quantity
|
| 38 |
DELIV_WORK_QTY |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Working Quantity
|
| 39 |
DELIV_WK_QTY_SHIP |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Shipped Work Qty
|
| 40 |
DELIV_UOM_QTY |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Order Qty UOM
|
| 41 |
DELIV_SHIP_UOM_QTY |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Ship Qty UOM
|
| 42 |
USE_STD_UOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Standard UOM
|
| 43 |
SHIPPING_QTY |
Number(17,4) |
DECIMAL(16,4) NOT NULL |
Shipping Quantity
|
| 44 |
SHIPPING_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 45 |
SHIPPING_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Volume
|
| 46 |
NET_UNIT_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price
|
| 47 |
NET_UNIT_PRICE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price (base)
|
| 48 |
EXTENDED_NET_PRICE |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Ext Net Amount
|
| 49 |
DELIVORD_AMT_BSE |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Total Amount Base
|
| 50 |
EXT_NET_PRC_BASE |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Extended Net Price (base)
|
| 51 |
QTY_SCHEDULED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Scheduled
|
| 52 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 53 |
RATE_DATE_2 |
Date(10) |
DATE |
Exchange Rate Date
|
| 54 |
ORD_SCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
|
| 55 |
TRFT_SRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order
|
| 56 |
TRFT_DISPOSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Supply Source disposition
1=Direct Ship
2=Direct Receipt
|
| 57 |
DROP_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drop Ship
N=No
Y=Yes
|
| 58 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
|
| 59 |
CFG_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configured Kit
Default Value: N
|
| 60 |
DEL_ORD_RESTRICTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Deliveries restricted to order
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order
|
| 61 |
ORDER_TYPE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Type
QUO=Sales Quote
SO=Sales Order
|
| 62 |
SINGLE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No
Y=Yes
|
| 63 |
SOFT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
|
| 64 |
SOFT_ALLOC_FLG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Soft Reserve
|
| 65 |
SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Source Code
|
| 66 |
ADJ_DELIVERY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Delivery Flag
A=Add
M=Move
N=No Action
R=Remove
Default Value: N
|
| 67 |
ADJ_WTVOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Weight or Volume
Y/N Table Edit
Default Value: N
|
| 68 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 69 |
ADJ_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Quantity
Default Value: N
|
| 70 |
ADJ_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Delivery Value
Default Value: N
|
| 71 |
SQL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
SQL Action to Take
D=Delete
I=Insert
N=No Action
U=Update
Default Value: N
|
| 72 |
SHIP_EARLY_DATE |
Date(10) |
DATE |
Earliest Ship Date
|
| 73 |
SELECTTYPE |
Number(1,0) |
SMALLINT NOT NULL |
Selection Type
Default Value: 3
|
| 74 |
DELIV_QTY_PACK |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Packed
|
| 75 |
DELIV_QTY_PACK_BSE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Packed Base
|
| 76 |
DELIV_QTY_PACK_SHP |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Packed Shipped
|
| 77 |
DEMAND_RS_ROW |
Number(7,0) |
INTEGER NOT NULL |
Demand rowset row
|
| 78 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 79 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 80 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
Default Value: 1
|
| 81 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 82 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 83 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 84 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 85 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 86 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 87 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 88 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 89 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 90 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 91 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 92 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 93 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 94 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 95 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 96 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 97 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 98 |
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
|
| 99 |
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
|
| 100 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 101 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 102 |
SHIP_EARLY_DTTM |
DateTime(26) |
TIMESTAMP |
Earliest Ship Date/Time
|
| 103 |
SHIP_LATE_DTTM |
DateTime(26) |
TIMESTAMP |
Latest Ship Date/Time
|
| 104 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
LOAD_INV
|
| 105 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID
|
| 106 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 107 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 108 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 109 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 110 |
KIT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Kit Line Number
|
| 111 |
QTY_PER |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Quantity
|
| 112 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 113 |
OPTIONAL_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Ship Without
|
| 114 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_SBU_VW
|
| 115 |
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.
|
| 116 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 117 |
SHIP_CUST_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 118 |
SHIP_CUST_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name 2
|
| 119 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 120 |
ADDR_OVRD_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
|
| 121 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 122 |
QTY_REQUESTED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Base
|
| 123 |
QTY_PROMISED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Promised Base
|
| 124 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 125 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 126 |
QTY_BACKORDER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Qty
|
| 127 |
QTY_BACKORDER_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Base Qty
|
| 128 |
QTY_PICKED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Picked
|
| 129 |
QTY_PICK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Pick Base
|
| 130 |
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.
|
| 131 |
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.
|
| 132 |
QTY_PACK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity Packed
|
| 133 |
QTY_SHIPPED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 134 |
QTY_SHIP_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Ship Base
|
| 135 |
QTY_SHIPPED_CONV |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 136 |
LAST_QTY_SHIP |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Last Shipped
|
| 137 |
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'.
|
| 138 |
IN_ZERO_PICKED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Picked
|
| 139 |
BCKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 140 |
BACKORDER_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Created Flag
Y/N Table Edit
Default Value: N
|
| 141 |
UNIT_MEASURE_SHIP |
Character(3) |
VARCHAR2(3) NOT NULL |
Shipment Unit of Measure
Prompt Table:
INV_SHIP_UOM_VW
|
| 142 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 143 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 144 |
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
|
| 145 |
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
|
| 146 |
ROUTE_STOP_NBR |
Number(5,0) |
INTEGER NOT NULL |
An identifier used to sequence customer addresses/location for a given route.
|
| 147 |
FRT_CHRG_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
|
| 148 |
FRT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Rule Code
|
| 149 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
|
| 150 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table:
SHIP_HDR_INV
|
| 151 |
PRO_NUMBER |
Character(40) |
VARCHAR2(40) NOT NULL |
Pro Number
|
| 152 |
TMS_LOAD_STP_NBR |
Number(5,0) |
INTEGER NOT NULL |
Load Stop Number
|
| 153 |
DELIV_UNIT_VOL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Unit Volume
|
| 154 |
DELIV_UNIT_WT |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Delivery Unit Weight
|
| 155 |
DELIV_UOM_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Volume UOM
|
| 156 |
DELIV_UOM_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Weight UOM
|
| 157 |
DELIV_UOM_SHIP_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship UOM for volume conversion
|
| 158 |
DELIV_UOM_SHIP_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship UOM for weight conversion
|
| 159 |
DELIV_UNIT_VOL_CNV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Unit volume conversion rate
|
| 160 |
DELIV_UNIT_WT_CNV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Unit weight conversion rate
|
| 161 |
DELIV_USE_UOM_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use UNIT_MEASURE_SHIP
Y/N Table Edit
Default Value: N
|
| 162 |
PREF_CARRIER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
Default Value: N
|
| 163 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 164 |
PICKLIST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
Pick List Sorting Line Number
|
| 165 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 166 |
DEMAND_DATE |
Date(10) |
DATE |
Demand Date
|
| 167 |
COMPLETED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
N=Not Completed
Y=Complete
Default Value: N
|
| 168 |
DMD_DLV_LOAD_SRC |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand
00=Dummy Demand
10=Demand from Run Control
90=Demand not in Run Control
|
| 169 |
VALID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Valid XLAT flag
Default Value: Y
|
| 170 |
DELETE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Loaded Items
Default Value: Y
|
| 171 |
DELIVERY_KEY1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Delivery Key
|
| 172 |
NET_UNIT_LAST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price
|
| 173 |
NET_UNIT_LAST_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price (base)
|
| 174 |
IN_FRT_USAGE |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both
|
| 175 |
SHIP_ID_EST |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Ship ID
|
| 176 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 177 |
RATE_DIV_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 178 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 179 |
RATE_MULT_2 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 180 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 181 |
RT_TYPE_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
|