Employee Repayment Metadata

GET {{base_url}}/metadata/EREntry

Use this endpoint to retrieve the Employee Repayment metadata.

The metadata describes the fields in each table of the database for the record and describes whether or not the table is a custom table and whether or not it has a grid ID. Each field describes whether or not the field is required, the data type, the default value, whether or not it is updateable, and other useful minimums, limits, and maximum details.

For more information, see Metadata Reference.

HEADERS

The type of content supported by the API endpoint. | | Authorization | string | | Required.

The type of authorization supported by the API endpoint. |

RESPONSES

status: OK

{"erControl":{"Keys":"Batch","TableName":"erControl","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Recurring","FieldType":"Checkbox","Caption":"Recurring","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"2007-12-31T00:00:00.000","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Total","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SumTotal","FieldType":"Numeric","Caption":"File Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DiffTotal","FieldType":"Numeric","Caption":"Difference","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Selected","FieldType":"String","Caption":"Selected","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Posted","FieldType":"String","Caption":"Posted","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Creator","FieldType":"String","Caption":"Creator","DefaultValue":"ADMIN","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Period","FieldType":"Numeric","Caption":"Period","DefaultValue":"200712","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"[CURRENTCOMPANY]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14}],"Caption":"erControl"},"erMasterKey":{"Keys":"Batch,RefNo","TableName":"erMasterKey","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RefNo","FieldType":"Uppercase","Caption":"RefNo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":7},{"FieldName":"TransDate","FieldType":"String","Caption":"TransDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TransComment","FieldType":"String","Caption":"TransComment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StatusDesc","FieldType":"String","Caption":"StatusDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true}],"Caption":"erMasterKey"},"erMaster":{"Keys":"Batch,RefNo","TableName":"erMaster","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"RefNo","FieldType":"Uppercase","Caption":"Reference No","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":7},{"FieldName":"TransDate","FieldType":"Date","Caption":"Transaction Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"TransComment","FieldType":"String","Caption":"Comment","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":40},{"FieldName":"Posted","FieldType":"String","Caption":"Posted","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"CurrencyCode","FieldType":"String","Caption":"CurrencyCode","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StatusDescription","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AuthorizedByName","FieldType":"String","Caption":"Approved By","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AuthorizedBy","FieldType":"String","Caption":"AuthorizedBy","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RejectReason","FieldType":"String","Caption":"Reject Reason","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":500},{"FieldName":"ModUser","FieldType":"String","Caption":"ModUser","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUserEmployee","FieldType":"String","Caption":"ModUserEmployee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"ModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Diary","FieldType":"Dropdown","Caption":"Diary","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGDiaryAutoNum LEFT JOIN CFGDiary On CFGDiaryAutoNum.Code = CFGDiary.Code LEFT JOIN CFGDatesStatus On CFGDiaryAutoNum.Period = CFGDatesStatus.Period And CFGDiaryAutoNum.Company = CFGDatesStatus.Company LEFT JOIN (Select '0/'+CONVERT(varchar,Years) AS Pd, Years * 100 AS Period FROM (SELECT Distinct Period/100 AS Years FROM CFGDatesStatus WHERE Closed = 'N' and CFGDatesStatus.Company = /*N*/'PR') x) _OpenYear ON CFGDiaryAutoNum.Period = _OpenYear.Period","LimitToList":true},{"FieldName":"DiaryNo","FieldType":"Numeric","Caption":"Diary Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"erMaster"},"erDetail":{"Keys":"Batch,RefNo,PKey","TableName":"erDetail","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Batch","FieldType":"String","Caption":"Batch","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"RefNo","FieldType":"Uppercase","Caption":"RefNo","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":7},{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"BankCode","FieldType":"Dropdown","Caption":"Bank","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10,"CodeTable":"CFGBanks Inner Join CA On CFGBanks.Account = CA.Account","LimitToList":true},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"EmplName","FieldType":"String","Caption":"Employee Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Amount","FieldType":"Currency","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true}],"Caption":"erDetail"}}