| 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 |
- |
|
|
|