|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Transportation Document - History
Table Name: ATRO
Table Description: Transportation Document - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| NextNum | Consecutive Number | Int | 11 | - | Â | Â | Â |
| PostDate | Posting Date | Date | 8 | - | Â | Â | Â |
| EDocGenTyp | El. Doc. Gen. Type | VarChar | 1 | - | N | N | Not Relevant |
| Â | Â | Â | Â | Â | Â | G | Generate |
| Â | Â | Â | Â | Â | Â | L | Generate Later |
| EDocExpFrm | Electronic Doc. Export Format | Int | 11 | - | Â | Â | Â |
| TranspNum | Transportation Number | nVarChar | 100 | - | Â | Â | Â |
| Expiration | Expiration Date | Date | 8 | - | Â | Â | Â |
| Vehicle | Vehicle ID | nVarChar | 10 | - | Â | Â | Â |
| TrailerID | Trailer ID | nVarChar | 10 | - | Â | Â | Â |
| Carrier | Carrier Code | nVarChar | 15 | - | Â | Â | Â |
| IssueGate | Issue Gate | Int | 11 | - | 0 | Â | Â |
| AtcEntry | Attachment Entry | Int | 11 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| CreateDate | Production Date | Date | 8 | - | Â | Â | Â |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| CANCELED | Canceled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Weight | Weight | Num | 19.6 | - | Â | Â | Â |
| WghtUnit | Unit of Weight | Int | 6 | - | Â | Â | Â |
| TotalLC | Row Total | Num | 19.6 | - | Â | Â | Â |
| WhsCode | Warehouse Code | nVarChar | 8 | - | Â | Â | Â |
| COTcode | COT Code | nVarChar | 3 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |
| NEXT_NUM_U | Yes | NextNum |
| Â | Â | WhsCode |
| Â | Â | IssueGate |
| Â | Â | LogInstanc |