Bill Table
| Column | Data type | Data type name | Length | Can be queried? | Can be updated? | Can be inserted? | Mandatory when inserting? | Format | Refers To | Version introduced in | Edition available in |
|---|---|---|---|---|---|---|---|---|---|---|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | 1.0 | US, CA, UK | |
| TimeCreated | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | 1.0 | US, CA, UK | |
| TimeModified | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | 1.0 | US, CA, UK | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | 1.0 | US, CA, UK | |
| TxnNumber | 4 | INTEGER | 9 | True | False | False | False | %11.0f | 1.0 | US, CA, UK | |
| VendorRef_ListID | 12 | VARCHAR | 36 | True | True | True | True | %s | ListID | 1.0 | US, CA, UK |
| VendorRef_FullName | 12 | VARCHAR | 41 | True | True | True | True | %s | Name | 1.0 | US, CA, UK |
| VendorAddress_Addr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| VendorAddress_Addr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| VendorAddress_Addr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| VendorAddress_Addr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | 2.0 | US, CA, UK | |
| VendorAddress_Addr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | 6.0 | US, CA, UK | |
| VendorAddress_City | 12 | VARCHAR | 31 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| VendorAddress_State | 12 | VARCHAR | 13 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| VendorAddress_PostalCode | 12 | VARCHAR | 36 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| APAccountRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 2.0 | US, CA, UK |
| APAccountRef_FullName | 12 | VARCHAR | 159 | True | True | True | False | %s | FullName | 2.0 | US, CA, UK |
| TxnDate | 91 | DATE | 10 | True | True | True | False | CCCC-MM-DD | 1.0 | US, CA, UK | |
| TxnDateMacro | 12 | VARCHAR | 25 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear |
1.0 | US, CA, UK | |
| DueDate | 9 | DATE | 91 | True | True | True | False | CCCC-MM-DD | 1.0 | US, CA, UK | |
| AmountDue | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 1.0 | US, CA, UK | |
| CurrencyRef_ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | ListID | 8.0 | US, CA, UK |
| CurrencyRef_FullName | 12 | VARCHAR | 64 | True | False | False | False | %s | Name | 8.0 | US, CA, UK |
| ExchangeRate | 2 | NUMERIC | 15 | True | True | True | False | %6.6f | 8.0 | US, CA, UK | |
| AmountDueInHomeCurrency | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 8.0 | US, CA, UK | |
| RefNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| TermsRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
| TermsRef_FullName | 12 | VARCHAR | 31 | True | True | True | False | %s | FullName | 1.0 | US, CA, UK |
| Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | 1.0 | US, CA, UK | |
| IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false |
1.0 | US, CA, UK | |
| ExternalGUID | 12 | VARCHAR | 40 | True | False | True | False | %s | 9.0 | US, CA, UK | |
| LinkToTxnID | 12 | VARCHAR | 36 | True | False | True | False | %s | 1.0 | US, CA, UK | |
| OpenAmount | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 1.0 | US, CA, UK |