biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / Additional Expenses
API OEXD / Additional Expenses
OEXD - Freight Setup Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ExpnsCode KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ExpnsName KEY UNIQUENamenVarChar
20
NAMEYes
RevAcctRevenue AccountnVarChar
15OACT
G/L Accounts
ExpnsAcctExpense AccountnVarChar
15OACT
G/L Accounts
TaxLiableTax LiableVarChar
Y) Yes
N) No
1
N
RevFixSumFixed Amount - RevenuesNum
20
ExpFixSumFixed Amount - ExpensesNum
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Incr.
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
VatGroupIOutput Tax GroupnVarChar
8OVTG
Tax Definition
VatGroupOInput Tax GroupnVarChar
8OVTG
Tax Definition
DistrbMthdDistribution MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
E) Equally
T) Row Total
1
N
In1099Include in 1099VarChar
Y) Yes
N) No
1
N
ExpOfstActFreight Clearing AccountnVarChar
15OACT
G/L Accounts
WTLiableWTax LiableVarChar
Y) Yes
N) No
1
N
BaseMethodDrawing MethodVarChar
N) None
Q) Quantity
T) Total
A) All
1
T
StockStockVarChar
Y) Yes
N) No
1
N
LstPchPrceLast Purchase PriceVarChar
Y) Yes
N) No
1
N
SalseRptSales Analysis ReportVarChar
Y) Yes
N) No
1
N
PchRptPurchase Analysis ReportVarChar
Y) Yes
N) No
1
N
RevExmAcctRevenues Exempted AccountnVarChar
15OACT
G/L Accounts
ExpnsExActExpense Exempted AccountnVarChar
15OACT
G/L Accounts
RevRetActRevenue Returns AccountnVarChar
15
ExpnsTypeFreight TypeVarChar
1) Shipping
2) Insurance
3) Other
4) Special
1
1
OcrCodeDistr. RulenVarChar
8OOCR
Distribution Rule
TaxDisMthdTax Distribution MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
E) Equally
T) Row Total
1
N
OcrCode2Distr. Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distr. Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distr. Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distr. Rule5nVarChar
8OOCR
Distribution Rule
OcrCodeXDistr. RulenVarChar
100OOCR
Distribution Rule
LogInstancLog InstanceInt
11
0
UpdateDateDate of UpdateDate
8
UserSign2Updating UserInt
6OUSR
Users
ProjectProjectnVarChar
20OPRJ
Project Codes
IntrastatIntrastat RelevantVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OEXD.ExpnsCode AS 'Internal Number', OEXD.ExpnsName AS 'Name', OEXD.RevAcct AS 'Revenue Account', OEXD.ExpnsAcct AS 'Expense Account', OEXD.TaxLiable AS 'Tax Liable', OEXD.RevFixSum AS 'Fixed Amount - Revenues', OEXD.ExpFixSum AS 'Fixed Amount - Expenses', OEXD.DataSource AS 'Data Source', OEXD.UserSign AS 'User Signature', OEXD.VatGroupI AS 'Output Tax Group', OEXD.VatGroupO AS 'Input Tax Group', OEXD.DistrbMthd AS 'Distribution Method', OEXD.In1099 AS 'Include in 1099', OEXD.ExpOfstAct AS 'Freight Clearing Account', OEXD.WTLiable AS 'WTax Liable', OEXD.BaseMethod AS 'Drawing Method', OEXD.Stock AS 'Stock', OEXD.LstPchPrce AS 'Last Purchase Price', OEXD.SalseRpt AS 'Sales Analysis Report', OEXD.PchRpt AS 'Purchase Analysis Report', OEXD.RevExmAcct AS 'Revenues Exempted Account', OEXD.ExpnsExAct AS 'Expense Exempted Account', OEXD.RevRetAct AS 'Revenue Returns Account', OEXD.ExpnsType AS 'Freight Type', OEXD.OcrCode AS 'Distr. Rule', OEXD.TaxDisMthd AS 'Tax Distribution Method', OEXD.OcrCode2 AS 'Distr. Rule2', OEXD.OcrCode3 AS 'Distr. Rule3', OEXD.OcrCode4 AS 'Distr. Rule4', OEXD.OcrCode5 AS 'Distr. Rule5', OEXD.OcrCodeX AS 'Distr. Rule', OEXD.LogInstanc AS 'Log Instance', OEXD.UpdateDate AS 'Date of Update', OEXD.UserSign2 AS 'Updating User', OEXD.Project AS 'Project', OEXD.Intrastat AS 'Intrastat Relevant' FROM OEXD AS OEXD

Related information


Additional Expenses AdditionalExpenses Object· Table: OEXD
AdditionalExpenses is a business object that represents the additional expenses defined in the Administration module. These definitions are used by the Marketing Documents and Receipts. This object enables to calculate additional costs connected...

OEXD SQL Table

G/L Accounts OACT SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Users OUSR SQL Table

Tax Definition OVTG 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