📚 SAP Business One SDK Help

Table Name: BTF1

Table Description: Journal Voucher - Rows

Field Description Type Size Related Default Value Constraints
TransId Transaction Key Int 11 OJDT      
Line_ID Row Number Int 11 - 0    
Account Account Code nVarChar 15 OACT      
Debit Debit Amount Num 19.6 -      
Credit Credit Amount Num 19.6 -      
SYSCred System Credit Amount Num 19.6 -      
SYSDeb System Debit Amount Num 19.6 -      
FCDebit FC Debit Amount Num 19.6 -      
FCCredit FC Credit Amount Num 19.6 -      
FCCurrency Foreign Currency nVarChar 3 -      
DueDate Due Date Date 8 -      
SourceID Source Key Int 11 -      
SourceLine Source Row Number Int 6 -      
ShortName Card/Account Code nVarChar 15 -      
IntrnMatch Internal Reconciliation No. Int 11 - 0    
ExtrMatch External Reconciliation No. Int 11 - 0    
ContraAct Offset Account nVarChar 15 -      
LineMemo Row Details nVarChar 254 -      
Ref3Line Reference 3 nVarChar 200 -      
TransType Original Journal nVarChar 20 - -1 -1  
RefDate Posting Date Date 8 -      
Ref2Date Posting Date 2 Date 8 -      
Ref1 Reference 1 nVarChar 200 -      
Ref2 Reference 2 nVarChar 200 -      
CreatedBy Origin Int 11 -      
BaseRef Base Reference nVarChar 11 -      
Project Project Code nVarChar 20 OPRJ      
TransCode Transaction Code nVarChar 4 OTRC      
ProfitCode Distribution Rule nVarChar 8 OOCR      
TaxDate Document Date Date 8 -      
SystemRate System Price Num 19.6 -      
MthDate Reconciliation Date Date 8 -      
ToMthSum Reconciliation Total Num 19.6 -      
UserSign User Signature Int 6 OUSR      
BatchNum Journal Voucher No. Int 11 OBTD      
FinncPriod Posting Period Int 11 OFPR      
RelTransId Linked Transaction Key Int 11 - -1    
RelLineID Linked Row No. Int 11 - -1    
RelType Link Type VarChar 1 - N N Without Link
            D WTax Deduction - Correction
LogInstanc Log Instance Int 11 - 0    
VatGroup Tax Group nVarChar 8 OVTG      
BaseSum Base Amount Num 19.6 -      
VatRate Tax % Num 19.6 -      
Indicator Indicator Code nVarChar 2 OIDC      
AdjTran Adjusting Trans. (Period 13) VarChar 1 - N Y Yes
            N No
RevSource Revaluation Source VarChar 1 - N F FC
            S System
            N No
ObjType Object Type nVarChar 20 ADP1 30    
VatDate Document Date Date 8 -      
PaymentRef Payment Reference nVarChar 27 -      
SYSBaseSum System Base Amount Num 19.6 -      
MultMatch Multiple BP Reconciliation No. Int 11 - 0    
VatLine VAT Row VarChar 1 - N Y Yes
            N No
VatAmount VAT Amount Num 19.6 -      
SYSVatSum System VAT Amount Num 19.6 -      
Closed Closed VarChar 1 - N    
GrossValue Gross Value Num 19.6 -      
CheckAbs Internal Check No. Int 11 -      
LineType LineType Int 11 - 0    
DebCred Debit Credit Line Indicator VarChar 1 -   D Debit
            C Credit
SequenceNr Assigned Sequence No. Int 11 - 0    
StornoAcc Storno Account Code nVarChar 15 OACT      
BalDueDeb Balance Due - Debit Num 19.6 -      
BalDueCred Balance Due - Credit Num 19.6 -      
BalFcDeb Balance Due FC - Debit Num 19.6 -      
BalFcCred Balance Due FC - Credit Num 19.6 -      
BalScDeb Balance Due SC - Debit Num 19.6 -      
BalScCred Balance Due SC - Credit Num 19.6 -      
IsNet Is Net VarChar 1 - Y Y Yes
            N No
DunWizBlck Wizard Dunning Block VarChar 1 - N N No
            Y Yes
               
DunnLevel Dunning Level Int 11 ODUN 0    
DunDate Last Dunning Date Date 8 -      
TaxType Tax Type Int 6 - 0    
TaxPostAcc Tax Posting Account VarChar 1 - N N  
            R Sales Tax Account
            P Purchasing Tax Account
