Table BPS1099PAY
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BPS1099PAY | B9P | Supplier 1099 payments | Financials | S1099 |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| B9P0 | YR1099+CPY+BPSNUM+PAYNUM+PAYLIN | No | |
| B9P1 | YR1099+CPY+BPSNUM+FRM1099+BOX1099 | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMT1099 | 1099 amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BOX1099 | 1099 box | A | 4 | |||||
| BPSNUM | Supplier | BPS | [BPS]BPS0=[B9P]BPSNUM | Delete | ||||
| CPY | Company | CPY | [CPY]CPY0=[B9P]CPY | Delete | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[B9P]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[B9P]CUR | Delete | ||||
| FRM1099 | 1099 form | M | 15 | 3601 | ||||
| INVNUM | Invoice number | VCR | ||||||
| PAYLIN | Line | C | 4 | |||||
| PAYNUM | Payment number | VCR | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[B9P]UPDUSR | Other | ||||
| YR1099 | Year | C | 4 |