Table 12182 "Vendor Bill Line" (IT)
IT country layer · Microsoft.Bank.Payment
Across versions
- BC23-28not present
- BC29-30present
IT country layer · Microsoft.Bank.Payment · BC29-30 · source at ea08af5e · facts from BC29
An object of the IT localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | Vendor Bill Line |
| DataClassification | CustomerContent |
| Permissions | TableData “Vendor Ledger Entry” = m |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Vendor Bill List No. | Code[20] | — | |
| 2 | Line No. | Integer | — | |
| 5 | Description | Text[45] | — | |
| 6 | Description 2 | Text[45] | — | |
| 10 | Vendor No. | Code[20] | — | TableRelation Vendor |
| 11 | Vendor Name | Text[100] | — | FlowField: lookup(Vendor.Name where(“No.” = field(“Vendor No.”))); not editable |
| 12 | Vendor Bank Acc. No. | Code[20] | — | TableRelation “Vendor Bank Account”.Code where(“Vendor No.” = field(“Vendor No.”)) |
| 14 | Vendor Bill No. | Code[20] | — | |
| 20 | Document Type | Enum “Gen. Journal Document Type” | — | enum Enum 6 “Gen. Journal Document Type” |
| 21 | Document No. | Code[20] | — | TableRelation if (“Document Type” = const(Invoice)) “Purch. Inv. Header” else if (“Document Type” = const(“Credit Memo”)) “Purch. Cr. Memo Hdr.” else if (“Document Type” = const(“Finance Charge Memo”)) “Finance Charge Memo Header” else if (“Document Type” = const(Reminder)) “Reminder Header” |
| 22 | Document Occurrence | Integer | — | |
| 23 | Document Date | Date | — | |
| 24 | External Document No. | Code[35] | — | |
| 25 | Instalment Amount | Decimal | — | not editable |
| 26 | Remaining Amount | Decimal | — | not editable |
| 27 | Amount to Pay | Decimal | — | |
| 30 | Due Date | Date | — | |
| 31 | Beneficiary Value Date | Date | — | |
| 34 | Cumulative Transfers | Boolean | — | |
| 45 | Vendor Entry No. | Integer | — | |
| 50 | Reason Code | Code[10] | — | |
| 60 | Transfer Type | Option | — | OptionCaption: Transfer,Salary |
| 61 | Withholding Tax Amount | Decimal | — | not editable |
| 62 | Social Security Amount | Decimal | — | not editable |
| 63 | Gross Amount to Pay | Decimal | — | not editable |
| 64 | Manual Line | Boolean | — | not editable |
| 65 | Dimension Set ID | Integer | — | TableRelation Dimension Set Entry; not editable |
| 66 | Has Payment Export Error | Boolean | — | FlowField: exist(“Payment Jnl. Export Error Text” where(“Journal Line No.” = field(“Line No.”), “Document No.” = field(“Vendor Bill List No.”))); not editable |
Keys
- Key1: Vendor Bill List No., Line No. (clustered)
- Key2: Vendor No., External Document No., Document Date
- Key3: Vendor Bill List No., Vendor No., Due Date, Vendor Bank Acc. No., Cumulative Transfers
Events published
OnAfterUpdateVendBillWithTaxWHTAmounts(var VendorBillWithholdingTax: Record "Vendor Bill Withholding Tax"; ComputedWithholdingTax: Record "Computed Withholding Tax")(integration)OnCreateVendBillWithhTaxOnAfterVendBillWithhTaxInsert(var VendorBillWithholdingTax: Record "Vendor Bill Withholding Tax")(integration)OnCreateVendBillWithhTaxOnBeforeVendBillWithhTaxInsert(var VendorBillWithholdingTax: Record "Vendor Bill Withholding Tax"; var Vendor: Record Vendor)(integration)OnBeforeUpdateVendBillWithhTaxWHTAmounts(var VendorBillWithholdingTax: Record "Vendor Bill Withholding Tax"; ComputedWithholdingTax: Record "Computed Withholding Tax")(integration)
Procedures
GetCurrCode(): Code[10]EditDimensions()ShowDimensions()ShowPurchInvDimensions()ShowInvoice()ShowVendorBillWithhTax(Open: Boolean)CreateVendBillWithhTax()SetWithholdCode(WithholdingCode: Code[20])SetSocialSecurityCode(SocSecCode: Code[20])InitValues()GetVendBillWithhTax(): BooleanDeletePaymentFileErrors()
Plus 4 local procedures.
Triggers
OnDelete, OnInsert
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Vendor Bill Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A IT country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.