StaCode Authority Code nVarChar 8 OSTA      
StaType Authority Type Int 11 OSTT      
TaxCode Tax Code nVarChar 8 OSTC      
ValidFrom Valid From Date 8 - 19000101    
GrossValFc Gross Value (FC) Num 19.6 -      
LvlUpdDate Dunning Level Update Date Date 8 -      
OcrCode2 Costing Code 2 nVarChar 8 OOCR      
OcrCode3 Costing Code 3 nVarChar 8 OOCR      
OcrCode4 Costing Code 4 nVarChar 8 OOCR      
OcrCode5 Costing Code 5 nVarChar 8 OOCR      
MIEntry MI Entry when include this OB Int 11 - 0    
MIVEntry A/P Monthly Invoice Int 11 - 0    
ClsInTP Tax Payment Wizard Int 11 - 0    
CenVatCom CENVAT Component Int 11 - -1    
MatType Material Type Int 11 - -1    
PstngType Posting Type Int 11 - 0    
ValidFrom2 Valid from2 Date 8 - 19000101    
ValidFrom3 Valid from3 Date 8 - 19000101    
ValidFrom4 Valid from4 Date 8 - 19000101    
ValidFrom5 Valid from5 Date 8 - 19000101    
Location Loc. Int 11 OLCT      
WTaxCode Withholding Tax Code nVarChar 4 OWHT      
EquVatRate Equalization Tax % Num 19.6 -      
EquVatSum Equalization Tax Amount Num 19.6 -      
SYSEquSum System Equalization Tax Amount Num 19.6 -      
TotalVat Total Tax Num 19.6 -      
SYSTVat System Total Tax Num 19.6 -      
WTLiable WTax-Liable VarChar 1 - N Y Yes
            N No
WTLine WTax Row VarChar 1 - N Y Yes
            N No
WTApplied Applied WTax Num 19.6 -      
WTAppliedS Applied WTax (SC) Num 19.6 -      
WTAppliedF Applied WTax (FC) Num 19.6 -      
WTSum WTax Amount Num 19.6 -      
WTSumFC WTax Amount (FC) Num 19.6 -      
WTSumSC WTax Amount (SC) Num 19.6 -      
PayBlock Payment Block VarChar 1 - N Y Yes
            N No
PayBlckRef Payment Block Abs Entry Int 11 OPYB      
LicTradNum Federal Tax ID nVarChar 32 -      
InterimTyp Interim Account Type Int 11 - 0    
DprId Down Payment Request Key Int 11 -      
MatchRef Reconciliation Reference nVarChar 20 -      
Ordered Payment Ordered VarChar 1 - N Y Yes
            N No
CUP Unique Code of Project Int 11 OCUP      
CIG Contract Code Identification Int 11 OCIG      
BPLId Branch Int 11 OBPL      
BPLName Branch Name nVarChar 200 -      
VatRegNum VAT Reg. Number nVarChar 32 -      
SLEDGERF Subledger Flag VarChar 1 -      
InitRef2 Initial Reference 2 nVarChar 100 -      
InitRef3Ln Initial Reference 3 nVarChar 27 -      
ExpUUID Expense UUID nVarChar 50 -      
ExpOPType Expense Operation Type VarChar 1 -   P Professional Services
            R Renting Assets
            O Others
               
            D Disposal of Goods
            S Import of Goods and Services
            V Import by Virtual Transfer
            G Global Operations
ExTransId Exposed Transaction ID Int 11 -      
DocArr Source of Posting Int 6 -      
DocLine Source Line Internal ID Int 11 -      
MYFtype MYF type nVarChar 2 -   S1 MYF Wholesale Sales
            S2 Retail Sales
            P1 MYF Wholesale Purchases
            P3 Other Expense Transactions
DocEntry Source Document Entry Int 11 -      
DocNum Source Document Number Int 11 -      
DocType Source Document Type nVarChar 20 -      
DocSubType Document Subtype nVarChar 2 -      
RmrkTmpt Remark Text Template Int 11 OTTR      
CemCode Cost Element Code nVarChar 20 -      
InClassCat Income Classification Category Int 11 -      
InClassTyp Income Classification Type Int 11 -      
ExClassCat Expense Classification Category Int 11 -      
ExClassTyp Expense Classification Type Int 11 -      
VATClassCa VAT Classification Category Int 11 -      
VATClassTy VAT Classification Type Int 11 -      
EVatCate VAT Category Int 11 -      
EWtPercCat Withheld Percentage Category Int 11 -      
EWtAmount Withheld Amount Num 19.6 -      
EBVatExCau VAT Exemption Cause Int 11 OVEC      
OrgBPName BP name at time of creation. nVarChar 200 -      
OrgAccName Account name at time of creation. nVarChar 200 -      
AllocNum Allocation Number for IL nVarChar 50 -      
EncryptIV Encrypt IV nVarChar 100 -      
EnLicTradN Encrypt TAX ID Number Text 16 -      
Key Unique Field
PRIMARY Yes BatchNum
    TransId
    Line_ID
SHORT_NAME No ShortName
ACCOUNT No Account
BATCH_IDX No BatchNum
CURRENCY No FCCurrency
INTRNMATCH No ShortName
    Account
    IntrnMatch