...
| 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 | VARCHAR2(1) | CM_CPTLAST_DTL_T | |||
| 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(12) | CM_AST_PMT_DTL_T | |||
| accountNumber | AC | Yes | VARCHAR2(17) | CM_AST_PMT_DTL_T | |||
| subAccountNumber | AD | VARCHAR2(15) | CM_AST_PMT_DTL_T | ||||
| financialObjectCode | AE | Yes | VARCHAR2(14) | CM_AST_PMT_DTL_T | |||
| financialSubObjectCode | AF | VARCHAR2(13) | CM_AST_PMT_DTL_T | ||||
| projectCode | AG | VARCHAR2(110) | CM_AST_PMT_DTL_T | ||||
| organizationReferenceId | AH | VARCHAR2(18) | CM_AST_PMT_DTL_T | ||||
| expenditureFinancialSystemOriginationCode | AI | VARCHAR2(12) | CM_AST_PMT_DTL_T | ||||
| expenditureFinancialDocumentNumber | AJ | VARCHAR2(114) | CM_AST_PMT_DTL_T | ||||
| expenditureFinancialDocumentTypeCode | AK | VARCHAR2(14) | CM_AST_PMT_DTL_T | ||||
| purchaseOrderNumber | AL | VARCHAR2(19) | CM_AST_PMT_DTL_T | ||||
| requisitionNumber | AM | VARCHAR2(18) | CM_AST_PMT_DTL_T | ||||
| expenditureFinancialDocumentPostedDate | AN | DATE | CM_AST_PMT_DTL_T | mm/dd/yyyy | |||
| postingPeriodCode | AO | VARCHAR2(12) | CM_AST_PMT_DTL_T | ||||
| amount | AP | Yes | NUMBER(19,2) | CM_AST_PMT_DTL_T | |||
| approvalMethod | AQ | VARCHAR2(1) | |||||
| FiscalYear | AR | VARCHAR2(14) |