ARSAP

partners.sagenorthamerica.com/.../210-30254.html

Can you tell me the table name where ARSAP is located?

ARSAP

Or is ARSAP the table? And if so, what is the "name" field called?

ARSAP is a table, I'm sure you can figure the rest out.

Jay provide the link to download the table names so you can find all this stuff.  I find this extremely easy to use.  

CODESLSP    String*8 Salesperson Mask: %-8N

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  

CODEEMPL    String*15 Employee Number  

NAMEEMPL    String*60 Name  

SWCOMM    Integer Commissions Paid List:2 entries

0 = No

1 = Yes

AMTANLTARG    BCD*10.3 Annual Sales Target  

SALESBASE1    BCD*10.3 Maximum Sales for Rate 1  

SALESBASE2    BCD*10.3 Maximum Sales for Rate 2  

SALESBASE3    BCD*10.3 Maximum Sales for Rate 3  

SALESBASE4    BCD*10.3 Maximum Sales for Rate 4  

SALESRATE1    BCD*5.5 Commission Rate 1  

SALESRATE2    BCD*5.5 Commission Rate 2  

SALESRATE3    BCD*5.5 Commission Rate 3  

SALESRATE4    BCD*5.5 Commission Rate 4  

SALESRATE5    BCD*5.5 Commission Rate 5  

SALESCOMM    BCD*10.3 Commissionable Sales  

SALESCOST    BCD*10.3 Cost of Commissionable Sales  

DATECLRD    Date Date Last Cleared

you will need to link to ARSAP.NAMEEMPL

There are application object models available for the product.  Good Luck

Thanks

Stacey

One last question, what is table for Shipment optional fields? I know table for Shipment Details optional field is OESHIDO, is it just OESHIO?

partners.sagenorthamerica.com/.../210-30254.html

Shipment header optional fields?

OESHIHO