biuan SAP® BUSINESS ONE SDK
SQL Administration / Loading Expenses
DTW Administration / Setup / Purchasing / Landed Costs
API OALC / / Landed Costs Codes
OALC - Loading Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AlcCode KEY UNIQUECodenVarChar
2
PRIMARYYes
AlcName KEYNamenVarChar
30
GROUP_NAMENo
OhTypeAllocation ByVarChar
F) Cash Value Before Customs
C) Cash Value After Customs
Q) Quantity
W) Weight
V) Volume
A) Equal
1
F
AcctCodeAccount CodenVarChar
15OACT
G/L Accounts
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Data Doc.
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
LaCAllcAccLanded Costs Alloc. AccountnVarChar
15

Table relationship map

SELECT statement

SELECT OALC.AlcCode AS 'Code', OALC.AlcName AS 'Name', OALC.OhType AS 'Allocation By', OALC.AcctCode AS 'Account Code', OALC.DataSource AS 'Data Source', OALC.UserSign AS 'User Signature', OALC.LaCAllcAcc AS 'Landed Costs Alloc. Account' FROM OALC AS OALC

Related information


Landed Costs Codes LandedCostsCodes Object· Table: OALC
The LandedCostsCodes object enables to define codes for landed costs and their distribution type. These codes are used in delivery notes to divide the landed costs between the items according to the specified distribution type (AllocationBy),...

OALC SQL Table

G/L Accounts OACT 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