|
|
DTW Inventory Posting
API Inventory Postings Service / Inventory Posting
OIQR - Inventory Posting Table
Inventory Posting InventoryPosting Object· Table: OIQR
Parent: Inventory Postings Service InventoryPostingsService Service· Table: OIQR
Inventory Postings Service InventoryPostingsService Service· Table: OIQR
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Inventory Posting Draft OIPD SQL Table
Posting Period OFPR SQL Table
Journal Entry OJDT SQL Table
Period Indicator OPID SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CreateDate KEY | Creation Date | Date | 8 | CREATEDATE | No | |||
| DocTime | Generation Time | Int | 6 | |||||
| IOffIncAcc | Inventory Offset - Increase Ac | nVarChar | 15 | OACT G/L Accounts | ||||
| DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DocDate KEY | Posting Date | Date | 8 | DOC_DATE | No | |||
| Reference | Reference | nVarChar | 11 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| DataSource | Data Source | VarChar | 1 | N | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| JdtNum | Journal Number | Int | 11 | OJDT Journal Entry | ||||
| Reference2 | Reference 2 | nVarChar | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | 10000071 | ||||
| DocNum | Document Number | Int | 11 | |||||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PriceSrc | Price Source | Int | 1) By Price List 2) Last Evaluated Price 3) Item Cost | 11 | 3 | |||
| PriceList | Price List | Int | 11 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| Status | Status | VarChar | O) Open C) Close | 1 | O | |||
| LogIns | Log Instance - History | Int | 11 | |||||
| UserSign2 | Updating User - History | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update - History | Date | 8 | |||||
| CountDate | Date of Counting | Date | 8 | |||||
| CountTime | Time of Counting | Int | 11 | |||||
| WddStatus | Authorization Status | VarChar | -) Without W) Pending Y) Approved N) Rejected P) Generated A) Generated by Authorizer C) Canceled | 1 | ||||
| DraftKey | Draft Document Internal ID | Int | 11 | OIPD Inventory Posting Draft | -1 | |||
| Printed | Printed | VarChar | 1 | N | ||||
| DocTotal | Document Total | Num | 20 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| UpdateTS | Update Full Time | Int | 11 | |||||
| CopyOption | DI Copy from Option | VarChar | 0 1) Individual 1 2) Individual 2 3) Individual 3 4) Individual 4 5) Individual 5 6) Team Counted Quantity | 1 | 0 | |||
| BaseEntry | Base Counting Doc. Entry | Int | 11 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ' ' | |||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period |
Table relationship map
SELECT statement
SELECT
OIQR.DocEntry AS 'Document Internal ID',
OIQR.CreateDate AS 'Creation Date',
OIQR.DocTime AS 'Generation Time',
OIQR.IOffIncAcc AS 'Inventory Offset - Increase Ac',
OIQR.DOffDecAcc AS 'Inventory Offset Decrease Acct',
OIQR.DocDate AS 'Posting Date',
OIQR.Reference AS 'Reference',
OIQR.Comments AS 'Remarks',
OIQR.DocDueDate AS 'Due Date',
OIQR.DataSource AS 'Data Source',
OIQR.UserSign AS 'User Signature',
OIQR.VersionNum AS 'Version Number',
OIQR.JdtNum AS 'Journal Number',
OIQR.Reference2 AS 'Reference 2',
OIQR.ObjType AS 'Object Type',
OIQR.DocNum AS 'Document Number',
OIQR.Series AS 'Series',
OIQR.PriceSrc AS 'Price Source',
OIQR.PriceList AS 'Price List',
OIQR.JrnlMemo AS 'Journal Remarks',
OIQR.Status AS 'Status',
OIQR.LogIns AS 'Log Instance - History',
OIQR.UserSign2 AS 'Updating User - History',
OIQR.UpdateDate AS 'Date of Update - History',
OIQR.CountDate AS 'Date of Counting',
OIQR.CountTime AS 'Time of Counting',
OIQR.WddStatus AS 'Authorization Status',
OIQR.DraftKey AS 'Draft Document Internal ID',
OIQR.Printed AS 'Printed',
OIQR.DocTotal AS 'Document Total',
OIQR.BPLId AS 'Branch',
OIQR.BPLName AS 'Branch Name',
OIQR.UpdateTS AS 'Update Full Time',
OIQR.CopyOption AS 'DI Copy from Option',
OIQR.BaseEntry AS 'Base Counting Doc. Entry',
OIQR.PIndicator AS 'Period Indicator',
OIQR.FinncPriod AS 'Posting Period'
FROM OIQR AS OIQR
Related information
Inventory Posting InventoryPosting Object· Table: OIQR
If there are differences between the inventory counting results and the item quantities recorded in SAP Business One, you may need to reconcile the quantities so as not to distort your inventory valuation results. For this purpose, use the...
Parent: Inventory Postings Service InventoryPostingsService Service· Table: OIQR Inventory Postings Service InventoryPostingsService Service· Table: OIQR
The InventoryPostingsService service enables you to add, look up, and update inventory posting transactions.
Source table: OIQR.
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Inventory Posting Draft OIPD SQL Table
Posting Period OFPR SQL Table
Journal Entry OJDT SQL Table
Period Indicator OPID SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR SQL Table
InventoryPostingsService
Object
InventoryPosting
Collection
Enumeration
Method
Property
PostingDate
DB
PriceList
DB
PriceSource
DB
Reference2
DB
Remarks
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
