The following fields exist in SROLBA:
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. All identities will be changed to “FI” for the selected transactions during interfacing so that they cannot be selected again. Invoice documents transferred from the DI interface use the code “ED”. |
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. |
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: FPI where transaction amount < 0FPC, where transaction amount > 0FPZ, where transaction amount = 0. The document type is mandatory if the documents should be final documents or 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. |
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 K 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. |
BTPACD | 6 | Forced payment mode (Text in file: Payment mode) Optional. If completed, only that payment mode will be valid when paying the document through the routine Work with A/P automatic payments.
Payment modes with SEPA scheme = Y in Work with A/P payment modes require: 1) The document’s currency code or the ISO currency code in Work with currencies must be EUR. 2) If bank is completed, BTBKCD, the bank account number must be an IBAN number and the Swift address must contain a Bank Identifier Code (BIC) in the Business partner bank table. |
BTVENO | 11 | Supplier number (Text in file: Supplier number) Mandatory. Validated against the Business partner file. |
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:
FPI where transaction amount < 0FPC, where transaction amount > 0FPZ, 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 supplier. 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 i) supplier invoice date if completed, or ii) document date. |
BTVEIN | 15 | Supplier invoice number (Text in file: Supplier invoice number). Optional. Mandatory if the automatic A/P invoice matching routine is used, i.e., a reference number has been defined in field BTLIRE. The invoice number must be unique for the same supplier number. |
BTSIDT | 8,00 | Supplier invoice date (Text in file: Supplier invoice date) Optional. Format CCYYMMDD (Century/Year/Month/Day). If completed, will be the basis for the calculation of due date. This field is mandatory if function control APINVDAT is active. |
BTVIEC | 1 | Import code (Text in file: Import/Export code) Mandatory. Validated against the VAT import/export code table. |
BTATTE | 1 | Approved for payment (Text in file: Approved for payment Y/N) Optional. If blank, will be defaulted with Y if the invoice document is final, or N if the invoice document is preliminary. |
BTATUS | 10 | Attestor (Text in file: Attestor) Optional. If blank, will be defaulted from the Business partner file. |
BTCDBA | 17,03 | Cash discount base amount (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). |
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.) |
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. |
BTREDT | 8,00 | Reception date (Text in file: Received date) Optional. Format CCYYMMDD (Century/Year/Month/Day). |
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/P control file. |
BTCLVL | 1 | Exchange rate level (Text in file: Exchange rate level code)
H = High Optional. If blank, will be defaulted from the A/P 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) Optional. If zero, will be defaulted from the transaction amount, including or excluding VAT, depending on the parameters in the A/P control file. |
BTCSTS | 7 | Cost centre (Text in file: Cost centre) Optional. Only valid if cost centre accounting is used. If blank, the system will default the cost centre from two different levels. First from the Signature table and secondly from the Business partner file. If no cost centre is defined on either of these three levels, the cost centre must be completed here. |
BTCUNB | 30 | Customs number (Text in file: Foreign payment information 1) |
BTCTNO | 30 | Contract number (Text in file: Foreign payment information |
BTNBAN | 30 | National bank number (Text in file: Foreign payment information 3) Customs number is mandatory information for documents that have forced payment mode. The other fields are optional. |
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. For automatic A/P invoice matching: Valid only for control accounting; otherwise zero. |
BTACGP | 2,00 | A/P 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/P group from the Business partner file. |
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 | Cost accounted (Text in file: Already cost/income accounted Y/N) Mandatory.
Y = the cost 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 cost account posting should be generated based on: 1. the pseudo account defined below, or 2. the contra accounting rules defined for the document type. For automatic A/P invoice matching: Must be N. (Any cost accountings should be placed in SROLBAL.) |
BTPSAC | 7 | Pseudo account (Text in file: Pseudo account) Optional. See Cost accounted above. The pseudo account is validated against the Pseudo account file. |
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. |
BTSTOP | 2 | Payment stop code (Text in file: Payment stop code) Optional. If completed, it is validated against the Stop code table. |
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 on. 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. The terms of payment control the credit period, cash discount and instalment conditions. If blank, will be defaulted from firstly either the Document type table or the terms of payment in the Business partner file. |
BTBKCD | 3 | Supplier bank (Text in file: Bank code) Optional. If entered it is validated against the A/P supplier bank table. If a payee number has been entered in the Business partner file for the supplier the bank must exist for the payee number in the A/P supplier bank table.
Refers to the Payment mode field, BTPACD. |
BTICPC | 3 | Intra-company payment (Text in file: Intra-company payment code) Optional. Only valid if EDI is used. |
BTPACC | 3 | Payment channel code (Text in file: Payment channel code) Optional. Only valid if EDI is used. |
BTPAMC | 3 | Payment mean code (Text in file: Payment mean code) Optional. Only valid if EDI is used. |
BTRFTX | 70 | Free text (Text in file: Free text) Optional. Only valid if EDI is used. |
BTRLAC | 3 | Language (Text in file: Language) Optional. Only valid if EDI is used. |
BTEXRT | 13,07 | Transaction currency exchange rate (Text in file: Exchange rate transaction currency) Not allowed. This is a work field. |
BTIDNO | 12,00 | Document number (Text in file: Document 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. |
BTRVAT | 15,00 | Related VAT transaction (Text in file: Related VAT transaction) Mandatory if related VAT transactions exist in SROLBV. This is the reference number of the transaction. Reference numbers must be unique. |
BTCNTY | 5 | County code (Text in file: County code) Not allowed. Country specific field. |
BTSPCD | 2 | State/Province code (Text in file: State/Province Code) Not allowed. Country specific field. |
BTTAXJ | 12 | Tax jurisdiction code (Text in file: Tax Jurisdiction Code) Not allowed. Country specific field. |
BTCCOU | 4 | Supplier 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 payee address in the Business partner file. |
BTCTRG | 16 | Supplier 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 payee 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. (Now called EU VAT report.) |
BTTCOU | 4 | Trader country (Text in file: Country of trader) Optional. If blank, will be defaulted with the system country. |
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. |
BTRSUN | 15,00 | Related sundry supplier transaction (Text in file: Related sundry supplier transaction). Mandatory, if related sundry information exist in SROLBS. This is the reference number of the transaction. Reference number must be unique. |
BTRAPY | 15,00 | Related additional payment transaction (Text in file: Related additional payment transaction) Mandatory, if related extra payment information exist in the A/P batch transaction credit transfer file, SROLBACT, or in the local file. This is the reference number of the transaction. Reference number must be unique.
For payment modes used for Credit transfer and SEPA Credit transfer the extension file is SROLBACT and the reference field is CTREFX. |
BTLIRE | 15,00 | A/P invoice line ref no (Text in file: A/P invoice line ref no). Mandatory if related invoice lines exist in SROLBAL. Otherwise zero. Reference number must be unique and preferably retrieved from the REFX number series in the G/L control file. |
BTOHLD | 1 | On hold Y/N (Text in file: On hold Y/N). Optional.
Y = Record is on hold and will not be retrieved from the General Interface file, SROLBA. Other values: Not on hold. |
BTBANO | 3 | Batch number for A/P Workflow. (Text in file: Batch number). Not allowed. This field is used to group selected A/P invoices into one batch. The batch number will be completed by the system when LBA records are selected for routine A/P Workflow. |
BTEWPROM | 1 | Promotion Y/N, A/P Workflow (Text in file: Promotion Y/N, A/P eWorkflow). Optional. Only valid if A/P Workflow is used.
Y = Promote |
BTEWSCID | 9 | Scan id, A/P Workflow (Text in file: Scan id, A/P eWorkflow). Optional. Only valid if A/P Workflow is used. |