Billing Groups (Main Projects) Table Formats (BillingGroupsMain)

Follow Vision specifications for preparing a file containing billing groups (main projects).

Field Name Data Type Length Notes

MainWBS1

varchar Required. The main project number for this billing group. This must be a valid project number in Vision.

ConsolidatePrint

varchar Optional. Use this option to consolidate the printing for this billing group.

SeparateTerms

varchar Optional. Use this option to apply separate billing terms for projects in this group.

ConsolidatePost

varchar Optional. Use this option to consolidate the posting for this billing group.

OverallLimit

varchar Optional. Use this option to apply the overall limit for this billing group.

PrintAR

varchar Optional. G appears if you are printing outstanding invoices by group. P appears if you are printing outstanding invoices by project.

PrintBTD

varchar Optional. G appears if you are printing billings-to-date by group. P appears if you are printing billings-to-date by project.

PrintInterest

varchar Optional. G appears if you are printing interest by group. P appears if you are printing interest by project.

PrintTax

varchar Optional. G appears if you are printing taxes by group. P appears if you are printing taxes by project.

PrintRet

varchar Optional. G appears if you are printing retainage by group. P appears if you are printing retainage by project.