biuan SAP® BUSINESS ONE SDK
DTW A/R Correction Invoice - Freight
API Documents Additional Expenses / Base Doc Entry
CSI3 - A/R Correction Invoice - Freight Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYDocument Internal IDInt
11OCSI
A/R Correction Invoice
DOCUMENTNo
ExpnsCodeExpense CodeInt
11OEXD
Freight Setup
LineTotalTotalNum
20
TotalFrgnTotal (FC)Num
20
TotalSumSyTotal (SC)Num
20
PaidToDatePaid to DateNum
20
PaidFCPaid in FCNum
20
PaidSysPaid in SCNum
20
CommentsRemarksnVarChar
100
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
165
LogInstancLog InstanceInt
11
0
DistrbMthdDistribution MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
E) Equally
T) Row Total
1
TaxStatusTax LiableVarChar
Y) Yes
N) No
1
Y
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatPrcntRow Tax %Num
20
VatSumTax AmountNum
20
VatSumFrgnTax Amount (FC)Num
20
VatSumSyTax Amount (SC)Num
20
DedVatSumDeductible Tax AmountNum
20
DedVatSumFDeductible Tax Amount (FC)Num
20
DedVatSumSDeductible Tax Amount (SC)Num
20
IsAcquistnAquisition TaxVarChar
Y) Yes
N) No
1
N
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
TaxTypeTax TypeVarChar
Y) Regular Tax
N) No Tax
U) Use Tax
1
Y
WTLiableWT LiableVarChar
Y) Yes
N) No
1
VatAppliedVat AppliedNum
20
VatAppldFCApplied Tax (FC)Num
20
VatAppldSCApplied Tax (SC)Num
20
EquVatPerEqualization Tax %Num
20
EquVatSumTotal Equalization TaxNum
20
EquVatSumFTotal Equalization Tax (FC)Num
20
EquVatSumSTotal Equalization Tax (SC)Num
20
LineVatNet Tax AmountNum
20
LineVatFNet Tax Amount (FC)Num
20
LineVatSNet Tax Amount (SC)Num
20
BaseMethodBase MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
T) Total
A) All
1
StockStockVarChar
Y) Yes
N) No
1
LstPchPrceLast Purchase PriceVarChar
Y) Yes
N) No
1
AnalysRptAnalysis ReportVarChar
Y) Yes
N) No
1
N
BaseAbsEntBase Abs EntryInt
11
-1
BaseTypeBase Document TypeInt
-1)
0
13) A/R Invoice
165) A/R Correction Invoice
11
BaseRefBase Document ReferenceInt
11
BaseLnNumBase Document Line No.Int
11
LineNumline numInt
11
-1
StatusStatusVarChar
O) Open
C) Closed
1
O
TrgTypeTarget TypeInt
11
TrgAbsEntTarget Abs. EntryInt
11
-1
StDstrStock Distributed SumNum
20
StDstrSCStock Distributed Sum (SC)Num
20
StDstrFCStock Distributed Sum (FC)Num
20
FixCurrFixation CurrencynVarChar
3OCRN
Currency Codes
VatDscntPrTax Discount %Num
20
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
TaxDistMtdTax Distribution MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
E) Equally
T) Row Total
1
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes
VatGrpSrcVAT Group SourceVarChar
N) Not Defined
M) Manually Entered
D) Determined
1
N
DrawnTotalDrawn TotalNum
20
DrawnFCDrawn Total (FC)Num
20
DrawnSCDrawn Total (SC)Num
20

Table relationship map

SELECT statement

