| # |
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 |
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
|
| 3 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 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
|
| 5 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 6 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 7 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITM_INV_VW2
|
| 8 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 9 |
AUTO_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Number Type
|
| 10 |
DEMAND_DATE |
Date(10) |
DATE |
Demand Date
|
| 11 |
REQUEST_DATE |
Date(10) |
DATE |
Requested
|
| 12 |
ORIG_SCHED_DATE |
Date(10) |
DATE |
Orig Sched Date
|
| 13 |
ORIG_SCHED_TIME |
Time(15) |
TIMESTAMP |
Original Schedule Time
|
| 14 |
SCHED_DATE |
Date(10) |
DATE NOT NULL |
Schedule Date
|
| 15 |
SCHED_TIME |
Time(15) |
TIMESTAMP |
Schedule Time
|
| 16 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 17 |
PICK_DATE |
Date(10) |
DATE |
Picked Date
|
| 18 |
ORIG_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Business Unit
|
| 19 |
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.
|
| 20 |
DESTIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Unit
|
| 21 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
|
| 22 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 23 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 24 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
LOAD_INV_OPN_VW
|
| 25 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID
|
| 26 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 27 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 28 |
SHIP_EARLY_DATE |
Date(10) |
DATE |
Earliest Ship Date
|
| 29 |
SHIP_EARLY_TIME |
Time(15) |
TIMESTAMP |
Earliest Ship Time
|
| 30 |
SHIP_EARLY_DTTM |
DateTime(26) |
TIMESTAMP |
Earliest Ship Date/Time
|
| 31 |
SHIP_LATE_DATE |
Date(10) |
DATE |
Latest Ship Date
|
| 32 |
SHIP_LATE_TIME |
Time(15) |
TIMESTAMP |
Latest Ship Time
|
| 33 |
SHIP_LATE_DTTM |
DateTime(26) |
TIMESTAMP |
Latest Ship Date/Time
|
| 34 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 35 |
SCHED_ARRV_DATE |
Date(10) |
DATE |
Scheduled Arrival Date
|
| 36 |
SCHED_ARRV_TIME |
Time(15) |
TIMESTAMP |
Scheduled Arrival Time
|
| 37 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 38 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 39 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
Set Control Field: SETCNTRLVALUE
|
| 40 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 41 |
PICKLIST_LINE_NO |
Number(7,0) |
INTEGER NOT NULL |
Pick List Sorting Line Number
|
| 42 |
HARD_ALLOC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hard Allocate
|
| 43 |
PROJECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign To Project
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 44 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 45 |
REQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Line Number
|
| 46 |
REQ_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Requisition Schedule Number
|
| 47 |
REQ_DISTRIB_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Distrib Number
|
| 48 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 49 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 50 |
KIT_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Kit Line Number
|
| 51 |
CHARGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Charged Out
Y/N Table Edit
Default Value: N
|
| 52 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 53 |
DESTIN_GL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 54 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDIT_ACCOUNT
Set Control Field: SETCNTRLVALUE
|
| 55 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDIT_ALTACCT
Set Control Field: SETCNTRLVALUE
|
| 56 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 57 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_SC_VW
|
| 58 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_SC_VW
|
| 59 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_SC_VW
|
| 60 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_SC_VW
|
| 61 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_SC_VW
|
| 62 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_SC_VW
|
| 63 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 64 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 65 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 66 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_SC_VW
|
| 67 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_SC_VW
|
| 68 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_SC_VW
|
| 69 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 70 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 71 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 72 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 73 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 74 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 75 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 76 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
Prompt Table:
FERC_CD_TBL
|
| 77 |
INTERUNIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
InterUnit Order ID
|
| 78 |
INTERUNIT_LINE |
Number(5,0) |
INTEGER NOT NULL |
InterUnit Order Line
|
| 79 |
INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
Default Value: O
|
| 80 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 81 |
INV_ITEM_ALIAS |
Character(18) |
VARCHAR2(18) NOT NULL |
Item Alias
|
| 82 |
PRICE_MARKUP_PCT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Price Markup %
|
| 83 |
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.
|
| 84 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 85 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
CUST_SHP_INV_VW
|
| 86 |
SHIP_CUST_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 87 |
SHIP_CUST_NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name 2
|
| 88 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
%EDITTABLE5
|
| 89 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDRSHP_VW
|
| 90 |
CNTCT_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Ship To
Prompt Table:
CUST_CNCT_SH_VW
|
| 91 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 92 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 93 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 94 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 95 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 96 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 97 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 98 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 99 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 100 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 101 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 102 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 103 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 104 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 105 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 106 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 107 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 108 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
|
| 109 |
EXP_RETURN_DATE |
Date(10) |
DATE |
Return Date
|
| 110 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 111 |
TRANSFER_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Transfer Price
|
| 112 |
PACKAGING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packaging Code
Prompt Table:
PACKAGNG_CD_INV
|
| 113 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 114 |
QTY_REQUESTED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested
|
| 115 |
QTY_REQUESTED_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Base
|
| 116 |
DEPLETE_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deplete Inventory Flag
|
| 117 |
CONFIRMED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm
|
| 118 |
QTY_ALLOCATED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Allocated quantity
|
| 119 |
QTY_ALLOC_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity allocation
|
| 120 |
QTY_BACKORDER |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Qty
|
| 121 |
QTY_BACKORDER_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Backorder Base Qty
|
| 122 |
QTY_SHIPPED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 123 |
QTY_PICKED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Picked
|
| 124 |
QTY_SHIPPED_CONV |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Shipped
|
| 125 |
QTY_NEW |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 126 |
QTY_NEW_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 127 |
QTY_DELTA_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Delta Quantity
|
| 128 |
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.
|
| 129 |
QTY_COUNT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Count Quantity
|
| 130 |
CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel PO
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 131 |
SHIPPED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipped
B=Both
N=No
Y=Yes
|
| 132 |
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
|
| 133 |
FULFILL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pick
Y/N Table Edit
Default Value: N
|
| 134 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 135 |
APPROVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 136 |
SHIP_PRIOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
Y/N Table Edit
Default Value: N
|
| 137 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
Default Value: N
|
| 138 |
BCKORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Backorder Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 139 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 140 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
|
| 141 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
Default Value: N
|
| 142 |
PARTIAL_ORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 143 |
SINGLE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No
Y=Yes
|
| 144 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
|
| 145 |
FROZEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both
N=No
Y=Yes
Default Value: N
|
| 146 |
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
|
| 147 |
LOT_ALLOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Lot Allocation
Y/N Table Edit
Default Value: N
|
| 148 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 149 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 150 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 151 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
Default Value: N
|
| 152 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: N
|
| 153 |
HOLD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table:
HOLD_CD
|
| 154 |
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
|
| 155 |
ROUTE_STOP_NBR |
Number(5,0) |
INTEGER NOT NULL |
An identifier used to sequence customer addresses/location for a given route.
Prompt Table:
ROUTE_STOP_VW2
|
| 156 |
RESERVED_DATE |
Date(10) |
DATE |
Date on which a demand line was soft reserved.
|
| 157 |
SELECT_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Check Box
N=No
Y=Yes
Y/N Table Edit
|
| 158 |
DETAILS_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Details
|
| 159 |
USE_ROUTE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether route functionality will be used for a business unit.
|
| 160 |
RECORD_IDENTIFIER |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Identifier
|
| 161 |
RECORD_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Count of Records
|
| 162 |
ALLOW_OVERPICK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether or not overpicking is allowed for a customer or business unit.
|
| 163 |
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.
|
| 164 |
EXT_REF_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
External Reference Number
|
| 165 |
EXT_REF_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
External Reference Line Number
|
| 166 |
PUB_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 167 |
ALLOW_SUB_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether item substitutions are allowed on the order schedule.
|
| 168 |
CHANGE_DEMAND_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Demand Line
Y/N Table Edit
Default Value: N
|
| 169 |
CARTON_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Carton Print Flag
|
| 170 |
SHIPPING_PRINTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Container Print Flag
|
| 171 |
QTY_PACK_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity Packed
|
| 172 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
Y/N Table Edit
|
| 173 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 174 |
COMBO_VALID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
|
| 175 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
REASON_SHIP_VW
|
| 176 |
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
|
| 177 |
PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
|
| 178 |
SUP_PEG_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged
|
| 179 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
Prompt Table:
IN_RULE_B_VW
|
| 180 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
Prompt Table:
IN_RULE_R_VW
|
| 181 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
Prompt Table:
IN_RULE_R_VW
|
| 182 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
Prompt Table:
IN_RULE_O_VW
|
| 183 |
ADDR_OVRD_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
|
| 184 |
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
|
| 185 |
LINE_FIELD_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 A
|
| 186 |
LINE_FIELD_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 B
|
| 187 |
LINE_FIELD_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 C
|
| 188 |
LINE_FIELD_C1_D |
Character(1) |
VARCHAR2(1) NOT NULL |
User Defined C1 D
|
| 189 |
LINE_FIELD_C2 |
Character(2) |
VARCHAR2(2) NOT NULL |
User Defined C2
|
| 190 |
LINE_FIELD_C4 |
Character(4) |
VARCHAR2(4) NOT NULL |
User Defined C4
|
| 191 |
LINE_FIELD_C6 |
Character(6) |
VARCHAR2(6) NOT NULL |
User Defined C6
|
| 192 |
LINE_FIELD_C8 |
Character(8) |
VARCHAR2(8) NOT NULL |
User Defined C8
|
| 193 |
LINE_FIELD_C10_A |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined C10 A
|
| 194 |
LINE_FIELD_C10_B |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined C10 B
|
| 195 |
LINE_FIELD_C10_C |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined C10 C
|
| 196 |
LINE_FIELD_C10_D |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Fld C10 D
|
| 197 |
LINE_FIELD_C30_A |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 A
|
| 198 |
LINE_FIELD_C30_B |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 B
|
| 199 |
LINE_FIELD_C30_C |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 C
|
| 200 |
LINE_FIELD_C30_D |
Character(30) |
VARCHAR2(30) NOT NULL |
User Defined C30 D
|
| 201 |
LINE_FIELD_DTTM_A |
DateTime(26) |
TIMESTAMP |
User Defined DTTM A
|
| 202 |
LINE_FIELD_DTTM_B |
DateTime(26) |
TIMESTAMP |
User Defined DTTM B
|
| 203 |
LINE_FIELD_DTTM_C |
DateTime(26) |
TIMESTAMP |
User Defined DTTM C
|
| 204 |
LINE_FIELD_DTTM_D |
DateTime(26) |
TIMESTAMP |
User Defined DTTM D
|
| 205 |
LINE_FIELD_N11_A |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 A
|
| 206 |
LINE_FIELD_N11_B |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 B
|
| 207 |
LINE_FIELD_N11_C |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 C
|
| 208 |
LINE_FIELD_N11_D |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
User Defined N11.4 D
|
| 209 |
LINE_FIELD_N15_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 A
|
| 210 |
LINE_FIELD_N15_B |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 B
|
| 211 |
LINE_FIELD_N15_C |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 C
|
| 212 |
LINE_FIELD_N15_D |
Number(15,0) |
DECIMAL(15) NOT NULL |
User Defined N15.0 D
|
| 213 |
QTY_PARENT_ORD |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Requested Parent Order
|
| 214 |
OPTIONAL_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Ship Without
Y/N Table Edit
|
| 215 |
QTY_PER |
Number(10,4) |
DECIMAL(9,4) NOT NULL |
Quantity
|
| 216 |
QTY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Per
ASY=Assembly
ORD=Order
|
| 217 |
IN_PROCESS_DATE |
Date(10) |
DATE |
Process Date
Default Value: %date
|
| 218 |
OMB_PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 219 |
CUST_CONTACT |
Character(40) |
VARCHAR2(40) NOT NULL |
Customer Contact
|
| 220 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 221 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 222 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 223 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 224 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax Number
|
| 225 |
DP_KIT_PARENT_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Demand Planning Kit Parent Qty
|
| 226 |
DP_KIT_PARENT_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP Kit Parent Unit of Measure
|
| 227 |
IN_KIT_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Kit protected flag
Y/N Table Edit
Default Value: N
|
| 228 |
IN_TPRC_OVRD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Transfer Prices flag
|