📚 SAP Business One SDK Help

Table Name: IPF1

Table Description: Landed Costs - Rows

Field Description Type Size Related Default Value Constraints
DocEntry Landed Costs Internal ID Int 11 OIPF      
LineNum Row Number Int 11 -      
BaseType Base Document Type Int 11 - -1 -1  
            0  
            20 Goods Receipt PO
            69 Landed Costs
            18 A/P Invoice
BaseEntry Base Document Internal ID Int 11 -      
ItemCode Item No. nVarChar 50 OITM      
Dscription Item Description nVarChar 200 -      
Quantity Quantity Num 19.6 -      
PriceFOB Base Doc. Price Num 19.6 -      
Currency Price Currency nVarChar 3 -      
Rate Currency Price Num 19.6 -      
Custom Projected Customs Num 19.6 -      
CustomFC Projected Customs (FC) Num 19.6 -      
Cost Expenditure Num 19.6 -      
CostFC Freight (FC) Num 19.6 -      
PriceAtWH Whse Price Num 19.6 -      
PricAtWHFC Whse Price (FC) Num 19.6 -      
LineTotal Row Total Num 19.6 -      
TotalFrgn Row Total (FC) Num 19.6 -      
Volume Volume Num 19.6 -      
UnitCode Volume UoM Int 6 OLGT      
Weight1 Weight 1 Num 19.6 -      
UnitCode1 Unit of Weight 1 Int 6 OWGT      
Weight2 Weight 2 Num 19.6 -      
UnitCode2 Unit of Weight 2 Int 6 OWGT      
CardCode Vendor Code nVarChar 15 OCRD      
Reference Reference nVarChar 16 -      
OrigLine Base Line Number Int 11 -      
FactNoCust Factor Without Customs Num 19.6 -      
FacWthCust Factor with Customs Num 19.6 -      
PriceList Price List No. Int 6 OPLN      
CostOH Cost Surcharge VarChar 1 - Y Y Yes
            N No
StockEval Use for Inventory Valuation VarChar 1 - Y Y Yes
            N No
UseBaseUn Inventory UoM VarChar 1 -   Y Yes
            N No
BlockNum Block No. nVarChar 100 -      
ImportLog Import Log nVarChar 20 -      
WhsCode Warehouse Code nVarChar 8 OWHS      
OrigRow Original Row Int 11 -      
Locked Locked VarChar 1 - N Y Yes
            N No
OrigWhs Original Warehouse nVarChar 8 OWHS      
ReleaseNum Release Number Int 11 -      
VarCosts Variant Costs Num 19.6 -      
ConstCosts Fixed Costs Num 19.6 -      
VarCostsFR Variant Costs (FC) Num 19.6 -      
CnstCostFR Fixed Costs (FC) Num 19.6 -      
UserCustom User Expected Custom Num 19.6 -      
UsrCusomFC User Expected Foreign Custom Num 19.6 -      
FobValue Base Doc. Value Row Total (LC) Num 19.6 -      
FobValueFC Base Doc. Value Row Total (FC) Num 19.6 -      
TtlExpndLC Allocated Unit Costs Row Total Num 19.6 -      
TtlExpndFC Allocated Unit Costs Row Total Num 19.6 -      
TtlCustLC Allocated Unit Costs Row Total Num 19.6 -      
TtlCustFC Allocated Unit Costs Row Total Num 19.6 -      
TtlCostLC Row Ttl Cust + Alloc Costs LC Num 19.6 -      
TtlCostFC Row Ttl Cust + Alloc Costs FC Num 19.6 -      
TtlVolume Volume Row Total Num 19.6 -      
TtlWeight Weight Row Total Num 19.6 -      
BaseRowNum use IPF1_BASE_LINE_NUM instead Int 11 -      
TtlCustSC Ttl Row Projected Customs (SC) Num 19.6 -      
TtlExpndSC Allocated Costs Row Total (SC) Num 19.6 -      
OriBAbsEnt Original Base Doc. Internal ID Int 11 - -1    
OriBLinNum Original Base Doc. Row No. Int 11 - -1    
TargetDoc Target Document Internal No. Int 11 -      
FobValCurr Base Doc. Value Currency nVarChar 3 -      
FobnLaC FOB and Included Costs (LC) Num 19.6 -      
FobnLaCFC FOB and Included Costs (FC) Num 19.6 -      
NumPerMsr UoM Value Num 19.6 -      
Project Project Code nVarChar 20 OPRJ      
OcrCode Distribution Rule nVarChar 8 OOCR      
OcrCode2 Distribution Rule 2 nVarChar 8 OOCR      
OcrCode3 Distribution Rule 3 nVarChar 8 OOCR      
OcrCode4 Distribution Rule 4 nVarChar 8 OOCR      
OcrCode5 Distribution Rule 5 nVarChar 8 OOCR      
OriBDocTyp Original Base Document Type nVarChar 11 - -1 -1  
            18 A/P Invoice
            20 Goods Receipt PO
