| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | IdNumber | ID Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | PmntDate | Date of Payment Run | date | 8 | 0 | | | | |
| 3 | NextDate | A/P Due Date To | date | 8 | 0 | | | | |
| 4 | OutgoType | Outgoing Type | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 5 | IncomType | Incoming Type | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 6 | CheckPmntM | Check Payment Terms | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 7 | BnkTrnsPmM | Bank Transfer Payment Terms | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 8 | FilePath | File Path | text | 16 | 0 | | | | |
| 9 | PostDtFrom | Posting Date From | date | 8 | 0 | | | | |
| 10 | PostDtTo | Posting Date To | date | 8 | 0 | | | | |
| 11 | ValDteFrom | Due Date From | date | 8 | 0 | | | | |
| 12 | ValDateTo | Due Date To | date | 8 | 0 | | | | |
| 13 | ApInvAmntF | A/P Invoice Amount From | num | 19 | 6 | | | | Allow NULL? |
| 14 | ApInvAmntT | A/P Invoice Amount To | num | 19 | 6 | | | | Allow NULL? |
| 15 | PchNoFrom | A/P Invoice No. From | int | 11 | 0 | | | | Allow NULL? |
| 16 | PchNoTo | A/P Invoice No. To | int | 11 | 0 | | | | Allow NULL? |
| 17 | InvNoFrom | A/R Invoice No. From | int | 11 | 0 | | | | Allow NULL? |
| 18 | InvNoTo | A/R Invoice No. To | int | 11 | 0 | | | | Allow NULL? |
| 19 | SelPriorit | Selection Priority | int | 11 | 0 | | | | Allow NULL? |
| 20 | Status | Object Status | char | 1 | 0 | | S | E, R, S | Allow NULL? |
| 21 | WizardName | Wizard Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 22 | StatusDisc | Status | nvarchar | 100 | 0 | | | | Allow NULL? |
| 23 | Canceled | Canceled | char | 1 | 0 | | N | | Allow NULL? |
| 24 | BoePmnMn | Bill of Exchange Paymt Method | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 25 | SeriesOut | Outgoing Series | int | 6 | 0 | NNM1 | 0 | | Allow NULL? |
| 26 | SeriesIn | Incoming Series | int | 6 | 0 | NNM1 | 0 | | Allow NULL? |
| 27 | TotalOut | Total Outgoing | num | 19 | 6 | | | | Allow NULL? |
| 28 | TotalIn | Total Incoming | num | 19 | 6 | | | | Allow NULL? |
| 29 | ViewIntBal | Include Interim Acct Balance | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 30 | SelMthd | Selection Method | char | 1 | 0 | | D | D, M | Allow NULL? |
| 31 | MINumFrom | Monthly Invoice No. From | int | 11 | 0 | | | | Allow NULL? |
| 32 | MINumTo | Monthly Invoice No. To | int | 11 | 0 | | | | Allow NULL? |
| 33 | MIDateFrom | Monthly Invoice Issued Date From | date | 8 | 0 | | | | |
| 34 | MIDateTo | Monthly Invoice Issued Date To | date | 8 | 0 | | | | |
| 35 | MIVNumFrom | A/P Monthly Invoice No. From | int | 11 | 0 | | | | Allow NULL? |
| 36 | MIVNumTo | A/P Monthly Invoice No. To | int | 11 | 0 | | | | Allow NULL? |
| 37 | MIVDateFro | A/P Monthly Invoice Date From | date | 8 | 0 | | | | |
| 38 | MIVDateTo | A/P Monthly Invoice Date To | date | 8 | 0 | | | | |
| 39 | APDocDtFrm | A/P Document Date From | date | 8 | 0 | | | | |
| 40 | APDocDtTo | A/P Document Date To | date | 8 | 0 | | | | |
| 41 | APDueDtFrm | A/P Due Date From | date | 8 | 0 | | | | |
| 42 | NxtPmntDat | Next Payment Run Date | date | 8 | 0 | | | | |
| 43 | MinPayAR | Minimum Incoming Payment | num | 19 | 6 | | | | Allow NULL? |
| 44 | MinPayAP | Minimum Outgoing Payment | num | 19 | 6 | | | | Allow NULL? |
| 45 | ShowAtCard | Display BP Ref. No. | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 46 | TolerDays | Tolerance Days | int | 6 | 0 | | | | Allow NULL? |
| 47 | MinCashDis | Min. Cash Discount | num | 19 | 6 | | | | Allow NULL? |
| 48 | NegBalBP | Include Negative Balance BP | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 49 | ManualJE | Include Manual JEs | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 50 | NegTrans | Include Negative Transactions | char | 1 | 0 | | Y | N, Y | Allow NULL? |
| 51 | CDTransApp | Apply to Cash Discount Trans. | char | 1 | 0 | | N | N, Y | Allow NULL? |
| 52 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 53 | CigTo | Contract Code ID To | int | 11 | 0 | OCIG | | | Allow NULL? |
| 54 | CupFrom | Unique Code of Project From | int | 11 | 0 | OCUP | | | Allow NULL? |
| 55 | CupTo | Unique Code of Project To | int | 11 | 0 | OCUP | | | Allow NULL? |
| 56 | CigFrom | Contract Code ID From | int | 11 | 0 | OCIG | | | Allow NULL? |
| 57 | BPLId | Active Branch | int | 11 | 0 | OBPL | | | Allow NULL? |
