Project

General

Profile

Edit Copy Actions

Feature #10

open

Payment Terms Master

Added by Anil KV over 2 years ago. Updated 5 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Target version:
Start date:
08/04/2022
Due date:
08/08/2022 (over 2 years late)
% Done:

70%

Estimated time:
20:00 h
Owner(Agency):
Travvise
Time Taken(HH):
37.00
Module:
Payment Terms
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Payment Terms

CREATE TABLE accounts.tbl_payment_terms (
pk_payment_terms_id BIGSERIAL PRIMARY KEY,

sin_payment_mode SMALLINT NOT NULL DEFAULT 1, --*1
sin_next_day_week_month SMALLINT DEFAULT 0, --*2
sin_based_on SMALLINT NULL DEFAULT 1, --*2
vhr_payment_term_string VARCHAR(250) NOT NULL,
sin_if_supplier SMALLINT DEFAULT 1,
sin_if_customer SMALLINT DEFAULT 1
) INHERITS(tbl_action_user_and_date_time);
--*1 > 0 = No Terms
-
1 = Cash Only
-- 2 = Advance Payment
-- 3 = Same Month
-- 4 = Same Fortnight
-- 5 = Same Week
-- 6 = Same Day
-- 7 = Next Month
-- 8 = Next Fortnight
-- 9 = Next Week
-- 10 = Next Day
--*2 > *1>7 and 0 Input then consider Next Month End, MAX Value=31
-- *1->8 and 0 Input then consider Next Fortnight End, MAX Value=15
-- *1->9 and 0 Input then consider Next Week End, MAX Value=7
-- *1->10 then Inut is must, MIN=1, MAX=365
--*3 > 1 = Document Date
-
2 = Submission Date
-- 3 = Issue Date
-- 4 = Travel/Check In/From Date
-- 5 = Return/Check Out/To Date

Files

1-CsModel.txt (1.4 KB) 1-CsModel.txt Anil KV, 08/04/2022 12:03 PM
2-tsModel.txt (1002 Bytes) 2-tsModel.txt Anil KV, 08/04/2022 12:03 PM
4-CsControllerFile.txt (24.3 KB) 4-CsControllerFile.txt Anil KV, 08/04/2022 12:03 PM
3-CsFile.txt (12.9 KB) 3-CsFile.txt Anil KV, 08/04/2022 12:03 PM
6-HtmlFile.txt (1.91 KB) 6-HtmlFile.txt Anil KV, 08/04/2022 12:03 PM
5-TsFile.txt (13.6 KB) 5-TsFile.txt Anil KV, 08/04/2022 12:03 PM
sql.txt (13.4 KB) sql.txt Anil KV, 08/04/2022 12:03 PM
clipboard-202412311431-v03p0.png (98.7 KB) clipboard-202412311431-v03p0.png Arathy PS, 12/31/2024 02:31 PM
BSP-Payment-Cycle-Travelify.jpg (177 KB) BSP-Payment-Cycle-Travelify.jpg Junaid M, 03/04/2025 12:30 PM
clipboard-202503041259-jtf3b.png (72.6 KB) clipboard-202503041259-jtf3b.png Arathy PS, 03/04/2025 12:59 PM
clipboard-202503131525-srywr.png (105 KB) clipboard-202503131525-srywr.png Theja Ponon, 03/13/2025 03:25 PM

Add

Subtasks


Add

Related issues

Edit Copy Actions

Also available in: Atom PDF