|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Input Service Distribution - Invoice Lines
Table Name: ASI1
Table Description: Input Service Distribution - Invoice Lines
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OISI | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| SourceType | Source Document Type | Int | 11 | - | Â | 18 | GST Tax Invoice |
| Â | Â | Â | Â | Â | Â | 19 | GST Credit Memo |
| Â | Â | Â | Â | Â | Â | -18 | GST Debit Memo |
| SourceNo | Source Document No. | Int | 11 | - | Â | Â | Â |
| SrcEntry | Source Document Entry | Int | 11 | - | Â | Â | Â |
| SrcStaType | Source GST Tax Type | Int | 11 | - | Â | -100 | CGST |
| Â | Â | Â | Â | Â | Â | -110 | SGST |
| Â | Â | Â | Â | Â | Â | -120 | IGST |
| Â | Â | Â | Â | Â | Â | -130 | Cess GST |
| Â | Â | Â | Â | Â | Â | -150 | UTGST |
| SrcTaxAcct | Source Tax Account | nVarChar | 15 | - | Â | Â | Â |
| SACEntry | SAC Entry | Int | 11 | - | Â | Â | Â |
| TarStaType | Target GST Tax Type | Int | 11 | - | Â | -100 | CGST |
| Â | Â | Â | Â | Â | Â | -110 | SGST |
| Â | Â | Â | Â | Â | Â | -120 | IGST |
| Â | Â | Â | Â | Â | Â | -130 | Cess GST |
| Â | Â | Â | Â | Â | Â | -150 | UTGST |
| TarTaxAcct | Target Tax Account | nVarChar | 15 | - | Â | Â | Â |
| DistAmnt | Credit Amount to Distribute | Num | 19.6 | - | Â | Â | Â |
| SrcSubType | Source Document Subtype | nVarChar | 2 | - | Â | Â | Â |
| ITCType | ITC Type | VarChar | 1 | - | E | E | Eligible |
| Â | Â | Â | Â | Â | Â | I | Ineligible |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |