|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Project Management - Stages - Documents - History
Table Name: APM4
Table Description: Project Management - Stages - Documents - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | PMG1 | Â | Â | Â |
| LineID | Row No. | Int | 11 | - | Â | Â | Â |
| StageID | Stage ID | Int | 11 | - | Â | Â | Â |
| TYP | Document Type | Int | 11 | - | -1 | -1 | Please select |
| Â | Â | Â | Â | Â | Â | 112 | Document Draft |
| Â | Â | Â | Â | Â | Â | 30 | Manual Journal Entry |
| Â | Â | Â | Â | Â | Â | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 15 | Delivery |
| Â | Â | Â | Â | Â | Â | 16 | Return |
| Â | Â | Â | Â | Â | Â | 203002 | A/R Down Payment Request |
| Â | Â | Â | Â | Â | Â | 203 | A/R Down Payment Invoice |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 13002 | A/R Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 540000006 | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 21 | Goods Return |
| Â | Â | Â | Â | Â | Â | 204002 | A/P Down Payment Request |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment Invoice |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 18002 | A/P Reserve Invoice |
| Â | Â | Â | Â | Â | Â | 191 | Service Call |
| Â | Â | Â | Â | Â | Â | 59 | Goods Receipt |
| Â | Â | Â | Â | Â | Â | 60 | Goods Issue |
| Â | Â | Â | Â | Â | Â | 165 | A/R Correction Invoice |
| Â | Â | Â | Â | Â | Â | 166 | A/R Correction Invoice Reversal |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Invoice |
| Â | Â | Â | Â | Â | Â | 164 | A/P Correction Invoice Reversal |
| Â | Â | Â | Â | Â | Â | 1470000113 | Purchase Request |
| Â | Â | Â | Â | Â | Â | 234000032 | Goods Return Request |
| Â | Â | Â | Â | Â | Â | 234000031 | Return Request |
| DOCNUM | Document Number | Int | 11 | - | Â | Â | Â |
| DocEntry | Document Abs. Entry | Int | 11 | - | Â | Â | Â |
| DocDate | Document Date | Date | 8 | - | Â | Â | Â |
| Total | Total | Num | 19.6 | - | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| Status | Line status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| AmountCat | Category to which we will apply the amount from Total | VarChar | 1 | - | Â | I | Invoiced |
| Â | Â | Â | Â | Â | Â | O | Open |
| Categorize | Category Open Amount/Invoiced A/R, A/P to which we will apply the amount from journal entry | nVarChar | 2 | - | Â | Â | Ignore |
| Â | Â | Â | Â | Â | Â | OP | Open Amount (A/P) |
| Â | Â | Â | Â | Â | Â | OR | Open Amount (A/R) |
| Â | Â | Â | Â | Â | Â | IP | Invoiced (A/P) |
| Â | Â | Â | Â | Â | Â | IR | Invoiced (A/R) |
| Operation | Operation which we will apply to the amount from the total | VarChar | 1 | - | Â | Â | Ignore |
| Â | Â | Â | Â | Â | Â | A | Add |
| Â | Â | Â | Â | Â | Â | S | Subtract |
| Chargeable | Chargeable [Yes/No] | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Charged | Charged | Num | 19.6 | - | Â | Â | Â |
| ChargedQty | Charged Quantity | Num | 19.6 | - | Â | Â | Â |
| DocType | Document Type | VarChar | 1 | - | I | I | Item |
| Â | Â | Â | Â | Â | Â | S | Service |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| PartTotal | Partially Invoiced Total | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineID |
| Â | Â | LogInstanc |