| |||
API OGTI | |||
OGTI - GTS Invoice Table SBO SQL database table detailsSELECT statementSELECT
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 informationOGTI 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 |