|
|
SAP Business One SDK 10.0 - Database Tables Reference |
RAMI
Table Name: RAMI
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ErrUID | Error Message Unique ID | nVarChar | 11 | - | Â | Â | Â |
| StrlNum | String List Number | Int | 11 | - | Â | Â | Â |
| StrIdx | String Index | Int | 11 | - | Â | Â | Â |
| GuidStr | GUID String | nVarChar | 32 | - | 3A51AF1A405C41479530D05FF95A3FBA | Â | Â |
| MsgDef | Message Define | nVarChar | 100 | - | Â | Â | Â |
| MsgType | Message Type | VarChar | 1 | - | E | E | Error |
| Â | Â | Â | Â | Â | Â | W | Warning |
| Â | Â | Â | Â | Â | Â | N | Info |
| Â | Â | Â | Â | Â | Â | S | Success |
| Â | Â | Â | Â | Â | Â | O | None |
| MsgArea | Message Area | nVarChar | 20 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | AP_AR | Sales and Purchurse orders |
| Â | Â | Â | Â | Â | Â | RPT | Reports |
| Â | Â | Â | Â | Â | Â | PROD | Production |
| Â | Â | Â | Â | Â | Â | LGST | ItemMasterData |
| Â | Â | Â | Â | Â | Â | INVT | Inventory |
| Â | Â | Â | Â | Â | Â | FIN | Financial |
| Â | Â | Â | Â | Â | Â | BANK | Banking |
| Â | Â | Â | Â | Â | Â | CARD | BP Master Data |
| Â | Â | Â | Â | Â | Â | AUTH | Authorization |
| Â | Â | Â | Â | Â | Â | ADMIN | Administration |
| Â | Â | Â | Â | Â | Â | SDK | SDK UI |
| Â | Â | Â | Â | Â | Â | LCNS | License |
| Â | Â | Â | Â | Â | Â | ADDON | Add-On manager |
| Â | Â | Â | Â | Â | Â | FORM | Form Infrastructure |
| Â | Â | Â | Â | Â | Â | DB | DB Infrastructure |
| Â | Â | Â | Â | Â | Â | CORE | Core Layer |
| Â | Â | Â | Â | Â | Â | INST | Installation and Upgrade |
| ScnExp | Scenarion Explanation | Text | 16 | - | Â | Â | Â |
| ObjName | Object Name | nVarChar | 20 | - | Â | Â | Â |
| SonTable | Son Table | nVarChar | 20 | - | Â | Â | Â |
| Alias | Alias | nVarChar | 10 | - | Â | Â | Â |
| FormID | Form ID | Int | 11 | - | Â | Â | Â |
| PaneID | Pane Id | Int | 6 | - | 0 | Â | Â |
| ItemID | Item ID | Int | 11 | - | -1 | Â | Â |
| CreateDate | Creation date | Date | 8 | - | Â | Â | Â |
| CreateTime | Creation Time | Int | 6 | - | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 6 | - | Â | Â | Â |
| UserSign | User Sign | Int | 11 | - | Â | Â | Â |
| SolExp | Solution Explanation | Text | 16 | - | Â | Â | Â |
| CsnId | CSN Note Id | nVarChar | 30 | - | Â | Â | Â |
| DispType | Display Type | nVarChar | 30 | - | SBAR | SBAR | Sbar |
| Â | Â | Â | Â | Â | Â | NOTE | Note |
| Â | Â | Â | Â | Â | Â | DIALOG_OKCancelType | Dialog OK Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_YesNoCancelType | Dialog Yes No Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_YesNoType | Dialog Yes No |
| Â | Â | Â | Â | Â | Â | DIALOG_YesAllNoAllCancelType | Dialog Yes All No All Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_ErrorOkType | Dialog Error Ok |
| Â | Â | Â | Â | Â | Â | DIALOG_ContinueSaveType | Dialog Continue Save |
| Â | Â | Â | Â | Â | Â | DIALOG_RemoveCancelType | Dialog Remove Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_ContinueCancelType | Dialog Continue Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_ContinueCancelNoType | Dialog Continue Cancel No |
| Â | Â | Â | Â | Â | Â | DIALOG_AddCancelType | Dialog Add Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_ContinueStopType | Dialog Continue Stop |
| Â | Â | Â | Â | Â | Â | DIALOG_YesCancelType | Dialog Yes Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_ContinueOpenType | Dialog Continue Open |
| Â | Â | Â | Â | Â | Â | DIALOG_OpenContinueCancelType | Dialog Open Continue Cancel |
| Â | Â | Â | Â | Â | Â | DIALOG_YesYesAllNoType | Dialog Yes Yes All No |
| Â | Â | Â | Â | Â | Â | DIALOG_YesYesAllNoAllType | Dialog Yes Yes All No All |
| ColmID | Column ID | Int | 11 | - | -1 | Â | Â |
| IsDeleted | Is Deleted | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Key | Unique | Field |
| PRIMARY | Yes | ErrUID |
| GUID | No | GuidStr |
| CodeDefine | Yes | MsgDef |
| String | Yes | StrlNum |
| Â | Â | StrIdx |
| ObjectId | No | ObjName |
| Â | Â | SonTable |
| Â | Â | Alias |