|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Checks for Payment - Rows - History
Table Name: ACH1
Table Description: Checks for Payment - Rows - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CheckKey | SBO Internal Key | Int | 11 | OCHO | Â | Â | Â |
| LineId | Row Number | Int | 11 | - | Â | Â | Â |
| LineDitail | Row Details | nVarChar | 40 | - | Â | Â | Â |
| LineMoney | Row Total | Num | 19.6 | - | Â | Â | Â |
| LineCurr | Row Currency | nVarChar | 3 | - | Â | Â | Â |
| LineAcct | Row G/L Acct | nVarChar | 15 | - | Â | Â | Â |
| Line_A_C | G/L Acct/BP Code | VarChar | 1 | - | 0 | Â | Â |
| Code | Tax Definition | nVarChar | 8 | OVTG | Â | Â | Â |
| CredAcct | Credited Account | nVarChar | 15 | OACT | Â | Â | Â |
| TotalLine | Row Total | Num | 19.6 | - | Â | Â | Â |
| VatPercent | Tax %: | Num | 19.6 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | ADP1 | 57 | Â | Â |
| LineMnyLC | Row Total (LC) | Num | 19.6 | - | Â | Â | Â |
| LineMnySC | Row Total (SC) | Num | 19.6 | - | Â | Â | Â |
| LineMnyFC | Row Total (FC) | Num | 19.6 | - | Â | Â | Â |
| TotLineLC | Row Total (LC) | Num | 19.6 | - | Â | Â | Â |
| TotLineSC | Row Total (SC) | Num | 19.6 | - | Â | Â | Â |
| TotLineFC | Row Total (FC) | Num | 19.6 | - | Â | Â | Â |
| UserSign2 | Updating User - History | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update - History | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CheckKey |
| Â | Â | LineId |
| Â | Â | LogInstanc |