Snowflake VC Object: Payment Terms

Last updated
Save as PDF

► Payment Terms

Field	Datatype	Description
CLIENT_NO	NUMBER	CLIENT_NO uniquely identifying each unique client
BATCH_ID	NUMBER	BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID	NUMBER	CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP	TIMESTAMP_NTZ	EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID	TEXT	EVENT_ID for the change JSON record
CREATETIME	NUMBER	CREATETIME createtime of the changed JSON record
ACTIONS	TEXT	ACTIONS for create, load, update, delete determining processing behavior for the record.
PAYMENT_TERM_NO	NUMBER	The payment_term_no for the referenced record.
CLIENT_PAYMENT_TERM_ID	TEXT	The unique identifier for a client payment term id.
NAME	TEXT	The payment terms name.
DESCRIPTION	TEXT	A verbose description of the payment term.
IS_EAN_OR_GLN	BOOLEAN	Are the payment terms EAN or GLN?
ACCOUNT_GROUP_SCOPE_NO	NUMBER	The unique identifier for a account group scope number.
ACCOUNT_GROUP_NO	NUMBER	The unique identifier for a account group number.
CLIENT_ACCOUNT_GROUP_ID	TEXT	The unique identifier for a client account group id.
DAYS_UNTIL_DUE	NUMBER	The number of days until the payment is due.
DAYS_UNTIL_DUE_METHOD_NO	NUMBER	The unique identifier for a days untile due method number.
BILL_LAG_DAYS	NUMBER	The billing lag in number of days.
DISCOUNT_PERCENT	NUMBER	The discount percentage rate.
DISCOUNT_PERIOD	NUMBER	The discount period.
SURCHARGE_NO	NUMBER	The surcharge_no for the referenced record.
CLIENT_SURCHARGE_ID	TEXT	The client_surcharge_no for the referenced record.
AUTO_BILL_ORDERS	BOOLEAN	Should orders be auto billed?
PAYMENT_REMINDER_NO	NUMBER	The unique identifier for a payment reminder number.
PAYMENT_REMINDER_CONFIGURATIONS	VARIANT	The payment reminder configuration.
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data.
Child Views
Variant	Source Table	Child View Name
PAYMENT_REMINDER_CONFIGURATIONS	PAYMENT_TERMS	VM_PT_PAYMENT_REMINDER_CONFIGURATIONS