📚 SAP Business One SDK Help

Table Name: GPA1

Table Description: Gross Profit Adjustment - Documents

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Key Int 11 OGPA      
LineId Row No. Int 11 -      
ItemCode Item No. nVarChar 50 OITM      
ItemName Item Description nVarChar 200 -      
DocType Document Type nVarChar 20 -      
DocNum Document Number Int 11 -      
DocAbs Document Abs. Entry Int 11 -      
DocLineNum Document Line Number Int 11 -      
ManagedBy Managed By Int 11 - -1 10000044 Batch Numbers
            10000045 Serial Numbers
            -1  
Selected Choose VarChar 1 - Y Y Yes
            N No
DistNumber Batch Number nVarChar 36 -      
PostDate Posting Date Date 8 -      
WhsCode Warehouse Code nVarChar 8 -      
Quantity Quantity Num 19.6 -      
CogsAcct COGS Account Code nVarChar 15 -      
CogsAmnt COGS Amount Num 19.6 -      
SalesAmnt Sales Amount Num 19.6 -      
GrssProfit Row Gross Profit Num 19.6 -      
COGSByCC COGS By Current Cost Num 19.6 -      
GPByCC Gross Profit By Current Cost Num 19.6 -      
DeltaGP Delta Gross Profit Num 19.6 -      
SalesPrice Sales Price Num 19.6 -      
BatchQt Batch Quantity Num 19.6 -      
SnBAbs SnB Abs. Entry Int 11 -      
AccTotal Acct Total Num 19.6 -      
AccQty Acct Qty Num 19.6 -      
ActionType Action Type Int 11 - 5 0 TRANSACTION_UNKNOWN
            1 TRANSACTION_IN
            2 TRANSACTION_OUT
            3 TRANSACTION_SET
            4 TRANSACTION_COMPLETE
            5 EMPTY_TRANSACTION
            6 TRANSACTION_REVALUATION
            7 TRANSACTION_REVALUATION_INCREASE
            8 TRANSACTION_REVALUATION_DECREASE
            9 TRANSACTION_CLOSE_IN
            10 TRANSACTION_CLOSE_OUT
            11 TRANSACTION_NEGATIVE_REVALUATION
            12 TRANSACTION_NULLIFY
            13 TRANSACTION_RESERVE_CI_IN
            14 TRANSACTION_RESERVE_CI_OUT
            15 TRANSACTION_RESERVE_CI_REVAL_INC
            16 TRANSACTION_RESERVE_CI_REVAL_DEC
            17 TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
            18 TRANSACTION_REVAL_PRICE_CHANGE_DECREASE
SBAccTotal SnB Acct Total Num 19.6 -      
SBAccQty SnB Acct Qty Num 19.6 -      
BaseType Base Type nVarChar 20 -      
Execute Execute VarChar 1 - Y Y Yes
            N No
SBCogsAmnt SnB COGS Amount Num 19.6 -      
SBSaleAmnt SnB Sales Amount Num 19.6 -      
SBGrssProf SnB Gross Profit Num 19.6 -      
SBGrPrPerc SnB Gross Profit Percentage Num 19.6 -      
GrPrPerc Gross Profit Percentage Num 19.6 -      
GPPercByCC Gross Profit Percentage By Current Cost Num 19.6 -      
DeltaGPLn Delta gross profit calculated for the document line Num 19.6 -      
Applied Applied Adjustment Num 19.6 -      
SBAccTtAdj SnB Acct Total Adjustment Num 19.6 -      
IsMixed Is Mixed Based Document VarChar 1 - N Y Yes
            N No
CogsAmByCC Total COGS Amount By Current Cost Num 19.6 -      
GrssPrByCC Total Gross Profit By Current Cost Num 19.6 -      
LineType Wizard Line Type VarChar 1 - N N Normal
            C Chained
            I Non Based Correction Invoice
ChDocType Chained Document Type nVarChar 20 -      
ChDocAbs Chained Document Abs. Entry Int 11 -      
WasQty Was Line Quantity Num 19.6 -      
WasCogs Was Line COGS Amount Num 19.6 -      
WasSales Was Line Sales Amount Num 19.6 -      
WasPrice Was Line Sales Price Num 19.6 -      
WasGrProf Was Line Gross Profit Num 19.6 -      
BaseAbs Base Document Abs Entry Int 11 -      
WasNewCogs Was Line New Cogs Num 19.6 -      
ChDocLine Chained Document Line Int 11 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LineId