| DB | Areas | X-idx | Tables | Sequences | <- acp-apadv-orig | acp-apinv-orig -> | HtmlDict 11 |
Accounts Payable Invoices
| Area | FinData |
|---|---|
| Dumpname | apinv |
| Label | Accounts Payable Invoices |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 350 | acct-no | X | Acct | character | xxxxxx-xx-x | |||
| 400 | add-spent-amt | X | Add Spent Amt | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 420 | add-spent-deduct-ind | X | Add Spent Deducted Ind | logical | Yes/No | FALSE | ||
| 440 | add-spent-ref-crnote | X | Add Spent Cr Note Nr | character | x(12) | |||
| 490 | allow-amt | X | Allowance Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 270 | appr-clerk-no | X | Approve Clerk No | integer | >9 | 0 | ||
| 260 | clerk-no | X | Clerk No | integer | >9 | 0 | ||
| 115 | cr-amt | X | Credit Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 220 | cr-tax-amt | X | Credit Tax Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 170 | currcy-cde | X | Currency Code | character | !!! | |||
| 320 | date-capt | X | Date Captured | date | 99/99/9999 | ? | ||
| 300 | doc-type | X | Document Type | logical | Invoice/Creditnote | TRUE | ||
| 180 | exchange-rate | X | Exchange Rate | decimal-4 | >>,>>9.9999 | 0 | ||
| 90 | fin-mth | X | Fin Month | integer | 99 | 0 | ||
| 80 | fin-year | X | Fin Year | character | 9999/9999 | |||
| 110 | inv-amt | X | Invoice Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 70 | inv-date | X | Invoice Date | date | 99/99/9999 | ? | ||
| 250 | inv-stat | X | Invoice Status | integer | 9 | 0 | ||
| 20 | inv-type | X | Invoice Type | character | ! | |||
| 380 | match-no | X | Match No | character | x(12) | |||
| 112 | pay-amt | X | Payment Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 210 | pay-tax-amt | X | Payment Tax Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 150 | post-ind | X | Post Ind | logical | Yes/No | NO | ||
| 500 | prev-sched-date | X | Prev Sched Date | date | 99/99/99 | ? | D: Previous Scheduled Date | |
| 390 | rebate-amt | X | Rebate Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 410 | rebate-deduct-ind | X | Rebate Deducted Ind | logical | Yes/No | FALSE | ||
| 430 | rebate-ref-crnote | X | Rebate Cr Note Nr | character | x(12) | |||
| 30 | ref-inv-no | X | Ref Invoice No | character | x(12) | |||
| 190 | rej-reason | X | Reject Reason | character | x(2) | |||
| 240 | remit-no | X | Remittance No | character | x(8) | |||
| 280 | remit-to-vendor-no | X | Remittance To No | character | X(6) | |||
| 105 | sched-date | X | Sched Date | date | 99/99/9999 | ? | ||
| 230 | sel-ind | X | Select Ind | logical | Yes/No | NO | ||
| 100 | settl-date | X | Settlement Date | date | 99/99/9999 | ? | ||
| 130 | settl-disc-amt | X | Settl Discount Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 370 | sys-crnote-ind | X | System CN Ind | logical | Yes/No | No | ||
| 120 | tax-amt | X | Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 360 | tax-dev-amt | X | Tax Dev Amt | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 340 | tax-incl-excl | X | Tax Incl/Excl | logical | Incl/Excl | Incl | ||
| 330 | tax-ind | X | Tax Ind | logical | Yes/No | Yes | ||
| 480 | tot-wgt | X | Total Weight | decimal-3 | >>>>9.999 | 0 | ||
| 460 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 470 | upd-time | X | At | integer | 99999 | 0 | ||
| 450 | upd-user-id | X | By | character | x(12) | |||
| 310 | vendor-crnote-no | X | Vendor Crnote No | character | X(12) | |||
| 10 | vendor-inv-no | X | Vendor Invoice No | character | x(12) | |||
| 5 | vendor-no | X | Vendor No | character | x(6) | |||
| 290 | vendor-stmnt-no | X | Statement No | character | X(15) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| vendor-inv | P U | vendor-no (+) | character |
| vendor-inv-no (+) | character | ||
| doc-type (+) | logical | ||
| acct-no | acct-no (+) | character | |
| capt-ndx | clerk-no (+) | integer | |
| inv-stat (+) | integer | ||
| doc-type (+) | logical | ||
| clerk-no | clerk-no (+) | integer | |
| vendor-no (+) | character | ||
| date-vendor-type | inv-date (-) | date | |
| vendor-no (+) | character | ||
| doc-type (+) | logical | ||
| remit-inv-type | remit-to-vendor-no (+) | character | |
| vendor-inv-no (+) | character | ||
| doc-type (+) | logical | ||
| remit-no | remit-no (+) | character | |
| statement-no | remit-to-vendor-no (+) | character | |
| vendor-stmnt-no (+) | character | ||
| vendor-doc-inv | vendor-no (+) | character | |
| doc-type (+) | logical | ||
| vendor-inv-no (+) | character | ||
| vendor-inv-no | vendor-inv-no (+) | character | |
| vendor-match | remit-to-vendor-no (+) | character | |
| match-no (+) | character | ||
| vendor-refinv | vendor-no (+) | character | |
| doc-type (+) | logical | ||
| ref-inv-no (+) | character | ||
| vendor-type-fin | vendor-no (+) | character | |
| doc-type (+) | logical | ||
| fin-year (+) | character | ||
| fin-mth (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acp-recur-inv acr-clntacct cbk-match sal-remitadv sys-finmth-aud |
| Child tables |
|---|
| acp-apinv-orig acp-remit-ded fra-invoice pur-allow-inv pur-schedinv |
| generated 24-6-2026 08:22 |