|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Transition
Table Name: OTRA
Table Description: Transition
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| BaseDocNum | Base Document Number | Int | 11 | - | Â | Â | Â |
| Printed | Printed | VarChar | 1 | - | N | Y | Copy |
| Â | Â | Â | Â | Â | Â | N | Original |
| ObjType | Object Type | nVarChar | 20 | ADP1 | Â | Â | Â |
| DocDate | Posting Date | Date | 8 | - | Â | Â | Â |
| DocDueDate | Due Date | Date | 8 | - | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | OCRD | Â | Â | Â |
| CardName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| FreZoneNum | ID Number | nVarChar | 8 | - | Â | Â | Â |
| Shiper | Sender | nVarChar | 100 | - | Â | Â | Â |
| Address | Address | nVarChar | 254 | - | Â | Â | Â |
| FromCntry | Country/Region - Origin | nVarChar | 100 | - | Â | Â | Â |
| ToCntry | Country/Region - Destination | nVarChar | 100 | - | Â | Â | Â |
| FromPort | Origin Port | nVarChar | 100 | - | Â | Â | Â |
| ToPort | Destination Port | nVarChar | 100 | - | Â | Â | Â |
| AirPlane | Ship/Aircraft | nVarChar | 50 | - | Â | Â | Â |
| AirPlanNum | No. of Ships/Aircraft | nVarChar | 40 | - | Â | Â | Â |
| TotalFob | Total | Num | 19.6 | - | Â | Â | Â |
| Taxes | Taxes | Num | 19.6 | - | Â | Â | Â |
| Insurance | Insurance | Num | 19.6 | - | Â | Â | Â |
| Others | Other | Num | 19.6 | - | Â | Â | Â |
| TotalCif | Document Total | Num | 19.6 | - | Â | Â | Â |
| Ref1 | Reference 1 | nVarChar | 11 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 11 | - | Â | Â | Â |
| Comments | Remarks | nVarChar | 254 | - | Â | Â | Â |
| GroupNum | Payment Terms Code | Int | 6 | OCTG | Â | Â | Â |
| DocTime | Document Time | Int | 6 | - | Â | Â | Â |
| SlpCode | Sales Employee | Int | 11 | OSLP | -1 | Â | Â |
| TrnspCode | Delivery Code | Int | 6 | OSHP | -1 | Â | Â |
| PartSupply | Partial Delivery | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ImportEnt | Landed Costs | Int | 11 | OIPF | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| NumForPrn | Base Doc. No. for Printing | nVarChar | 16 | - | Â | Â | Â |
| PurPackMsr | Packaging UoM Name | nVarChar | 8 | - | Â | Â | Â |
| Series | Series | Int | 11 | - | Â | Â | Â |
| BaseDocObj | Base Document Object Type | Int | 6 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| NUM | No | DocNum |
| BASE_DOC | No | BaseDocNum |
| Â | Â | BaseDocObj |
| OBJECT | No | ObjType |
| SERIES | No | Series |