biuan SAP® BUSINESS ONE SDK
API OGTI
OGTI - GTS Invoice Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CreateDateCreate DateDate
8
MappingNumGTS Mapping No.nVarChar
20
VoidingVoiding FlagVarChar
0
1) Voided
1
0
ItemListItem ListVarChar
0
1) With Item List
1
CategNumGTS Cat. No.nVarChar
10
GtsInvNumGTS Invoice No.nVarChar
8
ItemRowNumItem List Row NumberInt
11
DocDateDocument DateDate
8
FiscaMonthFiscal MonthInt
6
DocAmountDocument AmountNum
20
VatPercentVAT PercentNum
20
VatAmountVAT AmountNum
20
BpNameBP NamenVarChar
100
BpTaxRgNumBP Tax Registration No.nVarChar
20
BpAddrTelBP Address and TelephonenVarChar
80
BpBankNumBP Bank NumbernVarChar
60
SellerNameSeller NamenVarChar
80
SelTaxRegSeller Tax Registration No.nVarChar
80
SelAddTelSeller Address and Tel.nVarChar
80
SelBankActSeller Bank AccountnVarChar
80
RemarksRemarksnVarChar
127
IssuerIssuernVarChar
8
CheckerCheckernVarChar
8
PayeePayeenVarChar
8
InBndFileInbound File: Full NamenVarChar
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



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