|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Amout Differences Report Lines
Table Name: AMD1
Table Description: Amout Differences Report Lines
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| LineNum | Internal ID | Int | 11 | - | Â | Â | Â |
| PmnNum | Payment Number | Int | 11 | ORCT | Â | Â | Â |
| PmnInvID | Invoice Seq. No. in Payment | Int | 11 | - | Â | Â | Â |
| PmnDate | Payment Date | Date | 8 | - | Â | Â | Â |
| CardCode | BP Code | nVarChar | 15 | OCRD | Â | Â | Â |
| InvType | Invoice Category | nVarChar | 20 | - | 13 | 13 | Sales Invoice |
| InvEntry | Invoice Key | Int | 11 | OINV | Â | Â | Â |
| InstId | Installment ID | Int | 6 | - | Â | Â | Â |
| InvTransID | Invoice Transaction Number | Int | 11 | OJDT | Â | Â | Â |
| FCCurrency | Foreign Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| InvRate | Rate, Invoice | Num | 19.6 | - | Â | Â | Â |
| PmnRate | Rate, Payment | Num | 19.6 | - | Â | Â | Â |
| Approved | Confirmed | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AmountDiff | Amount Difference (LC) | Num | 19.6 | - | Â | Â | Â |
| TaxAmtDiff | Tax Difference (LC) | Num | 19.6 | - | Â | Â | Â |
| TMP_JE | Temporary Transaction ID | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | LineNum |
| Â | Â | PmnNum |
| Â | Â | PmnInvID |