|
|
SAP Business One SDK 10.0 - Database Tables Reference |
A/R Credit Memo - Tax Amount per Document
Table Name: RIN4
Table Description: A/R Credit Memo - Tax Amount per Document
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ORIN | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | -1 | Â | Â |
| GroupNum | Group Number | Int | 11 | - | -1 | Â | Â |
| ExpnsCode | Expense Code | Int | 11 | OEXD | -1 | Â | Â |
| RelateType | Relation Type | Int | 11 | - | 1 | 1 | Row |
| Â | Â | Â | Â | Â | Â | 2 | Row Freight Charges |
| Â | Â | Â | Â | Â | Â | 3 | Document Expenses |
| Â | Â | Â | Â | Â | Â | 13 | Distributed Freights |
| StcCode | Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| StaCode | Authority Code | nVarChar | 8 | OSTA | Â | Â | Â |
| staType | Authority Type | Int | 11 | OSTT | Â | Â | Â |
| TaxRate | Tax Rate | Num | 19.6 | - | Â | Â | Â |
| TaxAcct | Tax Account | nVarChar | 15 | OACT | Â | Â | Â |
| TaxSum | Tax Amount | Num | 19.6 | - | Â | Â | Â |
| TaxSumFrgn | Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| TaxSumSys | Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| BaseSum | Base Amount | Num | 19.6 | - | Â | Â | Â |
| BaseSumFrg | Base Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| BaseSumSys | Base Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | ADP1 | 14 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| TaxStatus | Tax Status | VarChar | 1 | - | Y | Y | Regular Tax |
| Â | Â | Â | Â | Â | Â | N | No Tax |
| Â | Â | Â | Â | Â | Â | U | Use Tax |
| VatApplied | VAT Applied | Num | 19.6 | - | Â | Â | Â |
| VatAppldFC | Applied Tax (FC) | Num | 19.6 | - | Â | Â | Â |
| VatAppldSC | Applied Tax (SC) | Num | 19.6 | - | Â | Â | Â |
| LineSeq | Line Sequence | Int | 11 | - | Â | Â | Â |
| DeferrAcct | Deferred Tax Account | nVarChar | 15 | OACT | Â | Â | Â |
| BaseType | Base Document Type | Int | 11 | - | -1 | Â | Â |
| BaseAbs | Base Doc Abs Entry | Int | 11 | - | -1 | Â | Â |
| BaseSeq | Base Doc. Line Sequence | Int | 11 | - | Â | Â | Â |
| DeductTax | Deductible Tax Amount | Num | 19.6 | - | Â | Â | Â |
| DdctTaxFrg | Deductible Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| DdctTaxSys | Deductible Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| BaseAppld | Applied Base Amount | Num | 19.6 | - | Â | Â | Â |
| BaseApldFC | Applied Base Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| BaseApldSC | Applied Base Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| NonDdctPrc | Non Deductible % | Num | 19.6 | - | Â | Â | Â |
| NonDdctAct | Non Deductible Account | nVarChar | 15 | OACT | Â | Â | Â |
| TaxInPrice | Tax Included in Price? | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Exempt | Exempt? | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxExpAct | Expense Account for Tax | nVarChar | 15 | OACT | Â | Â | Â |
| OnHoldTax | On Hold Tax Amount | Num | 19.6 | - | Â | Â | Â |
| OnHoldTaxF | On Hold Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| OnHoldTaxS | On Hold Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| InGrossRev | Included in Gross Revenue | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxSumOrg | Tax Amount Original | Num | 19.6 | - | Â | Â | Â |
| TaxSumOrgF | Tax Amount Original (FC) | Num | 19.6 | - | Â | Â | Â |
| TaxSumOrgS | Tax Amount Original (SC) | Num | 19.6 | - | Â | Â | Â |
| OpenTax | Open Service Tax | Num | 19.6 | - | Â | Â | Â |
| OpenTaxFC | Open Service Tax (FC) | Num | 19.6 | - | Â | Â | Â |
| OpenTaxSC | Open Service Tax (SC) | Num | 19.6 | - | Â | Â | Â |
| Unencumbrd | Unencumbered | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxOnRI | Tax On Reserve Invoice | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RvsChrgPrc | Reverse Charge % | Num | 19.6 | - | Â | Â | Â |
| RvsChrgTax | Reverse Charge Tax Amount | Num | 19.6 | - | Â | Â | Â |
| RvsChrgSC | Reverse Charge Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| RvsChrgFC | Reverse Charge Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| InFirstIns | Included in First Installment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ExtTaxRate | External Tax Rate | Num | 19.6 | - | Â | Â | Â |
| ExtTaxSum | External Tax Amount | Num | 19.6 | - | Â | Â | Â |
| TaxAmtSrc | Tax Amount Source | VarChar | 1 | - | S | S | Internal System Calculation |
| Â | Â | Â | Â | Â | Â | E | External Calculation |
| ExtTaxSumF | External Tax Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| ExtTaxSumS | External Tax Amount (SC) | Num | 19.6 | - | Â | Â | Â |
| CESTrel | CEST Relevant | VarChar | 1 | - | N | Y | Â |
| Â | Â | Â | Â | Â | Â | N | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineSeq |
| SCONDARY | No | DocEntry |
| Â | Â | LineNum |
| Â | Â | GroupNum |
| Â | Â | ExpnsCode |
| Â | Â | StcCode |
| Â | Â | StaCode |
| Â | Â | staType |