📚 SAP Business One SDK Help

Table Name: OEXD

Table Description: Freight Setup

Field Description Type Size Related Default Value Constraints
ExpnsCode Internal Number Int 11 -      
ExpnsName Name nVarChar 20 -      
RevAcct Revenue Account nVarChar 15 OACT      
ExpnsAcct Expense Account nVarChar 15 OACT      
TaxLiable Tax Liable VarChar 1 - N Y Yes
            N No
RevFixSum Fixed Amount - Revenues Num 19.6 -      
ExpFixSum Fixed Amount - Expenses Num 19.6 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Upgrade
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Auto Incr.
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
VatGroupI Output Tax Group nVarChar 8 OVTG      
VatGroupO Input Tax Group nVarChar 8 OVTG      
DistrbMthd Distribution Method VarChar 1 - N N None
            Q Quantity
            V Volume
            W Weight
            E Equally
            T Row Total
In1099 Include in 1099 VarChar 1 - N Y Yes
            N No
ExpOfstAct Freight Clearing Account nVarChar 15 OACT      
WTLiable WTax Liable VarChar 1 - N Y Yes
            N No
BaseMethod Drawing Method VarChar 1 - T N None
            Q Quantity
            T Total
            A All
Stock Stock VarChar 1 - N Y Yes
            N No
LstPchPrce Last Purchase Price VarChar 1 - N Y Yes
            N No
SalseRpt Sales Analysis Report VarChar 1 - N Y Yes
            N No
PchRpt Purchase Analysis Report VarChar 1 - N Y Yes
            N No
RevExmAcct Revenues Exempted Account nVarChar 15 OACT      
ExpnsExAct Expense Exempted Account nVarChar 15 OACT      
RevRetAct Revenue Returns Account nVarChar 15 -      
ExpnsType Freight Type VarChar 1 - 1 1 Shipping
            2 Insurance
            3 Other
            4 Special
OcrCode Distr. Rule nVarChar 8 OOCR      
TaxDisMthd Tax Distribution Method VarChar 1 - N N None
            Q Quantity
            V Volume
            W Weight
            E Equally
            T Row Total
OcrCode2 Distr. Rule2 nVarChar 8 OOCR      
OcrCode3 Distr. Rule3 nVarChar 8 OOCR      
OcrCode4 Distr. Rule4 nVarChar 8 OOCR      
OcrCode5 Distr. Rule5 nVarChar 8 OOCR      
OcrCodeX Distr. Rule nVarChar 100 OOCR      
LogInstanc Log Instance Int 11 - 0    
UpdateDate Date of Update Date 8 -      
UserSign2 Updating User Int 6 OUSR      
Project Project nVarChar 20 OPRJ      
Intrastat Intrastat Relevant VarChar 1 - N Y Yes
            N No
GrsFreight Gross Freight VarChar 1 - N Y Yes
            N No
SacCode SAC Code nVarChar 8 -      
FreighType Freight Type VarChar 1 - S S Standard
            B Bollo
DataVers Data Version Int 11 - 1    
DocFreight Document Operation Freight VarChar 1 - N Y Yes
            N No
ProdctType SAF-T Product Type VarChar 1 - S P Products
            S Services
            O Other
            I Taxes
ProdTypeEx SAF-T Product Type nVarChar 10 OSPT S    
IsActive Active VarChar 1 - Y Y Yes
            N No
Key Unique Field
PRIMARY Yes ExpnsCode
NAME Yes ExpnsName