Table PJMPRGBILD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PJMPRGBILD | PBILD | Progress billing plan lines | Sales | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PBILD0 | PRGBILNUM+SEQLIN | No | |
| PBILD1 | PRGBILNUM+PERSTRDAT+SEQLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTCPLCAL | Estimated amount | MD1 | ||||||
| AMTCPLENT | Billed amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PBILD]CREUSR | Other | ||||
| CUMAMT | Cumulated amount | MD1 | ||||||
| CUMQTY | Cumulated quantity | QTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[PBILD]CUR | Block | ||||
| DESAXX | Description | AXX | 10 | |||||
| ECHADJDAT | Adjusted on | D | ||||||
| ECHADJPRO | Adjusted value | M | 15 | 7767 | ||||
| ECHADJUSR | Adjusted by | AUS | [AUS]CODUSR=[PBILD]ECHADJUSR | Block | ||||
| ECHCREDAT | Created on | D | ||||||
| ECHCREUSR | Created by | AUS | [AUS]CODUSR=[PBILD]ECHCREUSR | Block | ||||
| ECHUPDDAT | Updated on | D | ||||||
| ECHUPDUSR | Updated by | AUS | [AUS]CODUSR=[PBILD]ECHUPDUSR | Block | ||||
| ECHVALDAT | Validated on | D | ||||||
| ECHVALUSR | Validated by | AUS | [AUS]CODUSR=[PBILD]ECHVALUSR | Block | ||||
| NEXINVDAT | Next invoice date | D | ||||||
| PERENDDAT | Period end | D | ||||||
| PERSTRDAT | Period start | D | ||||||
| PRCCPLCAL | Estimated progress (%) | RAT | ||||||
| PRCCPLDAT | Estimation date | D | ||||||
| PRCCPLENT | Billed progress (%) | RAT | ||||||
| PRGBILNUM | Billing plan number | PBIL | [PBILH]PBILH0=[PBILD]PRGBILNUM | BSRA | ||||
| QTYCPLCAL | Estimated quantity | QTY | ||||||
| QTYCPLENT | Billed quantity | QTY | ||||||
| REMAMT | Remaining amount | MD1 | ||||||
| REMQTY | Remaining quantity | QTY | ||||||
| SEQLIN | Line number | ISEQ | ||||||
| SIDLIN | Sales invoice line | L | 8 | |||||
| SIHNUM | Sales invoice no. | VCR | ||||||
| STA | Status | M | 15 | 7764 | ||||
| SVICNUM | Scheduled invoices | VCR | ||||||
| TBECHK | Refresh requested | M | 4 | 1 | ||||
| TMPSVICNUM | Scheduled invoice | VCR | ||||||
| TMPVCRINVCND | Due date line | L | 8 | |||||
| TYPECH | Line type | M | 15 | 7759 | ||||
| UOM | Sales unit | UOM | [TUN]TUN0=[PBILD]UOM | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PBILD]UPDUSR | Other | ||||
| VALLIN | Validated | M | 4 | 1 | ||||
| VCRINVCNDLIN | Due date line | L | 8 |