|
|
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 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 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 Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
SHP-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeCustomer number representing a unique
customer.
SHP-SHIP-TO Numeric 4
Element: Ship-to Code User-defined code identifying a
customer's ship-to number.
SHP-NAME Alpha 30 (Lower Case) WH21.2 WH210
Element: Name This field displays the ship to's
address name.
SHP-ADDR1 Alpha 30 (Lower Case)
Element: Address 1 First line of address information for a
customer's ship-to location.
SHP-ADDR2 Alpha 30 (Lower Case)
Element: Address 1 Second line of address information for
a customer's ship-to location.
SHP-ADDR3 Alpha 30 (Lower Case)
Element: Address 1 Third line of address information for a
customer's ship-to location.
SHP-ADDR4 Alpha 30 (Lower Case)
Element: Address 1 Fourth line of address information for
a customer's ship-to location.
SHP-CITY Alpha 18 (Lower Case)
Element: City City name of a customer's ship-to
location.
SHP-STATE Alpha 2
Element: State or ProviState abbreviation of a customer's
ship-to location.
SHP-ZIP Alpha 10
Element: Postal Code Zip code of a customer's ship-to
location.
SHP-COUNTRY Alpha 30 (Lower Case)
Element: Country or OthCountry name for a customer's ship-to
location.
SHP-COUNTY Alpha 25 (Lower Case) TX140
Element: County The county for the company address.
SHP-TAX-EXEMPT-CD Alpha 1
Element: Tax Exempt CodCode 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 TX140
Element: Tax Code 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 Alpha 2
Element: Add On Cost CoFreight 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)
Element: Vendor ID This field contains the carrier vendor
number. Must be a valid vendor in the
Accounts Payable system.
SHP-BRK-CHRG-FL Alpha 1
Element: All Flag This flag indicates whether this
customer ship-to is subject to broken
case charges.
Y = Yes
N = No
SHP-BACK-ORD-FL Alpha 1
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
Element: 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
Element: Picking Priority
SHP-POD-REQ-FL Alpha 1
Element: 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
Element: Age Periods
SHP-DEF-LOCATION Alpha 5
Element: Location Code Default location from which the items
on orders placed for this customer
ship-to should be allocated, picked, and
shipped.
SHP-DEF-METHOD Alpha 10
Element: Opt Method 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 Alpha 1 WH20.7
Element: Used Flag indicating whether this ship-to
location has ever been used.
N = No
Y = Yes
SHP-ACTIVE-FLAG Alpha 1
Element: Status This flag indicates the active or
inactive status of this ship-to code.
A = Active
I = Inactive
SHP-TERRITORY Alpha 4
Element: Sales TerritorSales territory in which this customer
ship-to location is located.
SHP-SALESMAN Numeric 4
Element: Salesman NumbeSales representative for this customer
ship-to location.
SHP-SALESMAN-2 Numeric 4
Element: Salesman NumbeSecondary sales representative for this
customer ship-to location.
SHP-COMM-SPLIT Percent 5.3 (Percent)
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
Element: 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
Element: 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
Element: Sequence NumbeThis is the sequence number identifying
the last comment line tied to the
customer ship-to.
SHP-SHIP-TO-EDI Alpha 16
Element: Ship To Edi Used to cross reference the Lawson
ship-to number used on EDI transactions
if different.
SHP-COUNTRY-CODE Alpha 2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
SHP-REGION Alpha 2
Element: 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)
Element: Email Address
SHP-VENDOR Alpha 9 (Right Justified)
Element: Vendor ID The vendor's identification code.
SHP-PURCH-FR-LOC Alpha 4
Purchase From The vendor's purchase from location.
Location Code
SHP-EC-CTRY-NBR Numeric 3
Element: Ec Ctry Nbr The European Community Country number;
leave blank if not a member of the
European Community.
SHP-ISO-CTRY-NBR Numeric 3
Element: Iso Ctry Nbr The ISO country number.
SHP-FOB-CODE Alpha 3
Element: Shipping Term The user defined Free On Board Code.
SHP-PORT-CD Alpha 5
Element: 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 AR10.1
CUSTOMER AR501 AR550
SHIP-TO 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 Subset 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 -> -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-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
|
