SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OSTC
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 |