| DB | Areas | X-idx | Tables | Sequences | <- acp-remit-audit | acp-remitadv -> | HtmlDict 11 |
Account Payable Remittance Allow Deductions
| Area | FinData |
|---|---|
| Dumpname | remitded |
| Label | Account Payable Remittance Allow Deductions |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 100 | allow-amt | X | Allowance Amount | decimal-2 | >>>,>>>,>>9.99- | 0 | ||
| 210 | allow-base-amt | X | Allow Base Amt | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 40 | allow-cat-cde | X | Allowance Category Code | character | x(3) | |||
| 10 | allow-no | X | Allowance No | integer | >>>>>>>9 | 0 | ||
| 90 | allow-perc | X | Allowance Perc | decimal-2 | >>9.99 | 0 | ||
| 110 | allow-tax | X | Allowance Tax | decimal-2 | >>>,>>>,>>9.99- | 0 | ||
| 50 | allow-type | X | Allowance Type | character | x(3) | |||
| 130 | claim-date | X | Claim Date | date | 99/99/9999 | ? | ||
| 200 | claim-no | X | Claim No | character | x(8) | 0 | ||
| 230 | comment | X | Comment | character | x(30) | |||
| 120 | create-date | X | Create Date | date | 99/99/9999 | ? | ||
| 160 | deduct-ind | X | Deduct Ind | logical | Yes/No | NO | ||
| 60 | doc-type | X | Document Type | logical | Invoice/Creditnote | TRUE | ||
| 220 | fra-allow-base-amt | X | Fran Allow Base Amt | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 25 | franchise-ind | X | Franchise Ind | logical | Yes/No | NO | ||
| 250 | grp-cde | X | Group Code | character | x(3) | |||
| 80 | inv-ln | X | Invoice Line | integer | 999 | 0 | ||
| 30 | mem-comp-no | X | Member Company No | integer | 9999999 | 0 | ||
| 240 | pay-no | X | Payment No | character | x(8) | |||
| 140 | remit-no | X | Remittance No | character | x(8) | |||
| 170 | remit-to-vendor-no | X | Remittance To No | character | X(6) | |||
| 180 | tax-cat | X | Tax Category | character | X(2) | |||
| 190 | tax-cde | X | Tax Code | character | x(2) | 0 | ||
| 150 | undo-ind | X | Undo | logical | Yes/No | NO | ||
| 70 | vendor-inv-no | X | Vendor Invoice No | character | x(12) | |||
| 20 | vendor-no | X | Vendor No | character | x(6) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| remit-ded | P | vendor-no (+) | character |
| allow-no (+) | integer | ||
| franchise-ind (+) | logical | ||
| mem-comp-no (+) | integer | ||
| inv-no | vendor-no (+) | character | |
| vendor-inv-no (+) | character | ||
| doc-type (+) | logical | ||
| inv-ln (+) | integer | ||
| member-deduct | mem-comp-no (+) | integer | |
| deduct-ind (+) | logical | ||
| franchise-ind (+) | logical | ||
| vendor-no (+) | character | ||
| pay-no | franchise-ind (+) | logical | |
| deduct-ind (+) | logical | ||
| pay-no (+) | character | ||
| remit-deduct | vendor-no (+) | character | |
| deduct-ind (+) | logical | ||
| claim-date (+) | date | ||
| remit-no | remit-no (+) | character | |
| remit-to | remit-to-vendor-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acp-apinv fra-grp-ret fra-mem-allow fra-member icc-taxtyp pur-allow-cat sal-remitadv |
| generated 24-6-2026 08:23 |