OUTX - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Finance /

Unreported VAT Transactions

API OUTX

OUTX - Unreported VAT Transactions Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11		PRIMARY	Yes
SrcObjType ^KEY ^UNIQUE	Source Object Type	nVarChar	-1) 15) Delivery notes 16) Revert Delivery Notes 17) Sales Order 20) Goods Receipt 21) Goods Return 22) Purchase order 23) Sales Quotation 112) Document Draft 59) Goods Receipt 60) Goods Issue 28) Journal Batches 140) Payment Draft 123) Checks for Payment Drafts 540000006) Purchase Quotation	20	-1	SECONDARY	Yes
SrcObjAbs	Source Object Internal ID	Int		11	-1
OrdinLNum	Ordial Num (BTF & Canceled)	Int		11	-1
Cancelled	Canceled	VarChar	N) No Y) Yes	1	N

SELECT statement

SELECT
   OUTX.AbsEntry AS 'Internal Number', 
   OUTX.SrcObjType AS 'Source Object Type', 
   OUTX.SrcObjAbs AS 'Source Object Internal ID', 
   OUTX.OrdinLNum AS 'Ordial Num (BTF & Canceled)', 
   OUTX.Cancelled AS 'Canceled'
FROM OUTX AS OUTX

Related information

OUTX SQL Table

biuan SAP® BUSINESS ONE

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