|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Sales Tax Codes
Table Name: ASTC
Table Description: Sales Tax Codes
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | nVarChar | 8 | - | Â | Â | Â |
| Name | Name | nVarChar | 100 | - | Â | Â | Â |
| Rate | Rate | Num | 19.6 | - | Â | Â | Â |
| Freight | Freight | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| ValidForAR | Valid for A/R | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ValidForAP | Valid for A/P | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TfcId | Formula Combination ID | Int | 11 | OTFC | Â | Â | Â |
| Lock | Inactive | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxIcms | Taxation For ICMS | nVarChar | 2 | - | Â | Â | Â |
| IsItmLevel | Single Item Level Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CfopIn | CFOP Incoming Code | nVarChar | 6 | OCFP | Â | Â | Â |
| CfopOut | CFOP Outgoing Code | nVarChar | 6 | OCFP | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| FADebit | FA Debit | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| IsSystem | Is System Tax Code | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| VatExempt | Apply VAT Exemption | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| HashInpNm | Hash Input Name | nVarChar | 100 | - | Â | Â | Â |
| CheckDate | Check Date | Date | 8 | - | Â | Â | Â |
| EfctDate | Effective From | Date | 8 | - | Â | Â | Â |
| Provider | Tax Service Provider | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |
| Â | Â | LogInstanc |