| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Code |
nVarChar |
8 |
- |
|
|
|
| Name |
Name |
nVarChar |
20 |
- |
|
|
|
| Warehouse |
Warehouse |
nVarChar |
8 |
OWHS |
|
|
|
| SalePerson |
Sales Employee |
Int |
11 |
OSLP |
-1 |
|
|
| ICTCard |
BP for Invoice + Payment |
nVarChar |
15 |
OCRD |
|
|
|
| CashAcct |
Cash Account |
nVarChar |
15 |
- |
|
|
|
| CheckAcct |
Current Account |
nVarChar |
15 |
- |
|
|
|
| CreditCard |
Credit Card |
Int |
6 |
OCRC |
|
|
|
| PrintRcpt |
Print Receipt |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
A |
Only When Adding |
| |
|
|
|
|
|
Y |
Always |
| ShortRcpt |
Print Payment & Invoice in Succession |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Color |
Windows Color |
Int |
6 |
- |
|
0 |
Combined |
| |
|
|
|
|
|
1 |
Classic |
| |
|
|
|
|
|
2 |
Gray |
| |
|
|
|
|
|
3 |
Violet |
| |
|
|
|
|
|
4 |
Blue |
| |
|
|
|
|
|
5 |
Green |
| |
|
|
|
|
|
6 |
Yellow |
| |
|
|
|
|
|
7 |
Orange |
| |
|
|
|
|
|
8 |
Red |
| |
|
|
|
|
|
9 |
Brown |
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| PrintHeadr |
Printing Header |
nVarChar |
100 |
- |
|
|
|
| Phone1 |
Telephone Number 1 |
nVarChar |
50 |
- |
|
|
|
| Phone2 |
Telephone Number 2 |
nVarChar |
50 |
- |
|
|
|
| Fax |
Fax Number |
nVarChar |
50 |
- |
|
|
|
| E_Mail |
E-Mail |
nVarChar |
100 |
- |
|
|
|
| FrgnAddr |
Address in Foreign Language |
nVarChar |
254 |
- |
|
|
|
| FrnPrntHdr |
Printing Header in Foreign Lan |
nVarChar |
100 |
- |
|
|
|
| FrgnPhone1 |
Telephone Number 1 (Foreign Lang.) |
nVarChar |
50 |
- |
|
|
|
| FrgnPhone2 |
Telephone Number 2 (Foreign Lang.) |
nVarChar |
50 |
- |
|
|
|
| FrgnFax |
Fax Number (Foreign Lang.) |
nVarChar |
50 |
- |
|
|
|
| DflTaxCode |
Default Tax Code |
nVarChar |
8 |
OSTC |
|
|
|
| FreeZoneNo |
Additional ID Number |
nVarChar |
32 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| free1 |
Free1 |
VarChar |
1 |
- |
|
|
|
| UseTax |
Use Tax |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AdrsFromWh |
Use Warehouse Address in A/P Documents |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Language |
Language |
Int |
11 |
OLNG |
|
|
|
| Font |
Font |
nVarChar |
50 |
- |
|
|
|
| FontSize |
Font Size |
Int |
11 |
- |
|
|
|
| BPLId |
Default Branch |
Int |
11 |
OBPL |
|
|
|
| AssetInDoc |
Allow Creation of Asset in Doc. |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AttachPath |
Attachments Path |
Text |
16 |
- |
|
|
|
| DflPTICode |
Default POI Code |
nVarChar |
5 |
OPTI |
|
|
|
| Free4 |
unused |
VarChar |
1 |
- |
|
|
|
| Free2 |
unused |
VarChar |
1 |
- |
|
|
|
| Free3 |
unused |
VarChar |
1 |
- |
|
|
|
| DflPosCR |
Default POS/Cash Register |
Int |
11 |
OPCM |
|
|
|
| TimeFormat |
Time Template |
VarChar |
1 |
- |
|
0 |
24H |
| |
|
|
|
|
|
1 |
12H |
| DateFormat |
Date Template |
VarChar |
1 |
- |
|
0 |
DD/MM/YY |
| |
|
|
|
|
|
1 |
DD/MM/YYYY |
| |
|
|
|
|
|
2 |
MM/DD/YY |
| |
|
|
|
|
|
3 |
MM/DD/YYYY |
| |
|
|
|
|
|
4 |
CCYY/MM/DD |
| |
|
|
|
|
|
5 |
DD/Month/YYYY |
| |
|
|
|
|
|
6 |
YY/MM/DD |
| DateSep |
Date Separator |
VarChar |
1 |
- |
|
|
|
| DecSep |
Decimal Separator |
VarChar |
1 |
- |
|
|
|
| ThousSep |
Thousands Separator |
VarChar |
1 |
- |
|
|
|
| WallPaper |
Wallpaper |
Text |
16 |
- |
|
|
|
| WllPprDsp |
Wallpaper Display |
nVarChar |
6 |
- |
|
1 |
Centralized |
| |
|
|
|
|
|
2 |
Full Screen |
| |
|
|
|
|
|
3 |
Tile |
| SkinType |
Skin Type |
nVarChar |
254 |
- |
|
|
|
| CharMonth |
Number of Characters in Month |
Int |
11 |
- |
|
|
|
| HandleEDoc |
Can Take Control of eDoc Processing in Electronic Document Monitor |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |