biuan SAP® BUSINESS ONE SDK
API CIN5
CIN5 - A\R Correction Invoice - Withholding Tax Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUENumeratorInt
11OCIN
A/R Correction Invoice
SECONDERYYes
WTCodeWT CodenVarChar
4OWHT
Withholding Tax
RateRateNum
20
TaxbleAmntTaxable AmountNum
20
TxblAmntSCTaxable Amount in SCNum
20
TxblAmntFCTaxable Amount in FCNum
20
WTAmntWT AmountNum
20
WTAmntSCWT Amount (SC)Num
20
WTAmntFCWT Amount (FC)Num
20
ApplAmntApplied WT AmountNum
20
ApplAmntSCApplied WTax Amount (SC)Num
20
ApplAmntFCApplied WTax Amount (FC)Num
20
CategoryCategoryVarChar
P) Payment
I) Invoice
1
CriteriaCriteriaVarChar
Y) Accrual
N) Cash
1
AccountG/L AccountnVarChar
15OACT
G/L Accounts
TypeWithholding TypeVarChar
V) VAT Withholding
I) Income Tax Withholding
1
RoundTypeRounding TypeVarChar
T) Truncated
C) Commercial Values
N) No Rounding
1
BaseTypeBase TypeVarChar
G) Gross
N) Net
V) VAT
1
BaseAbsEntBase Abs EntryInt
11
-1
BaseLineBase LineInt
11
BaseNumBase Document TypeInt
-1)
0
23) Sales Quotation
17) Sales Order
16) A/R Returns
11
-1
LineNumLine NumberInt
11
BaseRefBase Document ReferenceInt
11
StatusStatusVarChar
O) Open
C) Closed
1
O
TrgTypeTarget Document TypeInt
11
TrgAbsEntrTarget Abs. EntryInt
11
-1
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
132
Doc1LineNoDOC1 Line NumberInt
11
-1
WtLineTypeWT Line TypeVarChar
D) Document Level WTax
L) Row Level WTax
1
D
TxblCurrTaxable Currency from Doc LinenVarChar
3
DtblCurrDeductible CurrencynVarChar
3
DtblRateRate for Deductible AmountNum
20
txblRateRate for Taxable AmountNum
20
DtblAmountDeductible AmountNum
20
TdsAccTDS AccountnVarChar
15OACT
G/L Accounts
SurAccSurcharge AccountnVarChar
15OACT
G/L Accounts
CessAccCess AccountnVarChar
15OACT
G/L Accounts
HscAccHSC AccountnVarChar
15OACT
G/L Accounts
TdsRateTDS RateNum
20
SurRateSurcharge RateNum
20
CessRateCess RateNum
20
HscRateHSC RateNum
20
TdsBAmtTDS Base AmountNum
20
TdsBAmtSCTDS Base Amount (SC)Num
20
TdsBAmtFCTDS Base Amount (FC)Num
20
SurBAmtSurcharge Base AmountNum
20
SurBAmtSCSurcharge Base Amount (SC)Num
20
SurBAmtFCSurcharge Base Amount (FC)Num
20
CessBAmtCess Base AmountNum
20
CessBAmtSCCess Base Amount (SC)Num
20
CessBAmtFCCess Base Amount (FC)Num
20
HscBAmtHSC Base AmountNum
20
HscBAmtSCHSC Base Amount (SC)Num
20
HscBAmtFCHSC Base Amount (FC)Num
20
TdsAmntTDS Tax AmountNum
20
TdsAmntSCTDS Tax Amount (SC)Num
20
TdsAmntFCTDS Tax Amount (FC)Num
20
SurAmntSurcharge Tax AmountNum
20
SurAmntSCSurcharge Tax Amount (SC)Num
20
SurAmntFCSurcharge Tax Amount (FC)Num
20
CessAmntCess Tax AmountNum
20
CessAmntSCCess Tax Amount (SC)Num
20
CessAmntFCCess Tax Amount (FC)Num
20
HscAmntHSC Tax AmountNum
20
HscAmntSCHSC Tax Amount (SC)Num
20
HscAmntFCHSC Tax Amount (FC)Num
20
TdsApplApplied TDS AmountNum
20
TdsApplSCApplied TDS Amount (SC)Num
20
TdsApplFCApplied TDS Amount (FC)Num
20
SurApplApplied Surcharge AmountNum
20
SurApplSCApplied Surcharge Amount (SC)Num
20
SurApplFCApplied Surcharge Amount (FC)Num
20
CessApplApplied Cess AmountNum
20
CessApplSCApplied Cess Amount (SC)Num
20
CessApplFCApplied Cess Amount (FC)Num
20
HscApplApplied HSC AmountNum
20
HscApplSCApplied HSC Amount (SC)Num
20
HscApplFCApplied HSC Amount (FC)Num
20
BatchNumJournal Voucher No.Int
11
InCSTCodeCST Code IncomingnVarChar
2
OutCSTCodeCST Code OutgoingnVarChar
2
DpmWTAplDPM WT Applied AmountNum
20
DpmWTAplSCDPM WT Applied Amount (SC)Num
20
DpmWTAplFCDPM WT Applied Amount (FC)Num
20

Table relationship map

SELECT statement

