biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Shipping Types
API OSHP / / Shipping Types
OSHP - Delivery Types Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TrnspCode KEY UNIQUECodeInt
6
PRIMARYYes
TrnspName KEY UNIQUENamenVarChar
40
NAMEYes
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
WebSiteWeb SitenVarChar
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


Shipping Types 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

Users OUSR SQL Table



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