📚 SAP Business One SDK Help

Table Name: PEX1

Table Description: Payment Results Table - Rows

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
LineId Row Number Int 11 -      
PayRunDate Date of Payment Run Date 8 -      
PaymWizCod Payment Wizard Code Int 11 -      
VendorNum Vendor Code nVarChar 15 OCRD      
CustNum Customer Code nVarChar 15 OCRD      
PaymMethod Payment Means nVarChar 15 OPYM      
PaymDocNum Payment Document No. Int 11 -      
FiscalYear Fiscal Year Date 8 -      
VendRefNum Vendor Ref. No. nVarChar 200 -      
ObjType Document Object Type nVarChar 20 -      
DocDate Document Posting Date Date 8 -      
TaxDate Document Date Date 8 -      
CrdGLAcct BP Accounts Receivable/Payable nVarChar 15 OACT      
DocCurr Document Currency nVarChar 3 -      
DocRate Document Rate Num 19.6 -      
DocTotal Document Total (LC) Num 19.6 -      
DocTotalFC Document Total (FC) Num 19.6 -      
DocTaxAmnt Tax Amount per Document Amount Num 19.6 -      
DoxTxAmtFC Tax Amount per Document Amount Num 19.6 -      
DocRemarks Document Remarks nVarChar 254 -      
DocPrmTerm Document Payment Terms Int 6 OCTG      
DocPymRef Payment Document Reference nVarChar 27 -      
DocLocCurr Document Local Currency nVarChar 3 -      
PymTermPer Payment Terms Period Int 11 -      
DocNum Document Number Int 11 -      
PymNum Payment Number (PWZ3 - PymNum) Int 11 -      
PayOrderNo Payment Order Number Int 11 OIPO      
FreeText1 Free Text 1 nVarChar 100 -      
FreeText2 Free Text 2 nVarChar 100 -      
FreeText3 Free Text 3 nVarChar 100 -      
vatApplied VAT Applied Num 19.6 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LineId