|
|
API ATXI
ATXI - Tax Invoice - History Table
Business Place OBPL SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Object Settings - History ADP1 SQL Table
Period Indicator OPID SQL Table
Journal Entry OJDT SQL Table
Delivery Types OSHP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| DocType | Document Type | VarChar | I) Invoice P) Payment J) Journal Entry C) Correction Invoice D) Down Payment A) Alteration Invoice B) Alteration Correction Invoice | 1 | I | |||
| CANCELED | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| HandWriten | Manual Numbering | VarChar | Y) Yes N) No | 1 | N | |||
| Printed | Printed | VarChar | Y) Yes N) No | 1 | N | |||
| Transfered | Year Transfer | VarChar | Y) Yes N) No | 1 | N | |||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 194 | |||
| DocDate | Posting Date | Date | 8 | |||||
| CardCode | Customer Code | nVarChar | 15 | OCRD Business Partner | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| Series | Series | Int | 6 | 0 | ||||
| Segment | Segment | Int | 6 | 0 | ||||
| CntctCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| VatDate | Document Date | Date | 8 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| TrnspCode | Shipping Type | Int | 6 | OSHP Delivery Types | -1 | |||
| ShipToCode | Ship-to Code | nVarChar | 50 | |||||
| Address | Bill to | nVarChar | 127 | |||||
| Address2 | Ship To | nVarChar | 127 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| CurSource | Base Currency | VarChar | L) Local Currency S) System Currency C) BP Currency | 1 | C | |||
| DocCur | Document Currency | nVarChar | 3 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| NumAtCard | BP Reference No. | nVarChar | 100 | |||||
| CardName | Customer/Vendor Name | nVarChar | 100 | |||||
| CancelDate | Cancel Date | Date | 8 | |||||
| DocTotal | Document Total | Num | 20 | |||||
| VatSum | Total Tax | Num | 20 | |||||
| PayRefNo | Payment Ref. No. | nVarChar | 16 | |||||
| PayRefDate | Payment Ref. Date | Date | 8 | |||||
| TaxMethod | Taxation Method | VarChar | S) On Shipment P) On Payment | 1 | S | |||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| IsDpm | IS Down Payment | VarChar | Y) Yes N) No | 1 | N | |||
| AltRev | Alteration Revision | Int | 11 | 0 | ||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| JrnlMemo | Journal Remark | nVarChar | 50 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VATRegNum | Branch Reg. No. | nVarChar | 32 |
Table relationship map
SELECT statement
SELECT
ATXI.DocEntry AS 'Internal Number',
ATXI.DocNum AS 'Document Number',
ATXI.DocType AS 'Document Type',
ATXI.CANCELED AS 'Canceled',
ATXI.HandWriten AS 'Manual Numbering',
ATXI.Printed AS 'Printed',
ATXI.Transfered AS 'Year Transfer',
ATXI.ObjType AS 'Object Type',
ATXI.DocDate AS 'Posting Date',
ATXI.CardCode AS 'Customer Code',
ATXI.CreateDate AS 'Creation Date',
ATXI.UpdateDate AS 'Date of Update',
ATXI.DocDueDate AS 'Due Date',
ATXI.Series AS 'Series',
ATXI.Segment AS 'Segment',
ATXI.CntctCode AS 'Contact Person',
ATXI.VatDate AS 'Document Date',
ATXI.Comments AS 'Remarks',
ATXI.TrnspCode AS 'Shipping Type',
ATXI.ShipToCode AS 'Ship-to Code',
ATXI.Address AS 'Bill to',
ATXI.Address2 AS 'Ship To',
ATXI.LogInstanc AS 'Log Instance',
ATXI.CurSource AS 'Base Currency',
ATXI.DocCur AS 'Document Currency',
ATXI.UserSign AS 'User Signature',
ATXI.UserSign2 AS 'Updating User',
ATXI.NumAtCard AS 'BP Reference No.',
ATXI.CardName AS 'Customer/Vendor Name',
ATXI.CancelDate AS 'Cancel Date',
ATXI.DocTotal AS 'Document Total',
ATXI.VatSum AS 'Total Tax',
ATXI.PayRefNo AS 'Payment Ref. No.',
ATXI.PayRefDate AS 'Payment Ref. Date',
ATXI.TaxMethod AS 'Taxation Method',
ATXI.AtcEntry AS 'Attachment Entry',
ATXI.IsDpm AS 'IS Down Payment',
ATXI.AltRev AS 'Alteration Revision',
ATXI.PIndicator AS 'Period Indicator',
ATXI.TransId AS 'Transaction Number',
ATXI.JrnlMemo AS 'Journal Remark',
ATXI.BPLId AS 'Branch',
ATXI.BPLName AS 'Branch Name',
ATXI.VATRegNum AS 'Branch Reg. No.'
FROM ATXI AS ATXI
Related information
Business Place OBPL SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Object Settings - History ADP1 SQL Table
Period Indicator OPID SQL Table
Journal Entry OJDT SQL Table
Delivery Types OSHP 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