SROKBA is used also when transferring invoice documents from DC1 Distribution. The following fields exist in SROKBA:
| Field | Length | Description |
|---|---|---|
| BTIDEN | 2 | Identity (Text in file: Record type) Mandatory. The code is used to select the transaction when an interface type with this identity is transferred to DC1 Financials. Invoice documents transferred from DC1 Distribution uses the code “DI”. All identities will be changed to “FI” or “DF” for the selected transactions during interfacing so that they cannot be selected again. |
| BTUSED | 1 | Status (Text in file: Status) Not allowed. This is a work field. |
| BTJONO | 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. |
| BTSQ70 | 7,00 | Sequence number (Text in file: Sequence number) Not allowed. This is a work field. |
| BTACYE | 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. |
| BTPERI | 6,00 | Accounting period (Text in file: Accounting period) Mandatory. Format CCYYPP (Century/Year/Period). The period must be an open period within the permitted limits, as defined in the G/L control file. If transactions from more than one accounting year are transferred at the same time, one journal per year will be created. The accounting period can be overridden when the actual transfer is done. |
| BTSTAT | 1 | Status (Text in file: Status) Not allowed. This is a work field. |
| BTINNO | 12,00 | Document number (Text in file: Invoice number) Optional. If zero, the document number will be retrieved from the document number series defined for the document type. The document number will also be used as voucher number if the break level for the interface type is 2. Also, if BTINNO is used the document number series for the document type should have handling code 2 (manual). |
| BTVONO | 12,00 | Voucher number (Text in file: Voucher number) Not allowed. The voucher number will be completed by the system, using document number for break level 2, or the number after last used in the voucher number series for break level 1. |
| BTVODT | 8,00 | Voucher date (Text in file: Voucher date) Not allowed. The system, using document date for break level 2 or the actual system date for break level 1 will complete the voucher date. The voucher date can be overridden when the actual transfer is done. |
| BTDODT | 8,00 | Document date (Text in file: Document date) Mandatory. Format CCYYMMDD (Century/Year/Month/Day). The document date will also be used as voucher date if break level for the interface type is 2. |
| BTDENO | 11 | Debtor number (Text in file: Debtor number) Mandatory. Validated against the Business partner file. If Customer (BTCUNO) is loaded, then the Debtor number will be defaulted with the Customer’s number. |
| BTTCOA | 17,03 | Transaction amount (Text in file: Original amount in transaction currency) Mandatory. The transaction amount sign will give the default document type if the document type is blank:
FKI where transaction amount > 0FKC, where transaction amount < 0FKZ, where transaction amount = 0 |
| BTTCUR | 4 | Transaction currency (Text in file: Transaction currency) Optional. If blank, the currency will be defaulted from the primary currency of the debtor. If completed, it is validated against the Currency table. |
| BTPCOA | 17,03 | Primary amount (Text in file: Original amount in primary currency) Optional. If zero, will be calculated by the system based on the exchange rate for the selected period and level. |
| BTPCUR | 4 | Primary currency (Text in file: Primary currency) Not allowed. The primary currency will be defaulted from the Business partner file. |
| BTSCOA | 17,03 | System amount (Text in file: Original amount in system currency) Optional. If zero, will be calculated by the system based on the exchange rate for the selected period and level. |
| BTDUDT | 8,00 | Due date (Text in file: Due date) Optional. Format CCYYMMDD (Century/Year/Month/Day). If zero, will be calculated from the terms of payment, based on the document date. |
| BTCUNO | 11 | Customer number (Text in file: Customer number) Optional. If completed, it is validated against the Business partner file. |
| BTVIEC | 1 | Export code (Text in file: Import/Export code) Mandatory. Validated against the VAT import/export code table. |
| BTCDBA | 17,03 | Cash discount base (Text in file: Cash discount base) Optional. If zero, will be defaulted from the transaction amount, including or excluding VAT, depending on the parameters for: 1. the terms of payment, or 2. the VAT handling code. |
| BTCDD1 | 8,00 | Cash discount 1 date (Text in file: Cash discount due date 1) |
| BTCDP1 | 5,03 | Cash discount 1 % (Text in file: Cash discount percent 1) |
| BTCDD2 | 8,00 | Cash discount 2 date (Text in file: Cash discount due date 2) |
| BTCDP2 | 5,03 | Cash discount 2 % (Text in file: Cash discount percent 2) Optional. Date format CCYYMMDD (Century/Year/Month/Day). If zero, will be calculated from the terms of payment, based on the document date, unless there is a due date for the document already in the file, in which case the default cash discount conditions will not be used. |
| BTTTXT | 30 | Text (Text in file: Transaction text) Optional. If blank, will be defaulted from the document type. |
| BTTYPC | 1,00 | Exchange rate period (Text in file: Exchange rate period)
Optional. If zero, will be defaulted from the A/R control file. |
| BTCLVL | 1 | Exchange rate level (Text in file: Exchange rate level code)
Optional. If blank, will be defaulted from the A/R control file. |
| BTTIML | 8,00 | Exchange rate time (Text in file: Exchange rate time) Optional. If zero, will be defaulted from the document date and the exchange rate period. The format depends on the exchange rate level code:
The value is right adjusted in the field. |
| BTVOTY | 2 | Voucher type (Text in file: Voucher type) Not allowed. The system will complete the field with the voucher type of the interface type. |
| BTTAAM | 17,03 | Turnover amount (Text in file: Turnover amount) Mandatory. |
| BTCSTS | 7 | Cost centre (Text in file: Cost centre) Optional, but only valid if cost centre accounting is used. If blank, the system will default the cost centre from the Business partner file. If no cost centre is defined in the Business partner file, the cost centre must be completed here. |
| BTNAME | 30 | Sundry name (Text in file: Name) |
| BTADR1 | 35 | Address line 1 (Text in file: Address line 1) |
| BTADR2 | 35 | Address line 2 (Text in file: Address line 2) |
| BTADR3 | 35 | Address line 3 (Text in file: Address line 3) |
| BTADR4 | 35 | Address line 4 (Text in file: Address line 4) |
| BTPOCD | 16 | Postal code (Text in file: Postal code). Mandatory if the debtor number is for a sundry debtor. |
| BTACGP | 2,00 | A/R group (Text in file: A/R-A/P group). Optional. If zero and the control account posting has not already been created by the pre-system (i.e., the control account posting should be created by DC1 Financials), the system will default the A/R group from the Business partner file. |
| BTREFX | 15,00 | Reference number (Text in file: Reference number). Mandatory, if related G/L postings exist in SROIBT. Reference numbers should be retrieved from SROSTYSF, and must be unique per document. |
| BTDEAC | 1 | Control accounted (Text in file: Already control accounted Y/N) Mandatory. Y = the control account is already charged, and a G/L posting exists in SROIBT which should be transferred to DC1 Financials together with the document. N = a control account posting should be generated based on the control account rules for the document type. |
| BTCOAC | 1 | Income accounted (Text in file: Already cost/income accounted Y/N) Mandatory. Y = the income account is already charged, and a G/L posting exists in SROIBT which should be transferred to DC1 Financials together with the document. More than one posting may exist. N = the income account posting should be generated based on: 1. the pseudo account defined below, or 2. the contra accounting rules defined for the document type. |
| BTPSAC | 7 | Pseudo account (Text in file: Pseudo account) Optional. See Income accounted above. The pseudo account is validated against the Pseudo account file. |
| BTINRL | 12,00 | Related document (Text in file: Related invoice number) Optional. The number registered here is not used as any reference. Only for informational purposes. |
| BTRERL | 15,00 | Related reference number (Text in file: Reference number relation) Mandatory, if there is a related document. This reference number is used to connect the document to another document for automatic settlement. Reference numbers must be unique per document. |
| BTERCD | 1 | Error code (Text in file: Error code) Not allowed. This is a work field. |
| BTBRNO | 35 | Bank reference number (Text in file: Bank reference number) Optional. If blank, will be calculated automatically if your country has updated the bank reference calculation program GCFR004 with a country unique calculation. It is used as a unique reference for the document at payment. |
| BTPRJI | 15 | Project (Text in file: Project id) Not allowed. Not supported in the current release. |
| BTTOPC | 3 | Terms of payment (Text in file: Terms of payment) Optional. If blank, will be defaulted from the terms of payment in the Business partner file. Controls instalment and cash discount conditions. |
| BTTAXT | 17,03 | VAT amount (Text in file: VAT amount in transaction currency) Mandatory. If VAT exists for the document, and if instalments should be created. |
| BTDOTY | 3 | Document type (Text in file: Document type) Optional. The transaction amount sign will give the default document type if the document type is blank:
FKI where transaction amount > 0FKC, where transaction amount < 0FKZ, where transaction amount = 0. The document type is mandatory if the type should be used to select the document when an interface type with a defined document type is transferred to DC1 Financials. Validated against the Document type table. |
| BTCNTY | 5 | County code (Text in file: County code) Optional. Country specific field. |
| BTSPCD | 2 | State/Province code (Text in file: State/Province Code) Optional. Country specific field. |
| BTTAXJ | 12 | Tax jurisdiction code (Text in file: Tax Jurisdiction Code) Optional. Country specific field. |
| BTCCOU | 4 | Debtor VAT country (Text in file: Country of customer/supplier) Optional. Only valid if EU reporting is used. If blank, will be defaulted from the country of the debtor address in the Business partner file. |
| BTCTRG | 16 | Debtor VAT number (Text in file: VAT registration number of customer/supplier) Optional. Only valid if EU reporting is used. If blank, will be defaulted from the debtor address in the Business partner file. |
| BTQLCD | 1 | Quarterly list code (Text in file: Quarterly list activity code) Optional. Only valid if EU reporting is used. |
| BTTCOU | 4 | Trader country (Text in file: Country of trade. Optional. If blank, will be defaulted with the system country. |
| BTGRIM | 1 | Group document (Text in file: Batch group document handling) Optional. If blank, will be defaulted from the terms of payment. |
| BTCRDT | 8,00 | Creation date (Text in file: Creation date) Optional. If zero, will be defaulted from the date of the transfer. |
| BTCOTI | 6,00 | Creation time (Text in file: Time) Optional. If zero, will be defaulted from the time of the transfer. |
| BTUSER | 10 | Creation user (Text in file: User id) Optional. If blank, will be defaulted from the user who submitted the transfer. |
| BTDECCH1-9 | 6 | Customer chain 1-9 (Text in file: Customer chain 1-9) Not allowed. Country specific field, Germany. |
| BTPACD | 6 | Payment mode (Text in file: Payment mode) Optional. If entered the payment mode must exist in the Payment mode table and for this customer. |
| BTSAHA | 10 | Main salesman/Handler (Text in file: Salesman/handler) Optional. If entered it is validated against the Signature table. If DC1 Distribution is installed, then the Salesman/Handler has to be defined with YES in the Signature table. |