Table: Ship-To Locations

Table: ARCSP
View: AR0023
Record Length: 1159

Flags: A R 

Keys: 2

Title Flags Fields
Customer, Ship-To Location IDCUST, IDCUSTSHPT
Ship-To Location, Customer IDCUSTSHPT, IDCUST

Fields: 56

Field Type Title Presentation
IDCUST String*12 Customer Number Mask: %-12C
IDCUSTSHPT String*6 Ship-To Location Mask: %-6C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
SWACTV Integer Status List:2 entries
0 = Inactive
1 = Active
DATEINAC Date Inactive Date
DATELASTMN Date Date Last Maintained
DATELASTIV Date Reserved
NAMELOCN String*60 Description
TEXTSTRE1 String*60 Address Line 1
TEXTSTRE2 String*60 Address Line 2
TEXTSTRE3 String*60 Address Line 3
TEXTSTRE4 String*60 Address Line 4
NAMECITY String*30 City
CODESTTE String*30 State/Prov.
CODEPSTL String*20 Zip/Postal Code
CODECTRY String*30 Country
NAMECTAC String*60 Contact Name
TEXTPHON1 String*30 Phone Number Mask: (%-3C) %-3C-%-24C
TEXTPHON2 String*30 Fax Number Mask: (%-3C) %-3C-%-24C
CODETERR String*6 Territory Code Mask: %-6N
CODETAXGRP String*12 Tax Group Mask: %-12N
IDTAXREGI1 String*20 Tax Registration No. 1
IDTAXREGI2 String*20 Tax Registration No. 2
IDTAXREGI3 String*20 Tax Registration No. 3
IDTAXREGI4 String*20 Tax Registration No. 4
IDTAXREGI5 String*20 Tax Registration No. 5
TAXSTTS1 Integer Tax Class Code 1
TAXSTTS2 Integer Tax Class Code 2
TAXSTTS3 Integer Tax Class Code 3
TAXSTTS4 Integer Tax Class Code 4
TAXSTTS5 Integer Tax Class Code 5
SHIPVIA String*15 Reserved
SPCLINST String*60 Special Instructions
CODESLSP1 String*8 Salesperson 1 Mask: %-8N
CODESLSP2 String*8 Salesperson 2 Mask: %-8N
CODESLSP3 String*8 Salesperson 3 Mask: %-8N
CODESLSP4 String*8 Salesperson 4 Mask: %-8N
CODESLSP5 String*8 Salesperson 5 Mask: %-8N
PCTSASPLT1 BCD*5.5 Sales-Split Percentage 1
PCTSASPLT2 BCD*5.5 Sales-Split Percentage 2
PCTSASPLT3 BCD*5.5 Sales-Split Percentage 3
PCTSASPLT4 BCD*5.5 Sales-Split Percentage 4
PCTSASPLT5 BCD*5.5 Sales-Split Percentage 5
PRICLIST String*6 Customer Price List Mask: %-6C
FOB String*60 Free On Board
SHPVIACODE String*6 Ship Via Code Mask: %-6N
SHPVIADESC String*60 Ship Via Description
EMAIL String*50 E-mail
CTACPHONE String*30 Contact's Phone Mask: (%-3C) %-3C-%-24C
CTACFAX String*30 Contact's Fax Mask: (%-3C) %-3C-%-24C
CTACEMAIL String*50 Contact's E-mail
VALUES Long Optional Fields
LOCATION String*6 Inventory Location Mask: %-6N

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).