FBL is the link table between FBD and the corresponding contracts.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Finance Base Row Link | Text | 8 | 1 | Edit | Yes | Public | ||
FBDINR | INR of linked Finance Base Document | Text | 8 | 1 | Edit | Yes | Public | ||
NUM | Sequence number in document | Numeric | 20 | 0 | Edit | Yes | Public | ||
OWNREF | Own Reference of entry | Text | 60 | 1 | Edit | Yes | Public | ||
NAM | Externally Displayed Name to Identify the entry | Text | 60 | 1 | Edit | Yes | Public | ||
PLIN | P-line information of invoice line | Text | 40 | 1 | Edit | Yes | Public | ||
TRMCOD | Terms Code | Text | 40 | 1 | Edit | Yes | Public | ||
ADBRAT | Adb Rate | Numeric | 14 | 6 | Edit | Yes | Public | ||
CNT | Quantity | Numeric | 16 | 0 | Edit | Yes | Public | ||
CUR | Currency | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
AMT | Amount | Numeric | 18 | 3 | Edit | Yes | Public | ||
DUEDAT | Due Date | Date | 16 | 0 | Date | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
FBR_FBDINR | FBDINR | |
FBR_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter FBL. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
Unique internal ID of the linked Finance Base Document
Number of entry to preserve the sequence of entries. For entries created by EDI filebased import this field is filled from invoice-line-number.
For entries created by EDI filebased import this field is filled from invoice-line-reference
This field holds the displayed descriptive name used in the application to describe the contract and to search for a contract. Within the default configuration this field is set by a default rule based on contract amount and main party and cannot be modified by the user.
For entries created by EDI filebased import this field is filled from invoice-line-narrative
For entries created by EDI filebased import this field is filled from invoice-line-p-line.
For entries created by EDI filebased import this field is filled from invoice-line-terms-code
For entries created by EDI filebased import this field is filled from invoice-line-adbrate
For entries created by EDI filebased import this field is filled from invoice-line-quantity.
Currency of the linked Finance Base Document amount
For entries created by EDI filebased import this field is filled from invoice-line-price.
Remark: AMT is the unit priice
Due date of the invoice line
For entries created by EDI filebased import this field is filled from invoice-line-due-date.
This field holds the version counter to keep track of the version history of an FBR entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.