biuan SAP® BUSINESS ONE SDK
DTW A/P Invoice - Rows
API Document Lines / Ex Line No
PCH1 - A/P Invoice - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEYDocument Internal IDInt
11OPCH
A/P Invoice
VIS_ORDERNo
LineNumRow NumberInt
11
TargetTypeTarget Document TypeInt
-1)
0
19) A/P Credit Memo
20) Goods Receipt
163) A/P Correction Invoice
11
-1
TrgetEntryTarget Document Internal IDInt
11
BaseRefBase Document ReferencenVarChar
16
BaseTypeBase Document TypeInt
-1)
0
22) Purchase Orders
20) Goods Receipt PO
540000006) Purchase Quotation
18) A/P Invoice
69) Landed Costs
11
-1
BaseEntry KEYBase Document Internal IDInt
11
BASE_ENTRYNo
BaseLineBase RowInt
11
LineStatus KEYRow StatusVarChar
O) Open
C) Closed
1
OSTATUSNo
ItemCode KEYItem No.nVarChar
20OITM
Items
ITM_WHS_OQNo
DscriptionItem/Service DescriptionnVarChar
100
QuantityQuantityNum
20
ShipDateRow Delivery DateDate
8
OpenQtyRemaining Open QuantityNum
20
PricePriceNum
20
Currency KEYPrice CurrencynVarChar
3OCRN
Currency Codes
CURRENCYNo
RateCurrency RateNum
20
DiscPrcntDiscount % per RowNum
20
LineTotalRow TotalNum
20
TotalFrgnRow Total (FC)Num
20
OpenSumOpen AmountNum
20
OpenSumFCOpen Amount (FC)Num
20
VendorNumVendor Catalog No.nVarChar
17
SerialNumSerial NumbernVarChar
17
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
SlpCodeSales Employee CodeInt
11OSLP
Sales Employee
-1
CommissionCommission PercentageNum
20
TreeTypeBOM TypeVarChar
N) Not a BOM
A) Assembly
S) Sales
I) Sales BOM Component
P) Production
T) Template
1
N
AcctCode KEYAccount CodenVarChar
15OACT
G/L Accounts
ACCOUNTNo
TaxStatusTax DefinitionVarChar
Y) Yes
N) No
1
GrossBuyPrBase Price for Gross ProfitNum
20
PriceBefDiUnit PriceNum
20
DocDatePosting DateDate
8
FlagsFlagsInt
11
0
OpenCreQtyCredit Memo AmountNum
20
UseBaseUnInventory UoMVarChar
Y) Yes
N) No
1
N
SubCatNumCustomer/Vendor Cat. No.nVarChar
20OSCN
Customer/Vendor Cat. No.
BaseCardBase BP CodenVarChar
15OCRD
Business Partner
TotalSumSyRow Total (SC)Num
20
OpenSumSysOpen Amount (SC)Num
20
InvntSttusWarehouse StatusVarChar
O) Open
C) Closed
1
O
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes
CodeBarsBar CodenVarChar
127
VatPrcntTax Rate per RowNum
20
VatGroupTax DefinitionnVarChar
8OVTG
Tax Definition
PriceAfVATGross PriceNum
20
Height1Height 1Num
20
Hght1UnitUnit of Height 1Int
6
Height2Height 2Num
20
Hght2UnitUnit of Height 2Int
6
Width1Width 1Num
20
Wdth1UnitUnit of Width 1Int
6
Width2Width 2Num
20
Wdth2UnitUnit of Width 2Int
6
Length1Length 1Num
20
Len1UnitUnit of Length 1Int
6
length2Length 2Num
20
Len2UnitUnit of Length 2Int
6
VolumeQuantityNum
20
VolUnitVolume UoMInt
6
Weight1Weight 1Num
20
Wght1UnitUnit of Weight 1Int
6
Weight2Weight 2Num
20
Wght2UnitUnit of Weight 2Int
6
Factor1Factor 1Num
20
Factor2Factor 2Num
20
Factor3Factor 3Num
20
Factor4Factor 4Num
20
PackQtyPacking QuantityNum
20
UpdInvntryWarehouse UpdateVarChar
Y) Yes
N) No
1
Y
BaseDocNumBase Document No.Int
11
BaseAtCardCustomer/Vendor Base DocumentnVarChar
100
SWWAdditional IdentifiernVarChar
16
VatSumTotal TaxNum
20
VatSumFrgnTax Amount (FC)Num
20
VatSumSyTax Amount (SC)Num
20
FinncPriodPosting PeriodInt
11OFPR
Posting Period
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
18
LogInstancLog InstanceInt
11
0
BlockNumBlock NumbernVarChar
100
ImportLogImport LognVarChar
20
DedVatSumDeductible Tax AmountNum
20
DedVatSumFDeductible Tax Amount (FC)Num
20
DedVatSumSDeductible Tax Amount (SC)Num
20
IsAqcuistnAcquisition TaxVarChar
Y) Yes
N) No
1
N
DistribSumDistributed AmountNum
20
DstrbSumFCDistributed Amount (FC)Num
20
DstrbSumSCDistributed Amount (SC)Num
20
GrssProfitRow Gross ProfitNum
20
GrssProfSCRow Gross Profit (SC)Num
20
GrssProfFCRow Gross Profit (FC)Num
20
VisOrderVisual OrderInt
11
INMPriceItem's Last Sales Price (OINM)Num
20
PoTrgNumPO Target No.Int
11
PoTrgEntryPO Target Internal IDnVarChar
11
DropShipDrop-ShipVarChar
Y) Yes
N) No
1
N
PoLineNumPO Target Row No.Int
11
AddressAddressnVarChar
127
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
TaxTypeTax TypeVarChar
Y) Regular Tax
N) No Tax
U) Use Tax
1
OrigItemOriginal ItemnVarChar
20OITM
Items
BackOrdrAllow BackorderVarChar
Y) Yes
N) No
1
FreeTxtFree TextnVarChar
100
PickStatusPick StatusVarChar
Y) Picked
N) Not Picked
R) Released for Picking
P) Partially Picked
1
N
PickOtyPick QuantityNum
20
PickIdNoPick List ID NumberInt
11
TrnsCodeShipping MethodInt
6OSHP
Delivery Types
-1
VatAppldApplied TaxNum
20
VatAppldFCApplied Tax (FC)Num
20
VatAppldSCApplied Tax (SC)Num
20
BaseQtyBase QuantityNum
20
BaseOpnQtyBase Open QuantityNum
20
VatDscntPrTax Discount %Num
20
WtLiableWithholding Tax LiableVarChar
Y) Yes
N) No
1
DeferrTaxDeferred TaxVarChar
Y) Yes
N) No
1
N
EquVatPerEqualization Tax %Num
20
EquVatSumTotal Equalization TaxNum
20
EquVatSumFTotal Equalization Tax (FC)Num
20
EquVatSumSTotal Equalization Tax (SC)Num
20
LineVatNet Tax AmountNum
20
LineVatlFNet Tax AmountNum
20
LineVatSNet Tax AmountNum
20
unitMsrUnitnVarChar
100
NumPerMsrUoM ValueNum
20
CEECFlagCorrection Invoice Was/Should BeVarChar
W) Was
S) Should Be
1
S
ToStockCorr. Invoice Amt to InventoryNum
20
ToDiffCorr. Invoice Amount to Diff.Num
20
ExciseAmtExcise AmountNum
20
TaxPerUnitTax per UnitNum
20
TotInclTaxTotal Including TaxNum
20
CountryOrgCountry of OriginnVarChar
3
StckDstSumStock Distribution SumNum
20
ReleasQttyReleased QuantityNum
20
LineTypeRow TypeVarChar
R) Regular
1
R
TranTypeTransaction TypeVarChar
C) Complete
R) Reject
1
TextTextText
16
OwnerCode KEYDocument OwnerInt
11
OWNER_CODENo
StockPriceInventory PriceNum
20
ConsumeFCTConsumer Sales ForecastVarChar
Y) Yes
N) No
1
LstByDsSumLast Buy Distribute SumNum
20
StckINMPrStock Inm PriceNum
20
LstBINMPrLast Buy Inventory Journal Pr.Num
20
StckDstFcStock Distributed Sum (FC)Num
20
StckDstScStock Distributed Sum (SC)Num
20
LstByDsFcLast Buy Distribute Sum (FC)Num
20
LstByDsScLast Buy Distribute Sum (SC)Num
20
StockSumStock SumNum
20
StockSumFcStock Sum FCNum
20
StockSumScStock Sum SCNum
20
StckSumAppStock Sum AppliedNum
20
StckAppFcStock Sum Applied FCNum
20
StckAppScStock Sum Applied SCNum
20
ShipToCodeShip-to CodenVarChar
50
ShipToDescShip-to DescriptionnVarChar
127
StckAppDStock Distrib. - Applied SumNum
20
StckAppDFCStock Dist. - Applied Sum (FC)Num
20
StckAppDSCStock Dist. - Applied Sum (SC)Num
20
BasePricePrice for Total CalculationVarChar
E) Exclude Tax
I) Include Tax
1
E
GTotalGross TotalNum
20
GTotalFCGross Total (FC)Num
20
GTotalSCGross Total (SC)Num
20
DistribExpDistribute FreightVarChar
Y) Yes
N) No
1
DescOWDescription OverwrittenVarChar
Y) Yes
N) No
1
N
DetailsOWDetails OverwrittenVarChar
Y) Yes
N) No
1
N
GrossBaseBase Method for Gross ProfitInt
6
VatWoDpmTax Before DPM AppliedNum
20
VatWoDpmFcTax Before DPM Applied (FC)Num
20
VatWoDpmScTax Before DPM Applied (SC)Num
20
CFOPCodeCFOP Code for DocumentnVarChar
6OCFP
CFOP for Nota Fiscal
CSTCodeCST Code for ICMSnVarChar
6
UsageUsage Code for DocumentInt
11OUSG
Usage of Nota Fiscal
TaxOnlyTax OnlyVarChar
Y) Yes
N) No
1
WtCalcedWithholding Tax CalculatedVarChar
N) No
Y) Yes
1
N
QtyToShipQuantity to ShipNum
20
DelivrdQtyDelivered QuantityNum
20
OrderedQtyOrdered QuantityNum
20
CogsOcrCodCOGS Distribution Rule CodenVarChar
8OOCR
Distribution Rule
CiOppLineNLine Number of Opposite LineInt
11
-1
CogsAcctCOGS Account CodenVarChar
15OACT
G/L Accounts
ChgAsmBoMWChange Whs for Asm BoM ChildVarChar
Y) Yes
N) No
1
ActDelDateActual Delivery DateDate
8
OcrCode2Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrCode3Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrCode4Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrCode5Costing Code 5nVarChar
8OOCR
Distribution Rule
TaxDistSumTax Distributed AmountNum
20
TaxDistSFCTax Distributed Amount (FC)Num
20
TaxDistSSCTax Distributed Amount (SC)Num
20
PostTaxPost Tax in Price to StockVarChar
Y) Yes
N) No
1
Y
ExcisableExcisable [Yes/No]VarChar
Y) Yes
N) No
1
AssblValueAssessable ValueNum
20
RG23APart1RG23A Part1 NumberInt
11
RG23APart2RG23A Part2 NumberInt
11
RG23CPart1RG23C Part1 NumberInt
11
RG23CPart2RG23C Part2 NumberInt
11
CogsOcrCo2COGS Distribution Rule Code2nVarChar
8OOCR
Distribution Rule
CogsOcrCo3COGS Distribution Rule Code3nVarChar
8OOCR
Distribution Rule
CogsOcrCo4COGS Distribution Rule Code4nVarChar
8OOCR
Distribution Rule
CogsOcrCo5COGS Distribution Rule Code5nVarChar
8OOCR
Distribution Rule
LnExcisedLine ExcisedVarChar
O) Open
C) Closed
P) Copied to OEI
1
LocCodeLocation CodeInt
11OLCT
Location
StockValueTotal COGS ValueNum
20
GPTtlBasPrTotal Base Price for ProfitNum
20
unitMsr2Pur/Sal UoM if BaseUnitnVarChar
100
NumPerMsr2Pur/Sal UoM Value if BaseUnitNum
20
SpecPricePrice Source TypeVarChar
Y) Special Prices for Business Partner
N) Manual
W) Active Price List, Discount Groups
R) Active Price List
U) Inactive Price List
A) Blanket Agreement
P) Period and Volume Discounts
Q) Period and Volume Discounts, Discount Groups
V) Inactive Price List, Discount Groups
9) Special Prices for Business Partner
!) Blanket Agreement
0
1) Period and Volume Discounts, Discount Groups
2) Active Price List
7) Active Price List, Discount Groups
5) Inactive Price List
6) Inactive Price List, Discount Groups
1
N
CSTfIPICST for IPI CodenVarChar
2
CSTfPISCST for PIS CodenVarChar
2
CSTfCOFINSCST for COFINS CodenVarChar
2
ExLineNoExLineNonVarChar
10
isSrvCallCreated from Service CallVarChar
Y) Yes
N) No
1
N
PQTReqQtyPur Quotation: Required QtyNum
20
PQTReqDatePur Quotation: Required DateDate
8
PcDocTypePurchase Confirmation Doc TypeInt
-1) No Type
22) Purchase Order
540000006) Purchase Quotation
11
-1
PcQuantityPurchase Confirmation QuantityNum
20
LinManClsdLine Was Closed ManuallyVarChar
Y) Yes
N) No
U) Unknown
1
N
VatGrpSrcVAT Group SourceVarChar
N) Not Defined
M) Manually Entered
D) Determined
1
N
NoInvtryMvWithout Inventory MovementVarChar
Y) Yes
N) No
1
N
ActBaseEntActual Base Document EntryInt
11
ActBaseLnActual Base Line NumberInt
11
ActBaseNumActual Base Document No.Int
11
OpenRtnQtyQuantity Open for ReturnNum
20
AgrNoAgreement No.Int
11OOAT
Blanket Agreement
AgrLnNumAgreement Row NumberInt
11
CredOriginCredit OriginVarChar
1OBSI
Brazil String Indexer
SurplusesSurplusesNum
20
DefBreakDefect and BreakupNum
20
ShortagesShortagesNum
20
UomEntryUoM EntryInt
11OUOM
UoM Master Data
0
UomEntry2UoM Entry if Base UnitInt
11OUOM
UoM Master Data
0
UomCodeUoM CodenVarChar
20
UomCode2UoM Code if Base UnitnVarChar
20
FromWhsCodFrom Warehouse CodenVarChar
8OWHS
Warehouses
NeedQtyConsider Quantity of ItemsVarChar
Y) Yes
N) No
1
N
PartRetirePartial RetirementVarChar
Y) Yes
N) No
1
N
RetireQtyRetirement QuantityNum
20
RetireAPCRetirement APCNum
20
RetirAPCFCRetirement APC FCNum
20
RetirAPCSCRetirement APC SCNum
20
InvQtyQuantity - Inventory UoMNum
20
OpenInvQtyOpen Quantity (Inventory UoM)Num
20
EnSetCostEnable Set Item Cost in ReturnVarChar
Y) Yes
N) No
1
N
RetCostReturn Cost in A/R ReturnNum
20
IncotermsIncotermsInt
11ODCI
Intrastat Configuration
0
TransModTransport ModeInt
11ODCI
Intrastat Configuration
0
LineVendorLine Vendor CodenVarChar
15OCRD
Business Partner
DistribISDistribute Intrastat FreightVarChar
Y) Yes
N) No
1
N
ISDistrbIntrastat Distrib. AmountNum
20
ISDistrbFCIntrastat Distrib. Amount (FC)Num
20
ISDistrbSCIntrastat Distrib. Amount (SC)Num
20
IsByPrdctItem Is By-ProductVarChar
N) No
Y) Yes
1
N
ItemTypeItem TypeInt
4) Item
11
4
PriceEditPrice Was Edited by UserVarChar
N) No
Y) Yes
1
N
PrntLnNumParent Line NumberInt
11
LinePoPrssLine PO ProcessVarChar
Y) Yes
N) No
1
N
FreeChrgBPFree of Charge (BP)VarChar
Y) Yes
N) No
1
TaxRelevTax Relevant RowVarChar
Y) Yes
N) No
1
Y
LegalTextLegal TextnVarChar
127
ThirdPartyThird PartyVarChar
Y) Yes
N) No
1
N
LicTradNumFederal Tax IDnVarChar
32
InvQtyOnlyChange Qty (Inv. UoM) OnlyVarChar
Y) Yes
N) No
1
N
UnencReasnReason for Unencumbered ICMSInt
11
ShipFromCoShip-From CodenVarChar
50
ShipFromDeShip-From DescriptionnVarChar
127

