Outstanding Customer Invoices

These queries show in detail the withholdings applied to customers, grouping them by withholding concept and NIT, additionally, it presents the bases, withholding percentages and withholding amount, etc.

Fields:
  • Transaction Type: Transaction type code
  • Document: Transaction number, consecutive
  • Financial Company: Company number
  • Document: Transaction number, consecutive
  • Line: Number of the line within the record or document
  • Withholding Tax Code: Code of the withholding applied
  • Withholding Type: Classification of the withholding
  • Identification Document Type: Tax ID type of the partner
  • Identification Number: Partner's tax ID number
  • Check Digit: Verification digit
  • Branch: Branch number
  • Currency: Currency or currency of record
  • City: City code
  • Commercial Activity: ISIC code
  • Base Amount: Base amount for withholding in the currency or currency of record
  • DP Base Value (1): Base amount for the withholding tax in the company's own currency
  • DP Base Value (2): Base amount for withholding in the company's own currency (2)
  • DP Base Value (3): Base amount for withholding in company currency three (3)
  • Percentage: Rate or percentage of withholding applied
  • Tax Value: Calculated amount of the withholding in the currency or currency of record
  • PD Tax Value (1): Calculated withholding tax amount in the company's own currency
  • DP Tax Value (2): Calculated amount of withholding tax in the company's own currency (2)
  • PD Tax Value (3): Calculated amount of withholding tax withheld in company currency three (3)
  • Debit Account: Code of the debit accounting account
  • Credit Account: Code of the credit accounting account
  • Fiscal Year: Fiscal year
  • Fiscal Period: Fiscal period
  • Type Operation: Type of mathematical operation that performs the withholding, addition, subtraction or neutral.
  • Transaction Date: Date of the transaction
  • Dimension 1, 2,3,4,5...: Dimension Code
Code Description Path
lpcol2509m000 Outstanding Customer Invoices Localization/Colombia/Inquiry/Outstanding Customer Invoices

Outstanding customer invoices