|
|
SQL Administration / Freight Setup
DTW Administration / System Initialization / Additional Expenses
API OEXD / / Additional Expenses
OEXD - Freight Setup Table
Additional Expenses AdditionalExpenses Object· Table: OEXD
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ExpnsCode KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ExpnsName KEY UNIQUE | Name | nVarChar | 20 | NAME | Yes | |||
| RevAcct | Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpnsAcct | Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TaxLiable | Tax Liable | VarChar | Y) Yes N) No | 1 | N | |||
| RevFixSum | Fixed Amount - Revenues | Num | 20 | |||||
| ExpFixSum | Fixed Amount - Expenses | Num | 20 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| VatGroupI | Output Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatGroupO | Input Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| DistrbMthd | Distribution Method | VarChar | N) None Q) Quantity V) Volume W) Weight E) Equally T) Row Total | 1 | N | |||
| In1099 | Include in 1099 | VarChar | Y) Yes N) No | 1 | N | |||
| ExpOfstAct | Freight Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WTLiable | WTax Liable | VarChar | Y) Yes N) No | 1 | N | |||
| BaseMethod | Drawing Method | VarChar | N) None Q) Quantity T) Total A) All | 1 | T | |||
| Stock | Stock | VarChar | Y) Yes N) No | 1 | N | |||
| LstPchPrce | Last Purchase Price | VarChar | Y) Yes N) No | 1 | N | |||
| SalseRpt | Sales Analysis Report | VarChar | Y) Yes N) No | 1 | N | |||
| PchRpt | Purchase Analysis Report | VarChar | Y) Yes N) No | 1 | N | |||
| RevExmAcct | Revenues Exempted Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpnsExAct | Expense Exempted Account | nVarChar | 15 | OACT G/L Accounts | ||||
| RevRetAct | Revenue Returns Account | nVarChar | 15 | |||||
| ExpnsType | Freight Type | VarChar | 1) Shipping 2) Insurance 3) Other 4) Special | 1 | 1 | |||
| OcrCode | Distr. Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| TaxDisMthd | Tax Distribution Method | VarChar | N) None Q) Quantity V) Volume W) Weight E) Equally T) Row Total | 1 | N | |||
| OcrCode2 | Distr. Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distr. Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distr. Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distr. Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCodeX | Distr. Rule | nVarChar | 100 | OOCR Distribution Rule | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| Project | Project | nVarChar | 20 | OPRJ Project Codes | ||||
| Intrastat | Intrastat Relevant | VarChar | 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
AdditionalExpenses
Enumeration
Method
Property
DistributionMethod
DTW DB
DistributionRule
DTW DB
DrawingMethod
DTW DB
ExpensCode
DTW DB
ExpenseAccount
DTW DB
ExpenseExemptedAccount
DTW DB
FixedAmountExpenses
DTW DB
FixedAmountRevenues
DTW DB
FreightOffsetAccount
DTW DB
FreightType
DTW DB
Includein1099
DTW DB
InputVATGroup
DTW DB
LastPurchasePrice
DTW DB
Name
DTW DB
OutputVATGroup
DTW DB
RevenuesAccount
DTW DB
RevenuesExemptedAccount
DTW DB
Stock
DTW DB
TaxLiable
DTW DB
WTLiable
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