SELECT CIN5.AbsEntry AS 'Numerator', CIN5.WTCode AS 'WT Code', CIN5.Rate AS 'Rate', CIN5.TaxbleAmnt AS 'Taxable Amount', CIN5.TxblAmntSC AS 'Taxable Amount in SC', CIN5.TxblAmntFC AS 'Taxable Amount in FC', CIN5.WTAmnt AS 'WT Amount', CIN5.WTAmntSC AS 'WT Amount (SC)', CIN5.WTAmntFC AS 'WT Amount (FC)', CIN5.ApplAmnt AS 'Applied WT Amount', CIN5.ApplAmntSC AS 'Applied WTax Amount (SC)', CIN5.ApplAmntFC AS 'Applied WTax Amount (FC)', CIN5.Category AS 'Category', CIN5.Criteria AS 'Criteria', CIN5.Account AS 'G/L Account', CIN5.Type AS 'Withholding Type', CIN5.RoundType AS 'Rounding Type', CIN5.BaseType AS 'Base Type', CIN5.BaseAbsEnt AS 'Base Abs Entry', CIN5.BaseLine AS 'Base Line', CIN5.BaseNum AS 'Base Document Type', CIN5.LineNum AS 'Line Number', CIN5.BaseRef AS 'Base Document Reference', CIN5.Status AS 'Status', CIN5.TrgType AS 'Target Document Type', CIN5.TrgAbsEntr AS 'Target Abs. Entry', CIN5.LogInstanc AS 'Log Instance', CIN5.ObjType AS 'Object Type', CIN5.Doc1LineNo AS 'DOC1 Line Number', CIN5.WtLineType AS 'WT Line Type', CIN5.TxblCurr AS 'Taxable Currency from Doc Line', CIN5.DtblCurr AS 'Deductible Currency', CIN5.DtblRate AS 'Rate for Deductible Amount', CIN5.txblRate AS 'Rate for Taxable Amount', CIN5.DtblAmount AS 'Deductible Amount', CIN5.TdsAcc AS 'TDS Account', CIN5.SurAcc AS 'Surcharge Account', CIN5.CessAcc AS 'Cess Account', CIN5.HscAcc AS 'HSC Account', CIN5.TdsRate AS 'TDS Rate', CIN5.SurRate AS 'Surcharge Rate', CIN5.CessRate AS 'Cess Rate', CIN5.HscRate AS 'HSC Rate', CIN5.TdsBAmt AS 'TDS Base Amount', CIN5.TdsBAmtSC AS 'TDS Base Amount (SC)', CIN5.TdsBAmtFC AS 'TDS Base Amount (FC)', CIN5.SurBAmt AS 'Surcharge Base Amount', CIN5.SurBAmtSC AS 'Surcharge Base Amount (SC)', CIN5.SurBAmtFC AS 'Surcharge Base Amount (FC)', CIN5.CessBAmt AS 'Cess Base Amount', CIN5.CessBAmtSC AS 'Cess Base Amount (SC)', CIN5.CessBAmtFC AS 'Cess Base Amount (FC)', CIN5.HscBAmt AS 'HSC Base Amount', CIN5.HscBAmtSC AS 'HSC Base Amount (SC)', CIN5.HscBAmtFC AS 'HSC Base Amount (FC)', CIN5.TdsAmnt AS 'TDS Tax Amount', CIN5.TdsAmntSC AS 'TDS Tax Amount (SC)', CIN5.TdsAmntFC AS 'TDS Tax Amount (FC)', CIN5.SurAmnt AS 'Surcharge Tax Amount', CIN5.SurAmntSC AS 'Surcharge Tax Amount (SC)', CIN5.SurAmntFC AS 'Surcharge Tax Amount (FC)', CIN5.CessAmnt AS 'Cess Tax Amount', CIN5.CessAmntSC AS 'Cess Tax Amount (SC)', CIN5.CessAmntFC AS 'Cess Tax Amount (FC)', CIN5.HscAmnt AS 'HSC Tax Amount', CIN5.HscAmntSC AS 'HSC Tax Amount (SC)', CIN5.HscAmntFC AS 'HSC Tax Amount (FC)', CIN5.TdsAppl AS 'Applied TDS Amount', CIN5.TdsApplSC AS 'Applied TDS Amount (SC)', CIN5.TdsApplFC AS 'Applied TDS Amount (FC)', CIN5.SurAppl AS 'Applied Surcharge Amount', CIN5.SurApplSC AS 'Applied Surcharge Amount (SC)', CIN5.SurApplFC AS 'Applied Surcharge Amount (FC)', CIN5.CessAppl AS 'Applied Cess Amount', CIN5.CessApplSC AS 'Applied Cess Amount (SC)', CIN5.CessApplFC AS 'Applied Cess Amount (FC)', CIN5.HscAppl AS 'Applied HSC Amount', CIN5.HscApplSC AS 'Applied HSC Amount (SC)', CIN5.HscApplFC AS 'Applied HSC Amount (FC)', CIN5.BatchNum AS 'Journal Voucher No.', CIN5.InCSTCode AS 'CST Code Incoming', CIN5.OutCSTCode AS 'CST Code Outgoing', CIN5.DpmWTApl AS 'DPM WT Applied Amount', CIN5.DpmWTAplSC AS 'DPM WT Applied Amount (SC)', CIN5.DpmWTAplFC AS 'DPM WT Applied Amount (FC)' FROM CIN5 AS CIN5

Related information


A/R Correction Invoice OCIN SQL Table

G/L Accounts OACT SQL Table

Object Settings - History ADP1 SQL Table

Withholding Tax OWHT 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