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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.