on 12-14-2016 1:48 PM
The Account Details data source provides account addresses but I cannot find a field in the data source that indicates if the address is a default Ship to, Bill to or Remit to address. Were can this information be found other than through the Account > Addresses screen?
Hi Bill,
The below data sources will provide the Ship-To and Bill-To details for respective documents.
Ship-To Sales Order Item - CRMSLOIB
Customer Contract Item - CRMCCOIB
Customer Invoice Item - CRMCIVIB
Sales Order Item - CRMSLOIB
Sales Order Item Historical Data - CRMSLOIHB
Customer Invoice Item with Tax Details - GLOCIB01
Ship-to Location
Delivered Quantity - SCMOBDB02
Logistics Unit Delivered Quantity - SCMOBDB03_IT
Outbound Delivery Detail Line Items - SCMOBDU02
Outbound Delivery Header Details - SCMOBDB01
Outbound Delivery Item Details - SCMOBDU01
Outbound Delivery Items - SCMOBDU01_IT
Bill-To
Customer Invoice Header - CRMCIVHB
Customer Invoice Item - CRMCIVIB
Customer Returns Item - CRMCRTIB
Sales Order Item - CRMSLOIB
Best Regards,
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bill,
have you found it? I am just asking because I am looking for the same data.
Many thanks if you share the info.
Laszlo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.