| 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=No, Y=Yes | Allow NULL? |
| 5 | IncomType | Incoming Type | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 6 | CheckPmntM | Check Payment Terms | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 7 | BnkTrnsPmM | Bank Transfer Payment Terms | char | 1 | 0 | | N | N=No, Y=Yes | 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=Executed Wizard, H=Scheduled Wizard, L=Scheduled Executing Wizard, R=Recommended Wizard, S=Saved Wizard | 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=No, Y=Yes | Allow NULL? |
| 25 | SeriesOut | Outgoing Series | int | 11 | 0 | NNM1 | 0 | | Allow NULL? |
| 26 | SeriesIn | Incoming Series | int | 11 | 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=No, Y=Yes | Allow NULL? |
| 30 | SelMthd | Selection Method | char | 1 | 0 | | D | D=By Document Property, M=By Monthly Invoice | 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=No, Y=Yes | 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=No, Y=Yes | Allow NULL? |
| 49 | ManualJE | Include Manual JEs | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 50 | NegTrans | Include Negative Transactions | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 51 | CDTransApp | Apply to Cash Discount Trans. | char | 1 | 0 | | N | N=No, Y=Yes | 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? |
| 58 | BoeDDFrom | BoE Due Date From | date | 8 | 0 | | | | |
| 59 | BoeDDTo | BoE Due Date To | date | 8 | 0 | | | | |
| 60 | BoeNumFrom | BoE No. From | int | 11 | 0 | OBOE | | | Allow NULL? |
| 61 | BoeNumTo | BoE No. To | int | 11 | 0 | OBOE | | | Allow NULL? |
| 62 | BoeStatus | Bill of Exchange Status | nvarchar | 32 | 0 | | | | Allow NULL? |
| 63 | HaExistBoe | Handle Existing BoE | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 64 | SeriesPOO | Outgoing Payment Order Series | int | 11 | 0 | NNM1 | 0 | | Allow NULL? |
| 65 | SeriesPOI | Incoming Payment Order Series | int | 11 | 0 | NNM1 | 0 | | Allow NULL? |
| 66 | SeqType | Sequence Type | nvarchar | 4 | 0 | | | FNAL=FNAL, FRST=FRST, OOFF=OOFF, RCUR=RCUR | Allow NULL? |
| 67 | PayDueDate | Payment Due Date Determination | char | 1 | 0 | | R | D=Document Due Date, R=Run Date | Allow NULL? |
| 68 | CentrPay | Centralized Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 69 | BA_AP_From | A/P Blanket Agreement From | int | 11 | 0 | | | | Allow NULL? |
| 70 | BA_AP_To | A/P Blanket Agreement To | int | 11 | 0 | | | | Allow NULL? |
| 71 | BA_AR_From | A/R Blanket Agreement From | int | 11 | 0 | | | | Allow NULL? |
| 72 | BA_AR_To | A/R Blanket Agreement To | int | 11 | 0 | | | | Allow NULL? |
| 73 | JobId | Job ID Number | int | 11 | 0 | | | | Allow NULL? |
| 74 | ZeroBalBP | Include Zero Balance BP | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 75 | ZeroBalDoc | Zero Balance Document Types | nvarchar | 50 | 0 | | YNNNNYNNNNN | | Allow NULL? |
