| Column Header Names | column letters | Required field? | Type, Length, Format | Table | Description |
|---|---|---|---|---|---|
| unit | A | Yes | |||
| reporterEmailAddress | B | Yes | |||
| acquisitionTypeCode | C | Yes | VARCHAR2(1) | CM_CPTLAST_T | |
| description | D | Yes | |||
| organizationOwnerChartOfAccountsCode | E | Yes | VARCHAR(2) | CM_CPTLAST_T | |
| organizationOwnerAccountNumber | F | Yes | VARCHAR(7) | CM_CPTLAST_T | |
| agencyNumber | G | VARCHAR2(5) | CM_CPTLAST_T | ||
| inventoryStatusCode | H | Yes | VARCHAR2(1) | CM_CPTLAST_T | |
| conditionCode | I | Yes | CM_CPTLAST_T | ||
| capitalAssetDescription | J | Yes | |||
| capitalAssetTypeCode | K | Yes | |||
| vendorName | L | ||||
| manufacturerName | M | ||||
| manufacturerModelNumber | N | ||||
| organizationText | O | ||||
| createDate | P | Yes | |||
| campusCode | Q | Yes | |||
| buildingCode | R | Yes | |||
| buildingRoomNumber | S | ||||
| locationQuantity | T | Yes | |||
| serialNumber | U | ||||
| organizationInventoryName | V | ||||
| organizationAssetTypeIdentifier | W | ||||
| governmentTagNumber | X | ||||
| campusTagNumber | Y | ||||
| nationalStockNumber | Z | ||||
| representativeUniversalIdentifier | AA | ||||
| chartOfAccountsCode | AB | Yes | |||
| accountNumber | AC | Yes | |||
| subAccountNumber | AD | ||||
| financialObjectCode | AE | Yes | |||
| financialSubObjectCode | AF | ||||
| projectCode | AG | ||||
| organizationReferenceId | AH | ||||
| expenditureFinancialSystemOriginationCode | AI | ||||
| expenditureFinancialDocumentNumber | AJ | ||||
| expenditureFinancialDocumentTypeCode | AK | ||||
| purchaseOrderNumber | AL | ||||
| requisitionNumber | AM | ||||
| expenditureFinancialDocumentPostedDate | AN | ||||
| postingPeriodCode | AO | ||||
| amount | AP | Yes | |||
| approvalMethod | AQ | ||||
| FiscalYear | AR |
Manage space
Manage content
Integrations