Table: dbo.Client_AP_Setup
Client Accounts Payable Setup information table
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key for this table
ap__gl_accounting_method_KEYint (4)NOT NULLGL accounting methods supported by AP
ap__automatic_payment_application_method_KEYint (4)NOT NULLAP automatic payment application methods supported by AP
ap_discount_method_KEYint (4)NOT NULLAP discount methods supported by AP
ap__gl_account_KEYint (4)The client Accounts Payable general ledger account
ap_discount__gl_account_KEYint (4)The GL account used to track the discount methods of Net and Gross
use_reference_numberbit (1)NOT NULLFlag indicating whether or not we want to use reference number on payables and AP transactions.
use_purchase_order_numberbit (1)NOT NULLFlag indicating whether or not we want to use purchase order number on payables and AP transactions.
purchase_order_number__duplicate_treatment_KEYint (4)NOT NULLDuplicate 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_paymentbit (1)NOT NULLFlag 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_KEYint (4)NOT NULLDuplicate reference number treatment methods supported by AP. This value is ignored when use_reference_number is false.
Primary key
NameColumnsDescription
PK_Client_AP_Setup$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_AP_Setup__AP_Discount_Method__ap_discount_method_KEYap_discount_method_KEYAP_Discount_Method (ap_discount_method_KEY)
FK_Client_AP_Setup__Automatic_Payment_Application_Method__ap__automatic_payment_application_method_KEYap__automatic_payment_application_method_KEYAutomatic_Payment_Application_Method (automatic_payment_application_method_KEY)
FK_Client_AP_Setup__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_AP_Setup__Duplicate_Treatment__purchase_order_number__duplicate_treatment_KEYpurchase_order_number__duplicate_treatment_KEYDuplicate_Treatment (duplicate_treatment_KEY)
FK_Client_AP_Setup__Duplicate_Treatment__reference_number__duplicate_treatment_KEYreference_number__duplicate_treatment_KEYDuplicate_Treatment (duplicate_treatment_KEY)
FK_Client_AP_Setup__GL_Account__ap__gl_account_KEYap__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AP_Setup__GL_Account__ap_discount__gl_account_KEYap_discount__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_AP_Setup__GL_Accounting_Method__ap__gl_accounting_method_KEYap__gl_accounting_method_KEYGL_Accounting_Method (gl_accounting_method_KEY)

Schema diagram