|
|
API AIQI
AIQI - Inventory Opening Balance Table
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Inventory Opening Balance Draft OIOD 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 Acct | 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 | |||||
| Reference2 | Reference 2 | nVarChar | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | 310000001 | ||||
| DocNum | Document Number | Int | 11 | |||||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PriceSrc | Price Source | VarChar | 1) By Price List 2) Last Evaluated Price 3) Item Cost | 1 | 3 | |||
| PriceList | Price List | Int | 11 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| TaxDate | Document Date | Date | 8 | |||||
| Status | Status | VarChar | O) Open C) Close | 1 | O | |||
| LogIns | Log Instance - History | Int | 11 | |||||
| UserSign2 | Update User - History | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update - History | Date | 8 | |||||
| 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 | OIOD Inventory Opening Balance 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 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | ' ' | ||||
| FinncPriod | Posting Period | Int | 11 |
Table relationship map
SELECT statement
SELECT
AIQI.DocEntry AS 'Document Internal ID',
AIQI.CreateDate AS 'Creation Date',
AIQI.DocTime AS 'Generation Time',
AIQI.IOffIncAcc AS 'Inventory Offset Increase Acct',
AIQI.DOffDecAcc AS 'Inventory Offset Decrease Acct',
AIQI.DocDate AS 'Posting Date',
AIQI.Reference AS 'Reference',
AIQI.Comments AS 'Remarks',
AIQI.DocDueDate AS 'Due Date',
AIQI.DataSource AS 'Data Source',
AIQI.UserSign AS 'User Signature',
AIQI.VersionNum AS 'Version Number',
AIQI.JdtNum AS 'Journal Number',
AIQI.Reference2 AS 'Reference 2',
AIQI.ObjType AS 'Object Type',
AIQI.DocNum AS 'Document Number',
AIQI.Series AS 'Series',
AIQI.PriceSrc AS 'Price Source',
AIQI.PriceList AS 'Price List',
AIQI.JrnlMemo AS 'Journal Remarks',
AIQI.TaxDate AS 'Document Date',
AIQI.Status AS 'Status',
AIQI.LogIns AS 'Log Instance - History',
AIQI.UserSign2 AS 'Update User - History',
AIQI.UpdateDate AS 'Date of Update - History',
AIQI.WddStatus AS 'Authorization Status',
AIQI.DraftKey AS 'Draft Document Internal ID',
AIQI.Printed AS 'Printed',
AIQI.DocTotal AS 'Document Total',
AIQI.BPLId AS 'Branch',
AIQI.BPLName AS 'Branch Name',
AIQI.UpdateTS AS 'Update Full Time',
AIQI.PIndicator AS 'Period Indicator',
AIQI.FinncPriod AS 'Posting Period'
FROM AIQI AS AIQI
Related information
Business Place OBPL SQL Table
G/L Accounts OACT SQL Table
Inventory Opening Balance Draft OIOD SQL Table
Documents Numbering - Series NNM1 SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
