Client Accounts Payable Setup information table |
client_KEY | int (4) | NOT NULL | Primary key for this table |
ap__gl_accounting_method_KEY | int (4) | NOT NULL | GL accounting methods supported by AP |
ap__automatic_payment_application_method_KEY | int (4) | NOT NULL | AP automatic payment application methods supported by AP |
ap_discount_method_KEY | int (4) | NOT NULL | AP discount methods supported by AP |
ap__gl_account_KEY | int (4) | | The client Accounts Payable general ledger account |
ap_discount__gl_account_KEY | int (4) | | The GL account used to track the discount methods of Net and Gross |
use_reference_number | bit (1) | NOT NULL | Flag indicating whether or not we want to use reference number on payables and AP transactions. |
use_purchase_order_number | bit (1) | NOT NULL | Flag indicating whether or not we want to use purchase order number on payables and AP transactions. |
purchase_order_number__duplicate_treatment_KEY | int (4) | NOT NULL | Duplicate purchase order number treatment methods supported by AP. This value is ignored when use_purchase_order_number is false. |
use_due_date_as_payment_date_manage_ap_payment | bit (1) | NOT NULL | Flag that is used in Manage AP Payments to know if for a client we want to use a payable due date as the date of a new pending payment to be created in Manage AP Payments to pay one or more payables. If several payables are to be paid together, the oldest due date will be used as the payment date when this flag is set true. When this flag is set false, then the payment date defaults to the AP date. |
reference_number__duplicate_treatment_KEY | int (4) | NOT NULL | Duplicate reference number treatment methods supported by AP. This value is ignored when use_reference_number is false. |