|
| Displays Tax State ID |
ProductCode | TM Site Item # |
|
|
UnitPrice | See Pricing Method |
| Displays Call entry price |
PrepayAmount | Not Used. | N/A | Blank |
DelInst | TM Will Call Comments + TM Site Description + TM Site Instructions |
| http://jira.irelyserver.com/browse/TM-1751 |
DelType | TM Fill Method |
|
|
CreditCode | TM Site Terms |
|
|
LastDeliveryDate | TM Site Last Delivery |
|
|
LastDeliveryVolume | TM Site Last Gallons |
|
|
ARBalance | A/R Bill To Total Balance |
| Customer Balance select vwcus_balance, * from vwcusmst where vwcus_key = '<customer number>' The arBalance field should be left blank ("") if not used |
DiscountType | TM Site Terms |
| Default to "D" for now |
DiscountRate | A/R Terms Disc % | N/A | Blank |
DiscountDays | A/R Terms Disc Days | N/A | Blank |
DiscountTxt | A/R Terms Description | N/A | Blank |
DiscountCode | N/A | N/A | Blank |
PlanPrice | A/R Contract Price |
| Should display the selected contract price only. If no contract is selected or no contract for customer, display blank. Displays 0. |
PlanRemainingGal | A/R Contract Balance |
| Blank or 0 |
OffPlanPrice | See Pricing Method |
| Displays Call Entry Price |
TicketNumber | N/A. Displays Ticket Assigned |
| Displays Ticket Assigned in TM |
priceGal2 | See Pricing Method |
| Same with UnitPrice |
addCharge1 | N/A | N/A | Blank |
addChargeLabel1 | N/A | N/A | Blank |
addChargeTax1 | N/A | N/A | Blank |
addCharge2 | N/A - Need method for additional fees. | N/A | Blank |
addChargeLabel2 | N/A | N/A | Blank |
addChargeTax2 | N/A | N/A | Blank |
balanceReflects | Always Y or N? | N/A | Blank |
po_number | TM Site Recurring PO |
|
|
divisionNumber | TM Site Location |
| Should display Location No |
CustomerRequest | TM Site Will Call = Y |
| Displays N if Fill Method is not equal to WIll Call |
Sequence | N/A |
| **Displays intContractDetailId of tblCTContractDetail Displays Blank even TM Sequence field has value |
usePreset | Yes when Will Call Quantity Requested is entered. |
| Displays N if Fill Method is not equal to WIll Call |
deliveryGroup | TM Site Fill Group | N/A | Blank |
serialNumber | TM Tank Serial # |
|
|
alwaysDiscount | TBD | N/A | Blank |
emailAddr | A/R Contact E-mail addresses That are setup with Invoices for eMail Distribution | N/A | Blank |
TruckNumber | N/A | N/A | Blank |
ContractNum | A/R Contract # | N/A | Blank |
TankPctFull | TM Site Estimated % Full | N/A | Blank. No tracking on what was the %full during the last delivery |
addCharge3+A86A78:A88A78:A9A78:A111 | additional charges for additives etc | N/A | Blank |
addChargeLabel3 | Text to print on delivery Ticket | N/A | Blank |
addChargeTax3 | tax on additional charge | N/A | Blank |
addCharge4 | additional charges for additives etc | N/A | Blank |
addChargeLabel4 | Text to print on delivery Ticket | N/A | Blank |
addChargeTax4 | tax on additional charge | N/A | Blank |
addCharge5 | additional charges for additives etc | N/A | Blank |
addChargeLabel5 | Text to print on delivery Ticket | N/A | Blank |
addChargeTax5 | tax on additional charge | N/A | Blank |
addCharge6 | additional charges for additives etc | N/A | Blank |
addChargeLabel6 | Text to print on delivery Ticket | N/A | Blank |
addChargeTax6 | tax on additional charge | N/A | Blank |
addCharge7 | additional charges for additives etc | N/A | Blank |
addChargeLabel7 | Text to print on delivery Ticket | N/A | Blank |
addChargeTax7 | tax on additional charge | N/A | Blank |
addCharge8 | additional charges for additives etc | N/A | Blank |
addChargeLabel8 | Text to print on delivery Ticket | N/A | Blank |
addChargeTax8 | tax on additional charge | N/A | Blank |
RunOutDDay | degree day estimate for tank runout / formerly called degreeDayRunout | N/A | Blank |
BringTicketBack | Message for driver to bring delivery ticket back to office |
| If blank will default to 'N' |
ownedTank | Message for driver that tank is owned by customer |
| If blank will default to 'N' |
hwAcct | Flag to indicate that this is a hot water account |
| if blank will to default to 'N' |
PAR | Price above Rack |
| Blank |
PriceAdjustment | Price Adjustment Flag |
| IF blank will default to 'N; |
ScheduleSubType | type of automatic delivery, julian, day-of-week |
| if blank will not be displayed |
addChargeCode1-DO NOT USE | associated with add charge | N/A | Blank |
addChargeCode2-DO NOT USE | associated with add charge | N/A | Blank |
addChargeCode3 | associated with add charge | N/A | Blank |
addChargeCode4 | associated with add charge | N/A | Blank |
addChargeCode5 | associated with add charge | N/A | Blank |
addChargeCode6 | associated with add charge | N/A | Blank |
addChargeCode7 | associated with add charge | N/A | Blank |
addChargeCode8 | associated with add charge | N/A | Blank |
addCharge1Prefix-DO NOT USE | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge2Prefix-DO NOT USE | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge3Prefix | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge4Prefix | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge5Prefix | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge6Prefix | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge7Prefix | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A | Blank |
addCharge8Prefix | determines special add charge cases. Blank or no prefix indicates a flat fee. 'N' for Negative value to be subtracted 'P' apply value as percent of unit price * vol. 'U' apply value as unit charge per unit vol. Note: P and U type Add charges, can be entered as negative values to produce a credit on the invoice. | N/A |
|