|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Landed Costs - Costs
Table Name: IPF2
Table Description: Landed Costs - Costs
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Landed Costs Internal ID | Int | 11 | OIPF | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| AlcCode | Cost Code | nVarChar | 2 | OALC | Â | Â | Â |
| OhType | Load by | VarChar | 1 | - | Â | F | Cash Value Before Customs |
| Â | Â | Â | Â | Â | Â | C | Cash Value After Customs |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| Â | Â | Â | Â | Â | Â | W | Weight |
| Â | Â | Â | Â | Â | Â | V | Volume |
| Â | Â | Â | Â | Â | Â | A | Equal |
| Â | Â | Â | Â | Â | Â | L | Legal Cost |
| CostSum | Total Costs | Num | 19.6 | - | Â | Â | Â |
| CostSumFC | Total Costs (FC) | Num | 19.6 | - | Â | Â | Â |
| Factor | Factor | Num | 19.6 | - | Â | Â | Â |
| CostType | Cost Type | VarChar | 1 | - | F | F | Fixed Costs |
| Â | Â | Â | Â | Â | Â | V | Variable Costs |
| Â | Â | Â | Â | Â | Â | L | Legal Costs |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LaCAllcAcc | Landed Costs Alloc. Account | nVarChar | 15 | - | Â | Â | Â |
| CostSumSC | Total Costs (SC) | Num | 19.6 | - | Â | Â | Â |
| InCustCalc | Included in Customs Calc | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| OpenCost | Open Costs | Num | 19.6 | - | Â | Â | Â |
| OpenCostFC | Open Costs (FC) | Num | 19.6 | - | Â | Â | Â |
| OpenCostSC | Open Costs (SC) | Num | 19.6 | - | Â | Â | Â |
| AgentCode | Subst. Code | nVarChar | 15 | - | Â | Â | Â |
| AgentName | Subst. Name | nVarChar | 100 | - | Â | Â | Â |
| CostCateg | Cost Category | VarChar | 1 | - | Â | V | Customs VAT |
| Â | Â | Â | Â | Â | Â | E | Excise Cost |
| Â | Â | Â | Â | Â | Â | D | Customs Duty |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | AlcCode |
| Â | Â | CostType |
| NUM | No | DocEntry |
| Â | Â | LineNum |