CustRate Custom Group Rate Num 19.6 -      
LFixCost Locked Fixed Cost Num 19.6 -      
LFixCostFC Locked Fixed Cost (FC) Num 19.6 -      
LVarCost Locked Variable Cost Num 19.6 -      
LVarCostFC Locked Variable Cost (FC) Num 19.6 -      
CstmsRate Customs Rate Num 19.6 -      
VatGroup VAT Code nVarChar 8 -      
VatPrcnt VAT Rate per Row Num 19.6 -      
VatSum Total of VAT Num 19.6 -      
SnbType Batch or Serial Type nVarChar 20 - -1 -1  
            10000045 Serial
            10000044 Batch
SnbAbsEnt SnB Abs. Entry Int 11 - -1    
SysNumber System Number Int 11 -      
DistNumber Distinct Number nVarChar 36 -      
ExciseSum Sum of Excise Num 19.6 -      
ExcisSumFC Sum of Excise - FC Num 19.6 -      
ExcInStk Is Excise in Stock VarChar 1 - N Y Yes
            N No
CustomSum Sum of Customs Cost Num 19.6 -      
CustSumFC Sum of Customs Cost in FC Num 19.6 -      
CstmInStk Is Customs in Stock VarChar 1 - Y Y Yes
            N No
CstmVatSum Sum of Customs Cost VAT Num 19.6 -      
CstmVatFC Sum of Customs Cost VAT in FC Num 19.6 -      
CstmVatStk Is Customs VAT in Stock VarChar 1 - Y Y Yes
            N No
CCDEntry CCD Abs. Entry Int 11 -      
CCDNumber Number of CCD nVarChar 20 -      
ExcisSumSC Sum of Excise - SC Num 19.6 -      
CustSumSC Sum of Customs Cost in SC Num 19.6 -      
CstmVatSC Sum of Customs Cost VAT in SC Num 19.6 -      
InvQty Inventory Quantity Num 19.6 -      
CCDLineNum CCD Row Number Int 11 -      
TtlVolCCM Volume Row Total per CCM Num 19.6 -      
ExcImpQty Excise Imported Quantity Num 19.6 -      
ExcFixAmnt Excise Fixed Amount Num 19.6 -      
ExcRate Excise Rate Num 19.6 -      
ExcAmntUoM Excise Amount UoM Num 19.6 -      
ExcAmntAdV Excise Amount Ad Valorem Num 19.6 -      
ExcImpQUoM Excise Imported Quantity UoM Int 11 -      
            112 Liters, m3
            168 Tonne, metric ton (1000 kg)
            251 Horsepower (1 hp = 0.75 kW)
            831 Liters of anhydrous (pure) alcohol
ExcBasAmnt Excise Base Amount Num 19.6 -      
LineNumV3 Target VAT Row Number in IPF3 Int 11 IPF3      
FobVal2 Corrected Base Doc. Value Row Total (LC) Num 19.6 - 0    
FobVal2FC Corrected Base Doc. Value Row Total (FC) Num 19.6 - 0    
EncryptIV Encrypt IV nVarChar 100 -      
UoMNum UoM Item Per Unit Numerator Num 19.6 -      
UoMDen UoM Item Per Unit Denominator Num 19.6 -      
Key Unique Field
PRIMARY Yes DocEntry
    LineNum
BASE No BaseEntry
    OrigLine
ITEM No BaseEntry
    ItemCode
CURRENCY No Currency
BASE_LINE No BaseType
    BaseEntry
    OrigLine