| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| BPLId |
Branch ID |
Int |
11 |
- |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| BPLFrName |
Branch Name (Foreign) |
nVarChar |
200 |
- |
|
|
|
| VATRegNum |
VAT Reg. Number |
nVarChar |
12 |
- |
|
|
|
| RepName |
Rep. Name |
nVarChar |
15 |
- |
|
|
|
| Industry |
Industry |
nVarChar |
20 |
- |
|
|
|
| Business |
Business |
nVarChar |
20 |
- |
|
|
|
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| AddressFr |
Address (Foreign) |
nVarChar |
254 |
- |
|
|
|
| MainBPL |
Main BPL |
VarChar |
1 |
- |
N |
Y |
Main Business Place |
| |
|
|
|
|
|
N |
Not Main Business Place |
| TxOffcNo |
Tax Office No. |
nVarChar |
3 |
- |
|
|
|
| Disabled |
Disabled |
VarChar |
1 |
- |
N |
Y |
Disabled |
| |
|
|
|
|
|
N |
Enabled |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| DflCust |
Default Customer ID |
nVarChar |
15 |
OCRD |
|
|
|
| DflVendor |
Default Vendor ID |
nVarChar |
15 |
OCRD |
|
|
|
| DflWhs |
Default Warehouse ID |
nVarChar |
8 |
OWHS |
|
|
|
| DflTaxCode |
Default Tax Code |
nVarChar |
8 |
OCNA |
|
|
|
| RevOffice |
Tax Office |
nVarChar |
100 |
- |
|
|
|
| TaxIdNum |
Branch Reg. No. |
nVarChar |
32 |
- |
|
|
|
| TaxIdNum2 |
Federal Tax ID 2 |
nVarChar |
32 |
- |
|
|
|
| TaxIdNum3 |
Federal Tax ID 3 |
nVarChar |
32 |
- |
|
|
|
| AddtnlId |
Additional ID Number |
nVarChar |
32 |
- |
|
|
|
| CompNature |
Nature of Company |
Int |
11 |
OBNI |
-1 |
|
|
| EconActT |
Economic Activity Type |
Int |
11 |
OBNI |
-1 |
|
|
| CredCOrig |
Credit Contribution Origin |
nVarChar |
2 |
OBSI |
|
|
|
| IPIPeriod |
IPI Period |
nVarChar |
2 |
OBSI |
|
|
|
| CoopAssocT |
Cooperative Association Type |
Int |
11 |
OBNI |
-1 |
|
|
| PrefState |
Default State |
nVarChar |
3 |
- |
|
|
|
| ProfTax |
Profit Taxation |
Int |
11 |
OBNI |
-1 |
|
|
| CompQualif |
Company Qualification |
Int |
11 |
OBNI |
-1 |
|
|
| DeclType |
Declarer Type |
Int |
11 |
OBNI |
-1 |
|
|
| AddrType |
Address Type |
nVarChar |
100 |
- |
|
|
|
| Street |
Street |
nVarChar |
100 |
- |
|
|
|
| StreetNo |
Street No. |
nVarChar |
100 |
- |
|
|
|
| Building |
Building/Floor/Room |
nVarChar |
100 |
- |
|
|
|
| ZipCode |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| Block |
Block |
nVarChar |
100 |
- |
|
|
|
| City |
City |
nVarChar |
100 |
- |
|
|
|
| State |
State |
nVarChar |
3 |
- |
|
|
|
| County |
County |
nVarChar |
100 |
OCNT |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| PmtClrAct |
Payment Clearing Account |
nVarChar |
15 |
OACT |
|
|
|
| CommerReg |
Commercial Register |
nVarChar |
60 |
- |
|
|
|
| DateOfInc |
Date of Incorporation |
Date |
8 |
- |
|
|
|
| SPEDProf |
SPED Profile |
nVarChar |
2 |
OBSI |
|
|
|
| EnvTypeNFe |
Environment Type NFe |
Int |
11 |
OBNI |
-1 |
|
|
| Opt4ICMS |
Opting for ICMS 115_03 |
VarChar |
1 |
- |
N |
|
|
| AliasName |
Alias Name |
Text |
16 |
- |
|
|
|
| GlblLocNum |
Global Location Number |
nVarChar |
50 |
- |
|
|
|
| TaxRptFrm |
Tax Wizard Reporting From |
Date |
8 |
- |
|
|
|
| Suframa |
SUFRAMA |
nVarChar |
100 |
- |
|
|
|
| DfltResWhs |
Default Resource Warehouse ID |
nVarChar |
8 |
OWHS |
|
|
|
| SnapshotId |
Snapshot ID |
Int |
11 |
- |
0 |
|
|
| BPLNum |
Branch No. |
Int |
11 |
- |
0 |
|
|