biuan SAP® BUSINESS ONE SDK
API INV22
INV22 - A/R Invoice - Resource Costs Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11INV1
A/R Invoice - Rows
PRIMARYYes
LineNumRow NumberInt
11INV1
A/R Invoice - Rows
StdCostNumResource Standard Cost NumberInt
11
PricePriceNum
20
TotalTotalNum
20
ObjectTypeObject TypenVarChar
20
13
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT INV22.DocEntry AS 'Document Internal ID', INV22.LineNum AS 'Row Number', INV22.StdCostNum AS 'Resource Standard Cost Number', INV22.Price AS 'Price', INV22.Total AS 'Total', INV22.ObjectType AS 'Object Type', INV22.LogInstanc AS 'Log Instance' FROM INV22 AS INV22

Related information


A/R Invoice - Rows INV1 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