Wiki

Case Status
Log In

Wiki

 
Cooper Order Mapping
  • RSS Feed

Last modified on 7/14/2014 2:07 PM by User.

Tags:

Cooper Order Mapping

General Tab

Field
Mapping Notes
Quoter
-
CSR
-
Manufacturerorder.setManufacturer() from querying flash
Customer(Account number only)
PO Number
order.setPONumber()
Projectorder.setProjectName(
Order Type
-
Stampif not blank
order.getHeaderComments()[].setActive("Y")
order.getHeaderComments()[].setCommentTypeCode("AL")
order.getHeaderComments()[].setCreateByName(OASIS user name)
order.getHeaderComments()[].setComment("STAMP: "+po.getStamp())
Lot Net Billing
order.setLotInvoiced()
Ship Together
order.setShipCompleteOnly()
End User PO
See augmentation data below
Freight Type
Some items mapped to augmentation data below - USER TRAINING!
Allowance-
Freight Account
if not blank
order.getHeaderComments()[].setActive("Y")
order.getHeaderComments()[].setCommentTypeCode("AL")
order.getHeaderComments()[].setCreateByName(OASIS user name)
order.getHeaderComments()[].setComment("Freight Account: "+po.getFreightAccount())
order.getHeaderComments()[].setPrintOnShippingSet(true)
order.getHeaderComments()[].setPrintOnWarehouse(true)
order.setShippingConditions("C")
Don't Ship Before
order.setDoNotShipBeforeShipDate()
Required On Site
order.setRequestedDeliveryDate()
File Code
-
MFG Quote
-
Our Quote
-
Accountorder.setDistributor() distributor object from querying flash with account number
PO Status
-
Entry Date
order.setPODate()
RMA Handler
-
Sales Accounts
-
Custom TAGS
-
Specifiers-

Items Tab


 

Field
Mapping Notes
QuantitylineWS.setQuantity()
ReleaselineWS.setReleaseQuantity()
TypelineWS.setLineItemType()
MFGlineWS.setBrand()
PartlineWS.setCatalogNumberValue()
Net Price
-
CommlineWS.setBaseCommissionPercentage()
Overage-
%Over-
MFG Quote
-
SelllineWS.setCustomerPrice()
LinelineWS.setCustomerLineNumber() (Actually LineUID)
Rel Now
-
HoldHOLD ORDERS NOT ALLOWED
WLamp-
Finish-
Voltage-
UQ(UQ LOGIC NOT IMPLEMENTED)
PQ-
Ext.SelllineWS.setUnitPriceValue1()
Open Sell
-
Tx-
MM-
SI-
Updated-
DescriptionlineWS.setDescription()
Line Note
if not blank
lineWS.getOrderComments()[].setText(line.getLineNote())
lineWS.getOrderComments()[].setCommentTypeCode("AL")
Line Internal Note
NEVER EVER!

Addresses



Field
Mapping Notes
Sold Name
(Implied from account number)
SoldLine1-
SoldLine2-
SoldCity-
SoldState-
SoldZip-
SoldCounty-
SoldCountry-
Bill Name
(Implied from account number)
BillLine1-
BillLine2-
BillCity-
BillState-
BillZip-
BillCounty-
BillCountry-
Ship Name
order.setShipToName1()
Ship C/O
order.setShipToName2()
ShipLine1order.getShipToAddress().setStreetAddress1()
ShipLine2order.getShipToAddress().setStreetAddress2()
ShipCityorder.getShipToAddress().setCity()
ShipStateorder.getShipToAddress().setState()
ShipZiporder.getShipToAddress().setZipCode()
ShipCounty-
ShipCountryorder.getShipToAddress().setCountryCode()
Markingsif not blank
order.getHeaderComments()[].setActive("Y")
order.getHeaderComments()[].setCommentTypeCode("AL")
order.getHeaderComments()[].setCreateByName(OASIS user name)
order.getHeaderComments()[].setComment("Markings: "+po.getShipMark())
order.getHeaderComments()[].setPrintOnWarehouse(true)
Call Ahead
order.setDeliveryContact() less phone number, limited to 30 chars
order.setDeliveryContactPhone() just the phone number portion

Notes



Field
Mapping Notes
Remarksif not blank
order.getHeaderComments()[].setActive("Y")
order.getHeaderComments()[].setCommentTypeCode("AL")
order.getHeaderComments()[].setCreateByName(OASIS user name)
order.getHeaderComments()[].setComment(po.getRemarks())
Notesif not blank
order.getHeaderComments()[].setActive("Y")
order.getHeaderComments()[].setCommentTypeCode("AL")
order.getHeaderComments()[].setCreateByName(OASIS user name)
order.getHeaderComments()[].setComment(po.getPONotes())
Internal Notes
NEVER EVER!

Augmentation Data

 

Field
Mapping Notes
Obtain AgentLiteBean from user login
order.setAgent()
po.getTotalPrice()
order.getPriceTotal().setPriceTotal()
po.getTotalCommission()order.getPriceTotal().setRegularCommissionDollarTotal()
po.getTotalOverage()order.getPriceTotal().setPremiumCommissionDollarTotal()
Agency Splits are not currently mapped to flash
order.getCommissionableAgents()[0].setAgent(from login)
order.getCommissionableAgents()[0].setCommissionCode("R")
order.getCommissionableAgents()[0].setCommissionSplit(1)
order.getCommissionableAgents()[0].setUID(from login)
User's territory country
order.setCountryCode()
order.setProjectCountry() -- @todo pull from ship addr?

Field
Mapping Notes
CUD Code
REQUIRED: order.setOrderCUDCode()
ApplicationREQUIRED: order.setApplication()
Promotion
List of objects pulled from flash. order.setPromotion()
Shipping Methods
(not currently mapped)
Shipping Conditions
List of objects pulled from flash. order.setShippingCondition()
CarrierList of objects pulled from flash. order.setCarrierID()
National Account
List of objects pulled from flash. order.setNationalAccountBean()



Only used of the Name filed is filled in.

Field
Mapping Notes
Name
order.setAlternateName1()
C/Oorder.setAlternateName2()
Line1order.getAlternateAddress().setStreetAddress1()
Line2order.getAlternateAddress().setStreetAddress2()
Cityorder.getAlternateAddress().setCity()
Stateorder.getAlternateAddress().setStateCode()
Ziporder.getAlternateAddress().setZipCode()
County-
Countryorder.getAlternateAddress().setCountryCode()



NOTE: Only used if a contractor is selected.

Field
Mapping Notes
Contractor First
List pulled from flash. order.setCFPONumber()
Contractor PO#
Intially pulled from End User PO field on order. order.setCFPONumber()
ProjectInitially pulled from order project name. User editable. order.setProjectName()
Location City
Initially pulled from related oasis quote project city. User Editable. order.setProjectCity()
Location State
Initially pulled from related oasis quote project city. User Editable. order.setProjectState()