| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Address |
Address Name |
nVarChar |
50 |
- |
|
|
|
| CardCode |
BP Code |
nVarChar |
15 |
OCRD |
|
|
|
| Street |
Street |
nVarChar |
100 |
- |
|
|
|
| Block |
Block |
nVarChar |
100 |
- |
|
|
|
| ZipCode |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| City |
City |
nVarChar |
100 |
- |
|
|
|
| County |
County |
nVarChar |
100 |
- |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| State |
State |
nVarChar |
3 |
OCST |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
2 |
|
|
| LicTradNum |
Federal Tax ID |
nVarChar |
32 |
- |
|
|
|
| LineNum |
Row Number |
Int |
11 |
- |
|
|
|
| TaxCode |
Tax Code |
nVarChar |
8 |
OSTC |
|
|
|
| Building |
Building/Floor/Room |
Text |
16 |
- |
|
|
|
| AdresType |
Address Type |
VarChar |
1 |
- |
S |
S |
Ship To |
| |
|
|
|
|
|
B |
Bill To |
| Address2 |
Address Name 2 |
nVarChar |
50 |
- |
|
|
|
| Address3 |
Address Name 3 |
nVarChar |
50 |
- |
|
|
|
| AddrType |
Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNo |
Street No. |
nVarChar |
100 |
- |
|
|
|
| AltCrdName |
Alternative BP Name |
nVarChar |
200 |
- |
|
|
|
| AltTaxId |
Alternative Tax ID |
nVarChar |
32 |
- |
|
|
|
| TaxOffice |
Tax Office |
nVarChar |
50 |
- |
|
|
|
| GlblLocNum |
Global Location Number |
nVarChar |
50 |
- |
|
|
|
| Ntnlty |
Nationality |
nVarChar |
100 |
- |
|
|
|
| DIOTNat |
DIOT Nationality |
nVarChar |
3 |
OCRY |
|
|
|
| TaaSEnbl |
TaaS Service Enabled on Address |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GSTRegnNo |
GSTIN |
nVarChar |
15 |
- |
|
|
|
| GSTType |
GST Type |
Int |
11 |
OGTY |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| CreateTS |
Creation Time Incl. Sec. |
Int |
11 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| MYFType |
MYF Type |
nVarChar |
2 |
- |
|
S1 |
MYF Wholesale Sales |
| |
|
|
|
|
|
S2 |
Retail Sales |
| |
|
|
|
|
|
P1 |
MYF Wholesale Purchases |
| |
|
|
|
|
|
P3 |
Other Expense Transactions |
| VatResDate |
VAT Verfication Response Date |
Date |
8 |
- |
|
|
|
| VatResCode |
VAT Verfication Response Code |
Int |
11 |
ORVC |
|
|
|
| VatResName |
VAT Verfication Response Name |
nVarChar |
254 |
- |
|
|
|
| VatResAddr |
VAT Verfication Response Addr |
nVarChar |
254 |
- |
|
|
|
| EnNtnlty |
Encryption of Nationality |
Text |
16 |
- |
|
|
|