top of page

Search

ABS
- Oct 22, 2021
- 0 min read

SAP - DI API - Data Type Mapping

Application

DI API

Type	Structure	Type	SubType
Alphanumeric	Regular	db_Alpha	st_None
Alphanumeric	Address	db_Alpha	st_Address
Alphanumeric	Phone	db_Alpha	st_Phone
Alphanumeric	Text	db_Memo	st_None
Numeric	None	db_Numeric	st_None
Date/Hour	Date	db_Date	st_None
Date/Hour	Hour	db_Date	st_Time
Units And Totals	Rate	db_Float	st_Rate
Units And Totals	Sum	db_Float	st_Sum
Units And Totals	Price	db_Float	st_Price
Units And Totals	Quantity	db_Float	st_Quantity
Units And Totals	Percent	db_Float	st_Percentage
Units And Totals	Measure	db_Float	st_Measurement
General	Link	db_Memo	st_Link
General	Image	db_Alpha	st_Image

Recent Posts

SAP B1/iVend- Query Inventory In SAP

Check inventory audit in SAP select a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then 'Sale Invoice' when a.TransType = 14 then 'Sale Credit Note' when a

iVend Integration Configuration Error: Object reference not set to an instance of an object

ivend-SAP Integration Monitor from SBO to ivend Query

Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime, Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Fa

Post: Blog2_Post

bottom of page