| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_OM_NONVW
|
| 5 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
Default Value: OM
|
| 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
Prompt Table:
OM_MASS_ORD_VW
|
| 7 |
ORDER_NO_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To Order No
Prompt Table:
OM_MASS_ORD_VW
|
| 8 |
FROM_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
From Line
|
| 9 |
TO_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
To Line
|
| 10 |
FROM_SCHED_NUM |
Number(6,0) |
INTEGER NOT NULL |
Team sequence number
|
| 11 |
TO_SCHED_NUM |
Number(6,0) |
INTEGER NOT NULL |
Team sequence number
|
| 12 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
Prompt Table:
SP_BUIN_NONVW
|
| 13 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
CUST_SHP_A1_VW
|
| 14 |
ADDRESS_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Address - Ship To
Prompt Table:
CUST_ADDRSHP_VW
|
| 15 |
FROM_SCH_SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
From Schedule Ship Datetime
|
| 16 |
TO_SCH_SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
To Schedule Ship Datetime
|
| 17 |
FROM_SCH_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
From Schedule Arrival Datetime
|
| 18 |
TO_SCH_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
To Schedule Arrival Datetime
|
| 19 |
FROM_REQ_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
From Request Arrival Datetime
|
| 20 |
TO_REQ_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
To Request Arrival Datetime
|
| 21 |
FROM_REQ_SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
From Request Ship Datetime
|
| 22 |
TO_REQ_SHIP_DTTM |
DateTime(26) |
TIMESTAMP |
To Request Ship Datetime
|
| 23 |
DELIVERY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Delivery ID
Prompt Table:
OCH_DELIVERY_VW
|
| 24 |
CARRIER_ID_SELECT |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
CARRIER_ID
|
| 25 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 26 |
CNTCT_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Contact Name1
|
| 27 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
SCON_HDR
|
| 28 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 29 |
INV_ITEM_ID_SELECT |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
MASTER_ITEM_TBL
|
| 30 |
LOAD_ID_SELECT |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
%EDITTABLE12
|
| 31 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 32 |
ORD_SCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
Prompt Table:
OMEC_ORDSTAT_VW
|
| 33 |
PARENT_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Parent Product Id
|
| 34 |
PROD_SUBSTITUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Product Substitutions
N=No
Y=Yes
|
| 35 |
PRODUCT_ID_SELECT |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
|
| 36 |
ROUTE_CD_SELECT |
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:
%EDITTABLE13
|
| 37 |
ROUTE_STOP_NBR |
Number(5,0) |
INTEGER NOT NULL |
An identifier used to sequence customer addresses/location for a given route.
|
| 38 |
SHIP_TYPE_SELECT |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 39 |
SINGLE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No
Y=Yes
|
| 40 |
SELECT_ADDR_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 41 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDRSHP_VW
|
| 42 |
SELECT_CNTCT_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 43 |
CNTCT_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Ship To
Prompt Table:
CUST_CNCT_SH_VW
|
| 44 |
SECTION_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Date Init. Issue # Description
092804 JJM F-CJORG-L1CX3 Sprinklebacks
|
| 45 |
HEADER_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
Y/N Table Edit
Default Value: N
|
| 46 |
LINE_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
Y/N Table Edit
Default Value: N
|
| 47 |
AERP |
Character(50) |
VARCHAR2(50) NOT NULL |
Automated Exporter Rptg Prgm
|
| 48 |
SEL_AERP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 49 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
|
| 50 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table:
%EDITTABLE8
|
| 51 |
SEL_CARRIER_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 52 |
CARRIER_ID_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Carrier ID
Prompt Table:
%EDITTABLE8
|
| 53 |
SEL_CARRIER_ID_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 54 |
CCI_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Canadian Customs Invoice
N=No
Y=Yes
|
| 55 |
COO_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Certificate of Origin
N=No
Y=Yes
|
| 56 |
CUST_PICKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No
Y=Yes
|
| 57 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table:
CM_DISTR_TYPE
|
| 58 |
SELECT_DISTR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 59 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
|
| 60 |
EXPORT_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 61 |
SELECT_EXP_APPL_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 62 |
EXPORT_LIC_APPL |
Character(3) |
VARCHAR2(3) NOT NULL |
Applied For
NO=No
YES=Yes
|
| 63 |
EXPORT_LIC_EXPIRE |
Date(10) |
DATE |
Expiration Date
|
| 64 |
SELECT_EXP_LIC_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 65 |
EXPORT_LIC_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Export License Nbr
|
| 66 |
SELECT_EXP_LIC_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 67 |
EXPORT_LIC_REC |
Character(3) |
VARCHAR2(3) NOT NULL |
License Received
NO=No
YES=Yes
|
| 68 |
EXPORT_LIC_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Export License Required
NO=No
YES=Yes
|
| 69 |
EXPORT_LIC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
License Type
GDST=General
SPEC=Specific
|
| 70 |
EXPORT_LIC_VALUE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
License Value
|
| 71 |
SELECT_EXP_LIC_VAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 72 |
EXPORT_REC_DT |
Date(10) |
DATE |
Date Received
|
| 73 |
SELECT_EXP_REC_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 74 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
%EDITTABLE7
|
| 75 |
SEL_FRT_TERMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 76 |
FREIGHT_TERMS_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Freight Terms Code
Prompt Table:
%EDITTABLE7
|
| 77 |
SEL_FRT_TERMS_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 78 |
IMPORT_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 79 |
SELECT_IMP_APPL_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 80 |
IMPORT_CERT_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Import License Nbr
|
| 81 |
SELECT_IMP_CERTNBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 82 |
IMPORT_LIC_APPL |
Character(3) |
VARCHAR2(3) NOT NULL |
Applied For
NO=No
YES=Yes
|
| 83 |
IMPORT_LIC_EXP |
Date(10) |
DATE |
Expiration Date
|
| 84 |
SELECT_IMP_LIC_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 85 |
IMPORT_LIC_REC |
Character(3) |
VARCHAR2(3) NOT NULL |
License Received
NO=No
YES=Yes
|
| 86 |
IMPORT_LIC_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Import License Required
NO=No
YES=Yes
|
| 87 |
IMPORT_REC_DT |
Date(10) |
DATE |
Date Received
|
| 88 |
SELECT_IMP_REC_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 89 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
Prompt Table:
IN_RULE_B_VW
|
| 90 |
SEL_IN_LN_BO_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 91 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
Prompt Table:
IN_RULE_R_VW
|
| 92 |
SEL_IN_LN_RESV_RUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 93 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
Prompt Table:
IN_RULE_R_VW
|
| 94 |
SEL_IN_LN_RESV_BO |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 95 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
Prompt Table:
IN_RULE_O_VW
|
| 96 |
SEL_IN_ORD_RES_RUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 97 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 98 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
Prompt Table:
%EDITTABLE12
|
| 99 |
SELECT_LOAD_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 100 |
NAFTA_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
North American Free Trade Agmt
N=No
Y=Yes
|
| 101 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
REASON_SHIP_VW
|
| 102 |
SELECT_REASON_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 103 |
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:
%EDITTABLE13
|
| 104 |
SELECT_ROUTE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 105 |
SCHED_ARRV_DATE |
Date(10) |
DATE |
Scheduled Arrival Date
|
| 106 |
SCHED_ARRV_TIME |
Time(15) |
TIMESTAMP |
Scheduled Arrival Time
|
| 107 |
SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date
|
| 108 |
SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time
|
| 109 |
SELECT_SCH_ARRV_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 110 |
SELECT_SCH_SHIP_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 111 |
SED_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Shippers Export Declaration
N=No
Y=Yes
|
| 112 |
SHIP_PARTIAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
|
| 113 |
SHIP_PARTIAL_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Order
N=Partial Order No
Y=Partial Order Yes
|
| 114 |
SHIP_PRIORITY_EXP |
Character(6) |
VARCHAR2(6) NOT NULL |
Export Shipping Priority
Prompt Table:
%EDITTABLE6
|
| 115 |
SEL_SHIP_PRI_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 116 |
SHIP_PRIORITY_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Shipping Priority Code
Prompt Table:
%EDITTABLE6
|
| 117 |
SEL_SHIP_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 118 |
SHIP_PRIOR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
|
| 119 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
%EDITTABLE4
|
| 120 |
SEL_SHIP_TYPE_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 121 |
SHIP_TYPE_ID_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Shipping Method
Prompt Table:
%EDITTABLE4
|
| 122 |
SEL_SHIP_TYPE_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 123 |
SELECT_CUST_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
Y/N Table Edit
Default Value: N
|
| 124 |
CUSTOMER_PO_UPD |
Character(25) |
VARCHAR2(25) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
|
| 125 |
SEL_PROJECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Project
Y/N Table Edit
Default Value: N
|
| 126 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 127 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 128 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 129 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 130 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 131 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 132 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 133 |
DATETIME_ADDED |
DateTime(26) |
TIMESTAMP |
DateTime Added
|
| 134 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 135 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 136 |
SELECT_ADDRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 137 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 138 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 139 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 140 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 141 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 142 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 143 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 144 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 145 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 146 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 147 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 148 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 149 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 150 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 151 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 152 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 153 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 154 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 155 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 156 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 157 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax Number
|
| 158 |
RUN_OM_BACKGRND |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Order Completion
Y/N Table Edit
|
| 159 |
RUN_OM_PRICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Repricing
Y/N Table Edit
|
| 160 |
RUN_OMCREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Credit Checking
Y/N Table Edit
|
| 161 |
RUN_OMDEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Populate Demand
Y/N Table Edit
|
| 162 |
RUN_OMHOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Hold Checking
Y/N Table Edit
|
| 163 |
RUN_RESERVATIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Reservations Job
Y/N Table Edit
|
| 164 |
RUN_DELIVERIES |
Character(1) |
VARCHAR2(1) NOT NULL |
Manage Deliveries
Y/N Table Edit
|
| 165 |
RUN_FREIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Freight
Y/N Table Edit
|