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 Number: Transaction number, consecutive
  • Company: Company number
  • Document: Transaction number, consecutive
  • Line: Number of the line within the record or document
  • Withholding Code: Code of the withholding applied
  • Withholding Type..: Classification of the withholding
  • Document type: Tax ID type of the partner
  • Tax ID Number: Partner's tax ID number
  • Verification Digit58: Verification digit
  • Branch: Branch number
  • Currency: Currency or currency of record
  • City: City code
  • Business activity code: ISIC code
  • Base Value: 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
  • Period: Fiscal period
  • Type of operation: Type of mathematical operation that performs the withholding, addition, subtraction or neutral.
  • Document date: Date of the transaction
  • Dimension 1, 2,3,4,5...: Dimension Code
Code Description Path
lpcol2509m000 Outstanding Customer Invioces Localization/ Colombia / Inquiry / Outstanding Customer Invioces

Outstanding customer invoices