|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Tax Invoice - History
Table Name: ATXI
Table Description: Tax Invoice - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocType | Document Type | VarChar | 1 | - | I | I | Invoice |
| Â | Â | Â | Â | Â | Â | P | Payment |
| Â | Â | Â | Â | Â | Â | J | Journal Entry |
| Â | Â | Â | Â | Â | Â | C | Correction Invoice |
| Â | Â | Â | Â | Â | Â | D | Down Payment |
| Â | Â | Â | Â | Â | Â | A | Alteration Invoice |
| Â | Â | Â | Â | Â | Â | B | Alteration Correction Invoice |
| CANCELED | Canceled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| HandWriten | Manual Numbering | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Printed | Printed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Transfered | Year Transfer | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 194 | Â | Â |
| DocDate | Posting Date | Date | 8 | - | Â | Â | Â |
| CardCode | Customer Code | nVarChar | 15 | OCRD | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| DocDueDate | Due Date | Date | 8 | - | Â | Â | Â |
| Series | Series | Int | 11 | - | 0 | Â | Â |
| Segment | Segment | Int | 6 | - | 0 | Â | Â |
| CntctCode | Contact Person | Int | 11 | OCPR | Â | Â | Â |
| VatDate | Document Date | Date | 8 | - | Â | Â | Â |
| Comments | Remarks | nVarChar | 254 | - | Â | Â | Â |
| TrnspCode | Shipping Type | Int | 6 | OSHP | -1 | Â | Â |
| ShipToCode | Ship-to Code | nVarChar | 50 | - | Â | Â | Â |
| Address | Bill To | nVarChar | 254 | - | Â | Â | Â |
| Address2 | Ship To | nVarChar | 254 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CurSource | Base Currency | VarChar | 1 | - | C | L | Local Currency |
| Â | Â | Â | Â | Â | Â | S | System Currency |
| Â | Â | Â | Â | Â | Â | C | BP Currency |
| DocCur | Document Currency | nVarChar | 3 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| NumAtCard | BP Reference No. | nVarChar | 200 | - | Â | Â | Â |
| CardName | Customer/Vendor Name | nVarChar | 200 | - | Â | Â | Â |
| CancelDate | Cancel Date | Date | 8 | - | Â | Â | Â |
| DocTotal | Document Total | Num | 19.6 | - | Â | Â | Â |
| VatSum | Total Tax | Num | 19.6 | - | Â | Â | Â |
| PayRefNo | Payment Ref. No. | nVarChar | 16 | - | Â | Â | Â |
| PayRefDate | Payment Ref. Date | Date | 8 | - | Â | Â | Â |
| TaxMethod | Taxation Method | VarChar | 1 | - | S | S | On Shipment |
| Â | Â | Â | Â | Â | Â | P | On Payment |
| AtcEntry | Attachment Entry | Int | 11 | - | Â | Â | Â |
| IsDpm | IS Down Payment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AltRev | Alteration Revision | Int | 11 | - | 0 | Â | Â |
| PIndicator | Period Indicator | nVarChar | 10 | OPID | Â | Â | Â |
| TransId | Transaction Number | Int | 11 | OJDT | Â | Â | Â |
| JrnlMemo | Journal Remark | nVarChar | 254 | - | Â | Â | Â |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| BPLName | Branch Name | nVarChar | 200 | - | Â | Â | Â |
| VATRegNum | Branch Reg. No. | nVarChar | 32 | - | Â | Â | Â |
| GovContrID | Gov. Contract ID | nVarChar | 254 | - | Â | Â | Â |
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | D | Erased |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LogInstanc |
| Â | Â | ObjType |
| NUM | Yes | DocNum |
| Â | Â | AltRev |
| Â | Â | LogInstanc |
| Â | Â | ObjType |
| Â | Â | PIndicator |
| Â | Â | Series |