SOP50200 - Sales Document Header Temp | Prospr

SOP50200 - Sales Document Header Temp

Select * from SOP50200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type	Integer	2	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
SOPNUMBE	SOP Number	String	22	View
LOCNCODE	Location Code	String	12	View
CUSTNMBR	Customer Number	String	16	View
USERID	User ID	String	16	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DOCPRINTSEQ	Document Print Sequence	Long Integer	4	View
ShipToName	ShipToName	String	66	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
SHIPMTHD	Shipping Method	String	16	View
Reprint	Reprint	Boolean	2	View
Email_Type	Email Type	Integer	2	View
PHONNAME	Phone Number	String	22	View