biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / WTax Certificates
API OWTC
OWTC - WTax Certificates Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
RctTypeObject TypenVarChar
24) Incoming Payment
46) Outgoing Payment
20
RctAbsReceipt No.Int
11
JurisdictJurisdictionnVarChar
2
WtaxTypeWTax TypenVarChar
--) WTax Certificate
OV) Outgoing VAT - Withholding Tax
OG) Outgoing Gross Income - Withholding Tax
ON) Outgoing Income Tax - Withholding Tax
OS) Outgoing Social Security - Withholding Tax
OI) Outgoing Industry Specific - Withholding Tax
OD) Outgoing District Specific - Withholding Tax
IC) Incoming WTax Certificate
2
WtAbsEntryInternal NumberInt
11
DueDateDue DateDate
8
CerSeriesWTax Certificate SeriesnVarChar
6
NumberNumberInt
11
RefNumberReference NumbernVarChar
20
SumVatAmntSum of VAT AmountNum
20
SumDocTotSum of Doc. Total AmountNum
20
SumBaseAmnSum of Base AmountNum
20
SumAccumAmSum of Accumulated AmountNum
20
SumPercpAmSum of Perception AmountNum
20
PTICodePOI CodenVarChar
5
HandwrttenManual NumberingVarChar
Y) Yes
N) No
1
N
PIndicatorPeriod IndicatornVarChar
10
' '
PTICodeRefPOI Code ReferencenVarChar
20

SELECT statement

SELECT OWTC.AbsEntry AS 'Internal Number', OWTC.RctType AS 'Object Type', OWTC.RctAbs AS 'Receipt No.', OWTC.Jurisdict AS 'Jurisdiction', OWTC.WtaxType AS 'WTax Type', OWTC.WtAbsEntry AS 'Internal Number', OWTC.DueDate AS 'Due Date', OWTC.CerSeries AS 'WTax Certificate Series', OWTC.Number AS 'Number', OWTC.RefNumber AS 'Reference Number', OWTC.SumVatAmnt AS 'Sum of VAT Amount', OWTC.SumDocTot AS 'Sum of Doc. Total Amount', OWTC.SumBaseAmn AS 'Sum of Base Amount', OWTC.SumAccumAm AS 'Sum of Accumulated Amount', OWTC.SumPercpAm AS 'Sum of Perception Amount', OWTC.PTICode AS 'POI Code', OWTC.Handwrtten AS 'Manual Numbering', OWTC.PIndicator AS 'Period Indicator', OWTC.PTICodeRef AS 'POI Code Reference' FROM OWTC AS OWTC

Related information
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