|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Correction Invoice - E-Books(GR) Rows
Table Name: CIN27
Table Description: Correction Invoice - E-Books(GR) Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OCIN | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| RelateType | Relation Type | Int | 11 | - | -1 | 1 | Row |
| Â | Â | Â | Â | Â | Â | 2 | Row Expenses |
| Â | Â | Â | Â | Â | Â | 3 | Document Expenses |
| Â | Â | Â | Â | Â | Â | 13 | Distributed Freights |
| Â | Â | Â | Â | Â | Â | -1 | Manual |
| RelateLine | Relation Row Number | Int | 11 | - | -1 | Â | Â |
| GroupNum | Group Number | Int | 11 | - | -1 | Â | Â |
| LineTotal | Line Total | Num | 19.6 | - | Â | Â | Â |
| LineTotalF | Line Total (FC) | Num | 19.6 | - | Â | Â | Â |
| LineTotalS | Line Total (SC) | Num | 19.6 | - | Â | Â | Â |
| InClassTyp | Income Classification Type | Int | 11 | OICP | Â | Â | Â |
| InClassCat | Income Classification Category | Int | 11 | OICC | Â | Â | Â |
| ExClassTyp | Expense Classification Type | Int | 11 | OECP | Â | Â | Â |
| ExClassCat | Expense Classification Cat. | Int | 11 | OECC | Â | Â | Â |
| VatCate | VAT Category | Int | 11 | - | Â | Â | Â |
| NetValue | Net Value | Num | 19.6 | - | Â | Â | Â |
| NetValueFC | Net Value (FC) | Num | 19.6 | - | Â | Â | Â |
| NetValueSC | Net Value (SC) | Num | 19.6 | - | Â | Â | Â |
| VatAmount | VAT Amount | Num | 19.6 | - | Â | Â | Â |
| VatAmFC | VAT Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| VatAmSC | VAT Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| WtPercCat | Withheld Percentage Category | Int | 11 | - | Â | Â | Â |
| WtAmount | Withheld Amount | Num | 19.6 | - | Â | Â | Â |
| WtAmountFC | Withheld Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| WtAmountSC | Withheld Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | ADP1 | 132 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| WtCategory | Withheld Category | VarChar | 1 | - | Â | I | Invoice |
| Â | Â | Â | Â | Â | Â | P | Payment |
| VATClassTy | VAT Classification Type | Int | 11 | OECP | Â | Â | Â |
| VATClassCa | VAT Classification Category | Int | 11 | OECC | Â | Â | Â |
| EBVatExCau | VAT Exemption Cause | Int | 11 | OVEC | Â | Â | Â |
| RecType | Rec Type | Int | 11 | OREC | Â | Â | Â |
| StampDutyC | Stamp Duty Categgory | Int | 11 | OSDC | Â | Â | Â |
| OtherTaxCt | Other Tax Category | Int | 11 | OEOT | Â | Â | Â |
| FeesCtegr | Fees Category | Int | 11 | OEFC | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| RELATE_ROW | No | DocEntry |
| Â | Â | RelateType |
| Â | Â | RelateLine |
| Â | Â | GroupNum |