|
|
SQL Draft - Rows
DTW Draft - Rows
API Document Lines / Ex Line No
DRF1 - Draft - Rows Table
Ex Line No ExLineNo Property· Table: DRF1
Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1
DRF1 SQL Table
G/L Accounts OACT 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
Drafts ODRF 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY | Document Internal ID | Int | 11 | ODRF Drafts | VIS_ORDER | No |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| TargetType | Target Document Type | Int | 11 | -1 | ||||
| TrgetEntry | Target Document Internal ID | Int | 11 | |||||
| BaseRef | Base Document Reference | nVarChar | 16 | |||||
| BaseType | Base Document Type | Int | -1) 15) Delivery 16) Returns 203) A/R Down Payment 13) A/R Invoice 14) A/R Credit Memo 132) Correction Invoice 20) Goods Receipt PO 21) Goods Return 204) A/P Down Payment 18) A/P Invoice 19) A/P Credit Memo 17) Sales Order 22) Purchase Order 23) Sales Quotation 67) Inventory Transfers 163) A/P Correction Invoice 164) A/P Correction Invoice Reversal 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 540000006) Purchase Quotation 59) Goods Receipt 1250000001) Inventory Transfers Request 1470000113) Purchase Request 0 | 11 | -1 | |||
| BaseEntry KEY | Base Document Internal ID | Int | 11 | BASE_ENTRY | No | |||
| BaseLine | Base Row | Int | 11 | |||||
| LineStatus KEY | Row Status | VarChar | O) Open C) Closed | 1 | STATUS | No | ||
| ItemCode KEY | Item No. | nVarChar | 20 | OITM Items | ITM_WHS_OQ | No | ||
| Dscription | Item/Service Description | nVarChar | 100 | |||||
| Quantity | Quantity | Num | 20 | |||||
| ShipDate | Delivery Date per Row | Date | 8 | |||||
| OpenQty | Remaining Open Quantity | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| Currency KEY | Price Currency | nVarChar | 3 | OCRN Currency Codes | CURRENCY | No | ||
| Rate | Currency Rate | Num | 20 | |||||
| DiscPrcnt | Discount % per Row | Num | 20 | |||||
| LineTotal | Row Total | Num | 20 | |||||
| TotalFrgn | Row Total (FC) | Num | 20 | |||||
| OpenSum | Open Amount | Num | 20 | |||||
| OpenSumFC | Open Amount (FC) | Num | 20 | |||||
| VendorNum | Vendor Catalog Number | nVarChar | 17 | |||||
| SerialNum | Serial Number | nVarChar | 17 | |||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| SlpCode | Sales Employee Code | Int | 11 | OSLP Sales Employee | ||||
| Commission | Commission Percentage | Num | 20 | |||||
| TreeType | BOM Type | VarChar | N) Not a BOM A) Assembly S) Sales I) Sales BOM Component P) Production T) Template | 1 | N | |||
| AcctCode KEY | Account Code | nVarChar | 15 | OACT G/L Accounts | ACCOUNT | No | ||
| TaxStatus | Tax Definition | VarChar | Y) Yes N) No | 1 | ||||
| GrossBuyPr | Base Price for Gross Profit | Num | 20 | |||||
| PriceBefDi | Unit Price | Num | 20 | |||||
| DocDate | Posting Date | Date | 8 | |||||
| Flags | Flags | Int | 11 | |||||
| OpenCreQty | Credit Memo Amount | Num | 20 | |||||
| UseBaseUn | Inventory UoM | VarChar | Y) Yes N) No | 1 | N | |||
| SubCatNum | Customer/Vendor Catalog No. | nVarChar | 20 | OSCN Customer/Vendor Cat. No. | ||||
| BaseCard | Base BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| TotalSumSy | Row Total (FC) | Num | 20 | |||||
| OpenSumSys | Open Amount (SC) | Num | 20 | |||||
| InvntSttus | Warehouse Status | VarChar | O) Open C) Closed | 1 | ||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| CodeBars | Bar Code | nVarChar | 127 | |||||
| VatPrcnt | Tax Rate per Row | Num | 20 | |||||
| VatGroup | Tax Definition | nVarChar | 8 | OVTG Tax Definition | ||||
| PriceAfVAT | Gross Price | Num | 20 | |||||
| Height1 | Height 1 | Num | 20 | |||||
| Hght1Unit | Height 1 UoM | Int | 6 | |||||
| Height2 | Height 2 | Num | 20 | |||||
| Hght2Unit | Height 2 UoM | Int | 6 | |||||
| Width1 | Width 1 | Num | 20 | |||||
| Wdth1Unit | UoM for Width 1 | Int | 6 | |||||
| Width2 | Width 2 | Num | 20 | |||||
| Wdth2Unit | UoM for Width 2 | Int | 6 | |||||
| Length1 | Length 1 | Num | 20 | |||||
| Len1Unit | Length 1 UoM | Int | 6 | |||||
| length2 | Length 2 | Num | 20 | |||||
| Len2Unit | Length 2 UoM | Int | 6 | |||||
| Volume | Quantity | Num | 20 | |||||
| VolUnit | Volume UoM | Int | 6 | |||||
| Weight1 | Weight 1 | Num | 20 | |||||
| Wght1Unit | UoM for Weight 1 | Int | 6 | |||||
| Weight2 | Weight 2 | Num | 20 | |||||
| Wght2Unit | UoM for Weight 2 | Int | 6 | |||||
| Factor1 | Factor 1 | Num | 20 | |||||
| Factor2 | Factor 2 | Num | 20 | |||||
| Factor3 | Factor 3 | Num | 20 | |||||
| Factor4 | Factor 4 | Num | 20 | |||||
| PackQty | No. of Packages | Num | 20 | |||||
| UpdInvntry | Warehouse Update | VarChar | Y) Yes N) No | 1 | ||||
| BaseDocNum | Base Document No. | Int | 11 | |||||
| BaseAtCard | BP Reference No. From | nVarChar | 100 | |||||
| SWW | Additional Identifier | nVarChar | 16 | |||||
| VatSum | Total Tax | Num | 20 | |||||
| VatSumFrgn | Tax Amount (FC) | Num | 20 | |||||
| VatSumSy | Tax Amount (SC) | Num | 20 | |||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 112 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| BlockNum | Block Number | nVarChar | 100 | |||||
| ImportLog | Import Log | nVarChar | 20 | |||||
| DedVatSum | Deductible Tax Amount | Num | 20 | |||||
| DedVatSumF | Deductible Tax Amount (FC) | Num | 20 | |||||
| DedVatSumS | Deductible Tax Amount (SC) | Num | 20 | |||||
| IsAqcuistn | Acquisition Tax | VarChar | Y) Yes N) No | 1 | N | |||
| DistribSum | Distributed Amount | Num | 20 | |||||
| DstrbSumFC | Distributed Amount (FC) | Num | 20 | |||||
| DstrbSumSC | Distributed Amount (SC) | Num | 20 | |||||
| GrssProfit | Row Gross Profit | Num | 20 | |||||
| GrssProfSC | Row Gross Profit (SC) | Num | 20 | |||||
| GrssProfFC | Row Gross Profit (FC) | Num | 20 | |||||
| VisOrder | Visual Order | Int | 11 | |||||
| INMPrice | Item's Last Sales Price (OINM) | Num | 20 | |||||
| PoTrgNum | Target PO No. | Int | 11 | |||||
| PoTrgEntry | Target PO Entry | nVarChar | 11 | |||||
| DropShip | Drop-Ship | VarChar | Y) Yes N) No | 1 | N | |||
| PoLineNum | PO Target Row No. | Int | 11 | |||||
| Address | Address | nVarChar | 127 | |||||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| TaxType | Tax Type | VarChar | Y) Regular Tax N) No Tax U) Use Tax | 1 | ||||
| OrigItem | Original Item | nVarChar | 20 | OITM Items | ||||
| BackOrdr | Allow Backorder | VarChar | Y) Yes N) No | 1 | ||||
| FreeTxt | Free Text | nVarChar | 100 | |||||
| PickStatus | Pick Status | VarChar | Y) Picked N) Not Picked R) Released for Picking P) Partially Picked | 1 | N | |||
| PickOty | Pick Quantity | Num | 20 | |||||
| PickIdNo | Pick List ID Number | Int | 11 | |||||
| TrnsCode | Shipping Method | Int | 6 | OSHP Delivery Types | -1 | |||
| VatAppld | Applied Tax | Num | 20 | |||||
| VatAppldFC | Applied Tax (FC) | Num | 20 | |||||
| VatAppldSC | Applied Tax (SC) | Num | 20 | |||||
| BaseQty | Base Quantity | Num | 20 | |||||
| BaseOpnQty | Base Open Quantity | Num | 20 | |||||
| VatDscntPr | Tax Discount % | Num | 20 | |||||
| WtLiable | Withholding Tax Liable | VarChar | Y) Yes N) No | 1 | ||||
| DeferrTax | Deferred Tax | VarChar | Y) Yes N) No | 1 | N | |||
| EquVatPer | Equalization Tax % | Num | 20 | |||||
| EquVatSum | Total Equalization Tax | Num | 20 | |||||
| EquVatSumF | Total Equalization Tax (FC) | Num | 20 | |||||
| EquVatSumS | Total Equalization Tax (SC) | Num | 20 | |||||
| LineVat | Net Tax Amount | Num | 20 | |||||
| LineVatlF | Net Tax Amount | Num | 20 | |||||
| LineVatS | Net Tax Amount | Num | 20 | |||||
| unitMsr | Unit | nVarChar | 100 | |||||
| NumPerMsr | UoM Value | Num | 20 | |||||
| CEECFlag | Correction Invoice Was/Should Be | VarChar | W) Was S) Should Be | 1 | S | |||
| ToStock | Corr. Invoice Amt to Inventory | Num | 20 | |||||
| ToDiff | Corr. Invoice Amount to Diff. | Num | 20 | |||||
| ExciseAmt | Excise Amount | Num | 20 | |||||
| TaxPerUnit | Tax per Unit | Num | 20 | |||||
| TotInclTax | Total Including Tax | Num | 20 | |||||
| CountryOrg | Country of Origin | nVarChar | 3 | |||||
| StckDstSum | Stock Distribution Sum | Num | 20 | |||||
| ReleasQtty | Released Quantity | Num | 20 | |||||
| LineType | Row Type | VarChar | R) Regular A) Alternative M) Resource | 1 | R | |||
| TranType | Transaction Type | VarChar | C) Complete R) Reject | 1 | ||||
| Text | Text | Text | 16 | |||||
| OwnerCode KEY | Document Owner | Int | 11 | OWNER_CODE | No | |||
| StockPrice | Item Cost | Num | 20 | |||||
| ConsumeFCT | Consumer Sales Forecast | VarChar | Y) Yes N) No | 1 | ||||
| LstByDsSum | Last Buy Distribute Sum | Num | 20 | |||||
| StckINMPr | Stock Inm Price | Num | 20 | |||||
| LstBINMPr | Last Buy Inventory Journal Pr. | Num | 20 | |||||
| StckDstFc | Stock Distribution Sum (FC) | Num | 20 | |||||
| StckDstSc | Stock Distribution Sum (SC) | Num | 20 | |||||
| LstByDsFc | Last Buy Distribute Sum (FC) | Num | 20 | |||||
| LstByDsSc | Last Buy Distribute Sum (SC) | Num | 20 | |||||
| StockSum | Stock Sum | Num | 20 | |||||
| StockSumFc | Stock Sum FC | Num | 20 | |||||
| StockSumSc | Stock Sum SC | Num | 20 | |||||
| StckSumApp | Stock Sum Applied | Num | 20 | |||||
| StckAppFc | Stock Sum Applied FC | Num | 20 | |||||
| StckAppSc | Stock Sum Applied SC | Num | 20 | |||||
| ShipToCode | Ship-to Code | nVarChar | 50 | |||||
| ShipToDesc | Ship-to Description | nVarChar | 127 | |||||
| StckAppD | Stock Distrib. - Applied Sum | Num | 20 | |||||
| StckAppDFC | Stock Dist. - Applied Sum (FC) | Num | 20 | |||||
| StckAppDSC | Stock Dist. - Applied Sum (SC) | Num | 20 | |||||
| BasePrice | Price for Total Calculation | VarChar | E) Exclude Tax I) Include Tax | 1 | E | |||
| GTotal | Gross Total | Num | 20 | |||||
| GTotalFC | Gross Total (FC) | Num | 20 | |||||
| GTotalSC | Gross Total (SC) | Num | 20 | |||||
| DistribExp | Distribute Freight | VarChar | Y) Yes N) No | 1 | ||||
| DescOW | Description Overwritten | VarChar | Y) Yes N) No | 1 | N | |||
| DetailsOW | Details Overwritten | VarChar | Y) Yes N) No | 1 | N | |||
| GrossBase | Base Method for Gross Profit | Int | 6 | |||||
| VatWoDpm | Tax Before DPM Applied | Num | 20 | |||||
| VatWoDpmFc | Tax Before DPM Applied (FC) | Num | 20 | |||||
| VatWoDpmSc | Tax Before DPM Applied (SC) | Num | 20 | |||||
| CFOPCode | CFOP Code for Document | nVarChar | 6 | OCFP CFOP for Nota Fiscal | ||||
| CSTCode | CST Code for ICMS | nVarChar | 6 | |||||
| Usage | Usage Code for Document | Int | 11 | OUSG Usage of Nota Fiscal | ||||
| TaxOnly | Tax Only | VarChar | Y) Yes N) No | 1 | ||||
| WtCalced | Withholding Tax Calculated | VarChar | N) No Y) Yes | 1 | N | |||
| QtyToShip | Quantity to Ship | Num | 20 | |||||
| DelivrdQty | Delivered Quantity | Num | 20 | |||||
| OrderedQty | Ordered Quantity | Num | 20 | |||||
| CogsOcrCod | COGS Distribution Rule Code | nVarChar | 8 | OOCR Distribution Rule | ||||
| CiOppLineN | Line Number of Opposite Line | Int | 11 | -1 | ||||
| CogsAcct | COGS Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| ChgAsmBoMW | Change Whs for Asm BoM Child | VarChar | Y) Yes N) No | 1 | ||||
| ActDelDate | Actual Delivery Date | Date | 8 | |||||
| OcrCode2 | Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| TaxDistSum | Tax Distributed Amount | Num | 20 | |||||
| TaxDistSFC | Tax Distributed Amount (FC) | Num | 20 | |||||
| TaxDistSSC | Tax Distributed Amount (SC) | Num | 20 | |||||
| PostTax | Post Tax in Price to Stock | VarChar | Y) Yes N) No | 1 | Y | |||
| Excisable | Excisable [Yes/No] | VarChar | Y) Yes N) No | 1 | ||||
| AssblValue | Assessable Value | Num | 20 | |||||
| RG23APart1 | RG23A Part1 Number | Int | 11 | |||||
| RG23APart2 | RG23A Part2 Number | Int | 11 | |||||
| RG23CPart1 | RG23C Part1 Number | Int | 11 | |||||
| RG23CPart2 | RG23C Part2 Number | Int | 11 | |||||
| CogsOcrCo2 | COGS Distribution Rule Code2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| CogsOcrCo3 | COGS Distribution Rule Code3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| CogsOcrCo4 | COGS Distribution Rule Code4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| CogsOcrCo5 | COGS Distribution Rule Code5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| LnExcised | Line Excised | VarChar | O) Open C) Closed P) Copied to OEI | 1 | ||||
| LocCode | Location Code | Int | 11 | OLCT Location | ||||
| StockValue | Total COGS Value | Num | 20 | |||||
| GPTtlBasPr | Total Base Price for Profit | Num | 20 | |||||
| unitMsr2 | Pur/Sal UoM if BaseUnit | nVarChar | 100 | |||||
| NumPerMsr2 | Pur/Sal UoM Value if BaseUnit | Num | 20 | |||||
| SpecPrice | Price Source Type | VarChar | 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 | |||
| CSTfIPI | CST for IPI Code | nVarChar | 2 | |||||
| CSTfPIS | CST for PIS Code | nVarChar | 2 | |||||
| CSTfCOFINS | CST for COFINS Code | nVarChar | 2 | |||||
| ExLineNo | ExLineNo | nVarChar | 10 | |||||
| isSrvCall | Created from Service Call | VarChar | Y) Yes N) No | 1 | N | |||
| PQTReqQty | Pur Quotation: Required Qty | Num | 20 | |||||
| PQTReqDate | Pur Quotation: Required Date | Date | 8 | |||||
| PcDocType | Purchase Confirmation Doc Type | Int | -1) No Type 22) Purchase Order 540000006) Purchase Quotation | 11 | -1 | |||
| PcQuantity | Purchase Confirmation Quantity | Num | 20 | |||||
| LinManClsd | Line Was Closed Manually | VarChar | Y) Yes N) No U) Unknown | 1 | N | |||
| VatGrpSrc | VAT Group Source | VarChar | N) Not Defined M) Manually Entered D) Determined | 1 | N | |||
| NoInvtryMv | Without Inventory Movement | VarChar | Y) Yes N) No | 1 | N | |||
| ActBaseEnt | Actual Base Document Entry | Int | 11 | |||||
| ActBaseLn | Actual Base Line Number | Int | 11 | |||||
| ActBaseNum | Actual Base Document No. | Int | 11 | |||||
| OpenRtnQty | Quantity Open for Return | Num | 20 | |||||
| AgrNo | Agreement No. | Int | 11 | |||||
| AgrLnNum | Agreement Row Number | Int | 11 | |||||
| CredOrigin | Credit Origin | VarChar | 1 | OBSI Brazil String Indexer | ||||
| Surpluses | Surpluses | Num | 20 | |||||
| DefBreak | Defect and Breakup | Num | 20 | |||||
| Shortages | Shortages | Num | 20 | |||||
| UomEntry | UoM Entry | Int | 11 | OUOM UoM Master Data | 0 | |||
| UomEntry2 | UoM Entry if Base Unit | Int | 11 | OUOM UoM Master Data | 0 | |||
| UomCode | UoM Code | nVarChar | 20 | |||||
| UomCode2 | UoM Code if Base Unit | nVarChar | 20 | |||||
| FromWhsCod | From Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| NeedQty | Consider Quantity of Items | VarChar | Y) Yes N) No | 1 | N | |||
| PartRetire | Partial Retirement | VarChar | Y) Yes N) No | 1 | N | |||
| RetireQty | Retirement Quantity | Num | 20 | |||||
| RetireAPC | Retirement APC | Num | 20 | |||||
| RetirAPCFC | Retirement APC FC | Num | 20 | |||||
| RetirAPCSC | Retirement APC SC | Num | 20 | |||||
| InvQty | Quantity - Inventory UoM | Num | 20 | |||||
| OpenInvQty | Open Quantity (Inventory UoM) | Num | 20 | |||||
| EnSetCost | Enable Set Item Cost in Return | VarChar | Y) Yes N) No | 1 | N | |||
| RetCost | Return Cost in A/R Return | Num | 20 | |||||
| Incoterms | Incoterms | Int | 11 | ODCI Intrastat Configuration | 0 | |||
| TransMod | Transport Mode | Int | 11 | ODCI Intrastat Configuration | 0 | |||
| LineVendor | Line Vendor Code | nVarChar | 15 | OCRD Business Partner | ||||
| DistribIS | Distribute Intrastat Freight | VarChar | Y) Yes N) No | 1 | N | |||
| ISDistrb | Intrastat Distrib. Amount | Num | 20 | |||||
| ISDistrbFC | Intrastat Distrib. Amount (FC) | Num | 20 | |||||
| ISDistrbSC | Intrastat Distrib. Amount (SC) | Num | 20 | |||||
| IsByPrdct | Item Is By-Product | VarChar | N) No Y) Yes | 1 | N | |||
| ItemType | Item Type | Int | 4) Item 290) Resource | 11 | 4 | |||
| PriceEdit | Price Was Edited by User | VarChar | N) No Y) Yes | 1 | N | |||
| PrntLnNum | Parent Line Number | Int | 11 | |||||
| LinePoPrss | Line PO Process | VarChar | Y) Yes N) No | 1 | N | |||
| FreeChrgBP | Free of Charge (BP) | VarChar | Y) Yes N) No | 1 | ||||
| TaxRelev | Tax Relevant Row | VarChar | Y) Yes N) No | 1 | Y | |||
| LegalText | Legal Text | nVarChar | 127 | |||||
| ThirdParty | Third Party | VarChar | Y) Yes N) No | 1 | N | |||
| LicTradNum | Federal Tax ID | nVarChar | 32 | |||||
| InvQtyOnly | Change Qty (Inv. UoM) Only | VarChar | Y) Yes N) No | 1 | N | |||
| UnencReasn | Reason for Unencumbered ICMS | Int | 11 | |||||
| ShipFromCo | Ship-From Code | nVarChar | 50 | |||||
| ShipFromDe | Ship-From Description | nVarChar | 127 |
Table relationship map
SELECT statement
SELECT
DRF1.DocEntry AS 'Document Internal ID',
DRF1.LineNum AS 'Row Number',
DRF1.TargetType AS 'Target Document Type',
DRF1.TrgetEntry AS 'Target Document Internal ID',
DRF1.BaseRef AS 'Base Document Reference',
DRF1.BaseType AS 'Base Document Type',
DRF1.BaseEntry AS 'Base Document Internal ID',
DRF1.BaseLine AS 'Base Row',
DRF1.LineStatus AS 'Row Status',
DRF1.ItemCode AS 'Item No.',
DRF1.Dscription AS 'Item/Service Description',
DRF1.Quantity AS 'Quantity',
DRF1.ShipDate AS 'Delivery Date per Row',
DRF1.OpenQty AS 'Remaining Open Quantity',
DRF1.Price AS 'Price',
DRF1.Currency AS 'Price Currency',
DRF1.Rate AS 'Currency Rate',
DRF1.DiscPrcnt AS 'Discount % per Row',
DRF1.LineTotal AS 'Row Total',
DRF1.TotalFrgn AS 'Row Total (FC)',
DRF1.OpenSum AS 'Open Amount',
DRF1.OpenSumFC AS 'Open Amount (FC)',
DRF1.VendorNum AS 'Vendor Catalog Number',
DRF1.SerialNum AS 'Serial Number',
DRF1.WhsCode AS 'Warehouse Code',
DRF1.SlpCode AS 'Sales Employee Code',
DRF1.Commission AS 'Commission Percentage',
DRF1.TreeType AS 'BOM Type',
DRF1.AcctCode AS 'Account Code',
DRF1.TaxStatus AS 'Tax Definition',
DRF1.GrossBuyPr AS 'Base Price for Gross Profit',
DRF1.PriceBefDi AS 'Unit Price',
DRF1.DocDate AS 'Posting Date',
DRF1.Flags AS 'Flags',
DRF1.OpenCreQty AS 'Credit Memo Amount',
DRF1.UseBaseUn AS 'Inventory UoM',
DRF1.SubCatNum AS 'Customer/Vendor Catalog No.',
DRF1.BaseCard AS 'Base BP Code',
DRF1.TotalSumSy AS 'Row Total (FC)',
DRF1.OpenSumSys AS 'Open Amount (SC)',
DRF1.InvntSttus AS 'Warehouse Status',
DRF1.OcrCode AS 'Distribution Rule',
DRF1.Project AS 'Project Code',
DRF1.CodeBars AS 'Bar Code',
DRF1.VatPrcnt AS 'Tax Rate per Row',
DRF1.VatGroup AS 'Tax Definition',
DRF1.PriceAfVAT AS 'Gross Price',
DRF1.Height1 AS 'Height 1',
DRF1.Hght1Unit AS 'Height 1 UoM',
DRF1.Height2 AS 'Height 2',
DRF1.Hght2Unit AS 'Height 2 UoM',
DRF1.Width1 AS 'Width 1',
DRF1.Wdth1Unit AS 'UoM for Width 1',
DRF1.Width2 AS 'Width 2',
DRF1.Wdth2Unit AS 'UoM for Width 2',
DRF1.Length1 AS 'Length 1',
DRF1.Len1Unit AS 'Length 1 UoM',
DRF1.length2 AS 'Length 2',
DRF1.Len2Unit AS 'Length 2 UoM',
DRF1.Volume AS 'Quantity',
DRF1.VolUnit AS 'Volume UoM',
DRF1.Weight1 AS 'Weight 1',
DRF1.Wght1Unit AS 'UoM for Weight 1',
DRF1.Weight2 AS 'Weight 2',
DRF1.Wght2Unit AS 'UoM for Weight 2',
DRF1.Factor1 AS 'Factor 1',
DRF1.Factor2 AS 'Factor 2',
DRF1.Factor3 AS 'Factor 3',
DRF1.Factor4 AS 'Factor 4',
DRF1.PackQty AS 'No. of Packages',
DRF1.UpdInvntry AS 'Warehouse Update',
DRF1.BaseDocNum AS 'Base Document No.',
DRF1.BaseAtCard AS 'BP Reference No. From',
DRF1.SWW AS 'Additional Identifier',
DRF1.VatSum AS 'Total Tax',
DRF1.VatSumFrgn AS 'Tax Amount (FC)',
DRF1.VatSumSy AS 'Tax Amount (SC)',
DRF1.FinncPriod AS 'Posting Period',
DRF1.ObjType AS 'Object Type',
DRF1.LogInstanc AS 'Log Instance',
DRF1.BlockNum AS 'Block Number',
DRF1.ImportLog AS 'Import Log',
DRF1.DedVatSum AS 'Deductible Tax Amount',
DRF1.DedVatSumF AS 'Deductible Tax Amount (FC)',
DRF1.DedVatSumS AS 'Deductible Tax Amount (SC)',
DRF1.IsAqcuistn AS 'Acquisition Tax',
DRF1.DistribSum AS 'Distributed Amount',
DRF1.DstrbSumFC AS 'Distributed Amount (FC)',
DRF1.DstrbSumSC AS 'Distributed Amount (SC)',
DRF1.GrssProfit AS 'Row Gross Profit',
DRF1.GrssProfSC AS 'Row Gross Profit (SC)',
DRF1.GrssProfFC AS 'Row Gross Profit (FC)',
DRF1.VisOrder AS 'Visual Order',
DRF1.INMPrice AS 'Item's Last Sales Price (OINM)',
DRF1.PoTrgNum AS 'Target PO No.',
DRF1.PoTrgEntry AS 'Target PO Entry',
DRF1.DropShip AS 'Drop-Ship',
DRF1.PoLineNum AS 'PO Target Row No.',
DRF1.Address AS 'Address',
DRF1.TaxCode AS 'Tax Code',
DRF1.TaxType AS 'Tax Type',
DRF1.OrigItem AS 'Original Item',
DRF1.BackOrdr AS 'Allow Backorder',
DRF1.FreeTxt AS 'Free Text',
DRF1.PickStatus AS 'Pick Status',
DRF1.PickOty AS 'Pick Quantity',
DRF1.PickIdNo AS 'Pick List ID Number',
DRF1.TrnsCode AS 'Shipping Method',
DRF1.VatAppld AS 'Applied Tax',
DRF1.VatAppldFC AS 'Applied Tax (FC)',
DRF1.VatAppldSC AS 'Applied Tax (SC)',
DRF1.BaseQty AS 'Base Quantity',
DRF1.BaseOpnQty AS 'Base Open Quantity',
DRF1.VatDscntPr AS 'Tax Discount %',
DRF1.WtLiable AS 'Withholding Tax Liable',
DRF1.DeferrTax AS 'Deferred Tax',
DRF1.EquVatPer AS 'Equalization Tax %',
DRF1.EquVatSum AS 'Total Equalization Tax',
DRF1.EquVatSumF AS 'Total Equalization Tax (FC)',
DRF1.EquVatSumS AS 'Total Equalization Tax (SC)',
DRF1.LineVat AS 'Net Tax Amount',
DRF1.LineVatlF AS 'Net Tax Amount',
DRF1.LineVatS AS 'Net Tax Amount',
DRF1.unitMsr AS 'Unit',
DRF1.NumPerMsr AS 'UoM Value',
DRF1.CEECFlag AS 'Correction Invoice Was/Should Be',
DRF1.ToStock AS 'Corr. Invoice Amt to Inventory',
DRF1.ToDiff AS 'Corr. Invoice Amount to Diff.',
DRF1.ExciseAmt AS 'Excise Amount',
DRF1.TaxPerUnit AS 'Tax per Unit',
DRF1.TotInclTax AS 'Total Including Tax',
DRF1.CountryOrg AS 'Country of Origin',
DRF1.StckDstSum AS 'Stock Distribution Sum',
DRF1.ReleasQtty AS 'Released Quantity',
DRF1.LineType AS 'Row Type',
DRF1.TranType AS 'Transaction Type',
DRF1.Text AS 'Text',
DRF1.OwnerCode AS 'Document Owner',
DRF1.StockPrice AS 'Item Cost',
DRF1.ConsumeFCT AS 'Consumer Sales Forecast',
DRF1.LstByDsSum AS 'Last Buy Distribute Sum',
DRF1.StckINMPr AS 'Stock Inm Price',
DRF1.LstBINMPr AS 'Last Buy Inventory Journal Pr.',
DRF1.StckDstFc AS 'Stock Distribution Sum (FC)',
DRF1.StckDstSc AS 'Stock Distribution Sum (SC)',
DRF1.LstByDsFc AS 'Last Buy Distribute Sum (FC)',
DRF1.LstByDsSc AS 'Last Buy Distribute Sum (SC)',
DRF1.StockSum AS 'Stock Sum',
DRF1.StockSumFc AS 'Stock Sum FC',
DRF1.StockSumSc AS 'Stock Sum SC',
DRF1.StckSumApp AS 'Stock Sum Applied',
DRF1.StckAppFc AS 'Stock Sum Applied FC',
DRF1.StckAppSc AS 'Stock Sum Applied SC',
DRF1.ShipToCode AS 'Ship-to Code',
DRF1.ShipToDesc AS 'Ship-to Description',
DRF1.StckAppD AS 'Stock Distrib. - Applied Sum',
DRF1.StckAppDFC AS 'Stock Dist. - Applied Sum (FC)',
DRF1.StckAppDSC AS 'Stock Dist. - Applied Sum (SC)',
DRF1.BasePrice AS 'Price for Total Calculation',
DRF1.GTotal AS 'Gross Total',
DRF1.GTotalFC AS 'Gross Total (FC)',
DRF1.GTotalSC AS 'Gross Total (SC)',
DRF1.DistribExp AS 'Distribute Freight',
DRF1.DescOW AS 'Description Overwritten',
DRF1.DetailsOW AS 'Details Overwritten',
DRF1.GrossBase AS 'Base Method for Gross Profit',
DRF1.VatWoDpm AS 'Tax Before DPM Applied',
DRF1.VatWoDpmFc AS 'Tax Before DPM Applied (FC)',
DRF1.VatWoDpmSc AS 'Tax Before DPM Applied (SC)',
DRF1.CFOPCode AS 'CFOP Code for Document',
DRF1.CSTCode AS 'CST Code for ICMS',
DRF1.Usage AS 'Usage Code for Document',
DRF1.TaxOnly AS 'Tax Only',
DRF1.WtCalced AS 'Withholding Tax Calculated',
DRF1.QtyToShip AS 'Quantity to Ship',
DRF1.DelivrdQty AS 'Delivered Quantity',
DRF1.OrderedQty AS 'Ordered Quantity',
DRF1.CogsOcrCod AS 'COGS Distribution Rule Code',
DRF1.CiOppLineN AS 'Line Number of Opposite Line',
DRF1.CogsAcct AS 'COGS Account Code',
DRF1.ChgAsmBoMW AS 'Change Whs for Asm BoM Child',
DRF1.ActDelDate AS 'Actual Delivery Date',
DRF1.OcrCode2 AS 'Costing Code 2',
DRF1.OcrCode3 AS 'Costing Code 3',
DRF1.OcrCode4 AS 'Costing Code 4',
DRF1.OcrCode5 AS 'Costing Code 5',
DRF1.TaxDistSum AS 'Tax Distributed Amount',
DRF1.TaxDistSFC AS 'Tax Distributed Amount (FC)',
DRF1.TaxDistSSC AS 'Tax Distributed Amount (SC)',
DRF1.PostTax AS 'Post Tax in Price to Stock',
DRF1.Excisable AS 'Excisable [Yes/No]',
DRF1.AssblValue AS 'Assessable Value',
DRF1.RG23APart1 AS 'RG23A Part1 Number',
DRF1.RG23APart2 AS 'RG23A Part2 Number',
DRF1.RG23CPart1 AS 'RG23C Part1 Number',
DRF1.RG23CPart2 AS 'RG23C Part2 Number',
DRF1.CogsOcrCo2 AS 'COGS Distribution Rule Code2',
DRF1.CogsOcrCo3 AS 'COGS Distribution Rule Code3',
DRF1.CogsOcrCo4 AS 'COGS Distribution Rule Code4',
DRF1.CogsOcrCo5 AS 'COGS Distribution Rule Code5',
DRF1.LnExcised AS 'Line Excised',
DRF1.LocCode AS 'Location Code',
DRF1.StockValue AS 'Total COGS Value',
DRF1.GPTtlBasPr AS 'Total Base Price for Profit',
DRF1.unitMsr2 AS 'Pur/Sal UoM if BaseUnit',
DRF1.NumPerMsr2 AS 'Pur/Sal UoM Value if BaseUnit',
DRF1.SpecPrice AS 'Price Source Type',
DRF1.CSTfIPI AS 'CST for IPI Code',
DRF1.CSTfPIS AS 'CST for PIS Code',
DRF1.CSTfCOFINS AS 'CST for COFINS Code',
DRF1.ExLineNo AS 'ExLineNo',
DRF1.isSrvCall AS 'Created from Service Call',
DRF1.PQTReqQty AS 'Pur Quotation: Required Qty',
DRF1.PQTReqDate AS 'Pur Quotation: Required Date',
DRF1.PcDocType AS 'Purchase Confirmation Doc Type',
DRF1.PcQuantity AS 'Purchase Confirmation Quantity',
DRF1.LinManClsd AS 'Line Was Closed Manually',
DRF1.VatGrpSrc AS 'VAT Group Source',
DRF1.NoInvtryMv AS 'Without Inventory Movement',
DRF1.ActBaseEnt AS 'Actual Base Document Entry',
DRF1.ActBaseLn AS 'Actual Base Line Number',
DRF1.ActBaseNum AS 'Actual Base Document No.',
DRF1.OpenRtnQty AS 'Quantity Open for Return',
DRF1.AgrNo AS 'Agreement No.',
DRF1.AgrLnNum AS 'Agreement Row Number',
DRF1.CredOrigin AS 'Credit Origin',
DRF1.Surpluses AS 'Surpluses',
DRF1.DefBreak AS 'Defect and Breakup',
DRF1.Shortages AS 'Shortages',
DRF1.UomEntry AS 'UoM Entry',
DRF1.UomEntry2 AS 'UoM Entry if Base Unit',
DRF1.UomCode AS 'UoM Code',
DRF1.UomCode2 AS 'UoM Code if Base Unit',
DRF1.FromWhsCod AS 'From Warehouse Code',
DRF1.NeedQty AS 'Consider Quantity of Items',
DRF1.PartRetire AS 'Partial Retirement',
DRF1.RetireQty AS 'Retirement Quantity',
DRF1.RetireAPC AS 'Retirement APC',
DRF1.RetirAPCFC AS 'Retirement APC FC',
DRF1.RetirAPCSC AS 'Retirement APC SC',
DRF1.InvQty AS 'Quantity - Inventory UoM',
DRF1.OpenInvQty AS 'Open Quantity (Inventory UoM)',
DRF1.EnSetCost AS 'Enable Set Item Cost in Return',
DRF1.RetCost AS 'Return Cost in A/R Return',
DRF1.Incoterms AS 'Incoterms',
DRF1.TransMod AS 'Transport Mode',
DRF1.LineVendor AS 'Line Vendor Code',
DRF1.DistribIS AS 'Distribute Intrastat Freight',
DRF1.ISDistrb AS 'Intrastat Distrib. Amount',
DRF1.ISDistrbFC AS 'Intrastat Distrib. Amount (FC)',
DRF1.ISDistrbSC AS 'Intrastat Distrib. Amount (SC)',
DRF1.IsByPrdct AS 'Item Is By-Product',
DRF1.ItemType AS 'Item Type',
DRF1.PriceEdit AS 'Price Was Edited by User',
DRF1.PrntLnNum AS 'Parent Line Number',
DRF1.LinePoPrss AS 'Line PO Process',
DRF1.FreeChrgBP AS 'Free of Charge (BP)',
DRF1.TaxRelev AS 'Tax Relevant Row',
DRF1.LegalText AS 'Legal Text',
DRF1.ThirdParty AS 'Third Party',
DRF1.LicTradNum AS 'Federal Tax ID',
DRF1.InvQtyOnly AS 'Change Qty (Inv. UoM) Only',
DRF1.UnencReasn AS 'Reason for Unencumbered ICMS',
DRF1.ShipFromCo AS 'Ship-From Code',
DRF1.ShipFromDe AS 'Ship-From Description'
FROM DRF1 AS DRF1
Related information
Ex Line No ExLineNo Property· Table: DRF1
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 DRF1 SQL Table
G/L Accounts OACT 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
Drafts ODRF 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
Document_Lines
Property
ExLineNo
Method
Property
ChangedMenuName
9.0 DB
Enumeration
Method
Object
BatchNumbers OBTN, BTNT
WithholdingTaxLines INV5
Property
AccountCode
DTW DB
ActualDeliveryDate
DTW DB
Address
DTW DB
AppliedTax
DB
AppliedTaxFC
DB
AppliedTaxSC
DB
BackOrder
DTW DB
BarCode
DTW DB
BaseEntry
DTW DB
BaseLine
DTW DB
BaseType
DTW DB
CFOPCode
DTW DB
ChangeAssemlyBoMWarehouse
DTW DB
COGSAccountCode
DTW DB
COGSCostingCode
DTW DB
CommisionPercent
DTW DB
ConsumerSalesForecast
DTW DB
CorrectionInvoiceItem
DTW DB
CorrInvAmountToDiffAcct
DTW DB
CorrInvAmountToStock
DTW DB
CostingCode
DTW DB
CostingCode2
DTW DB
CostingCode3
DTW DB
CostingCode4
DTW DB
CostingCode5
DTW DB
CountryOrg
DTW DB
CSTCode
DTW DB
Currency
DTW DB
DeferredTax
DTW DB
DiscountPercent
DTW DB
DistributeExpense
DTW DB
ExciseAmount
DTW DB
ExLineNo
DTW DB
Factor1
DTW DB
Factor2
DTW DB
Factor3
DTW DB
Factor4
DTW DB
FreeText
DTW DB
GrossBase
DTW DB
GrossBuyPrice
DTW DB
GrossProfitTotalBasePrice
DTW DB
Height1
DTW DB
Height2
DTW DB
Height2Unit
DTW DB
Hight1Unit
DTW DB
ItemCode
DTW DB
ItemDescription
DTW DB
ItemDetails
DTW DB
Lengh1
DTW DB
Lengh1Unit
DTW DB
Lengh2
DTW DB
Lengh2Unit
DTW DB
LineNum
DTW DB
LineStatus
DTW DB
LineTotal
DTW DB
LineType
DTW DB
LocationCode
DTW DB
MeasureUnit
DTW DB
NetTaxAmount
DB
OpenAmount
DB
OpenAmountFC
DB
OpenAmountSC
DB
OriginalItem
DB
PickQuantity
DB
PickStatus
DB
PickStatusEx
DB
POTargetNum
DB
Price
DTW DB
PriceAfterVAT
DTW DB
ProjectCode
DTW DB
Quantity
DTW DB
Rate
DTW DB
RowTotalFC
DTW DB
RowTotalSC
DB
SalesPersonCode
DTW DB
SerialNum
DTW DB
ShipDate
DTW DB
ShippingMethod
DTW DB
ShipToCode
DTW DB
SupplierCatNum
DTW DB
SWW
DTW DB
TaxBeforeDPM
DB
TaxCode
DTW DB
TaxLiable
DTW DB
TaxOnly
DTW DB
TaxPercentagePerRow
DTW DB
TaxPerUnit
DB
TaxTotal
DB
TaxType
DTW DB
Text
DB
TotalInclTax
DB
TransactionType
DTW DB
TreeType
DTW DB
UnitPrice
DTW DB
UnitsOfMeasurment
DTW DB
UoMCode
DB
UoMEntry
DB
Usage
DTW DB
UseBaseUnits
DTW DB
VatGroup
DTW DB
VendorNum
DTW DB
VisualOrder
DB
Volume
DTW DB
VolumeUnit
DTW DB
WarehouseCode
DTW DB
Weight1
DTW DB
Weight1Unit
DTW DB
Weight2
DTW DB
Weight2Unit
DTW DB
Width1
DTW DB
Width1Unit
DTW DB
Width2
DTW DB
Width2Unit
DTW DB
WTLiable
DTW DB
Method
Property
TransferID
8.8.2 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
