Table: dbo.Client_AP_Setup
Client Accounts Payable Setup information table
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Client_AP_Setup$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_AP_Setup__AP_Discount_Method__ap_discount_method_KEY | ap_discount_method_KEY | AP_Discount_Method (ap_discount_method_KEY) |
FK_Client_AP_Setup__Automatic_Payment_Application_Method__ap__automatic_payment_application_method_KEY | ap__automatic_payment_application_method_KEY | Automatic_Payment_Application_Method (automatic_payment_application_method_KEY) |
FK_Client_AP_Setup__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_AP_Setup__Duplicate_Treatment__purchase_order_number__duplicate_treatment_KEY | purchase_order_number__duplicate_treatment_KEY | Duplicate_Treatment (duplicate_treatment_KEY) |
FK_Client_AP_Setup__Duplicate_Treatment__reference_number__duplicate_treatment_KEY | reference_number__duplicate_treatment_KEY | Duplicate_Treatment (duplicate_treatment_KEY) |
FK_Client_AP_Setup__GL_Account__ap__gl_account_KEY | ap__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AP_Setup__GL_Account__ap_discount__gl_account_KEY | ap_discount__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_AP_Setup__GL_Accounting_Method__ap__gl_accounting_method_KEY | ap__gl_accounting_method_KEY | GL_Accounting_Method (gl_accounting_method_KEY) |