SHIPTO FILE
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 AR501 AR550 BL121 BL125 BL202
BL290 BL320 BL80.1 BL90.1 BLI2.1 IC02.1
TX40.1 WH130 WH140 WH21.2 WH210 WH224
WH225 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4
UPDATED BY
BL02.1 BL802 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SHP-COMPANY Numeric 4 BL02.1 BL802
Company The company number represents an
established company and is entered on
all function codes.
SHP-CUSTOMER Alpha 9 (Right Justified) BL02.1 BL802
Customer Number Customer number representing a unique
customer.
SHP-SHIP-TO Numeric 4 BL02.1 BL802
Ship-to Code User-defined code identifying a
customer's ship-to number.
SHP-NAME Alpha 30 (Lower Case) BL02.1 BL290
Name This field displays the ship to's BL320 BL80.1
address name. BL802 WH21.2
WH210
SHP-ADDR1 Alpha 30 (Lower Case) BL02.1 BL80.1
Address 1 First line of address information for a BL802
customer's ship-to location.
SHP-ADDR2 Alpha 30 (Lower Case) BL02.1 BL80.1
Address 2 Second line of address information for BL802
a customer's ship-to location.
SHP-ADDR3 Alpha 30 (Lower Case) BL02.1 BL80.1
Address 3 Third line of address information for a BL802
customer's ship-to location.
SHP-ADDR4 Alpha 30 (Lower Case) BL02.1 BL80.1
Address 4 Fourth line of address information for BL802
a customer's ship-to location.
SHP-CITY Alpha 18 (Lower Case) BL02.1 BL80.1
City City name of a customer's ship-to BL802
location.
SHP-STATE Alpha 2 BL02.1 BL80.1
State or Province State abbreviation of a customer's BL802
ship-to location.
SHP-ZIP Alpha 10 BL02.1 BL80.1
Postal Code Zip code of a customer's ship-to BL802
location.
SHP-COUNTRY Alpha 30 (Lower Case) BL02.1 BL80.1
Country or Other Country name for a customer's ship-to BL802
location.
SHP-COUNTY Alpha 25 (Lower Case) BL02.1 TX140
County The county for the company address.
SHP-TAX-EXEMPT-CD Alpha 1 BL02.1 BL802
Tax Exempt Code 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 Alpha 10 BL02.1 BL802
Tax Code A user-defined code representing the TX140
tax authorities this ship-to pays sales
tax to. Tax codes are set up in the Tax
system.
SHP-FREIGHT-CODE Alpha 2 BL02.1 BL802
Freight Code 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 Alpha 9 (Right Justified) BL02.1 BL202
Carrier Vendor This field contains the carrier vendor BL802
Number number. Must be a valid vendor in the
Accounts Payable system.
SHP-BRK-CHRG-FL Alpha 1 BL02.1 BL802
Brk Chrg Fl This flag indicates whether this
customer ship-to is subject to broken
case charges.
Y = Yes
N = No
SHP-BACK-ORD-FL Alpha 1 BL02.1 BL802
Backorders Allowed Flag indicating whether backorders are
Flag allowed when placing orders for this
ship-to location.
Y = Yes
N = No
SHP-SHIP-COMP-FL Alpha 1 BL02.1 BL802
Ship Comp Fl 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 Numeric 2
Picking Priority
SHP-POD-REQ-FL Alpha 1 BL02.1 BL802
Pod Req Fl 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 Numeric 3 BL02.1 BL802
Pod Grace Per Number of days from the shipment date
after which POD shipments are billed
automatically even if the POD is not
returned.
SHP-DEF-LOCATION Alpha 5 BL02.1 BL802
Default Location Default location from which the items
for Operator on orders placed for this customer
ship-to should be allocated, picked, and
shipped.
SHP-DEF-METHOD Alpha 10 BL02.1 BL802
Default Method for Default method indicating how orders
Ship-to placed for this customer ship-to should
be shipped. Method prints on the
invoice, BL122 (Invoice and Register
Print).
SHP-USED-FL Alpha 1 BL02.1 BL802
Used Flag indicating whether this ship-to
location has ever been used.
N = No
Y = Yes
SHP-ACTIVE-FLAG Alpha 1 BL02.1 BL802
Status This flag indicates the active or
inactive status of this ship-to code.
A = Active
I = Inactive
SHP-TERRITORY Alpha 4 BL02.1 BL802
Sales Territory Sales territory in which this customer
ship-to location is located.
SHP-SALESMAN Numeric 4 BL02.1 BL802
Salesman Number Sales representative for this customer
ship-to location.
SHP-SALESMAN-2 Numeric 4 BL02.1 BL802
Salesman Number 2 Secondary sales representative for this
customer ship-to location.
SHP-COMM-SPLIT Percent 5.3 (Percent) BL02.1 BL802
Commission Split Percentage of the total order value
Percentage used as the basis for the second sales
representative's commission.
SHP-TERMS-CD Alpha 5 BL02.1 BL802
Terms Code 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 Alpha 14 BL02.1 BL802
List Name Name of the price list that will be
used to price items ordered for this
customer ship-to.
SHP-LAST-CMNT-SEQ Numeric 3
Last Cmnt Seq This is the sequence number identifying
the last comment line tied to the
customer ship-to.
SHP-SHIP-TO-EDI Alpha 16 BL02.1 BL802
Ship To Edi Used to cross reference the Lawson
ship-to number used on EDI transactions
if different.
SHP-COUNTRY-CODE Alpha 2 BL02.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
SHP-REGION Alpha 2 BL02.1
Region Code The region code, if applicable for the
country. Used by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
SHP-E-MAIL-ADDRESS Alpha 60 (Lower Case)
E Mail Address
SHP-VENDOR Alpha 9 (Right Justified) BL02.1
Vendor ID The vendor's identification code.
SHP-PURCH-FR-LOC Alpha 4 BL02.1
Purchase From The vendor's purchase from location.
Location Code
SHP-EC-CTRY-NBR Numeric 3 BL02.1
Ec Ctry Nbr The European Community Country number;
leave blank if not a member of the
European Community.
SHP-ISO-CTRY-NBR Numeric 3 BL02.1
Iso Ctry Nbr The ISO country number.
SHP-FOB-CODE Alpha 3 BL02.1
Shipping Term Code The user defined Free On Board Code.
SHP-PORT-CD Alpha 5 BL02.1
Port Cd The Intrastat port code. Must be
define
in IN04.1 (Port Maintenance)
SHIPTO FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SHPSET1 COMPANY AR08.1 AR501
CUSTOMER AR550 BL02.1
SHIP-TO BL121 BL125
BL202 BL290
BL320 BL80.1
BL802 BL90.1
BLI2.1 IC02.1
TX140 TX40.1
WH130 WH140
WH21.2 WH210
WH224 WH225
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
...
SHPSET2 COMPANY Subset BL02.1 IC02.1
CUSTOMER Where SHIP-TO-EDI != Spaces
SHIP-TO-EDI
SHIPTO FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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-COMPANY -> 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
|
