XM_PAYMENT_TYPE

Entity Name XM_PAYMENT_TYPE
Entity Type Independent
Definition This table identifies expense payment types.

Attributes

Attribute Datatype Width Definition
CHANGE_TIMESTAMP DateTime 23
CREDIT_CARD_COMPANY Varchar 25 The name of the credit card company for the payment type, if appropriate.
DESCRIPTION Varchar 42 A description of the payment type.
PAYMENT_METHOD_CODE Integer 1 The payment method code. Possible values for the Payment_method_code INTEGER N: • 1 (Individual Bill/Individual Pay) • 2 (Individual Bill/Company Paid) • 3 (Company Billed/Company Paid) • 4 (Company Paid) • 5 (Personal funds)
PAYMENT_TYPE_ID Integer 7 The primary key for the table identifying each unique payment type.
lastModified DateTime 24
VariationID Integer 13
ACTIVE_STATUS Varchar 4
CHANGE_TIMESTAMP DateTime 23
CREDIT_CARD_COMPANY Varchar 25 The name of the credit card company for the payment type, if appropriate.
DESCRIPTION Varchar 42 A payment type description.
PAYMENT_METHOD_CODE Integer 1 The payment method code. Possible values for the Payment_method_code INTEGER N: • 1 (Individual Bill/Individual Pay) • 2 (Individual Bill/Company Paid) • 3 (Company Billed/Company Paid) • 4 (Company Paid) • 5 (Personal funds)
PAYMENT_TYPE_ID Integer 7 The primary key for the table identifying each unique payment type.
lastModified DateTime 24
VariationID Integer 13
ACTIVE_STATUS Varchar 4