| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| CardCode |
BP Code |
nVarChar |
15 |
- |
|
|
|
| CardName |
BP Name |
nVarChar |
200 |
- |
|
|
|
| CardType |
BP Type |
VarChar |
1 |
- |
C |
C |
Customer |
| |
|
|
|
|
|
S |
Vendor |
| |
|
|
|
|
|
L |
Lead |
| GroupCode |
Group Code |
Int |
6 |
OCRG |
|
|
|
| CmpPrivate |
Type of Business |
VarChar |
1 |
- |
C |
C |
Company |
| |
|
|
|
|
|
I |
Private |
| |
|
|
|
|
|
G |
Government |
| |
|
|
|
|
|
E |
Employee |
| Address |
Bill-to Street |
nVarChar |
100 |
- |
|
|
|
| ZipCode |
Bill-to Zip Code |
nVarChar |
20 |
- |
|
|
|
| MailAddres |
Ship-to Street |
nVarChar |
100 |
- |
|
|
|
| MailZipCod |
Ship-to Zip Code |
nVarChar |
20 |
- |
|
|
|
| Phone1 |
Telephone 1 |
nVarChar |
50 |
- |
|
|
|
| Phone2 |
Telephone 2 |
nVarChar |
50 |
- |
|
|
|
| Fax |
Fax Number |
nVarChar |
50 |
- |
|
|
|
| CntctPrsn |
Contact Person |
nVarChar |
90 |
- |
|
|
|
| Notes |
Remarks |
nVarChar |
100 |
- |
|
|
|
| Balance |
Account Balance |
Num |
19.6 |
- |
|
|
|
| ChecksBal |
Open Checks Balance in FC |
Num |
19.6 |
- |
|
|
|
| DNotesBal |
Open Deliveries/GRPO Balance |
Num |
19.6 |
- |
|
|
|
| OrdersBal |
Open Orders Balance |
Num |
19.6 |
- |
|
|
|
| GroupNum |
Payment Terms Code |
Int |
6 |
OCTG |
-1 |
|
|
| CreditLine |
Credit Limit |
Num |
19.6 |
- |
|
|
|
| DebtLine |
Payable Limit |
Num |
19.6 |
- |
|
|
|
| Discount |
Discount % |
Num |
19.6 |
- |
|
|
|
| VatStatus |
Tax Definition |
VarChar |
1 |
- |
Y |
Y |
Liable |
| |
|
|
|
|
|
N |
Exempted |
| |
|
|
|
|
|
E |
EU |
| LicTradNum |
Federal Tax ID |
nVarChar |
32 |
- |
|
|
|
| DdctStatus |
Liable for Ded. at Source |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DdctPrcnt |
Withholding Tax Deduction % |
Num |
19.6 |
- |
|
|
|
| ValidUntil |
Expiration Date for -% of Deduction |
Date |
8 |
- |
|
|
|
| Chrctrstcs |
Properties |
Int |
11 |
- |
|
|
|
| ExMatchNum |
Last Ext. Reconciliation No. |
Int |
11 |
- |
|
|
|
| InMatchNum |
Last Int. Reconciliation No. |
Int |
11 |
- |
|
|
|
| ListNum |
Price List No. |
Int |
6 |
OPLN |
|
|
|
| DNoteBalFC |
Open DN Balance in BP Curr. |
Num |
19.6 |
- |
|
|
|
| OrderBalFC |
Open Orders Bal. in BP Curr. |
Num |
19.6 |
- |
|
|
|
| DNoteBalSy |
Open Deliveries/GRPO Balance in SC |
Num |
19.6 |
- |
|
|
|
| OrderBalSy |
Open Orders Balance in SC |
Num |
19.6 |
- |
|
|
|
| Transfered |
Year Transfer |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BalTrnsfrd |
Balances transferred |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IntrstRate |
Interest % on Liabilities |
Num |
19.6 |
- |
|
|
|
| Commission |
Commission % for Customer |
Num |
19.6 |
- |
|
|
|
| CommGrCode |
Commission Group |
Int |
6 |
OCOG |
0 |
|
|
| Free_Text |
Free Text |
Text |
16 |
- |
|
|
|
| SlpCode |
Sales Employee Code |
Int |
11 |
OSLP |
-1 |
|
|
| PrevYearAc |
Previous Year Balance |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Currency |
BP Currency |
nVarChar |
3 |
OCRN |
|
|
|
| RateDifAct |
Rate Differences Account |
nVarChar |
15 |
OACT |
|
|
|
| BalanceSys |
Account Balance in SC |
Num |
19.6 |
- |
|
|
|
| BalanceFC |
BP Balance in FC |
Num |
19.6 |
- |
|
|
|
| Protected |
Protected BP |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Cellular |
Mobile Phone |
nVarChar |
50 |
- |
|
|
|
| AvrageLate |
Average Payment Delay in Days |
Int |
6 |
- |
|
|
|
| City |
Bill-to City |
nVarChar |
100 |
- |
|
|
|
| County |
Bill-to County |
nVarChar |
100 |
- |
|
|
|
| Country |
Bill-to Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| MailCity |
Ship-to City |
nVarChar |
100 |
- |
|
|
|
| MailCounty |
Ship-to County |
nVarChar |
100 |
- |
|
|
|
| MailCountr |
Ship-to Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| E_Mail |
E-Mail |
nVarChar |
100 |
- |
|
|
|
| Picture |
Picture |
nVarChar |
200 |
- |
|
|
|
| DflAccount |
Default Account |
nVarChar |
50 |
- |
|
|
|
| DflBranch |
Default Branch |
nVarChar |
50 |
- |
|
|
|
| BankCode |
Default Bank |
nVarChar |
30 |
- |
-1 |
|
|
| AddID |
ID No. 2 |
nVarChar |
64 |
- |
|
|
|
| Pager |
Pager |
nVarChar |
30 |
- |
|
|
|
| FatherCard |
Consolidating Business Partner |
nVarChar |
15 |
OCRD |
|
|
|
| CardFName |
Foreign Name |
nVarChar |
200 |
- |
|
|
|
| FatherType |
Parent Summary Type |
VarChar |
1 |
- |
P |
P |
Payment Consolidation |
| |
|
|
|
|
|
D |
Delivery Consolidation |
| QryGroup1 |
Property 1 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup2 |
Property 2 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup3 |
Property 3 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup4 |
Property 4 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup5 |
Property 5 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup6 |
Property 6 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup7 |
Property 7 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup8 |
Property 8 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup9 |
Property 9 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup10 |
Property 10 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup11 |
Property 11 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup12 |
Property 12 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup13 |
Property 13 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup14 |
Property 14 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup15 |
Property 15 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup16 |
Property 16 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup17 |
Property 17 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup18 |
Property 18 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup19 |
Property 19 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup20 |
Property 20 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup21 |
Property 21 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup22 |
Property 22 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup23 |
Property 23 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup24 |
Property 24 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup25 |
Property 25 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup26 |
Property 26 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup27 |
Property 27 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup28 |
Property 28 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup29 |
Property 29 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup30 |
Property 30 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup31 |
Property 31 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup32 |
Property 32 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup33 |
Property 33 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup34 |
Property 34 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup35 |
Property 35 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup36 |
Property 36 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup37 |
Property 37 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup38 |
Property 38 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup39 |
Property 39 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup40 |
Property 40 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup41 |
Property 41 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup42 |
Property 42 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup43 |
Property 43 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup44 |
Property 44 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup45 |
Property 45 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup46 |
Property 46 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup47 |
Property 47 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup48 |
Property 48 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup49 |
Property 49 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup50 |
Property 50 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup51 |
Property 51 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup52 |
Property 52 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup53 |
Property 53 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup54 |
Property 54 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup55 |
Property 55 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup56 |
Property 56 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup57 |
Property 57 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup58 |
Property 58 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup59 |
Property 59 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup60 |
Property 60 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup61 |
Property 61 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup62 |
Property 62 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup63 |
Property 63 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| QryGroup64 |
Property 64 |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DdctOffice |
Deduction Approval Office |
nVarChar |
10 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| ExportCode |
Data Export Code |
nVarChar |
8 |
- |
|
|
|
| DscntObjct |
Object for Discounts |
Int |
6 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
52 |
Groups |
| |
|
|
|
|
|
8 |
Properties |
| |
|
|
|
|
|
43 |
Companies |
| |
|
|
|
|
|
4 |
Items |
| DscntRel |
Discounts Ratio |
VarChar |
1 |
- |
L |
L |
Lowest Discount |
| |
|
|
|
|
|
H |
Highest Discount |
| |
|
|
|
|
|
A |
Average Disc. |
| |
|
|
|
|
|
S |
Discount Totals |
| |
|
|
|
|
|
M |
Discount Multiples |
| SPGCounter |
SPG Counter |
Int |
6 |
- |
0 |
|
|
| SPPCounter |
SPP Counter |
Int |
11 |
- |
0 |
|
|
| DdctFileNo |
Tax Deduction File Number |
nVarChar |
9 |
- |
|
|
|
| SCNCounter |
SCN Counter |
Int |
6 |
- |
|
|
|
| MinIntrst |
Min. Interest Letter Amount |
Num |
19.6 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| OprCount |
Open Opportunities |
Int |
11 |
- |
|
|
|
| ExemptNo |
Exempt No. |
nVarChar |
50 |
- |
|
|
|
| Priority |
Priority |
Int |
11 |
OBPP |
-1 |
|
|
| CreditCard |
Credit Cards |
Int |
6 |
OCRC |
-1 |
|
|
| CrCardNum |
Credit Card No. |
nVarChar |
64 |
- |
|
|
|
| CardValid |
Credit Card Validity |
Date |
8 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| LocMth |
LC Reconciliation |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| validFor |
Active |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| validFrom |
Active From |
Date |
8 |
- |
|
|
|
| validTo |
Active To |
Date |
8 |
- |
|
|
|
| frozenFor |
Inactive |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| frozenFrom |
Inactive From |
Date |
8 |
- |
|
|
|
| frozenTo |
Inactive To |
Date |
8 |
- |
|
|
|
| sEmployed |
Self-Employed |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MTHCounter |
MTH Counter |
Int |
11 |
- |
|
|
|
| BNKCounter |
BNK Counter |
Int |
11 |
- |
|
|
|
| DdgKey |
Withholding Tax Deduction Grp |
Int |
11 |
ODDG |
-1 |
|
|
| DdtKey |
Current Deduction Hierarchy |
Int |
11 |
- |
-1 |
|
|
| ValidComm |
Active Remarks |
nVarChar |
30 |
- |
|
|
|
| FrozenComm |
Inactive Remarks |
nVarChar |
30 |
- |
|
|
|
| chainStore |
Belongs to Retail Store |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DiscInRet |
Allow Doc Discount in Returns |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| State1 |
Bill-to State |
nVarChar |
3 |
OCST |
|
|
|
| State2 |
Ship-to State |
nVarChar |
3 |
OCST |
|
|
|
| VatGroup |
Tax Code |
nVarChar |
8 |
OSTC |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
2 |
|
|
| Indicator |
Indicator |
nVarChar |
2 |
OIDC |
|
|
|
| ShipType |
Shipping Type |
Int |
6 |
OSHP |
|
|
|
| DebPayAcct |
Accounts Receivable/Payable |
nVarChar |
15 |
OACT |
|
|
|
| ShipToDef |
Ship-to-Default |
nVarChar |
50 |
- |
|
|
|
| Block |
Bill-to Block |
nVarChar |
100 |
- |
|
|
|
| MailBlock |
Ship-to Block |
nVarChar |
100 |
- |
|
|
|
| Password |
Password |
nVarChar |
32 |
- |
|
|
|
| ECVatGroup |
Tax Group |
nVarChar |
8 |
OVTG |
|
|
|
| Deleted |
Deleted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IBAN |
IBAN |
nVarChar |
50 |
- |
|
|
|
| DocEntry |
Internal Number |
Int |
11 |
- |
|
|
|
| FormCode |
1099 Form Code |
Int |
11 |
OTNN |
|
|
|
| Box1099 |
1099 Box |
nVarChar |
20 |
- |
|
|
|
| PymCode |
Payment Method Code |
nVarChar |
15 |
OPYM |
-1 |
|
|
| BackOrder |
Backorder |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PartDelivr |
Partial Delivery |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DunnLevel |
Dunning Level |
Int |
11 |
ODUN |
|
|
|
| DunnDate |
Dunning Date |
Date |
8 |
- |
|
|
|
| BlockDunn |
Block Dunning |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BankCountr |
Bank Country |
nVarChar |
3 |
OCRY |
|
|
|
| CollecAuth |
Collection Authorization |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DME |
DME Identification |
nVarChar |
5 |
- |
|
|
|
| InstrucKey |
Instruction Key |
nVarChar |
30 |
- |
|
|
|
| SinglePaym |
Single Payment |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ISRBillId |
ISR Biller ID |
nVarChar |
9 |
- |
|
|
|
| PaymBlock |
Payment Block |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| RefDetails |
Reference Details |
nVarChar |
20 |
- |
|
|
|
| HouseBank |
House Bank |
nVarChar |
30 |
- |
-1 |
|
|
| OwnerIdNum |
ID Number |
nVarChar |
15 |
- |
|
|
|
| PyBlckDesc |
Payment Block Description |
Int |
11 |
OPYB |
-1 |
|
|
| HousBnkCry |
House Bank Country |
nVarChar |
3 |
- |
|
|
|
| HousBnkAct |
House Bank Account |
nVarChar |
50 |
- |
|
|
|
| HousBnkBrn |
House Bank Branch |
nVarChar |
50 |
- |
|
|
|
| ProjectCod |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| SysMatchNo |
Last Sys. Reconciliation No. |
Int |
11 |
- |
-1 |
|
|
| VatIdUnCmp |
Unified Federal Tax ID |
nVarChar |
32 |
- |
|
|
|
| AgentCode |
Agent Code |
nVarChar |
32 |
OAGP |
|
|
|
| TolrncDays |
Tolerance Days |
Int |
6 |
- |
|
|
|
| SelfInvoic |
Self Invoice |
VarChar |
1 |
- |
|
|
|
| DeferrTax |
Deferred Tax |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LetterNum |
Tax Exemption Letter No. |
nVarChar |
50 |
- |
|
|
|
| MaxAmount |
Max. Exemption Amount |
Num |
19.6 |
- |
|
|
|
| FromDate |
Exemption Validity Date From |
Date |
8 |
- |
|
|
|
| ToDate |
Exemption Validity Date To |
Date |
8 |
- |
|
|
|
| WTLiable |
Subject to Withholding Tax |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
|
None |
| CrtfcateNO |
Certificate No. |
nVarChar |
20 |
- |
|
|
|
| ExpireDate |
Expiration Date |
Date |
8 |
- |
|
|
|
| NINum |
Registration No. |
nVarChar |
20 |
- |
|
|
|
| AccCritria |
Accrual |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WTCode |
WTax Code |
nVarChar |
4 |
OWHT |
|
|
|
| Equ |
Equalization Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| HldCode |
Holidays Name |
nVarChar |
20 |
OHLD |
|
|
|
| ConnBP |
Linked Business Partner |
nVarChar |
15 |
OCRD |
|
|
|
| MltMthNum |
Last Multi. Reconciliation No. |
Int |
11 |
- |
|
|
|
| TypWTReprt |
BP Type for WTax Report |
VarChar |
1 |
- |
C |
C |
Company |
| |
|
|
|
|
|
P |
Person |
| VATRegNum |
VAT Reg. Number |
nVarChar |
32 |
- |
|
|
|
| RepName |
Representative Name |
nVarChar |
15 |
- |
|
|
|
| Industry |
Industry |
Text |
16 |
- |
|
|
|
| Business |
Business |
Text |
16 |
- |
|
|
|
| WTTaxCat |
Withholding Tax Cat. |
Text |
16 |
- |
|
|
|
| IsDomestic |
Is Domestic |
VarChar |
1 |
- |
Y |
Y |
Domestic |
| |
|
|
|
|
|
N |
Foreign |
| IsResident |
Is Resident |
VarChar |
1 |
- |
Y |
Y |
Resident |
| |
|
|
|
|
|
N |
Non-Resident |
| AutoCalBCG |
Auto Calculated Bank Charges |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| OtrCtlAcct |
Other Receivable/Payable |
nVarChar |
15 |
OACT |
|
|
|
| AliasName |
Alias Name |
Text |
16 |
- |
|
|
|
| Building |
Bill-to Building/Floor/Room |
Text |
16 |
- |
|
|
|
| MailBuildi |
Ship to Building/Floor/Room |
Text |
16 |
- |
|
|
|
| BoEPrsnt |
Customer Bill of Exchang Pres |
nVarChar |
15 |
OACT |
|
|
|
| BoEDiscnt |
Customer BoE Discounted |
nVarChar |
15 |
OACT |
|
|
|
| BoEOnClct |
Bill of Exchange on Collection |
nVarChar |
15 |
OACT |
|
|
|
| UnpaidBoE |
Unpaid Bill of Exchange |
nVarChar |
15 |
OACT |
|
|
|
| ITWTCode |
Income Tax WTax Code |
nVarChar |
4 |
OWHT |
|
|
|
| DunTerm |
Dunning Term |
nVarChar |
25 |
ODUT |
|
|
|
| ChannlBP |
Channel BP |
nVarChar |
15 |
OCRD |
|
|
|
| DfTcnician |
Default Technician |
Int |
11 |
OHEM |
|
|
|
| Territory |
Territory |
Int |
11 |
OTER |
|
|
|
| BillToDef |
Bill-to Default |
nVarChar |
50 |
- |
|
|
|
| DpmClear |
Payment Advances |
nVarChar |
15 |
OACT |
|
|
|
| IntrntSite |
Web Site |
nVarChar |
100 |
- |
|
|
|
| LangCode |
Language Code |
Int |
11 |
OLNG |
|
|
|
| HousActKey |
House Bank Account Key |
Int |
11 |
DSC1 |
|
|
|
| Profession |
Profession |
nVarChar |
50 |
- |
|
|
|
| CDPNum |
Closing Date Procedure Number |
Int |
6 |
OCDP |
|
|
|
| DflBankKey |
Default Bank Key |
Int |
11 |
ODSC |
|
|
|
| BCACode |
Bank Charges Allocation Codes |
nVarChar |
3 |
OBCA |
|
|
|
| UseShpdGd |
Use Shipped Goods Account |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RegNum |
Company Reg. No. (CRN) |
nVarChar |
32 |
- |
|
|
|
| VerifNum |
WTax Verification No. |
nVarChar |
32 |
- |
|
|
|
| BankCtlKey |
Default Bank Internal ID |
nVarChar |
2 |
- |
|
|
|
| HousCtlKey |
House Bank Control Number |
nVarChar |
2 |
- |
|
|
|
| AddrType |
Bill-to Address Type |
nVarChar |
100 |
- |
|
|
|
| InsurOp347 |
347 Insurance Operation |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| MailAddrTy |
Ship-to Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNo |
Bill-to Street No. |
nVarChar |
100 |
- |
|
|
|
| MailStrNo |
Ship-to Street No. |
nVarChar |
100 |
- |
|
|
|
| TaxRndRule |
Tax Rounding Rule |
VarChar |
1 |
- |
D |
D |
Company Default |
| |
|
|
|
|
|
R |
Round Off |
| |
|
|
|
|
|
C |
Round Up |
| |
|
|
|
|
|
F |
Round Down |
| VendTID |
Vender Type ID |
Int |
11 |
OVTP |
|
|
|
| ThreshOver |
Threshold Overlook |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SurOver |
Surcharge Overlook |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VendorOcup |
Vendor Occupation |
nVarChar |
15 |
- |
|
|
|
| OpCode347 |
347 Operation Code |
VarChar |
1 |
- |
|
A |
Goods or Services Acquisitions |
| |
|
|
|
|
|
D |
Public Entities Acquisitions |
| |
|
|
|
|
|
G |
Travel Agent Purchases |
| |
|
|
|
|
|
B |
Sales or Services Revenues |
| |
|
|
|
|
|
E |
Public Subsidies |
| |
|
|
|
|
|
F |
Travel Agent Sales |
| DpmIntAct |
DPM Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ResidenNum |
Residence Number |
VarChar |
1 |
- |
1 |
1 |
Spanish Fiscal ID |
| |
|
|
|
|
|
2 |
VAT Registration Number |
| |
|
|
|
|
|
3 |
Passport |
| |
|
|
|
|
|
4 |
Fiscal ID Issued by the Country of Residence |
| |
|
|
|
|
|
5 |
Certificate of Fiscal Residence |
| |
|
|
|
|
|
6 |
Other Document |
| |
|
|
|
|
|
7 |
Not Registered |
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| PlngGroup |
Planning Group |
nVarChar |
10 |
- |
|
|
|
| VatIDNum |
VAT ID Number |
nVarChar |
32 |
- |
|
|
|
| Affiliate |
Affiliate |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MivzExpSts |
Mivzak Export Status |
VarChar |
1 |
- |
B |
B |
Not Exported |
| |
|
|
|
|
|
U |
Exported |
| |
|
|
|
|
|
D |
Deleted |
| HierchDdct |
Hierarchical Deduction |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CertWHT |
Withholding Tax Certified |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CertBKeep |
Bookkeeping Certified |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WHShaamGrp |
Withholding Shaam Group |
VarChar |
1 |
- |
1 |
1 |
Services and Agriculture Products |
| |
|
|
|
|
|
2 |
Construction and Transportation |
| |
|
|
|
|
|
3 |
Insurance Commissions |
| |
|
|
|
|
|
4 |
Withholding Tax Instructions |
| |
|
|
|
|
|
5 |
Interest Exchange Rate Differences |
| |
|
|
|
|
|
6 |
Rental Fees |
| IndustryC |
Industry |
Int |
11 |
OOND |
|
|
|
| DatevAcct |
DATEV Account |
nVarChar |
9 |
- |
|
|
|
| DatevFirst |
First Data Entry |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GTSRegNum |
GTS Registration Number |
nVarChar |
20 |
- |
|
|
|
| GTSBankAct |
GTS Bank Account |
nVarChar |
80 |
- |
|
|
|
| GTSBilAddr |
GTS Billing Address |
nVarChar |
80 |
- |
|
|
|
| HsBnkSwift |
House Bank BIC/SWIFT Code |
nVarChar |
50 |
- |
|
|
|
| HsBnkIBAN |
House Bank IBAN |
nVarChar |
50 |
- |
|
|
|
| DflSwift |
Default Bank BIC/SWIFT Code |
nVarChar |
50 |
- |
|
|
|
| AutoPost |
Automatic Posting |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
B |
Interest and Fee |
| |
|
|
|
|
|
I |
Interest Only |
| |
|
|
|
|
|
F |
Fee Only |
| IntrAcc |
Interest Account |
nVarChar |
15 |
- |
|
|
|
| FeeAcc |
Fee Account |
nVarChar |
15 |
- |
|
|
|
| CpnNo |
Campaign No. |
Int |
11 |
OCPN |
|
|
|
| NTSWebSite |
E-Tax Web Site |
Int |
6 |
OTWS |
|
|
|
| DflIBAN |
Default Bank IBAN |
nVarChar |
50 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| Number |
Number |
Int |
11 |
- |
|
|
|
| EDocExpFrm |
Electronic Doc. Export Format |
Int |
11 |
- |
|
|
|
| TaxIdIdent |
Tax ID Category |
VarChar |
1 |
- |
3 |
1 |
Self-Employed |
| |
|
|
|
|
|
2 |
Company |
| |
|
|
|
|
|
3 |
Registered Business |
| |
|
|
|
|
|
5 |
International Company |
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| DiscRel |
Disc. Relations |
VarChar |
1 |
- |
L |
L |
Lowest Discount |
| |
|
|
|
|
|
H |
Highest Discount |
| |
|
|
|
|
|
A |
Average |
| |
|
|
|
|
|
S |
Total |
| |
|
|
|
|
|
M |
Discount Multiples |
| NoDiscount |
No Discounts |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SCAdjust |
SC Adjustment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DflAgrmnt |
Default Blanket Agreement No. |
Int |
11 |
OOAT |
|
|
|
| GlblLocNum |
Global Location Number |
nVarChar |
50 |
- |
|
|
|
| SenderID |
EDI Message Sender ID |
nVarChar |
50 |
- |
|
|
|
| RcpntID |
EDI Message Recipient ID |
nVarChar |
50 |
- |
|
|
|
| MainUsage |
Main Usage |
Int |
11 |
- |
|
|
|
| SefazCheck |
Check BP Status on SEFAZ |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ChecksBalL |
Open Checks Balance in LC |
Num |
19.6 |
- |
|
|
|
| ChecksBalS |
Open Checks Balance in SC |
Num |
19.6 |
- |
|
|
|
| DateFrom |
Relationship Initial Date |
Date |
8 |
- |
|
|
|
| DateTill |
Relationship Final Date |
Date |
8 |
- |
|
|
|
| RelCode |
Relationship Code |
nVarChar |
2 |
- |
|
|
|
| |
|
|
|
|
|
01 |
Matriz no exterior |
| |
|
|
|
|
|
02 |
Filial, inclusive ag�ncia ou depend�ncia, no exterior |
| |
|
|
|
|
|
03 |
Coligada, inclusive equiparada |
| |
|
|
|
|
|
04 |
Controladora |
| |
|
|
|
|
|
05 |
Controlada (exceto subsidi�ria integral) |
| |
|
|
|
|
|
06 |
Subsidi�ria integral |
| |
|
|
|
|
|
07 |
Controlada em conjunto |
| |
|
|
|
|
|
08 |
Entidade de Prop�sito Espec�fico (conforme defini��o da CVM) |
| |
|
|
|
|
|
09 |
Participante do conglomerado, conforme norma espec�fica do �rg�o regulador, exceto as que se enquadrem nos tipos precedentes |
| |
|
|
|
|
|
10 |
Vinculadas (Art. 23 da Lei 9.430/96), exceto as que se enquadrem nos tipos precedentes |
| |
|
|
|
|
|
11 |
Localizada em pa�s com tributa��o favorecida (Art. 24 da Lei 9.430/96), exceto as que se enquadrem nos tipos precedentes |
| OKATO |
OKATO |
nVarChar |
11 |
- |
|
|
|
| OKTMO |
OKTMO |
nVarChar |
12 |
- |
|
|
|
| KBKCode |
KBK Budget Classification Code |
nVarChar |
20 |
- |
|
|
|
| TypeOfOp |
Type of Operation |
VarChar |
1 |
- |
O |
P |
Professional Services |
| |
|
|
|
|
|
R |
Renting Assets |
| |
|
|
|
|
|
O |
Others |
| OwnerCode |
BP Owner |
Int |
11 |
OHEM |
|
|
|
| MandateID |
Mandate ID |
nVarChar |
35 |
- |
|
|
|
| SignDate |
Date of Signature |
Date |
8 |
- |
|
|
|
| Remark1 |
Remark 1 |
Int |
11 |
ORMK |
|
|
|
| ConCerti |
Concessional Certificate |
nVarChar |
20 |
- |
|
|
|
| TpCusPres |
Type of End-User Presence |
Int |
11 |
OBNI |
9 |
|
|
| RoleTypCod |
Role Type Code |
nVarChar |
2 |
- |
|
|
|
| BlockComm |
Block Sending Marketing |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| EmplymntCt |
Employment Category |
nVarChar |
3 |
OETC |
|
|
|
| ExcptnlEvt |
Exceptional Event |
nVarChar |
2 |
OEPE |
|
|
|
| ExpnPrfFnd |
Professional Funds Expenses |
Num |
19.6 |
- |
|
|
|
| EdrsFromBP |
Endorsable Checks from This BP |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EdrsToBP |
This BP Accepts Endorsed Checks |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateTS |
Creatn Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| EDocGenTyp |
Electr. Doc. Generation Type |
VarChar |
1 |
- |
|
N |
Not Relevant |
| |
|
|
|
|
|
G |
Generate |
| |
|
|
|
|
|
L |
Generate - Later |
| |
|
|
|
|
|
S |
Send |
| |
|
|
|
|
|
R |
Send - Later |
| eStreet |
Street |
nVarChar |
38 |
- |
|
|
|
| eStreetNum |
Street Number |
nVarChar |
4 |
- |
|
|
|
| eBuildnNum |
Building Number |
Int |
11 |
- |
|
|
|
| eZipCode |
Zip Code |
nVarChar |
10 |
- |
|
|
|
| eCityTown |
City/Town/Village |
nVarChar |
48 |
- |
|
|
|
| eCountry |
Country |
nVarChar |
3 |
OCRY |
|
|
|
| eDistrict |
District |
nVarChar |
3 |
- |
|
|
|
| RepFName |
Representative First Name |
nVarChar |
20 |
- |
|
|
|
| RepSName |
Representative Surname |
nVarChar |
36 |
- |
|
|
|
| RepCmpName |
Company Name |
nVarChar |
36 |
- |
|
|
|
| RepFisCode |
Representative Fiscal Code |
nVarChar |
16 |
- |
|
|
|
| RepAddID |
Representative Additional ID |
nVarChar |
28 |
- |
|
|
|
| PECAddr |
PEC Address |
nVarChar |
254 |
- |
|
|
|
| IPACodePA |
Receiver Code for Public Administration |
nVarChar |
32 |
- |
|
|
|
| PriceMode |
Price Mode |
VarChar |
1 |
- |
|
N |
Net |
| |
|
|
|
|
|
G |
Gross |
| EffecPrice |
Effective Price |
VarChar |
1 |
- |
D |
D |
Default Priority |
| |
|
|
|
|
|
L |
Lowest Price |
| |
|
|
|
|
|
H |
Highest Price |
| TxExMxVdTp |
Exemption Max validate type |
VarChar |
1 |
- |
I |
I |
Apply to Individual Documents |
| |
|
|
|
|
|
A |
Apply to Accumulated Document Amount |
| MerchantID |
Merchant ID |
nVarChar |
15 |
- |
|
|
|
| UseBilAddr |
Determine GST by Using Bill to |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| NaturalPer |
Natural Person |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| |
|
|
|
|
|
B |
Blocked |
| |
|
|
|
|
|
U |
Unblocked |
| EnAddID |
Encryption of ID No. 2 |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| EnDflAccnt |
Encryption of Default Account |
Text |
16 |
- |
|
|
|
| EnDflIBAN |
Encryption of Default IBAN |
Text |
16 |
- |
|
|
|
| EnERD4In |
Enable ERD for Incoming Payments |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnERD4Out |
Enable ERD for Outgoing Payments |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DflCustomr |
Default Customer |
VarChar |
1 |
- |
N |
N |
Not a default customer |
| |
|
|
|
|
|
D |
Default Customer |
| |
|
|
|
|
|
P |
Partially erased |
| |
|
|
|
|
|
C |
Default customer who has been partially erased |
| TspEntry |
Default Transporter |
Int |
11 |
OTSP |
|
|
|
| TspLine |
Default Transportation Line |
Int |
11 |
- |
|
|
|
| FCERelevnt |
FCE Relevant |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FCEVldte |
FCE Validate Base Delivery |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AggregDoc |
Aggregate Document |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EffcAllSrc |
Considers All Price Sources |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EBVatExCau |
VAT Exemption Cause |
Int |
11 |
OVEC |
|
|
|
| DataVers |
Data Version |
Int |
11 |
- |
1 |
|
|
| LegalText |
Legal Text |
nVarChar |
254 |
- |
|
|
|
| VatResDate |
VAT Verfication Response Date |
Date |
8 |
- |
|
|
|
| VatResCode |
VAT Verfication Response Code |
Int |
11 |
ORVC |
|
|
|
| EnIBAN |
Encryption of IBAN |
Text |
16 |
- |
|
|
|
| DefaultCur |
Default Currency |
nVarChar |
3 |
OCRN |
|
|
|
| VatResName |
VAT Verfication Response Name |
nVarChar |
254 |
- |
|
|
|
| VatResAddr |
VAT Verfication Response Addr |
nVarChar |
254 |
- |
|
|
|
| CertDetail |
Certificate Details |
nVarChar |
100 |
- |
|
|
|
| EORINumber |
EORI Number |
nVarChar |
17 |
- |
|
|
|
| FCEPmnMean |
Use FCEs as Payment Means |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DefCommDDt |
Defer Commitment Limit on Due Date |
VarChar |
1 |
- |
|
E |
Month End |
| |
|
|
|
|
|
H |
Half Month |
| |
|
|
|
|
|
S |
Month Start |
| DefCommMon |
Defer Commitment Limit on Due Date - Months |
Int |
6 |
- |
|
|
|
| DefCommDay |
Defer Commitment Limit on Due Date - Days |
Int |
6 |
- |
|
|
|
| ExLettDate |
Exemption Letter Registration Date |
Date |
8 |
- |
|
|
|
| NotRel4MI |
Not Relevant for Monthly Invoice |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnHBnkAcct |
Encryption of House Bank Account |
Text |
16 |
- |
|
|
|