biuan SAP® BUSINESS ONE SDK
API AMR3
AMR3 - Inventory Revaluation SNB Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11
PRIMARYYes
BaseLineBase Row NumberInt
11
LineNumRow NumberInt
11
SNBNumSerial and Batch NumbernVarChar
36
AdmisDateAdmission DateDate
8
ExpiryDateExpiration DateDate
8
CurrCostCurrent CostNum
20
NewCostNew CostNum
20
DebCredDebit Credit ValueNum
20
SNBOpenQtySNB Open QuantityNum
20
RToStockReval. Amount Posted to
Stock
Num
20
SnbSysNumSNB System NumberInt
11
SnbAbsEntSNB Abs. EntryInt
11
SnbQtySNB QuantityNum
20
SnbCostTSNB Cost TotalNum
20
SnbLotNumSNB Lot NumbernVarChar
36
SnbMfnSNB Manufacture AttributenVarChar
36

SELECT statement

SELECT AMR3.DocEntry AS 'Document Internal ID', AMR3.BaseLine AS 'Base Row Number', AMR3.LineNum AS 'Row Number', AMR3.SNBNum AS 'Serial and Batch Number', AMR3.AdmisDate AS 'Admission Date', AMR3.ExpiryDate AS 'Expiration Date', AMR3.CurrCost AS 'Current Cost', AMR3.NewCost AS 'New Cost', AMR3.DebCred AS 'Debit Credit Value', AMR3.SNBOpenQty AS 'SNB Open Quantity', AMR3.RToStock AS 'Reval. Amount Posted to Stock', AMR3.SnbSysNum AS 'SNB System Number', AMR3.SnbAbsEnt AS 'SNB Abs. Entry', AMR3.SnbQty AS 'SNB Quantity', AMR3.SnbCostT AS 'SNB Cost Total', AMR3.SnbLotNum AS 'SNB Lot Number', AMR3.SnbMfn AS 'SNB Manufacture Attribute' FROM AMR3 AS AMR3

Related information




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