In SAP Business One, the "OINV" table stores data on the invoices that are created by the system. Each row in the table represents an invoice and contains information on this invoice, including the invoice number, date, customer, invoice number and invoice type. articlethe quantity and the price. The table contains the following fields, among others:
- DocNum: The unique number assigned to each invoice.
- DocDate: The date on which the invoice was created.
- CardCode: The code of the customer to whom the invoice is addressed.
- DocTotal: The total amount of the invoice.
- PaidToDate: The amount paid so far from the invoice.
- DocDate: The date on which the invoice was created.
- CardCode: The code of the customer to whom the invoice is addressed.
- CardName: The name of the client.
- Address: The address of the client.
- DocCur: The currency of the invoice.
- DocRate: The exchange rate for the currency of the invoice.
- Comments: Comments on the bill.
- DocTotal: The total amount of the invoice.
- PaidToDate: The amount paid so far from the invoice.
- DocStatus: The status of the invoice (e.g. open, paid).
- NumAtCard: The customer's reference number for the invoice.
- DocOwner: The user who created the invoice.
- Series: The sequence of invoice numbering.
- TaxDate: The date on which taxes are calculated for the invoice.
- DiscPrcnt: The discount percentage for the invoice.
- DiscSum: The discount amount for the invoice.
- VatSum: The tax amount for the invoice.
- TotalExpns: The total cost of the invoice.
- Payments: The amount paid for the invoice.
- PaidSum: The amount paid for the invoice.
- LastPymtDt: The date of the last payment for the invoice.
- DocEntryRE: The reference to the original invoice if it has been cancelled or changed.
The OINV table is one of the most important tables in SAP Business One, as it provides information about which customer has purchased what, when and at what price.
