| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Key | int | 11 | 0 | | | | Allow NULL? |
| 2 | LineID | Row No. | int | 11 | 0 | | | | Allow NULL? |
| 3 | BWRefID | Billing Wizard Reference ID | int | 11 | 0 | | | | Allow NULL? |
| 4 | TargetType | Target Document Type | int | 11 | 0 | | -1 | -1, 13=A/R Invoice, 15=Delivery | Allow NULL? |
| 5 | TargetAbs | Target Document Abs. Entry | int | 11 | 0 | | | | Allow NULL? |
| 6 | TargetNum | Target Document Number | int | 11 | 0 | | | | Allow NULL? |
| 7 | TargetLine | Target Document Line Number | int | 11 | 0 | | | | Allow NULL? |
| 8 | SubProjID | Subproject ID | int | 11 | 0 | | -1 | | Allow NULL? |
| 9 | StageID | Stage ID | int | 11 | 0 | | | | Allow NULL? |
| 10 | SourceType | Source Document Type | int | 11 | 0 | | -1 | -1, 13002=A/R Reserve Invoice, 15=Delivery, 17=Sales Order, 18=A/P Invoice, 202=Work Order, 234000024=Timesheet, 23=Sales Quotation, 33=Activity | Allow NULL? |
| 11 | SourceAbs | Source Document Abs. Entry | int | 11 | 0 | | | | Allow NULL? |
| 12 | SourceNum | Source Document Number | int | 11 | 0 | | | | Allow NULL? |
| 13 | SourceLine | Source Document Line Number | int | 11 | 0 | | | | Allow NULL? |
| 14 | Charged | Charged | num | 19 | 6 | | | | Allow NULL? |
| 15 | ChargedQty | Charged Quantity | num | 19 | 6 | | | | Allow NULL? |
| 16 | DestType | Destination Table Type | int | 11 | 0 | | -1 | -1, 234000021=Project Management Document, 234000022=Project Management Subproject, 234000024=Time Sheet Document | Allow NULL? |
| 17 | DestArr | Destination Table Array | int | 11 | 0 | | -1 | -1, 1=Time Sheet Lines, 4=Stage Documents, 6=Stage Activities, 7=Stage Workorders | Allow NULL? |
| 18 | DestAbs | Destination Table Abs. Entry | int | 11 | 0 | | | | Allow NULL? |
| 19 | DestLine | Destination Table Line Number | int | 11 | 0 | | | | Allow NULL? |