Table relationship map

SELECT statement

SELECT PCH1.DocEntry AS 'Document Internal ID', PCH1.LineNum AS 'Row Number', PCH1.TargetType AS 'Target Document Type', PCH1.TrgetEntry AS 'Target Document Internal ID', PCH1.BaseRef AS 'Base Document Reference', PCH1.BaseType AS 'Base Document Type', PCH1.BaseEntry AS 'Base Document Internal ID', PCH1.BaseLine AS 'Base Row', PCH1.LineStatus AS 'Row Status', PCH1.ItemCode AS 'Item No.', PCH1.Dscription AS 'Item/Service Description', PCH1.Quantity AS 'Quantity', PCH1.ShipDate AS 'Row Delivery Date', PCH1.OpenQty AS 'Remaining Open Quantity', PCH1.Price AS 'Price', PCH1.Currency AS 'Price Currency', PCH1.Rate AS 'Currency Rate', PCH1.DiscPrcnt AS 'Discount % per Row', PCH1.LineTotal AS 'Row Total', PCH1.TotalFrgn AS 'Row Total (FC)', PCH1.OpenSum AS 'Open Amount', PCH1.OpenSumFC AS 'Open Amount (FC)', PCH1.VendorNum AS 'Vendor Catalog No.', PCH1.SerialNum AS 'Serial Number', PCH1.WhsCode AS 'Warehouse Code', PCH1.SlpCode AS 'Sales Employee Code', PCH1.Commission AS 'Commission Percentage', PCH1.TreeType AS 'BOM Type', PCH1.AcctCode AS 'Account Code', PCH1.TaxStatus AS 'Tax Definition', PCH1.GrossBuyPr AS 'Base Price for Gross Profit', PCH1.PriceBefDi AS 'Unit Price', PCH1.DocDate AS 'Posting Date', PCH1.Flags AS 'Flags', PCH1.OpenCreQty AS 'Credit Memo Amount', PCH1.UseBaseUn AS 'Inventory UoM', PCH1.SubCatNum AS 'Customer/Vendor Cat. No.', PCH1.BaseCard AS 'Base BP Code', PCH1.TotalSumSy AS 'Row Total (SC)', PCH1.OpenSumSys AS 'Open Amount (SC)', PCH1.InvntSttus AS 'Warehouse Status', PCH1.OcrCode AS 'Distribution Rule', PCH1.Project AS 'Project Code', PCH1.CodeBars AS 'Bar Code', PCH1.VatPrcnt AS 'Tax Rate per Row', PCH1.VatGroup AS 'Tax Definition', PCH1.PriceAfVAT AS 'Gross Price', PCH1.Height1 AS 'Height 1', PCH1.Hght1Unit AS 'Unit of Height 1', PCH1.Height2 AS 'Height 2', PCH1.Hght2Unit AS 'Unit of Height 2', PCH1.Width1 AS 'Width 1', PCH1.Wdth1Unit AS 'Unit of Width 1', PCH1.Width2 AS 'Width 2', PCH1.Wdth2Unit AS 'Unit of Width 2', PCH1.Length1 AS 'Length 1', PCH1.Len1Unit AS 'Unit of Length 1', PCH1.length2 AS 'Length 2', PCH1.Len2Unit AS 'Unit of Length 2', PCH1.Volume AS 'Quantity', PCH1.VolUnit AS 'Volume UoM', PCH1.Weight1 AS 'Weight 1', PCH1.Wght1Unit AS 'Unit of Weight 1', PCH1.Weight2 AS 'Weight 2', PCH1.Wght2Unit AS 'Unit of Weight 2', PCH1.Factor1 AS 'Factor 1', PCH1.Factor2 AS 'Factor 2', PCH1.Factor3 AS 'Factor 3', PCH1.Factor4 AS 'Factor 4', PCH1.PackQty AS 'Packing Quantity', PCH1.UpdInvntry AS 'Warehouse Update', PCH1.BaseDocNum AS 'Base Document No.', PCH1.BaseAtCard AS 'Customer/Vendor Base Document', PCH1.SWW AS 'Additional Identifier', PCH1.VatSum AS 'Total Tax', PCH1.VatSumFrgn AS 'Tax Amount (FC)', PCH1.VatSumSy AS 'Tax Amount (SC)', PCH1.FinncPriod AS 'Posting Period', PCH1.ObjType AS 'Object Type', PCH1.LogInstanc AS 'Log Instance', PCH1.BlockNum AS 'Block Number', PCH1.ImportLog AS 'Import Log', PCH1.DedVatSum AS 'Deductible Tax Amount', PCH1.DedVatSumF AS 'Deductible Tax Amount (FC)', PCH1.DedVatSumS AS 'Deductible Tax Amount (SC)', PCH1.IsAqcuistn AS 'Acquisition Tax', PCH1.DistribSum AS 'Distributed Amount', PCH1.DstrbSumFC AS 'Distributed Amount (FC)', PCH1.DstrbSumSC AS 'Distributed Amount (SC)', PCH1.GrssProfit AS 'Row Gross Profit', PCH1.GrssProfSC AS 'Row Gross Profit (SC)', PCH1.GrssProfFC AS 'Row Gross Profit (FC)', PCH1.VisOrder AS 'Visual Order', PCH1.INMPrice AS 'Item's Last Sales Price (OINM)', PCH1.PoTrgNum AS 'PO Target No.', PCH1.PoTrgEntry AS 'PO Target Internal ID', PCH1.DropShip AS 'Drop-Ship', PCH1.PoLineNum AS 'PO Target Row No.', PCH1.Address AS 'Address', PCH1.TaxCode AS 'Tax Code', PCH1.TaxType AS 'Tax Type', PCH1.OrigItem AS 'Original Item', PCH1.BackOrdr AS 'Allow Backorder', PCH1.FreeTxt AS 'Free Text', PCH1.PickStatus AS 'Pick Status', PCH1.PickOty AS 'Pick Quantity', PCH1.PickIdNo AS 'Pick List ID Number', PCH1.TrnsCode AS 'Shipping Method', PCH1.VatAppld AS 'Applied Tax', PCH1.VatAppldFC AS 'Applied Tax (FC)', PCH1.VatAppldSC AS 'Applied Tax (SC)', PCH1.BaseQty AS 'Base Quantity', PCH1.BaseOpnQty AS 'Base Open Quantity', PCH1.VatDscntPr AS 'Tax Discount %', PCH1.WtLiable AS 'Withholding Tax Liable', PCH1.DeferrTax AS 'Deferred Tax', PCH1.EquVatPer AS 'Equalization Tax %', PCH1.EquVatSum AS 'Total Equalization Tax', PCH1.EquVatSumF AS 'Total Equalization Tax (FC)', PCH1.EquVatSumS AS 'Total Equalization Tax (SC)', PCH1.LineVat AS 'Net Tax Amount', PCH1.LineVatlF AS 'Net Tax Amount', PCH1.LineVatS AS 'Net Tax Amount', PCH1.unitMsr AS 'Unit', PCH1.NumPerMsr AS 'UoM Value', PCH1.CEECFlag AS 'Correction Invoice Was/Should Be', PCH1.ToStock AS 'Corr. Invoice Amt to Inventory', PCH1.ToDiff AS 'Corr. Invoice Amount to Diff.', PCH1.ExciseAmt AS 'Excise Amount', PCH1.TaxPerUnit AS 'Tax per Unit', PCH1.TotInclTax AS 'Total Including Tax', PCH1.CountryOrg AS 'Country of Origin', PCH1.StckDstSum AS 'Stock Distribution Sum', PCH1.ReleasQtty AS 'Released Quantity', PCH1.LineType AS 'Row Type', PCH1.TranType AS 'Transaction Type', PCH1.Text AS 'Text', PCH1.OwnerCode AS 'Document Owner', PCH1.StockPrice AS 'Inventory Price', PCH1.ConsumeFCT AS 'Consumer Sales Forecast', PCH1.LstByDsSum AS 'Last Buy Distribute Sum', PCH1.StckINMPr AS 'Stock Inm Price', PCH1.LstBINMPr AS 'Last Buy Inventory Journal Pr.', PCH1.StckDstFc AS 'Stock Distributed Sum (FC)', PCH1.StckDstSc AS 'Stock Distributed Sum (SC)', PCH1.LstByDsFc AS 'Last Buy Distribute Sum (FC)', PCH1.LstByDsSc AS 'Last Buy Distribute Sum (SC)', PCH1.StockSum AS 'Stock Sum', PCH1.StockSumFc AS 'Stock Sum FC', PCH1.StockSumSc AS 'Stock Sum SC', PCH1.StckSumApp AS 'Stock Sum Applied', PCH1.StckAppFc AS 'Stock Sum Applied FC', PCH1.StckAppSc AS 'Stock Sum Applied SC', PCH1.ShipToCode AS 'Ship-to Code', PCH1.ShipToDesc AS 'Ship-to Description', PCH1.StckAppD AS 'Stock Distrib. - Applied Sum', PCH1.StckAppDFC AS 'Stock Dist. - Applied Sum (FC)', PCH1.StckAppDSC AS 'Stock Dist. - Applied Sum (SC)', PCH1.BasePrice AS 'Price for Total Calculation', PCH1.GTotal AS 'Gross Total', PCH1.GTotalFC AS 'Gross Total (FC)', PCH1.GTotalSC AS 'Gross Total (SC)', PCH1.DistribExp AS 'Distribute Freight', PCH1.DescOW AS 'Description Overwritten', PCH1.DetailsOW AS 'Details Overwritten', PCH1.GrossBase AS 'Base Method for Gross Profit', PCH1.VatWoDpm AS 'Tax Before DPM Applied', PCH1.VatWoDpmFc AS 'Tax Before DPM Applied (FC)', PCH1.VatWoDpmSc AS 'Tax Before DPM Applied (SC)', PCH1.CFOPCode AS 'CFOP Code for Document', PCH1.CSTCode AS 'CST Code for ICMS', PCH1.Usage AS 'Usage Code for Document', PCH1.TaxOnly AS 'Tax Only', PCH1.WtCalced AS 'Withholding Tax Calculated', PCH1.QtyToShip AS 'Quantity to Ship', PCH1.DelivrdQty AS 'Delivered Quantity', PCH1.OrderedQty AS 'Ordered Quantity', PCH1.CogsOcrCod AS 'COGS Distribution Rule Code', PCH1.CiOppLineN AS 'Line Number of Opposite Line', PCH1.CogsAcct AS 'COGS Account Code', PCH1.ChgAsmBoMW AS 'Change Whs for Asm BoM Child', PCH1.ActDelDate AS 'Actual Delivery Date', PCH1.OcrCode2 AS 'Costing Code 2', PCH1.OcrCode3 AS 'Costing Code 3', PCH1.OcrCode4 AS 'Costing Code 4', PCH1.OcrCode5 AS 'Costing Code 5', PCH1.TaxDistSum AS 'Tax Distributed Amount', PCH1.TaxDistSFC AS 'Tax Distributed Amount (FC)', PCH1.TaxDistSSC AS 'Tax Distributed Amount (SC)', PCH1.PostTax AS 'Post Tax in Price to Stock', PCH1.Excisable AS 'Excisable [Yes/No]', PCH1.AssblValue AS 'Assessable Value', PCH1.RG23APart1 AS 'RG23A Part1 Number', PCH1.RG23APart2 AS 'RG23A Part2 Number', PCH1.RG23CPart1 AS 'RG23C Part1 Number', PCH1.RG23CPart2 AS 'RG23C Part2 Number', PCH1.CogsOcrCo2 AS 'COGS Distribution Rule Code2', PCH1.CogsOcrCo3 AS 'COGS Distribution Rule Code3', PCH1.CogsOcrCo4 AS 'COGS Distribution Rule Code4', PCH1.CogsOcrCo5 AS 'COGS Distribution Rule Code5', PCH1.LnExcised AS 'Line Excised', PCH1.LocCode AS 'Location Code', PCH1.StockValue AS 'Total COGS Value', PCH1.GPTtlBasPr AS 'Total Base Price for Profit', PCH1.unitMsr2 AS 'Pur/Sal UoM if BaseUnit', PCH1.NumPerMsr2 AS 'Pur/Sal UoM Value if BaseUnit', PCH1.SpecPrice AS 'Price Source Type', PCH1.CSTfIPI AS 'CST for IPI Code', PCH1.CSTfPIS AS 'CST for PIS Code', PCH1.CSTfCOFINS AS 'CST for COFINS Code', PCH1.ExLineNo AS 'ExLineNo', PCH1.isSrvCall AS 'Created from Service Call', PCH1.PQTReqQty AS 'Pur Quotation: Required Qty', PCH1.PQTReqDate AS 'Pur Quotation: Required Date', PCH1.PcDocType AS 'Purchase Confirmation Doc Type', PCH1.PcQuantity AS 'Purchase Confirmation Quantity', PCH1.LinManClsd AS 'Line Was Closed Manually', PCH1.VatGrpSrc AS 'VAT Group Source', PCH1.NoInvtryMv AS 'Without Inventory Movement', PCH1.ActBaseEnt AS 'Actual Base Document Entry', PCH1.ActBaseLn AS 'Actual Base Line Number', PCH1.ActBaseNum AS 'Actual Base Document No.', PCH1.OpenRtnQty AS 'Quantity Open for Return', PCH1.AgrNo AS 'Agreement No.', PCH1.AgrLnNum AS 'Agreement Row Number', PCH1.CredOrigin AS 'Credit Origin', PCH1.Surpluses AS 'Surpluses', PCH1.DefBreak AS 'Defect and Breakup', PCH1.Shortages AS 'Shortages', PCH1.UomEntry AS 'UoM Entry', PCH1.UomEntry2 AS 'UoM Entry if Base Unit', PCH1.UomCode AS 'UoM Code', PCH1.UomCode2 AS 'UoM Code if Base Unit', PCH1.FromWhsCod AS 'From Warehouse Code', PCH1.NeedQty AS 'Consider Quantity of Items', PCH1.PartRetire AS 'Partial Retirement', PCH1.RetireQty AS 'Retirement Quantity', PCH1.RetireAPC AS 'Retirement APC', PCH1.RetirAPCFC AS 'Retirement APC FC', PCH1.RetirAPCSC AS 'Retirement APC SC', PCH1.InvQty AS 'Quantity - Inventory UoM', PCH1.OpenInvQty AS 'Open Quantity (Inventory UoM)', PCH1.EnSetCost AS 'Enable Set Item Cost in Return', PCH1.RetCost AS 'Return Cost in A/R Return', PCH1.Incoterms AS 'Incoterms', PCH1.TransMod AS 'Transport Mode', PCH1.LineVendor AS 'Line Vendor Code', PCH1.DistribIS AS 'Distribute Intrastat Freight', PCH1.ISDistrb AS 'Intrastat Distrib. Amount', PCH1.ISDistrbFC AS 'Intrastat Distrib. Amount (FC)', PCH1.ISDistrbSC AS 'Intrastat Distrib. Amount (SC)', PCH1.IsByPrdct AS 'Item Is By-Product', PCH1.ItemType AS 'Item Type', PCH1.PriceEdit AS 'Price Was Edited by User', PCH1.PrntLnNum AS 'Parent Line Number', PCH1.LinePoPrss AS 'Line PO Process', PCH1.FreeChrgBP AS 'Free of Charge (BP)', PCH1.TaxRelev AS 'Tax Relevant Row', PCH1.LegalText AS 'Legal Text', PCH1.ThirdParty AS 'Third Party', PCH1.LicTradNum AS 'Federal Tax ID', PCH1.InvQtyOnly AS 'Change Qty (Inv. UoM) Only', PCH1.UnencReasn AS 'Reason for Unencumbered ICMS', PCH1.ShipFromCo AS 'Ship-From Code', PCH1.ShipFromDe AS 'Ship-From Description' FROM PCH1 AS PCH1

Related information


Ex Line No ExLineNo Property· Table: PCH1
Specify the ExLineNo field of the marketing document tables. The marketing document tables include INV1, RIN1, DLN1, RDN1, RDR1, QUT1, PCh2, RPC1, PDN1, RPD1, POR1, IGN1, IGE1, and DRF1. Length: 10 characters.
· Table: IGE1 IGN1    Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
PCH1 SQL Table

G/L Accounts OACT SQL Table

Blanket Agreement OOAT SQL Table

Business Partner OCRD SQL Table

CFOP for Nota Fiscal OCFP SQL Table

Distribution Rule OOCR SQL Table

Brazil String Indexer OBSI SQL Table

Currency Codes OCRN SQL Table

A/P Invoice OPCH SQL Table

Posting Period OFPR SQL Table

Warehouses OWHS SQL Table

Intrastat Configuration ODCI SQL Table

Items OITM SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Project Codes OPRJ SQL Table

Sales Employee OSLP SQL Table

Customer/Vendor Cat. No. OSCN SQL Table

Sales Tax Codes OSTC SQL Table

Delivery Types OSHP SQL Table

UoM Master Data OUOM SQL Table

Usage of Nota Fiscal OUSG SQL Table

Tax Definition OVTG SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates