|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Loading Expenses
Table Name: OALC
Table Description: Loading Expenses
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AlcCode | Code | nVarChar | 2 | - | Â | Â | Â |
| AlcName | Name | nVarChar | 30 | - | Â | Â | Â |
| OhType | Allocation By | VarChar | 1 | - | F | F | Cash Value Before Customs |
| Â | Â | Â | Â | Â | Â | C | Cash Value After Customs |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | A | Equal |
| Â | Â | Â | Â | Â | Â | L | Legal Cost |
| AcctCode | Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| 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 | Data Doc. |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| LaCAllcAcc | Landed Costs Alloc. Account | nVarChar | 15 | - | Â | Â | Â |
| CostCateg | Cost Category | VarChar | 1 | - | Â | V | Customs VAT |
| Â | Â | Â | Â | Â | Â | E | Excise Cost |
| Â | Â | Â | Â | Â | Â | D | Customs Duty |
| Key | Unique | Field |
| PRIMARY | Yes | AlcCode |
| GROUP_NAME | No | AlcName |