The OCRD table in SAP Business One stores information about the many Business partnerwith whom the company cooperates. Each row in the table represents a single business partner, which can be either a customer or a supplier, depending on the context of the relationship.
The OCRD table stores information such as the business partner code, the business partner name, the business partner type, the business partner address and additional contact information such as a phone number and an email address for the business partner.
In addition, further data can be stored in the table OCRD. This data may include the payment history of the business partner, the credit limit of the business partner and the creditworthiness of the business partner.
The OCRD table is closely linked to a number of other modules in SAP Business One, including the module that handles operations for sales and purchasing. Given this, selecting business partners and linking orders and invoices directly to the appropriate business partner is a simple process. The following fields, among others, are included in the OCRD table in SAP Business One:
- CardCode: This field contains the code of the business partner, which serves as a unique identifier.
- CardName: The name of the business partner is stored here.
- CardType: This field defines the type of business partner (e.g. customer or supplier).
- GroupCode: The group membership of the business partner is saved here.
- Phone1: The phone number of the business partner is stored in this field.
- Email: The email address of the business partner is stored here.
- CreditLimit: The credit limit of the business partner is stored in this field.
- Balance: The current balance of the business partner is saved here.
- Currency: This field specifies the currency in which transactions are conducted with the business partner.
- PaymentTerms: This defines the payment term that applies to the business partner.
