📚 SAP Business One SDK Help

Table Name: OTCX

Table Description: Tax Code Determination

Field Description Type Size Related Default Value Constraints
DocEntry Internal Document ID Int 11 -      
LineNum Row Number Int 11 -      
DocType Document Type Int 11 -   0 Item
            1 Service
            2 Item & Service
BusArea Business Area Int 11 -   0 Sales
            1 Purchase
            2 Sales & Purchase
Cond1 Condition 1 Int 11 -   0  
            1 Federal Tax ID
            2 Ship-To Address
            3 Ship-To Street / PO Box
            4 Ship-To City
            5 Ship-To ZIP Code
            6 Ship-To County
            7 Ship-To State
            8 Ship-to Country/Region
            9 Item
            10 Item Group
            11 Business Partner
            12 Customer Group
            13 Vendor Group
            14 Warehouse
            15 G/L Account
            16 Customer Equalization tax
            17 Tax Status
            18 Freight
            19 UDF
            20 Branch
            21 Type of Business
UDFTable1 UDF Table Name nVarChar 20 -      
NumVal1 Numeric Value Int 11 -      
StrVal1 String Value nVarChar 100 -      
MnyVal1 Monetary Value Num 19.6 -      
Cond2 Condition 2 Int 11 -   0  
            1 Federal Tax ID
            2 Ship-To Address
            3 Ship-To Street / PO Box
            4 Ship-To City
            5 Ship-To ZIP Code
            6 Ship-To County
            7 Ship-To State
            8 Ship-to Country/Region
            9 Item
            10 Item Group
            11 Business Partner
            12 Customer Group
            13 Vendor Group
            14 Warehouse
            15 G/L Account
            16 Customer Equalization tax
            17 Tax Status
            18 Freight
            19 UDF
            20 Branch
            21 Type of Business
UDFTable2 UDF Table Name nVarChar 20 -      
NumVal2 Numeric Value Int 11 -      
StrVal2 String Value nVarChar 100 -      
MnyVal2 Monetary Value Num 19.6 -      
Cond3 Condition 3 Int 11 -   0  
            1 Federal Tax ID
            2 Ship-To Address
            3 Ship-To Street / PO Box
            4 Ship-To City
            5 Ship-To ZIP Code
            6 Ship-To County
            7 Ship-To State
            8 Ship-to Country/Region
            9 Item
            10 Item Group
            11 Business Partner
            12 Customer Group
            13 Vendor Group
            14 Warehouse
            15 G/L Account
            16 Customer Equalization tax
            17 Tax Status
            18 Freight
            19 UDF
            20 Branch
            21 Type of Business
UdfTable3 UDF Table Name nVarChar 20 -      
NumVal3 Numeric Value Int 11 -      
StrVal3 String Value nVarChar 100 -      
MnyVal3 Monetary Value Num 19.6 -      
Cond4 Condition 4 Int 11 -   0  
            1 Federal Tax ID
            2 Ship-To Address
            3 Ship-To Street / PO Box
            4 Ship-To City
            5 Ship-To ZIP Code
            6 Ship-To County
            7 Ship-To State
            8 Ship-to Country/Region
            9 Item
            10 Item Group
            11 Business Partner
            12 Customer Group
            13 Vendor Group
            14 Warehouse
            15 G/L Account
            16 Customer Equalization tax
            17 Tax Status
            18 Freight
            19 UDF
            20 Branch
            21 Type of Business
UdfTable4 UDF Table Name nVarChar 20 -      
NumVal4 Numeric Value Int 11 -      
StrVal4 String Value nVarChar 100 -      
MnyVal4 Monetary Value Num 19.6 -      
Cond5 Condition 5 Int 11 -   0  
            1 Federal Tax ID
            2 Ship-To Address
            3 Ship-To Street / PO Box
            4 Ship-To City
            5 Ship-To ZIP Code
            6 Ship-To County
            7 Ship-To State
            8 Ship-to Country/Region
            9 Item
            10 Item Group
            11 Business Partner
            12 Customer Group
            13 Vendor Group
            14 Warehouse
            15 G/L Account
            16 Customer Equalization tax
            17 Tax Status
            18 Freight
            19 UDF
            20 Branch
            21 Type of Business
UdfTable5 UDF Table Name nVarChar 20 -      
NumVal5 Numeric Value Int 11 -      
StrVal5 String Value nVarChar 100 -      
MnyVal5 Monetary Value Num 19.6 -      
Descr Description nVarChar 250 -      
LnTaxCode Line Tax Code nVarChar 8 -      
FrLnTax Line Freight Tax nVarChar 8 -      
FrHdrTax Header Freight Tax nVarChar 8 -      
UDFAlias1 UDF Field Alias nVarChar 18 -      
UDFAlias2 UDF Field Alias nVarChar 18 -      
UDFAlias3 UDF Field Alias nVarChar 18 -      
UDFAlias4 UDF Field Alias nVarChar 18 -      
UDFAlias5 UDF Field Alias nVarChar 18 -      
LogInstanc Log Instance Int 11 -      
UpdateDate Update Date Date 8 -      
UserSign User Signature Int 6 OUSR      
UserSign2 Update User Int 6 OUSR      
Key Unique Field
PRIMARY Yes DocEntry