Skip to main content

Window: Invoice Payment Schedule

[Created: 03/06/2003 - Updated: 30/06/2021 ]
Description: Maintain Invoice Payment Schedule
Help: Maintain Payment Schedule of unpaid invoices

Tab: Invoice

[Created: 03/06/2003 - Updated: 11/09/2013 ]
Description: Select Invoice
Help: Select from invoices not fully paid.
Tab Level: 0

Table 10: Invoice - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_invoice.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_invoice.AD_Org_ID numeric(10)
Table Direct
OrderOrderThe Order is a control document. The Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you close an order, unshipped (backordered) quantities are cancelled.c_invoice.C_Order_ID numeric(10)
Search
Document TypeDocument type or rulesThe Document Type determines document sequence and processing rulesc_invoice.C_DocType_ID numeric(10)
Table Direct
Document NoDocument sequence number of the documentThe document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order).c_invoice.DocumentNo character varying(30)
String
Document StatusThe current status of the documentThe Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action fieldc_invoice.DocStatus character(2)
List
Date InvoicedDate printed on InvoiceThe Date Invoice indicates the date printed on the invoice.c_invoice.DateInvoiced timestamp without time zone
Date
Sales RepresentativeSales Representative or Company AgentThe Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user.c_invoice.SalesRep_ID numeric(10)
Search
Self-ServiceThis is a Self-Service entry or this entry can be changed via Self-ServiceSelf-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality.c_invoice.IsSelfService character(1)
Yes-No
DescriptionOptional short description of the recordA description is limited to 255 characters.c_invoice.Description character varying(255)
Text
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonc_invoice.C_BPartner_ID numeric(10)
Search
Partner LocationIdentifies the (ship to) address for this Business PartnerThe Partner address indicates the location of a Business Partnerc_invoice.C_BPartner_Location_ID numeric(10)
Table Direct
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactc_invoice.AD_User_ID numeric(10)
Table Direct
Payment RuleHow you pay the invoiceThe Payment Rule indicates the method of invoice payment.c_invoice.PaymentRule character(1)
Payment
CurrencyThe Currency for this recordIndicates the Currency to be used when processing or reporting on this recordc_invoice.C_Currency_ID numeric(10)
Table Direct
Grand TotalTotal amount of documentThe Grand Total displays the total amount including Tax and Freight in document currencyc_invoice.GrandTotal numeric
Amount
Payment TermThe terms of Payment (timing, discount)Payment Terms identify the method and timing of payment.c_invoice.C_PaymentTerm_ID numeric(10)
Table Direct
Total LinesTotal of all document linesThe Total amount displays the total of all lines in document currencyc_invoice.TotalLines numeric
Amount
Pay Schedule validIs the Payment Schedule is validPayment Schedules allow to have multiple due dates.c_invoice.IsPayScheduleValid character(1)
Yes-No

Tab: Payment Schedule

[Created: 03/06/2003 - Updated: 02/01/2000 ]
Description: Mainain Payment Schedule
Help:
Tab Level: 1

Table 20: Payment Schedule - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_invoicepayschedule.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_invoicepayschedule.AD_Org_ID numeric(10)
Table Direct
InvoiceInvoice IdentifierThe Invoice Document.c_invoicepayschedule.C_Invoice_ID numeric(10)
Search
Payment SchedulePayment Schedule TemplateInformation when parts of the payment are duec_invoicepayschedule.C_PaySchedule_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.c_invoicepayschedule.IsActive character(1)
Yes-No
Due DateDate when the payment is dueDate when the payment is due without deductions or discountc_invoicepayschedule.DueDate timestamp without time zone
Date
Amount dueAmount of the payment dueFull amount of the payment duec_invoicepayschedule.DueAmt numeric
Amount
Discount DateLast Date for payments with discountLast Date where a deduction of the payment discount is allowedc_invoicepayschedule.DiscountDate timestamp without time zone
Date
Discount AmountCalculated amount of discountThe Discount Amount indicates the discount amount for a document or line.c_invoicepayschedule.DiscountAmt numeric
Amount
ValidateValidate Payment Schedulec_invoicepayschedule.Processing character(1)
Button
ValidElement is validThe element passed the validation checkc_invoicepayschedule.IsValid character(1)
Yes-No