Asset Global .csv File Format
- Kathleen Avery (Deactivated)
Owned by Kathleen Avery (Deactivated)
| 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 | VARCHAR2(1) | CM_CPTLAST_T | |
| capitalAssetDescription | J | Yes | VARCHAR2(4000) | CM_CPTLAST_T | |
| capitalAssetTypeCode | K | Yes | VARCHAR2(1) | CM_CPTLAST_T | |
| vendorName | L | ||||
| manufacturerName | M | VARCHAR2(45) | CM_CPTLAST_T | ||
| manufacturerModelNumber | N | VARCHAR2(25) | CM_CPTLAST_T | ||
| organizationText | O | VARCHAR2(255) | CM_CPTLAST_DTL_T | ||
| createDate | P | Yes | DATE | CM_CPTLAST_T | mm/dd/yyyy |
| campusCode | Q | Yes | VARCHAR2(2) | CM_CPTLAST_DTL_T | |
| buildingCode | R | Yes | VARCHAR2(30) | CM_CPTLAST_DTL_T | |
| buildingRoomNumber | S | VARCHAR2(30) | CM_CPTLAST_DTL_T | ||
| locationQuantity | T | Yes | |||
| serialNumber | U | VARCHAR2(25) | CM_CPTLAST_DTL_T | ||
| organizationInventoryName | V | VARCHAR2(40) | CM_CPTLAST_DTL_T | ||
| organizationAssetTypeIdentifier | W | VARCHAR2(20) | CM_CPTLAST_DTL_T | ||
| governmentTagNumber | X | VARCHAR2(12) | CM_CPTLAST_DTL_T | ||
| campusTagNumber | Y | VARCHAR2(8) | CM_CPTLAST_DTL_T | ||
| nationalStockNumber | Z | VARCHAR2(25) | CM_CPTLAST_DTL_T | ||
| representativeUniversalIdentifier | AA | VARCHAR2(40) | CM_CPTLAST_DTL_T | ||
| chartOfAccountsCode | AB | Yes | VARCHAR2(2) | CM_AST_PMT_DTL_T | |
| accountNumber | AC | Yes | VARCHAR2(7) | CM_AST_PMT_DTL_T | |
| subAccountNumber | AD | VARCHAR2(5) | CM_AST_PMT_DTL_T | ||
| financialObjectCode | AE | Yes | VARCHAR2(4) | CM_AST_PMT_DTL_T | |
| financialSubObjectCode | AF | VARCHAR2(3) | CM_AST_PMT_DTL_T | ||
| projectCode | AG | VARCHAR2(10) | CM_AST_PMT_DTL_T | ||
| organizationReferenceId | AH | VARCHAR2(8) | CM_AST_PMT_DTL_T | ||
| expenditureFinancialSystemOriginationCode | AI | VARCHAR2(2) | CM_AST_PMT_DTL_T | ||
| expenditureFinancialDocumentNumber | AJ | VARCHAR2(14) | CM_AST_PMT_DTL_T | ||
| expenditureFinancialDocumentTypeCode | AK | VARCHAR2(4) | CM_AST_PMT_DTL_T | ||
| purchaseOrderNumber | AL | VARCHAR2(9) | CM_AST_PMT_DTL_T | ||
| requisitionNumber | AM | VARCHAR2(8) | CM_AST_PMT_DTL_T | ||
| expenditureFinancialDocumentPostedDate | AN | DATE | CM_AST_PMT_DTL_T | mm/dd/yyyy | |
| postingPeriodCode | AO | VARCHAR2(2) | CM_AST_PMT_DTL_T | ||
| amount | AP | Yes | NUMBER(19,2) | CM_AST_PMT_DTL_T | |
| approvalMethod | AQ | ||||
| FiscalYear | AR | VARCHAR2(4) |