285511 - Revision history

DuttonT: /* Fuel Surcharge Maintenance */

2011-05-13T08:40:52Z

Fuel Surcharge Maintenance

← Older revision		Revision as of 10:40, 13 May 2011
Line 127:		Line 127:
	The fuel surcharge will no longer be displayed in detail on the invoices for each collection manifest but instead as an invoice total. The fuel surcharge on the Invoice will be calculated as the net amount (order charges and minimum collections) multiplied by the fuel surcharge for the operational week ending date and this value will be stored in a new field FUEL_AMOUNT which will be added to the ACC_INVOICE table .		The fuel surcharge will no longer be displayed in detail on the invoices for each collection manifest but instead as an invoice total. The fuel surcharge on the Invoice will be calculated as the net amount (order charges and minimum collections) multiplied by the fuel surcharge for the operational week ending date and this value will be stored in a new field FUEL_AMOUNT which will be added to the ACC_INVOICE table .

	In the INV package, the procedure UPDATE_TOTALS will be amended to exclude fuel ~~furcharge~~ records from the NET_AMOUNT and populate the new FUEL_AMOUNT field.		In the INV package, the procedure UPDATE_TOTALS will be amended to exclude fuel surcharge records from the NET_AMOUNT and populate the new FUEL_AMOUNT field.

	== VAT ==		== VAT ==

DuttonT: /* Data */

2011-05-13T08:39:23Z

Data

@@ Line 99: / Line 99: @@
 [[Image:285511_2.png]]
@@ Line 115: / Line 105: @@
 [[Image:285511_3.png]]
@@ Line 132: / Line 111: @@
 [[Image:285511_4.png]]
@@ Line 142: / Line 116: @@
 [[Image:285511_5.png]]
 = Functional Description =

DuttonT: /* Data */

2011-05-13T08:32:30Z

Data

← Older revision		Revision as of 10:32, 13 May 2011
Line 96:		Line 96:

	The following script will be utilised to create the new database table ORG_CUST_FUEL. This will allow effective dates to be maintained for fuel surcharge percentages on a customer by customer basis.		The following script will be utilised to create the new database table ORG_CUST_FUEL. This will allow effective dates to be maintained for fuel surcharge percentages on a customer by customer basis.


			[[Image:285511_2.png]]


	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL
Line 108:		Line 112:

	The following script will be utilised to create the new database table ACC_PAYMENT_LINES. This will store the tiered audit trail calculation used to build up the order change for each consignment.		The following script will be utilised to create the new database table ACC_PAYMENT_LINES. This will store the tiered audit trail calculation used to build up the order change for each consignment.

			[[Image:285511_3.png]]

	CREATE TABLE ACC_PAYMENT_LINES		CREATE TABLE ACC_PAYMENT_LINES
Line 123:		Line 129:

	An additional column will be added to the ACC_INVOICE table to store the total invoice calculated fuel surcharge amount and the tax point date for the invoice (will be printed as invoice date on the revised invoice front sheet).		An additional column will be added to the ACC_INVOICE table to store the total invoice calculated fuel surcharge amount and the tax point date for the invoice (will be printed as invoice date on the revised invoice front sheet).

			[[Image:285511_4.png]]

	ALTER TABLE ACC_INVOICE		ALTER TABLE ACC_INVOICE
Line 132:		Line 140:

	An additional column will be added to the ACC_PAYMENT table to store a flag denoting whether the transaction is a minimum collection surcharge.		An additional column will be added to the ACC_PAYMENT table to store a flag denoting whether the transaction is a minimum collection surcharge.

			[[Image:285511_5.png]]

	ALTER TABLE ACC_PAYMENT		ALTER TABLE ACC_PAYMENT

DuttonT: /* Data */

2011-05-13T08:30:37Z

Data

← Older revision		Revision as of 10:30, 13 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	:;CUSTOMER_ID :VARCHAR2(50)		CUSTOMER_ID VARCHAR2(50)

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE

DuttonT: /* Data */

2011-05-13T08:30:18Z

Data

← Older revision		Revision as of 10:30, 13 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	;CUSTOMER_ID :VARCHAR2(50)		:;CUSTOMER_ID :VARCHAR2(50)

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE

DuttonT: /* Data */

2011-05-12T14:45:19Z

Data

← Older revision		Revision as of 16:45, 12 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	CUSTOMER_ID VARCHAR2(50)		;CUSTOMER_ID :VARCHAR2(50)

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE

DuttonT: /* Data */

2011-05-12T14:43:51Z

Data

← Older revision		Revision as of 16:43, 12 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	CUSTOMER_ID ~~<tab>~~VARCHAR2(50)~~</tab>~~		CUSTOMER_ID VARCHAR2(50)

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE

DuttonT: /* Data */

2011-05-12T14:43:36Z

Data

← Older revision		Revision as of 16:43, 12 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	CUSTOMER_ID VARCHAR2(50)		CUSTOMER_ID <tab>VARCHAR2(50)</tab>

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE

DuttonT: /* Data */

2011-05-12T14:42:40Z

Data

← Older revision		Revision as of 16:42, 12 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	CUSTOMER_ID ~~<TAB:~~VARCHAR2(50)		CUSTOMER_ID VARCHAR2(50)

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE

DuttonT: /* Data */

2011-05-12T14:42:27Z

Data

← Older revision		Revision as of 16:42, 12 May 2011
Line 99:		Line 99:
	CREATE TABLE ORG_CUST_FUEL		CREATE TABLE ORG_CUST_FUEL

	CUSTOMER_ID #TAB:VARCHAR2(50)		CUSTOMER_ID <TAB:VARCHAR2(50)

	EFFECTIVE_DATE DATE		EFFECTIVE_DATE DATE