| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Document Internal ID |
Int |
11 |
ORPC |
|
|
|
| TaxId0 |
Tax ID 0 |
nVarChar |
100 |
- |
|
|
|
| TaxId1 |
Tax ID 1 |
nVarChar |
100 |
- |
|
|
|
| TaxId2 |
Tax ID 2 |
nVarChar |
100 |
- |
|
|
|
| TaxId3 |
Tax ID 3 |
nVarChar |
100 |
- |
|
|
|
| TaxId4 |
Tax ID 4 |
nVarChar |
100 |
- |
|
|
|
| TaxId5 |
Tax ID 5 |
nVarChar |
100 |
- |
|
|
|
| TaxId6 |
Tax ID 6 |
nVarChar |
100 |
- |
|
|
|
| TaxId7 |
Tax ID 7 |
nVarChar |
100 |
- |
|
|
|
| TaxId8 |
Tax ID 8 |
nVarChar |
100 |
- |
|
|
|
| TaxId9 |
Tax ID 9 |
nVarChar |
100 |
- |
|
|
|
| State |
State Code |
nVarChar |
3 |
- |
|
|
|
| County |
County Code |
nVarChar |
7 |
- |
|
|
|
| Incoterms |
Incoterms |
nVarChar |
3 |
- |
|
|
|
| Vehicle |
Vehicle ID |
nVarChar |
10 |
- |
|
|
|
| VidState |
Vehicle ID (State) |
nVarChar |
3 |
- |
|
|
|
| NfRef |
Nota Fiscal Reference |
nVarChar |
254 |
- |
|
|
|
| Carrier |
Carrier Code |
nVarChar |
15 |
- |
|
|
|
| QoP |
Quantity of Packs |
Int |
11 |
- |
|
|
|
| PackDesc |
Pack Description |
nVarChar |
10 |
- |
|
|
|
| Brand |
Brand |
nVarChar |
20 |
- |
|
|
|
| NoSU |
Number of Shipping Unit |
Int |
11 |
- |
|
|
|
| NetWeight |
Net Weight |
Num |
19.6 |
- |
|
|
|
| GrsWeight |
Gross Weight |
Num |
19.6 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjectType |
Object Type |
nVarChar |
20 |
ADP1 |
19 |
|
|
| TaxId10 |
Tax ID 10 |
nVarChar |
100 |
- |
|
|
|
| TransCat |
Transaction Category |
nVarChar |
100 |
- |
|
|
|
| FormNo |
Form No. |
nVarChar |
100 |
- |
|
|
|
| TaxId11 |
Tax ID 11 |
nVarChar |
100 |
- |
|
|
|
| StreetS |
Street |
nVarChar |
100 |
- |
|
|
|
| BlockS |
Block |
nVarChar |
100 |
- |
|
|
|
| BuildingS |
Building/Floor/Room |
Text |
16 |
- |
|
|
|
| CityS |
City |
nVarChar |
100 |
- |
|
|
|
| ZipCodeS |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| CountyS |
County |
nVarChar |
100 |
- |
|
|
|
| StateS |
State |
nVarChar |
3 |
OCST |
|
|
|
| CountryS |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| AddrTypeS |
Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNoS |
Street No. |
nVarChar |
100 |
- |
|
|
|
| StreetB |
Street |
nVarChar |
100 |
- |
|
|
|
| BlockB |
Block |
nVarChar |
100 |
- |
|
|
|
| BuildingB |
Building/Floor/Room |
Text |
16 |
- |
|
|
|
| CityB |
City |
nVarChar |
100 |
- |
|
|
|
| ZipCodeB |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| CountyB |
County |
nVarChar |
100 |
- |
|
|
|
| StateB |
State |
nVarChar |
3 |
OCST |
|
|
|
| CountryB |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| AddrTypeB |
Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNoB |
Street No. |
nVarChar |
100 |
- |
|
|
|
| ImpORExp |
Import or Export |
VarChar |
1 |
- |
|
N |
|
| |
|
|
|
|
|
Y |
|
| Vat |
VAT |
VarChar |
1 |
- |
N |
N |
No VAT Support |
| |
|
|
|
|
|
Y |
VAT Support |
| AltCrdNamB |
Alternative BP Name |
nVarChar |
200 |
- |
|
|
|
| AltTaxIdB |
Alternative Tax ID |
nVarChar |
32 |
- |
|
|
|
| Address2S |
Address Name 2 |
nVarChar |
50 |
- |
|
|
|
| Address3S |
Address Name 3 |
nVarChar |
50 |
- |
|
|
|
| Address2B |
Address Name 2 |
nVarChar |
50 |
- |
|
|
|
| Address3B |
Address Name 3 |
nVarChar |
50 |
- |
|
|
|
| MainUsage |
Main Usage Code of Document |
Int |
11 |
OUSG |
|
|
|
| GlbLocNumS |
Global Location Number |
nVarChar |
50 |
- |
|
|
|
| GlbLocNumB |
Global Location Number |
nVarChar |
50 |
- |
|
|
|
| CollectDT |
Date and Time of Collection |
nVarChar |
20 |
- |
|
|
|
| TransprtDT |
Transport Starting Date |
Date |
8 |
- |
|
|
|
| TransprtRS |
Transport Reason |
nVarChar |
100 |
- |
|
|
|
| TaxId12 |
Tax ID 12 |
nVarChar |
50 |
- |
|
|
|
| TaxId13 |
Deductee Ref. No. in India |
nVarChar |
100 |
- |
|
|
|
| ImpExpNo |
Import/Export Bill No. |
nVarChar |
100 |
- |
|
|
|
| ImpExpDate |
Import/Export Date |
Date |
8 |
- |
|
|
|
| BpGSTType |
GST Regn Type of BP |
Int |
11 |
- |
|
|
|
| BpGSTN |
GST Regn No of BP |
nVarChar |
15 |
- |
|
|
|
| BpStateCod |
State Code of Business Partner |
nVarChar |
3 |
OCST |
|
|
|
| BPStatGSTN |
GST State Code of BP |
nVarChar |
2 |
- |
|
|
|
| LocGSTType |
GST Regn Type of Location |
Int |
11 |
- |
|
|
|
| LocGSTN |
GST Regn No of Location |
nVarChar |
15 |
- |
|
|
|
| LocStatCod |
State Code of Location |
nVarChar |
3 |
OCST |
|
|
|
| LocStaGSTN |
GST State Code of Location |
nVarChar |
2 |
- |
|
|
|
| BpCountry |
Country/Region Code of BP |
nVarChar |
3 |
OCRY |
|
|
|
| OrigImpNo |
Original Bill of Entry No. |
nVarChar |
100 |
- |
|
|
|
| OrigImpDat |
Original Bill of Entry Date |
Date |
8 |
- |
|
|
|
| ExportType |
Exporting Type |
VarChar |
1 |
- |
E |
E |
Imports/Exports |
| |
|
|
|
|
|
S |
SEZ Developer |
| |
|
|
|
|
|
U |
SEZ Unit |
| |
|
|
|
|
|
D |
Deemed Imports/Exports |
| PortCode |
Port Code |
nVarChar |
100 |
- |
|
|
|
| BoEValue |
Bill of Entry Value |
Num |
19.6 |
- |
|
|
|
| IsIGSTAct |
Supply under IGST Account |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ClaimRefun |
Claim Refund |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxRateDif |
Differential % of Tax Rate |
Int |
11 |
- |
|
65 |
|
| |
|
|
|
|
|
100 |
|
| BPGdsIssP |
Goods Issue Place BP |
nVarChar |
15 |
- |
|
|
|
| CNPJGIP |
Goods Issue Place CNPJ |
nVarChar |
100 |
- |
|
|
|
| CPFGIP |
Goods Issue Place CPF |
nVarChar |
100 |
- |
|
|
|
| StreetGIP |
Goods Issue Place Street |
nVarChar |
100 |
- |
|
|
|
| StrtNoGIP |
Goods Issue Place Street No. |
nVarChar |
100 |
- |
|
|
|
| BldngGIP |
Goods Issue Place Building |
Text |
16 |
- |
|
|
|
| ZipGIP |
Goods Issue Place Zip Code |
nVarChar |
20 |
- |
|
|
|
| BlockGIP |
Goods Issue Place Block |
nVarChar |
100 |
- |
|
|
|
| CityGIP |
Goods Issue Place City |
nVarChar |
100 |
- |
|
|
|
| CountyGIP |
Goods Issue Place County |
nVarChar |
100 |
- |
|
|
|
| StateGIP |
Goods Issue Place State |
nVarChar |
3 |
OCST |
|
|
|
| CountryGIP |
Goods Issue Place Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| PhoneGIP |
Goods Issue Place Phone |
nVarChar |
20 |
- |
|
|
|
| EMailGIP |
Goods Issue Place E-Mail |
nVarChar |
100 |
- |
|
|
|
| DptDateGIP |
Goods Issue Place Departure Date |
Date |
8 |
- |
|
|
|
| BPDelivryP |
Delivery Place BP |
nVarChar |
15 |
- |
|
|
|
| CNPJDlvryP |
Delivery Place CNPJ |
nVarChar |
100 |
- |
|
|
|
| CPFDlvryP |
Delivery Place CPF |
nVarChar |
100 |
- |
|
|
|
| StrtDlvryP |
Delivery Place Street |
nVarChar |
100 |
- |
|
|
|
| StrNoDlvrP |
Delivery Place Street No. |
nVarChar |
100 |
- |
|
|
|
| BldDlvryP |
Delivery Place Building |
Text |
16 |
- |
|
|
|
| ZipDlvryP |
Delivery Place Zip Code |
nVarChar |
20 |
- |
|
|
|
| BlckDlvryP |
Delivery Place Block |
nVarChar |
100 |
- |
|
|
|
| CityDlvryP |
Delivery Place City |
nVarChar |
100 |
- |
|
|
|
| CntyDlvryP |
Delivery Place County |
nVarChar |
100 |
- |
|
|
|
| StatDlvryP |
Delivery Place State |
nVarChar |
3 |
OCST |
|
|
|
| CtryDlvryP |
Delivery Place Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| FoneDlvryP |
Delivery Place Phone |
nVarChar |
20 |
- |
|
|
|
| MailDlvryP |
Delivery Place E-Mail |
nVarChar |
100 |
- |
|
|
|
| DpDtDlvryP |
Delivery Place Departure Date |
Date |
8 |
- |
|
|
|
| AuthedCNPJ |
Authorized CNPJ or CPF |
nVarChar |
250 |
- |
|
|
|
| TaxId14 |
ITR Filing |
nVarChar |
250 |
- |
|
|
|