ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.invoice/C Invoice CustomerVendQtr
Contents |
C_Invoice_CustomerVendQtr
- Name:InvoiceCustomerVendQtr
- Classname:InvoiceCustomerVendQtr
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
| Vendor_ID | N | VARCHAR2(32) | A business partner who sells products or services. |
| DateInvoiced | Y | DATE | The time listed on the invoice. |
| LineNetAmt | Y | NUMBER | The final amount of a specified line, based only on quantities and prices. |
| LineListAmt | Y | NUMBER | null |
| LineLimitAmt | Y | NUMBER | null |
| LineDiscountAmt | Y | NUMBER | Line Discount Amount |
| LineDiscount | Y | NUMBER | Line Discount as a percentage |
| LineOverLimitAmt | Y | NUMBER | null |
| LineOverLimit | Y | NUMBER | null |
| QtyInvoiced | Y | NUMBER | The total number of a product included in an invoice to a business partner. |
Columns
Client
- Physical column name: AD_Client_ID
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Reference: Search
- This column is part of the table's identifier
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Vendor
- Physical column name: Vendor_ID
- Reference: Table
- This column is part of the table's identifier
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Reference Table C_BPartner Vendors With the following where clause:
C_BPartner.IsVendor='Y'
Invoice Date
The Date Invoice indicates the date printed on the invoice.
- Physical column name: DateInvoiced
- Reference: Date
- This column is part of the table's identifier
Line Net Amount
Indicates the line net amount based on the quantity and the actual price. Any additional charges or freight are not included.
- Physical column name: LineNetAmt
- Reference: Amount
Line List Amount
- Physical column name: LineListAmt
- Reference: Amount
Line Limit Amount
- Physical column name: LineLimitAmt
- Reference: Amount
Line Discount
Indicates the discount for this line as an amount.
- Physical column name: LineDiscountAmt
- Reference: Amount
Line Discount %
The Line Discount Percent indicates the discount for this line as a percentage.
- Physical column name: LineDiscount
- Reference: Number
Gross Margin
- Physical column name: LineOverLimitAmt
- Reference: Amount
Gross margin %
- Physical column name: LineOverLimit
- Reference: Number
Invoiced Quantity
The Invoiced Quantity indicates the quantity of a product that have been invoiced.
- Physical column name: QtyInvoiced
- Reference: Quantity