biuan SAP® BUSINESS ONE SDK
API PRQ13
PRQ13 - Purchase Request Rows - Distributed Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYInternal Document IDInt
11OPRQ
Purchase Request
LINENo
LineNumRow NumberInt
11
GroupNumGroup NumberInt
11
ExpnsCodeFreight CodeInt
11OEXD
Freight Setup
LineTotalTotalNum
20
TotalFrgnTotal (FC)Num
20
TotalSumSyTotal (SC)Num
20
PaidToDatePaid to DateNum
20
PaidFCPaid (FC)Num
20
PaidSysPaid (SC)Num
20
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
1470000113
LogInstancLog InstanceInt
11
0
TaxStatusTax LiableVarChar
Y) Yes
N) No
1
Y
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
VatPrcntRow Tax %Num
20
VatSumTax AmountNum
20
VatSumFrgnTax Amount (FC)Num
20
VatSumSyTax Amount (SC)Num
20
DedVatSumDeductible Tax AmountNum
20
DedVatSumFDeductible Tax Amount (FC)Num
20
DedVatSumSDeductible Tax Amount (SC)Num
20
IsAcquistnAquisition TaxVarChar
Y) Yes
N) No
1
N
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
TaxTypeTax TypeVarChar
Y) Normal Tax
N) No Tax
U) Use Tax
1
Y
VatAppliedVAT AppliedNum
20
VatAppldFCVAT Applied ForeignNum
20
VatAppldSCVAT Applied SystemNum
20
EquVatPerEqualization Tax %Num
20
EquVatSumTotal Equalization TaxNum
20
EquVatSumFTotal Equalization Tax (FC)Num
20
EquVatSumSTotal Equalization Tax (SC)Num
20
lineVatNet Tax AmountNum
20
lineVatlFNet Tax Amount (FC)Num
20
lineVatSNet Tax Amount (SC)Num
20
WtLiableWTax LiableVarChar
Y) Yes
N) No
1
BaseMethodBase MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
T) Total
A) All
1
StockStockVarChar
Y) Yes
N) No
1
N
LstPchPrceLast Purchase PriceVarChar
Y) Yes
N) No
1
AnalysRptAnalysis ReportVarChar
Y) Yes
N) No
1
N
BaseAbsEntBase Abs. EntryInt
11
-1
BaseTypeBase Document TypeInt
11
BaseRefBase Document ReferenceInt
11
BaseLnNumBase Document Line No.Int
11
TrgTypeTarget TypeInt
11
TrgAbsEntTarget Abs. EntryInt
11
-1
BaseGroupBase Document GroupInt
11
-1
StatusStatusVarChar
O) Open
C) Close
1
O
TrgGroupTarget GroupInt
11
-1
VisOrderVisual OrderInt
11
DistrbMthdDistribution MethodVarChar
N) None
Q) Quantity
V) Volume
W) Weight
E) Equally
T) Row Total
1
DistribExpDistribute FreightsVarChar
Y) Yes
N) No
1
FixCurrFixation CurrencynVarChar
3OCRN
Currency Codes
VatDscntPrTax Discount %Num
20
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
OcrCode2Distribution Rule 2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule 3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule 4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule 5nVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT PRQ13.DocEntry AS 'Internal Document ID', PRQ13.LineNum AS 'Row Number', PRQ13.GroupNum AS 'Group Number', PRQ13.ExpnsCode AS 'Freight Code', PRQ13.LineTotal AS 'Total', PRQ13.TotalFrgn AS 'Total (FC)', PRQ13.TotalSumSy AS 'Total (SC)', PRQ13.PaidToDate AS 'Paid to Date', PRQ13.PaidFC AS 'Paid (FC)', PRQ13.PaidSys AS 'Paid (SC)', PRQ13.ObjType AS 'Object Type', PRQ13.LogInstanc AS 'Log Instance', PRQ13.TaxStatus AS 'Tax Liable', PRQ13.VatGroup AS 'Tax Group', PRQ13.VatPrcnt AS 'Row Tax %', PRQ13.VatSum AS 'Tax Amount', PRQ13.VatSumFrgn AS 'Tax Amount (FC)', PRQ13.VatSumSy AS 'Tax Amount (SC)', PRQ13.DedVatSum AS 'Deductible Tax Amount', PRQ13.DedVatSumF AS 'Deductible Tax Amount (FC)', PRQ13.DedVatSumS AS 'Deductible Tax Amount (SC)', PRQ13.IsAcquistn AS 'Aquisition Tax', PRQ13.TaxCode AS 'Tax Code', PRQ13.TaxType AS 'Tax Type', PRQ13.VatApplied AS 'VAT Applied', PRQ13.VatAppldFC AS 'VAT Applied Foreign', PRQ13.VatAppldSC AS 'VAT Applied System', PRQ13.EquVatPer AS 'Equalization Tax %', PRQ13.EquVatSum AS 'Total Equalization Tax', PRQ13.EquVatSumF AS 'Total Equalization Tax (FC)', PRQ13.EquVatSumS AS 'Total Equalization Tax (SC)', PRQ13.lineVat AS 'Net Tax Amount', PRQ13.lineVatlF AS 'Net Tax Amount (FC)', PRQ13.lineVatS AS 'Net Tax Amount (SC)', PRQ13.WtLiable AS 'WTax Liable', PRQ13.BaseMethod AS 'Base Method', PRQ13.Stock AS 'Stock', PRQ13.LstPchPrce AS 'Last Purchase Price', PRQ13.AnalysRpt AS 'Analysis Report', PRQ13.BaseAbsEnt AS 'Base Abs. Entry', PRQ13.BaseType AS 'Base Document Type', PRQ13.BaseRef AS 'Base Document Reference', PRQ13.BaseLnNum AS 'Base Document Line No.', PRQ13.TrgType AS 'Target Type', PRQ13.TrgAbsEnt AS 'Target Abs. Entry', PRQ13.BaseGroup AS 'Base Document Group', PRQ13.Status AS 'Status', PRQ13.TrgGroup AS 'Target Group', PRQ13.VisOrder AS 'Visual Order', PRQ13.DistrbMthd AS 'Distribution Method', PRQ13.DistribExp AS 'Distribute Freights', PRQ13.FixCurr AS 'Fixation Currency', PRQ13.VatDscntPr AS 'Tax Discount %', PRQ13.OcrCode AS 'Distribution Rule', PRQ13.OcrCode2 AS 'Distribution Rule 2', PRQ13.OcrCode3 AS 'Distribution Rule 3', PRQ13.OcrCode4 AS 'Distribution Rule 4', PRQ13.OcrCode5 AS 'Distribution Rule 5', PRQ13.Project AS 'Project Code' FROM PRQ13 AS PRQ13

Related information


Purchase Request OPRQ SQL Table

Freight Setup OEXD SQL Table

Currency Codes OCRN SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Sales Tax Codes OSTC SQL Table

Tax Definition OVTG SQL Table



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