|
|
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 BL120 BL121
BL122 BL130 BL20.1 BL20.3 BL202 BL21.2
BL21.5 BL29.1 BL29.2 BL290 BL320 BL520
BL80.1 BL820 BL90.1 BL940 OE112 OE13.1
OE230 OE260 OE280 OE281 OE291 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE330 OE60.1 OE80.1 OE80.2 OE80.3
OE80.4 OE80.5 OE81.1 OE830 OE85.1 OE950
SA03.1 SA100 SA300 SA80.2 SA90.2 TX40.1
WH130 WH140 WH190 WH21.2 WH210 WH224
WH225 WH32.1 WH32.3
UPDATED BY
BL02.1 BL02.2 BL802 BL902 BL92.1 BL967
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE510
OE810 OE920 TX140 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SHP-COMPANY Numeric 4 BL02.1 BL802
Company The company number represents an BL902 BL967
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 BL902 BL967
customer.
SHP-SHIP-TO Numeric 4 BL02.1 BL802
Ship-to Code User-defined code identifying a BL902 BL967
customer's ship-to number.
SHP-NAME Alpha 30 (Lower Case) BL02.1 BL122
Name This field displays the ship-to's BL290 BL320
address name. BL80.1 BL802
BL902 BL967
OE230 OE260
OE280 OE281
OE30.1 OE60.1
SA03.1 SA100
WH21.2 WH210
SHP-ADDR1 Alpha 30 (Lower Case) BL02.1 BL122
Address 1 First line of address information for a BL80.1 BL802
customer's ship-to location. BL902 BL967
SHP-ADDR2 Alpha 30 (Lower Case) BL02.1 BL122
Address 2 Second line of address information for BL80.1 BL802
a customer's ship-to location. BL902 BL967
SHP-ADDR3 Alpha 30 (Lower Case) BL02.1 BL122
Address 3 Third line of address information for a BL80.1 BL802
customer's ship-to location. BL902 BL967
SHP-ADDR4 Alpha 30 (Lower Case) BL02.1 BL122
Address 4 Fourth line of address information for BL80.1 BL802
a customer's ship-to location. BL902 BL967
SHP-CITY Alpha 18 (Lower Case) BL02.1 BL122
City City name of a customer's ship-to BL80.1 BL802
location. BL902 BL967
SHP-STATE Alpha 2 BL02.1 BL122
State or Province State abbreviation of a customer's BL80.1 BL802
ship-to location. BL902 BL967
SHP-ZIP Alpha 10 BL02.1 BL122
Postal Code Zip code of a customer's ship-to BL80.1 BL802
location. BL902 BL967
SHP-COUNTRY Alpha 30 (Lower Case) BL02.1 BL122
Country or Other Country name for a customer's ship-to BL80.1 BL802
location. BL902 BL967
SHP-TAX-EXEMPT-CD Alpha 1 BL02.1 BL802
Tax Exempt Code Code indicating the taxing status of a BL902 BL967
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-CITY-IO-FL Alpha 1 BL967
City IO Fl Indicates whether the address is inside
or outside the city limits. This is
used by tax calculation routines.
Y = Yes
N = No
SHP-TAX-CODE Alpha 10 BL02.1 BL802
Tax Code A user-defined code representing the BL902 BL967
tax authorities this ship-to pays sales TX140
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 BL902 BL967
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 BL02.1 BL802
Carrier Vendor This field contains the carrier vendor BL902 BL967
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 BL902 BL967
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 BL902 BL967
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 BL902 BL967
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-POD-REQ-FL Alpha 1 BL02.1 BL802
Pod Req Fl POD required flag. Indicates whether BL902 BL967
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 BL902 BL967
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 BL902 BL967
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 BL902 BL967
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 BL92.1
Used Flag indicating whether this ship-to BL967 OE10.1
location has ever been used. OE10.2 OE10.3
N = No OE10.4 OE10.5
Y = Yes OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.7
SHP-ACTIVE-FLAG Alpha 1 BL02.1 BL967
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 BL902 BL967
ship-to location is located.
SHP-SALESMAN Numeric 4 BL02.1 BL802
Salesman Number Sales representative for this customer BL902 BL967
ship-to location.
SHP-SALESMAN-2 Numeric 4 BL02.1 BL802
Salesman Number 2 Secondary sales representative for this BL902 BL967
customer ship-to location.
SHP-COMM-SPLIT Percent 5.3 (Percent) BL02.1 BL802
Commission Split Percentage of the total order value BL902 BL967
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 BL902 BL967
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 BL902 BL967
used to price items ordered for this
customer ship-to.
SHP-LAST-CMNT-SEQ Numeric 3 BL02.2 BL967
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 only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
SHIPTO FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SHPSET1 COMPANY AR08.1 AR10.1
CUSTOMER AR501 AR550
SHIP-TO BL02.1 BL02.2
BL120 BL121
BL122 BL130
BL20.1 BL20.3
BL202 BL21.2
BL21.5 BL29.1
BL29.2 BL290
BL320 BL520
BL80.1 BL802
BL820 BL90.1
BL92.1 BL940
BL967 OE10.1
OE10.2 OE10.3
...
SHPSET2 COMPANY Subset BL02.1 OE510
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
SHIPTO FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments SHIPTOCMNT Delete Cascades
SHP-COMPANY -> SPC-COMPANY
SHP-CUSTOMER -> SPC-CUSTOMER
SHP-SHIP-TO -> SPC-SHIP-TO
SPC-SEQ
|