biuan SAP® BUSINESS ONE SDK
API IPF3
IPF3 - Landed Costs - Customs Summary Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUELanded Costs Internal IDInt
11OIPF
Landed Costs
PRIMARYYes
LineNumRow NumberInt
11
DscriptionSummary DescriptionnVarChar
100
LaCAllcAccLanded Costs Alloc. AccountnVarChar
15
CustSumCustoms SummaryNum
20
CustSumFCCustoms Summary FCNum
20
CustSumSCCustoms Summary SCNum
20
OpenSumOpen Customs SummaryNum
20
OpenSumFCOpen Customs Summary (FC)Num
20
OpenSumSCOpen Customs Summary (SC)Num
20
AccTypeType of Account of SummarizedInt
11
VatGroupVAT CodenVarChar
8OVTG
Tax Definition
CstmVatStkIs Customs VAT in StockVarChar
Y) Yes
N) No
1
Y
CCDEntryCCD Abs. EntryInt
11

Table relationship map

SELECT statement

SELECT IPF3.DocEntry AS 'Landed Costs Internal ID', IPF3.LineNum AS 'Row Number', IPF3.Dscription AS 'Summary Description', IPF3.LaCAllcAcc AS 'Landed Costs Alloc. Account', IPF3.CustSum AS 'Customs Summary', IPF3.CustSumFC AS 'Customs Summary FC', IPF3.CustSumSC AS 'Customs Summary SC', IPF3.OpenSum AS 'Open Customs Summary', IPF3.OpenSumFC AS 'Open Customs Summary (FC)', IPF3.OpenSumSC AS 'Open Customs Summary (SC)', IPF3.AccType AS 'Type of Account of Summarized', IPF3.VatGroup AS 'VAT Code', IPF3.CstmVatStk AS 'Is Customs VAT in Stock', IPF3.CCDEntry AS 'CCD Abs. Entry' FROM IPF3 AS IPF3

Related information


Landed Costs OIPF 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