LM_BO_COUNTERS(SQL Table) |
Index Back |
|---|---|
Biz Objects Counterscounters for Business Objects |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_JOBCODE_ID | Number(15,0) | DECIMAL(15) NOT NULL | JobCode ID |
| 3 | LM_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Vendor ID |
| 4 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 5 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 6 | LM_VENDOR_PROD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Vendor Product ID |
| 7 | LM_CRITERIA_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learner Group Criteria ID |
| 8 | LM_SUBLEDGER_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Sub-Ledger ID. System Generated.
Default Value: 0 |
| 9 | LM_SUBLEDGR_LN_NUM | Number(20,0) | DECIMAL(20) NOT NULL |
Subledger Line Number
Default Value: 0 |
| 10 | LM_LOCATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Location Id |