# ProjectInvoiceProposalDefaults: ionBIZ Project Invoice Proposal Defaults - Catalog: `ionBIZ` - Label: Project Invoice Proposal Defaults - Retrieve: true ## Table Columns The columns of the table `ProjectInvoiceProposalDefaults` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AmountToInvoice` | `decimal` | Amount to Invoice | ☐ | | | `AmountToInvoiceExclPostponed` | `decimal` | Amount To Invoice Excl. Postponed | ☐ | | | `ApprovalComment` | `int32` | Approval Comment | ☐ | | | `CoId` | `int32` | CO ID | ☐ | | | `CompanyAddressId` | `int32` | Company Address ID | ☐ | | | `CuId` | `int32` | CU ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CustomerId` | `int32` | Customer ID | ☐ | | | `ExtraCompanyAddress` | `boolean` | Extra Company Address | ☐ | | | `ExtraCustomer` | `boolean` | Extra Customer | ☐ | | | `HighestApprovalLevel` | `int32` | Highest Approval Level | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☐ | | | `IntercompanyCompId` | `int32` | Intercompany Company ID | ☐ | | | `IntercompanyCuId` | `int32` | Intercompany CU ID | ☐ | | | `InvoiceScheduleId` | `string` | Invoice Schedule ID | ☐ | | | `MaxDate` | `datetimeoffset` | Max Date | ☐ | | | `MinDate` | `datetimeoffset` | Min Date | ☐ | | | `OnlyApprovalLevel` | `int32` | Only Approval Level | ☐ | | | `OriginalCompanyAddressId` | `int32` | Original Company Address ID | ☐ | | | `OriginalCustomerId` | `int32` | Original Customer ID | ☐ | | | `PrId` | `int32` | PR ID | ☐ | | | `ProjectHeaderId` | `int32` | Project Header ID | ☐ | | | `ProposalId` | `int32` | Proposal ID | ☐ | | | `SchId` | `int32` | Schedule ID | ☐ | | | `SeparateProposal` | `boolean` | Separate Proposal | ☐ | | | `Status_0` | `int32` | Status 0 | ☐ | | | `Status_1` | `int32` | Status 1 | ☐ | | | `Status_2` | `int32` | Status 2 | ☐ | | | `Status_3` | `int32` | Status 3 | ☐ | | | `Status_4` | `int32` | Status 4 | ☐ | | | `Status_5` | `int32` | Status 5 | ☐ | | | `Status_6` | `int32` | Status 6 | ☐ | | | `Status_7` | `int32` | Status 7 | ☐ | | | `Status_8` | `int32` | Status 8 | ☐ | | | `Status_9` | `int32` | Status 9 | ☐ | |