| aud_RRN |
|
integer
|
|
| aud_DatePosted |
|
string
|
|
| aud_CustomerNumber |
|
integer
|
|
| aud_DivisionNumber |
|
integer
|
|
| aud_Pending |
|
string
|
|
| aud_TankRRN |
|
integer
|
|
| divisionNumber |
|
integer
|
|
| customerNumber |
|
integer
|
|
| billTo |
|
integer
|
|
| name |
|
string
|
|
| address |
|
string
|
|
| address2 |
|
string
|
|
| city |
|
string
|
|
| state |
|
string
|
|
| zipcode |
|
string
|
|
| phone |
|
string
|
|
| creditLimit |
|
decimal number
|
|
| currentBalance |
|
decimal number
|
|
| _30DayBalance |
|
decimal number
|
|
| _60DayBalance |
|
decimal number
|
|
| _90DayBalance |
|
decimal number
|
|
| totalBalance |
|
decimal number
|
|
| lastPaymentAmount |
|
decimal number
|
|
| lastPaymentDate |
|
string
|
|
| alternateIdNumber |
|
string
|
|
| activeOrInactive |
|
string
|
|
| termsCode |
|
integer
|
|
| noOfBudgetPymntsMade |
|
integer
|
|
| noOfTimesBilled |
|
integer
|
|
| divisionNumber1 |
|
integer
|
|
| termsCode1 |
|
integer
|
|
| termsCodeDescription |
|
string
|
|
| aud_Name |
|
string
|
|
| v_totalBalForBillTo |
|
decimal number
|
|
| tnkTankRrn |
|
integer
|
|
| tnkDivisionNumber |
|
integer
|
|
| customerNumber1 |
|
integer
|
|
| tankSerialNumber |
|
string
|
|
| tnkTankTypeCode |
|
string
|
|
| businessOwnsTank |
|
string
|
|
| customerType |
|
integer
|
|
| tnkDeliveryType |
|
integer
|
|
| tankCapacity |
|
integer
|
|
| lastDeliveryDate |
|
string
|
|
| estimatedGallonsLeft |
|
decimal number
|
|
| estimatedPercentLeft |
|
integer
|
|
| route |
|
integer
|
|
| totalTanksCapacity |
|
integer
|
|
| truckNumber |
|
integer
|
|
| truckName |
|
string
|
|
| runNumber |
|
integer
|
|
| sequenceNumber |
|
integer
|
|
| scheduledDate |
|
string
|
|
| holdDate |
|
string
|
|
| holdReasonCode |
|
integer
|
|
| holdReleaseDate |
|
string
|
|
| address1 |
|
string
|
|
| city1 |
|
string
|
|
| state1 |
|
string
|
|
| locationCode |
|
integer
|
|
| actualGallonsDelivered |
|
decimal number
|
|
| directions |
|
string
|
|
| departmentNumber |
|
integer
|
|
| county |
|
integer
|
|
| township |
|
integer
|
|
| divisionNumber2 |
|
integer
|
|
| locationNumber |
|
integer
|
|
| locationName |
|
string
|
|
| divisionNumber3 |
|
integer
|
|
| validateLocationInTank |
|
string
|
|
| division |
|
integer
|
|
| tankRrn |
|
integer
|
|
| productId |
|
integer
|
|
| defaultProduct_T_F_ |
|
boolean
|
|
| priceCode |
|
integer
|
|
| tierPriceCode |
|
string
|
|
| dPTDivisionNumber |
|
integer
|
|
| dPTDepartmentNumber |
|
integer
|
|
| dPTDepartmentDescription |
|
string
|
|
| divisionNumber4 |
|
integer
|
|
| reasonCode |
|
integer
|
|
| reasonDescription |
|
string
|
|
| divisionNumber5 |
|
integer
|
|
| deliveryTypeCode |
|
integer
|
|
| deliveryTypeDescription |
|
string
|
|
| lQ_PayArr |
|
boolean
|
|
| divisionNumber6 |
|
integer
|
|
| customerNumber2 |
|
integer
|
|
| activeInactive |
|
string
|
|
| startDate |
|
string
|
|
| endDate |
|
string
|
|
| monthlyPaymentAmount |
|
decimal number
|
|
| comments |
|
string
|
|
| divisionNumber7 |
|
integer
|
|
| tankRrn1 |
|
integer
|
|
| specialInstructions |
|
string
|
|
| tankName |
|
string
|
|
| divisionNumber8 |
|
integer
|
|
| customerType1 |
|
integer
|
|
| customerTypeDescription |
|
string
|
|
| divisionNumber9 |
|
integer
|
|
| priceCode1 |
|
integer
|
|
| priceDescription |
|
string
|
|
| pricingTierA |
|
decimal number
|
|
| pricingTierB |
|
decimal number
|
|
| pricingTierC |
|
decimal number
|
|
| pricingTierD |
|
decimal number
|
|
| pricingTierE |
|
decimal number
|
|
| pricingTierF |
|
decimal number
|
|
| pricingTierG |
|
decimal number
|
|
| pricingTierH |
|
decimal number
|
|
| tankTypeCode |
|
string
|
|
| tankCapacity1 |
|
integer
|
|
| minimumOrderGallons |
|
integer
|
|
| deliveryPolicy |
|
string
|
|
| aud_Route |
|
integer
|
|
| aud_EstimatedPercent |
|
decimal number
|
|
| aud_EstimatedAmountToDeliver |
|
decimal number
|
|
| aud_MinimumDelivery |
|
decimal number
|
|
| aud_MinimumDollarDelivery |
|
decimal number
|
|
| aud_ScheduledDate |
|
string
|
|
| aud_ImmediateFill |
|
string
|
|
| aud_Comment |
|
string
|
|
| aud_CallInDate |
|
string
|
|
| aud_CallInTime |
|
string
|
|
| aud_EnteredBy |
|
string
|
|
| aud_TicketPrinted |
|
boolean
|
|
| lQ_History |
|
boolean
|
|
| divisionNumber10 |
|
integer
|
|
| customerNumber3 |
|
integer
|
|
| lQ_Tickler |
|
boolean
|
|
| ticklerDivision |
|
integer
|
|
| ticklerLocation |
|
integer
|
|
| ticklerCustomerNumber |
|
integer
|
|
| ticklerDateEntered |
|
string
|
|
| divisionNumber11 |
|
integer
|
|
| tankOrMeterRrn |
|
integer
|
|
| customerNo |
|
integer
|
|
| contractNo |
|
string
|
|
| beginningDate |
|
string
|
|
| divisionNumber12 |
|
integer
|
|
| contractNumber |
|
string
|
|
| customerNumber4 |
|
integer
|
|
| contractDate |
|
string
|
|
| endingContractDate |
|
string
|
|
| gallonsToBeDelivered |
|
decimal number
|
|
| totalGallonsContracted |
|
decimal number
|
|
| gallonsDelivered |
|
decimal number
|
|
| dollarsContracted |
|
decimal number
|
|
| dollarAmountDelivered |
|
decimal number
|
|
| contractPriceCode |
|
integer
|
|
| contractTierPriceCode |
|
string
|
|
| billType |
|
integer
|
|
| contractGasPrice |
|
decimal number
|
|
| lqContractGas |
|
boolean
|
|
| divisionNumber13divisionNumber13 |
|
integer
|
|
| billingType |
|
integer
|
|
| contractType |
|
string
|
|
| expiresOnEndingDate_ |
|
boolean
|
|
| energyAssistanceTaxExempt_ |
|
boolean
|
|
| divisionNumber14 |
|
integer
|
|
| priceCode2 |
|
integer
|
|
| pricingTierA1 |
|
decimal number
|
|
| pricingTierB1 |
|
decimal number
|
|
| pricingTierC1 |
|
decimal number
|
|
| pricingTierD1 |
|
decimal number
|
|
| pricingTierE1 |
|
decimal number
|
|
| pricingTierF1 |
|
decimal number
|
|
| pricingTierG1 |
|
decimal number
|
|
| pricingTierH1 |
|
decimal number
|
|
| price |
|
decimal number
|
|
| v_ContractPriceFromContract |
|
decimal number
|
|
| divisionNumber15 |
|
integer
|
|
| customerNumber5 |
|
integer
|
|
| contractNumber1 |
|
string
|
|
| centsDown |
|
decimal number
|
|
| prepaidBalance |
|
decimal number
|
|
| departmentPrepaid |
|
integer
|
|
| linkedRrn |
|
integer
|
|
| typeOfMessage |
|
integer
|
|
| rrn |
|
integer
|
|
| driverDateAck |
|
string
|
|
| tankType |
|
string
|
|
| bptSeq |
|
integer
|
|
| disableContractLink |
|
boolean
|
|
| dollarsLeft |
|
decimal number
|
|
| id |
|
integer
|
|