📚 SAP Business One SDK Help

Table Name: RPD12

Table Description: Goods Return - Tax Extension

Field Description Type Size Related Default Value Constraints
DocEntry Document Internal ID Int 11 ORPD      
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 21    
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 -      
StreetR Street for Return nVarChar 100 -      
BlockR Block for Return nVarChar 100 -      
BuildingR Building / Floor / Room for Return Text 16 -      
CityR City for Return nVarChar 100 -      
ZipCodeR Zip Code for Return nVarChar 20 -      
CountyR County for Return nVarChar 100 -      
StateR State for Return nVarChar 3 OCST      
CountryR Country/Region for Return nVarChar 3 OCRY      
AddrTypeR Address Type for Return nVarChar 100 -      
StreetNoR Street No. for Return nVarChar 100 -      
Address2R Address Name 2 for Return nVarChar 50 -      
Address3R Address Name 3 for Return nVarChar 50 -      
GlbLocNumR Global Location Number for Return nVarChar 50 -      
Key Unique Field
PRIMARY Yes DocEntry