SHIPTO

Customer Ship To Address

The Customer Ship To Address file stores customer ship to information, including the ship-to address and specific order processing rules for the ship-to location. Any customer can have multiple ship-to records set up and one ship to can be defined as a default.

REFERENCED BY
AR08.1 AR10.1 AR501 AR550 BLI2.1 IC02.1
TX40.1 WH130 WH132 WH140 WH190 WH21.2
WH210 WH224 WH225 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.5 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830


UPDATED BY
TX140 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SHP-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
SHP-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number representing a unique customer.
SHP-SHIP-TO
Element: Ship To
Numeric 4
User-defined code identifying a customer's ship-to number.
SHP-NAME
Element: Name
Alpha 30 (Lower Case)
This field displays the ship to's address name.
WH21.2 WH210
SHP-CONTACT
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
SHP-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
First line of address information for a customer's ship-to location.
SHP-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
Second line of address information for a customer's ship-to location.
SHP-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
Third line of address information for a customer's ship-to location.
SHP-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
Fourth line of address information for a customer's ship-to location.
SHP-CITY
Element: City
Alpha 18 (Lower Case)
City name of a customer's ship-to location.
SHP-STATE
Element: State
Alpha 2
State abbreviation of a customer's ship-to location.
SHP-ZIP
Element: Zip
Alpha 10
Zip code of a customer's ship-to location.
SHP-COUNTRY
Element: Country
Alpha 30 (Lower Case)
Country name for a customer's ship-to location.
SHP-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
TX140
SHP-TAX-EXEMPT-CD
Element: Tax Exempt Cd
Alpha 1
Code indicating the taxing status of a customer's ship-to location. If a customer ship-to is defined as exempt, any order placed for this ship-to location will be exempt regardless of the taxing status of the item ordered.
E = Exempt
T = Taxable
SHP-TAX-CODE
Element: Tax Code
Alpha 10
A user-defined code representing the tax authorities this ship-to pays sales tax to. Tax codes are set up in the Tax system.
TX140
SHP-FREIGHT-CODE
Element: Freight Code
Alpha 2
Freight code indicating if a freight charge is to be assessed for orders placed using this ship-to location. Freight codes are set up in the Billing system.
SHP-CARRIER
Element: Vendor
Alpha 9 (Right Justified)
This field contains the carrier vendor number. Must be a valid vendor in the Accounts Payable system.
SHP-BRK-CHRG-FL
Element: All Flag
Alpha 1
This flag indicates whether this customer ship-to is subject to broken case charges.
Y = Yes
N = No
SHP-BACK-ORD-FL
Element: Back Ord Fl
Alpha 1
Flag indicating whether backorders are allowed when placing orders for this ship-to location.
Y = Yes
N = No
SHP-SHIP-COMP-FL
Element: Ship Comp Fl
Alpha 1
Flag indicating if orders for this customer ship-to must only be shipped when the order is completely filled. If Yes is selected, the orders can only be shipped when all lines on the order can be shipped in total together.
Y = Yes
N = No
SHP-PK-PRIORITY
Element: Pk Priority
Numeric 2
SHP-POD-REQ-FL
Element: Pod Req Fl
Alpha 1
POD required flag. Indicates whether this customer's ship-to requires that a Proof of Delivery form accompany the shipment. The shipment will not be billed until the POD form is returned or the POD grace period expires.
Y = Yes
N = No
SHP-POD-GRACE-PER
Element: Age Periods
Numeric 3
SHP-DEF-LOCATION
Element: Location
Alpha 5
Default location from which the items on orders placed for this customer ship-to should be allocated, picked, and shipped.
SHP-DEF-METHOD
Element: Def Method
Alpha 10
Default method indicating how orders placed for this customer ship-to should be shipped. Method prints on the invoice, BL122 (Invoice and Register Print).
SHP-USED-FL
Element: Used Fl
Alpha 1
Flag indicating whether this ship-to location has ever been used.
N = No
Y = Yes
WH20.7
SHP-ACTIVE-FLAG
Element: Active Flag
Alpha 1
This flag indicates the active or inactive status of this ship-to code.
A = Active
I = Inactive
SHP-TERRITORY
Element: Territory
Alpha 4
Sales territory in which this customer ship-to location is located.
SHP-SALESMAN
Element: Salesman
Numeric 4
Sales representative for this customer ship-to location.
SHP-SALESMAN-2
Element: Salesman
Numeric 4
Secondary sales representative for this customer ship-to location.
SHP-COMM-SPLIT
Element: Comm Split
Percent 5.3 (Percent)
Percentage of the total order value used as the basis for the second sales representative's commission.
SHP-TERMS-CD
Element: Term Code
Alpha 5
Payment terms code established for this customer ship-to number. Terms codes are set up in the Terms system and determine the due date of the invoices produced for orders placed for this ship-to.
SHP-LIST-NAME
Element: List Name
Alpha 14
Name of the price list that will be used to price items ordered for this customer ship-to.
SHP-LAST-CMNT-SEQ
Element: Seq
Numeric 3
This is the sequence number identifying the last comment line tied to the customer ship-to.
SHP-SHIP-TO-EDI
Element: Ship To Edi
Alpha 16
Used to cross reference the Lawson ship-to number used on EDI transactions if different.
SHP-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
SHP-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
SHP-E-MAIL-ADDRESS
Element: Email Address
Alpha 60 (Lower Case)
e-mail address.
SHP-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
SHP-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
SHP-EC-CTRY-NBR
Element: Ec Ctry Nbr
Numeric 3
The European Community Country number; leave blank if not a member of the European Community.
SHP-ISO-CTRY-NBR
Element: Iso Ctry Nbr
Numeric 3
The ISO country number.
SHP-FOB-CODE
Element: Fob Code
Alpha 3
The user defined Free On Board Code.
SHP-PORT-CD
Element: Port Cd
Alpha 5
The Intrastat port code. Must be define in IN04.1 (Port Maintenance)
SHP-MEMO-TERM
Element: Memo Term
Alpha 5
The terms code used for a credit memo when a ship to is present.
SHP-INT-PREFIX
Element: Phone Prefix
Alpha 6
SHP-PHONE-NMBR
Element: Phone
Alpha 15
SHP-PHONE-EXT
Element: Phone Ext
Alpha 5
SHP-FAX-NUMBER
Element: Phone
Alpha 15
SHP-FAX-EXT
Element: Phone Ext
Alpha 5
SHP-ADD-DATE
Element: Date Entered
Numeric 8 (yyyymmdd)


