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
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SHPSET1 |
COMPANY CUSTOMER SHIP-TO |
|
|||||||||||||||||
SHPSET2 |
COMPANY CUSTOMER SHIP-TO-EDI |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ap Company | APCOMPANY |
Required
| ||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||
Arcustgrp | ARCUSTGRP |
Required
| ||||||||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||||||||
Carrier | APVENMAST |
Required
| ||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||
Freight Code | OEFRTCODE |
Required
| ||||||||||||
Location | ICLOCATION |
Required
| ||||||||||||
Method | OEMETHOD |
Required
| ||||||||||||
Oecompany | OECOMPANY |
Required
| ||||||||||||
Oefrtcode | OEFRTCODE |
Required
| ||||||||||||
Salesrep1 | SALESREP |
Required
| ||||||||||||
Salesrep2 | SALESREP |
Required
| ||||||||||||
Shpbod | SHPBOD |
Not Required, Delete Cascades
| ||||||||||||
Tax Code | TXTAXCODE |
Required
| ||||||||||||
Terms | TERMS |
Required
| ||||||||||||
Territory | TERITORY |
Required
| ||||||||||||
Txtaxcode | TXTAXCODE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.