| View Name: | gl_part_sum |
| View Number: | 70 |
| Group: | Logistics |
| Description: | Used by the server process in cbbatch for GL summary computations |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | part_trans | objid | Part transaction internal record number | 3 (UNIQUE) |
| trans_date | part_trans | creation_date | The date of transaction | |
| qty | part_trans | quantity | The quantity of this transaction | |
| unit_price | part_trans | standard_cost | The price per unit | |
| to_gl | to_fixed(inv_bin) | gl_acct_no | The TO GL account name | |
| to_gl_objid | to_fixed(inv_bin) | objid | The TO GL account object ID | |
| from_gl | from_fixed(inv_bin) | gl_acct_no | The FROM GL account | |
| from_gl_objid | from_fixed(inv_bin) | objid | The FROM GL account object ID | |
| to_bin | to_bin(inv_bin) | bin_name | The TO bin name | |
| to_bin_objid | to_bin(inv_bin) | objid | The TO bin object ID | |
| from_bin | from_bin(inv_bin) | bin_name | The FROM bin name | |
| from_bin_objid | from_bin(inv_bin) | objid | The FROM bin object ID | |
| trans_id | part_trans | transaction_id | Transaction ID of this part transaction |
| Join From | Join To |
|---|---|
| (part_trans).from_bin2inv_bin | from_bin(inv_bin).from_bin2part_trans |
| (part_trans).to_bin2inv_bin | to_bin(inv_bin).to_bin2part_trans |
| (part_trans).to_fixed2inv_bin | to_fixed(inv_bin).to_fixed2part_trans |
| (part_trans).from_fixed2inv_bin | from_fixed(inv_bin).from_fixed2part_trans |
| gl_part_sum | |||