SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: ORTG
Table Description: Deducted Tax Definition
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Code |
nVarChar |
8 |
- |
|
|
|
| Name |
Name |
nVarChar |
50 |
- |
|
|
|
| Inactive |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Category |
Category |
VarChar |
1 |
- |
I |
I |
Input Tax |
| RecognRate |
Deducted Purchase Tax % |
Num |
19.6 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| IsSystem |
System Deducted Tax Code |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Key |
Unique |
Field |
| PRIMARY |
Yes |
Code |
| GROUP_NAME |
No |
Name |