OSHP - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

Delivery Types

DTW Administration / Setup / Inventory / Shipping Types

API OSHP / / Shipping Types

OSHP - Delivery Types Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
TrnspCode ^KEY ^UNIQUE	Code	Int		6			PRIMARY	Yes
TrnspName ^KEY ^UNIQUE	Name	nVarChar		40			NAME	Yes
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer	1		N
UserSign	User Signature	Int		6	OUSR Users
WebSite	Web Site	nVarChar		50

Table relationship map

SELECT statement

SELECT
   OSHP.TrnspCode AS 'Code', 
   OSHP.TrnspName AS 'Name', 
   OSHP.DataSource AS 'Data Source', 
   OSHP.UserSign AS 'User Signature', 
   OSHP.WebSite AS 'Web Site'
FROM OSHP AS OSHP

Related information

ShippingTypes Object· Table: OSHP

The ShippingTypes object enables to define transportation methods (for example, air cargo and courier) to carry out deliveries. A shipping type can be assigned to a document, item master data, and business partner master data. Source table:...

OSHP SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
ShippingTypes

Method

Add

GetAsXML

GetByKey

Remove

SaveToFile

SaveXML

Update

Property

Browser

Code

DTW DB

Name

DTW DB

UserFields

Website

DTW DB

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates