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

SQL Marketing Documents and Receipts / GTS Invoice

API OGTI

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11		PRIMARY	Yes
CreateDate	Create Date	Date		8
MappingNum	GTS Mapping No.	nVarChar		20
Voiding	Voiding Flag	VarChar	0 1) Voided	1	0
ItemList	Item List	VarChar	0 1) With Item List	1
CategNum	GTS Cat. No.	nVarChar		10
GtsInvNum	GTS Invoice No.	nVarChar		8
ItemRowNum	Item List Row Number	Int		11
DocDate	Document Date	Date		8
FiscaMonth	Fiscal Month	Int		6
DocAmount	Document Amount	Num		20
VatPercent	VAT Percent	Num		20
VatAmount	VAT Amount	Num		20
BpName	BP Name	nVarChar		100
BpTaxRgNum	BP Tax Registration No.	nVarChar		20
BpAddrTel	BP Address and Telephone	nVarChar		80
BpBankNum	BP Bank Number	nVarChar		60
SellerName	Seller Name	nVarChar		80
SelTaxReg	Seller Tax Registration No.	nVarChar		80
SelAddTel	Seller Address and Tel.	nVarChar		80
SelBankAct	Seller Bank Account	nVarChar		80
Remarks	Remarks	nVarChar		127
Issuer	Issuer	nVarChar		8
Checker	Checker	nVarChar		8
Payee	Payee	nVarChar		8
InBndFile	Inbound File: Full Name	nVarChar		127

SELECT statement

SELECT
   OGTI.AbsEntry AS 'Internal Number', 
   OGTI.CreateDate AS 'Create Date', 
   OGTI.MappingNum AS 'GTS Mapping No.', 
   OGTI.Voiding AS 'Voiding Flag', 
   OGTI.ItemList AS 'Item List', 
   OGTI.CategNum AS 'GTS Cat. No.', 
   OGTI.GtsInvNum AS 'GTS Invoice No.', 
   OGTI.ItemRowNum AS 'Item List Row Number', 
   OGTI.DocDate AS 'Document Date', 
   OGTI.FiscaMonth AS 'Fiscal Month', 
   OGTI.DocAmount AS 'Document Amount', 
   OGTI.VatPercent AS 'VAT Percent', 
   OGTI.VatAmount AS 'VAT Amount', 
   OGTI.BpName AS 'BP Name', 
   OGTI.BpTaxRgNum AS 'BP Tax Registration No.', 
   OGTI.BpAddrTel AS 'BP Address and Telephone', 
   OGTI.BpBankNum AS 'BP Bank Number', 
   OGTI.SellerName AS 'Seller Name', 
   OGTI.SelTaxReg AS 'Seller Tax Registration No.', 
   OGTI.SelAddTel AS 'Seller Address and Tel.', 
   OGTI.SelBankAct AS 'Seller Bank Account', 
   OGTI.Remarks AS 'Remarks', 
   OGTI.Issuer AS 'Issuer', 
   OGTI.Checker AS 'Checker', 
   OGTI.Payee AS 'Payee', 
   OGTI.InBndFile AS 'Inbound File: Full Name'
FROM OGTI AS OGTI

Related information

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