View: Ship-To Locations

RotoID: AR0023
Table: ARCSP
Protocol: Header
DLL:ARCSP

Compositions: 1

RotoID Tables Title DLL
AR0412 ARCSPO Ship-To Locations Optional Field Values ARCSPO

Keys: 2

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

Fields: 58

Field Index Type Title Attributes Presentation
IDCUST 1 String*12 Customer Number E A K R  Mask: %-12C
IDCUSTSHPT 2 String*6 Ship-To Location E A K R  Mask: %-6C
SWACTV 3 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
DATEINAC 4 Date Inactive Date E A C 
DATELASTMN 5 Date Date Last Maintained E A C 
DATELASTIV 6 Date Reserved E 
NAMELOCN 7 String*60 Description E A 
TEXTSTRE1 8 String*60 Address Line 1 E A 
TEXTSTRE2 9 String*60 Address Line 2 E A 
TEXTSTRE3 10 String*60 Address Line 3 E A 
TEXTSTRE4 11 String*60 Address Line 4 E A 
NAMECITY 12 String*30 City E A 
CODESTTE 13 String*30 State/Prov. E A 
CODEPSTL 14 String*20 Zip/Postal Code E A 
CODECTRY 15 String*30 Country E A 
NAMECTAC 16 String*60 Contact Name E A 
TEXTPHON1 17 String*30 Phone Number E A P  Mask: (%-3C) %-3C-%-24C
TEXTPHON2 18 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
CODETERR 19 String*6 Territory Code E A  Mask: %-6N
CODETAXGRP 20 String*12 Tax Group E A  Mask: %-12N
IDTAXREGI1 21 String*20 Tax Registration No. 1 E A 
IDTAXREGI2 22 String*20 Tax Registration No. 2 E A 
IDTAXREGI3 23 String*20 Tax Registration No. 3 E A 
IDTAXREGI4 24 String*20 Tax Registration No. 4 E A 
IDTAXREGI5 25 String*20 Tax Registration No. 5 E A 
TAXSTTS1 26 Integer Tax Class Code 1 E A 
TAXSTTS2 27 Integer Tax Class Code 2 E A 
TAXSTTS3 28 Integer Tax Class Code 3 E A 
TAXSTTS4 29 Integer Tax Class Code 4 E A 
TAXSTTS5 30 Integer Tax Class Code 5 E A 
SHIPVIA 31 String*15 Reserved E 
SPCLINST 32 String*60 Special Instructions E A 
CODESLSP1 41 String*8 Salesperson 1 E A  Mask: %-8N
CODESLSP2 42 String*8 Salesperson 2 E A  Mask: %-8N
CODESLSP3 43 String*8 Salesperson 3 E A  Mask: %-8N
CODESLSP4 44 String*8 Salesperson 4 E A  Mask: %-8N
CODESLSP5 45 String*8 Salesperson 5 E A  Mask: %-8N
PCTSASPLT1 46 BCD*5.5 Sales-Split Percentage 1 E A 
PCTSASPLT2 47 BCD*5.5 Sales-Split Percentage 2 E A 
PCTSASPLT3 48 BCD*5.5 Sales-Split Percentage 3 E A 
PCTSASPLT4 49 BCD*5.5 Sales-Split Percentage 4 E A 
PCTSASPLT5 50 BCD*5.5 Sales-Split Percentage 5 E A 
PRICLIST 51 String*6 Customer Price List E A  Mask: %-6C
FOB 52 String*60 Free On Board E A 
SHPVIACODE 53 String*6 Ship Via Code E A  Mask: %-6N
SHPVIADESC 54 String*60 Ship Via Description E A 
SWPRIMSHPT 55 Integer Primary Ship-To Indicator E A  List:2 entries
0 = No
1 = Yes
EMAIL 56 String*50 E-mail E A 
CTACPHONE 57 String*30 Contact's Phone E A P  Mask: (%-3C) %-3C-%-24C
CTACFAX 58 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
CTACEMAIL 59 String*50 Contact's E-mail E A 
VALUES 60 Long Optional Fields E A C 
PROCESSCMD 61 Integer Process Command Code E A C  List:1 entries
0 = Insert Optional Fields
LOCATION 62 String*6 Inventory Location E A  Mask: %-6N
EWSUPPRESS 63 Boolean Suppress Integration E A 
EWARVER 64 String*3 A/R Version A 
EWORGID 65 String*6 Database A 
EWMODE 66 Integer Mode E A  List:2 entries
0 = Normal Mode
1 = Unconditional Inserts/Updates

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).