|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payment Results Table - Rows
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 |