| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_PCPOS | Procurement Card Statement: Position Data | 22 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | | |
2 | BBP_SUS_STG_ADR | Staging address table | 54 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | | |
3 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 55 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | | |
4 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 55 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | | |
5 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 62 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | | |
6 | PIQDB_NL_ADDR | Maintain GBA Address | 57 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPExcise Duty |
7 | /BEV2/CS_BP | EMCS Process: Partners | 7 | STREET_NO | EMCS: House Number | nvarchar | 12 | 0 | | |
8 | /BEV2/CS_BP_H | EMCS Process: Partners - History | 8 | STREET_NO | EMCS: House Number | nvarchar | 12 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
9 | DFMCA_TF_WHT_L | Line Item Table of Withholding Tax | 21 | STREET_NO | House Number | nvarchar | 10 | 0 | | |