ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.invoice/C Invoice Week
Contents |
C_Invoice_Week
- Name:InvoiceWeek
- Classname:InvoiceWeek
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 |
SalesRep_ID | Y | VARCHAR2(32) | The person in charge of a document. |
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 |
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)
Sales Representative
- Physical column name: SalesRep_ID
- Reference: Table
- This column is part of the table's identifier
Foreign key column to AD_User table, (column: AD_User_ID)
Reference Table AD_User SalesRep With the following where clause:
EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep='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