SHIPTO – Customer Ship To Address

System: Billing (BL)
Prefix: SHP
Primary key: COMPANY, CUSTOMER, SHIP-TO
Fields: 52
Updated by: 2 programs
Referenced by: 37 programs

SHIPTO is the Customer Ship To Address table in Lawson Billing (prefix SHP). It is indexed by COMPANY, CUSTOMER, SHIP-TO (SHPSET1); alternate indexes: SHPSET2. It is related 1:1 to APCOMPANY, ARCOMP, ARCUSTGRP, ARCUSTOMER, APVENMAST, CUSTDESC, OEFRTCODE, ICLOCATION and 7 more. It is updated by TX140 and WH20.7 and referenced by AR08.1, AR10.1, AR501, AR550, BLI2.1, IC02.1, TX40.1, WH130 and 29 more. The table has 52 fields, 2 indexes and 18 documented relations.

About SHIPTO

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.

Fields (52)

Column = COBOL field name without the SHP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`SHP-COMPANY` PK 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` PK CUSTOMER	Alpha 9 (Right Justified)	Customer number representing a unique customer.	—
`SHP-SHIP-TO` PK SHIP_TO	Numeric 4	User-defined code identifying a customer's ship-to number.	—
`SHP-NAME` NAME	Alpha 30 (Lower Case)	This field displays the ship to's address name.	WH21.2, WH210
`SHP-CONTACT` CONTACT	Alpha 30 (Lower Case)	Displays the company description.	—
`SHP-ADDR1` ADDR1	Alpha 30 (Lower Case)	First line of address information for a customer's ship-to location.	—
`SHP-ADDR2` ADDR2	Alpha 30 (Lower Case)	Second line of address information for a customer's ship-to location.	—
`SHP-ADDR3` ADDR3	Alpha 30 (Lower Case)	Third line of address information for a customer's ship-to location.	—
`SHP-ADDR4` ADDR4	Alpha 30 (Lower Case)	Fourth line of address information for a customer's ship-to location.	—
`SHP-CITY` CITY	Alpha 18 (Lower Case)	City name of a customer's ship-to location.	—
`SHP-STATE` STATE	Alpha 2	State abbreviation of a customer's ship-to location.	—
`SHP-ZIP` ZIP	Alpha 10	Zip code of a customer's ship-to location.	—
`SHP-COUNTRY` COUNTRY	Alpha 30 (Lower Case)	Country name for a customer's ship-to location.	—
`SHP-COUNTY` COUNTY	Alpha 25 (Lower Case)	The county for the company address.	TX140
`SHP-TAX-EXEMPT-CD` 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` 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` 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` CARRIER	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` BRK_CHRG_FL	Alpha 1	This flag indicates whether this customer ship-to is subject to broken case charges. `Y` Yes `N` No	—
`SHP-BACK-ORD-FL` 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` 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` PK_PRIORITY	Numeric 2	—	—
`SHP-POD-REQ-FL` 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` POD_GRACE_PER	Numeric 3	—	—
`SHP-DEF-LOCATION` DEF_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` 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` USED_FL	Alpha 1	Flag indicating whether this ship-to location has ever been used. `N` No `Y` Yes	WH20.7
`SHP-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	This flag indicates the active or inactive status of this ship-to code. `A` Active `I` Inactive	—
`SHP-TERRITORY` TERRITORY	Alpha 4	Sales territory in which this customer ship-to location is located.	—
`SHP-SALESMAN` SALESMAN	Numeric 4	Sales representative for this customer ship-to location.	—
`SHP-SALESMAN-2` SALESMAN_2	Numeric 4	Secondary sales representative for this customer ship-to location.	—
`SHP-COMM-SPLIT` 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` TERMS_CD	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` 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` LAST_CMNT_SEQ	Numeric 3	This is the sequence number identifying the last comment line tied to the customer ship-to.	—
`SHP-SHIP-TO-EDI` SHIP_TO_EDI	Alpha 16	Used to cross reference the Lawson ship-to number used on EDI transactions if different.	—
`SHP-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	—
`SHP-REGION` 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` E_MAIL_ADDRESS	Alpha 60 (Lower Case)	e-mail address.	—
`SHP-VENDOR` VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	—
`SHP-PURCH-FR-LOC` PURCH_FR_LOC	Alpha 4	The vendor's purchase from location.	—
`SHP-EC-CTRY-NBR` EC_CTRY_NBR	Numeric 3	The European Community Country number; leave blank if not a member of the European Community.	—
`SHP-ISO-CTRY-NBR` ISO_CTRY_NBR	Numeric 3	The ISO country number.	—
`SHP-FOB-CODE` FOB_CODE	Alpha 3	The user defined Free On Board Code.	—
`SHP-PORT-CD` PORT_CD	Alpha 5	The Intrastat port code. Must be define in IN04.1 (Port Maintenance)	—
`SHP-MEMO-TERM` MEMO_TERM	Alpha 5	The terms code used for a credit memo when a ship to is present.	—
`SHP-INT-PREFIX` INT_PREFIX	Alpha 6	—	—
`SHP-PHONE-NMBR` PHONE_NMBR	Alpha 15	—	—
`SHP-PHONE-EXT` PHONE_EXT	Alpha 5	—	—
`SHP-FAX-NUMBER` FAX_NUMBER	Alpha 15	—	—
`SHP-FAX-EXT` FAX_EXT	Alpha 5	—	—
`SHP-ADD-DATE` ADD_DATE	Numeric 8 (yyyymmdd)	—	—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`SHPSET1`	`COMPANY`, `CUSTOMER`, `SHIP-TO`	Primary		AR08.1, AR10.1, AR501, AR550, BLI2.1, IC02.1, TX140, TX40.1 +22 more (list truncated in source)
`SHPSET2`	`COMPANY`, `CUSTOMER`, `SHIP-TO-EDI`	Subset	Where SHIP-TO-EDI != Spaces	IC02.1, WH20.2, WH20.7

Relations

One to one (18) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (2)

TX140 Vertex Geocode Update
WH20.7 Substitute Location

Referenced by (37)

AR08.1 Customer Defaults
AR10.1 Customer
AR501 Customer Conversion
AR550 Customer Interface
BLI2.1 BL and OE Attachment Copy
IC02.1 Location
TX40.1 Tax Inquiry for Vertex
WH130 Pick List Print
WH132 Batch Feedback
WH140 Bill Of Lading Print
WH190 Shipment Release
WH21.2 Stops
WH210 Route File Listing
WH224 Packing List Print
WH225 MSDS Listing
WH30.1 Picking Feedback by Document
WH30.2 Picking Feedback by Shipment
WH30.3 Picking by Batch
WH30.4 Bin Sequence Picking Feedback
WH31.1 Packing Feedback by Document
WH31.2 Packing Feedback by Shipment
WH31.3 Packing by Batch
WH31.4 Bin Sequence Packing Feedback
WH32.1 Shipping Feedback by Document
WH32.2 Shipping Feedback by Shipment
WH32.3 Shipping by Batch
WH32.4 Bin Sequence Shipping Feedback
WH32.5 Shipping Line Feedback
WH33.5 Additional Shipment Information
WH34.1 Component Bins
WH34.2 Component Lots
WH34.3 Component Serials
WH34.4 Component UOMs
WH40.1 Bill of Lading
WH40.2 Bill of Lading Feedback
WH520 Batch Feedback Interface
WH830 Shipment Load Program