...
| 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) |
...