| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL Administration / Freight Setup DTW Administration / System Initialization / Additional Expenses API OEXD / / Additional Expenses | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OEXD - Freight Setup Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationAdditional 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 |