| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
ADD_NOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Add a New Note
Y/N Table Edit
Default Value: N
|
| 3 |
ADD_PART_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if Default Partner Contact message will be used in Order Capture Self Service
Y/N Table Edit
Default Value: N
|
| 4 |
BU_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Open or Closed Status of the Business Unit.
1=Facility Open
2=Facility Closed
Default Value: 2
|
| 5 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 6 |
BUSINESS_UNIT_RA |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RA_NONVW
|
| 7 |
BUSINESS_UNIT_RF |
Character(5) |
VARCHAR2(5) NOT NULL |
Store the Business Unit for the associated FieldService Business Unit.
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table:
SP_BU_RF_NONVW
|
| 8 |
BUSINESS_UNIT_ESA |
Character(5) |
VARCHAR2(5) NOT NULL |
ESA Business Unit for integrations
Prompt Table:
SP_BU_FS_NONVW
|
| 9 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
This field stores the values for Contracts Business Unit.
Prompt Table:
SP_BU_FS_NONVW
|
| 10 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.
Prompt Table:
SP_BU_FS_NONVW
|
| 11 |
CR_CARD_VENDOR |
Character(16) |
VARCHAR2(16) NOT NULL |
Vendor name for credit card processing
Prompt Table:
EOEC_CCI_INSTAL
|
| 12 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email address to store the address of email.
|
| 13 |
EMAIL_ADDR_F |
Character(70) |
VARCHAR2(70) NOT NULL |
Fulfillment Specialist Email
|
| 14 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
This field stores the Telephone number.
|
| 15 |
CR_RATING |
Number(5,0) |
INTEGER NOT NULL |
Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record
|
| 16 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
DEFAULT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Flag
Y/N Table Edit
Default Value: N
|
| 18 |
FREIGHT_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by OM, INV.
E=External
N=None
Default Value: N
|
| 19 |
CARRIER |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier or preferred carrier. Also used for Shipping Method.
Prompt Table:
CARRIER_VW
|
| 20 |
PRICE_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price List ID
|
| 21 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_VW1
|
| 22 |
RE_NUM_ROWS |
Number(2,0) |
SMALLINT NOT NULL |
Quick Entry Fields
Default Value: 4
|
| 23 |
ORD_ACCEPT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
This field stores the value for Order Acceptance Location
Prompt Table:
LOCATION_VW1
|
| 24 |
ORD_ORIGIN_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
This field stores the Order Origin Location.
Prompt Table:
LOCATION_VW1
|
| 25 |
QUOTE_CONV_WARNING |
Character(1) |
VARCHAR2(1) NOT NULL |
Warning message to display when converting a quote to an order
1=No Warning
2=Display Warnings
Default Value: 1
|
| 26 |
QUOTE_CONVERSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Use to specify if a quote will be submitted when it is converted to an order.
C=Convert to Order Only
S=Convert to Order and Submit
Default Value: S
|
| 27 |
QUOTE_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Number of days in which the quote will be due.
|
| 28 |
QUOTE_EXPIRE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to repersent expiration days for quote.
|
| 29 |
ORDER_EXPIRE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field is used to represent expiration days for non-submitted Order.
|
| 30 |
SHOW_RECOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used by order capture to show the recommendation
Y/N Table Edit
Default Value: N
|
| 31 |
RAD_ADVISOR_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Advisor Dialog Guid - represents internally the Advisor dialog
Prompt Table:
RAD_ADV_ACTI_VW
|
| 32 |
RECTEMPLATE_ID_NUM |
Number(5,0) |
INTEGER NOT NULL |
Field used by order capture for recommendation section to show
Prompt Table:
RO_DISTMP_A_VW
|
| 33 |
REFRESH_CATALOG |
Number(4,0) |
SMALLINT NOT NULL |
Number of minutes between each product catalog refresh.
|
| 34 |
REVIEW_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Number of days to review a customer.
|
| 35 |
RO_PRIORITY |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Capture Priority
Prompt Table:
RO_DEFN_PRIORTY
|
| 36 |
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.
Prompt Table:
RT_TYPE_TBL
|
| 37 |
SHOW_PHONE_COUNTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Phone Country Code
Y/N Table Edit
Default Value: Y
|
| 38 |
SITE_ADDR_INCLUDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates what address will be included when prompting for a Site address.
1=Site Addresses Only
2=Customer Bill To Addresses
3=Customer Ship To Addresses
9=All Customer Addresses
Default Value: 1
|
| 39 |
TAX_COMPANY |
Character(20) |
VARCHAR2(20) NOT NULL |
Tax company used for third party tax reporting
|
| 40 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Tax division for reporting purposes
|
| 41 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Third party tax vendor
A=Taxware
N=None
V=Vertex
W=WorldTax
Default Value: N
|
| 42 |
USE_ACCOUNTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if accounts are to be used in Order Capture
|
| 43 |
CATALOG_TREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used by order capture to show the recommendation
Y/N Table Edit
Default Value: N
|
| 44 |
SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Source Code
Prompt Table:
RO_DEFN_SOURCE
Set Control Field: BUSINESS_UNIT
|
| 45 |
RO_SS_SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Order source code populated in self service orders
Prompt Table:
RO_DEFN_SOURCE
Set Control Field: BUSINESS_UNIT
|
| 46 |
CHANGES_ACCEPTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Action to take regarding notifications when requested Order changes are accepted
B=Notify CSR and Customer
C=Notify Customer Only
N=Notify Nobody
R=Notify CSR Only
Default Value: N
|
| 47 |
CHANGES_PARTIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Action to take regarding notifications when requested Order changes are partially accepted
B=Notify CSR and Customer
C=Notify Customer Only
N=Notify Nobody
R=Notify CSR Only
Default Value: N
|
| 48 |
CHANGES_REJECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Action to take regarding notifications when requested Order changes are completely rejected
B=Notify CSR and Customer
C=Notify Customer Only
N=Notify Nobody
R=Notify CSR Only
Default Value: N
|
| 49 |
ADVISOR_SESSIONFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for indicating if the business unit allows for session debugging information
Y/N Table Edit
Default Value: N
|
| 50 |
RO_INDREL_VW |
Character(25) |
VARCHAR2(25) NOT NULL |
Field Used in Bulk Order Business Unit settings to indicate which view to use for Individual Consumer View
Prompt Table:
BO_REL_CFG1
|
| 51 |
RO_ORGREL_VW |
Character(25) |
VARCHAR2(25) NOT NULL |
Field Used in Bulk Order Business Unit settings to indicate which view to use for an Organization.
Prompt Table:
BO_REL_CFG1
|
| 52 |
MULTORD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used as part of Order Capture Business Unit Setup to determine whether Multiple Orders per line are allowed per recipient.
Y/N Table Edit
Default Value: N
|
| 53 |
SUBMIT_CONF |
Character(1) |
VARCHAR2(1) NOT NULL |
Controls if the submit confirmation page will be displayed after an order is submitted.
Y/N Table Edit
Default Value: N
|
| 54 |
RO_COMM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for the order capture BU to indicate if the communications tab should be displayed.
Y/N Table Edit
Default Value: N
|
| 55 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Field for IBM development. Lead Time used in SM
|
| 56 |
DURATION_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
D=Days
M=Months
Q=Quarters
W=Weeks
Y=Years
Default Value: M
|
| 57 |
STORE_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
This field stores the value for Store Location
|
| 58 |
CAT_DISP_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Display the product catalogs that are available by customer.
Y/N Table Edit
Default Value: Y
|
| 59 |
CAT_DISP_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Display the product catalogs that are available by partner.
Y/N Table Edit
Default Value: Y
|
| 60 |
CAT_DISP_USER |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to display catalogs by user.
Y/N Table Edit
Default Value: Y
|
| 61 |
CAT_PRI_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
catalog display priority for customer
1=1
2=2
3=3
Default Value: 1
|
| 62 |
CAT_PRI_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
catalog display priority for partner
1=1
2=2
3=3
Default Value: 2
|
| 63 |
CAT_PRI_USER |
Character(1) |
VARCHAR2(1) NOT NULL |
catalog display priority for user
1=1
2=2
3=3
Default Value: 3
|
| 64 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Bill Type Identifier.
Prompt Table:
BI_TYPE_EF_VW
Set Control Field: BUSINESS_UNIT
|
| 65 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source ID - used on the Field Service Business Unit table. Value obtained from SCM.
Prompt Table:
BI_SRC_EF_VW
Set Control Field: BUSINESS_UNIT
|
| 66 |
PRORATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Proration flag - indicates if order adjustments are prorated to the lines
0=Do Not Prorate Adjustments
1=Prorate Order Adjustments
Default Value: 0
|
| 67 |
PROD_TERM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Code for Subscriptions Terms - determine the length of the subscription
Prompt Table:
RO_SUB_TERM_VW
Set Control Field: BUSINESS_UNIT
|
| 68 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RF_SCHED_TBL_VW
|
| 69 |
BPLAUNCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Field indicates whether Order Capture business projects should be run immediately upon Submit, Queued Always, or Queued only for Future Dated Orders.
0=Do not Queue
1=Queue All
2=Only Queue Future Dated Orders
Default Value: 2
|
| 70 |
RO_FULLFILMENT_LOG |
Character(1) |
VARCHAR2(1) NOT NULL |
RO_FULLFILMENT_LOG,Fulfillment logging flag used in ibm order bridge,
|
| 71 |
RO_LINEDATES_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to determine whether or not Line start dates are editable for Future Dated Orders
Y/N Table Edit
Default Value: N
|
| 72 |
RO_ORDER_QUEUEING |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to determine if Future Dated Orders is enabled
Y/N Table Edit
Default Value: Y
|
| 73 |
RO_TEMP_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to enable temporary service availability on the business unit
Y/N Table Edit
Default Value: N
|
| 74 |
RO_USE_LEAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to determine if Lead Time should be used to calculate the Start Date for services
Y/N Table Edit
Default Value: Y
|
| 75 |
PRICE_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Line Adjustment
Y/N Table Edit
Default Value: N
|
| 76 |
HDR_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Header Adjustment used in Order Capture. While Clonning this flag is used.
Y/N Table Edit
Default Value: Y
|
| 77 |
PRICE_AT_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicates if the order should only be priced upon saving, rather than after each line is added
N=Price as Lines Added
U=Price at Update Totals
Y=Price at Save
Default Value: Y
|
| 78 |
LIST_PRICE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag indicates if the order should only be priced upon saving, rather than after each line is added
E=Pricing Engine
M=Product Model
N=Show No Price
|
| 79 |
RO_LINE_AAF |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used in the Business Unit Field Defaults to whether allow the AAF Actions during addition of the Line in the Order.
Y/N Table Edit
Default Value: N
|
| 80 |
RO_AGREEMENT_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
Setting indicates when to display the Covered Products grid for agreement products on an order.
A=Always Populate Grid
R=Populate Upon Request
Default Value: A
|
| 81 |
DISPLAY_ROOT_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used by order capture to hide or unhide the nested catalog at root.
Y/N Table Edit
Default Value: Y
|
| 82 |
RO_AVAILABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business unit setting for the product availability display options
P=Display Highest Priority IBU
Q=Display Highest Quantity
Default Value: Q
|
| 83 |
VERITY_MAX_ROWS |
Number(6,0) |
INTEGER NOT NULL |
Field use for order capture verity enhancements
Default Value: 250
|
| 84 |
SUB_SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Field used for storing sub source information
Prompt Table:
RO_DEFN_SUB_SRC
|
| 85 |
RO_SSSUB_SOURCE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Field used for storing Default Self Service Sub Source
Prompt Table:
RO_DEFN_SUB_SRC
|
| 86 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 87 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 88 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 89 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 90 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 91 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|