The information about the payments received by the company is stored in the ORCT table in SAP Business One. The entries in the table each denote a single payment received from either a customer or a supplier.
The ORCT table stores information such as the payment identification number, the date on which the payment was made, the amount of the payment and the name of the linked customer or supplier. In addition, further information such as the payment status, comments, the linked transaction code and the Currency be added to the payment.
The ORCT table in SAP Business One is closely linked to a number of other modules in the application, including the sales order module and the invoicing module. This allows each incoming payment to be assigned to a specific order or invoice, making accounting and management of requirements simplified. The fields in the ORCT table include, among others:
- DocNum: The number of the payment documentation is stored here.
- DocType: The type of payment is defined in this field (e.g. cash payment, bank transfer, cheque).
- CardCode: The code of the customer or supplier to whom the payment is assigned is stored here.
- DocDate: The date of payment is stored in this field.
- DocTotal: The total amount of the payment is stored here.
- CashSum: This field stores the cash amount of the payment.
- TrsfrSum: The amount of the transfer payment is saved here.
- Remarks: Comments or remarks about the payment can be saved in this field.
- InvType: The type of the associated invoice is defined here (e.g. sales invoice, purchase invoice).
