biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Purchase Quotation - Import Process
API PQT17
PQT17 - Purchase Quotation - Import Process Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11OPQT
Purchase Quotation		PRIMARYYes
LineNumRow NumberInt
11
LogInstancLog InstanceInt
11
0
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History		540000006
ImpDocTypeType of Importation DocumentVarChar
1OBSI
Brazil String Indexer
ImpDocNumImportation Document NumbernVarChar
10
DateOfRegDate of Registry DI/DSI/DADate
8
CustClrDatDate of Customs ClearanceDate
8
ConcActNumDrawback Concession Acct No.nVarChar
30
AdditNumAdditional NumbernVarChar
30
AddItmDVAdditional Item Discount ValueNum
20
tpVTranspOverland Transport RouteInt
1) Maritime
2) Waterway
3) Lakeside
4) Air
5) Post
6) Train
7) Road
8) Network Transmission
9) Own Means
10) Input/Output Fictitious
6

Table relationship map

SELECT statement

SELECT PQT17.DocEntry AS 'Document Internal ID', PQT17.LineNum AS 'Row Number', PQT17.LogInstanc AS 'Log Instance', PQT17.ObjectType AS 'Object Type', PQT17.ImpDocType AS 'Type of Importation Document', PQT17.ImpDocNum AS 'Importation Document Number', PQT17.DateOfReg AS 'Date of Registry DI/DSI/DA', PQT17.CustClrDat AS 'Date of Customs Clearance', PQT17.ConcActNum AS 'Drawback Concession Acct No.', PQT17.AdditNum AS 'Additional Number', PQT17.AddItmDV AS 'Additional Item Discount Value', PQT17.tpVTransp AS 'Overland Transport Route' FROM PQT17 AS PQT17

Related information


Purchase Quotation OPQT SQL Table

Brazil String Indexer OBSI SQL Table

Object Settings - History ADP1 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