The following fields exist in SROKBP:
| Field | Length | Description |
|---|---|---|
| PTIDEN | 2 | Identity (Text in file: Record type) Mandatory.
The code is used to select the transaction when a transfer with this identity is made. Payment documents from DC1 Distribution (created by the Order Settlement routine) use code OS (cash payment) or CC (credit card payment) when transferred to DC1 Financials. Payment documents (created by the DI Accounts Receivable batch payment transfer routine) use the identity code ED. All identities will be changed to “FI” for the selected transaction during interfacing so that they cannot be selected again. |
| PTSTAT | 1 | Status (Text in file: Status) Not allowed. This is a work field. |
| PTDENO | 11 | Debtor number (Text in file: Debtor number) Mandatory.
Validated against the Business partner file. |
| PTDOTY | 3 | Document type (Text in file: Document type) Optional.
Must be blank if document number is blank. The type and number are used to find the document to settle, unless a bank reference number is completed. If document type/number and bank reference number are blank, the payment will become an open document. |
| PTINNO | 12,00 | Document number (Text in file: Invoice number) Optional.
Must be blank if document type is blank. The type and number are used to find the document to settle, unless a bank reference number is completed. If document type/number and bank reference number are blank, the payment will become an open document. |
| PTAMTR | 17,03 | Transaction amount (Text in file: Amount transaction currency) Mandatory.
The system handles i) full payment if the transaction amount is the same as the remaining amount within the amount limits of cash and hidden discount rules, ii) part payment if the remaining amount is greater than the payment amount, as well as iii) on account payment if the payment amount is greater than the remaining amount. |
| PTAMOU | 17,03 | System amount (Text in file: Amount system currency) Optional.
If zero, will be calculated by the system based on the exchange rate for the period and level defined in the A/R control file for payments. |
| PTCURR | 4 | Transaction currency (Text in file: Currency) Mandatory. Must be the transaction currency of the document to settle. |
| PTPADT | 8,00 | Payment date (Text in file: Payment date) Mandatory.
Format CCYYMMDD (Century/Year/Month/Day). The date is used for calculating the system currency amount, based on the exchange rate for the period and level defined in the A/R control file for payments. The payment date is also used to control which cash discount deduction is allowed. |
| PTTEXT | 30 | Text (Text in file: Description) Optional.
If blank, will be defaulted from the document type of the payment. |
| PTACYE | 4,00 | Accounting year (Text in file: Accounting year) Not allowed.
The accounting year will be completed by the system from the accounting period of the transaction. |
| PTJONO | 5,00 | Journal number (Text in file: Journal number) Not allowed.
The journal number will be completed by the system when a journal is created. |
| PTSQ50 | 5,00 | Sequence number (Text in file: Sequence no) Not allowed. This is a work field. |
| PTERCD | 1 | Error code (Text in file: Error code) Not allowed.
This is a work field. |
| PTIDNO | 12,00 | Document number (Text in file: Document number) Optional.
If zero, a document number will be retrieved from the document number series defined for the document type for each combination of debtor number, transaction currency and payment date. |
| PTBRNO | 35 | Bank reference number (Text in file: Bank reference number) Optional.
The bank reference number is used to find the document to settle. If blank, the document type and number are used. If the bank reference number and document type/number are blank, the payment will become an open document. |
| PTPRJI | 15 | Project (Text in file: Project id) Not allowed. Not supported in the current release. |
| PTDECCH1-9 | 6,00 | Customer chain 1-9 (Text in file: Customer chain 1-9). |
| PTPDOT | 3 | Payment document type. Different document type depending on payment method.
These are the preloaded ones: OCC = A/R payment received – credit card OCH = A/R payment received – cash OCK = A/R payment received – cheque |
| PTORNO | 12,00 | Order number. The order that this payment belongs to. |
| PTLSEQ | 5,00 | Sequence. Sequence to keep track of more than one payment per order, if you pay with different methods (e.g., 100 SEK cash and the rest with a cheque). |
| PTCASR | 10 | Cash register. The cash register where the money is put (cash). In the end of the day you want to count the money in each cash register. |
| PTUSER | 10 | User id. The user entering the payment on the order. |
| PTCSTS | 7 | Cost centre. The cost center for the order. |
| PTLRRF | 15,0 | Local related reference number. Not allowed. Optional.
The reference number is a link between the local payment file and SROKBP. |