📚 SAP Business One SDK Help

Table Name: OIPF

Table Description: Landed Costs

Field Description Type Size Related Default Value Constraints
DocEntry Internal Number Int 11 -      
DocNum Document Number Int 11 -      
DocDate Posting Date Date 8 -      
DocDueDate Due Date Date 8 -      
CardCode Vendor Code nVarChar 15 OCRD      
SuppName Vendor Name nVarChar 200 -      
AgentCode Subst. Code nVarChar 15 OCRD      
AgentName Subst. Name nVarChar 200 -      
DocStatus Document Status VarChar 1 - O C Closed
            O Open
AgentNum File Number nVarChar 16 -      
Descr Remarks nVarChar 250 -      
Ref1 Reference 1 nVarChar 11 -      
Ref2 Reference 2 nVarChar 11 -      
DocCur Document Currency nVarChar 3 -      
DocRate Document Rate Num 19.6 -      
ExpCustom Projected Customs Num 19.6 -      
ActCustom Act. Import Duty Num 19.6 -      
Vat1 Tax 2 Num 19.6 -      
Vat2 Tax 2 Num 19.6 -      
BeforeVat Total Before Tax Num 19.6 -      
DocTotal Document Total Num 19.6 -      
CostSum Total Costs Num 19.6 -      
DocTime Generation Time Int 6 -      
Canceled Canceled VarChar 1 - N Y Yes
            N No
ExCustomFC Projected Customs (FC) Num 19.6 -      
AcCustomFC Act. Import Duty in FC Num 19.6 -      
Vat1FC Tax 1 (FC) Num 19.6 -      
Vat2FC Tax 2 (FC) Num 19.6 -      
BeforVatFC Total Before Tax (FC) Num 19.6 -      
DocTotalFC Document Total (FC) Num 19.6 -      
CostSumFC Total Costs (FC) Num 19.6 -      
CloseDate Closing Date Date 8 -      
Cost_Match Expenses Diff. for Reconciliation Num 19.6 -      
C_Match_FC Expenses Diff. for Recon. (FC) Num 19.6 -      
BillOfLad Bill of Lading No. nVarChar 20 -      
TrnspCode Delivery Category Int 6 OSHP      
CostFactor Expenses Factor Num 19.6 -      
UpdateDate Date of Update Date 8 -      
CreateDate Creation Date Date 8 -      
Transfered Year Transfer VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 - 0    
TaxDate Document Date Date 8 -      
Series Series Int 11 -      
JdtNum Journal Number Int 11 OJDT      
JdtMemo Transaction Details nVarChar 254 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
ObjType Object Type nVarChar 20 ADP1 69    
ExCustomSC Projected Customs (SC) Num 19.6 -      
ActCustSC Actual Customs (SC) Num 19.6 -      
TtlCostSC Total Expenditure (SC) Num 19.6 -      
VersionNum Version Number nVarChar 13 -      
OpenForLaC Open For Landed Costs VarChar 1 - Y Y Yes
            N No
incCustom Include Customs Expenses VarChar 1 - Y    
SeqCode Sequence Code Int 6 -      
Serial Serial Number Int 11 -      
SeriesStr Series String nVarChar 3 -      
SubStr Subseries String nVarChar 3 -      
BuildDesc Build Descriptor nVarChar 50 -      
SupplCode Supplementary Code nVarChar 254 -      
AtcEntry Attachment Entry Int 11 -      
CustDate Customs Date Date 8 -      
BPLId Branch Int 11 OBPL      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
EncryptIV Encrypt IV nVarChar 100 -      
OwnerCode Document Owner Int 11 OHEM      
Key Unique Field
PRIMARY Yes DocEntry
NUM Yes DocNum
    Instance
    Series
SUPPLIER No CardCode
AGENT No AgentCode
    AgentNum
CURRENCY No DocCur
SERIES No Series
OWNER_CODE No OwnerCode