SHIPTO FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SHPSET1 COMPANY
CUSTOMER
SHIP-TO
...
AR08.1 AR10.1
AR501 AR550
BLI2.1 IC02.1
TX140 TX40.1
WH130 WH132
WH140 WH190
WH20.2 WH20.7
WH21.2 WH210
WH224 WH225
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
SHPSET2 COMPANY
CUSTOMER
SHIP-TO-EDI
Subset
WhereSHIP-TO-EDI !=Spaces
IC02.1 WH20.2
WH20.7


SHIPTO FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ap Company APCOMPANY Required
When SHP-CARRIER !=Spaces
SHP-COMPANY->CPY-COMPANY
Arcomp ARCOMP Required
SHP-COMPANY->ACO-COMPANY
Arcustgrp ARCUSTGRP Required
ACO-CUST-GROUP->ACG-CUST-GROUP
Arcustomer ARCUSTOMER Required
SHP-COMPANY->ACM-COMPANY
SHP-CUSTOMER->ACM-CUSTOMER
Carrier APVENMAST Required
When SHP-CARRIER !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
SHP-CARRIER->VEN-VENDOR
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
SHP-CUSTOMER->CUD-CUSTOMER
Freight Code OEFRTCODE Required
When SHP-FREIGHT-CODE !=Spaces
SHP-COMPANY->OFR-COMPANY
SHP-FREIGHT-CODE->OFR-FRT-CODE
Location ICLOCATION Required
When SHP-DEF-LOCATION !=Spaces
SHP-COMPANY->ICL-COMPANY
SHP-DEF-LOCATION->ICL-LOCATION
Method OEMETHOD Required
When SHP-DEF-METHOD !=Spaces
SHP-COMPANY->OMT-COMPANY
SHP-DEF-METHOD->OMT-METHOD
Oecompany OECOMPANY Required
SHP-COMPANY->OEC-COMPANY
Oefrtcode OEFRTCODE Required
When SHP-FREIGHT-CODE !=Spaces
SHP-COMPANY->OFR-COMPANY
SHP-FREIGHT-CODE->OFR-FRT-CODE
Salesrep1 SALESREP Required
When SHP-SALESMAN !=Zeroes
SHP-COMPANY->SAW-COMPANY
SHP-SALESMAN->SAW-SALESMAN
Salesrep2 SALESREP Required
When SHP-SALESMAN-2 !=Zeroes
SHP-COMPANY->SAW-COMPANY
SHP-SALESMAN-2->SAW-SALESMAN
Shpbod SHPBOD Not Required, Delete Cascades
SHP-COMPANY->BBB-COMPANY
SHP-CUSTOMER->BBB-CUSTOMER
SHP-SHIP-TO->BBB-SHIP-TO
Tax Code TXTAXCODE Required
When SHP-TAX-CODE !=Spaces
SHP-COMPANY->TAC-COMPANY
SHP-TAX-CODE->TAC-TAX-CODE
Terms TERMS Required
When SHP-TERMS-CD !=Spaces
SHP-TERMS-CD->TMS-TERMS-CD
Territory TERITORY Required
When SHP-TERRITORY !=Spaces
SHP-COMPANY->TRY-COMPANY
SHP-TERRITORY->TRY-TERRITORY
Txtaxcode TXTAXCODE Required
When SHP-TAX-CODE !=Spaces
SHP-COMPANY->TAC-COMPANY
SHP-TAX-CODE->TAC-TAX-CODE


File created: Thu Jun 09 02:09:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.