SAP Business One Configuration for Salesforce
First published on: 08/19/2023/12:23 am
New Database Fields
OCRD
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFAccountId |
Alphanumeric (50) |
Salesforce Account ID |
OCPR
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFContactId |
Alphanumeric (20) |
SF Contact Id |
OITM
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFProductId |
Alphanumeric (50) |
Salesforce Product ID |
|
V33SB_SFPricebookEntryId |
Alphanumeric (50) |
Salesforce PricebookEntry ID |
|
V33SB_SFProductItemId |
Alphanumeric (50) |
Salesforce Product Item ID |
OITW
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFLASTCT |
Numeric |
SF Last Inventory Count |
OPLN
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFPricebookId |
Alphanumeric (20) |
Salesforce Pricebook Id |
OUSR
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFUserId |
Alphanumeric (25) |
Salesforce User ID |
OOPR
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFOpportunityId |
Alphanumeric (50) |
Salesforce Opportunity ID |
OINS
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFAssetId |
Alphanumeric (25) |
Salesforce Asset ID |
OQUT
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFQuoteId |
Alphanumeric (50) |
Salesforce Quote ID |
QUT1
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFLineId |
Alphanumeric (20) |
SalesforceLineid |
ORDR
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFOrderId |
Alphanumeric (50) |
Salesforce Order ID |
RDR1
|
Field Name |
Field Type |
Description |
|---|---|---|
|
V33SB_SFLineId |
Alphanumeric (20) |
SalesforceLineid |
New SAP Queries
GetSFInventory:
SELECT T0."ItemCode", T2."U_V33SB_SFProductId" ,T2."U_V33SB_SFProductItemId", T0."OnHand" - T0."IsCommited" + T0."OnOrder"as Qty, T0."WhsCode"
FROM OITW T0
INNER JOIN OWHS T1 ON T0."WhsCode" = T1."WhsCode"
INNER JOIN OITM T2 ON T0."ItemCode" = T2."ItemCode"
WHERE IFNULL(T0."U_V33SB_SFLASTCT", 0) <> T0."OnHand" - T0."IsCommited" +T0."OnOrder"
AND T2."U_V33SB_SFProductId" is not null
AND T1."WhsCode" = '01'
AND (T0."OnHand" - T0."IsCommited" + T0."OnOrder") > 0
GetSFOwnerCodeAsset:
SELECT T3."U_V33SB_SFUserId" as "SF_Code"
FROM
OCRD T0
LEFT JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode"
LEFT JOIN OHEM T2 ON T1."SlpCode" = T2."salesPrson"
LEFT JOIN OUSR T3 ON T2."userId" = T3."USERID"
WHERE T0."CardCode" = [%CardCode]
GetAssetDeliveryDate:
SELECT
--If delivery exist, use delivery doc date
CASE WHEN (SELECT COUNT(*) FROM ODLN WHERE "DocNum" = [%DocNum]) > 0 THEN
(SELECT T0."DocDate"
FROM ODLN T0
WHERE T0."DocNum" = [%DocNum])
--if does not exist, use the date from the equipment card
ELSE
[%EquipmentCardDelDate]
END as "DelDate" FROM DUMMY
GetItemAssetGroupName:
SELECT T0."ItmsGrpNam" FROM OITB T0
LEFT JOIN OITM T1 ON T0."ItmsGrpCod" = T1."ItmsGrpCod"
WHERE T1."ItemCode" = [%ItemCode]
|
Last modified: 11/15/2023/8:24 pm |