SELECT CSI3.DocEntry AS 'Document Internal ID', CSI3.ExpnsCode AS 'Expense Code', CSI3.LineTotal AS 'Total', CSI3.TotalFrgn AS 'Total (FC)', CSI3.TotalSumSy AS 'Total (SC)', CSI3.PaidToDate AS 'Paid to Date', CSI3.PaidFC AS 'Paid in FC', CSI3.PaidSys AS 'Paid in SC', CSI3.Comments AS 'Remarks', CSI3.ObjType AS 'Object Type', CSI3.LogInstanc AS 'Log Instance', CSI3.DistrbMthd AS 'Distribution Method', CSI3.TaxStatus AS 'Tax Liable', CSI3.VatGroup AS 'Tax Group', CSI3.VatPrcnt AS 'Row Tax %', CSI3.VatSum AS 'Tax Amount', CSI3.VatSumFrgn AS 'Tax Amount (FC)', CSI3.VatSumSy AS 'Tax Amount (SC)', CSI3.DedVatSum AS 'Deductible Tax Amount', CSI3.DedVatSumF AS 'Deductible Tax Amount (FC)', CSI3.DedVatSumS AS 'Deductible Tax Amount (SC)', CSI3.IsAcquistn AS 'Aquisition Tax', CSI3.TaxCode AS 'Tax Code', CSI3.TaxType AS 'Tax Type', CSI3.WTLiable AS 'WT Liable', CSI3.VatApplied AS 'Vat Applied', CSI3.VatAppldFC AS 'Applied Tax (FC)', CSI3.VatAppldSC AS 'Applied Tax (SC)', CSI3.EquVatPer AS 'Equalization Tax %', CSI3.EquVatSum AS 'Total Equalization Tax', CSI3.EquVatSumF AS 'Total Equalization Tax (FC)', CSI3.EquVatSumS AS 'Total Equalization Tax (SC)', CSI3.LineVat AS 'Net Tax Amount', CSI3.LineVatF AS 'Net Tax Amount (FC)', CSI3.LineVatS AS 'Net Tax Amount (SC)', CSI3.BaseMethod AS 'Base Method', CSI3.Stock AS 'Stock', CSI3.LstPchPrce AS 'Last Purchase Price', CSI3.AnalysRpt AS 'Analysis Report', CSI3.BaseAbsEnt AS 'Base Abs Entry', CSI3.BaseType AS 'Base Document Type', CSI3.BaseRef AS 'Base Document Reference', CSI3.BaseLnNum AS 'Base Document Line No.', CSI3.LineNum AS 'line num', CSI3.Status AS 'Status', CSI3.TrgType AS 'Target Type', CSI3.TrgAbsEnt AS 'Target Abs. Entry', CSI3.StDstr AS 'Stock Distributed Sum', CSI3.StDstrSC AS 'Stock Distributed Sum (SC)', CSI3.StDstrFC AS 'Stock Distributed Sum (FC)', CSI3.FixCurr AS 'Fixation Currency', CSI3.VatDscntPr AS 'Tax Discount %', CSI3.OcrCode AS 'Distribution Rule', CSI3.TaxDistMtd AS 'Tax Distribution Method', CSI3.OcrCode2 AS 'Distribution Rule2', CSI3.OcrCode3 AS 'Distribution Rule3', CSI3.OcrCode4 AS 'Distribution Rule4', CSI3.OcrCode5 AS 'Distribution Rule5', CSI3.Project AS 'Project Code', CSI3.VatGrpSrc AS 'VAT Group Source', CSI3.DrawnTotal AS 'Drawn Total', CSI3.DrawnFC AS 'Drawn Total (FC)', CSI3.DrawnSC AS 'Drawn Total (SC)' FROM CSI3 AS CSI3

Related information


 v9.0  Base Doc Entry BaseDocEntry Property· Table: CSI3
Sets or returns the source document ID. Field name: DocEntry.
· Table: DRF3 RPC3 PCH3 CPI3 CPV3 PDN3 RPD3 POR3 PQT3 RIN3 INV3 CSI3 CSV3 DLN3 RDN3 RDR3 QUT3    Parent: Documents Additional Expenses DocumentsAdditionalExpenses Object· Table: DRF3 RPC3 PCH3 CPI3 CPV3 PDN3 RPD3 POR3 PQT3 RIN3 INV3 CSI3 CSV3 DLN3 RDN3 RDR3 QUT3
A/R Correction Invoice OCSI SQL Table

Freight Setup OEXD SQL Table

Currency Codes OCRN SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Sales Tax Codes OSTC 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates